RE: [Talk] Writing back to a spreadsheet

[Dwight Clevenger]

Paul, To take Vincents notion one step further,, the *.bds file is the 'helper' file used by BWS to keep track of configuration info and record tracking info. Once you have set up the report parameters within the Datastation component of BWS, the command D.REPORT used while your source file is still open will create a log file with the naming convention of your source file plus .log, and display the source file elements you requested.   Thanks,   Dwight Clevenger Senior System Analyst Baptist Health System 615 Soledad San Antonio, TX. 78213 210-297-1563 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 11/29/2004 02:22:28 PM >>> Thank you for the suggestions Vincent!  I was not aware of the report feature.     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Swisher, Vincent J. Sent: Monday, November 29, 2004 1:06 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] Writing back to a spreadsheet   Datastation creates a log file called <filename>.xls.bds  In this file are the statuses of each entry.  What you you could do is generate a report from datastation and import this into a spreadsheet.   Depending on how large you spreadsheet is, it could take a while to generate the report file.  I would suggest you be patient while the report is generating.   What I typically do is import my data into an Access Database and write the statuses directly to the database.  This is much easier and if the script needs to start over because of some issue with the screen, you don't have to wait while the script finds the last record you were on before the script stopped.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Brungardt Sent: Monday, November 29, 2004 2:00 PM To: [EMAIL PROTECTED] Subject: [Talk] Writing back to a spreadsheet I am writing a script pulling in info from a spreadsheet via datastation.  I would like to write a status of done next to each record and have the status show in the spreadsheet.  So far, I can not find a way to do that.  I can see the status while using datastation, but not while viewing the spreadsheet alone.  Anyone have a way of doing what I am trying to do? Thanks! Paul     Paul Brungardt Clinical Analyst HaysMedicalCenter PH: 785-623-2196 PG: 785-650-5989   See our web page at http://www.lahey.org for a full directory of Lahey sites, staff, services and career opportunities. THIS MESSAGE IS INTENDED FOR THE USE OF THE PERSON TO WHOM IT IS ADDRESSED. IT MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message and notify the sender so that we may correct our records. This email and any files transmitted with it may contain information that is PRIVILEGED AND CONFIDENTIAL. It is the property of the Baptist Health System and is intended only for the use of the intended recipient. If you have received this email in error, do not disseminate, distribute, forward, print or copy this email or any of its' attachments. Immediately destroy/purge the email and all attachments and notify the sender by reply of email. Any misuse/abuse may result in disciplinary action and/or legal liability. Unauthorized interception of this email is a violation of federal law.