FME Form

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 am using FME 2020 (Build 20218) and I find that if I expose the fme_basename and fme_dataset in the Reader Feature Type they are read normally and have no issue, however I am curious why if I use an AttributeExposer to expose those attributes in the workspace, the values for these attributes are exposed with null values. What is causing the AttributeExposer to remove the values when it exposes these format attributes? 

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 still can't get my head around how to produce an FME AR model that appears in the correct geographical location when I open it in the iOS app.Anyone that can point me to a good tutorial, preferably with an example workspace?

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 ?

Hi all,I have a workspace that has an Emailer transformer where the Email's body is the customed HTML_content. This works fine with FME desktop 2020.2 (build 20787-win64) but failed with FME Server 2020.1.1. (build 20608-win64).The error message was: Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'I wonder if this is because of:incompatibility between 2 versions (2020.2 vs 2020.1.1)?or is it because the FME server doesn't support the Emailer transformer?At the moment, upgrading FME Server isn't an option for me.I have tried the Email function in the Automations of FME Server but it doesn't have an option for me to include HTML content in the Email's body but rather an HTML attachment - this means every time I will have to click the attachment and it will be opened in a browser.Any suggestion? Many thanks! 

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 using FME ArcSDE Writer to create features for a feature class in a table of an enterprise geodatabase with editor tracking enabled. If I run the writer FME logs the message that the fields The field 'created_user' in table 'ABC' will not be updated since it is not editableThe field 'created_date' in table 'ABC' will not be updated since it is not editableThe field 'last_edited_user' in table 'ABC' will not be updated since it is not editableThe field 'last_edited_date' in table 'ABC' will not be updated since it is not editableWhen the translation has finished, the created_user field is set to the schema name of the postgresql db. Is it possible to specify the created_user manually in the writer?

Canadian Cities Open Address Data Attaching a sample FME workspace that shows how to import open address data from various Canadian municipal websites, and other authoritative sources. If there are additional Canadian open address data sources that you can find, please contribute to enhancing this.

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

Hello, i'm new to FEM. ​ I have a problem about changing the storage locationWhen the software FME Date Inspector reads the data, the data appear to be temporarily stored in this file. Is it possible to change this path?I have not much space on my c drive, and i got a very huge data, for the remaining space of my c drive, it is not enough to support the software to read this data

I would like to create a TIN from DEM (.TIFF or .DEM). I would be grateful if you could tell me which Transformer and Writter can be used.  

Hello, I would like to get the value that comes from a Counter transformer through the Initiator input in a SQL Executor transformer, to make a query that uses this number Here is my request: FME_SQL_DELIMITER ;alter sequence cajxg_CE_sequence increment by '@Value(COUNTER)'; I tried or without the quotes, I also tried using TO_NUMBER and if I replace my attribute by a number, it works But when I perform the query I get the error ORA-01722 (Invalid Number) When I try to do a select with this attribute, it works 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...

If I leave them blank I get an empty string inserted into my database (postgis) - I really want Nulls

fme_polygon covert with FaceReplacer, then with GeometryCoercer convert to fme_mesch. Why MeshSimplifier feature put to Rejected port with code invalid_mesh?

To whom may concern, We are currently trying to upload a 6GB obj mesh model to cesium ion, but errors showed up when retrieving the model. The mesh model was created from Reality Capture. As suggested by cesium team , we are looking for a way to tile the mesh or chop it up into small pieces. FME seems to be capable of doing this, but I'm still trying to figure out how to do that. An ideal result is attached below. Any suggestions would be appreciated. 

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

Hi, I want to overlap to my building and roof. I added one photo. 1(building) will go to 2 (roof). I know extruder transform. But also which transform can I added. Because it s not enough. This are .shp format.

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