If your using rules it helps to have a couple. One to read the line, one to verify what has been read (and decide what to do next) and one to remove (or add) the line.
In my rules example, the box I am reading is only 4 rows, the first one
starting at 7. The condition would be @7#4, Since I'm ignoring the column
there's no need to include it in the condition. When the cursor is in that row
the script reads the data. I'm only reading 3 characters because I am looking
for specific characters. Change the length to include the entire entry and use
Trim$ to remove trailing blank spaces.
Once the read is done I move onto the next step and check the Flag value. In
the example I'm looking for NHP, but you could easily substitute for a record
from the datastation. (F("V64") = D("1"); F("V64") = D("1") is false, etc...
If the value is what I am looking for I move down to the next step. If the
value is not what I'm looking for I move the cursor down one and re-read from
the cursor position. (Conditions: F("V64") = NHP; !F("V64")=NHP (! = false))
I seem to have better luck when I use ! and = for does not equal instead of <>
when I'm checking values.
Remember that Row:=Row or Col:=Col is your friend and tells BWS to use the
cursor position as either the Row or the Column.
[cid:542543111@02062009-128E]
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[email protected]
________________________________
From: [email protected] [mailto:[email protected]]
Sent: Monday, June 01, 2009 3:34 PM
To: [email protected]
Subject: [talkbws] Script question - MEDITECH
I am trying to write a script, new at this, I am logging into MEDITECH and I
have a spreadsheet that has the MIS USER PROFILE mnemonic, the Users with
access and another column that has a blank or Yes to delete the user from the
profile. How do I scroll down the screen to get to the user I want to delete,
the user may be beyond the users you can actually see on the screen. Screen
shot attached. Thanks in advance for any help.
Joanne Barrett-Haramis
Sr. Programmer /Analyst
Data Management and User Provisioning
Halifax Health - IT
386-254-4116 X 1115
E-Mail: [email protected]<mailto:[email protected]>
Learn IT, Use IT, Love IT
P please consider the environment before printing this email
Electronic communications originating from or sent to Halifax Health are
subject to monitoring and public inspection under ยง 119.07, Florida Statutes.
This message and any attachments are the property of Halifax Health and are
intended to be received only by the individuals or entities identified in the
message. If you have received this message in error, please take notice: 1)
that any use, copying, printing, forwarding or distribution of this message in
any form is strictly prohibited, and 2) please notify the Halifax Health
Compliance Department at (386) 254-4278 and/or forward the message to
[email protected], and please delete or destroy all copies of the message
and any attachments.
________________________________
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the designated
recipient(s) named above. If you are not the intended recipient, you are hereby
notified that you have received this communication in error and that any
review, disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in error,
please notify the sender at the electronic mail address noted above and destroy
all copies of this communication and any attachments. Thank you for your
cooperation.
<<inline: Outlook.jpg>>
