Skip to main content

Open ideas have been reviewed by our Customer Success team and are open for commenting and voting.

4476 Ideas

Terminator improvementsGathering Interest

Some general improvements for the Terminator transformer I am thinking of:The ability to terminate with a FME_FAILURE or ABORTED or maybe even a new TERMINATED status (relevant for Server). An FME_FAILURE happens when FME crashes or experiences some other problem (e.g. missing transformer). When the Terminator caused the workspace to quit, this typically happens because of a "user handled exception", which might also be interpreted as a cancellation, but now it's always FME_FAILURE as well. Either way, it gives me better insight in what went wrong if this status type could be changed.The ability to set custom data that should be sent upon failure, which can then be used as the "Data To Post" for notification topics. Upon failure, nothing gets written to the "Data To Post" writer, but it would be nice if we could at least get something back. In this case, that would be the custom data that was set in the Terminator.I would like the error message that I specified in the Terminator to stay exactly the way it is. When a job terminates on Server, it passes the Termination Message on to the statusMessage attribute from the job result. Just like in workbench, it always prefixes this message with "<Transformer Name>: Aborting Translation as directed by mapping file. Message is ...". I would love to see that prefix removed, because now I need to remove it myself since it is confusing to an end user who is not familiar with FME. Might as well officially integrate the functionality of the MessageLogger by 1Spatial.Any other suggestions...?

tim_wood
Contributor
tim_woodContributor

Excel Reader option to ignore empty rowsIn Development

See for example:https://knowledge.safe.com/questions/78116/excel-featurereader-reading-empty-row.htmlIt would be great to have an option in the Excel Reader to ignore any rows that are completely empty i.e. have no values in them. This option could be left un-ticked if you really want to read in rows from a named range or where there is formatting but no data.This would save having to spend time putting in a Tester or AttributeValidator to filter out the empty rows, or hard code ranges into the Reader when you need to be flexible.Merged Ideas:Add option to excel reader to only read 'non empty excel rows' by thijsknapen on February 20, 2021:When reading in excel files, I noticed that sometimes empty rows are read in. It would be nice if there would be an option in the excel reader, to only read 'non empty excel rows' in the excel sheet.This situation of 'empty excel rows' being read in, for instance occurs when an excel sheet contains cells that only contain formatting (but no value). However, also in the simple case where values are deleted in an excel sheet, the rows for that excel sheet will still be read.I often encounter this situation when I use a structured/formatted excel file as an input for a translation. As sheets are re-used, and not always the same number of rows are entered, there are different number of empty excel rows that are read in in the translation.