Easiest way to convert data from Ona to .dta format

[pratik purohit]

Hi Community,

I need help in converting the data downloaded from Ona in any format to .dta format for STATA. It would be a lot helpful to know the quickest way to convert. Thanks for you support.

[Evans from Ona]

This message was sent to the following 2 people: pratik purohit, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Pratik, You could any of the below options: You could try to save a .csv file then just open the .csv file in SPSS and go to Save As in the file menu. It should automatically select .sav as the default file type. Use an online converter such as this one Please let me know if you require any further support. Regards, Evans

Evans from Ona

On Fri, Sep 23, 2022 at 04:33 PM, "pratik purohit" <pratik6...@gmail.com> wrote:

Hi Community, I need help in converting the data downloaded from Ona in any format to .dta format for STATA. It would be a lot helpful to know the quickest way to convert. Thanks for you support.

-- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/44d1ecb5-7a11-429c-9933-364e899b73d3n%40googlegroups.com.

[ronald munjoma]

Hi Pratik.

Take a look at ODK META 

https://github.com/PovertyAction/odkmeta

And also ODK Split 

https://ideas.repec.org/c/boc/bocode/s458579.html

Best

Ronald

On Fri, 23 Sep 2022, 15:33 pratik purohit, <pratik6...@gmail.com> wrote:

Hi Community,

I need help in converting the data downloaded from Ona in any format to .dta format for STATA. It would be a lot helpful to know the quickest way to convert. Thanks for you support.

--

[Evans from Ona]

This message was sent to the following 2 people: pratik purohit, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Pratik, I did try to prepare an export in SAV format a few minutes ago and it worked. Could you please let me know if it's working for you? Regards, Evans

Evans from Ona

On Fri, Sep 23, 2022 at 05:12 PM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Pratik, You could any of the below options: You could try to save a .csv file then just open the .csv file in SPSS and go to Save As in the file menu. It should automatically select .sav as the default file type. Use an online converter such as this one Please let me know if you require any further support. Regards, Evans

On Fri, Sep 23, 2022 at 04:33 PM, "pratik purohit" <pratik6...@gmail.com> wrote: Hi Community, I need help in converting the data downloaded from Ona in any format to .dta format for STATA. It would be a lot helpful to know the quickest way to convert. Thanks for you support. -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/44d1ecb5-7a11-429c-9933-364e899b73d3n%40googlegroups.com.

[janet mwennde]

I have tried preparing SAV export since last week, but it is not working any solution?

Best,

Janet

[Samson from Ona]

This message was sent to the following 2 people: janet mwennde, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Janet Please note SAV format can fail if you have special characters in the name column on either survey sheet or choices sheet. The following rules apply to forms whose data is to be exported in SAV format: The last character of a variable name cannot be a period (.) or underscore (_) Use of special characters like > ( ) = . - is not allowed The first character must be a letter or the character @ Have a look at this guide for more information on valid SPSS characters. Regards, Samson

Samson from Ona

On Thu, Nov 10, 2022 at 01:38 AM, "janet mwennde" <jmwe...@gmail.com> wrote:

I have tried preparing SAV export since last week, but it is not working any solution? Best, Janet On Monday, September 26, 2022 at 10:40:22 AM UTC+1 Evans from Ona wrote: This message was sent to the following 2 people: pratik purohit, ona-co...@googlegroups.com. Replying to this email will notify them. Hello Pratik, I did try to prepare an export in SAV format a few minutes ago and it worked. Could you please let me know if it's working for you? Regards, Evans

https://ci4.googleusercontent.com/proxy/qARj9KTnDFu-xYPmVG5zhZowl7Q8nQEGl5ky426n686QFaijeo-5K5jNk3iUI4hjxrk0CQ0EcNuI6Ynkg1FaqL2Aek5_VODDgbNNmp4DLNuIuQx3vlkZMLj7VamoMcJqg7fC=s0-d-e1-ft#https://ona.intercom-mail.com/avatars/4576969/square_128/fullsize-1612166207.jpg Evans from Ona

On Fri, Sep 23, 2022 at 05:12 PM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote: Hello Pratik, You could any of the below options: You could try to save a .csv file then just open the .csv file in SPSS and go to Save As in the file menu. It should automatically select .sav as the default file type. Use an online converter such as this one Please let me know if you require any further support. Regards, Evans On Fri, Sep 23, 2022 at 04:33 PM, "pratik purohit" <pratik6...@gmail.com> wrote: Hi Community, I need help in converting the data downloaded from Ona in any format to .dta format for STATA. It would be a lot helpful to know the quickest way to convert. Thanks for you support. -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/44d1ecb5-7a11-429c-9933-364e899b73d3n%40googlegroups.com. -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/683fc63a-2645-4c25-9cbc-9a2f9d248edfn%40googlegroups.com.

