AnalystRN

I'm almost there!  Here is what I have so far:

What this script is supposed to do is put data into the EHR from a .CSV file with about 5 column and 400+rows.  If the entry exists it should hit ESC then ENTER and move on to the next, if it does not exist it would build the entry.  It works for the most part but if an entry exists after Line 11 it skips down to Line 33 in the scripts and starts entering wrong data in wrong area.  Any ideas on what I've messed up??

I attempted to do it as a .txt but I don't know how to split the rows up and apparently ME5 doesn't have the split variable command?

So in the example above I am using ASCII.  What do you mean by "controls?" 

What I am seeing so far is ASCII seems to look at data via columns and Text seems to look at data by rows is that correct?  

This is probably simple but i don't know how to do it.  I'm using ME 5.  

Above is an example of what I would like to do.  I want to move the data from the CSV file into the fields above.  In the CSV example everything in Column A from Group through Group12 goes into the one program screen in meditech and then I need it to "start over" with Group F.PRECA and continue on.  

I don't know how to call F.LIVWITH and then call the "element codes" and "element names" as they are in the same column in the .CSV file.  

Any help would be greatly appreciated.  

The reason I need(ed) it to be inserted via the .txt file is based on hardcoded programming of meditech.  If I had to send each variable followed by F10 from the script it would be a LONG script.  I need to enter pt room, enter, row, enter, column, enter, length, enter and then begin again with another row as show in screenshot.  But i can input all of that in the .txt file in one column, when i send %T[1]% it all flows in!

Well I have no idea what was wrong but putting <F10> in the text file started working.....unsure what the issue was.  But I was using the Text File Begin/End Process commands.  The F10 key was not being activated by the .txt file.

I'm trying to pull data from a .txt file into Meditech.  It works up to a point.  At points in the .txt file I need it to "backspace" which in meditech is the F10 key.  How can I build an F10 command into the txt file?  Below is an example:

pt room<ENTER>
<ENTER>
<ENTER>
<F10>
5
<ENTER>
pt confidential flag<ENTER>
<ENTER>
<F10>
5
<ENTER>
<F10>
1<ENTER>

2 hours ago, rberq said:

Thanks for the feedback.  Glad you have been successful.  I used to work for a hospital, too. We used the Eclipsys SCM system.  Sometimes I would have to apply identical maintenance to dozens or even hundreds of database entries.  We weren't permitted to do direct table maintenance via SQL, so we had to use the application maintenance screens, and macros saved me HUGE amounts of time clicking through screens and typing.  It takes some effort to set up the macros, but often much of the code is reusable for similar functions. 

That is what I do most of the time.  Update, update,update or change,change,change.  And now I'm doing many of the mass edits for all of the hospitals in our division.

Since I have posted this....I figured out that for my purposes it is best not to use the .csv and to work out of a .txt file

I have mine set to "Pause" and that seems to work

It works!  It will now work through each one as it should!  I've even figured out how to log into a facility, perform these actions you helped me with, back out, and then loop through the remaining facilities.  The help is really appreciated!

Thank you!  I'm going to give this a try....hopefully today!  Much appreciated!

On 6/3/2019 at 4:05 PM, rberq said:

Look at Options | Preferences | Playback | Miscellaneous Tab to see the built-in ways to stop a macro.  Also, in the Help screens, look at the "Abort Macro" topic.  If you need to get more complicated, such as triggering a macro that will then stop another macro, it can get a lot more complicated.   

 

I don't think the trial version is crippled in any way -- it just stops working entirely after a certain time if the license code is not applied.  You're lucky the corporate office will allow you to install the product, innocuous as it is.  I have seen places where a few simple macros would be tremendous time savers for staff, but they couldn't get permission to use the product.  And it's so inexpensive compared to some software that companies pay vast amounts of money for.  I bought my first copy out of my own pocket and installed it back when there weren't several layers of management approval required. 🤗

I this we got lucky.  Other in our organization use MacroExpress so I guess it must be on the "trusted" list.  Its working out well so far.  I just need to learn and digest this stuff faster.

Ok here is a portion of it.  There are three sections but they are all basically the same.  I wrote it out the long way because I could not figure out how to make it work.

I work for a hospital.  So there is terminology that i have removed because it might not be appropriate.  What i'm doing here is building what is called a Chief Complaint.  So I create the mnemonic "VOAS", then the "if" yes/no is looking for a potential pop up that asks if this is new or not.  Then I put in a description in another field "victims of stuff."  Unfortunately the programming of the EHR then puts additional verbiage in a field which I have to remove with the up arrows and F10s.  This is the point I run into trouble.  I need to pull the info from the third column below into the now empty field.  Each STUFF entry must have an <ENTER> after it or it won't go into the field correctly.  Then once i enter those "stuff" variables I move onto another field and need to enter the variables from the 4th column plus an <ENTER> then the Y or N, then onto the next variable.  So **RAPASMT <ENTER> Y <ENTER>; *DETASMT etc.

