There is an Excel file in Sharepoint that is updated by dozens of people, and I'd like to create a Master File to it. Has anyone done this, and if so, can you tell me how you made the connection?

This message has been edited. Last edited by: FP Mod Chuck,

Seriously, how do you all get access the Sharepoint data sources? I can't imagine I'm the first to have to deal with this.

Map the Sharepoint to a drive?
Attach directly to the file from WF/I-Way?
Have the source emailed to your server?

I'm pretty open, but I'm hoping not to have to enlist a Sharepoint programmer at my current org, as they are frightningly complicated people here.

John

I was thinking that the Sharepoint adapter might be a way but in looking at the adapter admin guide it seems like it will only reference the sharepoint internal data. Monday I will reach out to NY and see if an excel spreadsheet would be available through that adapter.

An option could be to use the rest api of sharepoint to retrieve the file:
https://docs.microsoft.com/en-...-and-files-with-rest

It's a bit tricky, you won't need a sharepoint programmer, just someone who can work with rest api.

John, you don't say what kind of systems you are using (windows only or window/unix/Linux, WebFOCUS version), but is seems to me you could create a drive share/drive mapping/symbolic link to the spreadsheet location and use the create synonym function in the reporting server.

One thing I've noticed is that if anything changes in the spreadsheet, col heading, format of dates, length of text fields, order of the columns or new columns added, you have to regenerate or manually update the master.

This is something I've tried.
The SharePoint Adapter will need to be licensed.

The SharePoint Drive adapter documentation shows how to map a SharePoint directory to a Reporting Server application.

Then, you just use the Excel adapter to create the metadata against the Excel Spreadsheet.

Excel support for the SharePoint Drive adapter starts with WebFOCUS 8207.17.