Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

FILEOPEN

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

2 Users

0 Reactions

79 Views

RSS

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

Our providers would like a button added to a custom form that will open a morphine equivalent calculator spreadsheet. This document is currently saved to their desktops and the custom button would avoid the toggle from the custom form for entering the calculated value.

I am following the Centricity MEL function guide, using the MEL expression below in a VFE button set to Run Process, but the document is not opening. The document is saved to the location in the filename, but of course the MEL reverses the file path forward slash to a backslash.

Has anyone had success in making this work? What do I need to change in this expression?

I've tried both variations:

{
local fname = "c:/opioddosecalculator.xslx"
local fhnd = FILEOPEN(fname, "a")
}

and this one:

FILEOPEN("c:/opioddosecalculator.xslx", "a")

Posted : April 16, 2015 8:58 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member


Try something like this:
local bs = numtoascii(92)
local fp = "c:" + bs + "opioddosecalculator.xslx"
RUNSHELLOPEN(fp,"","")

- Beverly

Posted : April 16, 2015 10:43 am

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

This didn't open the file. But strangely enough, after clicking the button with this run process function in it, I went to open the file to ensure it does indeed open, and I received a windows message telling me the file was already open, though the file wasn't actually already open, at least visually.

Any suggestions?

Posted : April 17, 2015 8:45 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

OK. I tested this on my system, for a file that contains spaces in the name (to make it cover all bases). { local bs = numtoascii(92) local fp = '"c:' + bs + 'TEMP' + bs + 'a test excel spreadsheet.xlsx"' RUNSHELLOPEN('excel',fp,'') }
This worked for me. - Beverly

Posted : April 17, 2015 10:14 am

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

Strange, this one isn't working either. I even renamed my file to 'a test excel spreadsheet.xlsx' to match yours. Are you using the RunProcess connection type in an action button? I've attached a screenshot of what I just tested.

Posted : April 17, 2015 10:49 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Is your file located in C:\TEMP ? That was where I put my test file. Your original example posted here just has your file in the C: drive. Just make sure your filepath in the RUNPROCESS matches where your file really is. I have sent you a dlg file with the filepath and filename set to your original example. Let me know if it works for you - Beverly

Posted : April 20, 2015 7:57 am

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

I will try this again today and confirm the file location. Can you please email me the dlg? I'm not seeing it attached to this forum. [email protected]

Thank you

Posted : April 21, 2015 5:52 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Test EXCEL vfe5
This is the dlg for a test form that will open an EXCEL file. This same concept should work to open an ms word document. regards - Beverly

Posted : April 28, 2015 9:11 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0