Shape the future of FME with your ideas
Open ideas have been reviewed by our Product Management and are open for commenting and voting.
Add an optional parameter to assume the first row of a table contains the column names (see https://community.safe.com/s/question/0D54Q000080hfEGSAY/problem-by-reading-of-html-table?t=1597311083500).
It would be nice to be able define the Time Zone at which a schedule runs instead of the time zone in which the instance lives.
It's possible you forget you have a reader disabled and when you run your workspace, it's not part of the result. Would be nice if FME notifies you before you run your workspace that there are readers/transformers/writers disabled (and which ones).
Hello, here's something I've come across many times in FME. When a translation sends no records to the writer, no files will be written for that writer. This means that if I am updating something daily and one day no records are sent to the writer, the file will remain as the day before (outdated), and this could cause confusion to customers.It is the same issue expressed in this thread https://knowledge.safe.com/questions/3785/empty-mapinfo-tab-or-shape-file.htmlHowever, no satisfactory answer is provided.The idea would be to include an option (a checkbox) in the writer or in the workbench to "allow writing empty files if no records are sent to the writer".The thing is that some systems need a file to be there, even if it is empty. Otherwise, loading will fail. So things like, removing all the files from folder before running the workbench won't work for me because the system is requiring all the listed files.Probably this is something that many people has come across already, and there are many workarounds, but this option should at least be considered, as it would save a lot of time applying those workarounds.Hope that makes sense.
***Note from Migration:*** Original Title was: Neighbourfinder: Possibility to use Start and Endpoints only for finding Neighbourhood Problem:I often Need only to use start- and end-Vertices of lines to pass through the neighborfinder-transformer (as well as Networktopologybuilder)So I must use the Workaround to:1. use the Counter to get an ID for the lines2. coordinateextractor 2 times do get first and last coordinate3. vertexcreator to create start and endpoints4. use the neighbourfinder to find out wheter a line's start- or end-vertex is nearby (what I actually wanted to know!!)5. use the featuremerger with the original Feature to get the Information on the original-FeaturePossible Solution:Upgrade the Neighbourfinder with the Parameter "used base geometry" with the possible values:"All Geometry" -- means the whole geometry, including lines between Vertices"Start-Points""End-Points""Start and End Points""All Vertices"This could be also helpful with the networktopolgybuilder (Start and Endpoint could help!!), because a lot of users seem to have problems with selfintersecting Features and other "invalid" Features (sometimes the Invalidation is only in FME, not in Reader or writer, where e.g. selfintersections are allowed)
Improve the Attribute Range Mapper to allow you to specify whether From and To ranges are inclusive or exclusive. Currently they are always inclusivee.g.Greater than or equal to 0 but less than 250Greater than or equal to 250 but less than 500
I love the emailer transformer- it's great, however, there is one limitation which is a little annoying which I think would be nice.Sometimes you want to attach an unknown amount of attachments to an email. At the moment you must zip them up (which is fine, but not always desired). If you want to work around this it's a little annoying an involves multiple emailers each with a different number of attachments defined .The solution would be to allow a list attribute. It's pretty minor really but would be a nice to have.
It would be good if the SQL Executor operates the same way on any database formats its supports. Recently I've had an issue whereby I cannot execute a 'DELETE from <my-table>' statement on SpatiaLite, but I can execute the same statement on Oracle Spatial. See the following Knowledge Centre question and supporting answers/comments at https://knowledge.safe.com/questions/50230/sql-executor-and-spatialite-delete-or-drop-command.html
It would be nice to control a job's running expiry time by which Queue it's been assigned to. At the moment Queues can be configured to a specific Repository, Engine, and designated a Priority level. So for example:Fast Queue ( < 15 mins )30 Min Queue ( 15 mins - 30 mins )60 Min Queue ( 30 mins - 1 hr )Slow Queue (1 hr + )1) This would help when your limited to a small number of engines and have to manage a high volume of jobs.2) It eliminates processes that may hang up an engine or two and cause the FME Server Job Queued List to rapidly grow. This could be to due to external sources. i.e. Database Performance Issues, Memory Constraints, CPU Constraints, and other constraints from a data source or target source perspective...3) You wouldn't need to then set the running job expiry time parameter for each individual schedule or automation, which makes it easier for FME Admins and Authors. 4) It would be easier to designate the correct Queue for a schedule or automation. You wouldn't be mismanaging Queues and you'd be able to minimize the amount of time a job is waiting for an available engine on the Server. Related to: https://community.safe.com/s/idea/0874Q000000TkrlQAC/detail
FME_SHAREDRESOURCE_TEMP and FME_SHAREDRESOURCE_DATA as a System Parameter that a user can preset the UNC in Desktop, Server/Cloud:Desktop:FME_SHAREDRESOURCE_TEMP = D: empFME_SHAREDRESOURCE_DATA = M:myprojectmydataServer/Cloud:FME_SHAREDRESOURCE_TEMP = /Resources/Temp/tempFME_SHAREDRESOURCE_DATA = /Resources/Data/myproject FME_SHAREDRESOURCE_TEMP and FME_SHAREDRESOURCE_DATA parameters can be used in a workbench for reading and writing data. When run on Desktop or Server/Cloud the data is read from or written to the specified location, no adjustment of the UNC in the workbench required between environments and no need to setup your local folder to mimic Server. Discussed with @smaccabe
It would be nice if the location and size of windows was stored. I always find myself resizing the list of attributes to select for the attribute keeper and attribute remove transformers.
To accept values like: urn:ogc:def:crs:EPSG::4167The context here is I'm building an ArcGIS ModelBuilder tool that sends spatial extents to a Spatial ETL tool from the active map, but in arbitrary spatial references, so the extent needs to be projected to match a WFS feature type DefaultCRS.
I'm working with a customer who is planning a data migration from one document management system to MS Sharepoint. At the moment we are looking at what options there are to use FME to do this via the Sharepoint Web Service to see if its possible to tackle this with a custom transformer or similar.It would be great to write more than just Sharepoint lists, especially as in this instance we're talking about migrating 5 million documents.
As an FME AR app user, I'm very interested in the Geolocation function. With this addition, we'd like to use FME AR in the field.
FME dates are irritating when working with MS SQL as I can handle dates more effectively in MS SQL.I have a workbench that processes 100+ CSV files, each file has a different structure so I process each file dynamically.Dates can be formatted as 19 Sep 2011 13:09:00 or 19 Sep 2011 13:09 which MS SQL is happy enough with but FME isn't.At the moment I use a Python script to load the full file and do a regex replace to resolve the FME date issue.It's really bad that FME simply nullifies any date issue so it is quite possible we are unaware of issues.
In the postgresql database, I work with sequences that are used by several tables (global). Unfortunately it is not possible to fill with FME data sets and to address the global sequence.The following error message currently appears if the ID is left blank on the writer:Bulk copy failed on table 'edit_gbki.spielplatzstammdaten' using delimiter ':'. Error was 'FEHLER: NULL-Wert in Spalte »t_id« verletzt Not-Null-ConstraintDETAIL: Fehlgeschlagene Zeile enthält (null, b474294c-8d3f-4c66-8085-69f59266582d, 15, 210, 1, 2920, Mosergarten Spielplatz, null, ...'
Would be AWESOME to have a transformer where you could pick a list element and have it flatten out the list into multiple attributes on the same record.
while using the "Directory and File Pathnames Reader". I need to be able to iterate through created output to get the latest file created. At present I have to manage the output into separate folders. And the only means to get a latest file in any given folder is to sort by date modified and then sample the list with [1] as the sample rate. It would be nice to be able to determine the exact latest date. this is similar to the idea for a sorter but takes it one step further.
Add function to skip reading some components in a transformer.For example:Feature Merger - If user only needs to read MERGED output, add a skip or turn off function on other output such as Used Supplier or Unused supplierorStatistics Calculator - add possibility to skip/ turn off Complete output and only run Summary output (or vice versa
Hi FME’ers, I recently work with QR Codes and I was curious if FME supports those Codes. As my Server has no access to the internet (security reasons), the provided GOQRCodeGenerator or the google API is not of any help. Is it possible to build a native QR Code Writer for FME? Maybe based on some open source projects like qrencode (linux).Best regardsRoland
Metadata is important. You know this as well. Yet I think the reader/writer support for those formats are lacking, to say the least. I am aware that the title asks for more than one format so lets break them down:OGC Catalogue services for the web uses XML (admit, you love xml ;-) ) and have several good standards for content. A reader for searching and displaying posts from a metadata portal is increasingly important as more and more national metadata portals goes live.CKAN and DACAT-AP are both common government and EUtypes of metadata portals. There already exists a CKAN writer plugin (https://github.com/OpenGov-OpenData/CKAN-DataStore-Writer-for-FME-Software) but I think it sholuld be integrated into the main software.scripting ESRI metadata management is lousy at its best. As with ogc catalogue services it is based on xml (more love) and both a reader and writer would greatly improve life those of us working with enterprise databases, file geodatabases and even shapefiles.I have marked FME Desktop as the space below but I believe one can have great use of this on server as well.
***Note from Migration:*** Original Title was: Respecting field name length limitations and reserved keywords per feature writer type 1) Field name lengthAs the maximum length of a field name in various formats is known (databases, shapefile, etc), it would be very helpful if FME Writers validated this on attributes entered.https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/enterprise-geodatabase-limits.htmhttps://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/enterprise-geodatabase-limits.htmhttps://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-file-gdb/file-geodatabase-size-and-name-limits.htm2) DB KeywordsIn a similar fashion, there are reserved keywords which can't be used as field names in many formats - this could also be validated on writers.https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15Error messaging for this in the translation log could also be clearer.
The time has come. I ditched python 2.7 at my first client when upgrading server to 2019.1And now of course, some workspaces using python don't run anymore, but which among the approx. 100 workspaces do use python, and have the version set to 2.7??I went for the .fmw reader, reading all .fmw files in the repository-path. With the Transformers features, I did find all workspaces containing a PythonCaller transformer.But, for this task it would have been super helpfull If I could read all private parameters (looking for python scripted) and read all of the workspace properties (especially the python startup- / shutdown-scripts and the Python Compatibility setting).So... Add all workspace properties and the private parameters as features to the .fmw reader please, as a help for all future upgrades....Kind regards,Martin
Restart core and engine services from the web UI
Keybase is a key directory that maps social media identities to encryption keys (including, but not limited to PGP keys) in a publicly auditable manner[. Additionally it offers an end-to-end encrypted chat and cloud storage system,] called Keybase Chat and the Keybase Filesystem respectively. Files placed in the public portion of the filesystem are served from a public endpoint,[as well as locally from a filesystem mounted by the Keybase client.Keybase supports publicly connecting Twitter, GitHub, Reddit, Hacker News and Mastodon identities, including websites and domains under one's control, to encryption keys.Keybase is a powerful tool and it would be great to see FME connect to this platform using a connector similar to the SlackConnector
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.
