topic Re: How to run jsl script in excel VBA? in Discussions

How to run jsl script in excel VBA?

lwx228 — Fri, 09 Jun 2023 23:30:32 GMT

My JMP installation path is "c:\00\jmp\jmp.exe".

I need to start jMP.exe in a VBA and have "jMP.exe" run the "c:\abc.jsl" file.

I wrote VBA like this.The JMP program can be started, but JSL is not running.

Sub test()

    Shell "c:\00\jmp\jmp.exe ""c:\abc.jsl"""

End Sub

Re: How to run jsl script in excel VBA?

nascif_jmp — Mon, 29 Jun 2020 12:57:29 GMT

Can you share with us what abc.jsl is trying to do? There are many ways of integrating JMP with Excel. Perhaps there is a better way to accomplish your task than running JMP as a subroutine.

Re: How to run jsl script in excel VBA?

Georg — Mon, 29 Jun 2020 13:14:39 GMT

I agree to @nascif_jmp , as a platform switch Always is a Chance to have Trouble.

Why also not Performing the whole Job in jmp?

By the way, the Shell call for a jmp Job works as simple as follows:

Path2JMP\jmp.exe script.jsl

and if the script starts with "//!", it is excecuted on Opening,

and you can quit at the end.

See Scripting guide --> getting started (or search for //!)

//!
Names Default To Here( 1 );
// here Comes the JMP Job ...
Quit();

Re: How to run jsl script in excel VBA?

lwx228 — Mon, 29 Jun 2020 14:06:03 GMT

Yes, I've converted most of what I do with VBA to JSL.
Prepare to spend some more time modifying the remaining VBA to JSL as well.

Thanks!

Re: How to run jsl script in excel VBA?

lwx228 — Mon, 29 Jun 2020 14:22:23 GMT

The focus of the question is:

Inexplicable errors occur when q programs use CSV files generated in JMP.

However, open the CSV file in Excel and save it once, so that the CSV file can be calculated at q level normally.

Re: How to run jsl script in excel VBA?

lwx228 — Mon, 29 Jun 2020 14:33:06 GMT

If open the CSV generated by JMP with Note.exe, it will see these scrambled codes,

This CSV file is opened in Excel, and then saved as a CSV file. This new CSV file is opened and displayed in Note.exe is normal.

Re: How to run jsl script in excel VBA?

lwx228 — Mon, 29 Jun 2020 14:36:20 GMT

I used JSL saved as CSV file is:.

d3 << Save( "C:/123.csv" );

Re: How to run jsl script in excel VBA?

Georg — Mon, 29 Jun 2020 15:27:55 GMT

What are your Export Settings?

Looks like there is a Special character used as delimiter for columns, that is not shown properly in "note.exe".

Have a look at File --> preferences --> Text data files --> Export settings

Does the example under Scripting index for Big Class ("Save as") work properly?

Re: How to run jsl script in excel VBA?

nascif_jmp — Mon, 29 Jun 2020 17:30:16 GMT

@lwx228 another thing to consider: it looks like the main feature of the q application is the ability to run SQL queries against CSV files.

But did you know that JMP also has a similar feature?

Take a look at the Query Builder, which supports building queries against tables since JMP13. This presentation is a good starting point.

QUOTA_BYTES quota exceeded

Re: How to run jsl script in excel VBA?

lwx228 — Tue, 30 Jun 2020 14:31:59 GMT

Yes, JMP is a great piece of software.
But I'm not using Q for that.
Q is surprisingly fast.

So the point is how to use jMP-generated CSV files without this problem.

Thanks!

Re: How to run jsl script in excel VBA?

lwx228 — Tue, 30 Jun 2020 14:40:34 GMT

I'm going to do it by default.
How should I set it up?

Thank Georg!

Re: How to run jsl script in excel VBA?

nascif_jmp — Tue, 30 Jun 2020 21:33:26 GMT

@lwx228 Also which OS and version of JMP you are using?

Re: How to run jsl script in excel VBA?

lwx228 — Tue, 30 Jun 2020 22:51:53 GMT

win 7 64b
JMP pro 14.3

Thank nascif!

Re: How to run jsl script in excel VBA?

nascif_jmp — Wed, 01 Jul 2020 18:58:03 GMT

I can't reproduce the issue you are having on my environment. The exported .CSV looks fine.

I'd recommend trying out a newer version of JMP, or if you can't upgrade, reach out to tech support.

Looks like you are very close, though. :)

Re: How to run jsl script in excel VBA?

lwx228 — Wed, 01 Jul 2020 23:58:03 GMT

This is also the case with CSV exported using JMP Pro version 15.1.

Thanks!

Re: How to run jsl script in excel VBA?

lwx228 — Thu, 02 Jul 2020 00:12:26 GMT

Got it. It has to do with the default language choose.An error occurs when the column name is not in English.

Re: How to run jsl script in excel VBA?

nascif_jmp — Thu, 02 Jul 2020 00:49:16 GMT

Nice! Glad you found it.