Page 1 of 1

Using External Dictionaries

Posted: March 27th, 2020, 4:59 pm
by Eohmer
Hello!

For a questionnaire, I need to have an External dictionary with certain information of different people stored in. For example, I want the external dictionary to have this random information:

Name: Steven
Phone: 12345678
Color: Blue
ID: 987654321

Name: Alex
Phone: 12345678
Color: Red
ID: 987156782

How do I save this information manually in the external dictionary (should Name, Phone, Colo, ID be Records? or Items in the Id Items?) and what functions should I use in the Logic to extract this information? (if, for example, I needed to have the name Steve or the phone stored in a variable for ease of reading purposes.)

I've been trying but I still don't understand how the Locate, Find, Retreive functions work.

Thanks.

Re: Using External Dictionaries

Posted: March 27th, 2020, 6:44 pm
by josh
1) Put your data in an Excel file.
2) Use Excel2CSPro to create a CSPro dictionary and data file from your Excel spreadsheet
3) In your CSPro logic use the function loadcase() to look up the data.

Check out page 42 of the workshop materials: https://www.csprousers.org/resources/CS ... rkshop.pdf
Here is a video tutorial: https://www.census.gov/library/video/cs ... files.html