Copying data from external file to current dictionary

Discussions about creating CAPI applications to run on Android devices
Forum rules
New release: CSPro 8.0
Post Reply
daudi
Posts: 1
Joined: January 3rd, 2018, 1:19 am

Copying data from external file to current dictionary

Post by daudi »

Fellow CSpRo/CS entry users,

I'm using cspro 7.1 and 1 have an external file/look up file with 9
columns in Excel containing household membership with each household
having different numbers of household members.
I'm doing a panel survey and I would like to pre-fill the rows of a
Roster with this info (household member characteristics) in the
external file before allowing enumerators to add in new members who
joined the various households since last survey. I have allowed the
Roaster to have maximum of 30 rows. I have unique IDs for every
household (see attached).

Kindly guide me with a code that I can use...; I envisage that once a
numerator fills in the unique ID of the household e..g. 1420, then
when she/he reaches the Roaster, then the Roster is already prefilled
with names of household members and so they only enter new household
members and their details.
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Copying data from external file to current dictionary

Post by khurshid.arshad »

Dear Daudi;

Please see attached example.
Dummy Households 101 and 102.
Best.
a.
Attachments
Test4_7.0 - Copy.rar
(13.45 KiB) Downloaded 363 times
Post Reply