Skip to content
manumoreira edited this page Nov 25, 2020 · 19 revisions

Import Wizard

Maap Collector tool offers hashing and obfuscation capabilities through an Import Wizard, to avoid exposing sensitive data server side.

Regarding Lab Records, at this moment Import Wizard is enabled only whenever the Site you are working with has a Hospital. If your Site does not have a Hospital, it is likely that you will not have any patient related information you would like to mark as confidential. Therefore, the Wizard has been removed in order to make import process more straightforward.

Import Wizard for Electronic Pharmacy Stock Records is enabled for every type of Site.

Protected Health Information (PHI)

When uploading files to the server, you may want to specify if any of your columns contains sensitive data.

If that's so, in the first step of the wizard you can specify which of your columns contains sensitive data and mark them as PHI. Values of those columns will be obfuscated in the file stored server side, which means that it will not be possible to read their content.

If your file contains PHI column, but they are already obfuscated (e.g if your file has already been processed by WHONET tool), you don't need to obfuscate them again.

Lab Record Imports: Patient Identification (PID)

When uploading Lab Record to the server, you may want to specify if there is a column containing Patient ID values. This data is extremely sensitive and has to be treated specially, so it remains private.

If so, in the first step of the wizard you can mark that column as Patient ID. By doing this, you are telling the server to hash the values of that column in order to keep the patient's anonymity. This means that the original values will be mapped into a complex combination of number and letters that only the Maap Admins will be able to relate to the original IDs.

If your file contains a Patient ID column, but it is already hashed (e.g if your file has already been processed by WHONET tool), you don't have to hash them again.

Synchronization

In order to constantly keep up to date, Maap Collector relies on a Synchronization Process which is triggered every time the Collectors are using the app, switching between actions and tabs, and their computers are online.

Synchronization is a two-step process that can be summarized as follows:

  1. Download the most recent changes from the server.
  2. Upload to the server collector's new files, entries or changes that the Collector performed in their local application.

This process applies for the following entities:

  • Sites
  • Antibiotics
  • Antibiotic Consumption Stats
  • Patient
  • Patient Entries

For Lab Record Imports and Electronic Pharmacy Stock Record Imports only step (2) of the process applies. That is, new files and changes to the files are uploaded to the server, but any of the other files uploaded to the server by other Collectors are downloaded by the app. That is because Maap Collector is just a data collection. Its main purpose is to keep all files server side, and Collectors do not need to have access to other uploaded files.

Site setting and synchronization

The synchronization process of Lab record imports varies depending on the type of site:

  • If the site has laboratory and has hospital every row of e lab record import file will trigger the creation of a patient row that can be edited later.
  • If the site only has laboratory the lab record import file will be synchronized faster without creating any additional rows.