RE: [Talk] DATA STATION

[Mickey Sherbett]

Title: DATA STATION

You are probably right. It always comes down the simplest solution is what is needed. Sometimes it is hard to see the simple stuff when you are juggling 10 projects at one time and you always think it can not be that simple. I will try it out and let you know.   I guess I am trying to understand the logic.  When the script starts does it also process the .bds file and since we have run it one time already it read the first record in the .bds file and since the STATUS was done it skipped the records the first time?   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 10:06 AM To: '[EMAIL PROTECTED]' Subject: RE: [Talk] DATA STATION   Mickey,             That is just a SAMPLE file.  If you want to use the same file over and over, you’ll have to take the IF statement out of your script.       -----Original Message----- From: Mickey Sherbett [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 9:55 AM To: [EMAIL PROTECTED] Subject: RE: [Talk] DATA STATION   Okay,   Why when we ran the script the first time it went through the whole file and entered in all the entries to the Meditech screen and ended.  When we called the script up the second time it acted as though the file had already been processed and did not read any records in the file on the second go around.   Like I said on the Flat File Example on the Web Site there is no If D(“Status”) <> “Done Then statement. But it is in the example that comes with Boston Workstation 6.5.   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 Rich McNeil Sent: Friday, February 27, 2004 9:40 AM To: [EMAIL PROTECTED] Subject: RE: [Talk] 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. ____________________ 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.