Hi I have just set up a local installation of Gibbon to test the functionality, I have used OpenRefine to clean up our student data file, however, after trying to run an import I have 1602 errors for the 205 records I am trying to import, I wanted to ask if there was an Excel template I could use for importing student/parent and teacher information?
Or have a missed something in the initial setup, creating user fields or replacing the ones that already exist to match our data?
Hi Mike, yes, next to each of the import options is an export option, which will download a blank spreadsheet with the columns pre-filled for you. However, the importer will also let you associate columns when you’re importing, so your current columns may work.
Gibbon is quite specific about the format of data it accepts, in order for everything to connect when uploaded. If you’re encountering errors, be sure to check the table on the selected import that explains the expected data, for example:
For example, gender must be a single character, rather than a word. For many fields that are connected to other records, the shortName is used to reference that data when importing. Hope this helps!
