Table of Contents

Steps to import CSV

Expand

title	Expand...

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
Image Modified
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

...

Column Name	Data type	Mandatory? (Create)	Mandatory? (Update)	Description	Permissible Values	Validations
Identifier	Number	DependsNo	Depends	System auto-generated unique number for every siteThis field can be used to update site name.		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		Collection Site Repository Laboratory Not Specified
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			Should be an existing user

Versions Compared