Shape the future of FME with your ideas
Open ideas have been reviewed by our Product Management and are open for commenting and voting.
Geometry Collections can be very difficult to intercept. They sometimes are nothing ore than a fairly simple polygon, where one of the segments is an arc for example. Trying to write these to quite a few formats usually results in problems, and some GIS applications like QGis can’t handle them properly.But there is no surefire way to catch these, since they are not always aggregates. There have been a few threads about this already, like this one: Geopackages and different polygon types in same layer ? | Community and this one: Aggregated surfaces written in wrong file format in SQL server | CommunityIt would be very helpful if the option ‘Collection’ was added to the GeometryFilter’s Simple definition list. It might already be possible using the Detailed mode, but that is not very obvious (I haven’t figured out how...).
IFC-writer - support textures
I am looking for a way to write to a self-created GeoPackage that contains multiple foreign keys and check constraints. To ensure the data loads correctly without ordering conflicts, I need to temporarily disable foreign key validation by executing:PRAGMA foreign_keys = OFF;Once all feature classes are written, I need to re-enable the checks.Currently, the GeoPackage writer lacks the option to execute SQL scripts before or after the translation process. Using a separate SQLExecutor is not a viable workaround because it operates in a different session; therefore, the pragma command does not affect the writer's connection.Interestingly, I can achieve the desired behavior using a SpatiaLite writer with a SQL statement on the same file, but this method fails to handle geometry correctly. Due to these limitations, I am considering switching from GeoPackage to SpatiaLite as a temporary measure, though this is not my preferred solution.Could you please add SQL before and SQL after parameters to the GeoPackage writer to support these types of database operations?
It would be really helpful in the “Search in Workspace” Function would include an option to also search through all populated Feature Caches in the Workspace.Related to this it would also be great if there were more search parameters like “whole word”/”match case”/”regular expression”.
I’d like to request a feature for the AttributeManager transformer (or all tables really) that allows users to export the hover table output (attribute actions table) directly to the clipboard. This would make it much easier to document, share, and review attribute configuration settings outside of FME, especially for workspace audits and reporting. Ideally, this could be enabled via a right-click menu or a dedicated export button.This would be very useful for the amount of documentation I have to do for all my Workspaces.
Hi!Thew new FME Form GUI is amazing, thanks! Could you consider bringing back some colors to the navigator to distinguish more easily the Reader/Writer part to the parameter part and also the enable vs disabled status? Thanks!
The Safe Software Product Team is actively looking at the possibility of adding support for B-Spline geometry natively to the FME Geometry Model.Currently, we read in BSpline Curves in FME from MicroStation DGN files for example, by stroking the B-Spline into line segments, which FME then store as lines, which might not be what you want in your output if your target format or system does support this geometry natively. Currently B-Splines are read as stroked lines. Image markup is only an example for visualizing. Are you someone who uses AutoCAD DWG, MicroStation DGN, IFC files or other formats/systems where you encounter B-Spline curves? Do you care about bézier and NURBS curves (but really, do you?)? If any of the above sounds like you, especially about B-Splines, please drop us a comment if you’d be open to being contacted to provide feedback and early testing!
The ISO-8601 standard for week numbers in the DateTimeConverter is missing the Week 01 - 53 implementation, where week 01 is the one with the first Thursday of the year. This is referred to as %V in other scripting languages. Can this be added as a DateTime function?
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...?
Adding the row number on the interface helps you to avoid errors or forget something.For example, row number to check the amount of conditions that the Tester has.Moreover, highlight the row number if the attribute name already exists.
A fair bit of time working with FME Form is waiting, while you run your workbench to test and develop. To improve my productivity, wouldn't it be neat if I could get a little alert/notification when the workspace is finished? There are various hacks one can implement to work around - I solved it this way:https://gist.github.com/fraxen/ccca53cb496864123c82c7abdd4e12ee...but it would be neat if it was built in and did not require dirty hacks… :)
When I have a job that runs for 5-15 minutes (and this is with a subset of data) it would be nice to be able to sneak a look at the cached features at any point during the running workbench. I could click on the green loading box and see what features have loaded so far. This way I can be QC-ing output before the workbench has even completed running.
It would be really cool if I can write output as a PMTiles (https://github.com/protomaps/PMTiles) file.PMTiles is a single-file archive format for tiled data. A PMTiles archive can be hosted on a commodity storage platform such as S3, and enables low-cost, zero-maintenance map applications that are "serverless" - free of a custom tile backend or third party provider.
I would love to be able to create hyperlinks when writing out to MS Word documents!
It would useful to be able to read password protected Excel files (encrypted workbook). The password could perhaps be set as a reader parameter.
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.
People love formatting excel documents so they're pretty and represent what they want, me doing it again for FME to understand, not so much.It would be great if the excel reader could pick up if a column was hidden and add it to the Schema details, and if there was a Format Attribute that could indicate if a row was hidden.Or actually an option to not read them at all would also be good.
If you select a view called “banana” in the Revit reader but the view doesn’t exist in the file (for instance, in a parameterised or generic workspace), the reader will default to the first available view. This can lead to unwanted data being read, and cannot be controlled by the user without accessing the log file.Please improve the Revit reader by:Not reading any data if the selected view is not available Adding the view that was used to access data to the feature attributes
Please vote for this format if you think it should be in FME: https://www.geonovum.nl/uploads/documents/220405-JSON-FG.pdf https://docs.ogc.org/DRAFTS/21-045.html
Apache Parquet and it’s GeoParquet spinoff are increasingly used for data distribution and analytics, now the RaQuet format is emerging as an option for raster data. Vote here if you would like RaQuet supported in FME, and cite your use cases too.https://www.linkedin.com/pulse/raquet-raster-data-apache-parquet-javier-de-la-torre-chice/https://www.raquet.io/
I would like to request a reader that reads .sld/.qml files and a writer that writes .lyrx files. It would make things much easier for us who work with both QGIS and ArcGIS Pro.
Edit: Got the header of the post wrong but i cant change it. Should of course beTunnels: allow 1..N and N..1 connections Allow more efficient and cleaner workspace design with one-to-many connections for tunnels. Ideally if there is a 1..N or N..1 connection between transformers, one should be able to select all connections → right click → convert all connections to tunnels. The expected layout would be according to picture below. The N-side of the connection would only have one junction instead of N amount of junctions. Layout wise it is already achievable. It does however require many clicks as well as playing with alignment and placing tunnel junctions on top of each other. Therefore it is easy to snap connections by mistake.
The available system events is rather limited. Everything should be a system event! Here are several that I noticed are missing:Deployment Parameter published/created/updated/deleted Web Connection published/created/updated/deleted Resource published/created/updated/deleted Automation published/created/updated/deleted Schedule published/created/updated/deleted Stream published/created/updated/deleted Flow App published/created/updated/deleted Project created/updated/deleted
Is is not possible to edit the title of my posts in FME Community? I was searching for an option to do so but couldn’t find one. I can edit my post’s body. It should also be possible to edit the title in case I phrased it wrong or in a unclear way.
In-depth courses for all FME skill levels.
Explore our extensive collection of how-to guides and tutorials.
Log an issue with us. Our support team is ready to help.
