Retrieve case ID in the case in form which creates case (Data export tool)

Users
1

Hi All,
I have a form which creates a case. Manually a case name is entered.
Now in data export tool I want to write the case id created to link the
form to the case.

In my case the using the case name would not work, as this is supposed to
be a unique integer, but due to manual adding double case id's can be made.
Do I miss something or does somebody have an idea how to achieve this?

Jos

2

Now a little further, I have seen that the Excel export option does have a
'info.caseid'. for the registration form, Is there an equivalent to be used
for the data export tool when storing to SQL? I do not see it mentioned in
the references page:
https://wiki.commcarehq.org/display/commcarepublic/Export+field+reference

Note: I could create a workaround by adding a UUID field in the
registration form and add this to the case properties, but it looks like
the info is already in there, you just need to right syntax to retrieve it.

Jos

ยทยทยท On Thursday, 12 October 2017 17:59:26 UTC+2, Jos van der Ent wrote: > > > Hi All, > I have a form which creates a case. Manually a case name is entered. > Now in data export tool I want to write the case id created to link the > form to the case. > > In my case the using the case name would not work, as this is supposed to > be a unique integer, but due to manual adding double case id's can be made. > Do I miss something or does somebody have an idea how to achieve this? > > > Jos >
3

I have found the solution. I sharing the solution in case anyone else is
wondering a similar challenge:
by adding 'form.case.@case_id' to the Excel export file you retrieve the
case id.

Jos