Hi all,
I have a script opens a very large file and updates STAR patient accounts from
information in the file. I have it set up to report the status of each record
in an Excel file but the spreadsheet is not always generated. >From my
observation, the larger the input file the less likely the Excel report will
generate.
Script Functionality:
Open file script: D.Open_ F("strTheSourceFile"), ftFixedLength,
"C:\Bss70\Scripts\BlahBlah\BlahBlah.bds"
Process records:
Update the status: D("Status")="DONE" & D("Status")="ERROR"
Run the report and close the file: D.Report & D.Close_
End the script
Here is what I know:
The files are large (8,000 - 10,000 lines +)
The Excel file does generate on our smaller test files
After a large file runs through the script, I may get 5 - 10 .bds files (*.bds,
*.bds1, *.bds2, etc...)
My question is... Is it possible to create the spreadsheet earlier in the
script and update it periodically rather than wait until the end of the script?
Any help would be appreciated but realize that I am a novice and will likely
need coaching if the resolution is complicated.
Frank
---
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
