Your course import sessions

This article will inform you about course imports in Springest. We offer our providers a service to import their courses automatically using an Importer.  

Import sessions are designed for:

Import sessions are interesting for providers who have shared their course data using a CSV-XML-file or an XML-feed. We have configured an import per institute (account). After each import session we store the results and show it in the admin. Once the import has been started a new row with results will be added. The results will also be shared with the right contact person by email when the import is completed. 

Import sessions page

On this page you can view the results of all import sessions for the selected import configuration. You can view the log of the latest import by clicking on 'Show log'. Below you can find short description of the different columns.

  • Date run: The exact date and time of the import session
  • Total courses: The total number of courses in the XML and the total number of courses expected to be published on Springest.
  • New courses: The total number of courses that have been created during import. The courses are new in Springest. 
  • Updated courses: The total number of courses that have been updated during import
  • Deleted courses: The total number of courses that have been deleted during the import. These courses were not listed in the XML. 
  • Successful: The number of courses that have been successfully imported.
  • Failed: The number of courses that have not been imported successfully. 

Log

From the log you can view the latest import result per course. You can check the log to see which courses didn't get imported. We always list the ID (= course id in the Springest Database) and external ID (= course id in XML given by Provider) for each course. For example:

With the external ID you can look back the course in the XML file for further investigation. 

List of common import failures

It can happen that one or more courses fail during the import. Below is a list of common failures and resolution. If you can not find yours in the list, please contact datasupport@springest.com and include the error and the admin-url. 

ID Failure (error message) Reasons & Solutions
1 Importer::TrainingAlreadyImported: Importer::TrainingAlreadyImported The training has already been imported. This means there are duplicate courses in the XML. Please check if there are courses with similar ID or names in your XML. The importer expects only unique courses (unique ID's)
2 NoMethodError: undefined method `force_encoding' for nil:NilClass This means that one of the fields containing text (Description, Runtime, PriceInfo) is empty. Please check the course in your XML and see what field is missing text. 
3 ActiveRecord::RecordNotSaved: Failed to replace starting_dateplaces because one or more of the new records could not be saved. The information added in the XML is not correct or is invalid. Please make sure
  • The format is valid according to the .XSD-document
  • A correct date is given (always). (yyyy-mm-dd)
  • A location is given (always)

Still need help? Contact Us Contact Us