[kpop4d ggwp]

Mari Join sekarang juga di situs slot online terbaik hanya
di Kpop4d dengan minimal deposit cukup hanya Rp 5.000 saja anda sudah dapat bermain di semua permainan yang telah kami sediakan yaitu Slot online, casino
online, togel online ,tembak ikan dan kami juga sedang mempersiapkan permainan sportbook
bagi anda semua pecinta bola online

https://tlcbogotanj.org

[Wilson Ochieng]

Hi Samson,

I am not able to understand how the system erroneously added 40 interviews to my submitted data recorded under a certain RA not deployed in that particular area while, at the same time, close look at my data reveal similarities with another set of data submitted by a different RA. Please reach out because now I have about 40 unwanted interviews and I need to delete that before I can download the dataset.

Regards,

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/884b0875-00554a69-1668073801-63366200324377%40ona.intercom-mail-150.com.

[Evans from Ona]

This message was sent to the following 2 people: Wilson Ochuka, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Wilson, Thank you for contacting us. Ona Data cannot submit or add records erroneously. It is close to impossible for data to be added to a form without a user's intervention so I'm not entirely sure how you ended up with 40 additional records on your form. Was any editing of records/submissions done on the platform after data was collected? Regards, Evans

Evans from Ona

On Thu, Nov 17, 2022 at 09:20 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Samson, I am not able to understand how the system erroneously added 40 interviews to my submitted data recorded under a certain RA not deployed in that particular area while, at the same time, close look at my data reveal similarities with another set of data submitted by a different RA. Please reach out because now I have about 40 unwanted interviews and I need to delete that before I can download the dataset. Regards, On Thu, Nov 10, 2022 at 12:50 PM 'Samson from Ona' via Ona Community <ona-co...@googlegroups.com> wrote: This message was sent to the following 2 people: janet mwennde, ona-co...@googlegroups.com. Replying to this email will notify them. Hello Janet Please note SAV format can fail if you have special characters in the name column on either survey sheet or choices sheet. The following rules apply to forms whose data is to be exported in SAV format: The last character of a variable name cannot be a period (.) or underscore (_) Use of special characters like > ( ) = . - is not allowed The first character must be a letter or the character @ Have a look at this guide for more information on valid SPSS characters. Regards, Samson

https://ona.intercom-mail.com/avatars/1081318/square_128/amwata_photo-1499773530.jpg Samson from Ona

-- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/884b0875-00554a69-1668073801-63366200324377%40ona.intercom-mail-150.com.

-- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/CAMq7G9s-2ogHDgztm0BarizyB6%3DvQsLF6uGB2FmDvxU13H2PzA%40mail.gmail.com.

[Wilson Ochieng]

Hi Samson,

Apparently that is my situation right now. I have 40 redundant entries. Since I had 51 RAs collecting data from different localities, I created a cascade list for RA for every locality such that if you are RA X working in locality A, once you pick your locality then you will only see the list of RAs from that particular place but  from the download it shows they were entered by an RA working in a different locality from the one he was assigned. This is not possible at a user level. Would you like me to share more details?

Wilson

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/1b34a52a-2e648bd1-1668669614-63366200325404%40outbound.intercom.ona.io.

[Evans from Ona]

This message was sent to the following 2 people: Wilson Ochuka, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Wilson, It still seems like the issue is related to how the data was entered by the data collectors. Not really a bug per se on our platform. Bearing in mind that it is possible for a user to send more than one submission for the same area since we don't prevent duplicate submissions. You can share more details but I would request you share the project, in which the form is located, with onasupport and assign a Can Edit permission level to enable us to look into the issue. Once you have shared the project, please let us know the account name, project name, and form title. We would also request you share two sample records that appear to have the same data (redundant entries) so that we can try to examine the two from the back end and see whether there are any issues. Regards, Evans

Evans from Ona

On Thu, Nov 17, 2022 at 10:27 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Samson,

Apparently that is my situation right now. I have 40 redundant entries. Since I had 51 RAs collecting data from different localities, I created a cascade list for RA for every locality such that if you are RA X working in locality A, once you pick your locality then you will only see the list of RAs from that particular place but from the download it shows they were entered by an RA working in a different locality from the one he was assigned. This is not possible at a user level. Would you like me to share more details? Wilson

