FME Form

I have 4 custom transformers saved to C:\\Users\\{username}\\Documents\\FME\\Transformers. I double-clicked them to install and they all installed successfully, but they don't show up in Workbench Transformer Gallery. I have clicked "refresh" and restarted Workbench, the refresh appears to run but doesn't generate any success or error messages. Any ideas how I could get these to display? I am running Workbench 2021.2. Thanks.

I have a few datasets of polygons and need outlines of the extents of each. Each polygon dataset has on average around 10,000 features and I need an outline of the extent of these to use in further processing stages e.g use as a clipper. Using the raw polygon data as the clipper instead is not an option due to how slow this makes the processing. I have tried dissolving the polygons however this does not make a single polygon for the dataset as some of the features are not adjacent to each other. I then tried aggregating, which does achieve what I wanted however is useless for further processing as the aggregate is deaggregated by most processes - effectively slower than just using the raw polygons.Hull building looked promising but does not accurately replicate the intricate boundary of each dataset. In ArcGIS it is possible to dissolve based on a common attribute rather than requiring a shared boundary. Surely there is a way to replicate this process in FME?

I've been trying to run a simple test, where I read in a 12D XML file, then write the same data back out. The 12D file is read in successfully, with all expected data and attribution, but when writing back out, there is an issue with the geometry of the included TIN. The TIN feature is written, but is missing all of it's geometry parts. The image below shows the TIN from the read input file:This image shows the same data when output to a new 12D XML file:The vertex pool exists, but with no parts. Anyone have any ideas why this may be happening?

Hello FME'ersWelcome to What's Up Wednesday Thursday, our slightly late roundup of FME news for the week. Recent PollsI try to do a fun poll on Mondays and recently we had "How do you feel about the Parameter Editor window in Workbench", with this result: Interesting to see how that window is used by a lot of users - but not everyone. My poll for this week was, "which is the last transformer in your Recent Transformer list"?  As you can see, mine was the AttributeExposer. How about you? Past, Current and Upcoming EventsStarting next week on Monday 6th December, we have the traditional 12 Days of FME co

i would like to get email from workbench when quick translator finish processing even if it fails or successes . i have tested and added the parameters in Emailer transformer and it send emails successfully .but i am not sure how to check the workbench if it successes or not before adding Emailer transformer .i have two output from my Workbench first output is excel file and the second is pdf file .Thanks in advance .FME 2018

error log:QUEUED:trigger success:

Hello,I want to split my citygml file into two by referring to a shape file which is an area.

I'm using a point on line over layer to split a long line into sections, I then need to create start and end points of each section. Simple process i've done a million times. This particular output needs to have the coordinates identical at the start/end of each section, theoretically they should be as they are split by the point at that location. The measure values are coming out identical, but some lat/longs are coming out wrong to the 9th decimal place - the issue is that its only a handful and so i'm not sure whats causing it. Any ideas?

Hello, I have a series of points that I would like to convert to a polyline feature. I have used the below workbench to accomplish the majority of it, but I'm stumped trying to fill in the gaps (in the line). Can anyone point me in the right direction? 

FME Desktop 2020: How to delete All layers (feature classes) available in the destination esri file Geoddatabase before writing on it from a workbench? For example, in the screenshot below, I wanted first to delete all layers that are available in the destination esri file Geoddatabase before writing in it How this could be performed?  

I tried FTPCaller using the full path to the file I want but I am unsure of authentication as it seems undocumented. I am unable to use username and password and must use SSH key files. Setting to ssh-agent seemed like the way to go but how do you choose your key file? I am publishing to Cloud anyways so I thought I would look at what was there and seems there is upload capability for sftp using a subscriber and ftp watcher (no sftp). Am I missing something?

I can see it in the reader parameters (Version From Historical Date and Time), however none of the attributes stick out as the correct one to expose.

I would like to know how many parts are part of the IFMEAggregate for each record. Are they always polygones? How many records contain lines etc.

Hi, @david_r​  help find a solution. I have a long line with a large number of segments, how could I extend the last sides of it, with the same angle, till the first intersection with another line or edge of the polygon.

