unable to export data

Discussions about tools to complement CSPro data processing
dmeo
Posts: 1
Joined: July 25th, 2017, 7:30 am

unable to export data

Postby dmeo » July 25th, 2017, 7:42 am

Hi
My data is in csdb format. I am trying to export the data into SPSS or excel. To do so, I follow the standard steps--I select the tab Tools in the menu bar. Then I select the export data, choose dictionary file after selecting all the check boxes. I then "run" it by clicking on the traffic light and select the data csdb file.
However I receive a message box saying that Run Batch Program has stopped working and the SPSS dataset is finally not generated.
Shall be thankful for any help in resolving the issue.
Thanks

josh
Posts: 1227
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: unable to export data

Postby josh » July 25th, 2017, 8:42 am

Sounds like a bug. Please send your data file to cspro@lists.census.gov.

arkagwa
Posts: 70
Joined: November 18th, 2014, 5:25 am

Re: unable to export data

Postby arkagwa » July 28th, 2017, 1:33 pm

Dear Josh

I have problem with data export from cspro to spss format using export tool. I am getting error the file created in not valid, unfortunately it was generated automatic with cspro 7 "Exported.dat and Exported.sps" . see attached error
Screenshot 2017-07-28 20.23.47.png
Screenshot 2017-07-28 20.23.47.png (152.1 KiB) Viewed 313 times

josh
Posts: 1227
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: unable to export data

Postby josh » July 28th, 2017, 3:27 pm

Try putting the exported.dat and exported.spss file in a different directory. Click on the "..." to browse a different directory on your computer.

arkagwa
Posts: 70
Joined: November 18th, 2014, 5:25 am

Re: unable to export data

Postby arkagwa » July 28th, 2017, 4:22 pm

Thanks this solution worked good.

bhayusufianto
Posts: 10
Joined: October 23rd, 2017, 2:33 am

Re: unable to export data

Postby bhayusufianto » November 3rd, 2017, 5:09 am

Dear Josh,
I am using CSpro 7.0. Previously I'v made it exporting csbd file to csv file for several times. However at this time, after click the traffic light, I got error message as shown in pict. After I clicked that error message, there come up following error message, saying "Record Type Length too large (...). Max is 9". I coundnt find any solution. Appreciate much you help.

Image

I've tried to reinstall CSpro and tried to export my csbd file to csv file, but the error message popped up again and I couldnt do file exporting.

bhayusufianto
Posts: 10
Joined: October 23rd, 2017, 2:33 am

Re: unable to export data

Postby bhayusufianto » November 3rd, 2017, 6:31 am

Dear Josh,

If I only select few records, here comes the the error message.
How can I figure out the "qualifier". Thank you

Image

bhayusufianto
Posts: 10
Joined: October 23rd, 2017, 2:33 am

Re: unable to export data

Postby bhayusufianto » November 3rd, 2017, 8:04 am

Dear Josh,

I got prompt reply from cspro@lists.census.gov (Gregory Martin). He advised me to move the dict file into another folder. After I did that, the exporting process worked very well...

Thank you.


Return to “Tools”