JMP recently got a built-in ability to open Google sheets. Before that in scripts I was calling an R package called Googlesheets to open them. Now my company is moving to office365 so w...
...problem. For a larger corporation, this usually involves IT applying permissions to the Azure/Office365 account and creating those items for you. If you are a personal user, do a b...
...neDrive/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 w...
Some time ago I created a script that gets data from a file on SharePoint. Everything worked smoothly. One day I started receiving an access error. I have attached the code but I have removed the e...
Hi, I am in progress of transferring my scripts to the companies new office365 account. I would like to be able to access and execute the jsl's (and csv's, html,s) directly from sharepoint...
What inspired this wish list request? For many users JMP is the standard application for data analysis, and Sharepoint is the standard collaboration platform. That Sharepoint can not be used i...
Attempting to use the following JMP JSL code: dt = Open("https://name_of_file.xlsx?download=1",
Worksheets( My_Res ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Creat...
I am looking to run a script routinely from an excel file we keep in sharepoint. I have not been able to find much but due to the tight control of our IT department I cannot write anything o...
...ompanies have access to a common Excel file via Sharepoint. I have been given access to the file on Sharepoint. After much ‘messing’ and then finding the Web() function, I am now able to get the Excel file t...
...onnecting, JMP opens the default browser and prompts you to login to your desired Microsoft account. You are then asked to grant access to the SharePoint Data Connector application.
If you do not have a...