I am creating animated maps related to a couple of public health projects on Dengue and Zika. All our data is stored in Commcare, and then we can download it as an excel file, with all the data and headers (column titles). So, if we need to create maps at any point, we have to simply export the data from commcare into excel, then convert that into a csv and join it to a shapefile of Iquitos called 'Noviembre_P01' (which contains the 'LOC_CODE' field on which is based the join with the 'loc_code' field in the csv file). The csv file is called 'project_2_gis_mapping'.

I want to automate this process of the attribute tables in qgis getting updated everytime I export this data from Commcare into excel as a csv file.

In the entire csv file, I have one column/field of interest - 'first_bloo'. I have created 1 additional column in my attribute table with this same name.

From my understanding, it seems that writing a Macros code will help me achieve this. Please can someone help with the Macros code for the same? Or, is there an easier/more efficient way of achieving this process?

closed as too broad by ahmadhanb, whyzar, PolyGeo Jun 21 '17 at 1:38

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged or ask your own question.