Error when export cases

[Tuan]

Hi Members

Have tried to export cases from cspro to spss but not all cases were exported from cspro. Does anyone has same issue and how to resolve....
Best
Tuan

[josh]

Look at the log file generated when you do the export to see if it contains any error messages.

[Tuan]

Dear Josh

Many thanks for your information. There was no error in the export report. The problem was with files that made on tablet but cannot open on laptop due to some unknown errors. After I re-index the file it worked on laptop but cause that error when export. Some time it creates more records than what is actually show on tablet....

Best
Tuan

[Tuan]

HI Members

To be more clear, I have 30 cases on tablet but when export to spss I can see only 20 cases... Where are these 10 cases go.... does anyone has same issue and ...

Many thanks

Best
tuan

[naylinnsoe]

Hi Tuan,

I also faced that type of problem.
I want to tell u how I solved it. I can't promise this can solve your problem or not.
First of all,I want to explain about Data Structure of CSPro

1. As you know CSPro saved it's data in .dat file. e.g "mm 20 clt tablet 1 data.dat"
2. In data file the structure is as follow.

record type value,id itmes, data in record.
e.g if you have 6 records in cspro and ID itmes are qid,psu_id
data is as follow.

for qid=0021 and psu_id=005

10021005 followed by data in first record.
20021005 followed by data in second record.
30021005 followed by data in third record.
40021005 followed by data in fourth record.
50021005 followed by data in fifth record.
60021005 followed by data in sixth record.

To test the data file is correct or not.

First count how many records are used in that cspro program(NOTE : this method is not correct if you used roaster feature ). Don't count (id item) pink color, count blue color records only.
Open your cspro data file "*.dat" with text editor. I recommend UltraEdit software.
If you used 6 records, the data for 30 cases must have 180 rows like above format.
If the data file contain more than or less than 180 rows check which row is not necessary and it make error.
Delete that error row and test export again.

But DON'T FORGET TO BACKUP before you test.
Thanks,

Nay Lin Soe
Myanmar
+959450014629

[Tuan]

Hi Nay Lin
Many thanks for your advice. Only I use roster thus the data looks different...and cannot identify which part is an error. When I used index feature of cspro it say it repaired something but when export it is same. I was thinking this is due to unicode problem where I use CaseID as alpha string ...

Anyways, many thanks for your valued advice.

Best
Tuan