When i take a look at reader.png I don't see a generic reader.
Try to set Merge Feature Type at the reader.
Can you share your workspace?
Thanks for the suggestion @stalknecht, I did try that in one of the earlier versions (I have many), and I still kept getting the reader error.
Thanks for the suggestion @stalknecht, I did try that in one of the earlier versions (I have many), and I still kept getting the reader error.
Please share your workspace.
Hi @liz,
Can you read just one file without fanning out?
Cheers.
Lyes
@liz
Hi,
Maybe it is due to the column names in your sheets.
Your sample sheet nr.2 9601 Has invalid character in the first 4 columns.
Might this cause the problem when using it a dynamic writer in FME 2014? (can't test it as I no longer have 2014 installed)
It does not cause problem using 2016, fme just removes the invalid characters.
In fme I use the dynamic writer schema definition with schema source
"96* [xlsxr]" or
"Schema From Schema Feature"
both work correctly
Hi @liz,
Can you read just one file without fanning out?
Cheers.
Lyes
Hi Lyes, yes the script will read one excel file. The issues seems to occur when I'm reading 2 xls files with different schemas. Thanks for the reply.
Hi @liz,
Can you read just one file without fanning out?
Cheers.
Lyes
In this case Liz please share the workspace thanks. (If you can)
Thanks everyone for the
responses! I've attached my workspace to this post.... I'm fairly new to FME so
I'm guessing I'm making a beginner mistake.. However any further
suggestions would be amazing! I've also attached the two excel files this
workspace is running with. Thanks again!
@gisinnovationsb, @gio, @stalknecht
Hi @liz, have you tried adding the Excel files using advanced browser to select multiple files or folders? I've been able to read in both of your attached spreadsheets in FME 2014 using this configuration for the Reader.
Hi @liz, have you tried adding the Excel files using advanced browser to select multiple files or folders? I've been able to read in both of your attached spreadsheets in FME 2014 using this configuration for the Reader.
Hi Tia, thanks for the response. I finally got the outputs working thanks to the screenshots above, but my output excel files are now blank, with no attributes. Any suggestions here? Thanks again for your time! @TiaAtSafe
Hi Tia, thanks for the response. I finally got the outputs working thanks to the screenshots above, but my output excel files are now blank, with no attributes. Any suggestions here? Thanks again for your time! @TiaAtSafe
HI @liz , do you mean no fields or empty fields?
The output excel files are completely blank; they don't even contain column headers @gisinnovationsb. It's like opeining up a new worksheet.
The output excel files are completely blank; they don't even contain column headers @gisinnovationsb. It's like opeining up a new worksheet.
Please provide your current workspace.
The output excel files are completely blank; they don't even contain column headers @gisinnovationsb. It's like opeining up a new worksheet.
hi @liz, as mentioned by @stalknecht please provide the workspace. Thanks.
fmehelp.fmw
Here you go... thanks again for looking taking the time to look at this! @gisinnovationsb, @stalknecht
ihstest3.xlsxihstest2.xlsx
And here are the current excel sheets I'm working with. @stalknecht, @gisinnovationsb
Hi @liz ,
1. I would set the drop table/sheet to yes in the writers parameters to start with, this is if you are creating new excel files all the time
2. Also the dynamic schema definition might have to be set on in the writers property
Try the first one first.
Set the Attribute Definition of the writer to automatic.
Thank you for the suggestions! My output excel file now has the original attributes, but not the new x, y attributes, but this is progress!
WRT custom transformers: is there one transformer you would replace with a custom ones? (I'm assuming my Esri Re-project transformers?) Or would you create a number of custom transformers? @gisinnovationsb
Thank you for the suggestions! My output excel file now has the original attributes, but not the new x, y attributes, but this is progress!
WRT custom transformers: is there one transformer you would replace with a custom ones? (I'm assuming my Esri Re-project transformers?) Or would you create a number of custom transformers? @gisinnovationsb
Sorry I deleted that part on the original reply not to get carried away ... you just have to select a few transformers, then go to transformers menu then "create custom transformer". A new transformer containing the selected transformers will appear and it can be edited by clicking on one of the tabs above the canvas (the canvas being the place where the art putting readers/ writers and transformers is performed). If you are not happy with the result just undo by pressing ctrl+z in your keyboard.
In short it is to make space in the main window.
Thank you for the suggestions! My output excel file now has the original attributes, but not the new x, y attributes, but this is progress!
WRT custom transformers: is there one transformer you would replace with a custom ones? (I'm assuming my Esri Re-project transformers?) Or would you create a number of custom transformers? @gisinnovationsb
try to create new x,y attributes with the attributeCreator.
Just wanted to say thanks so much for the help, thanks to all the suggestion from you two I've finally got the script working! Cheers!!
@gisinnovationsb, @stalknecht
