CSV file upload failed

Hi @rafaelr52,

Do you have a database table where you want to import your data? Did you perform the column mapping? Have you watched this video?

If your answer to all my question is YES, can you share an export of your table structure and the csv file? You can use the contactform on the plugin website if you prefer to share this information in private.

Thanks,
Peter

Hi Peter,

Thank you for your support.
I already watched the video and I have a database table created for the import.
But I can’t see the “Column Mapping” button.
The problem is not with importing.
It is the csv upload that is failing.

Here’s an image with before and after clicking the upload button:

Regards
Rafael

Hi Rafael,
I’m a simple user of WPDA.
But as I’m currently using import CSV feature without problems,
I suggest you to check your privileges (read/Write) on your destination server
(ie, using filezilla).

Hope this helps.

Hi Rafael,

How are you running WordPress? We see a lot of issues with read and write privileges as @measy suggested with XAMPP. Does this apply to your installation?

Thaanks,
Peter

Hi @measy / Peter,

Thank you for replying.
Indeed I’m using wordpress in an old XAMPP (PHP 7.2.5) and Windows 10.
I’ll upgrade my xampp/php and I’ll let you know.
(I have not yet installed “WP Data Access” in production site)

Thank you again for your support
Regards
Rafael

It seems a problem with any XAMPP install (?)
Tryed it in another PC running Windows 11 and with XAMPP (PHP 7.4.1) – another database, another csv file, same behaviour.
Please let me know if someone has manage to upload any csv file with any XAMPP version in WP Data Access (v5.1.5).
Thank you.

Hi Rafael,
I tested for you on my XAMPP Php 7.4.3/WPDA 5.1.0/Win10 test installation:
CSV upload works fine.

I would suggest you to check it by this way:
1. use a test DB table, say A, or define a new one;
2. insert some records in A, (if empty);
3. download the .csv file;
4. open with XL (or similar);
5. append one/two records accordingly;
6. try to import this new .csv.

This is to check if the “error” is in the .csv you’re trying to match/upload.

Hope this helps.
Regards

• This reply was modified 2 years, 7 months ago by measy.

Hi @measy,

Thank you! I did what you suggested, using WPDA also to create the records.

I did the following (xampp PHP 7.4.1):

Using ONLY WP Data Access (5.1.5):
1- Create a test table with 2 fields (id, name)
2- Add 2 rows to the table
3- Export table to CSV.
When I try to upload the exported csv file, I had the same result and screen as in the message above.

If the problem is not with the WPDA version, I must have some code/plugin causing it.
I’ll try with a clean wordpress install and inform here, but I only expect to do it next week.

Thanks again.
Regards
Rafael

Hi Marco and Rafael,

Can you both share the URL of your XAMPP admin page? This might be an issue with the URL. It might also be a missing OS privilege.

How did you install XAMPP Rafael? I want to install XAMPP and try to reproduce this issue so I can fix it. And how did you install XAMPP Marco?

Thanks to both of you,
Peter

Hi Peter,
my test WP/WPDA instance is a simple “localhost” install:
I simply downloaded xampp-windows-x64-7.4.3-0-VC15-installer
from https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/7.4.3/ and ran it.

Then installed WP Bitnami (if I remember well) and installed WPDA plugin on top.

Hope this helps,
M.

Hi Peter,

My two xampp installs (2 PCs) are also simple localhost installs. They are in D:\xampp (I have my boot windows disks with 2 partitions, D: being the second one).
The more recent one was installed running xampp-windows-x64-7.4.1-1-VC15-installer.exe, as did @measy.
Also, I use them to test 2 production sites without problems so far. The themes both use the Genesis framework and WP is 5.9.2 portuguese version,
I activated Debug in WP, but no information is written to debug.log after trying to upload the csv.
As I said, I’ll try a clean install next week.

Thank you
Rafael

Hi,

Just wanted to let you know that I installed XAMPP and get the same error. I cannot import SQL files as well. No error messages here as well. Looks like a permission issue. When I installed XAMPP I got the following error:
https://ibb.co/J21Z3R5

I need some time to figure out what’s going wrong. Get back to you later…

Any help is appreciated!

To be continued…
Peter

Good news!

The issue is fixed. The sanitization was too tight. The plugin removed all backslashes from the path making the temporary file name unavailable.

I patched the current release. If you have already updated to 5.1.6 you need to do this again. The update procedure is described here:
https://wpdataaccess.com/docs/documentation/updates/patches/

Thanks for all your help and patience,
Peter

Hi Peter,

I upgraded to 5.1.6 and problem solved!
I found WP Data Access few days ago, when I was searching a flexible way of importing csv data to database tables.
But WPDA is so much more!… I had not yet the time to explore other options, but It seems to me a plugin to keep.
Thank you very much for your work and support.
@measy: Thank you too!

Rafael