Variable length CSV file

  • Resolved joefridaywebmaster

    (@mshragesnetnet)


    5 years, 10 months ago

    We have an excel file which records member attendance for meetings held twice a month. The exported CSV file has rows with column data up to the current meeting.
    So for the first month each member has an Id number, a last name, a first name, and one field for the first meeting (a character X for attended, or N for not-attended) as follows:
    203,Schrage,James,X
    For the second month each member has an Id number, a last name, a first name, and one field for the first meeting (a character X for attended, or N for not-attended), and a second field for the second meeting as follows:
    203,Schrage,James,X,X
    The table definition has 29 fields for Id, Last Name, First Name, and 24 columns for the attendance codes.
    I’ve tried to import and it fails as all columns are not present.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)

  • Tell me if this is correct as to your label schema.

    ID, lastname, firstname, meeting 1, meeting 2, meeting 3

    I don’t see in your description above that you have the required first two fields in the order specified by the plugin — username and email.

    These should be the first two columns and it should be placed in this order: username and email. If you have these two columns, and there are more columns, this plugin should manage it automatically.

Viewing 1 replies (of 1 total)
  • The topic ‘Variable length CSV file’ is closed to new replies.