Skip to main content
Question

The best way of reading excel from Share Point

  • January 13, 2020
  • 3 replies
  • 155 views
F
Forum|alt.badge.img

Hi,

One of my FME projects is 90% done. The only thing that's stopping me from completing it (and putting it into automation) is the issue that I'm having with excel reader.

FME seems giving me errors sometimes (not always) at the excel reader (Feature Reader) (which reads an excel file from our own Share Point site). It works fine if I go to the SharePoint site by myself before running the script (or poke around the transformers either by parameters button, or containing folders button, etc.), which for me it indicates the problem is about the access to the file/site. But how do I mitigate this problem. Can someone please help?

 

Thanks.

3 replies

runneals
Contributor
Forum|alt.badge.img+19
  • runnealsContributor
  • Contributor
  • January 13, 2020

Are you only having issues when running on FME Server? If so, you need to make sure that the user that FME server is running as has access/permission to access the directory/files that you are able to access.

F
Forum|alt.badge.img
  • fpakzat
  • Author
  • January 13, 2020
runneals wrote:

Are you only having issues when running on FME Server? If so, you need to make sure that the user that FME server is running as has access/permission to access the directory/files that you are able to access.

No, I'm not using FME Server. Just Desktop.

I notice the only place where I could provide credentials are through "Specify URL" but this option is not working for me for some reason:

 

F
Forum|alt.badge.img
  • fpakzat
  • Author
  • February 7, 2020

I found solution myself at the end. I ended up using HTTPCaller to download the file from SharePoint and then utilize with Transformers.

Reply


Helpful Members This Week

Community Stats

30,929
Posts
117,224
Replies
38,733
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.