|
Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192,
Visits: 5,220
|
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.
|
|
Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192,
Visits: 5,220
|
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.
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
Yes, I recall this is something to do with drivers and how they handle joins.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|