|
Taking the IF out did the trick on our Developer PC. Next roadblock, When we move the .bws file to another developer PC , with all other parameters the same, Same folders, and everything else, the script will not read the text file on the other PC.
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-----
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-----
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-----
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
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Mickey Sherbett 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-----
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-----
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-----
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 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 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? 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. |
Title: DATA STATION
- RE: [Talk] DATA STATION Ross Stolle
- RE: [Talk] DATA STATION Mickey Sherbett
- RE: [Talk] DATA STATION Rich McNeil
- RE: [Talk] DATA STATION HTaylor
- RE: [Talk] DATA STATION Ross Stolle
- RE: [Talk] DATA STATION Mickey Sherbett
- RE: [Talk] DATA STATION Mickey Sherbett
- RE: [Talk] DATA STATION Thom C. Blackwell
- RE: [Talk] DATA STATION Mickey Sherbett
- RE: [Talk] DATA STATION Mickey Sherbett
- Mickey Sherbett
