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.

Question

Save a csv to SharePoint

+16

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.

+8

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

+16

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

Jacky Doyle - GIS Specialist and Kool Aid Drinker