Bitnami WP Multisite on AWS, CSV import seems successful, but no records there

  • Resolved mhurwicz

    (@mhurwicz)


    5 years, 8 months ago

    I’m trying to import a CSV file of contacts. PD says that all the records imported, but then when I go to “list participants” there are no records there. The user I am logged in as has Super Admin capabilities, so I wouldn’t think permissions are at fault. The CSV file seems properly formatted. I can input a participant manually. Any thoughts how I can import a CSV file to populate the database?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter mhurwicz

    (@mhurwicz)

    On closer investigation, I see that it is importing, but all of the fields are null. Not sure what would cause that, but I’m guessing I need to make a different kind of CSV.

    Plugin Author xnau webdesign

    (@xnau)

    The CSV must be UTF-8 encoded, many spreadsheet apps don’t do this by default. Also make sure the headers match the field names (not titles) exactly.

    Lastly, you can turn debugging on in the plugin settings under the advanced tab and you will see a summary of the import. I suggest you test with a file with only couple records to get it working before trying a larger import.

    Thread Starter mhurwicz

    (@mhurwicz)

    How should I configure the CSV export from phpmyadmin? One complication is that some of my text fields have commas in them. Image below shows the options I’m seeing in phpmyadmin.

    • This reply was modified 5 years, 8 months ago by mhurwicz.
    Thread Starter mhurwicz

    (@mhurwicz)

    There were two problems:

    OpenOffice Calc was removing quotes when I saved the CSV. (Is this normal?)

    I had titles instead of field names in my headers.

    I edited the file with a text editor, changed the headers to match the field names, and all the records imported.

    Thank you!

    Plugin Author xnau webdesign

    (@xnau)

    Glad you got it all working.

    Quotes are only needed if the data contains a meta character, such as a line return or comma, so I’m guessing that OpenOffice is trimming the size of the file down by removing unneeded quotes.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Bitnami WP Multisite on AWS, CSV import seems successful, but no records there’ is closed to new replies.