The easiest way is to create a custom NPR that will output your data from Meditech in an "excel" format such as tabbed or comma separated format. Name your output with a .xls extension, and it will be useable as your data source from the outset.
Thank you, Mitch Lawrence Lead Applications Analyst Technical Support - NPR/Automation CHRISTUS Information Management *: [email protected] <mailto:[email protected]> ________________________________ From: [email protected] [mailto:[email protected]] Sent: Monday, June 29, 2009 6:42 PM To: [email protected] Subject: [talkbws] Help getting Started I am new to BWS and have only written a couple scripts using an excel file to start. Now I want to move onto bigger/better projects. The first project I am trying to tackle is answering a query within BAR for a list of accounts that fail a specific claim check. I can run the failed claims report out of Meditech, import it into Excel, reformat the data into something readable, and then run the script from the excel file. The script itself is going to be easy and I get how to do that. The problem I am having is the work to run the report and reformat the data in Excel for the script to use takes longer than just doing the job. I guess the part I need help with is best practice recommendations for 'gathering' the source data from Meditech when it changes every day. Do you use BWS to run the report, import it into Excel, reformat the data, and then manipulate it however you need? Do you attempt to run the report in MT to screen and read off the screen of one session and work in another? Do you attempt to run the report in MT to the screen and read off the screen; move all the data off to variables in BWS and then work off that variable file? Other suggestions? Any pity and help is greatly appreciated. Thanks!! Amber Holcombe Applications Analyst, Patient Accounts Olympic Medical Center Phone: (360)417-7124 Fax: (360)417-7342 "Excellence is not a skill. It is an attitude." ~ Ralph Marston ------------------------------------------------------------------------ - Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended individual(s) named above and may contain confidential, privileged, and/or protected information. Any unauthorized review, use, disclosure, copying, or distribution of its contents is prohibited. If you are not the intended recipient, you have received this email in error. If so, please notify the sender immediately by reply email and delete/destroy the original and all copies of this communication. Also know that Internet e-mail is not secure. In choosing to communicate with Olympic Medical Center by email you will assume these confidentiality risks. Internet messages may become corrupted, incomplete, or may incorrectly identify the sender.
<<image001.jpg>>
<<image002.jpg>>
