Jump to content
Macro Express Forums
AnalystRN

Send variables to Meditech?

Recommended Posts

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

 

image.png.bad799e951fb03c0ad0ba082b5971c0d.pngimage.png.900039800b54bb7c3b8dd10b0b98de8b.png

 

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.  

 

 

Share this post


Link to post
Share on other sites

Are you using ASCII File Process?

Are you using controls?

 

Assuming you are, as you look though the file line by line, you would detect by the content of the first array value if it's "Group" and then switch you method in the loop to add the GroupElements. Once group row appears again, do the other thing. 

Share this post


Link to post
Share on other sites

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?  

Share this post


Link to post
Share on other sites

If you use ASCII File Process it splits the variables for you on the delimiter, a comma. 

There is a Split command. Please read the help file. It's called "Split String", you can't miss it. 

Last question is correct. ASCII file process reads line by line like Text File Process, but it splits the row by the delimiter and places them in an array variable of your choice. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...