FME Form

This has happened so many times that I have lost count: I try to import values from the source in AttributeFilter. After the process is complete, it gives me nothing!The latest time is trying to get them from an IFC file. I select fme_feature_type in the dropdown, hit the import button, the feature types show upI select all of themI select fme_feature_type and check the use format attributesIt thinks a second, and....NOTHINGThis has happened with dwgs as well. fme_feature_type is exposed in the reader. I tried selecting other value types in the wizard to no avail.What is going on? I have attached screenshots to illustrate.Thanks

I have a large POSTGIS database table with 10+ million features and I'm trying to "clip" it to another geometry that is already read into the workbench. Is there any examples of this in a tutorial or something?

I'm trying to convert a 0/1 value in CSV file to a kleenean value in smallworld. With the AttributeBooleanConverter I get this error:Smallworld Translator Error: Failed to convert string No for field Business to a truth value With an AttributeMapper I get this:Smallworld Translator Error: Failed to convert string 1 for field Business to a truth value What is weird with the AttributeMapper , I have the new attribute mapped to the field for Smallworld and the "Business" field should not even be considered. What am I doing wrong? 

I have read http://fmepedia.safe.com/articles/FAQ/Autodesk-AutoCAD-Civil-3D and wonder how you are handling surfaces. Inputdata is a Surface/TIN and I also want to write to a Surface/TIN in DWG-format.  Can you read the Surface in Civil3D as as "triangles" , then aggregate these within FME and write them out as Surface?

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 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?