How to generate a new ID for existing patients via SQL or Java?

ssmusoke · February 9, 2016, 2:39am

I have made a change in the implementation from the Old OpenMRS ID without a check digit to the new OpenMRS ID with a check digit- my question is how to generate the new IDs via SQL or via Java code so that the patients have the new identifier

dkayiwa · February 9, 2016, 9:04am

How do you generate the new IDs? Randomly?

ssmusoke · February 9, 2016, 9:12am

@dkayiwa this is for the automatically generated ID with a check digit, how do I generate that?

dkayiwa · February 9, 2016, 9:25am

I think the registrationcore module is using https://wiki.openmrs.org/display/docs/Idgen+Module

darius · February 9, 2016, 1:50pm

@ssmusoke

Are you asking how to generate the ID numbers? Or if there’s an automatic way to generate these for all patients as a batch?

For generating, you should try to use the idgen module as @dkayiwa says. For bulk assignment, I think you’ll have to script this yourself.)

ssmusoke · February 9, 2016, 2:06pm

@darius I am looking at the latter, automatically generating the numbers for patients as a batch and adding them to the patients, as this will be common in our migrations.

Is there a best practice for doing such updates?