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.

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

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.

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

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

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

was the issue resolved?
what was the solution?

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