Avoiding duplicate records

Dear all,
I have a form which should be submitted on a daily basis, so i need to avoid duplicating data of the same "date "and “site” (date and site are part of the form’s questions).

let me know if this is not clear and to provide more details.

Many thanks,

Joao

Dear Marcel,

Are you conversant with Stata? For you to achieve this there are certain parameters one needs to consider before calling a data duplicates. Using Stata to deal with duplicates issues is a lot easier and efficient.

Best wishes,

···

On Tue, Aug 7, 2018 at 3:21 PM, Marcelo &JM marcelo...@gmail.com wrote:

Dear all,
I have a form which should be submitted on a daily basis, so i need to avoid duplicating data of the same "date "and “site” (date and site are part of the form’s questions).

let me know if this is not clear and to provide more details.

Many thanks,

Joao

You received this message because you are subscribed to the Google Groups “KoBoToolbox Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Hi Marcelo,

The server does not check for those kind of duplicates, once a record is saved, a unique _uuid is created, which is used to avoid duplicates on submission.

For your case, maybe you can create a concat instance field, used to save the form, under settings sheet, you can add a new column (instance_name) then enter concat(string(today()),’-’,’${date},’-’,${site}), so each submission will have this as its default name. When you export the data in either csv/excel, there’ll be this column “meta/instanceName” that you can use to check for duplicates, or;

If you are good in R, you can use the duplicates function…

···

On Tue, Aug 7, 2018 at 5:21 PM, Marcelo &JM marcelo...@gmail.com wrote:

Dear all,
I have a form which should be submitted on a daily basis, so i need to avoid duplicating data of the same "date "and “site” (date and site are part of the form’s questions).

let me know if this is not clear and to provide more details.

Many thanks,

Joao

You received this message because you are subscribed to the Google Groups “KoBoToolbox Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Regards,

Jonathan Munene

+254 714 345 760

https://muneneg.github.io/resume/

Hi Marcelo,

You can easily use this to check for duplicates in R:

https://muneneg.github.io/articles/2018-07/r-check-dups-df

···

On Tue, Aug 7, 2018 at 5:21 PM, Marcelo &JM marcelo...@gmail.com wrote:

Dear all,
I have a form which should be submitted on a daily basis, so i need to avoid duplicating data of the same "date "and “site” (date and site are part of the form’s questions).

let me know if this is not clear and to provide more details.

Many thanks,

Joao

You received this message because you are subscribed to the Google Groups “KoBoToolbox Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Regards,

Jonathan Munene

+254 714 345 760

https://muneneg.github.io/resume/

Check the servers maybe will be fine okay…

···

Em 07/08/2018 17:20, “Jonathan Munene” munene...@gmail.com escreveu:

Hi Marcelo,

You can easily use this to check for duplicates in R:

https://muneneg.github.io/articles/2018-07/r-check-dups-df

You received this message because you are subscribed to the Google Groups “KoBoToolbox Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

On Tue, Aug 7, 2018 at 5:21 PM, Marcelo &JM marcelo...@gmail.com wrote:

Dear all,
I have a form which should be submitted on a daily basis, so i need to avoid duplicating data of the same "date "and “site” (date and site are part of the form’s questions).

let me know if this is not clear and to provide more details.

Many thanks,

Joao

You received this message because you are subscribed to the Google Groups “KoBoToolbox Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.


Regards,

Jonathan Munene

+254 714 345 760

https://muneneg.github.io/resume/