Encounter number issue after importing data (solved)

We are using open emr 7 on linux with php 8.1

We have existing encounter info in open emr from when we used to use oemr.

I imported data from another ehr for our encounters. I made sure the import used encounter numbers after the last encounter number from the data already existing in oemr.

New encounters are using encounter numbers that start right after the old data. Which is causing new encounters to have the same encounter numbers as imported data.

It’s like oemr has stored some where what the last encounter number was that it used. Is there a way to get oemr to start numbering the encounters after the imported data encounter numbers?

Advance the sequences table to a new value.

@sjpadgett That seems to have done the trick. Thank you!

Do any of the other tables have the id number stored anywhere? I’m importing data to multiple tables.

Try search the database for tables with seq in name.

@sjpadgett , Yep, I found a few more. Thanks for the info!