Page 1 of 1

Second Table created from CSV File is Empty!!

Posted: 2020-09-15 19:25
by mohamed
Hello,

I am using AppGini v5.8 ...

I have successfully created and imported the first table from a CSV file, and the page generated successfully with all data.

The problem, that when I edited the same Project and imported the 2nd table from another CSV file, then generated the Project, I was able to connect to the page, but AppGini did NOT prompt me to upload/retrieve the file, so I could not retrieve or Upload data from the second CSV file,
so when I loaded the page the 2nd table was empty, it has no records!!

How to load/import the data to the 2nd table from the 2nd CSV file ?


Thanks in advance ..

Re: Second Table created from CSV File is Empty!!

Posted: 2020-09-17 06:08
by tchandra
Go to admin menu - Utilities - Import CSV data

Re: Second Table created from CSV File is Empty!!

Posted: 2020-09-17 06:40
by mohamed
TChandra,
Thank you ..

I have found and tried this option (Import CSV data) after sending my query, but I noticed its limited to import 7 columns (fields) only!
and AppGini has the same limitation of maximum 7 columns when I try to import from CSV file, using either
File --> Import --> Table from CSV File
OR
Tables --> New Table form CSV File

Regards

Re: Second Table created from CSV File is Empty!!

Posted: 2020-09-17 07:39
by tchandra
can you share a few lines of your csv file here?
When you import from Admin menu - Import CSV data, Did you matched he headers of the table with your csv. (Belongs To)
is there any error message?
what is the delimiter of your csv file?

Re: Second Table created from CSV File is Empty!!

Posted: 2020-09-17 08:33
by mohamed
Thank you again TChandra for getting back, and for the hints about the headers

now it works fine and I am to import the all 12 columns, after doing the following changes to the headers:

1. Remove slashes "/" from the title/hear of each column

2. replace the spaces with underscore "_"