Versions Compared

Key

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

There are two ways to register locations in CommTrack:

...

Bulk upload location using excel 

Assuming in your project there are 3 mobile workers and each of them manages the inventory of 2 facilities. The first thing to do is to bulk upload 6 clinics. To do this, you first go to Setup and select 'Upload Locations from Excel'

Download 'locations.xlsx'

...

to Setup and select Locations. Go click 'Bulk Import Locations', and download the location configuration file.

Image Added


In the example domain we created two types of location hierarchy. Accordingly in the excel file there would be two sheets: sheet1 for District information and sheet2 for Clinic information.

Image RemovedImage Added

 

Let's say the 6 facilities are equally distributed from district a to district c. Fill the 'name' column, save the file and upload. The system would automatically generate an id for each district. 

Once you have successfully uploaded the excel file, repeat the download step and open the downloaded excel file. You should be able to see 3 ids for each district type. This time you would work on clinic sheet.

The concept for uploading clinic information is the same: fill in 'name' column with name of facilities. Two more manual steps: 1) fill in 'parent_id' column with district id. Let's say clinic 5 and clinic 6 are located in district a (a.k.a. district a is the parent of the two clinics). Then the parent id for these two clinics should be the system-generated id for district a in sheet district. 2) fill in 'site_code' column with unique codes for each clinic. 

Save the excel file and upload it again on the same screen. Once it is successfully uploaded, select 'Manage Locations' and you should be able to see the three districts and clinics within each district. You need to manually fill in all parent id for all clinics even when there are more than hundreds of them. 

Image RemovedImage Added