Optimize Sharepoint Integration☐cool new feature
☑ could help many users!
☑ removes a (MS) „bug“
☐ nice to have
☐ nobody needs it
What inspired this wish list request?
Many Windows users use Sharepoint to collaborate on the same files. Very convenient: synchronize the Sharepoint file with your OneDrive to have all the files accessible without the hiccups of direct Sharepoint access. This works great for Microsoft files like Word, Excel, Powerpoint...
For Jmp files, it can be very dangerous to have two colleagues working on the same file.
In the morning, Alice opens a file, modifies it and saves it at 9 am. She expects the file to be automatically updated in Sharepoint-but as long as the file is open in Jmp, OneDrive won't send the updated file to Sharepoint.
After lunch, Bob opens the file on his computer - unfortunately, still the previous version. He makes some changes, saves the file, and closes the file. Now Bob's file is sent to Sharepoint.
After a few more hours of tweaking, Alice is satisfied with her version and saves the file. It's now 22:00 and she closes Jmp as well. Now Onedrive tries to update the file in Sharepoint and notices that the file has been changed "in the meantime" (according to OneDrive: in the meantime = after Alice opened the file in the morning). Therefore, a message will pop up saying that "there are now two versions of the file" - the official one and Alice's version saved with a different filename. Unfortunately, Alice is already on her way home and won't see this message.
Best case: The next day, Alice and Bob discover the problem - and after a few "seconds" of merging the files, they end up with the correct one.
Worst case: Nobody notices.
What is the improvement you would like to see?
Please optimize the way Jmp works together with OneDrive and Sharepoint.
Within Jmp there exist thousands or "workarounds" to make things work via Eval(parse (...)).
I hope Jmp developers will find a creative workaround against this annoying behavior of OneDrive / Sharepoint.
suggestions:
Please optimize the way Jmp works with OneDrive and Sharepoint.
The ideal solution: working with Jmp files from OneDrive/Sharepoint works as seamless as for MS Office files.
This will be along way to go ...
Inside Jmp there are thousands of "workarounds" to make things work.
I hope the Jmp developers will find a creative Eval(parse (...)) workaround for this annoying behavior of OneDrive/Sharepoint.
Suggestions:
- Is a file stored in OneDrive? -> is there an API command? if not, maybe check the parent directories and search for "OneDrive".
- If a file is saved to a OneDrive folder, inform the user that the file won't be updated online until the file is closed.
- close the file and re-open it to trigger the upload (how long has it to be closed till OneDrive notices?)
- When a file is saved to a OneDrive folder, send an API command to OneDrive to trigger the upload.
Why is this idea important?
The loss of data is one of the most serious problems.
other wishes from 
Data AccessData Blending and CleanupSharing and Communicating ResultsRe: Optimize Sharepoint IntegrationWith the help of @jthi : On Save ?
dt = current data table();
Eval(Eval Expr (fsave = Function( {dtab, newpathname},
ex = New Window( "Upload to Sharepoint",
<<TYPE></TYPE>
Re: Optimize Sharepoint IntegrationGreat idea @hogi , my company is asking about similar things, thanks for starting the discussion.
Best regards, Georg
Re: Optimize Sharepoint Integration@Jonas_Rinne
as discussed today...
I guess that many (!!) users in other companies have similar issues.
So, it might makes sense to advertise for this wish.
It's quite complicated to implement this workaround - and there are some pitfalls.
So, hopefully Jmp developers will find a more clever / elegant / useful way to fix the issue.
Re: Optimize Sharepoint IntegrationHi @hogi ,
thanks for letting me know. Great work around by the way. 
I guess you are not the only user group with this issue and hope more people will push this request.
Cheers,
Jonas
Re: Optimize Sharepoint IntegrationDear all,
I agree, this is getting increasingly important, as more and more fileshares will be converted to Sharepoint.
Another workaround is, to map the Sharepoint folders into the Fileexplorer under Windows with OneDrive,
(we use "Sync" in the Document Library of Sharepoint)
in that way you can work with JMP on Sharepoint-Files as if they were local files.
Best regards,
Georg
Re: Optimize Sharepoint IntegrationHi @Georg , adding the Sharepoint drive to the local OneDrive helps a lot.
But this where the issue starts: the disappointing story of Alice, Sharepoint access collisions and backup copies like
- dataset.jmp
- dataset-notebook-2432544.jmp
- dataset-notebook-5464564.jmp
- dataset-notebook-2424424.jmp
...
-> added as an example to
Wish list - new Label: user experience
Re: Optimize Sharepoint IntegrationThanks to all for the many Kudos
great!
triggered by the JMP Wish List Prioritization Survey ?
Re: Optimize Sharepoint Integrationhi @mia_stephens , did the survey help to prioritize this topic?
Re: Optimize Sharepoint Integration - Status changed to: AcknowledgedThis request will be added to the queue for the wishlist survey. Thanks for posting this suggestion.
Re: Optimize Sharepoint IntegrationWe are currently developing a SharePoint data connector, which will be available as an add-in in the JMP Marketplace. While this does not fully address this request, the connector will facilitate data import into JMP from SharePoint.
Re: Optimize Sharepoint IntegrationHi Sarah,
ok, let's see ...
We use Sharepoint to share analysis reports in JMP files. We need read and write access to store, load and edit the files.
Re: Optimize Sharepoint IntegrationHello Sarah,
thanks, this could be a starting point. But ideally we would need a way to e.g.
- check out and open a file from Sharepoint,
- doing some changes on it,
- and check it in at the end and make it available for others therefore
We use Sharepoint for sharing JMP contents in a similar way like @hogi pointed out.
Re: Optimize Sharepoint IntegrationThank you for sharing this additional feedback! While I understand that the add-in doesn’t fully address your request, I wanted to provide you with this update as it relates to your request. Your feedback has been communicated, and I’ll keep you informed of any developments!
Re: Optimize Sharepoint Integration-
Re: Optimize Sharepoint Integration@DavidWhite
#DiscoverySummit2025
I just checked my recordings.
The data table has to be closed to get uploaded to Sharepoint/OneDrive.
When the Data Table gets opened in the mean time, OneDrive gets confused and e.g. a restart of Windows can help to get the file uploaded.
Maybe a data table property "cloase again and open in read only mode" could help ?
When a user needs to save the data table, he could get the "rights" by clicking on a button?
Any wishes / suggestions from other users?
