Transformers

When using SQL Executor or SQL Creator with a PostGIS reader on our Postgres datawarehouse I run into problems with spatial queries.Example given this query:select     table1.name  , table2.whatever  , table1.geometryfrom table1join table2 on ST_Intersects(table1.geometry, table2.geometry)this works only if the two tables are of a different geometry type (e.g. Polygons and Points). If they are both Polygons, FME does not recognise the geometry anymore. The geometry field from the output features does have content but when connected to a GeometryFilter the type is 'Null'. There is a workaround, when using a 'with' statement, like so:with polygons as   ( select * from table1 )select     polygons.name  , table2.whatever  , polygons.geometryfrom polygonsjoin table2 on ST_Intersects (polygons.geometry, table2.geometry Then, FME does recognise the geometry and displays them correctly (geometry coming from 'polygons' and thus, from 'table1') Is there anything I can check on our Postgres envir

Hello,I would like to +1 a value into a field using the Counter Transformer and although the expression I have used works in the evaluator I keep getting a rejected output with INVALID_PARAMETER_COUNT_START.The output from the SQL Creator Transformer seems to output the correct number.Can you tell me what I'm missing? Thank you.

We noticed that a password was visible in the log file of FME Desktop. Is this normal? We still looking if this is also the case for FME Server. We think this is a security issue. See attachment for an example. We changed the password in PASWOORD.  http://www.safe.com/support

I am currently converting DGN to SV G so that they can be used in ESRI ArcGISPro based Runtime Content. The DGN s that I am converting can be successfully viewed in a web browser, however once they are imported to ArcGISPro the text is not recognized. I was able to determine that ArcPro must have a ttf reference. I am not concerned with retaining the the current shx "font". I just want to overwrite that attribute with a font that is stock to the the Windows Library. I am an FME beginner and cant even expose the shx reference in the writer. Any assistance would be great.

I'm using the JSONFragmenter to choose a segment of a JSON file and am trying to expose the values from this segment as attributes. However, the JSONFragmenter just returns the values as separate objects, and the attributes are empty. I've tried without the "[*]" at the end of the JSON query, yielding just one object but still empty attributes. I've also tried using the JSONflattener on this segment and on the full JSON string, but it does not seem to do anything. It just returns the same attributes as on the input straight through. The parameters of the JSONFragmenter: The segment og JSON looks like this:{ "id": "8a463f67-99c2-4f6b-8703-d154de3dd7ef", "vejnavn": "Tietgensvej", "adresseringsvejnavn": "Tietgensvej", "husnr": 4, "supplerendebynavn": null, "postnr": 8600, "postnrnavn": "Silkeborg", "status": 1, "virkningstart": "2015-

I have a shapefile with roof shapes. Now I will convert them into faces. This works well for almost all. But some areas are not planar. So theses non planar areas I fixed in a step before with GeometryValidator and then I will use FaceReplacer. But now the same issue was found "Non-Planar Surfaces". I thought with Geometry Validator these areas are fixed? Can someone help me?

I am using the OffsetCurveGenerator for two line segments . One is red, the other turquoise on the picture. I am using an interpolation angle of 22.5, corner style : round. You can see the result for two different offsets for the left side on the picture, the one in green is 2, the blue one 1. Why is an offset of 1 generating two line segments which are continuous and not intersecting while an offset of 2 creates intersecting segments ? How can I create the result for an offset of 2 which looks like the one of offset 1? If it is not possible, how can I modify the current result of offset 2 to look like the one of 1 ?

I have been having trouble with a particular IFC. All I am trying to do is read it in but it keeps causing FME to crash with no expanation. At first I was trying to open it using FME Data Inspector, however the whole application would close - always at "caching 829 features". I have since tried to open each Object type separatley in FME Desktop and I have found that it is an element in the IfcWallStandardCase that is causing this problem but the only error I am getting is "Error running translation" so it is difficult to know where to go from here. Is there any reason why this might be happening?

Hi,I have a couple of questions regarding migration of GlobalID’s from a source table (reader is a SQL creator) to be written into an existing ESRI Geodatabase (ArcSDE Geodb) table (destination). 1st question:The destination table has the GlobalID field but all the values are zeros (see image below), does this seem correct? 2nd question:Do I need to expose the GlobalID attribute in the workflow and then attempt to copy those GlobalID’s from the source table to the destination table (using a writer) in the workflow or should the “Preserve Global: Yes” parameters ensure that the incoming GlobalID’s will be preserved from the source table and embedded into the destination table? I can run the FME script to run successfully however I cannot get the existing GlobalID’s from the source table to be written into the destination table, FYI each feature is linked by another attribute. I have tried copying using transformer and writers and I have also tried using the “Preserve GlobalID: Yes” by i

I am pulling the transformation metadata using the API call GET /transformations/jobs/completedand would like to trace each transformation back to a specific run/event of an automation. In other words, I just don't want to know which automation ran the transformation, but I also want to group those transformations by a specific date and time that the automation was triggered. In looking through the metadata provided, I am not seeing an obvious way to do that. Thanks

Can't wrap my head around the following reformatting problem. My data looks like this:Pointid substance1 substance2 substance3...1 value 2 3I have a lot of columns in the original data, almost 200 different substances. I would like to achieve the following structure (below) where Substances attribute contains all values of 200 substance columns and is exploded for each Pointid. So basically every Pointid is replicated for each substance and values column have the value of each substance. I've tried multiple combinations of transformers but without result. Pointid Substances values1 Substance1 value1 Substance2 ...1 Substance32 Substance12 Substance2...

Hello everyone, So I have a dataset and need to validate "Hour" format that is in OSM Opening Hours specification.https://wiki.openstreetmap.org/wiki/Key:opening_hours/specification I found a web site that have a lot if implemetation formats.https://wiki.openstreetmap.org/wiki/Key:opening_hours#Implementation However, I am not good at programming that I am not sure how to put it in FME for my checking. It would be awesome if someone could give me a hand. Thank you so much! Zach

in the original some initial alread had periods, but i already removed them with a stringreplacer. Any leads on how to tackle this are welcome. Luuk 

I have this xml fragment in an attribute called distr_formats and need to insert it in a specified location of an xml document (stored in another attribute):<gmd:distributionFormat>    <gmd:MD_Format>        <gmd:name>            <gco:CharacterString>DWG</gco:CharacterString>        </gmd:name>        <gmd:version>            <gco:CharacterString>r2013</gco:CharacterString>        </gmd:version>        <gmd:fileDecompressionTechnique>            <gco:CharacterString>ZIP</gco:CharacterString>        </gmd:fileDecompressionTechnique>    </gmd:MD_Format></gmd:distributionFormat><gmd:distributionFormat>    <gmd:MD_Format>        <gmd:name>            <gco:CharacterString>SHP</gco:CharacterString>        </gmd:name>        <gmd:version>            <gco:CharacterString>-</gco:CharacterString>        </gmd:version>        <gmd:fileDecom

How to submit a surface to Orientor? Since every triangle must be rotated.

Hope someone can help, I'm missing a lot of buttons in my workbench suddenly. I was working on a workbench yesterday, everything was fine. Today I open the same workbench, and the hover-over menu is missing from all the readers/writers and transformers. I need to click on a transformer and it will appear, but the RUN button is missing!  I can only run the entire workspace from the main menu, I can't select and run, and I can't run to/from. So I just ran the entire workspace from the top ribbon menu, and it worked, but now I am also missing the magnifying glass buttons (inspect feature cache)!!!  Help. How do I get my hover over menu back (including the run buttons) and how do I get the inspect feature cache boxes back. Thanks!

I want to check the header for information in a manual validation step for a xml/gml file. But it does not seem possible to extract the header information using the xmlFlattener for examle, just the dataset. Is it possible to extract certain keys from the header? I want to check for the encoding tag for validation.

Hi, I am running a workbench using the workspace runner. This workbench runs 12 times with a different area running through it each time. It takes roughly 3 days to complete all stages. I want to create a HTML report so I can get a simple percentage complete of this process. I have created a process whereby the sum of features passed through is counted in the statisticscalculator and this is then used to derive what percentage complete I am. However, due to the fact that I am using the runner and each area runs through on it's own. The statisticscalculator calculates that only 1 has through each time. Therefore I always get an update saying I am only 8% (1/12) complete, even though I may be farther.Would there be another way of achieving this? Hope this makes sense and thanks for any help. B

I have an XML with a tree structure, which we can aggregate to 1 feature with traits. It has several levels in the tree (6 at the moment) At each node, I would like to have the ID's of all underlying children of that node (so not only the direct children, but alto their children, etc etc). I tried TraitsToAttibute transformer, which does this but only on the root level. The Deaggegator can list the children ID's belonging to parent, but only for the direct children.   

Hi!I would like to know how to create from scratch an autocad file with blocks, I have a list of points xyz and a template file.  What are the information needed to be able to create a block ? I've tried something but it's not working at all ! Please help.Thank you in advance. 

I am trying to convert old DWG files into PDF. When I convert them to PDF, I find that several features are now filled in with color (mostly shades of gray and black), and this ends up obscuring most of the image. In the parameters I tried setting the default fill opacity to 0, but it did not change anything. How can I get rid of the fill color? These colors do not show up when I view it in Data Inspector. It only displays that way on the PDF version. Basically, I want the PDF to resemble exactly what the file looks like in Data Inspector.

Hello,  I'm an FME novice. This is my first workspace of any complexity at all, and it is based off of https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri.  I've inserted a couple testers, a reprojector, and an Attribute renamer to the wakthrough above. (The field name "CURRENT" causes and error in the SQL Insertion; likely because it is a SQL keyword). It MOSTLY works, and the process finishes successfully, however the Attribute rename doesn't work as expected. Instead of renaming "CURRENT" to "ECURRENT" as configured, it drops every field starting at "CURRENT" all the way up to the last field in the table.  This is obviously some sort of parameter/configuration issue that I'm overlooking. Can someone help me? I've attached the workspace. 

I have a custom transformer that was written with a lot of help from 1Spatial (thank you :)!!), The idea is that it goes through an Atom (georss) feed, and identifies links within feed that are zip files. However, due to the nature of some of the feeds I am working with, sometimes the download is on a second page (see, for example: http://www.catastro.minhap.es/INSPIRE/CadastralParcels/ES.SDGC.CP.atom.xml), and therefore I have a loop which goes through all the non-zip links that are in the initial feed, and checks if the subsequent feed contains zip files.When I run this using the URL https://www.ign.es/atom/dataset_feeds/lin_lim_mun.es.xml I find that it goes back into the initial Input loop and therefore identifies the same zip file twice.Can anyone shed some light on why this is occurring, and suggest how to stop this issue? I'm really struggling, and need to avoid this duplicated data!! I have attached a workbench which runs the custom transformer, along with the csv file whic

I have the following problem: I want to convert dwg-plans automatically to geopackage/dxf. Most of the plans are not in any geographic coordinate system. I'm trying to construct two separate workflows: First detect if the dwg has a coordinate system. If so, just use reprojector to confirm if it is in right coordinate system and use user controlled scaler (sometimes units are m, sometimes mm) then convert to geopackage (this workflow generally works)If the file doesn't have any geographic coordinate system, move it to a certain point and scale it (user parameter) preserving distances and angles (because the file used for precise work in QGIS later). The aim to move the drawing in certain location, is to more easily move it manually in QGIS without having to search it from 0,0 coordinates.I've tried LocalCoordinateSystemSetter among others and got some realistic coordinates when inspecting in FME, but when importing to QGIS, it seems to be in another dimension compared to all

Hi, I'm trying to upgrade a workbench from FME 2020_2_4_0 (build 20825) to FME 2021_2_4 however I have reprojectors that project data into lambert equal area polar projections. These projections do not appear to be available in FME2021 and the workbench fails as a result. Can these projections be added to 2021 or are there alternative polar equal area projections that are supported?