cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • See how to interactively organize and restructure data for analysis. Register for May 29 webinar, 2pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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? 

Recommended Articles