Notifications
Clear all
Topic starter
So I've always used EMR 9.5 for developing my forms and whatnot. I upgraded my hard drive and had to reinstall everything. We have a boat load of custom obs terms that I had loaded in but now that I'm up and running again I have no way of installing those terms again since I no longer have the clinical kits. Is there some DB file or something I can transfer over from my old hard drive?
Posted : January 14, 2015 8:29 am
You upgraded your hard drive only ? You are still using EMR 9.5 Evaluation ? You should be able to copy over your Oracle database to the new hard drive, if you still have the old hard drive. I am not sure where the Oracle database resides (for EMR 9.5 Evaluation).
As a starting guess, I would look under C:\program files for the "Centricity EMR 9.5" folder. It should have a sub-folder, Oracle. Save your original "Centricity EMR 9.5/Oracle" folder. Then replace it with the Oracle folder from your old drive. See if that works.....
Anyone here with more database knowledge could let you know otherwise...so please chip in here.
- Beverly
Posted : January 14, 2015 1:43 pm
I don't have DB knowledge but you can down-load the lates obs terms from the GE website, that will contain any custom obs terms you have requested for your site as well as everyone elses that you can't get to.
Dawn Duschel
UAP Clinic
Posted : January 15, 2015 4:53 am
Topic starter
Really? I didn't realize my custom ones at some point became available to the world...
Posted : January 15, 2015 4:59 am
Do you have access to a running database where those custom obs terms have been loaded? If so, run a SQL query against OBSHEAD to find an obs term you know is one of your custom ones and see what the GROUPID field is. Our custom obs terms come back with a GROUPID of 50500001. You could then e-mail GE's email address where you request custom obs terms and see if they could get you a kit with all the obs terms that have that group ID. They might be able to do that even if you can't get your GROUPID. Don't know if they would do it but worth a shot.
You couldn't just load the results of the query directly into your new OBSHEAD table as there would not be a relationship for that GROUPID in HIERGRPS. If you are salty enough to insert that row correctly, then you might be able to update OBSHEAD. If you try it - make backups beforehand!
Posted : January 15, 2015 12:10 pm
