RE: [Talk] DATA STATION

[Rich McNeil]

Title: DATA STATION

I've been following this discussion, and I thought I'd insert what we had in mind with Boston DataStation.  Our basic Learning tools reduce the time and effort of script development by 50 to 90 percent, but did nothing in particular about the typical day of scripting and 100 lines code associated with file handling.    "How fast, simple and small can this be done?"  The DataStation is our response to this question.  Mickey's example does it in 6 lines (5 lines actually since the Close isn't necessary), and it needn't take more than a few minutes to accomplish it.   The Status field is used here to make sure that a transaction is not entered twice, so that if a script is halted in the middle, it will skip all the previously "Done" records and pick up where it left off.  In addition, it allows a user to go into a completed file (using the DataStation's editor), fix any bad records and retry them.  This is all tied into a reporting system and an archiving system, that takes a file from from it birth to its final disposition.   Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mickey Sherbett Sent: Friday, February 27, 2004 10:17 AM To: [EMAIL PROTECTED] Subject: RE: [Talk] DATA STATION Below is the way we are using for Reading a delimited file. Notice the IF D (“Status”) <> “Done”.  This was in the Online Documentation under Boston Workstation 6.5. But I looked at the Flat File Sample on the Web Site the  IF D(“Status”) <> “Done is not in the sample script. I guesss I do not understand the Status and how the .bds file works yet.   Wait 1 D.Open_ "C:\Myfiles\Scripts\IVLISTS\log\carts.txt", ftDelimited Do     If D("Status") <> "Done" Then         Stable 0, 3         Wait 1         Enter D("CART")         D("Status") = "Done"     End If     D.Next_ Loop Until D.EOF D.Close_ Wait 1     Thanks,   Mickey Sherbett, Senior Analyst DCH Regional Medical Center                809 University Blvd. E. Tuscaloosa Al. 35401                         205-759-7167 [EMAIL PROTECTED]     The information contained in this email message is confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible to deliver it to the intended recipient, the reader is hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Stolle Sent: Friday, February 27, 2004 8:31 AM To: '[EMAIL PROTECTED]' Subject: RE: [Talk] DATA STATION   Mickey,             I assume you have an IF statement saying not to do the record if it has a status of DONE.  Change the IF statement to run if it doesn’t have a status of like DONE2 and after writing the file change the status from DONE to DONE2.   Ross Stolle Integration Engineer Avera McKennan Hospital Sioux Falls, SD       -----Original Message----- From: Mickey Sherbett [mailto:[EMAIL PROTECTED] Sent: Friday, 27 February, 2004 8:07 AM To: [EMAIL PROTECTED] Subject: RE: [Talk] DATA STATION   Yes we do a D.Close_ after we finished the Do Loop.   I did not see an extra Open.  It seems to be accessing the .bds file which had the record number and a Status of Done, which causes the Do Loop to do nothing.   Thanks,   Mickey Sherbett, Senior Analyst DCH Regional Medical Center                809 University Blvd. E. Tuscaloosa Al. 35401                         205-759-7167 [EMAIL PROTECTED]     The information contained in this email message is confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible to deliver it to the intended recipient, the reader is hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Corinna Robertson Sent: Thursday, February 26, 2004 2:06 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] DATA STATION   you more than likely have an extra open, every time you open the file it goes back to the first record   Thanks, Corinna Robertson   Boston Software Systems [EMAIL PROTECTED] www.bostonworkstation.com The Essential Tool for Healthcare Integration  866-653-5105 x 8 603-598-5122     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mickey Sherbett Sent: Thursday, February 26, 2004 11:36 AM To: [EMAIL PROTECTED] Cc: Rich McNeil; Jeff Lee Subject: [Talk] DATA STATION Rich,         We just incorporated the Data Station in the new 6.5 Script we wrote to read a delimited data file.         The first time we run it, it processed the file and all the records.   When we called it up and ran it a second time it hung at the point        where we should have open the file and started reading the same records again.         Have I missed something? Thanks, Mickey Sherbett, Senior Analyst DCH Regional Medical Center                809 University Blvd. E. Tuscaloosa Al. 35401                                 205-759-7167 [EMAIL PROTECTED]   The information contained in this email message is confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible to deliver it to the intended recipient, the reader is hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.   ____________________ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.