ijaraho wrote on Tuesday, August 27, 2013:
hi,
I made in my current database in site1 lot of configuration , so I don’t want to start new empty database in site2 from scratch.
So I import database of site1 to database in site2, then I deleted all patient (from openemr user interface) manually, but I want the database in site2 to start from number 1 not to continue of last number of the old database,
who I can it?
and if there is any thing else to delete?
Thank you.
blankev wrote on Tuesday, August 27, 2013:
If this is a Demo site, this quick and dirty advise might give the result. Go to Administration => Other => Database => Table patient_data => change the the relevant ID field starting with one for the first patient etc.
You can do this manual patient after patient in MyAdminPHP or export the file to your computer, import in spreadsheet program, change the field of choice starting by one and increment. Import the changed file back into the Database. Every patient will loose the correct connections with many connected tables, but the input of the past will not be unused as long as the ID is not out of range (Last couple of clients might have un empty connections and rest of Database with information connected to patients without ID might give disaster results since they can not connect the right fields with fields of other tables)
ADVISE: Don’t ever do this if it is not a Demo version. YOU MIGHT END UP WITH VERY ANGRY PROVIDERS AND CLIENTS!
ijaraho wrote on Tuesday, August 27, 2013:
It has been solved, because when I deleted all patients manually, openemr give me the first number for new patient is number 1
For example if the last number of the patients is 10, when you delete the last tow patients, then openemr give you for new patient number(pid) 9
thanks