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.
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.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
An option could be to use the rest api of sharepoint to retrieve the file:
It's a bit tricky, you won't need a sharepoint programmer, just someone who can work with rest api.
Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
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.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
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.
|Powered by Social Strata|