5 votes
Accepted

FME : Populate a column in Table A with the value(max) from StatisticCalculator transformer from table B

OK so with the comment of @Mapperz (thanks) I've got a simple solution (I was sure there would be...). Use the attribute manager to create a join field on both tables with a common value, then pass ...
lhowarth's user avatar
  • 531
4 votes

How to calculate distance to nearest neighbor when new candidates are created over the years?

Few steps to this process, the first of them is running a Python Script, purpose of the script is to prompt the user to select the two layers containing the House data and Turbine Data. Once that is ...
ScoGer's user avatar
  • 315
3 votes
Accepted

FME DateFormatter is not correctly setting white spaces to null and DateTimeConverter doesn't offert this option

To give you the long story, all invalid dates/datetimes used to be set to null in the output, but that wasn't a great idea because you could never tell what the original value had been. Hence, we no ...
Mark Ireland's user avatar
  • 13.1k
3 votes

FME 2021-22 delete features in GeoPackage

There are a couple of ways to do this. You just run the original workspace again, and create a new GeoPackage. Make sure it's set to overwrite, not append, the original file. You send only the ...
Mark Ireland's user avatar
  • 13.1k
2 votes
Accepted

Compacting table in FME?

The simplest part is to use an Aggregator transformer, with the Group-By set to CODE. Then you'll get two features, as shown in the After table. The question then is, how do we handle the attributes? ...
Mark Ireland's user avatar
  • 13.1k
2 votes

How to calculate distance to nearest neighbor when new candidates are created over the years?

That's an interesting problem to solve in FME. In short, the NeighborFinder won't do what you want by itself; there needs to be a little pre- or post-processing. I can think of a few methods. The most ...
Mark Ireland's user avatar
  • 13.1k
2 votes

Using FME Stringpadder

In the simple workspace the text (hello) is padded by the character % as hello (5 digits) by the Stringpadder is told to pad by 7 digits. the Stringpadder adds two extra %% (percentage characters). ...
Mapperz's user avatar
  • 49.7k
2 votes

Joining CSV to feature class in oracle dB and writing out matched records to feature class in file geodatabase on local machine using FME

The error states that you are creating a feature class for polygons, but are writing no geometry. So that gives us a few options to consider: If you truly don't want geometry in the feature class, ...
Mark Ireland's user avatar
  • 13.1k
2 votes

Creating an ascending network of strings using two columns

I'm not sure I understand fully, because in your example I'm not sure how the second output is 1-5-8. However, this may help somewhat. Firstly, place an AttributeManager. Open the parameters and ...
Mark Ireland's user avatar
  • 13.1k
2 votes
Accepted

FME issue while updating AND inserting data in Esri Geodatabase (File Geodb) writer

I have already encountered this issue; it was due to excessive/duplicate nodes in some of the polygons. Check even the "full" polygons, sometime the missing features change with the scale or ...
Calti's user avatar
  • 36
1 vote

FME Server - Can't Enter to FME GUI

When you have these kind of issues with FME Server (or FME Flow now), you should restart your machine, this solves most of the issues. You won't see FME Server in the services, it will be show as &...
GforGIS's user avatar
  • 2,776
1 vote

Deleting features based on matching attributes in Feature Service using FME (similar to row selection)

I have not tested this, but if I interpret the docs correctly, it will be done based on the objectid. From the documentation: Object (Feature) IDs When a Feature Service is created, ArcGIS Portal will ...
nielsgerrits's user avatar
  • 3,894
1 vote

FME restart identity sequence when using Truncate Existing in the writer table handling drop-down menu

This isn't quite the answer you're looking for, however, as I see it there are two options. On the writer Feature Type there is an option in the Advanced setting to Allow Serial Column Writing. If ...
virtualcitymatt's user avatar
1 vote
Accepted

FME Counter transformer - Assign a grid with numbers, change order that features are counted

I think the counter is fine, you just need to sort the data in a different order. One way to do this is to use the BoundsExtractor to get the min max x y. Then use a Sorter _ymax Numeric Descending ...
nielsgerrits's user avatar
  • 3,894
1 vote
Accepted

Write a raster to an Esri ArcSDE geodatabase using FME

I think you may be using the wrong writer. You probably have "Esri Geodatabase (ArcSDE Geodb)" and need "Esri Geodatabase (ArcSDE Geodb Raster Dataset)".
nielsgerrits's user avatar
  • 3,894
