FME Form

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 get null values). In Python this can easily be done by using pandas and the option "ambigous='infer'":import pandas as pddf = pd.read_csv(file, sep=';', parse_dates=['dt'])df['dt'] = df['dt'].dt.tz_localize('CET', ambiguous='infer')For thi

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 use PointClusterer from FME Hub (the wrong Python version). Thanks in ad

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: FME evaluates and extracts attributes using such logic: It works well and I'm getting what I need: But I have a question what to do when I have some more specific logic. For example, I have cases when I need to concatenate the fields into one field. How to pass this to FME to evaluate such expression?    

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? 

I've created an excel sheet with a series of dataset names and different equations to run against them e.g. @Value(COV_LEVEL)-@Value(INV_LEVEL) Using fme_feature_type and FeatureMerger I am able to get my datasets and the required equations together. How do I tell FME that to use the content of my Feature Attribute as an equation and action it rather than as seeing it as a text string? thanks

I have some date with id-blocks, meaning there is a column where one and the same object is represented of several features, with different attribute values, but always with the same id for these features.How many features there are per object varies.I was thinking to build some 'decision-tree' in an AttributeManager to find the correct features of such an id-block to process further. Unfortunately, the AttributeManager is not a group-by transformer and I was wondering how can I group my data by id, and process the resulting group, before the next group is created and processed.

Hi Community! I would like to know how, if possible, I can move workspaces from one fme server to another using the rest api. The overall goal is to use the rest api to backup the contents of one fme server onto another. Has anyone done something like this in the past and if so what did you do? Cheers,John

I'm trying to do a spatial join between two AGOL layers, one is a strip map and the other is parcel data with owner info. I want to merge the two and create a table with the owner information and its respective page number.  I have been using the SpatialRelator tool; the parcel data are Requestors, the strip map pages are Suppliers, Spatial Predicates are intersects/touches/within, and merge attributes are checked with Merge Supplier as the Accumulation Mode and Supplier as Conflict Resolution. The SpatialRelator will create a table with all attributes merged but all of the supplier data is shown as "<missing>" (and it's definitely not missing in the AGOL layer). I have tried a few different combinations of this but I just can't seem to populate the entire table. Has anyone ever encountered this problem?/Does anyone have any ideas on a fix?

I have a MHWS and along the MHWS line the elevation from the DEM varies. I want to locate the 2metre elevation point relative to the MHWS Line. Could you please suggest an approach that would work to identify this and convert to a line

I normally run FME Desktop at the office, where I'm storing named connections and associated files on an office network share, in order to facilitate sharing these between the development and production desktop licenses.These files are backed up to my local drive every day.Now, when I'm trying to run FME offline, without access to the office network, FME refuses to access the named connection, and even bars me from reading from a local SQL database although all connection data is entered manually.This also happens after I change the references in under options to point to the local backup copies of the files in question.WTF?Why is FME refusing to work normally in this manner ?Version 2022.2.2

Has anyone else experienced this? I'm using FME 2022.2. If I pick an attribute from the arrow drop down menu, it inserts it in the DateTime Attributes field as @Value(CREATETIMESTAMP). When the transformer runs, it doesn't convert the value. But if I select the attribute from the 3 dots menu, it's fineIn the 3 dots menu chooser, there are sort of two sets of the attributes....