Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

In a lot of use cases CommTrack mobile worker needs to be associated with potentially multiple locations (i.e. 50-100 facilities per mobile worker). This page would walk you through the bulk upload tool to create multiple locations, and the tool to associate each CommTrack mobile worker with multiple locations.

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'


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.

 

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. 

You need to manually fill in all parent id for all clinics even when there are more than hundreds of them. 

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. 

 

Associate mobile worker with multiple locations using Excel upload

This tool would allow you to create mobile workers and associate them with different locations all in one go.

Go to Users and select Bulk Upload. Download excel file.

In sheet users, username and password are two required columns. All else are optional (phone-number would also be required if you are using CommTrack SMS instead of mobile app). 

Once you are done with the sheet, go to sheet locations and associate each mobile worker with facilities. It is necessary to fill in username and location-sms-code columns.

Once you are done with these two sheets, upload it and click 'Create Mobile Workers'. After you see the line "Your bulk user upload is completed!",  go back to Mobile Worker page and check if they are associated with facilities you assigned them.

Click one of the usernames, say matt. Go to CommTrack and you would see the Supply Point he is associated with is one of the facilities that you associated him with in the excel file. For now there is no UI where web users can see the list of all facilities that each mobile worker is associated with. 

  • No labels