commcare
I need to have the commcare-user case type exist for all my users in my domain so I can export their location ids. Is there a way to trigger commcare to create the commcare-user cases for existing users?
It looks like if I add user case management to a form the user case gets created when that form is submitted. But for existing users I'd like to not have to rely on them submitting a form.
For this, you can leave the Case Management tab as "does not use cases." This controls the cases of the case type you've selected in your module.
The User Case will automatically be loaded into your form when you choose a form that has User Case setup.
The export tool can't export users, groups or organisations (locations) but you could use a mapping table to lookup the location or supervisor info based on the user_id.
You could do this by adding a Mappings sheet to your export query that contains the lookup table.
Here is an example of what your query sheet might look like:
We've defined two fields, Location and Supervisor which both reference user_id. We've also added a Mappings sheet as follows:
For each user_id value we have mapped them to the Location and the Supervisor.
When the export is run it will do the lookups the final export will contain the mapped values.
To get the data for the Mappings sheet you can use the user export and organisations (locations) export from CommCare HQ.
Best Answer
Nick, it looks like once user-as-a-case is enabled for the domain, usercases will be created whenever a user is saved. I realize this isn't ideal. You can manually trigger this for an individual user in the UI by making a trivial change (and changing it back, if needed), or similarly in a bulk user upload. It does look like when user-as-a-case is enabled, there should be a bulk action to add cases for all existing users, although this may not happen immediately.