Import Students

Student Upload:

Students can be imported into ASBWorks from another database or previous accounting program. The import file must be a comma separated file (.csv). IF the file is an excel file, you can save the file as a .csv from the 'Save As' menu.

Import File Specifications:

Here are the default headers for the student import file and a description of each. All these columns are expected, in this order, with these headings (Capitalization too!) :

Student#

ID#

First Name

Middle Name

Last Name

Mailing Address

City

State

Zip code

Home Phone

Grade

Column Descriptions:

•Student # (Data Required) - This is an alternate ID # for a student so you can potentially cross reference the students with another system if needed.

•ID# (Data Required) - This is the student ID# from the originating system. In our software, this number will be used as the student Bar code.

•First Name (Data Required) - First name of student

•Middle Name - Data can be left blank if not needed.

•Last Name (Data Required) - Last name of the student

Mailing Address (Columns in blue make up the mailing address. If you wish to import the address, all these columns must be completed.)

•Mailing Address - Street Address

•City - Mailing City

•State - Two Character State Abbreviation (ex. CA, MI)

•Zip code - All Zip Code formats are accepted. 5 digit, 9 digit, or 5-4 digit. (ex. 11111, 22222-2222, 333333333)

•Home Phone - Most phone formats are accepted. (ex. (123)456-7890, 123-456-790, 123456789)

Any extra digits after the base phone number is validated, are treated as the phone extension. (ex. +666, x444, 666).

(Data can be left blank if the student doesn't have a phone, OR if you do not want the number in the system.)

•Grade - The student grade # (ex. 1, 12). Data can be left blank if not needed.