Import training courses

Import training courses

Open the menu Settings > Data import

File format

Select the file format for this import: CSV file, Syfadis format, Course.

The import format is a CSV file. Therefore, this file is in text format. The encoding is ANSI by default, but it can be changed.

1. Choose a separator for columns that can contain several values, by default this is the " | " character.

2. Choose the column separator character (usually a "," or "; ").

3. Check or uncheck the 2 options checkboxes:

   • Import the first line of the file (which sometimes can be the labels of the columns). It is generally recommended to uncheck this option.

   • With preview of the result. This allows you to view the import prior to the actual import.

4. Options of responsibility of the operations. Check the boxes to enable import insertions (or creations) or updates for this import.

File contents

The columns taken into account in the file to be imported are defined in a configuration parameter in the configuration page, node Data import > Training.

This setting is Column order for CSV file, Course and has the default values:

ExternalId;Name;LearningMode;Duration.Scale;Duration.Length;Code;GroupingCode;TrainingThemes.TrainingTheme.ExternalId;TrainingThemes.TrainingTheme.Name;TrainingProviders.TrainingProvider.ExternalId;TrainingProviders.TrainingProvider.Name;ImportLanguageCultureCode;ImportDomainExternalId;Import_PageDataMyTrainingCode;Import_PageDataCatalogCode;Mandatory;ExcludedFromLegalOverview

The order of the columns is important for the import mechanism and should not be modified!

For each line of the file, there are a few rules:

• The fields "ExternalId", and "Name" are mandatory otherwise the data is not imported (read).

• The order of the columns is fixed. If you don't have any information to put in a column, you should leave it blank. Do not delete it!

Here is a description of the columns provided for in the import file in the standard:

Additional column information

• Estimated duration: If the duration is to be provided, you must fill in the 2 columns concerned, Duration.Scale + Duration.Length.

• Theme : If the identifier defined in the file does not correspond to an existing theme in the application, the theme will be created, of course, in this case, you must fill in the name of the theme, otherwise the theme will not be created. If the identifier defined in the file corresponds to an existing theme in the application and the name entered is not the same, the theme will be updated with the new name entered.

• Training organisation: If the identifier defined in the file does not correspond to an existing training organisation in the application, the training organisation will be created, of course, in this case, it is mandatory to fill in the name of the organisation, otherwise the organisation will not be created. If the identifier defined in the file corresponds to an existing organisation in the application and the name entered is not the same, the organisation will be updated with the new name entered.

• Management area: If no value is entered in this column, the area taken into account is the current area when importing the course. If an ID is entered but does not match a domain, the line will be treated in error – we do not create a domain. Alternatively, a PrimaryDomain.Domain.Code column can be used to make the association between the training and an existing domain (configuration modification in this case).

Here is a description of other columns that can be inserted into the import file:

Settings

The license

No license

Privileges

Configuration settings