using pycspro library to retrieve parse dictionary and cases from csweb
Posted: September 6th, 2022, 2:01 pm
Hi, I am working on a data visualization solution with the pycspro library.
As a reminder, this library takes as parameters a dictionary and a list of cases. I manage to find the dictionaries deployed in csweb in a table named cspro_dictionaries, the cases are in a table with the name of the corresponding dictionary suffixed with _dict (Example: household_dict) with a column named questionnaire hosting a hexadecimal information in blob format. Ie believe this information represents the cases of cspro. But how to decode this information in order to use it together with the dictionary to parse the data with the pyscpro library.
This problem has been bothering me for more than a month. Thanks for your help.
As a reminder, this library takes as parameters a dictionary and a list of cases. I manage to find the dictionaries deployed in csweb in a table named cspro_dictionaries, the cases are in a table with the name of the corresponding dictionary suffixed with _dict (Example: household_dict) with a column named questionnaire hosting a hexadecimal information in blob format. Ie believe this information represents the cases of cspro. But how to decode this information in order to use it together with the dictionary to parse the data with the pyscpro library.
This problem has been bothering me for more than a month. Thanks for your help.