Title: Variable length CSV file
Last modified: January 26, 2019

---

# Variable length CSV file

 *  Resolved [joefridaywebmaster](https://wordpress.org/support/users/mshragesnetnet/)
 * (@mshragesnetnet)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/variable-length-csv-file/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fvariable-length-csv-file%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  [CreativeRaven](https://wordpress.org/support/users/arizonanorse/)
 * (@arizonanorse)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/variable-length-csv-file/#post-11134365)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-csv-to-database_f1b072.svg)
 * [WP CSV to Database - Insert CSV file content into WordPress database](https://wordpress.org/plugins/wp-csv-to-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-csv-to-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-csv-to-database/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-csv-to-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-csv-to-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-csv-to-database/reviews/)

## Tags

 * [import failure](https://wordpress.org/support/topic-tag/import-failure/)

 * 1 reply
 * 2 participants
 * Last reply from: [CreativeRaven](https://wordpress.org/support/users/arizonanorse/)
 * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/variable-length-csv-file/#post-11134365)
 * Status: resolved