Export Data from Excel To CSPro Data Entry

Discussions about tools to complement CSPro data processing
Forum rules
New release: CSPro 8.0
yanina
Posts: 60
Joined: October 31st, 2016, 9:37 am

Export Data from Excel To CSPro Data Entry

Post 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
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Export Data from Excel To CSPro Data Entry

Post by josh »

Use the Excel2CSpro tool from the tools menu. Look at the help in that tool for details on how to use it.
yanina
Posts: 60
Joined: October 31st, 2016, 9:37 am

Re: Export Data from Excel To CSPro Data Entry

Post 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
Attachments
excel_to_cs.PNG
excel_to_cs.PNG (97.87 KiB) Viewed 10156 times
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Export Data from Excel To CSPro Data Entry

Post 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.
yanina
Posts: 60
Joined: October 31st, 2016, 9:37 am

Re: Export Data from Excel To CSPro Data Entry

Post by yanina »

Hi Gregory

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

Yanin
yanina
Posts: 60
Joined: October 31st, 2016, 9:37 am

Re: Export Data from Excel To CSPro Data Entry

Post 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
Attachments
error_2007.png
error_2007.png (74.06 KiB) Viewed 10122 times
sah
Posts: 97
Joined: May 28th, 2015, 3:16 pm

Method Not Found

Post by sah »

Hello Folks,
Any clue on how to solve Method Not Found......, when exporting Excel to CSPro data with CSPro 7.

Thanks
sah
Posts: 97
Joined: May 28th, 2015, 3:16 pm

Re: Export Data from Excel To CSPro Data Entry

Post by sah »

Folks, I think the problem is related to net framework. For windows 7 sp the problem persist. Guess it will be resolve
yanina
Posts: 60
Joined: October 31st, 2016, 9:37 am

Re: Export Data from Excel To CSPro Data Entry

Post 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
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Export Data from Excel To CSPro Data Entry

Post by Gregory Martin »

I'm glad that the answer was so simple. I hope you find use in the enhanced tool.
Post Reply