How can we download the workbench from the FME server showing the output of each transformer in the downloaded workbench? I want to get the joins and unjoins from the databasejoiner transformer.

 I´m right now trying to learn the basics of FME and have been busy doing calls to open data in Sweden, primary published as json files. I have managed to read the, and explode a list and write back to an excel file. I now try a larger dataset of about 1 million rows. I can not figure out how to extract more than the limit 500 records. I have tried searching in the forum an Google without understanding how to proceed. I attach the links to the dataset below. I would realy appreciate if someone could show a setup that loops and writes all data to a csv for example.  Dataset:https://www.vgregion.se/ov/dataportal-vast/#esc_org=https%3A%2F%2Fcatalog.goteborg.se%2Fstore%2F6%2Fresource%2F1I

Hi, I have a workbench that joins and manipulates data, then at a certain point it reaches an aggregator and creates two columns:Column 1 output sample:20688<br>1476<br>14633<br>14516Column 2 output sample:560 Hague Street LAVINGTON NSW 2641<br>449 Smollett Street ALBURY NSW 2640<br>601 Stanley Street ALBURY NSW 2640<br>599 Stanley Street ALBURY NSW 2640After this aggregator I am trying to send an email which includes a simple output body like: 20688 - 560 Hague Street LAVINGTON NSW 2641 1476 - 49 Smollett Street ALBURY NSW 2640 14633 - 601 Stanley Street ALBURY NSW 2640 14516 - 599 Stanley Street ALBURY NSW 2640Any ideas how to get it from the simple aggregator with these two outputs into an email? 

OK, here goes.  I have some data in a SQL Server database but it is stored in an object-oriented fashion which means a normal SQL query doesn't work, I have to pivot data in order to create a traditional tabular view.  Now that in itself wouldn't be a problem, but all data is stored in the same location with each asset class (e.g. door, window etc.) having a different number of attributes, so depending on how I pivot I get the relevant attributes as fields.  All good so far?  OK, so I want to push this data from the source database into the target database (Oracle in this case) and the method for doing this is currently using SQLCreator to create the fields by which I want to pivot (based on the asset class as a parameter) and then SQLExecutor to retrieve the pivoted table, which works, up to a point.  What doesn't work is that the attributes of the output from the SQLExecutor are not exposed, and I can't get them to be exposed without Populate from SQL Query option, which fa

I am using FME 2019.2 to read multiple Autocad drawings (r.2018) and then write them out into a single combined DWG. I've referenced a template file with all of the block definitions in it for the writer, but cannot seem to get any of my CAD blocks to write. The log tells me that "AutoCAD Writer: 3189 feature(s) were rejected and not written to the destination dataset", but doesn't give any hint as to why they were rejected. I've tried this using both the RealDWG and Map OD readers & writers, and I've tried it both with and without a DWG Styler transformer. Why are my blocks getting lost in translation?

Hi, I want to create a dynamic workspace. I have an excel file and I want to execute everything from there. I want to send database information for sqlexecutor via excel. but I couldn't find how to add format and dataset information. Is such a thing possible? 

I work for a deck building company that consistently needs to find lot boundary markers, but due to lack of information sometimes we are unable to identify where the boundaries of a lot are. We are exploring and trying to find ways that we could easily find the part of the lot that is the physical boundary marker of the property. Assuming we are able to find longitude/latitude coordinates, we are looking for software that could allow us to enter that information in a smartphone in order to be guided to that point on a map on smartphone. Thanks for any input you may give!

Hi, I haven't used FME in quite a while due to the flu outbreak. I have FME 2017.1 and have found that it will no longer reach in to my SDE due to the Legacy deprecation from ESRI. Are there any transformers I can use in 2017 that I can use?

Hello FME community, I have a long number (see the picture). I want only up to 3 decimal places to be displayed. Thanks in advance for your help 

I would like to know if FME has a reader and writer that directly read and write data back to the ArcSDE database.

Hello, I have a large workspace and there will be more developers that will develop it.I was wondering if we can use Git from inside the workbench. A visual diff that would identify changes in nodes and their properties, like e.g. Node-RED does, would be extremely useful.We already have the project in Git and treat it like a binary file.