1. Not knowing how you are reading the excel file, through BWS or through code, but you can update the excel file via code real-time. When you reach the end of the routine you can add code there or call another custom sub to update the record. If you are reading through BWS though I am not sure how to identify the record, cell, etc. I actually do 90% of my scripts in VB Code since I have a lot more control that way and it tends to be a little easier to read. 2. Even if you placed code to check to make sure you are connected to the Excel file your end user will be affected since if there is no connection to the excel object when you do connect the excel object will pop up front and if the users clicks on something else as soon as you connect again you will have the same situation. Maybe BWS knows another way of doing that; this is just my experience. I run all my scripts on dedicated servers. Brian Stevenson | Systems Administrator University Health System <http://www.universityhealthsystem.com/> | Business Information Services 8131 Pinebrook Drive | San Antonio, TX 78230 (210) 321 - 3167 :: Office (210) 203 - 9851 <mailto:[email protected]> :: Pager (210) 602 - 5792 :: Cell From: [email protected] [mailto:[email protected]] Sent: Thursday, April 23, 2009 10:53 AM To: [email protected] Subject: [talkbws] Scripting Recommendations I am new to BWS scripting and have written a few scripts that remain in IT. I am in the process of turning a script over to non-IT end-users and am wondering if some things are possible: 1. This script reads an excel file and executes a process in Meditech. When each record is processed, it updates the status field as "Processed". My problem - if the script bombs half way thru the spreadsheet the excel spreadsheet doesn't update that status fields until the "Wrap Up" step in the script so I don't know which records are processed and which need to be processed. How can I have the script update the status field "realtime" so if something happens we can see what row is causing the issue? 2. When I turn the script over to the end-users, is there something that needs to be included in the script that will allow them to continue working on non-script related tasks? When I run the script, I watch the process to make sure all errors, issues are resolved. I don't want to turn this over to the end-users and tell them that their computer cannot be used during the execution of the script. I'd would prefer them to be able to continue on with their daily tasks. Is there a recommendation for turning over scripts to end-users? Any help you are able to provide is appreciated.
Thanks! ________________________________ CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipient(s) named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender at the electronic mail address noted above and destroy all copies of this communication and any attachments. Thank you for your cooperation. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx ----------------------------------------- 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) --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
