Export Data from Excel To CSPro Data Entry

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

Export Data from Excel To CSPro Data Entry

Postby yanina » May 6th, 2017, 1:54 am

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

Re: Export Data from Excel To CSPro Data Entry

Postby josh » May 6th, 2017, 8:20 am

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

Postby yanina » May 9th, 2017, 5:03 am

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 678 times

Gregory Martin
Posts: 832
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Export Data from Excel To CSPro Data Entry

Postby Gregory Martin » May 9th, 2017, 7:32 am

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

Postby yanina » May 10th, 2017, 2:39 am

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

Postby yanina » May 12th, 2017, 3:12 am

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 644 times

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

Method Not Found

Postby sah » May 13th, 2017, 8:38 am

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

Thanks

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

Re: Export Data from Excel To CSPro Data Entry

Postby sah » May 13th, 2017, 10:51 am

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

Postby yanina » May 15th, 2017, 5:53 am

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: 832
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Export Data from Excel To CSPro Data Entry

Postby Gregory Martin » May 19th, 2017, 1:10 pm

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


Return to “Tools”