Updating JMP table from SharePoint list / document library

Question

Hi there,

used the search functionality but did not find a related topic, please correct me if I am wrong.

We have different SharePoint lists and libraries which I would like to update my evaluation automatically with updated content from the SharePoint.

I was able to download data using

Open("https://SHAREPOINT-ADDRESS/AllItems.aspx", HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) ))

This works fine but requires some post-processing for data types and some additional calculations.

Is there a way to simply update rather than putting all changes and additions into the import script? Something like "update from source"?

Thanks in advance!

martindemel · Accepted Answer

Hi, not sure this will address all you want to achive, however:

In this link to an external page https://www.cdata.com/kb/tech/sharepoint-odbc-sas-jmp.rst is discribed how to access sharepoint data through an ODBC connection. This connection could be used with the Query Builder in JMP and using the Query Builder you get in the created data table automatically Source/Update/Modify Scripts. I haven't tested this but might be a solution for what you are looking for.

In addition to that, you may want to have a template data table specifying all the column properties the fields have. Then you could update this table depending on what kind of update you want.

* adding new data to the existing
* Exchanging the existing data completely with the new data
* adding additional columns
* updating certain columns
* ...

Using a template data table removes the burden of changing the formats and other properties every time again (or at least to check them). If you want to remove typos, using recode and creating a formula column could help to do most recoding automatically for new data (at least for all mistakes you already know). This can be incorporated also by a script.

Unfortunately the problem is quite common to all non-office applications when they have to interact with Sharepoint.

This discussion might help aas well: https://community.jmp.com/t5/Discussions/Best-way-to-work-with-jmp-files-saved-on-SharePoint/td-p/13193