When I upload an excel spreadsheet in order to create a Table, the data ends up being incorrect.
The spreadsheet has seven columns. One is an text column, which I imported as a one line string, and the other six are formatted as numbers, which I imported as Integer. I can send you this spreadsheet if that helps (I'm not able to upload a spreadsheet as an attachment to this ticket)
When I select the file, the first screen shows a data preview which seems to indicate it is importing correctly. I've attached a screenshot of "Table Import Screenshot"
However, when I actually create the Table, the data all ends up being incorrect. In fact there is no apparent relation between the numbers in the actual spreadsheet, and the numbers that show in the end result in WPData Tables.
Please advise how I can correct this so I can make import this spreadsheet as a proper data table.
Can you please share that file with me, so I can take a look? You can zip it, and attach it to your response. If you have some confidential data in it, please check the "Private" response so it is not visible to public.
I used your file and created the table without issues (see attachment).
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Sorry about that, I was looking at Equity column for comparison, and it had correct values in the first few rows.
The issue with your file is that you had mixed formatting in columns. For example:
Combination of strings and integers can confuse the plugin, since it expects a certain column type, and when the format changes, it tries to apply the same logic, but fails. That's why you're getting wrong data.
Please try creating a table from the attached file. It has the same values, but I just pasted them without any formatting applied. When I compared the data, they are all the same:
If you need the $ sign in the columns, you can simply add it as a prefix through column settings:
It still imports the wrong data. I imported the exact spreadsheet you attached. The screenshot shows the result. Note for example the equity column shows a repeating number that is unrelated to what was in the original spreadsheet.
Note it seems to think the "Derivatives/Insurance Linked Securities is a one line string column (I changed to integer before importing)
In my screenshot it worked because I was linking to the Excel file, not importing it. The import will not work with numbers this big because the int in MySQL is 4 bytes long so the maximum values are -2147483648 and 2147483647. You can see in your table that numbers below 2147483648 are inserted correctly, and this is not an issue with wpDataTables, but instead the database. Well, technically it is linked to wpDataTables as well, because we're telling the code to insert the data as INT, not BIGINT.
Can you get me access to the original file, class.constructor.php so I can put it in there again? Alternatively, your login for my site is still good for another few hours. Thanks again for your help.
Also note: I have not yet attempted to edit existing tables.
Have you deactivated wpDataTables when you made the change? Perhaps that's what broke it.
Anyway, I copied and pasted the entire file, along with the BIGINT type, and I was able to import the table with correct values. Please take a look at wpdatatable id=36 and you should see correct values.
When I upload an excel spreadsheet in order to create a Table, the data ends up being incorrect.
The spreadsheet has seven columns. One is an text column, which I imported as a one line string, and the other six are formatted as numbers, which I imported as Integer. I can send you this spreadsheet if that helps (I'm not able to upload a spreadsheet as an attachment to this ticket)
When I select the file, the first screen shows a data preview which seems to indicate it is importing correctly. I've attached a screenshot of "Table Import Screenshot"
However, when I actually create the Table, the data all ends up being incorrect. In fact there is no apparent relation between the numbers in the actual spreadsheet, and the numbers that show in the end result in WPData Tables.
Please advise how I can correct this so I can make import this spreadsheet as a proper data table.
Hello JACOB
Thank you for your purchase.
Can you please share that file with me, so I can take a look? You can zip it, and attach it to your response. If you have some confidential data in it, please check the "Private" response so it is not visible to public.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
Hi again JACOB
I used your file and created the table without issues (see attachment).
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
Any update on this?
Hi again Jacob.
Sorry about that, I was looking at Equity column for comparison, and it had correct values in the first few rows.
The issue with your file is that you had mixed formatting in columns. For example:
Combination of strings and integers can confuse the plugin, since it expects a certain column type, and when the format changes, it tries to apply the same logic, but fails. That's why you're getting wrong data.
Please try creating a table from the attached file. It has the same values, but I just pasted them without any formatting applied. When I compared the data, they are all the same:
If you need the $ sign in the columns, you can simply add it as a prefix through column settings:
So it looks like this:
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
Here's the file.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
It still imports the wrong data. I imported the exact spreadsheet you attached. The screenshot shows the result. Note for example the equity column shows a repeating number that is unrelated to what was in the original spreadsheet.
Note it seems to think the "Derivatives/Insurance Linked Securities is a one line string column (I changed to integer before importing)
Hello again Jacob.
In my screenshot it worked because I was linking to the Excel file, not importing it. The import will not work with numbers this big because the int in MySQL is 4 bytes long so the maximum values are -2147483648 and 2147483647. You can see in your table that numbers below 2147483648 are inserted correctly, and this is not an issue with wpDataTables, but instead the database. Well, technically it is linked to wpDataTables as well, because we're telling the code to insert the data as INT, not BIGINT.
You can take a look at the limits here.
Here's what you can do:
Go to ../wp-content/plugins/wpdatatables/source/class.constructor.php and around line 117 you'll see this:
if ($isMySql) { $columnCollate = ''; $columnTextType = 'TEXT'; $columnIntType = 'INT(11)'; $columnDateTimeType = 'DATETIME'; $nullable = ''; }
Change 'INT(11)' to 'BIGINT', so it looks like this:
and after that you will be able to use the same file to import the table. I tried it locally, and it worked after I changed this:
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
It appears existing tables still work fine, but can no longer create new tables. I assume this is related to the
../wp-content/plugins/wpdatatables/source/class.constructor.php
becoming blank.
Can you get me access to the original file, class.constructor.php so I can put it in there again? Alternatively, your login for my site is still good for another few hours. Thanks again for your help.
Also note: I have not yet attempted to edit existing tables.
Hi again Jacob.
Have you deactivated wpDataTables when you made the change? Perhaps that's what broke it.
Anyway, I copied and pasted the entire file, along with the BIGINT type, and I was able to import the table with correct values. Please take a look at wpdatatable id=36 and you should see correct values.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
You're welcome Jacob
Glad I could help.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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