You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Excel to CI issue

8 replies [Last post]
Guest's picture
Guest

Hi Compshack,

I am facing a problem while loading data into a component, as one of the fields(COMMENTS) appears to be of LONG datatype. When I pass values for this field, it throws an error after submission of data stating "Cannot find value (91.32) ".

I tried trimming the data and even passing blank value for this field, but it still gave the error. But the error doesn't come when the field has been deselected from the template

Is there anything that needs to be done for passing data into a LONG field?

Please offer your valuable suggestions on this

Thanks,
Danny

Lepa's picture
User offline. Last seen 1 year 31 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Excel to CI issue

Quote:
Is there anything that needs to be done for passing data into a LONG field?

Not that I know off. I know there is a problem with long fields and that is ExcelToCI only takes the first 1024 characters and no more. There is a fix for that but it doesn't sound like this is the issue you are having. It should be something with the way you are building your template.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

oddsnends's picture
User offline. Last seen 10 years 31 weeks ago. Offline
Joined: 03/28/2008
Posts: 16
Re: Excel to CI issue

I too had an issue with the long field. I finally just used ExcelToCI without the field and went back and updated the values via SQL script (created by reading the data keys and comment in an sqr program to create the SQL Script) after the load.

I know - why have a SQR create a SQL script rather than just do the insert within the SQR ... Because getting a sqr to the production database and creating all the online objects to execute it are not worth the effort. Instead I can run the SQR in a non production environment by giving the SQR the name of another that already exists with online objects and no run parameters required. I execute the sqr and pass the SQL script it created to the DBA for an update.

Lepa - you mention there is a fix for this? Could you share that?

Thanks

Lepa's picture
User offline. Last seen 1 year 31 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Excel to CI issue

Quote:
Lepa - you mention there is a fix for this? Could you share that?

I don't have a fix for the original problem but do have one for the 1024 character issue. I can post it here when I get to my work PC tomorrow if that's what you want.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Ashar's picture
User offline. Last seen 4 years 13 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Excel to CI issue

Is it solved yet?
Ru using SQLExec in PC to update the data? If so, please take a look at PeopleBooks on %TextIn.

shruti bansal's picture
shruti bansal (not verified)
Re: Excel to CI issue

While creating ExceltoCI for acadmeic institution table I had entered value for Description say Indian Institute of Technology corresponding to Institution IIT , on submitting data it is saying value not found.
for description field there r neither transalts values nor prompt table

shruti bansal's picture
shruti bansal (not verified)
Re: Excel to CI issue

While creating ExceltoCI for acadmeic institution table I had entered value for Description say Indian Institute of Technology corresponding to Institution IIT , on submitting data it is saying value not found

Guest's picture
Guest
Re: Excel to CI issue

was the issue resolved?
what was the solution?

Guest's picture
Guest
Re: Excel to CI issue

Please the provide steps to over come excel to ci long descr field issue