Okay so here is what we do: Step 1: You will need to create a new Guided SQL Query from within DBMS for each dictionary you wish to get the data from. Via the guided sql query you will have to select each field you want to export. Step 2: Via DBMS there is a function/activity to download report to pc. Perform the steps to do this. When you do this you will enter what your delimiter will be. Step 3: If desired, If you absolutely want or need for the delimiter to be a tab then you open your file in an editor like Ultra Edit and replace your delimiters with a tab but be VERY CAREFUL not to replace a delimiter that actually might be apart of your fields value. It is my experience that you use a delimiter that will absolutely not be in any of the values in the fields such as a tilde ( ~ ) or a hat ( ^ ). Step 4: You will use Boston to read that file and apply the fields to your new system. Brian Stevenson | Systems Administrator
University Health System <http://www.universityhealthsystem.com/> | Business Information Services 355-2 Spencer Lane | San Antonio, TX 78229 Office | (210) 358 - 9282 Pager | (210) 756 - 0582 _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C. Blackwell Sent: Wednesday, May 21, 2008 3:36 PM To: [email protected] Subject: RE: [Talk] Transfering Dictionary information from GE Centricity OR product to Meditech using BWS Greetings, GE Centricity is a windows app - I've worked with it before. It's for the most part pretty "vanilla". I believe the suggestion below is the right one, do "something" in GE that extracts the information - I do not have any knowledge about GE's abilities here. Once extracted, you'll need to make sure it "matches up" with the Meditech screens. Meaning the data extracted can be keyed into Meditech successfully. A script can make data format changes (date, time) those sorts of things - or you can use Excel to format it ahead of time. Data entry into Meditech from a spreadsheet (or any other file format) should not be difficult at all - and perhaps folks on the list have dictionary update scripts already for what you're looking for. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian,Denise Sent: Wednesday, May 21, 2008 3:05 PM To: [email protected] Subject: RE: [Talk] Transfering Dictionary information from GE Centricity OR product to Meditech using BWS Has any one done this? if so which was more challenging Centricity or Meditech? _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Stevenson Sent: Wednesday, May 21, 2008 10:34 AM To: [email protected] Subject: RE: [Talk] Transfering Dictionary information from GE Centricity OR product to Meditech using BWS In my limited knowledge of Centricity I believe you will have to export your dictionaries in to excel spreadsheets and them have meditech import the data. Brian Stevenson | Systems Administrator University Health System <http://www.universityhealthsystem.com/> | Business Information Services 355-2 Spencer Lane | San Antonio, TX 78229 Office | (210) 358 - 9282 Pager | (210) 756 - 0582 _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian,Denise Sent: Wednesday, May 21, 2008 10:31 AM To: [email protected] Subject: [Talk] Transfering Dictionary information from GE Centricity OR product to Meditech using BWS We are in the process of implementing Meditech Magic 5.6.2 ORM. We would like to move inventory, physician cards, etc... from the current GE Centricity product to Meditech. Has anyone done this? If so how hard was it? Did you run into any difficulties? Denise Sebastian Sky Lakes Medical Center ----------------------------------------- CONFIDENTIALITY NOTICE: This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any use, dissemination, forwarding, distribution, or copying of the communication is strictly prohibited. Please notify the sender immediately by e-mail if you have received this by mistake and delete this e-mail from your system. (University Health System)
