Bad record type

Discussions about CSEntry
Post Reply
AriSilva
Posts: 259
Joined: July 22nd, 2016, 3:55 pm

Bad record type

Post by AriSilva » September 7th, 2019, 10:37 am

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?)
Attachments
BadRecodType_Conversion.PNG
BadRecodType_Conversion.PNG (9.65 KiB) Viewed 350 times
BadRecodType_1.PNG
BadRecodType_1.PNG (122.14 KiB) Viewed 350 times
BadRecodType_2.PNG
BadRecodType_2.PNG (122.78 KiB) Viewed 350 times
Best
Ari

aaronw
Posts: 190
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Bad record type

Post by aaronw » September 9th, 2019, 4:54 pm

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.

AriSilva
Posts: 259
Joined: July 22nd, 2016, 3:55 pm

Re: Bad record type

Post by AriSilva » September 10th, 2019, 11:11 am

Attached the dictionary and the csdb.
Best
Ari

aaronw
Posts: 190
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Bad record type

Post by aaronw » September 10th, 2019, 2:40 pm

Hey Ari, I don't see the attachments.

AriSilva
Posts: 259
Joined: July 22nd, 2016, 3:55 pm

Re: Bad record type

Post by AriSilva » September 11th, 2019, 1:39 pm

Attachements
See them now?
Best
Ari

aaronw
Posts: 190
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Bad record type

Post by aaronw » September 12th, 2019, 2:57 pm

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

Post Reply