I tried to Create a table by importing data from data source . My Excel file is 19.7 MB. In the "Select an Excel or CSV file" page, it states "Maximum upload file size: 8 MB."
I used the "Add From Server" plugin and imported an Excel file with 18.8 MB. However, I got the error "There was an error while trying to generate the table". The excel file has ~500,000 rows and 6 columns.
I used the "Add From Server" plugin and imported an Excel file with 785 KB (~170,000 rows and 6 columns) without any problems.
When you import data from file there is memory limit on server that cause this. My suggestion is to import that files directly on database and then make tables from sql query.
You can convert that excel files to csv file (because you can't import excel file directly ) and then import that file throw phpmyadmin to the database. When you finished that you will have table in database which you can use to make wpdatatables over the MySQL query.
Got "Invalid column count in CSV input on line 1. I used this CSV file to create a table successfully using "Create a table by importing data from data source ." in the Create a Table manual.
If you can make table form excel file using option Create a table by importing data from data source you don't have to do this. If you can't than you need to convert that file In CSV format with coma separated value and import in phpmyadmin in new table not existing one.
In Phpmyadmin:
Select database you want to import table into.
Click import tab.
Select your file. Set FORMAT to CSV
Leave Format-Specific Options alone except for ticking the "The first line of the file contains the table column names" box because of that first row mysql will make column headers
Click GO
You then need to rename the table ( which will be called somthing like "TABLE 5" if its the 5th table in the DB). So select the table and using the Operations tab -> "Rename table to:" and change it to TABLE_5.
Then go in wpdatatables and make table using mysql query
I got the following error when I import the attached csv file.
Error
Static analysis:
3 errors were found during analysis.
A symbol name was expected! A reserved keyword can not be used as a column name without backquotes. (near "varchar" at position 244)
Unexpected beginning of statement. (near "10" at position 252)
Unrecognized statement type. (near "DEFAULT CHARACTER SET" at position 257)
SQL query:
CREATE TABLE IF NOT EXISTS `u221116913_abyzy`.`TABLE 23` (`Contributor` varchar(29), `Internal ID` varchar(11), `Title` varchar(53), `Publisher` varchar(50), `Game Platform` varchar(29), `Date Published` varchar(4), `Content Type` varchar(8), varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
When you import csv file in phpmyadmin he make table in database for example TABLE 1.
You then need to rename the table ( which will be called something like "TABLE 1" if its the 1th table in the DB). So select the table and using the Operations tab -> "Rename table to:" and change it to TABLE_1.
Then go in wpdatatables and make table from MySQL query like this:
SELECT * FROM TABLE_1
Can you please tell we when you get this error? When you insert csv file in database?
1. I renamed the new table as ""ffhc_wpdatatable_12" (make it consistent with our tables created by wpDataTable)
2. In wpDataTables, choose "Generate a query to MySQL database.", there is no place to input "SELECT * FROM TABLE_1" as recommended. Instead, it allow me to choose which table I want to work on. I choose ffhc_wpdatatable_12
3. I selected everything in the "All MySQL columns" and click NEXT,
4. I got the following (see attached file)
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ';, ffhc_wpdatatable_12.Content Type FROM ffhc_wpdatatable_12 LIMIT 5' at line 7
Using the file I created with ~500,000 rows and format you recommended,
1, I choose the IMPORT function; choose my file, upload seems successful, then system prompt "Please be patient, the file is being uploaded. Details about the upload are not available "Waiting for auth-db148.hostinger.com", for ~2 min, i got "504 Gateway Time-out"
It's not recommended to change table name like ffhc_wpdatatable_12 because when you make manual tables wpdatatables plugin make tables in database starting from 1.(ffhc_wpdatatable_1,ffhc_wpdatatable_2...) So if you have already that table in database can be overwritten.
You get this error because of this line,(attachment) because is not selected column from database or that column don't have header name. Can you please check in database is this column have header name or is empty?
You can also make tables from first option Creating tables linked to existing data source and choose MySQL query and then insert query SELECT * FROM table_name. You can take a look in our documentation about this on this link.
Can you please open Inspect element->Console of the browser and then try to make table and when you receive that error please take a screenshot of the hole window so we can take a look?
When the time 504 Gateway Timeout message appear, the console became blank (see attached). When I backward the browser, I got the message in the console (see attached).
So you are getting this error when try to insert table in database throw phpmyadmin? You have to increase execute limit time, memory limit .... On this link you can see some solutions.
I tried to Create a table by importing data from data source . My Excel file is 19.7 MB. In the "Select an Excel or CSV file" page, it states "Maximum upload file size: 8 MB."
What can I do to upload my 19.7 MB file.
Hi pchan3,
Thank you for your purchase.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
You have to increase maximum upload file size in wordpress. On this link you can see how to do that.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
No problem.
I used the "Add From Server" plugin and imported an Excel file with 18.8 MB. However, I got the error "There was an error while trying to generate the table". The excel file has ~500,000 rows and 6 columns.
I used the "Add From Server" plugin and imported an Excel file with 785 KB (~170,000 rows and 6 columns) without any problems.
Hi pchan3,
When you import data from file there is memory limit on server that cause this. My suggestion is to import that files directly on database and then make tables from sql query.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
How can "import that files directly on database"?
The options available are
1. Create a table linked to an existing data source
2. Create a table manually
3. Create a table by importing data from data source (what I used and encountered error)
Hi pchan3,
You can convert that excel files to csv file (because you can't import excel file directly ) and then import that file throw phpmyadmin to the database. When you finished that you will have table in database which you can use to make wpdatatables over the MySQL query.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Could you please give me more detail steps on how to do that?
My steps so far are as follows:
1. goto phpAdmin
2. choose ffhc_wpdatatables
3. click Import
4. choose my csv file and GO
Got "Invalid column count in CSV input on line 1. I used this CSV file to create a table successfully using "Create a table by importing data from data source ." in the Create a Table manual.
I have made another attempt:
1. Separate my CSV file to 2 files: first one contain first row only - column headings and the second contain the remaining rows.
2. Use "Create a table by importing data from data source" using the first file in 1 above
3. goto phpAdmin
4. choose ffhc_wpdatatable_8 (the table created in 2 above)
5. click Import and choose my csv file (second file in 1 above and GO
6. Got " Invalid column count in CSV input on line 313."
Hi pchan3,
If you can make table form excel file using option Create a table by importing data from data source you don't have to do this. If you can't than you need to convert that file In CSV format with coma separated value and import in phpmyadmin in new table not existing one.
In Phpmyadmin:
SELECT * FORM TABLE_5 and you will get your table
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I got the following error when I import the attached csv file.
Error
Static analysis:
3 errors were found during analysis.
SQL query:
CREATE TABLE IF NOT EXISTS `u221116913_abyzy`.`TABLE 23` (`Contributor` varchar(29), `Internal ID` varchar(11), `Title` varchar(53), `Publisher` varchar(50), `Game Platform` varchar(29), `Date Published` varchar(4), `Content Type` varchar(8), varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1Hi pchan3,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
You file was not good configured. Can you please try with this one?(attachment)
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thanks, Milan. Your file works. However, I can't see the table in Worpress wpDataTables. What should I do next?
Also, when I try to import a table with 200,00 rows, I got
504 Gateway Time-out.
Any advise?
Hi pchan3,
When you import csv file in phpmyadmin he make table in database for example TABLE 1.
You then need to rename the table ( which will be called something like "TABLE 1" if its the 1th table in the DB). So select the table and using the Operations tab -> "Rename table to:" and change it to TABLE_1.
Then go in wpdatatables and make table from MySQL query like this:
SELECT * FROM TABLE_1
Can you please tell we when you get this error? When you insert csv file in database?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Using the file you sent me:
1. I renamed the new table as ""ffhc_wpdatatable_12" (make it consistent with our tables created by wpDataTable)
2. In wpDataTables, choose "Generate a query to MySQL database.", there is no place to input "SELECT * FROM TABLE_1" as recommended. Instead, it allow me to choose which table I want to work on. I choose ffhc_wpdatatable_12
3. I selected everything in the "All MySQL columns" and click NEXT,
4. I got the following (see attached file)
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable.
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ';, ffhc_wpdatatable_12.Content Type FROM ffhc_wpdatatable_12 LIMIT 5' at line 7
Using the file I created with ~500,000 rows and format you recommended,
1, I choose the IMPORT function; choose my file, upload seems successful, then system prompt "Please be patient, the file is being uploaded. Details about the upload are not available "Waiting for auth-db148.hostinger.com", for ~2 min, i got "504 Gateway Time-out"
Hi pchan3,
It's not recommended to change table name like ffhc_wpdatatable_12 because when you make manual tables wpdatatables plugin make tables in database starting from 1.(ffhc_wpdatatable_1,ffhc_wpdatatable_2...) So if you have already that table in database can be overwritten.
You get this error because of this line,(attachment) because is not selected column from database or that column don't have header name. Can you please check in database is this column have header name or is empty?
You can also make tables from first option Creating tables linked to existing data source and choose MySQL query and then insert query SELECT * FROM table_name. You can take a look in our documentation about this on this link.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I can use option 1 to create the table. One minor issue is that I have to delete the last column which contains ";" in the file you provide.
I really appreciate your help.
Now, I can create table from MySQL. I need to resolve the "504 Gateway Time-out" issue so that I can create the 500,000 rows table I need.
Hi pchan3,
Can you please open Inspect element->Console of the browser and then try to make table and when you receive that error please take a screenshot of the hole window so we can take a look?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
When the time 504 Gateway Timeout message appear, the console became blank (see attached). When I backward the browser, I got the message in the console (see attached).
Hi pchan3,
So you are getting this error when try to insert table in database throw phpmyadmin? You have to increase execute limit time, memory limit .... On this link you can see some solutions.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables