David,
There are two fundamental approaches for doing what you ask. But both
take advantage of D("Status") and the .BDS file
Approach #1 - use d("Status") and optionally DataStation reports.
Have your script set and evaluate against D("Status") - if you start up
a new Rules script and select the Data entry from File template you'll
see this in action.
The DataStation report can make an exact copy of your original
spreadsheet + the Status field.
Approach #2 - this still uses D("Status") in the exact same way as
above, except that when you create the command to open the spreadsheet,
you must check off "direct update" option.
Then a Status column will be added to your spreadsheet. I saw a post a
minute ago that describes how to force a save to the worksheet on
demand.
Which to choose? Well, my personal preference is approach #1, unless the
spreadsheet has other workbooks etc and having all the data together in
the original source spreadsheet is important.
Approach 1 is easier and will run just a tick faster because you're not
writing back to Excel. You end up with 2 files at the end - the original
spreadsheet and a copy that mimics exactly the original spreadsheet -
nothing an D.Archive command (or a VBA Kill command won't solve).
Thom C. Blackwell
Vice President, Technical Services
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Bronze Sponsors of the McKesson Insight Conference. Visit us in booth
201.
Learn about what we do <http://www.youtube.com/watch?v=Fbjk_4LUZYU>
Please follow us on Facebook
<http://www.facebook.com/pages/Boston-Software-Systems/122739774403349?>
and Twitter! <http://twitter.com/Bossoft>
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]]
Sent: Tuesday, August 30, 2011 4:55 PM
To: Talk
Subject: [talkbws] Saving Excel updates in DataStation
Hello,
I need to process a large file of credits from an Excel workbook into
STAR. I'll be updating each row in the file with a status reflecting the
failure/success of each transaction.
Is there a way to save the status updates back to Excel without waiting
until the script gets to D.Close_ ? If the script hangs up for some
reason and has to be restarted, I have to be 100% that transactions are
not applied more than once.
Thanks!
David Garcia
Sr. Programmer/Analyst
Washington Hospital, Fremont California
(510) 745-6477
--- 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
