nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Save data table to a sharepoint

MTOF

Hi All

I have succeded in reading data tables (uploaded manually) from a sharepoint using JSL.

However, I cannot find a way to make JMP (version 8.0.2 on Windows) save a file to this sharepoint.

To read a file I use:

dt = open(::path||"MyTable.jmp");

where path is a long string starting with http://.....

This works fine.

To save a file I use:

dt << save(::path||"MyTable1.jmp")

JMP interprets ::path||"MyTable1.jmp" as the filename and not as the full path incl filename!? And saves the file with a stupidly long name in the current directory in stead of on the sharepoint...

Any suggestions are highly appreciated!

BR, Marianne

Accepted answers

All comments

gbu

Hello Marianne,

Did you try with this syntax ?

strpath = "http://..............";

dt = open(strpath || "MyTable.jmp");

dt << save(strpath || "MyTable1.jmp");

Could you copy the log of the save statement ?

Regards,

Guillaume

MTOF

Hello Guillaume

Thank you for trying to help .

Yes, my path is a string (defined as ::path = "http://..............\"; )

The path as such works fine, otherwise the open command would not have worked.

But when saving the problem occurs. I've nailed the problem, but don't know how to overcome it! The problem is that Save interprets the input string I give it in the wrong way.

dt<<Save("MyTable.jmp") saves dt as MyTable.jmp in the current directory.

dt<<Save("C:\Program Files\MyTable.jmp") saves dt as MyTable.jmp in C:\Program Files.

dt<<Save("http://........\MyTable.jmp") is supposed to save dt as MyTable.jmp in the specified folder on the Sharepoint (given by the path), but instead saves dt in the current directory as a file named http---..................MyTable.jmp.

There is no error message in the log - only 'Scriptable[]' as JMP does save the file - just in the wrong place with the wrong name...

I've also tried changing directory using set current directory, thinking that then I could save the file using dt<<Save("MyTable.jmp") afterwards,

but nothing happens (no error message, no change in directory).

set current directory (::path);

BR, Marianne

pmroz

See if you can open your Sharepoint folder as a windows folder. That will give you the unc-style path which will work from JMP. When you are looking at the appropriate Sharepoint folder, click on Actions > Open with Windows Explorer. You will get a Windows Explorer window showing your files. The correct folder path is at the top, and will look something like this:

\\mysite.mycompany.com\mysubject\jmpprograms\Shared Documents

Then, your complete file path will be "\\mysite.mycompany.com\mysubject\jmpprograms\Shared Documents\MyTable.jmp"

MTOF

Dear PMroz

Thank you for your comment, but this is exactly what I've done!

Opened the Sharepoint folder in Windows Explorer and copied the path from here: ::pathstr="http://mysite.mycompany.net/mysubject/JMP_DB/";.

This path works fine with dt=open(::pathstr||"MyTable.jmp").

But it doesn't work with dt<<save(::pathstr||"MyTable.jmp");

See explanation of what happens in my reply above.

BR, Marianne

somehow got an extra set of http: in the above text... Message was edited by: Marianne Toft