I'm using a Mac and was wondering how to import a class list.  I tired to save as a csv file from EXCEL but when I import it gives me a #144 error.

Any suggestions?

Thanks

I'm also getting the same #144 error despite following the Senteo Help directions and instructions in your post.  Tried even going into text edit to insert commas in the csv file (even deleted them), but I still get the same error.  Help!

The order of the columns doesn't matter. What matters is that the first row must contain column headings that say what's in each column.

Here's an example of a .csv file to illustrate what to put for the column headings.

"ID Number","First Name","Last Name"
90210,"Brandon","Walsh"
888,"Feng","Shui"

You must have at least a column with heading: ID Number.

The single space between ID and Number is important. The importer will also accept it if this column heading is any of: ID; Student ID; or just plain Number.

If you do not have an appropriately named column for the ID Number, the import will not complete.

The columns that give the student's name are optional. There is a lot of fexibility in how you specify names and in a follow-up post I will give the full details.

Oh, the double-quote characters around cell contents are optional: your spreadsheet software may or may not insert them depending on if the cell values have commas in them.

Around page 17/18 of the Senteo user guide there is detailed example. (Download the user guide from SMART's web site if you don't already have a copy handy: http://www2.smarttech.com/kbdoc/93347)

Also, there is a knowledge base article on SMART's support site that gives examples: http://www2.smarttech.com/kbdoc/128887

If you have further problems importing your class list, please try posting the first few lines of your .csv file here (please change students' names and numbers to preserve their confidentiality.)

Thanks!

As mentioned previously, there is a lot of flexibility for names. They're not even mandatory.

For the students' given names, use this as the column heading: First Name.

The single space between First and Name is important. The importer will also accept it if this column heading is any of: First; Given Name; or just plain Given.

For the students' family names, use this as the column heading: Last Name.

Likewise, the single space between Last and Name is important. The importer will also accept it if this column heading is any of: Last; Family Name; or Surname.

If you don't have the names split out into separate columns for given/family name parts but instead have the combined in a single cell value you can have the importer automatically separate them by using this as that column's heading:  Full Name.

Likewise, the single space between Full and Name is important. The importer will also accept it if this column heading is any of: Full; or just plain Name.

If you are using the "full name" approach, the importer will first check to see if the family/given names are separated by a comma like this: Family, Given.

If there's no comma, it will separate them by spaces like this: Given Family.

If there is more than one space, the last word is used as the family name and all the first words are joined together to form the given name. For example, my full name "Michael John Boyle" would be split so that my family name is "Boyle" and my given name is "Michael John".

Finally, I reiterate: the order of the columns doesn't matter: what matters is that the first row of the file has suitable column headings. I will work to ensure this important fact is expressly stated in the online help for Senteo 2.0.