Hello regis

Thank you for your purchase.

When you import a file, the plugin creates a new manual table, which is stored in the database. That database table needs to have a unique auto-increment, integer column, which will be used for editing and adding new rows. If you don't have a column like that, the plugin will not be able to add new data, or modify existing data in the table.

So, you will need to create a new integer column in the database, and make it an auto increment column. Since that table already contains data, you'll need to assign values to an auto-increment column, so you can add it using a query similar to this:

ALTER TABLE `yourDatabaseTable` ADD `auto_increment_id_column` INT NOT NULL AUTO_INCREMENT;

Hi again regis

I honestly can't say what's going on. When I enter data manually, and then copy and paste "1" and "8" over that, it works.

Can you, please, provide me a temporary wp-admin (administrator) user, and FTP access credentials, so we can debug the plugin, and see what's going on? Database access would also be great, if that's not too much to ask.

Please remember to enable the PRIVATE response again when you paste credentials, so they are visible only to us.

Hi again regis

I was able to replicate the issue, I just don't know why it occurs, and it is strange that pasting over existing rows works.

Can you, please, provide me a temporary wp-admin (administrator) user, and FTP access credentials, so we can debug the plugin, and see what's going on? Database access would also be great, if that's not too much to ask.

Please remember to enable the PRIVATE response again when you paste credentials, so they are visible only to us.

Thank you, Regis

I forwarded the credentials to one of our developers, and as soon as I hear from him, I will let you know.

Hi again Regis

You sent us the entire hosting, and we have access to everything except for wp-admin credentials.

We can't find that anywhere.

Thanks again, Regis

I forwarded the credentials to our developer, and as soon as I hear from him, I will let you know.

Hi again Regis.

There's a bug with entering new rows with a separate DB connection, and excel like tables. Our developer was able to fix it for you, and this (or a better) solution will be added to our next update, so there's no need to worry about it.

Your website is fixed now.

Hello again Regis

I'm not sure what you did with the wdt_ID column in the database, but it doesn't have primary key set, nor is it an auto-increment column - that's why editing and inserting doesn't work. There was also an issue due to apostrophes in the cells, but our developer was able to fix that, so it works fine now in the new Support table, where wdt_ID is configured properly.

You can use that table, but if you want to use another one, you will need to import the data, but don't touch the wdt_ID column at all.

Hi again Regis

I don't see why it would fail after row #28, but it could be a timeout on the server, since it is a lot of data, and the default timeout is set to 300ms.

You can import the file directly in the database, though - it will be faster for sure, and it won't break

When you're importing a CSV file in your database, you need to navigate to the WordPress database, select the table that already exists in the database, and click on "Import":

Then click on "Choose file" and select your CSV file:

When you're adding a CSV file to update an existing table, you need to make sure that the structure of the file is the same (same column order and same type of data in the columns). Then, save the file without the headers, and import it in the database table. Then, when you select that file scroll down, and make sure the "The first line of the file contains the table column names" check-box is un-checked, so the first line is not used for headers of the table; and then click on GO:

Hi again Regis.

This limit can be increased in your php.ini file on the server. If you can't find it, or don't know how to modify it, please reach out to your hosting provider.

Hi again Regis

I'm glad to hear you were able to resolve the issue with the timeout!

As for the datetime - I suppose the issue is coming from the format. In wpDataTables it's set to DD/MM/YYYY HH:MM:

But in the CSV file it's DD-MM-YYYY HH:MM:

Please go to wpDataTables settings, and change the format to match what you have in the CSV file, and it should work.

Hi again Regis

Table #91 is now completely blank, so I tried changing the dateTime format from DD-MM-YYYY to DD/MM/YYYY, and it worked fine when I pasted the value in that table:

So, this was pasted, not selected from the date picker, and it worked fine. The only thing that could go wrong here is the date format.

Hi again Regis

I suppose the issue here is caused by the dateTime column. You can copy and paste the date without accessing the date column (Datedetelecollecte), but you can't copy and paste a value into dateTime without double clicking on the column.

I've forwarded this to one of our developers, so he can take a look.

Thanks for the video!

Hello again Regis.

Our developers confirmed this is a bug. When datetime column is copied, it needs to have the same format in the CSV (or Excel) file, as it is written in the database YYYY-MM-DD HH:MM:SS.

We'll see to fix this for one of our future updates.

Sorry for the inconvenience.

Hi again Regis

You can subscribe to our Newsletter, where we add all info about what's been fixed, and what's been added to the plugin.