It's possible they are closing the file too early. I will have to check on it but unfortunately (or fortunately) it is a monthly process so I won't be able to troubleshoot what they "really" do until the middle of next month. Thanks for your help. Frank
>>> On 1/27/2009 at 10:51 AM, <[email protected]> wrote: Greetings, I just created a similar situation on my pc – 10,000 row fixed length file + DataStation report set to export to Excel. I was able to get the report to execute successfully, with a larger file, it does take some time to complete. Any chance something is closing the instance of BWS while the report is running? Give the support folks a call to investigate further! Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com ( http://www.bossoft.com/ ) Sign up for my weekly webinar! ( http://www.bostonworkstation.com/customer_center/special_events.aspx ) 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, January 27, 2009 11:17 To: Talk Subject: [talkbws] Data Station Report File 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 --- 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
