CSPro Users Forum

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

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)