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.

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.

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:

Here's the file.

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:

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.

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.