Trust ID PBCEX logo 300x102

CSV file as database

5 years 1 month ago
Robo
Fresh Boarder
Fresh Boarder
Posts: 2
More
Topic Author
CSV file as database #4842
We have been using CSV files as our database for the last few years without any problems. We have now "modified" the field data and some columns are no longer visible in Card Exchange. The data affected appears to be the serial number columns which now contains alphanumeric characters in addition the numeric characters. Any column with eg A001-A123 is not affected but columns with eg 10023 and hk1256 are not visible. From Excel the data is visible and the numeric fields are right formatted with the alphanumeric left formatted. A workaround to this was to use Excel to format the whole file *csv file as 'text' and save as an *.xlsw file. This has proved successful.

Is there any way to not have to use this workaround and still use the *csv file?
5 years 1 month ago
Sergio Agostinho
Administrator
Administrator
Posts: 508
More
CSV file as database #4843
Hi Robo,

You need to specify the structure of that csv file, please take a look on this link

With best regards
Sergio Agostinho
The following user(s) said Thank You Robo
×

Notice

The forum is in read only mode.