Import CSV File

  • sathyaki

    (@sathyaki)


    11 years, 3 months ago

    Hi Iam trying to import CSV file which has the heading row in upper case like, FIRST_NAME, CITY etc.. when i import this its giving null values for the field in the participant_database_fields table i found that name Colum containing lower case, When convert csv file heading rowto lower case its working fine. Can you help me to import csv fles which can import either case coulmns ?
    what change i need to make ?

    https://wordpress.org/plugins/participants-database/

Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    11 years, 3 months ago

    Generally, MySQL field names are case-insensitive, so I suspect what you’re really seeing is a spelling change.

    If you want to change the case of your header row, it will be much easier to change the case of your CSV file before you import it. You can do this either using a plain text editor or import the CSV into a spreadsheet app. Don’t try to use a word processor.

Viewing 1 replies (of 1 total)

The topic ‘Import CSV File’ is closed to new replies.