Support » Plugin: WP Data Access » CSV file upload failed

  • Resolved rafaelr52

    (@rafaelr52)


    Hi,

    I’m testing the plugin in localhost and after creating a new table with it, I tried to import a csv file. But the upload failed without message: After choosing an import name, selecting the csv file and clicking the upload button, the page displays only “<- Import CSV” to return, and the file is not uploaded.
    I tried with 3 different csv files and the result is always the same.
    As I saw that this option is available in the free version and nobody complains about it, the problem should be with me. I already uninstalled and installed the plugin and deactivate another csv import plugin (?)
    Thank you for your help.

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter rafaelr52

    (@rafaelr52)

    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.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter rafaelr52

    (@rafaelr52)

    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

    Thread Starter rafaelr52

    (@rafaelr52)

    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.

    measy

    (@measy)

    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 4 months ago by measy.
    Thread Starter rafaelr52

    (@rafaelr52)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    measy

    (@measy)

    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.

    Thread Starter rafaelr52

    (@rafaelr52)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter rafaelr52

    (@rafaelr52)

    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

Viewing 14 replies - 1 through 14 (of 14 total)
  • You must be logged in to reply to this topic.