I have set up a workspace which reads in an Excel Spreadsheet whose attributes may change everytime that the workspace is run. As this workspace is part of a larger chain of workspaces I would like to be able to run it without having to reload the reader to ensure that the latest attributes and features are being brought through each time.
I have tried setting the 'Scan Schema in Dynamic Workflow' parameter, but with no success.
Is there something I am missing?
Hi @johnwk,
Thanks for reporting this. This is a known issue which we are working to fix, it is particularly noticeable when using the FeatureReader.
The first hing to check, however, is that the the Additional File Handling is set to 'Apply Default Settings to Additional Files' (see below).
If this still persists a suggested work around is to use the Schema reader (any format) in combination with the excel reader to build the schema manually. In my screen shot below, notice that I have the output schema source set to "Schema From Schema Feature". The data from the excel file should still be being read, however, it is the schema that may not be being generated properly.
Let us know how this goes
I asked a similar question not too long ago.
My problem was solved by using a 'generic' reader instead of an excel reader.
https://knowledge.safe.com/questions/52231/updating-reader-as-resource-for-dynamic-writing.html
Hi @johnwk,
Thanks for reporting this. This is a known issue which we are working to fix, it is particularly noticeable when using the FeatureReader.
The first hing to check, however, is that the the Additional File Handling is set to 'Apply Default Settings to Additional Files' (see below).
If this still persists a suggested work around is to use the Schema reader (any format) in combination with the excel reader to build the schema manually. In my screen shot below, notice that I have the output schema source set to "Schema From Schema Feature". The data from the excel file should still be being read, however, it is the schema that may not be being generated properly.
Let us know how this goes
On your two options to try:
Thanks for your help, glad I wasn't being stupid and that there is actually a known issue with the Excel readers.
I asked a similar question not too long ago.
My problem was solved by using a 'generic' reader instead of an excel reader.
https://knowledge.safe.com/questions/52231/updating-reader-as-resource-for-dynamic-writing.html
Glad it's sorted though now and there is a successful work around whilst Safe fix the Excel issue.
I'm using 2018.1 and this still seems to be an issue. It gets me every time! For example someone modifies the headers of a spreadsheet (ex: corrects a spelling mistake) and then the workspace doesn't read the data for that column. I was under the impression that this setting (Scan Schema in Dynamic Workflow) is supposed to rebuild the Attribute list. Is that not the case? I'm finding that even if I right-click and select "Update Reader" and select "Update Reader and Feature Types", the attributes don't update. I have to also go to "Parameters" in order to see the update. There are even times where I also have to toggle the "File Names Row" and "Cell Range" back and forth for the attributes to properly update.
I'm using 2018.1 and this still seems to be an issue. It gets me every time! For example someone modifies the headers of a spreadsheet (ex: corrects a spelling mistake) and then the workspace doesn't read the data for that column. I was under the impression that this setting (Scan Schema in Dynamic Workflow) is supposed to rebuild the Attribute list. Is that not the case? I'm finding that even if I right-click and select "Update Reader" and select "Update Reader and Feature Types", the attributes don't update. I have to also go to "Parameters" in order to see the update. There are even times where I also have to toggle the "File Names Row" and "Cell Range" back and forth for the attributes to properly update.
Hi @dbaldacchino Thanks for leaving your observation here. We have a couple of ideas that' could potentially make this experience better. Unfortunately, we don't have a timeline for it yet. But we will be sure to update here, when the solution is implemented.
Thank you for your patience.
Hi @dbaldacchino Thanks for leaving your observation here. We have a couple of ideas that' could potentially make this experience better. Unfortunately, we don't have a timeline for it yet. But we will be sure to update here, when the solution is implemented.
Thank you for your patience.
Has this issue been addressed? I am using FME 2020.1.2.1 (build 20624) and checking Scan Schema in Dynamic Workflow does not update the attributes when they change in my Excel file.
Hi @dbaldacchino Thanks for leaving your observation here. We have a couple of ideas that' could potentially make this experience better. Unfortunately, we don't have a timeline for it yet. But we will be sure to update here, when the solution is implemented.
Thank you for your patience.
Hello @xiaomengatsafe , please, do You have any updates on this bug?
thanks :-)
Hi @aaron and @lazarlubomir thank you for your question. The Scan Schema for Dynamic Workflow parameter is used with the Single Merged Feature Type in FME Desktop, are you planning on using the excel reader dynamically?
If you would like the Attributes to reflect the changes that are made in the Excel file when reading the file in (in a non-dynamic workflow) you will need to right-click on the Excel reader in the Navigator Panel and select Update Reader, when the Update Reader dialog appears, click the Parameters button (this is required for FME to pick up the change in schema), close the Excel Parameters dialog, then select Update Reader and Feature Types.
Hope this info helps. Please let me know if you have any further questions.