cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Djtjhin
Level IV

Saving JMP File / data table in Sharepoint through JSL

I'm trying to store a jmp data table which I can periodically update through JSL script (e.g. treating it like a check-in, check-out log). 

So far, I was able to successfully open the data table using the Open() function. However, instead of opening the actual data table, it downloaded like a temporary copy of the table from sharepoint as I see that the table name became "Untitled $$$". 

This is still acceptable as long as I can just save this new table in the same sharepoint directory and write over the existing file. I tried the Save(), Save as(), Copy Location () but none of these functions work. 

The errors which I faced are similar to the ones discussed in this thread below:

Save data table to a sharepoint 

 

I wonder if there are any new solutions since 2012.

 

Appreciate the help

1 ACCEPTED SOLUTION

Accepted Solutions
Craige_Hales
Super User

Re: Saving JMP File / data table in Sharepoint through JSL

Here's a 2010 article that expands on @pmroz comments.

https://whitepages.unlimitedviz.com/2010/12/unc-path-naming-for-files-stored-on-sharepoint-2/ 

I'm not a sharepoint user, but it appears you need some software on your machine that makes the http WebDAV stuff from sharepoint appear to be a network file. (Edit: And Isaac has a good comment at the bottom of that blog.)

As far as I know there is no builtin capability for this in JMP.

@briancorcoran 

Craige

View solution in original post

3 REPLIES 3
Craige_Hales
Super User

Re: Saving JMP File / data table in Sharepoint through JSL

Here's a 2010 article that expands on @pmroz comments.

https://whitepages.unlimitedviz.com/2010/12/unc-path-naming-for-files-stored-on-sharepoint-2/ 

I'm not a sharepoint user, but it appears you need some software on your machine that makes the http WebDAV stuff from sharepoint appear to be a network file. (Edit: And Isaac has a good comment at the bottom of that blog.)

As far as I know there is no builtin capability for this in JMP.

@briancorcoran 

Craige
Djtjhin
Level IV

Re: Saving JMP File / data table in Sharepoint through JSL

Thanks for sharing this. 

ih
Super User (Alumni) ih
Super User (Alumni)

Re: Saving JMP File / data table in Sharepoint through JSL

A few links that may or may not have some helpful info, I cannot tell if the errors in your example are the same as was discussed in these more recent posts:

Unable to save file to Sharepoint 

How to extract data from an Excel file on Sharepoint? 

Open microsoft office 365 cloud-based excel from JMP/JSL?