Good idea - I'll try that!
Michelle
-----Original Message-----
From: Ross Stolle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 4:28 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Scripting Help for Newbie (with attachment)
Michelle,
Have you tried putting a short wait in front of the If Trim command?
It might be blowing right past the field without getting a chance to read
it.
Ross Stolle
Integration Engineer
Avera McKennan Hospital
Sioux Falls, SD
-----Original Message-----
From: Barker, Michelle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 02 July, 2003 3:22 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Scripting Help for Newbie (with attachment)
Hi Rich,
Everything worked except the View function. I've tried it a couple different
ways and it just has trouble "viewing" the blank field. With the code below
I got it to view the first record with a blank field, but any other records
after that it will just tab past it.
If Trim(View(4, 78, 5)) = "" Then
Enter "0"
Else
Tab_ ""
End If
Thanks,
Michelle
-----Original Message-----
From: Rich McNeil [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 10:44 AM
To: [EMAIL PROTECTED]
Subject: RE: Scripting Help for Newbie (with attachment)
1. Pause "@4,78" '?? EVALUATE FOR VALUES - TAB PAST IF VALUE EXISTS -
ENTER "0" IF NOT ??
If Trim(View(4,78,5)) = "" then Key "0"
Tab_ ""
2. Pause "@10,6" '?? SEND KEY "PAGE DOWN" TO GET TO THE NEXT AVAILABLE
LINE IN FIELD ??
Key "{PgDn}"
3. One issue here is double entry...which is especially important here
with payroll information. We've developed a structure for deal with
this in our "file.bas" project which parses your .txt file into a random
access file and keeps track of entries that have already been made
making sure they are not reentered. This takes things up a notch in
complexity, but this is important in a production script that runs every
day as opposed to, say, a dictionary upload script that just runs once
and isn't sensitive to double entries. The sample File.bas project uses
our demo apps as an example and can be found in ScriptSamples.zip. By
the way, the structure of file.bas has the looping structure that
addresses your third question directly.
Rich McNeil
Boston Software Systems
866 653 5105
www.bostonworkstation.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Barker, Michelle
Sent: Tuesday, July 01, 2003 8:44 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Scripting Help for Newbie (with attachment)
... here's the attachment - I was trying to get out of the office a
little
too quickly last night.
Thanks
Michelle
-----Original Message-----
From: Barker, Michelle [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 5:55 PM
To: '[EMAIL PROTECTED]'
Subject: Scripting Help for Newbie
Hi,
I need help on 3 steps in my script:
1. I have a field that needs to be evaluated when the cursor stops on
it. If
there is a value the script should tab past it, if there isn't a value
the
script needs to add a zero.
2. When the script comes to a list field I need to send the "Page Down"
key
to it so the cursor will go to the next available space.
3. All my scripts in the past have been very simple and have read from a
data file consisting of a list of numbers, mnemonics, etc. I now need to
read from a list that contains an ID and a value (i.e. employee ID and
allowance $ value). My data file is tab delimited and I can get the
column
number for each value, but I'm not sure how to write the loop to put the
correct data where I need it.
I've attach part of the steps I'm doing (without the loop).
Thanks
Michelle
617-665-3432
Clinical Application Analyst
CHA Information Technology
[EMAIL PROTECTED]
____________________
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.
