Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
ubpk
Level I

Updating JMP table from SharePoint list / document library

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Updating JMP table from SharePoint list / document library

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/13... 

 

 

View solution in original post

1 REPLY 1
Highlighted

Re: Updating JMP table from SharePoint list / document library

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/13... 

 

 

View solution in original post