Versions Compared

Key

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

...

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

StringYes
  
YesName of the site.
Should be unique within the system
Institute NameStringYes
  
NoInstitute under which the site has to be created.
Should be an existing institute
CodeStringNoNo
An

A unique

short code

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
TypeStringYes
 
NoType of the site.
  • Collection Site
,
  • Repository
,
  • Laboratory
,
  • Not Specified
  



Activity Status (v7.0)StringNoNoActivity status for sites.
  • Active
  • Disabled
Use 'Disabled' to delete the sites.
AddressStringNo
  
No


Coordinator#1#Email AddressEmail AddressNoNoOne or more users
who Should
will be assigned an "administrator" role on this site.
 

It should be an existing user.


Coordinator#2#Email AddressEmail AddressNo

Sample BO Template

No