1 vote

Case tools, or wider if, else if, else if (etc.) tools in FME

That's an interesting question. I think that there are multiple ways of handling this scenario. The first is to use Conditional Values, as you currently are. It's really what that tool was designed ...
Mark Ireland's user avatar
  • 13.1k
1 vote

How many workspace, readers and writers to use in FME?

There are a few factors (particularly, how much do you want to push the performance), but in general: One workspace One reader to read the Excel file One writer for each format of data you want to ...
Mark Ireland's user avatar
  • 13.1k
1 vote

Fast column binding in FME

If you use FeatureMerger in a 1=1 comparison, then you're going to see every record in the table merged with every other record. I can imagine that would be quite slow. I think the better method would ...
Mark Ireland's user avatar
  • 13.1k
1 vote

FME Postgres Serial - Red Attribute

You have not done anything wrong. This means that FME does not know where to get the data from and save it into that attribute. If you do know however, you could just connect the attribute manually by ...
GforGIS's user avatar
  • 2,776
1 vote
Accepted

FME data conversion from CityGML to GeoJSON results in multiline not multipolygon

In FME Form Workbench, use the 2DForcer Transformer to convert the 3D objects to 2D. More information about the transformer is available here. Then add the AreaBuilder transformer to build polygons ...
GforGIS's user avatar
  • 2,776
1 vote

Install FME Server on 2 nodes sharing the same FME Flow System Share and FME Flow Database (PostgreSQL SQL DB)

Yes, you can do this, but - as noted - it's not the best setup. You have two separate installations with no knowledge of each other. The official method with a load-balancer is better because your ...
Mark Ireland's user avatar
  • 13.1k
1 vote
Accepted

SR-ORG:8369: _MI_0 - What coordinate system is it?

Do you know what coordinate system it should be? I think the simple problem is that FME doesn't recognize it. _MI_0 is just a temporary coordinate system. Take a look in the FME log window for lines ...
Mark Ireland's user avatar
  • 13.1k
1 vote

FME Form - Measure FME transformers execution time in the FME workbench

When I have to do something like this I parse the logfile tot Excel, calculate time diff between rows and work from there.
nielsgerrits's user avatar
  • 3,894
1 vote

How to get a notification or email through FME desktop or FME server if downloaded table all the fieldvalues are "NULL"

For the logic part, there's a transformer on the FME Hub called AdvancedSorter. It lets you include nulls in your sorting. So set it up like this: The point is to sort Nulls after any data. Then use ...
Mark Ireland's user avatar
  • 13.1k
1 vote
Accepted

Use FME to remove columns with all missing values

So, there are multiple places you might want to remove the attribute. If you want to remove it from the workspace itself, then you need to do it manually, say with an AttributeManager. You can't do it ...
Mark Ireland's user avatar
  • 13.1k
1 vote

Why are features showing up near Malaysia when using the Michigan State Plan South coordinate system?

The first possible issue is that you don't have a method of storing the coordinate system defined on the AutoCAD writer. To fix that issue, carry out these steps: Look in the Navigator window for the ...
Mark Ireland's user avatar
  • 13.1k
1 vote

FME Compare polygons from two datasets

I think there are a few ways to do this, but since you have two different datasets, the ChangeDetector transformer should do what you need. The ID attribute is chosen under Update Detection Key ...
Mark Ireland's user avatar
  • 13.1k
1 vote

Extending lines to edge of polygon, but not where start/end point intersects another line

Was searching for the same solution and found an easier way than mentioned above. If each polygon has a unique ID (or create one if necessary) prior to creating the centreline then the centreline and ...
Roger's user avatar
  • 11
1 vote

Converting "string" date to "date" format using FME

Year 2023, you can do this: Format date into one with FME (part 1) Regex filter https://transparentgov.net/cleargov1/1193/format-date-into-one-with-fme-part-1-regex-filter Format date into one with ...
hoogw's user avatar
  • 1,712
1 vote

How to extract a small area from a big GTFS feed?

Another alternative solution to restrict GTFS in python is mrcagney/gtfs_kit, which exposes the feed.restrict_to_area(bbox) method. This is how I managed to get it working, as other solutions ...
Ivotje50's user avatar
  • 281

Only top scored, non community-wiki answers of a minimum length are eligible