FME Form

I have a file geodatabase and a feature class called "Boundaries".I am using the Esri Geodatabase (File Geodb Open API) reader and I would like to apply this WHERE Clause, but the WHERE Clause is disabled."COUNTY" = 'Will County, IL' Is this a way to use the "SQL To Run Before Read" to achieve this? It can be found when you click on 'Parameters' and in the 'Advanced' section of the Esri Geodatabase (File Geodb Open API) reader.

Hi. Can FME workbench read a .gws file? I only found this linkhttps://community.safe.com/s/article/fme-and-intergraph-geomedia-compatibilityThanks

I get the data from two different databases, which contain a point layer, and a surface layer, I combine the two layers using a transformer called FeatureMerger, and it works fine. I write the result to a third database, where the layer is a surface layer. All the fields with data that I want are included, but when I send the data to an sde database in the writer, information is missing in two fields. In the writer, data type = char is set. The information that is missing is data type = text, the number of characters is correct when I look in the writer. What is it that is wrong? Why doesn't the information that is in the two fields come along?

I am trying to combine symbols consisting of donuts and polygons into a DWG block. The problem is that the areas are displayed incorrectly in the DWG. With the option "Prefer writing donuts as hatches" set in the DWG Writer ( even in the RealDWG Writer) the symbols are displayed as follows. The donut polygons are displayed correctly, the simple polygons only as a line. If I deactivate the option, all polygons are displayed as a line. The creation of the block is controlled by the attribute autocad_block_name.  Can someone help me? Thanks a lot Edit: I also tried to generate the DWG from an Aggregrate

