Steps to import CSV
- Login as super or institute admin user and go to sites' list page
- Click on the 'Import' button and select the option 'Sites'
- Click on 'Download Template File' to download the template file from the 'Import Sites' page
- Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
- Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update sites
- Click on the 'Validate and Import' button
- Refer 'Import status' to check the status of import job
Sample CSV
Data Directory
Column Name | Data type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| Identifier | Number | No | Depends | System auto-generated unique number for every site. | Mandatory while updating Site and Institute Name | |
Name | String | Yes | Yes | Should be unique within the system | ||
| Institute Name | String | Yes | No | Institute under which the site has to be created. | Should be an existing institute | |
| Code | String | No | No | A unique shortcode for the site. This is typically used in HL7 or API integration when data comes from other programs with a site code. | Should be unique within OS | |
| Type | String | Yes | No |
| ||
| Activity Status(Added in v7.0) | String | No | No | Activity status for sites | Active/Disabled | Use 'Disabled' to delete the sites. |
| Address | String | No | No | |||
| Coordinator#1#Email Address | Email Address | No | No | One or more users will be assigned an "administrator" role on this site. | Should be an existing user | |
| Coordinator#2#Email Address | Email Address | No | No |