Page 1 of 2

Export Data from Excel To CSPro Data Entry

Posted: May 6th, 2017, 1:54 am
by yanina
Hi Gregory, Josh

I have data in csv/xlxs format. Data entry using Excel.
Can I export it to CSPro Data Entry ?

For example on my excel files: the column header/variable name are:
Case_id
Q1
Q2

Rather than do data entry on excel, I want to do it with CSPro.
I believe its need some converting, create Dictionary etc.

Would you please give me guide how to do this please ?
Thank you very much.

Regards,
Yanin

Re: Export Data from Excel To CSPro Data Entry

Posted: May 6th, 2017, 8:20 am
by josh
Use the Excel2CSpro tool from the tools menu. Look at the help in that tool for details on how to use it.

Re: Export Data from Excel To CSPro Data Entry

Posted: May 9th, 2017, 5:03 am
by yanina
Thank you Josh.

Worked well, with this step:
1. Create Dictionary from Excel : with version 7 Beta (ahaa .. this beautiful tools I love it)
2. Excel to CSPro : CSPro version 7 Beta (failed, get Error messege)
With version 6.3 : OK (this amazing too)
Then with version 6.3 I got the data. Then Create application with 7 Beta. Done. I am satisfied enought

Please advice with Excel to CSPro v 7 Beta ?

Yanin

Re: Export Data from Excel To CSPro Data Entry

Posted: May 9th, 2017, 7:32 am
by Gregory Martin
Can you send your Excel file to cspro@lists.census.gov? I wrote both the 6.3 and 7.0 tools, so I would like to fix any problems with them.

Re: Export Data from Excel To CSPro Data Entry

Posted: May 10th, 2017, 2:39 am
by yanina
Hi Gregory

Thank you
I have just email the file to cspro@lists.census.gov.

Yanin

Re: Export Data from Excel To CSPro Data Entry

Posted: May 12th, 2017, 3:12 am
by yanina
Hi Gregory

Just for your update, above file I made on Excel 2010 and
I tried with Excel 2007 and different error as attached.
This error appear when I select the excel file, I don't even select the dictionary yet.

Yanin

Method Not Found

Posted: May 13th, 2017, 8:38 am
by sah
Hello Folks,
Any clue on how to solve Method Not Found......, when exporting Excel to CSPro data with CSPro 7.

Thanks

Re: Export Data from Excel To CSPro Data Entry

Posted: May 13th, 2017, 10:51 am
by sah
Folks, I think the problem is related to net framework. For windows 7 sp the problem persist. Guess it will be resolve

Re: Export Data from Excel To CSPro Data Entry

Posted: May 15th, 2017, 5:53 am
by yanina
Dear Gregory

Yes, what Sah suggested is right. Thank you Sah.

I downloaded latest Microsoft .NET Framework 4.6.2 (Offline Installer) https://www.microsoft.com/en-us/downloa ... x?id=53344
Install on my Windows 7 64 Bit SP1.

Run Excel to CSPro. Done. No error anymore. The cases converted well.

Yanin

Re: Export Data from Excel To CSPro Data Entry

Posted: May 19th, 2017, 1:10 pm
by Gregory Martin
I'm glad that the answer was so simple. I hope you find use in the enhanced tool.