The Python package <numpy> in FME is using version 1.15.1 and I want to switch to version 1.16.1. Already tried to force reinstall:fme.exe python -m pip install --upgrade --force-reinstall numpy==1.16.1 --target C:\Users\301650\Documents\FME\Plugins\Python\python37It does install numpy 1.16.1. However FME Desktop is still using numpy 1.15.1. Is it possible to uninstall Python package in fme.exe python? It would be nice if command below does work, but currently it does not: fme.exe python -m pip uninstall numpy --------------------------------------------------------------------------------------------------------------------fme.exe python -m pip uninstall numpy Python version 3.7 loaded successfully Usage:  C:\Program Files\FME\fmepython37\python.exe -m pip uninstall [options] <package> ...  C:\Program Files\FME\fmepython37\python.exe -m pip uninstall [option

I note that ArcStroker will stroke CircularStrings but my testing indicates it won't stroke CurvePolygons and CompoundCurves. What transformer will allow me to so stroke those geometries?Simon

A quick question on “LineonAreaOverlayer” Transformer in FME. I am using this transformer to connect WW pipe data from a council (in line format) with some environmental data (in area format in GIS layer) to analyse integrated data. However, when I am connecting this two layers in FME…I have originally 14, 000 WW pipesBut, when I am connecting this pipe layer with the environmental data layer using above transformer in FME… the number of pipes get almost 50% more say about 21,000 pipe recordsThis makes sense to me as per the description of this transformer which says: “The LineOnAreaOverlayer compares lines and polygons, splitting the lines where they intersect with a polygon boundary. Each resulting piece receives the attributes of the area(s) it is contained in, and each containing area receives the attributes of the line(s) that either fall within or intersect it (a spatial join). Features also receive a count of the number of ov

We have a custom application that calls and polls telephone numbers using an analog modem on COM1 port. I would like to port this application to FME and I have been unable to find any native transfomers/readers/writer that can communicate with COM Port1. Question:Can FME natively communicate with COM Ports ?If so, how is this done.If not, any suggestions on how to make with work

Hello , i have around 10 GB DGN files and it takes time to load in FME and and it seems slowly to work with them .i would like to know , if there is best method to work with DGN files ? Or should I convert them to other format ,if it will be besser then I work with them in new format ?FME 2021 Thanks in Advance

I have a time series with ambiguous dates due to the daylight savings time change that I would like to convert to unique datetimes with time zone information: 2021-10-31 02:00 > 2021-10-31 02:00:00+02:002021-10-31 02:15 > 2021-10-31 02:15:00+02:002021-10-31 02:30 > 2021-10-31 02:30:00+02:002021-10-31 02:45 > 2021-10-31 02:45:00+02:002021-10-31 02:00 > 2021-10-31 02:00:00+01:002021-10-31 02:15 > 2021-10-31 02:15:00+01:002021-10-31 02:30 > 2021-10-31 02:30:00+01:002021-10-31 02:45 > 2021-10-31 02:45:00+01:00I tried to do this in FME with the "TimeZoneSet"-function as described in https://community.safe.com/s/article/converting-time-and-date-fields-to-local-timezones. This works for all datetimes except the ambigous ones above

I am trying to automate some quality tests & I need to calculate the distance between the points in a consecutive manner. So, each point needs to be  '50-100 feet' apart from its previous point. I am unsure which transformer(s) would be the most efficient & haven't had much luck looking online. Thanks!

Hi FME Users, I have a list of points with coordinates and a lot of attributes. Based on this dataset I need to create (different size) polygon clusters, which depend on the criteria - such as distance from competition points, cluster density, number of POI in this cluster, and others.  Firstly I filtered data based on some criteria (eg. types of points, etc). Then I used NeighborFinder to find and filter these points which are too close to competition points (distance is defined by users as a parameter). But I am not sure how to create the polygon clusters.  I thought about using HexagonSample (custom transformer), NeighborhoodAggregator, or H3HexagonalIndexer. But unfortunately without any successful results. Maybe, someone from you had a similar task and could suggest how to approach this problem? Any tips or ideas from all of you will be very helpful! I am working on FME 2022.0, so it seems to me that I cannot

I'm beta testing the new FGDB 'preserve GlobalID' parameter in 2023 build 23215. It does not seem to be preserving the values. In the test dataset I've attached, the GlobalIDs are used for relating the attachments table to the feature. Is there something else that needs to be done to ensure the values are preserved, besides setting the parameter to Yes?

I have 3 datasets that are fme_time schema type and I want to use the AttributeManager Conditional Value to set if/else statements depending on which time values are missing. When I do this, the resulting attribute type is fme_varchar and not fme_time. If I create a new attribute and point to just any one of these attributes, the new resulting attribute is still fme_time. So it appears the conditional value setting is changing it and I can't figure out how to change it back to a time. I have tried parsing, formatting, casting and nothing changes the varchar back to time. Are there any ideas to fix this?  

This week my AutodeskBIM360DocsConnector stopped working and I am no longer able to read data or browse through the hub. It still works fine to authenticate in the web connection. Is there a way to troubleshoot the connection in the transformer? Seems like nothing is logging in the log window cheers

I'm creating a dynamic workspace which reads Excel sheet as a configuration and extracts data from a Feature Service. Configuration file looks like this:FME workspace looks like this:Feature reader reads every row in configuration file and extracts data for the listed Feature services. It outputs everything through the generic port.  In the configuration file I have field mapping information where attribute fields in a feature services are mapped with the output fields I need: 

I have too many points A and too many points B and I have many small polygons . every small polygons contain point A but some of them include point B . i would like to to find each point B that close to point A but it should be at the same small polygon if point A does not find point B ,at same small polygon so it will be better if i can mark it .that no point B close to point A .FME 2021Thanks in advance

I am trying to read an arcgis dimensions file from an sde . While reading i am getting the error "Unable to convert row to 'DimensionFeature'". i need to read the dimesions and need to convert them as a line feature.can you please hep me to resolve this issue.

I have a 3D meshes of buildings in a Rhino file that can be exported as a .obj or .fbx and want to use the fanout expression to put each building into an individual file/folder. The exported file (both .obj and .fbx) dont have any attributes and is read as one cohesive mesh so I am unable to assign any attributes to them to split up. How would I go about this workflow?

In the attributemanager, I declare the igds_model_name which is an atttribute for the model name and is determined by feature_type. Therefore in theory every feature should be written to their respective model. I also declared the model names in the seed file of the dgn, but for some reason the specific features are not written to their respective model. I was wondering whether it's possible to write features to different models in a dgn file and how one is able to do that. 

Hi,No data area of geotiff generated from 'HillShader' can't be shown as transparent in ArcGIS. If it's shown as RGB it contains ALPHA band, but if I choose 'stretched' in symbology, Alpha band is missing, nodata has been shown as black?Anybody knows how to show nodata as transparent in ArcGIS if the hillshade output generated by FME?

I have a simple workspace to generate some web tiles.   I first used WebMapTileClipper to break the data into vector tiles.   I next ran each vtile through MapnikRaster and grouped by _tile_column & _tile_row. I next sent each raster to WebMapTiler. See my attached workspace image. It seems that WebMapTileClipper and WebMapTiler do not agree on column and row. WebMapTiler generates an extra tile for many of the same tile coordinates. In my attached example you can see that MapnikRaster generated 1 image for _tile_column: 978 and _tile_row: 1655 however WebMapTiler generated 2 tiles. Any advice would be greatly appreciated. Richard Carmel 

Looking to extract 12 different unique number values in a CSV file. What would be the ideal way to accomplish this task. TIA

Hi all.I'm trying to update single values in a table, which has 3-4 keys. The three keys are mandatory, while the 4th is optional.A writer will apparently only update records which has a value for the 4th parameter, erroring when this value is NULL.Why is that ?I tried to test for the NULL value, but that didn't work. Apparantly the value needed to be tested as being an empty string, not a <null> value, even though that was what it contained.Is that a bug ?And lastly you - again apparently - cannot simultaneously have a writer/update and a SQL Executor (to handle the NULLs), the writer blocks the SQL Executor. I had to ditch the writer and go with two SQL Executor's.Why does a writer block transformers ?All this a s a warning to y'all. Can anyone confirm these findings ?Cheers.2020.2 / MS SQL Server

We use file geodatabase replicas to edit our enterprise SDE geodatabase. Edits made to these file geodatabases by FME are not recognized as "changes" when these replicas are synchronized to the master.Has anyone found a way to solve this?I see a post from Mark Stoakes (about 5 years ago) where he explains that FME cannot make entries in the change tables maintained in the replica - which definitely makes sense.Just wondering if anyone has possibly solved this?