I'm working with a customer who is planning a data migration from one document management system to MS Sharepoint. At the moment we are looking at what options there are to use FME to do this via the Sharepoint Web Service to see if its possible to tackle this with a custom transformer or similar.
It would be great to write more than just Sharepoint lists, especially as in this instance we're talking about migrating 5 million documents.
+3Ditto, I've got a few hundred photos (inc gps coords) in a sharepoint site. I want to read the properties of the jpeg (as you would with a reader). Its proving tricky for this FME novice!
+21
I'm guessing you've tried providing the URL of the SharePoint file/directory as a parameter on an FME reader, and failed? This is a common one we've come across (normally for spreadsheets held in SharePoint) and not found a way around. Basically we need Safe to allow us to read and write to SharePoint for all of its supported formats, not just using the Lists reader/writers.
Assuming you need something more detailed than that, like Dave says, @revesz !
+15
Just to add weight to this request. I'm generating around 1000 zipped SHP files which I want to regularly update and as opposed to just placing them on a network drive I thought it it would be good to upload them directly to a SharePoint folder. Not as easy as it seems clearly.
+19Good timing. We're gearing up for this. Out of curiosity, what version of Sharepoint. And is it hosted locally or via Microsoft's cloud?
@Sweco we use Office365. Would love to help out and play around with the things you are making. Might even be a great thing to present some hands on expierces on the world tour. Or am I moving to quickly....
+19This FMEWT might be a bit aggressive but very good to know you're able to beta test/advise ...
+6The whole cycle would be really ideal for us and perhaps relates to this idea.
*Also crucial (to us at least): Office 365 AD Authentication
Hey, what a brilliant post I have come across and believed me I have been searching out for this similar kind of post for past a week and hardly came across this. Thank you very much and I will look for more postings from you.Feel free to visit my web office 365 document management system
+24I`m guessing this can be done with Microsoft Graph API and the correct REST-API call from here. https://docs.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0 @1spatialdave
+21This capability 'might' be just around the corner in the form of a dedicated connector transformer and an associated web connection for format readers. Fingers crossed and thanks to Safe for hearing the cry!
+8Hi, would be nice if document tags could be specified, too. We are using the Cloud version of Sharepoint.
Hi,
You guys can try Microsoft Flow to upload the output file to MS sharepoint folder.
i.e use FME to email the output file to yourself, in the meantime use the ms flow to save the output file into sharepoint folder (when you receive an attachment from your email)
+3Any updates in regard to this feature?
The same task here.
I need to read from DB create some sort of Excel report and save it to SharePoint Online as excel file
Yarko
+5Seems interresting. Anyone tried this workaround? Didn't had the chance to try Microsoft Flow yet
+19I'm thinking this one has an excellent shot at being the first Idea to experience a state change in this all new forum... Watch this space...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