Hopefully some of this made sense.  Thank you in advance for any help you can offer!  I think my main issue is I don't know how to do a loop within a loop.....

<ASCII FILE BEGIN PROCESS Filename="C:\\Users\\cki8358\\Desktop\\2019.2\\EDM.CC.Build.csv" Format="CSV" Start_Record="1" Process_All="TRUE" Records="1" Variable="%T%" Start_Index="1" Parse_Blank_Lines="FALSE" Clear_Array="TRUE"/>
<WINDOW ACTIVATE Title="EDM.COC" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/>
<COMMENT Value="CC #1"/>
<TEXT TYPE Action="0" Text="VOAS<ENTER>"/>
<DELAY Flags="\x01" Time="1"/>
<IF WINDOW Option="\x01" Title="Yes/No Confirmation" Partial="TRUE" Wildcards="FALSE"/>
<DELAY Flags="\x02" Time="500"/>
<TEXT TYPE Action="0" Text="Y"/>
<DELAY Flags="\x02" Time="500"/>
<TEXT TYPE Action="0" Text="<F12>"/>
<END IF/>
<DELAY Flags="\x01" Time="1"/>
<DELAY Flags="\x01" Time="1"/>
<TEXT TYPE Action="0" Text="<F10>"/>
<TEXT TYPE Action="0" Text="N"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<DELAY Flags="\x01" Time="1"/>
<TEXT TYPE Action="0" Text="Victims of STUFF"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<DELAY Flags="\x01" Time="1"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="<F8>"/>
<TEXT TYPE Action="0" Text="<ARROW UP>"/>
<TEXT TYPE Action="0" Text="<F10>"/>
<TEXT TYPE Action="0" Text="<ARROW UP>"/>
<TEXT TYPE Action="0" Text="<F10>"/>
<TEXT TYPE Action="0" Text="<ARROW UP>"/>
<TEXT TYPE Action="0" Text="<F10>"/>
<TEXT TYPE Action="0" Text="<ARROW UP>"/>
<TEXT TYPE Action="0" Text="<F10>"/>
<TEXT TYPE Action="0" Text="<ARROW UP>"/>
<TEXT TYPE Action="0" Text="<F10>"/>
<DELAY Flags="\x01" Time="1"/>
<TEXT TYPE Action="0" Text="STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF"/>
<DELAY Flags="\x01" Time="2"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<DELAY Flags="\x01" Time="1"/>
<TEXT TYPE Action="0" Text="**RAPASMT"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="*DETASMT"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="VOAS"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="VOASR"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="MAN-RE-CON"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="N"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="FLOWSHEET"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="N"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="PAINASMT"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="N"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="PHYSFIND"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="PREFPHARM"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="N"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="SEPSISSCRN"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="TEACHEDUC"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="Y"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="TRIAGER"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="N"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="MEDHISTORY"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>

<MACRO STOP/>
<ASCII FILE END PROCESS/>

<TEXT TYPE Action="0" Text="%T[3]%"/>
<TEXT TYPE Action="0" Text="STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF" _ENABLED="FALSE"/>
<REPEAT UNTIL Variable="%T[3]%" Condition="\x00"/>
<END REPEAT/>
<DELAY Flags="\x01" Time="2"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<TEXT TYPE Action="0" Text="<ENTER>"/>
<DELAY Flags="\x01" Time="1"/>
<ASCII FILE END PROCESS/>

T[3] has multiple rows.  I'm trying to copy these into Meditech.  I can get the first variable to copy over but cannot get it to copy down the list.  The kicker is I need it to <ENTER> after each variable in the column for it work with Meditech.  Basically like this:

<TEXT TYPE Action="0" Text="STUFF<ENTER>STUFF<ENTER>FIGHT<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF<ENTER>STUFF"/>

But without having to type it out by hand.   How could I accomplish this?  Any thoughts?
 

ok I found it.....I was looking under options of the macro itself.  When I look under the Macro Express "options" I see them!  Much appreciated!

I was able to do this while running AutoIT.   How can I accomplish this in MacroExpress 5?

Hopefully I can describe this better.  So if i send the %T[3]% it would send the "A" from my .csv in the example above.  How would I program the script to go down the list and send AA then AAA, etc from that .csv.

The script pulls from the .csv file and inputs the data in the Meditech program.  Currently the only way I have found to do it is to put the data directly into Macro Express. 

From an excel .csv how can you send a variable, %T[3]%, which includes multiple rows under it.  So:

A

AA

AAA

AAAA

AAAAA

I want to send all of them in the example above.  But i seem to only be sending "A".  How can i accomplish that?  I am sending this variable into Meditech (Healthcare EHR program).