As far as number 1 below you could have it say "Processed " & [a variable with the mnemonic of the record being processed] for the status. I run multiple scripts, but on 2 machines designated for scripts only, so my keystrokes don't interfere with the scripts.
Dave Shelby (916) 734-3004 [email protected] [email protected] 04/23/2009 08:53 AM Please respond to [email protected] To [email protected] cc 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 --- 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
