|
|
|
Use the reference table below to help you correctly format the awarded certificates data you want to import via the Awarded Certificates CSV Loader.
Administrators with unrestricted access to the Awarded Certificates CSV Loader feature in System Roles (Manage Features > Certification Manager) can import awarded certificates CSV files.
To import awarded certificates data and review previous imports, go to Manage Center > Learning > Awarded Certificates CSV Loader.
If certificate award attributes have been defined, they are added to the end of the CSV file and prefixed with CT-.
Table: Awarded Certificates CSV Loader Field Reference
| Field | Content | Data Handling |
| ACTION | Action | A for Add or D for Delete |
| USERID | User ID | Mandatory. The user ID of the user to award the certification to. |
| CERTIFICATION_TITLE | Certification Name | Either a certification code or a certification name must be provided. If a certification code is not provided, the row will be skipped if more than one certificate matches the given certification name. |
| CERTIFICATION_CODE | Certification Code | A unique value among certificates. Either a certification code or a certification name must be provided. |
| AWARD_ID | Award ID | The Award ID of the certificate award. Mandatory when deleting certification awards, this is automatically generated when adding records. |
| DATE_ACHIEVED | Achievement date | Mandatory. If not specified, the record will be skipped. Preferred Date Format: dd-MMM-yyyy (as specified in System Configuration). |
| EXPIRE_DATE | Expire date | Optional. If not specified, it will be computed based on the certification validity period and the achievement date. Preferred Date Format: dd-MMM-yyyy (as specified in System Configuration). |
| COMMENTS | Comments | Optional. Maximum 255 characters. The import process skips records with invalid comments and generates an error report. |
| ASSIGNMENTID | Assignment ID | Optional. The ID of the users assignment in which the certification should be awarded. |
| IS_SELF_AWARDED | Is Self Award | Mandatory. Must be Y or N.
|
| STATUS | Status | Conditional. When IS_SELF_AWARDED = Y, Status is required. Must be 0, 1, 2, 3 or 4.
|
| ATTACHMENT_URL | Absolute or relative URL |
Optional. A valid URL for the PDF certificate attachment. For example, http://www.abc.com/tec101.pdf or /nd/fresco/repository/tec.pdf. URLs can be a maximum of 255 characters in length, and must be accessible by the LMS without any additional authorization, such as Single Sign-On (SSO) authorization. The import process skips records with invalid URLs and generates an error report. The maximum PDF attachment size 5 MB. |
| CT-DropDownAttribute Code |
Value for certificate award drop-down attribute with specified attribute code | Code related to the drop-down value to set for the attribute. Enter NONE to clear. |
| CT-DateAttribute Code |
Value for certificate award date attribute with specified attribute code | Must be in the format yyyy-MM-dd HH:mm:ss, e.g., 2010-08-25 13:00:00 denotes August 25, 2010, 1:00 p.m. Enter NONE to clear. |
| CT-AttributeCode | Value for certificate award attribute with specified attribute code (not of drop-down or date type) | Any Text (Max field length:2,000). Enter *NONE* to clear. |
Additional Information
