Search & Select Exact ID

Support
1

Hi All,

I have a preload form where I am using unique IDs from an external system.
So, I have Contact A with ID as 12345ABC and Contact B with ID as 1
2345ABc. Notice 'C" is the only difference with lower and upper case.
When the form pulls data For contact A, it goes on to reference contact B
with other details.

Would there be a way to search and select exact matches in a preload?

Many thanks in advance

Adah

2

I don't understand the question. The IDs are different, so they should
match different data records -- they should not share the same data record
when used as a lookup key.

Are you seeing some other behavior?

Are you sure your external application/itemset does not confound these two
ID values by doing a case-insensitive compare?

··· On Fri, Feb 6, 2015 at 8:53 AM, Adakole Kennedy wrote:

Hi All,

I have a preload form where I am using unique IDs from an external system.
So, I have Contact A with ID as 12345ABC and Contact B with ID as 1
2345ABc. Notice 'C" is the only difference with lower and upper case.
When the form pulls data For contact A, it goes on to reference contact B
with other details.

Would there be a way to search and select exact matches in a preload?

Many thanks in advance

Adah

--

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 the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

Hi Mitch,

Thank you. I do have an odd behaviour in that the when Contact A is selected, the follow on details are for contact B. When I look behind the names I find that they both have the same IDs but differentiated with upper and lower case. This is where the problem lays.

I hope this is a bit more descriptive?

Kind Regards

Adah

··· On Friday, 6 February 2015 16:53:48 UTC, Adakole Kennedy wrote: > Hi All, > > > I have a preload form where I am using unique IDs from an external system. So, I have Contact A with ID as 12345ABC and Contact B with ID as 12345ABc. Notice 'C" is the only difference with lower and upper case. When the form pulls data For contact A, it goes on to reference contact B with other details. > > > Would there be a way to search and select exact matches in a preload? > > > Many thanks in advance > > > Adah
4

Is the data extraction using the ODK external itemset functionality? If
not, you need to work with whomever wrote that software.

Is this a standard build of ODK Collect? If not, you will need to first
work with the organization that provided your the customization.

If it is the standard build of ODK Collect, does the problem exist if you
delete the /sdcard/odk directory (all the forms and data on the device) and
install the very latest version of ODK Collect (1.4.5)?

We would need the smallest example form and dataset (CSV) that demonstrates
this issue in order to proceed.

The ODK software does not intentionally ignore the case of the text strings
when doing string comparisons, so I suspect it is the external application
or a problem with the processing of the external itemset values.

Mitch

··· On Mon, Feb 9, 2015 at 4:16 AM, akennedy@camfed.org wrote:

Hi Mitch,

Thank you. I do have an odd behaviour in that the when Contact A is
selected, the follow on details are for contact B. When I look behind the
names I find that they both have the same IDs but differentiated with upper
and lower case. This is where the problem lays.

I hope this is a bit more descriptive?

Kind Regards

Adah

On Friday, 6 February 2015 16:53:48 UTC, Adakole Kennedy wrote:

Hi All,

I have a preload form where I am using unique IDs from an external
system. So, I have Contact A with ID as 12345ABC and Contact B with ID as
12345ABc. Notice 'C" is the only difference with lower and upper case. When
the form pulls data For contact A, it goes on to reference contact B with
other details.

Would there be a way to search and select exact matches in a preload?

Many thanks in advance

Adah

--

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 the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com