If you need to migrate certification records from another solution, or to update records in bulk, you can create a CSV file and import it into the Edjet LMS.
You can import as many certificates as you need.
Steps to import certificates from your CSV file:
The import log is displayed. Please check the import status for any errors.
There are 3 import modes which you can choose:
| Mode | Description |
|---|---|
| Create and update |
Create new items in LMS and overwrite items in LMS. This is a default method |
| Create | Only create new items in LMS. |
| Update | Only overwrite items in LMS. |
Items are identified by the column "uid", if present. So, if you import a certificate that already exists in LMS, no duplicate certificate is created. Instead, the existing certificate is updated.
Filed delimiter is a character used to separate individual fields (columns) in the CSV file. Default is the comma, but you can change the character used.
Options:
It's necessary to use a first row in CSV file to pair columns with corresponding fields in LMS database.
All common user data can be imported. The specification of the columns include:
| Column | Description | Datatype | Required |
|---|---|---|---|
| cert_user_id | Certified user ID of the certified user (user:id). Used to associate certificate to the user. Valid values are existing user IDs. If the value is empty, no user is assigned (in update mode, the assigned user is removed). This value is used, if import data contain "uc_uid" and/or "uc_code" field. |
integer | no |
| uc_uid | [CERT_USER_UID] Unique identifier of the certified user (user:uid). Used to associate certificate to the user. Valid values are existing user Unique identifiers. If the value is empty, no user is assigned (in update mode, the assigned user is removed). This value is ignored, if import data contain "cert_user_id" or "uc_code" field. |
varchar(256) | no |
| uc_code | Code Code of the certified user (user:code). Used to associate certificate to the user. Valid values are existing user codes. If the value is empty, no user is assigned (in update mode, the assigned user is removed). This value is ignored, if import data contain "cert_user_id" or "uc_uid" field. |
varchar(256) | no |
| course_id | Course ID of the course (course:id). Used to associate certificate to the course. |
integer | no |
| name | Name Name of the certificate. |
varchar(1024) | no |
| media_lib_id | Layout image ID of the media library item (media-library:id). |
integer | no |
| content | Content Certificate content (visual editor). |
text | no |
| valid_from | Valid from | date (see more below) | no |
| valid_to | Valid to | date (see more below) | no |
| uid | Unique identifier This column is used to identify items for update. |
varchar(256) | no |
Supported date formats:
For more information about datatypes see: https://www.postgresql.org/docs/current/datatype.html
Example how to import your certificates:
"valid_from";"valid_to";"name";"cert_user_code";"course_id";
"1.1.2023";"1.1.2024";"Imported certificate A";"U1234";"1"
"1.1.2023 9:30";"1.1.2024 16:30";"Imported certificate B";"U1234";"1"If you plan to update the data, it is recommended to add the "uid" column and generate the values in your spread sheet before first import. If you need to do it later, you have to export the data including "uid" and then do the update.
The order of the columns doesn't matter.
The steps might differ with Excel, Calc or Numbers version.
In general the steps are as follow:
Visit the page Import or export text (.txt or .csv) files, section "Export data to a text file by saving it" on the Microsoft Support website.
In general the steps are as follow:
Visit the page Opening and Saving Text CSV Files, section "To Save a Sheet as a Text CSV File" on the LibreOffice help website.
Visit the page Export to other file formats in Numbers on Mac on the Apple Support website.
Error/Warning "Insufficient data supplied.“