Odkmeta input csv format

Yes, except for this error: "today variable survey_date could not be converted using the mask MDY"
Half of the variable labels are missing and the other half are a copy of the variable name.

The do-file has to run to completion without any error to succeed. odkmeta formats date/time variables before attaching labels. Since the do-file resulted in an error while formatting those variables, it hadn't started its labeling work yet. The labels you see may just be the ones autogenerated by insheet.

It sounds like you need to update the locals at the top of the do-file. The help file describes the purpose of those:

The do-file starts with the definitions of several local macros; these are constants that the do-file uses. For instance, local macro `datemask' is the mask of date values in the .csv files. The local macros are automatically set to default values, but they may need to be changed depending on the data.

If that doesn't work, I recommend checking that you have raw, unmodified data from the NGO. For example, if you open a .csv file in Excel and save it, even without making other changes, that can reformat dates and times.

In the do-file I also see that not all the variable values have quotation marks.

Note that if a value label does not contain a space, it usually doesn't need to be enclosed by quotes.

Hope that helps!

2 Likes