Leave a comment at the end of this page or email contact@krishagni.com
User Forms Template (v8.0)
- Divya Prabhu (Unlicensed)
- Ankita Chavan
Steps to Import CSV
Log in as an admin user and go to the users' list page.
Click on the 'Import' button and select the option 'Forms'.
Select the records type.
Click on 'Download Template File' to download the template file.
Enter all valid data in the template file as mentioned in the 'Data Dictionary' table below.
Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to add or 'Update' to update user roles.
Select the correct date and time format.
Click on the 'Validate and Import' button.
Refer to 'Import status' to check the status of the import job.
Example Form
OpenSpecimen User Training Form
This is the default user training form that comes with OpenSpecimen. You can modify the form or use the same form as per your requirements.
Sample CSV
Data Dictionary
Column Name | Data Type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
OpenSpecimen User Training Form ID | Integer | No | No | It should be specified while updating a record. |
| The ID can be retrieved from the 'Forms' tab within the particular user. For multiple records, update the record id required. |
Email Address | String | Yes | Yes | The email address of the user for whom you want to create/update the form record. |
| The user should be registered in OpenSpecimen. |
Activity Status | String | No | No |
|
| The value should be 'Disabled' to delete the form record. |
Year of training | String | No | No |
|
| The entered year should be within the PVs. |
Privacy & Security (1) Training Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
DATE of ANNUAL Privacy&Security (1) Training | Date | No | No |
|
|
|
MAT (2) Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
DATE of ANNUAL MAT (2) | Date | No | No |
|
|
|
Cyber Security Awareness (3) Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
DATE of ANNUAL Cyber Security Awareness (3) | Date | No | No |
|
|
|
Workplace Violence Prevention (4) Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
DATE of ANNUAL Workplace Violence Prevention (4) | Date | No | No |
|
|
|
IATA Shipping (5) Training Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
DATE of BIENNIAL IATA Shipping (5) | Date | No | No |
|
|
|
Fire Safety (6) Training Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
DATE of ANNUAL Fire Safety (6) Training | Date | No | No |
|
|
|
OpenSpecimen (7) - ANNUAL Community Meeting (OSCON)#1 | String | No | No |
|
| The entered year should be within the PVs. |
If YES, Attended - DATE of ANNUAL OpenSpecimen OSCON (7) Meeting | Date | No | No |
|
|
|
OpenSpecimen (8-1)-Initial Training Completed? | String | No | No |
|
| The entered year should be within the PVs. |
OS (8-1)-DATE of Completion of INITIAL OS Training | Date | No | No |
|
|
|
OpenSpecimen (8-2)-Annual Competency Assessment Completed for this year? | String | No | No |
|
| The entered year should be within the PVs. |
OS (8-2)-DATE of Completion of ANNUAL Competency Assessment | Date | No | No |
|
|
|
SoCRA (9) Certificate?#1 | String | No | No |
|
| The entered year should be within the PVs. |
SoCRA (9) - If YES, Expiration Date (re-certify every 3 years) | Date | No | No |
|
|
|
Additional Training (10) | String | No | No |
|
|
|
Comments (11) | String | No | No |
|
|
|
Leave a comment at the end of this page or email contact@krishagni.com