Page 1 of 1

Bad record type

Posted: September 7th, 2019, 10:37 am
by AriSilva
One of the interviewers got this message (bad record type on questionnaire...).
In fact there are two interviews with this problem.
I do not know how this happened. By trying to look at the questionnaires the DataViewer issued the attached messages.
I tried to convert the csdb into .dat in order to save the questionnaires, but it did not work, the conversion ignored the bad records (see attached message).
When the csdbfile was sent to the server, the two bad record types came blank (empty).
Is there a way to save these records? (unable to attach the .rar file containing the csdb. Can I send it any other way?)

Re: Bad record type

Posted: September 9th, 2019, 4:54 pm
by aaronw
I suspect there is a difference between the dictionary embedded in the data file and the one being used to synchronize. Send the data file with the bad record and the dictionary being used to synchronize to cspro@lists.census.gov.

Re: Bad record type

Posted: September 10th, 2019, 11:11 am
by AriSilva
Attached the dictionary and the csdb.

Re: Bad record type

Posted: September 10th, 2019, 2:40 pm
by aaronw
Hey Ari, I don't see the attachments.

Re: Bad record type

Posted: September 11th, 2019, 1:39 pm
by AriSilva
Attachements
See them now?

Re: Bad record type

Posted: September 12th, 2019, 2:57 pm
by aaronw
Looking at the two cases in a SQLite viewer I can see that there is a newline before each name. So line 5 starts with a name and not the record number. I changed the data, but you can see the format. Line 4 and 5 should be on a single line like line 6.
newline.PNG
newline.PNG (4.1 KiB) Viewed 2965 times
I'm not sure how this happened. If you have any idea let us know. I will email you the corrected data file (and have removed the attachments).