copy sheet from gsheet to excel - maintain column names

Hi @donatoquercia

Cloud you share us your Workspace?

Thanks,

Danilo

Hi @danilo_fme in attach you can find Old Workspace that worked until yesterday...then I've modify in other project with write transfomation and the problem it's solved, but I can't uderstand because at any moment it stop. If you have any type of suggest please give us.

Thank you in advance

Donato

Hi @danilo_fme , I confirm to you that googlesheets2xlsw-drive-eri.fmw don't copy column/fields name, if I set overwrite type the procedure work correctly (I need to preserve the structure and data of destination file, there are a lot of other sheets) but with insert type in the destination xls file fields name don't are updated. How I need to modify the workspace?

Thank you!

Donato

Thanks @donatoquercia

I can't run this Workspace, because I dont have the credencials information from Google Sheets.

Could you share the log file?

Thanks,

Danilo

googlesheets2xlsxw_Drive_Eri.zip log file

Thank you very much!

Hi @donatoquercia

Thanks your Log File.

Inside the transformer FeatureWriter - Did you try the option Writer Mode for Update?

Thanks,

Danilo

Hi @danilo_fme, in Update mode it's necessary a fild with unique code (key), but I cant modify the source file (reader) and in update mode fme module return an error about wrong xlsx_row_id .

Thanks to you!

Donato

Hi @donatoquercia,

Unfortunately, I can't reproduce the same issue with attribute names not writing but it looks like you have all of the parameters set correctly. Are the attribute names not appearing on all three sheets or is it just on a specific sheet?

Additionally, are you able to share a sample of the output dataset before the new data is written to it? Just wanted to confirm that the output schema matches the source dataset(s). Lastly, do you get the same result if you write to a new file or use a template file with truncate existing sheet set to yes instead of drop existing sheet?

Hope this helps.

Here is the example I was working with (the Google Sheets are publicly shared - you just have to set your connection and set the dataset parameter to the included Excel file at runtime)

FILE_MASTER_Quercia_NEW.xlsx