CSPro Users Forum

Hello colleagues,

Please assist us onthe following queries:
Problem:
Loading the GPS coordinates into the CSPro application using listing dictionary for the menu program.
When CSPro convert the excel file into the CSPro.dat file, the coordinates are not coming out correctly and most of the items shift position, when the listing dictionary is structured into a single record, since conversion of the Excel file to .dat only works with a single record dictionary and the listing dictionary is a multiple record dictionary.
- Should we use the external dictionary?
We would like to develop an application that can be used for GIS mapping and use the information and upload the dwelling units coordinates into the tablets for household enumeration during the Census2021. So that enumerators can already have the DU pin for each eligible structure to be interviewed during the Census 2021.

Thanks in advance.

I don't think that the problem is that the record is multiplying occurring. Excel2CSPro can handle multiple records just fine. If two rows in the spreadsheet have the same case ids they will be added to the same case.

Maybe you can send your dictionary and your input spreadsheet so that we can see the problem.