EXPORTATION ANOMALY

Discussions about tools to complement CSPro data processing
Forum rules
New release: CSPro 8.0
Post Reply
Dzidefo
Posts: 21
Joined: July 12th, 2017, 1:57 pm

EXPORTATION ANOMALY

Post by Dzidefo »

Dear Cspro User forum Team and Members

I have a problem and i'm going to try to expose it (I'm not englisgh, my official language is french !!!, excuse me if any fault)


I'm working on Economics census data in my country. We are on the cartography phase.
We are using android device to collect data and we used Cspro 7.0 to build the application.

When i export data to stata, i found anomaly in some records.

The anomaly is this: Say we have 5 variable Id, A, B, C, D, rigth
instead of having this format at the exportation:

Id A B C D
1 2 1 9 4
2 2 2 3 2
3 1 1 9 2

I have this anomaly:

Id A B C D
1 21 9 4
2 223 2
3 1 192


I precise that the anomaly affect some record and not all.
I don't understand anything :roll: :roll: . I 'm sure, i'm using the the right dictionnary.

the most difficult is that i have GPS variables in the application and some records of GPS
are separate between several fields (Item). eg; if the LAT is "6.12365478", I get "6" in the LAT item and ".12365478" in
field of the next item after the LAT Variable, so and so...

Until now, i discover 400 records on /62000 wich are affected by the anomaly.

Somebody can help me to find the causes of that anomaly ? and how to remedy it ?

A

Thank you at advance.
Attachments
AnormalData.xlsx
Sample of anomaly record after exportation
(42.94 KiB) Downloaded 301 times
sah
Posts: 97
Joined: May 28th, 2015, 3:16 pm

Re: EXPORTATION ANOMALY

Post by sah »

Could you kindly share the files so we can be able to sort you out.
Dzidefo
Posts: 21
Joined: July 12th, 2017, 1:57 pm

Re: EXPORTATION ANOMALY

Post by Dzidefo »

Thanks Sah,

I share excel file with my firts post
Ok, i attache it again on this post
Is it ok ?
Attachments
AnormalData.xlsx
anomaly record
(42.94 KiB) Downloaded 313 times
Post Reply