Search found 60 matches

by yanina
May 26th, 2017, 2:55 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

Re: Export Data from Excel To CSPro Data Entry

Thank you Gregory Actually my question relate to topic that has been solved by Josh: Multiple Binary To One Occurrence Variable http://www.csprousers.org/forum/viewtopic.php?f=4&t=1920&p=6038#p6038 With Excel to CSPro, I want to build a dictionary from binary raw data. Can Excel to CSPro cre...
by yanina
May 26th, 2017, 2:34 am
Forum: Tools
Topic: Multiple Binary To One Occurrence Variance
Replies: 4
Views: 5453

Re: Multiple Binary To One Occurrence Variance

Aha . Marvelous ! marvelous ! Josh
Its worked.
For forum who want to know the solution with code given by Josh: Please see the batch program BinaryToOcc2.zip attached.

Thank you Josh :D

Yanin
by yanina
May 24th, 2017, 12:19 pm
Forum: Tools
Topic: Multiple Binary To One Occurrence Variance
Replies: 4
Views: 5453

Re: Multiple Binary To One Occurrence Variance

Thank you Josh.

I tried to put your code on my batch application but failed to compile.
Would you please take a look the attached file of my batch application
file: BinaryToOcc.zip.

Very thanks Josh

Yanin
by yanina
May 24th, 2017, 11:14 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

Re: Export Data from Excel To CSPro Data Entry

Yes Gregori

Indeed such enhanced tool. Awesome.

Does any option to make the column/variable in excel as Occurrence type ?

Yanin
by yanina
May 24th, 2017, 3:36 am
Forum: Tools
Topic: Multiple Binary To One Occurrence Variance
Replies: 4
Views: 5453

Multiple Binary To One Occurrence Variance

Hi Forum Gregori, Josh I have raw data that has many binary variables with value only 1 or 2. I = Yes and 2=No I want to build them on CSPro Data Entry, but to one single Occurrence Variable (CSPro Dictionary Format)? This is the example: Q1: What is your favorite color (Multiple Answer): 1. Red 2. ...
by yanina
May 15th, 2017, 5:53 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

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/download/details.aspx?id=53344 Install on my Windows 7 64 Bit SP1. Run Excel to CSPro. Done. No error anymore. The cases converted well...
by yanina
May 12th, 2017, 3:12 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

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
by yanina
May 10th, 2017, 2:39 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

Re: Export Data from Excel To CSPro Data Entry

Hi Gregory

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

Yanin
by yanina
May 9th, 2017, 5:03 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

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 ...
by yanina
May 6th, 2017, 1:54 am
Forum: Tools
Topic: Export Data from Excel To CSPro Data Entry
Replies: 13
Views: 14415

Export Data from Excel To CSPro Data Entry

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 ...