Page 1 of 1

Problem with Excel to Cspro

Posted: September 1st, 2015, 2:46 pm
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,

Re: Problem with Excel to Cspro

Posted: September 1st, 2015, 3:40 pm
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.

Re: Problem with Excel to Cspro

Posted: September 1st, 2015, 6:10 pm
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,