There was an error while trying to save the table!parsererror The column headers in your file do not match those in existing table. Please check your source file and try again.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I used Google Translate for some parts of your message, so i apologise if anything got 'lost in translation'.
1. If i understood, you are trying to update an existing Manual Table by uploading your updated Excel file, right?
2. And you pick the option "Add rows to the current table data" ?
If you pick this option, you must not rearange any Column order from your source Excel, and you must not add/remove any Columns or change Header Names.
When you choose to only add new Rows -
When you click “Save Changes”, a popup window will be shown with an explanation of what will happen next, as you can see in the image below.
As you can see, with this option you’re about to add data from the source file to the existing manual table.
If you have any date-type columns in your file, please make sure that you match the date input format in the Main settings of the plugin to the one you’re using in your source file first.
If they are different, some data may not be added correctly.
Due to everything mentioned above, our advice is to duplicate your table first before updating, because there is no undo option.
Please note that for this option in the source file you will need to have:
The same number of columns
The same names of column headers
Data (empty file is not allowed)
So please do not rearange the Columns/rename the Headers, or add/remove Columns for that option.
You can see more details explained here how this Feature works :
3. If you have to rearange or add/remove/rename Header on some Columns on this Table data, and wish to upload an updated file, you can choose a different option :
Replace entire table with source.
With this option - you can do anything you wish with the Source data Structure, like re-order Columns/rename Headers, or add/remove columns and it will work.
But again, we still advise making a duplicate from the original Table, just to have a copy for safety.
既存テーブルにインポートする時、以下のエラーが出ます。
There was an error while trying to save the table!parsererror
The column headers in your file do not match those in existing table. Please check your source file and try again.
しかし、ヘッダーは同一です。
私は、エラーが出る前に以下の行動をしています。
・列の追加
・列の並び替え
以上の行動に併せてインポート元のデータも並び替えたりすれば解決しますか？
色々やってますが必ずエラーが出ます。
現状はエラーが怖くて列の追加を諦めています。
詳細な回答を期待しています。
Hi fei,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I used Google Translate for some parts of your message, so i apologise if anything got 'lost in translation'.
1. If i understood, you are trying to update an existing Manual Table by uploading your updated Excel file, right?
2. And you pick the option "Add rows to the current table data" ?
If you pick this option, you must not rearange any Column order from your source Excel, and you must not add/remove any Columns or change Header Names.
When you choose to only add new Rows -
When you click “Save Changes”, a popup window will be shown with an explanation of what will happen next, as you can see in the image below.
As you can see, with this option you’re about to add data from the source file to the existing manual table.
If you have any date-type columns in your file, please make sure that you match the date input format in the Main settings of the plugin to the one you’re using in your source file first.
If they are different, some data may not be added correctly.
Due to everything mentioned above, our advice is to duplicate your table first before updating, because there is no undo option.
Please note that for this option in the source file you will need to have:
So please do not rearange the Columns/rename the Headers, or add/remove Columns for that option.
You can see more details explained here how this Feature works :
https://wpdatatables.com/documentation/table-features/update-manual-tables-from-source-files-csv-excel-or-google-sheet/.
3. If you have to rearange or add/remove/rename Header on some Columns on this Table data, and wish to upload an updated file, you can choose a different option :
Replace entire table with source.
With this option - you can do anything you wish with the Source data Structure, like re-order Columns/rename Headers, or add/remove columns and it will work.
But again, we still advise making a duplicate from the original Table, just to have a copy for safety.
Let me know if that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables