Skip to main content
Question

Save a csv to SharePoint

  • September 21, 2021
  • 2 replies
  • 72 views
jackyd
Contributor
Forum|alt.badge.img+11

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
Safer
Forum|alt.badge.img+7

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
Contributor
Forum|alt.badge.img+11
  • jackydContributor
  • Author
  • Contributor
  • September 22, 2021
JennaAtSafe wrote:

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


Helpful Members This Week

Community Stats

31,328
Posts
118,863
Replies
38,956
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.