rpl121 wrote on Tuesday, July 29, 2014:
If you’re brave, maybe try a MySQL command something like this (don’t trust
me – test it yourself):
update openemr_postcalendar_events set c_aid = X where c_aid = Y;
X and Y are just the provider IDs you want to exchange. You can further
limit this by date of the event if you wish. You can accomplish all in a
fraction of a second command if you do it right, I think.
On Mon, Jul 28, 2014 at 7:06 PM, Pieter W blankev@users.sf.net wrote:
Administration => Other => Database now you are in PhpMyAdmin => Locate
table Users (last page of tables)
Locate User ID: Usually Admin is User 1 and the other doctors are
something like 6 or 18
Find the ID of HolydayDoctor, Find the ID of NewDoctor
Locate Tabel: openemr_postcalendar_events
Locate: column pc-aid now comes the tricky part…* be aware and know
what you should do!*
Change after date of entrance of NewDoctor all pc_aid for HolydayDoctor
into NewDoctorID
In demo version http://demo.open-emr.org:2105/ (the change is there till
reset of the DEMO)
All admin (pc-aid = 1) agenda appointments were transfered to pwb (pc_aid
= 4 )
Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202506/
To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/