Import data into iDoceo

From the list of classes >20 > import CSV/XLS file. The import wizard will guide you through the steps.

If your file is already in your iPad and stored in Numbers, here is a quick guide for you.

You can also drag&drop the file into the list of classes to import it.
Image
You can also use 'Open in' > iDoceo, to import a file. It will use the 'Import wizard' and by following the steps, you can create a new class with the data or add the data to an existing class. This method is flexible and does not require any kind of edition in your CSV or XLS file headers
If by any reason you can not use a XLS/XLSX or CSV file, you can still import your students names from any text based source like Pages, a PDF or Word, by using the Copy & Paste feauture. Find below a video that explains the details.

Which formats can be imported?

iDoceo is able to import data from CSV and XLS / XLSX files. Any spreadsheet software (such as MS Excel, Numbers,Open Office, LibreOffice) is able to export and generate these files.

We recommend working with XLS/XLSX files

From the app or loaction holding your CSV/XLS/XLSX file, tap on 'Open in' > iDoceo and you'll be presented with the different options explained here. The import wizard will do the rest for you.
iDoceo will let you select which sheet to import if more than one has been detect in your XLS/XLSX file.
Image

I can't see the import wizard option when 'Opening in' iDoceo

This means the file is neither a CSV nor XLS/XLSX.

Please make sure you import the proper file extension. If you are trying to import several CSV sheets at once, Numbers will create a ZIP file that cannot be processed by iDoceo. The file must end in .csv, .xls or .xlsx

Which information can be imported?

Your students, their personal data, columns and their grades.

What about student photos?

You need to import first the students names in iDoceo, the next steps are explained here.

How should my info be formatted in order to be properly imported?

The only mandatory requirement is that a single row must contain a single student's data. It can't be spread in different rows.

Optionally, another requirement is that the first row of your spreadsheet should hold your columns names.

If you choose not to, importing will work, but column headers text will be empty.

Image

The import wizard

It is the default and only method to import CSV or XLS/XLSX files to iDoceo. It is use in all three ways of import, Drag & Drop, Import CSV/XLS file, or 'Open In' > iDoceo. I has five stages.
1
Header Row Selection: In this step you have to select where you column headers are (students, birthdays, Student ID, Homework 1, exam 1, etc). Additionally, if you have more than one sheet in your file, you can select the sheet you want to import.
Image
2
Student Name Composition: Here you will indicate which column headers are the names and the last names.
Import
3
Personal Data: In this step you will assign which column headers represent which personal data fields, like Student ID column header is ID, or Father column is Father's Name. All columns that do not represent a personal data field, leave empty.
Import
4
Gradebook Data: All the columns left empty in the previous step will be automatically selected in this one. Those columns will be added as columns in the gradebook. If you do not want to add one of them to the gradebook, deselect the column header with one tap.
Import
5
Import: The last step of the wizard, here you will decide if you want to create a new class with all this data or if you would like to add this data to an existing class in iDoceo.
Import

Any other specifics for CSV files?

Yes, if your spreadhseet software allows it, you should choose to store your file in UTF-8 (unicode) encoding.

If you don't, you might see weird characters when importing instead of your accents (if you're in a non english speaking country).

Any other specifics for XLS files?

Yes, you'll need to save in XLS format from a fairly recent MS Excel (i.e Excel 2000 will work, but Excel 95 won't).

Open In > iDoceo

From your iPhone or iPad, go to the location where you have your file:

iPad Storage (Files App) or email: open the file and select the export button, then iDoceo and tap on it. 

Google Drive: Locate the file and click on the three dots > Open In > Select iDoceo.

Dropbox: Select the three dots and choose Share > Export File, then look for iDoceo.

Any other location: Just look for the Export/Open in/Share options and select iDoceo.

When you are taken to iDoceo, the import wizard will open automatically.
Image
Image
Image
Image
You can also use the 'Open In' option in the Mac, just go to where your file is > right click > Open With > iDoceo

I can't use Dropbox or Google Drive or any cloud app with personal information of my students

You can use your own iPhone, iPad or Mac storage and from there Open in or Drag & Drop to iDoceo to import your files. 
To transfer a file between devices, you can use your personal emai, a USB or Wifi Disk apps to tranfer your files.

Appending data to an existing class: I already have some students in this class, what will happen if I import?

iDoceo, when importing, tries to find students with the same name and does not import them again (it only updates their personal data). New students will be imported alongside the existing students.

I'm having trouble importing a single column CSV with student names in it

Try adding 2 or 3 empty columns when exporting to CSV, this will help iDoceo to determine the proper CSV format.

If you are trying to create a CSV file on a windows machine

When exporting you should be able to specify CSV and MAC (UTF-8) file format, this will make it easier for iDoceo to work with your file.