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
Export Data from Excel To CSPro Data Entry
Re: Export Data from Excel To CSPro Data Entry
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
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
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 (97.87 KiB) Viewed 10700 times
-
- Posts: 1801
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Export Data from Excel To CSPro Data Entry
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
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
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 (74.06 KiB) Viewed 10666 times
Method Not Found
Hello Folks,
Any clue on how to solve Method Not Found......, when exporting Excel to CSPro data with CSPro 7.
Thanks
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
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
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
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
-
- Posts: 1801
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Export Data from Excel To CSPro Data Entry
I'm glad that the answer was so simple. I hope you find use in the enhanced tool.