Bad record type

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
AriSilva
Posts: 591
Joined: July 22nd, 2016, 3:55 pm

Bad record type

Post 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?)
Attachments
BadRecodType_Conversion.PNG
BadRecodType_Conversion.PNG (9.65 KiB) Viewed 3212 times
BadRecodType_1.PNG
BadRecodType_1.PNG (122.14 KiB) Viewed 3212 times
BadRecodType_2.PNG
BadRecodType_2.PNG (122.78 KiB) Viewed 3212 times
Best
Ari
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Bad record type

Post 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.
AriSilva
Posts: 591
Joined: July 22nd, 2016, 3:55 pm

Re: Bad record type

Post by AriSilva »

Attached the dictionary and the csdb.
Best
Ari
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Bad record type

Post by aaronw »

Hey Ari, I don't see the attachments.
AriSilva
Posts: 591
Joined: July 22nd, 2016, 3:55 pm

Re: Bad record type

Post by AriSilva »

Attachements
See them now?
Best
Ari
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Bad record type

Post 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 2921 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