Child pages
  • CSV Formatting

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagenone
titleExamples of Staff Demographic (CI) records
CI,222222,NW1234567,09/15/1977,W,M,3,120,N,186.5,.5,0,5,5,OH1234567,,”John”,”A.”,”Doe”,
CI,222222,NW7654321,08/22/1965,B,F,2,0,*,210,3,0,0,0,ZX1234567,””,”L’Vonne”,”S.”,”Hoops”,
CI,222222,NW4444444,07/23/1971,A,M,3,120,N,188,0,0,6,6,OH7654321,,”David”,”Hank”,”Good”,”Jr.”
 

Alpha fields which may contain a comma must be enclosed in quotes.  Refer to the example above of the employee name field on the Staff Demographic record.


Code Block
languagenone
titleExamples of Student Assessment (FA) records
FA,333333,NW7654321,GX,10,M,2008/03,STR,11,NO,*,355
FA,333333,NG1234567,GY,**,43FA,2012/01,**,**,*,231
FA,333333,HG1234567,SA,12,ENG,6/23/2017,STR,12,**,*,220 
FA,333333,HG1234567,GA,8,ELA,5/2017,ALT,8,Y2,*,402
FA,333333,HG1234567,GA,3,M,4/1/2017,ALT,3,Y2,*,273

Date fields must have the “/” in place in order for the record to import properly.  For YYYYMMDD date fields, the date may be either MM/DD/YYYY or YYYY/MM/DD in the CSV file.  For YYYYMM date fields, the date may be either MM/YYYY or YYYY/MM.  In the case of a blank (null) date, the date cell may be left blank or it may be filled with zeroes (ie. 00/00/0000).  There is one exception to this rule for dates, the YYYYMM date fields on the GG record need to be formatted as YYYYMM (no slash) or ******.Alpha fields which may contain a comma must be enclosed in quotes.  Refer to the example above of the employee name field on the Staff Demographic record

FA records - Test Date

Beginning FY17, the test date for assessments has been changed to a full eight character date rather than just month and year.  The day is only required in cases where the same assessment is offered more than once during a month.  This is currently true for ACT and SAT tests.  The FA record may be imported into EMISFFE using either MM/YYYY or MM/DD/YYYY formats.  In the case where day is not supplied, it will be defaulted to '01'.  The FA CSV example above shows various formats that may be used for importing into EMISFFE.


Financial records

Financial (QC) Records must include the following elements that are the KEY to the records, these elements will always be the first six columns of any QC record:

...