Question

Save a csv to SharePoint

  • 21 September 2021
  • 2 replies
  • 17 views
jackyd
Rank
Badge +2

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.

2 replies

JennaKAtSafe
Rank
Badge +6

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

jackyd
Rank
Badge +2

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

28,731
Posts
109,530
Replies
36,566
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.