1. /*  EXPECTED FORMAT received by the import tool */
  2. "3_LAST NAME:_textbox", "4_FIRST NAME:_textbox", "5_STREET ADDRESS:_textbox", "6_CITY:_textbox", "7_STATE:_textbox", "9_ZIP CODE:_textbox", "8_EMAIL ADDRESS:_email", "10_PHONE NUMBER:_textbox", "58_DATE OF BIRTH_datetime", "12_NAME OF SCHOOL:_textbox", "19_GRADUATED:_dropdown", "20_G.P.A.:_textbox"
  3. "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "sample@example.com", "sample input text", "2013-12-31 17:22", "sample input text", "optionName", "sample input text"
  4.  
  5. /* FORMAT THAT WE HAVE IN OUR CSV FILE */
  6. Time Submitted,LAST NAME:,FIRST NAME:,STREET ADDRESS:,CITY:,STATE:,ZIP CODE:,EMAIL ADDRESS:,PHONE NUMBER:,DATE OF BIRTH:,NAME OF SCHOOL:,GRADUATED:,G.P.A.:
  7. "January 23, 2015 3:44 PM",Rosemary,Zimmerman,328 LOWELL STREET,LEXINGTON,MA,02420,Rosemory@comcast.com,781) 860-0012,08/28/1983,LEXINGTON HIGH SCHOOL,yes,3.0
  8. "January 23, 2015 3:41 PM",Tracey,Svenson,18850 SaLcoy Street,VERMONT,VA,91335,TraceySv@hotmail.com,267-8957469,11/26/1990,HARRINGTON HIGH SCHOOL,yes,3.5
  9. "January 23, 2015 3:26 PM",Randy,Smith,74285 Haven Creek,Katy,TX,78413,RandyS@gmail.com,456-2548699,08/27/1980,Robin Dell Private School,yes,3.5
  10. "January 23, 2015 3:01 PM",Jane,Doe,1811 Juniper Street,Brodhead,WI,78447,Jadoe@mail.com,587-9587744,10/28/1983,"University of Texas, Austin",no,3.0
  11.  
  12.  
  13. /* FORMAT AFTER ADDING EXTRA FIELDS ( in our case the submission date field ) */
  14. "62_Time Submitted_textbox", "3_LAST NAME:_textbox", "4_FIRST NAME:_textbox", "5_STREET ADDRESS:_textbox", "6_CITY:_textbox", "7_STATE:_textbox", "9_ZIP CODE:_textbox", "8_EMAIL ADDRESS:_email", "10_PHONE NUMBER:_textbox", "58_DATE OF BIRTH_datetime", "12_NAME OF SCHOOL:_textbox", "19_GRADUATED:_dropdown", "20_G.P.A.:_textbox"
  15.  
  16. "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "sample@example.com", "sample input text", "2013-12-31 17:22", "sample input text", "optionName", "sample input text"
  17.  
  18. /* FINAL LOOK OF OUR CSV FILE */
  19. "62_Time Submitted_textbox", "3_LAST NAME:_textbox", "4_FIRST NAME:_textbox", "5_STREET ADDRESS:_textbox", "6_CITY:_textbox", "7_STATE:_textbox", "9_ZIP CODE:_textbox", "8_EMAIL ADDRESS:_email", "10_PHONE NUMBER:_textbox","58_DATE OF BIRTH_datetime", "12_NAME OF SCHOOL:_textbox", "19_GRADUATED:_dropdown", "20_G.P.A.:_textbox"
  20. "January 23, 2015 3:44 PM","Rosemary","Zimmerman","328 LOWELL STREET","LEXINGTON","MA","02420","Rosemory@comcast.com","781) 860-0012","08/28/1983","LEXINGTON HIGH SCHOOL","yes","3.0"
  21. "January 23, 2015 3:44 PM",Rosemary,Zimmerman,328 LOWELL STREET,LEXINGTON,MA,02420,Rosemory@comcast.com,781) 860-0012,08/28/1983,LEXINGTON HIGH SCHOOL,yes,3.0
  22. "January 23, 2015 3:41 PM",Tracey,Svenson,18850 SaLcoy Street,VERMONT,VA,91335,TraceySv@hotmail.com,267-8957469,11/26/1990,HARRINGTON HIGH SCHOOL,yes,3.5
  23. "January 23, 2015 3:26 PM",Randy,Smith,74285 Haven Creek,Katy,TX,78413,RandyS@gmail.com,456-2548699,08/27/1980,Robin Dell Private School,yes,3.5
  24. "January 23, 2015 3:01 PM",Jane,Doe,1811 Juniper Street,Brodhead,WI,78447,Jadoe@mail.com,587-9587744,10/28/1983,"University of Texas, Austin",no,3.0