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.
|