Format not working, no rows found

  • Resolved pedrovoorwinden

    (@pedrovoorwinden)


    7 years, 1 month ago

    Hi,

    I can’t get any format to work, the file is uploaded and the top column names are shown, but no rows are found.
    If I save a Excel file to CSV, it doesnt work, Editing it with Notepad doesn’t work.
    Not even when altering the test file, given in the documentation provided with the plugin, with Notepad or Excel.

    My csv file looks like this:

    
Username;Email;Password;first_name;last_name
myfirstusername;[email protected];mypassword;First;Last
mysecondusername;[email protected];mypassword;First;Last

    When I upload the test file directly it does work.

    What should I do?

    Kind regards,

    Pedro

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Javier Carazo

    (@carazo)

    7 years, 1 month ago

    @pedrovoorwinden,

    Have you tried using some good CSV software program like LibreOffice?

    We have never had problems with it.

    Thread Starter pedrovoorwinden

    (@pedrovoorwinden)

    7 years, 1 month ago

    Hi,

    I just installed LibreOffice and tried creating a CSV file and test it with the plugin.
    LibreOffice however, returns the same output as every program I used, and unfortunately, it didn’t work. I still get te header columns and no output rows.
    Can you provide me with the location of PHP functions that are used to decode the csv file so I can see if I can debug the problem with PHPStorm and xDebug? Maybe that way I can find a solution.

    Kind regards,

    Pedro

    Thread Starter pedrovoorwinden

    (@pedrovoorwinden)

    7 years, 1 month ago

    Hi,

    I’ve looked into the code and found out what is happening. The CSV file I was using, contained 2 rows, both rows used emails that were already in use by the application. It was not allowed to create 2 accounts with the same email. So the code skipped both, resulting in 0 rows to execute. It was my fault all along..

    Kind regards,

    Pedro

    Plugin Author Javier Carazo

    (@carazo)

    7 years, 1 month ago

    @pedrovoorwinden,

    Thanks this is not a problem from the plugin, in WordPress you cannot use the same emails in different users.

    Please remember that if this plugin helps you, remain a good review or make a little donation.

    Kind regards,

    Javier

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Format not working, no rows found’ is closed to new replies.

Tags