Steps to import CSV

Expand...

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 'Data Dictionary' table below.
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 the import job.

Sample CSV

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	Name of the site.		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	Type of the site.	Collection Site Repository Laboratory Not Specified
Activity Status (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.		It should be an existing user.
Coordinator#2#Email Address	Email Address	No	No			It should be an existing user.