Search found 1794 matches

by Gregory Martin
July 1st, 2013, 6:14 pm
Forum: Entry
Topic: get date on specific countdown or advance
Replies: 5
Views: 5562

Re: get date on specific countdown or advance

You could get the date 150 days ago by writing:
dateadd(sysdate("YYYYMMDD"),-150)
by Gregory Martin
July 1st, 2013, 5:45 pm
Forum: Entry
Topic: copy-pasting dictionary from Excel to CSPro
Replies: 4
Views: 7068

Re: copy-pasting dictionary from Excel to CSPro

It doesn't matter if your variables are capitalized. If you are copying the Names/Labels to Excel, remember that you can't insert or delete variables within Excel. The number of variables that you paste back in must match exactly the number that are in your dictionary.
by Gregory Martin
July 1st, 2013, 5:40 pm
Forum: Other
Topic: CSPro 4 - 5 compatibility
Replies: 3
Views: 6242

Re: CSPro 4 - 5 compatibility

The Unicode Text Converter doesn't take command line arguments at the moment. I can add this functionality if you would like. What task are you trying to accomplish?
by Gregory Martin
June 16th, 2013, 5:34 pm
Forum: Feature Requests
Topic: Option in CsPro 5 to keep ANSI data file as is
Replies: 3
Views: 5424

Re: Option in CsPro 5 to keep ANSI data file as is

Some people distribute UTF-8 files without the BOM and then hope that the software package can identify whether or not the file is UTF-8 or ANSI, but this is not an accurate solution 100% of the time. Also, say you have a 1.3 gigabyte data file, which is a possibility in CSPro. To check whether or n...
by Gregory Martin
June 11th, 2013, 7:25 pm
Forum: Tabulation
Topic: Exporting Field Notes to stata
Replies: 2
Views: 6451

Re: Exporting Field Notes to stata

How long are your strings? I don't have Stata on the current laptop I'm using so I can't test this, but I'm guessing that this is a Stata problem, not a CSPro problem. I tested exporting a 999 character string, and my Stata.dct file has the following code: infix dictionary using "C:\Users\Inset...
by Gregory Martin
June 11th, 2013, 4:51 pm
Forum: Entry
Topic: Why does some ROSTERs show a error message?
Replies: 3
Views: 4548

Re: Why does some ROSTERs show a error message?

We can better help diagnose your problem if you include your application on this forum and tell us how you can recreate this problem. From the error message it seems that you have an advance or move statement that is trying to go to an occurrence that does not exist. Are you using repeating subitems...
by Gregory Martin
June 11th, 2013, 4:43 pm
Forum: Entry
Topic: sub_dictionnary
Replies: 3
Views: 4919

Re: sub_dictionnary

As Arshad mentioned, the seek function may be useful to you. You can use that, or simply a do/while loop, to search for the eligible people in the household for which you want to enter data. You can either have a one-to-one correspondence for INDIVIDUAL_FRM and the household roster, in which case yo...
by Gregory Martin
June 11th, 2013, 1:00 pm
Forum: Entry
Topic: copy-pasting dictionary from Excel to CSPro
Replies: 4
Views: 7068

Re: copy-pasting dictionary from Excel to CSPro

When you paste it in you have to be careful to follow the format that exists when the value sets are copied to the clipboard. For instance, each value set much only be separated by one row in the Excel file for them to be copied over properly. I suggest that you copy them to the clipboard and paste ...
by Gregory Martin
June 11th, 2013, 10:09 am
Forum: Entry
Topic: Make ID unique
Replies: 1
Views: 2397

Re: Make ID unique

Can you clarify your question? Your code appears to add several numbers to the beginning of MAHO. You might consider writing your code like this, without all of the range checks: $ = tonumber ( maketext ( "%d%d%d%03d" ,matinh,mahuyen,maxa,$)); What is your concern with making the values un...
by Gregory Martin
June 11th, 2013, 9:45 am
Forum: Entry
Topic: Cspro import data
Replies: 6
Views: 6395

Re: Cspro import data

You have to follow the instructions that Arshad posted to convert the file from Excel format to a space-formatted text file. Then you must create a CSPro dictionary that describes that file. After that you can use in CSPro the data that was previously in Excel format.