WordPress.org

Ready to get started?Download WordPress

Forums

Participants Database
[resolved] CSV Import - Blank Fields (4 posts)

  1. phenn
    Member
    Posted 1 year ago #

    When importing from a CSV file (created in Excel and formatted to text only in all columns), I get a confirmation that new entries were successful. However, all fields are blank except for the ID.

    Are there any other formatting considerations?

    This is after adding custom fields and grabbing the sample CSV for them.

    Any help would be appreciated!

    http://wordpress.org/extend/plugins/participants-database/

  2. xnau
    Member
    Plugin Author

    Posted 1 year ago #

    phenn,

    Try exporting your CSV with a comma delimiter...Excel defaults to using "tab" and that won't work. Let me know if that does it.

  3. phenn
    Member
    Posted 1 year ago #

    Thanks, xnau. I did two things to resolve this.

    First, I incorrectly assumed that adding new fields would add them to the CSV import function. My bad. Users need to check their work and make sure they are selecting the 'CSV' box on new fields.

    I then followed your suggestion.

    Blammo!

    Everything is working beautifully.

    The plugin is ingenious and quite simple to use. Thank you so much for this and for your help.

  4. xnau
    Member
    Plugin Author

    Posted 1 year ago #

    Happy to hear it worked. Guess I could do a better job of explaining how to import the CSV.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic