How to check for duplicates

#1

Hello all,

I have been working to find a way to check for duplicates. It took me a
while to find a solution and a couple of posts here in the group helped me
(see the links below). I attached the file for others who need it.

Thanks

https://code.google.com/p/opendatakit/issues/detail?id=894
https://groups.google.com/forum/#!topic/opendatakit/oRx1uXnd4RQ

CheckForDuplicate.xls (26.5 KB)

#2

Much better solution than the one I came up with! Thanks for sharing.

#3

Enhanced solution attached

CheckForDuplicate2.xls (26.5 KB)

#4

Nice one. Thanks for sharing!

Here is another one that doesn't use indexed-repeat (since indexed-repeat
isn't supported yet in Enketo) and performs the check as a constraint:

In Action: https://u507s.enketo.org/webform (temporary link)
XLSForm: https://docs.google.com/a/enketo.org/spreadsheets/d/1O9ECbdY7wRpZqxsIjNSySgwXgttBIR_pfaLwtOaMnpA/edit#gid=550584070

··· On Thursday, January 1, 2015 8:29:07 AM UTC-7, james.b...@gmail.com wrote: > > Much better solution than the one I came up with! Thanks for sharing.

--

Revolutionizing data collection since 2012.

Enketo https://enketo.org/ | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/enketo | Twitter https://twitter.com/enketo
| Blog http://blog.enketo.org/

#5

Hi Rofand

Is it possible to prevent a user selecting a select_one question more than once have some logic in the XLS to prevent duplicates of that variable

··· On Tuesday, January 13, 2015 at 3:20:28 PM UTC+3, Rofand K wrote: > Enhanced solution attached
#6

Thanks Martijn
I am facing errors when using the Enketo webform.
To duplciate the error

  • Add ID 1
  • Then add ID 2
  • Then add ID 1
  • Then Save: it says error
  • Go back and correct the Last ID and Make it 3
  • Try saving. It still gives errors.
  • Edit and change all IDs to 8, 9 ,10 and try saving:
  • Still error comes

Thoughts ?
Vivek

··· On Friday, 2 January 2015 21:05:12 UTC+5:30, Martijn van de Rijdt wrote: > > Nice one. Thanks for sharing! > > Here is another one that doesn't use indexed-repeat (since indexed-repeat > isn't supported yet in Enketo) and performs the check as a constraint: > > In Action: https://u507s.enketo.org/webform (temporary link) > XLSForm: > https://docs.google.com/a/enketo.org/spreadsheets/d/1O9ECbdY7wRpZqxsIjNSySgwXgttBIR_pfaLwtOaMnpA/edit#gid=550584070 > > > On Thursday, January 1, 2015 8:29:07 AM UTC-7, james.b...@gmail.com wrote: >> >> Much better solution than the one I came up with! Thanks for sharing. > > > -- > *Revolutionizing data collection since 2012.* > > Enketo | LinkedIn > | GitHub > | Twitter > | Blog >
#7

Ouch! Yes I see. My technique was embarrassingly flawed! Please discard it.
Sorry about that.

··· On Tue, Jan 6, 2015 at 11:23 PM, Vivek Gupta wrote:

Thanks Martijn
I am facing errors when using the Enketo webform.
To duplciate the error

  • Add ID 1
  • Then add ID 2
  • Then add ID 1
  • Then Save: it says error
  • Go back and correct the Last ID and Make it 3
  • Try saving. It still gives errors.
  • Edit and change all IDs to 8, 9 ,10 and try saving:
  • Still error comes

Thoughts ?
Vivek

On Friday, 2 January 2015 21:05:12 UTC+5:30, Martijn van de Rijdt wrote:

Nice one. Thanks for sharing!

Here is another one that doesn't use indexed-repeat (since indexed-repeat
isn't supported yet in Enketo) and performs the check as a constraint:

In Action: https://u507s.enketo.org/webform (temporary link)
XLSForm: https://docs.google.com/a/enketo.org/spreadsheets/d/
1O9ECbdY7wRpZqxsIjNSySgwXgttBIR_pfaLwtOaMnpA/edit#gid=550584070

On Thursday, January 1, 2015 8:29:07 AM UTC-7, james.b...@gmail.com wrote:

Much better solution than the one I came up with! Thanks for sharing.

--
Revolutionizing data collection since 2012.

Enketo https://enketo.org/ | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/enketo | Twitter https://twitter.com/enketo
| Blog http://blog.enketo.org/

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/klseBnzgSb4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Revolutionizing data collection since 2012.

Enketo https://enketo.org/ | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/enketo | Twitter https://twitter.com/enketo
| Blog http://blog.enketo.org/

#10

Hi,
I try both the CheckForDuplicate2 and the CheckForDuplicate2 but not sure why it not work for me. I use ODK Collect version 1.21.2. Does anyone have experience this, pls help.
1/ Add group: 1->dont add group-> Save
Add group: 2->dont add group-> Save
Add group: 1->dont add group-> Save
-> not duplicate detected
2/ Add group: 1-> Add group: 2-> Error

CheckForDuplicate.xls (32.5 KB)
CheckForDuplicate2.xls (32.5 KB)