Transformers

I have a PostGIS query which involves interating over a cursor and inserting the results from each iteration into a temp table. Once the loop has finished the the results of the temp table are returned. FME is reading the geometry field as an attribute not as the geometry. I've now run out of ideas - I've tried renaming the geometry field, explicitly casting the output as Geometry type, adding an index on the geometry field on the temp table. Nothing works. This is the query (it's for find how long it takes to get from several points (in the `nearest_nodes` parameter) to all other points on a network within a set time ( the `maxDrivetime` parameter), by multiple modes of transport (the `Vehicle` parameter):```psql-- SetupCREATE TEMP TABLE query_output ( from_v int, node_geom geometry(Point,27700), agg_cost float, transport_mode varchar(10) )WITH ( OIDS = FALSE)TABLESPACE pg_default; CREATE INDEX node_idx ON query_output USING gist (node_geom);  DO $$

We're in the middle of setting up fault tolerance in FME Server with distributed engine hosts, per the optional configuration in the following documentation: https://knowledge.safe.com/articles/74845/introducing-the-new-20181-fault-tolerant-architect.html I found the following un-answered question posted by @swedper, and I have similar concerns about how distributed engine hosts work: https://knowledge.safe.com/questions/107724/engines-disappear-when-active-core-is-down-in-a-fa.htmlWe are planning to have two completely independent sets of core and engine hosts, each in its own data center - one primary and one secondary. We have a load balancer that will send all traffic to the primary core host, unless the primary goes down, in which case the load balancer will send traffic to the secondary core host. Both core hosts will be configured to point to the load balancer URL, so given that I have some questions about how FME Server works with this setup:Where is the queue itself stored

DGNStyler line width has on effect on lines when viewing in Bentley softwrae. I'm translating from a GeoDatabase to Bentley DGN format. I have a cell library for symbolizing cells but lines should just have a color and a width. It doesn't matter what width I select, it comes in a a very thin line with no fill.

Hi,I can't find an EPSG code (4083) in the "source coordinate system" list, in the Reprojector Transformer. Is there any way to load it? My FME version is 2018.1 Thanks!  

My issue is that I want to bend all lines around a polygon if the line is intersecting it. I understand that there is a huge amount of kombinations of how Buildings and lines can be scattered so my question is reduced to a more generelized question. "How to bend a line around a area object" In my workspace I am sharing fictive objekts and explanation what seletions to be bend. I have also, in red, marked out a costum tranformer that should be replaced with Another method. So dont bother dig Deep into that one. I am also sharing a fictive example of a result to visualize approximately what I want to accomplish.    

Hello everyone.I have a question for my DTM imageries. Resolution of imageries are 0.15m for red bordered area and 0,70 m. for green bordered area. I want to create a merged (mosaicked) and interpolated raster with a resolution of 0,50 m.. By the way; intersection of the two areas must come from the high resoluiton. How i must set the overlapping value and in what order should it be the transformers?I can guess the transformers that i can use (like rasterressampler, rastercellcoercer, rasermosaicker, tester(to retrieving the cells from high resolution for intersection area), 3DForcer, SurfaceModeler, etc.)Thanks. @daleatsafe @daveatsafe @jovitaatsafe @redgeographics @deanatsafe @rylanatsafe @hollyatsafe @lenaatsafe @annabelleatsafe @steveatsafe

Hello guys, Is there a way to find a word I character chaîne with the tester like in arcgis when I create an sql selection. For exemple with the % at the end or beginning or word?

Just updated windows 10 and can no longer boot up FME 2019.2.0.  Any ideas how to fix?

I'm looking for a method to "explode" single features into multiple features based on the numeric value in a given attribute field. Here is an example of what I'm working with and where I'm trying to get to, keeping in mind that there is point data attached to each record here...AnimalNumber_SeenOwl1Deer2Raccoon3 I'm looking to "explode" the features so that there is one point feature for each individual animal...AnimalNumber_SeenOwl1Deer1Deer1Raccoon1Raccoon1Raccoon1 It's worth noting that there are many features on the map for any given animal type, but the observations have been aggregated by the number of animals seen in the group at the time. An animal sighting with a "Number_Seen" = 1 does not need to be "exploded". Does anyone know a good FME workflow to do such a thing? I essentially need to de-aggregate points and replicate the spatial/attribute data so that there is a feature for each individual animal observed. Than

Hello Learned Friends,I have a Point layer where I need to convert each Point feature into a Polyline feature which traces along a set length (say 25 metres) of the nearest neighbouring polyline feature from a separate layer.In the crude example below, the BEFORE scenario details an example of my starting position, whereby I have 3x Points (in red), plus 3x Polyline reference features (in grey).The AFTER scenario details what I am attempting to achieve, and ideally the grey Polyline features (A,B, and C) will become split features along the length where the new red polyline features have been inserted.Does anyone have any ideas of how i can achieve this?Many thanks,RB

Hi,We have a problem with the DateTimeStamper in a workspace. The customer works in FME 2019.2.2 build 19817. As you can see from this screenshot it only stamps the first row with the date: I've tried to rebuild the same workspace from scratch, but I cant reproduce the error. The customer still gets the error when he is trying. These are the Parameters for the DateTimeStamper:Does anyone know where this error can come from? I've added the workspace as well as the data as attachements. Kind regards,Birk

I'm trying to reproject rasters from WGS84.PlateCarree to LambertAzimuthalEqualAreaSouthPole using a Reprojector Transformer,they have varying extent/ Resolution and Spacing. It often fails, my suspicion is that it has a lot to do with the extents of the input raster, particular when those extents are approaching linear unit values that represent the dateline and 90 / -90 latitude receptively . Sometimes the transformer runs successfully but just produces a very narrow vertical strip other times it fails and leaves translation log outputs like this(You can see the extents of the input raster here i was using). Are there any set rules that i should be following to guarantee success?I can give more details and examples if necessary.  Many thanksDavid

Hello,I have a 10 digit phone number in an attribute (e.g. 0123456789).However, I want to output it formatted to a string like this: 012-345-6789.How would I go about doing this?Any help would be much appreciated.Thanks

Hello,I'm currently working on a road network of ~3000 miles and some roads can go for 100 miles+ I'm looking to assign a value if the roadname is the same and the accumulative distance is 15 miles at most. So 1 road for example can be shown by 6 segments 0-33-1010-1414-2020-2828-35In the scenario above I would like 0-14 in 1 group as it is below 15 miles, then 14-28 in the second group and 28-35 in the next group. Currently a part of the workbench that works on assigning this is:However the issue I'm coming across is after 15 since the accumulative number is beyond 15 but the sum of 2 segments may still be below 15 miles. I'm not sure how to reset it as a reset would assign the whole road the same value. I'm a little stuck here and could really use some help

Hi list.I have built a number of custom transformers, using FMX and Python, and storing them in the shared folders structure. This works (apart from some kinks) well in Desktop.Now I've built a workspace with such a transformers, published the workspace to an FME Server, and tried to run the workspace as a job.And it fails with: Python Exception <ModuleNotFoundError>: No module named 'Xxxxx' How do I tell FME Server to look for the custom transformers in my shared folders. They're located on a network drive, so it has access.Cheers

Hi, following situation: we have a SDE-FeatureClass with parcel(plot)-data. Every week we got new data in a FGDB with the same datamodel from another source. Now we want to process of compare the two Featureclass, if there are now spatial difference and then update the sde Featureclass with the new Information of the FGDB Featureclass. If we make a spatial selection via ArcMap we got 50 difference between the data. We try the same in FME via SpatialFilter and other transformerprocess, but we got always 0 difference. Is there a better workaround?

I have a SDE table in Postgres that was created from data in a Hosted feature layer and MS Access table. Since it was created new records have been added to the the MS Access table. I am looking for the best way to update the SDE table with only the new records from the MS Access table.

Hi,i have a workspace on fme server and i want to start it from a python script. This scripts is not located on the fme server. Can this be done? greetings, Hans

Hello, I have a question about a XML. My XML has this result: <gml:Point gml:id="id-5d1fd60a-2737-40c8-bc59-06e25609b350-0" srsName="EPSG:28992" srsDimension="3"><gml:pos>But i need <gml:Point gml:id="id-ebfadba2-47a2-4027-b901-86ccacbb1004-0" srsName="EPSG:28992"><gml:pos srsDimension="3">How can i fix this? My workbench use the _geometry function to give this result, is it possible to change the position from de gml: pos?

I am working with crime data and need to change some fields to full names, M/F to Male/Female. Is the stringreplacer a good candidate for this? I have been using the FeatureMerger and definition tables in .csv format. Just seeing if there is a better way to do this. Thanks!!

Hello,I'm reading a shapefile created by ArcGis and I noticed something strange (or not?).In ArcGis, if I create a new attribute (for example text attribute) but don't enter any value, when I read it with FME, such field is interpreted as empty field in visual preview table of the reader (there is nothing in that field). But if I enter some value in ArcGis, store it, than delete this value and store it again, than when I read it with FME it is interpreted as <missing>. Why? Why not empty again? Is this correct interpretation by the FME?From help:Empty – The attribute exists and has an empty string as its value.Null – The attribute exists and has a value of null.Missing (Selected Attributes Only) – The attribute does not exist.

Hello,I'm intersecting two layers of data (polygon.shp and plygon2.shp). One of them (polygon2.shp) has two completely overlapping polygons. I'm getting this:How to get this:Here is the sample data: .

Hello, I need to filter the Attribute values into separate groups. See the image.The values are always variable/different so I cannot use an AttributeFilter.Any Idea?Thanks

I'm trying to change the name of a folder when running a workspace. I would like it to update the folder name from [job name_YYYYMMDD] to put in the date of when the workspace is run. I tried using system caller however it doesn't seem to work: below is a screenshot of my command line:I know @DateTimeNow() doesn't have the date format I'm looking for, does anybody know how I can update that as well?

Hi,I'm looking for a unit testing framework for FME workbenches. See link below for a lot of example frameworks for various programming languages.. Is FME running behind on this topic ?? https://en.wikipedia.org/wiki/List_of_unit_testing_frameworks#References This page is a list of tables of code-driven unit testing frameworks for various programming languages.