HH Roster to single case file

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
prabhustat
Posts: 72
Joined: March 17th, 2012, 10:46 am

HH Roster to single case file

Post by prabhustat »

Hi

Let me know, how to convert a Household roster to single case file in a batch file mode. Also, I want create a case id (HH id + member id).

Thanks advance.

Prabhu
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: HH Roster to single case file

Post by aaronw »

There area a few steps involved:
  1. Add HOUSEHOLD_MEMBER_NUMBER to roster (if it doesn't already exist)
  2. Create and run batch that fills the field with the curocc for each person in the roster
  3. Export the the data file to CSV (see below for settings)
  4. Create new dictionary with HOUSEHOLD_MEMBER_NUMBER as id item
  5. Convert CSV to an Excel file
  6. Use Excel to CSPro to read in Excel file and convert to the new dictionary's format
This process will give you a data file with:
  1. Id items ..., household number, household member number
  2. Each person (from roster) as its own case
  3. Each person's case will also include the singly occurring dwelling record data (in my example)
export.PNG
export.PNG (37.48 KiB) Viewed 2072 times
Post Reply