RE: [Talk] DATA STATION

[Ross Stolle]

Title: DATA STATION

Mickey,             Towards the end of the script you are setting the D(“Status”) field to “DONE”, therefore the IF statement is FALSE and the records are not done.  Try this…   Wait 1 D.Open_ "C:\Myfiles\Scripts\IVLISTS\log\carts.txt", ftDelimited Do     If D("Status") <> "Done2" Then         Stable 0, 3         Wait 1         Enter D("CART")         D("Status") = "Done2"     End If     D.Next_ Loop Until D.EOF D.Close_ Wait 1       -----Original Message----- From: Mickey Sherbett [mailto:[EMAIL PROTECTED] Sent: Friday, 27 February, 2004 9: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. ____________________ 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.