Data Tool file import V2.5040 limits field P_Desc1 to 255 Characters


https://forum.kartris.com/Topic2469.aspx
Print Topic | Close Window

By Neil - Wed 16 Oct 2013
Hi, as per post title, the datatool seems to only populate the database using the first 255 characters in the P_Desc1 field when importing from a file (have not tested other fields). We have a field length of up to 1700 characters.

This appears to be the case for both CSV and XLS files.

We think this might be some sort of driver problem as we had a similar thing happen when we were exporting from access to excel.



By Neil - Wed 16 Oct 2013
OK just tried this again on my production server and it worked fine. I can only think it had something to do settings/drivers on the local machine I was using.
By Paul - Wed 16 Oct 2013
Yes, I recall this is something to do with drivers and how they handle joins.