On Thu, Nov 17, 2022 at 10:20 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, Thank you for contacting us. Ona Data cannot submit or add records erroneously. It is close to impossible for data to be added to a form without a user's intervention so I'm not entirely sure how you ended up with 40 additional records on your form. Was any editing of records/submissions done on the platform after data was collected? Regards, Evans

On Thu, Nov 17, 2022 at 09:20 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

[Wilson Ochieng]

Thank you Samson.

I agree it is possible that an RA can do double entry however, it is not possible that an RA without permission to collect data in a particular study site e.g site A can submit data from that site where he has no right coz it is restricted by cascade list.

Thanks,

Wilson

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/6189be97-d0aa57e0-1668671117-63366200325404%40outbound.intercom.ona.io.

[Evans from Ona]

This message was sent to the following 2 people: Wilson Ochuka, ona-co...@googlegroups.com. Replying to this email will notify them.

That makes sense but we would need to look at the form structure as well as the data collected to ascertain this. Please share the form as well as the records that seem to have discrepancies.

Evans from Ona

On Thu, Nov 17, 2022 at 10:51 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Thank you Samson. I agree it is possible that an RA can do double entry however, it is not possible that an RA without permission to collect data in a particular study site e.g site A can submit data from that site where he has no right coz it is restricted by cascade list. Thanks,

Wilson

On Thu, Nov 17, 2022 at 10:45 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, It still seems like the issue is related to how the data was entered by the data collectors. Not really a bug per se on our platform. Bearing in mind that it is possible for a user to send more than one submission for the same area since we don't prevent duplicate submissions. You can share more details but I would request you share the project, in which the form is located, with onasupport and assign a Can Edit permission level to enable us to look into the issue. Once you have shared the project, please let us know the account name, project name, and form title. We would also request you share two sample records that appear to have the same data (redundant entries) so that we can try to examine the two from the back end and see whether there are any issues. Regards, Evans

On Thu, Nov 17, 2022 at 10:27 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Samson,

Apparently that is my situation right now. I have 40 redundant entries. Since I had 51 RAs collecting data from different localities, I created a cascade list for RA for every locality such that if you are RA X working in locality A, once you pick your locality then you will only see the list of RAs from that particular place but from the download it shows they were entered by an RA working in a different locality from the one he was assigned. This is not possible at a user level. Would you like me to share more details? Wilson

On Thu, Nov 17, 2022 at 10:20 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, Thank you for contacting us. Ona Data cannot submit or add records erroneously. It is close to impossible for data to be added to a form without a user's intervention so I'm not entirely sure how you ended up with 40 additional records on your form. Was any editing of records/submissions done on the platform after data was collected? Regards, Evans

On Thu, Nov 17, 2022 at 09:20 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

[Wilson Ochieng]

Hi Evans,

The project name is B&M Consult KE, form name is Household Survey Final. I will appreciate it if this can be expedited quickly.

Thanks

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/182de340-e2c8f363-1668671637-63366200325404%40outbound.intercom.ona.io.

[Evans from Ona]

This message was sent to the following 2 people: Wilson Ochuka, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Wilson, Thank you for sharing the project and form. We have been able to access it. Could you point us to the specific data that seems to have an issue? Regards, Evans

Evans from Ona

On Thu, Nov 17, 2022 at 11:02 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Evans, The project name is B&M Consult KE, form name is Household Survey Final. I will appreciate it if this can be expedited quickly. Thanks

On Thu, Nov 17, 2022 at 10:53 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

That makes sense but we would need to look at the form structure as well as the data collected to ascertain this. Please share the form as well as the records that seem to have discrepancies.

On Thu, Nov 17, 2022 at 10:51 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Thank you Samson. I agree it is possible that an RA can do double entry however, it is not possible that an RA without permission to collect data in a particular study site e.g site A can submit data from that site where he has no right coz it is restricted by cascade list. Thanks,

Wilson

On Thu, Nov 17, 2022 at 10:45 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, It still seems like the issue is related to how the data was entered by the data collectors. Not really a bug per se on our platform. Bearing in mind that it is possible for a user to send more than one submission for the same area since we don't prevent duplicate submissions. You can share more details but I would request you share the project, in which the form is located, with onasupport and assign a Can Edit permission level to enable us to look into the issue. Once you have shared the project, please let us know the account name, project name, and form title. We would also request you share two sample records that appear to have the same data (redundant entries) so that we can try to examine the two from the back end and see whether there are any issues. Regards, Evans

