Hello,
I have a question when I import CSV files, all is OK and datas are in my database (verification with PHP MYADMIN)
When I use the appgini application, datas are invisible for the lookup fields...
I think it's because values of lookup fields are Integer.
How to do the impot correctly please ?
Thanks !
Problem import CSV and lookup fields
Re: Problem import CSV and lookup fields
Yes, you are correct.
The lookup field in the table being imported into will need to be an integer rather than the text value.
You will need to match the corresponding parent table primary key integer ID value of each lookup field/row to be imported.
It depends on what and how much data you have to import but with some basic knowledge of how to use a spreadsheet, you can do that relatively easily in the CSV prior to import. If only a few, just use find/replace. For a lot of edits you can set up a template and use the vlookup (or the new xlookup) function to get the values. There are other ways to go about it (custom scripts, SQL after import) but it really depends on what's in the CSV import you are provided with. Generally speaking, Excel or similar will do the job for you.
The lookup field in the table being imported into will need to be an integer rather than the text value.
You will need to match the corresponding parent table primary key integer ID value of each lookup field/row to be imported.
It depends on what and how much data you have to import but with some basic knowledge of how to use a spreadsheet, you can do that relatively easily in the CSV prior to import. If only a few, just use find/replace. For a lot of edits you can set up a template and use the vlookup (or the new xlookup) function to get the values. There are other ways to go about it (custom scripts, SQL after import) but it really depends on what's in the CSV import you are provided with. Generally speaking, Excel or similar will do the job for you.