Skip to main content
  • EN

I have a task where I need to extract data from a database and save it as a csv in SharePoint

 

I had hoped to b able to specified the path to the SharePoint folder in the csv writer, but this does not seem to work.

 

The error I get is

 

  • CSV writer: Failed to open file 'HTTP:\\\\projectzone.tnad.tasnetworks.com.au\\business-projects\\iap\\TE\\HVDC Cable Specifications\\SATVUE_99021037_2021_08.csv' for writing. Please ensure that you have sufficient privileges to write this file. If the file already exists, please ensure it is not open in another application

 

I am using FME Server and the FME Server service account has permission to write to this location.

Hi @jackyd​ , would you be able to confirm what version of FME Desktop/Server you are using?

 

I would also suggest following this guide to ensure the SharePoint connection is made correctly https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection

Hi @jackyd​ , would you be able to confirm what version of FME Desktop/Server you are using?

 

I would also suggest following this guide to ensure the SharePoint connection is made correctly https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection

Hi Jenna,

 

we are using 2021.0.0.1 for both

 

I have looked at the web connection and not sure if it applies as we are using an inhouse hosted SharePoint and not web based.

I'll have a chat to our IT peeps and see what they sat though

 

Thanks

Cheers

Jacky

Reply


Community Stats

30,377
Posts
115,405
Replies
38,092
Members
Terms & ConditionsCookie 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.