Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Site: Sample file  

...

Column Name

...

Description

...

Name

...

Table of Contents

Steps to import CSV

Expand
titleExpand...
  • Log in as a super or institute admin user and go to the sites' list page.
  • Click on the 'Import' button and select the option 'Sites'.

Image Added

  • Click on 'Download Template File' to download the template file from the 'Import Sites' page.

Image Added

  • 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

Data Directory

...


Column Name

Data type

Mandatory?

(Create)

Mandatory?

(Update)

Description

Permissible ValuesValidations
IdentifierNumberNoDependsSystem auto-generated unique number for every site.
Mandatory while updating Site and Institute Name

Name

StringYesYesName of the site.
Should be unique within the system
Institute NameString
Name of an existing institute within OSInstitute Name within OS
YesNoInstitute under which the site has to be created.
Should be an existing institute
within OS
CodeString
Code
NoNo

A unique shortcode for the site

(user's choice)NA

.

This is typically used in HL7 or API integration when data comes from other programs with a site code.


Should be unique within OS
TypeStringYesNoType of the site.
  • Collection Site
/
  • Repository
/
  • Laboratory
/
  • Not Specified
Should be valid value from the list



Activity Status (v7.0)StringNoNoActivity status for sites.
  • Active
  • Disabled
Use 'Disabled' to delete the sites.
AddressString
Address of the siteNANA
NoNo


Coordinator#1#Email AddressEmail Address
Email address of a coordinator existing in OSEmail address of a coordinator existing in OS Email address of existing users within the selected institute
NoNoOne or more users will be assigned an "administrator" role on this site.

It should be an existing user.


Coordinator#2#Email AddressEmail Address
 
No
No