On Thu, Nov 17, 2022 at 10:27 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Samson,

Apparently that is my situation right now. I have 40 redundant entries. Since I had 51 RAs collecting data from different localities, I created a cascade list for RA for every locality such that if you are RA X working in locality A, once you pick your locality then you will only see the list of RAs from that particular place but from the download it shows they were entered by an RA working in a different locality from the one he was assigned. This is not possible at a user level. Would you like me to share more details? Wilson

On Thu, Nov 17, 2022 at 10:20 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, Thank you for contacting us. Ona Data cannot submit or add records erroneously. It is close to impossible for data to be added to a form without a user's intervention so I'm not entirely sure how you ended up with 40 additional records on your form. Was any editing of records/submissions done on the platform after data was collected? Regards, Evans

On Thu, Nov 17, 2022 at 09:20 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

[Wilson Ochieng]

Check the data collected in Migori county and submitted by Jasper and Timothy Lent, you will realise that the actual and original entries are those from Jasper while the extra 40 from Timothy Lent indicated to have been collected from Migori are redundant of what Jasper collected. Please do not interfere with the data collected in Siaya by Timothy Lent, only focus on the ones collected in Migori.

Thanks

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/7cc0dda8-409f5354-1668675125-63366200325404%40outbound.intercom.ona.io.

[Evans from Ona]

This message was sent to the following 2 people: Wilson Ochuka, ona-co...@googlegroups.com. Replying to this email will notify them.

I have taken a look at the data and there doesn't seem to be any evidence that points to the fact that the system itself submitted redundant records. I'm sorry but it doesn't really seem to be an issue related to a bug or glitch on the platform.

Evans from Ona

On Thu, Nov 17, 2022 at 12:14 PM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Check the data collected in Migori county and submitted by Jasper and Timothy Lent, you will realise that the actual and original entries are those from Jasper while the extra 40 from Timothy Lent indicated to have been collected from Migori are redundant of what Jasper collected. Please do not interfere with the data collected in Siaya by Timothy Lent, only focus on the ones collected in Migori. Thanks

On Thu, Nov 17, 2022 at 11:52 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, Thank you for sharing the project and form. We have been able to access it. Could you point us to the specific data that seems to have an issue? Regards, Evans

On Thu, Nov 17, 2022 at 11:02 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Evans, The project name is B&M Consult KE, form name is Household Survey Final. I will appreciate it if this can be expedited quickly. Thanks

On Thu, Nov 17, 2022 at 10:53 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

That makes sense but we would need to look at the form structure as well as the data collected to ascertain this. Please share the form as well as the records that seem to have discrepancies.

On Thu, Nov 17, 2022 at 10:51 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Thank you Samson. I agree it is possible that an RA can do double entry however, it is not possible that an RA without permission to collect data in a particular study site e.g site A can submit data from that site where he has no right coz it is restricted by cascade list. Thanks,

Wilson

On Thu, Nov 17, 2022 at 10:45 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, It still seems like the issue is related to how the data was entered by the data collectors. Not really a bug per se on our platform. Bearing in mind that it is possible for a user to send more than one submission for the same area since we don't prevent duplicate submissions. You can share more details but I would request you share the project, in which the form is located, with onasupport and assign a Can Edit permission level to enable us to look into the issue. Once you have shared the project, please let us know the account name, project name, and form title. We would also request you share two sample records that appear to have the same data (redundant entries) so that we can try to examine the two from the back end and see whether there are any issues. Regards, Evans

On Thu, Nov 17, 2022 at 10:27 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote:

Hi Samson,

Apparently that is my situation right now. I have 40 redundant entries. Since I had 51 RAs collecting data from different localities, I created a cascade list for RA for every locality such that if you are RA X working in locality A, once you pick your locality then you will only see the list of RAs from that particular place but from the download it shows they were entered by an RA working in a different locality from the one he was assigned. This is not possible at a user level. Would you like me to share more details? Wilson

On Thu, Nov 17, 2022 at 10:20 AM, "Evans Ochieng Onyango" <evans.ochi...@ona.intercom-mail.com> wrote:

Hello Wilson, Thank you for contacting us. Ona Data cannot submit or add records erroneously. It is close to impossible for data to be added to a form without a user's intervention so I'm not entirely sure how you ended up with 40 additional records on your form. Was any editing of records/submissions done on the platform after data was collected? Regards, Evans

On Thu, Nov 17, 2022 at 09:20 AM, "Wilson Ochuka" <ochieng...@gmail.com> wrote: