Skip to main content
Question

Saving Excel with Template to Sharepoint Sync Error

  • November 1, 2024
  • 1 reply
  • 38 views

jeroen_hack
Contributor
Forum|alt.badge.img+7

Hello fellow FME enthusiasts!

We've run into in issue with writing Excel files to our sharepoint. We have a workspace that output's an Excel file.

We've set it up to use a template to make sure it has the same easily readable layout for our users. We store the Excel file on our sharepoint. Our sharepoint folders are available locally on the PC through One Drive. So we store them to a location like: C:\Users\[User Name]\[Sharepoint name]\[Folder name]

The issue we have is that every time we do this with the Template setting active in the Excel writer we get a sync error saying there is one file in out local folder and another one online. It's easy enough to fix this manually (One Drive gives us this option). But it is a manual action. If we write to the same location without the template setting in the Excel writer all works fine.

We are working with FME version 2024.0.3.0 (build 24220)

Has anyone experienced this before? And found a way to fix this?

1 reply

jobvdnoort
Supporter
Forum|alt.badge.img+10
  • Supporter
  • November 1, 2024

Hi Jeroen,

 

The template you use is the same file you are overwriting? Or is it a special template xlsx? 

What you could try is to first download the template file to a temp folder, using the sharepointonlineconnector, and instead of a file you can use download path in the writer.

 

 

When I work with data from Sharepoint, most of the time I download the files to a temporary folder :).


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