Skip to main content
Solved

Read Excel file from Sharepoint?

  • August 26, 2014
  • 1 reply
  • 91 views

daniel_l
Forum|alt.badge.img
Hello,

 

 

I need to read a file from an external Sharepoint server in FME Desktop. When I open the https link in the web browser I first get directed to a login page where I can type the username and password.

 

Is it possible to pass domain\\username and password in the Source file parameter in FME so the Excel file can be opened in FME?

 

 

Thanks, Daniel

Best answer by ken

Hi Daniel, 

 

We are just starting to release a Sharepoint reader in betas of FME 2015 and I believe you should be able to read your excel file directly from Sharepoint and enter the credetials into the reader.  This is of course early days for this reader but you might want to download the beta of FME 2015 and take a look.  Otherwise in FME 2014 you'd need to use a series of Http transformers and FeatureReader transformer to do this and it gets a bit complicated.

 

Ken

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

Forum|alt.badge.img
  • Best Answer
  • August 29, 2014
Hi Daniel, 

 

We are just starting to release a Sharepoint reader in betas of FME 2015 and I believe you should be able to read your excel file directly from Sharepoint and enter the credetials into the reader.  This is of course early days for this reader but you might want to download the beta of FME 2015 and take a look.  Otherwise in FME 2014 you'd need to use a series of Http transformers and FeatureReader transformer to do this and it gets a bit complicated.

 

Ken