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

Function to run a vbscript

Trading Post

Last Post by Anonymous 1 second ago

8 Posts

4 Users

0 Reactions

71 Views

RSS

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

I have a vbscript that I need to call from within a form.

This vbscript calls data from a custom database table and I need it to populate a multipline edit field.

Error I get is Network Path was not found. If I run it under a doss windows, I get the desired results.

Any help will be greatly appreciated.

Function currently is as follows:

fn GetICD9()

{

local Progname = "\\servername\clinkits\SelectCode\ICD9Codes.vbs"

local argStr = DOCUMENT.TEST_EDIT

RUNSHELLOPEN(Progname, argStr)

}

Posted : May 28, 2013 6:00 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

if servername is a shared drive, try it with the actual drive name instead of the shared name.

Posted : May 28, 2013 6:36 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

Script is currently hosted on our jboss server on the same share we use for the clinic kits and files for jobs.txt.

It is shared to everyone read/execute.

When I run it using runtextprocess it apears to work, but I get an error about bad option of /o.

Also tried with progname=cscript.exe and the path in the argstr.

Posted : May 28, 2013 6:50 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

You might try changing whacks to slashes - i've seen problems with that before as they may be interpreted as escapes, though not sure if that will resolve this here.

Posted : May 28, 2013 6:57 am

bboswick

(@bboswick)

Posts: 29

Trusted Member

I've had success calling vbscripts in the following way:

{
  local application = "wscript.exe"
  local args = "//centricitylinks/scripts/ClearDataFiles.vbs"

  runshellopen(application, args)

}

Call wscript.exe and pass the name of the script as an argument to wscript.exe. I also use forward slashes to delineate directories and filenames.

Hope this helps.

Posted : May 28, 2013 7:00 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

Got it working....Sort of....

It runs, I see the DOS window apear and flash containing the results of the vb script.

I need to have the output of the script populate a variable. Not just a true of false.

Current code as follows:

fn GetICD9()

{

local Progname = "cscript.exe"

code = DOCUMENT.TEST_EDIT

local argStr = "\srovp0021\clinkits\SelectCode\ICD9Codes.vbs " + code

RUNSHELLOPEN(Progname, argStr) > DOCUMENT.TEST4

}

Posted : May 29, 2013 2:44 am

bboswick

(@bboswick)

Posts: 29

Trusted Member

In that case, you will need to have the vbscript write the result to a separate file that MEL will open and read the contents. I found that I had to make the MEL code "wait" for the vbscript to finish writing to the file by looping until there was data to read from the file.

The other alternative is you will need to develop a custom executable that is called by the runtextprocess function that can handle the /o switch that MEL tacks on to tell the application which temporary file to write the results to.

Posted : May 29, 2013 3:20 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

I just upgraded my test system to 11.0. The problem with the /o is no longer present.

Script runs fine now, but how can I capture the results from the vbs into a variable in a form?

Posted : June 3, 2013 5:21 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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