DOC: CmdQesExporter, anonymised and encrypted data
Starting with 5.4.9, all anonymised data is automatically encrypted. When you're doing an export from Supervisor, it's automatically handled by the system. But if you're still using CmdQesExporter to export your data, in 5.4.9+ environment, and if you want to get also the anonymised data, then you need to get the encryption keys for the survey you're exporting.
First, you need to refer to this article to have an overview of how the encryption is working on CCA side.
Then, you need to install this folder on your website (ideally where is installed your CCAAPI / CCAWebAPI). Once the folder is set at the root of your website, you can modify these two parameters (lines 128 / 129), into the DatabaseSettings.html:
- 1/ Value for urlCcaWebAPI (should be your internal IP address of your webserver):
<label for="urlCcaWebAPI">URL CcaWebAPI: </label><input type="text" id="urlCcaWebAPI" size="100" value="http://192.168.35.895/CcaWebAPI/"/><br/>
- 2/ Value for CCA Token should be taken from the supervisor > extra > Authentication Tokens . . .
<label for="urlCcaToken">Cca Token: </label><input type="text" id="urlCcaToken" size="100" value="A-541d73a8-af11-4e93-a4b3-d2f4305ef83a"/><br/>
Then, you start your weblink to databasesettings.html page.
click on generate new key pair
> enter the Survey ID wanted and click on "Get Database settings!"
That will populate, in an encrypted way, the text box "database settings (json):
And below this text box, you will find the two encryption keys (decrypted):
Now you can use these extra parameters in your command line for CmdQesExporter:
/encryptionkeyregulardata "the corresponding key for regular data"
/encryptionkeyanonymizeddata "the corresponding key for anonymised data"
A CmdQesExporter version 5.4.9 (or above) is mandatory to work with encrypted data. you can use the one used by your CCA. Simply copy the entire folder you can find in in "C:\Program Files (x86)\AskiaField\ExportService_localhost" on your side.
Each of these two keys is unique by survey. You need to check databaseSettings page for new survey you want to export data with CmdQesExporter.