Problem with Excel to Cspro

Discussions about CSEntry
Post Reply
htuser
Posts: 687
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Problem with Excel to Cspro

Post by htuser »

Dear Cspro developer team,
"This tools only work with single record dictionaries" What's the message that i always receive when i try to use this tools.
Do you think a next release will support multiple record dictionaries?
Sincerely,
G.VOLNY, a CSProuser from Haiti, since 2004
josh
Posts: 2403
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Problem with Excel to Cspro

Post by josh »

SInce the purpose of the tool is mainly to create lookup files the single record limitation hasn't been seen as a big deal. We may in the future support multiple records but it isn't a high priority.

For now if you want to import multiple records then you can create copies of your dictionary with only one record each, use CSPro2Excel to generate data files, concatenate the data files together and do a record sort. It is a bunch of extra work but it is a pretty rare case to use CSPro2Excel for multiple record dictionaries.
htuser
Posts: 687
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: Problem with Excel to Cspro

Post by htuser »

Thank you Josh i think the Cspro community should give you a gold medal for your precious help!
Using it for multiple records dictionaries is the way for me to transform old SPSS, Excel, Access datasets to Cspro format, for example, in the event of an update (longitidunal surveys). I thing native RDBMS support in the future can solve this problem.
Regards,
G.VOLNY, a CSProuser from Haiti, since 2004
Post Reply