FME Form

Hi all,I have to create a workflow where we are retrieving public data, either through download or URL and running it through FME for data processing and publishing to our SDE.  The idea is then that this process should be fully automated by adding the FME script as a spatial ETL tool in ArcGIS Pro, and then publishing it as a web tool to an ArcGIS server with DI extension for server.  This way we can just schedule that tool to run on a monthly basis, where new data is downloaded and being published to our SDE without us having to do anything :-) My problem is this: How do I handle the data and data connections in my script? Can I set up some parameters ensuring that even though my script is now running as a web tool on a different server, it still has a data connection to my SDE? And can I ensure that access to my "downloaded" or URL data is still intact through the web tool on the server, for instance using some kind of scratch folder?  Should I set a FME_TEMP Environment v

Anyone run into this error before trying to write data to ArcGIS Online with the writer (applyEdits)? In this instance, this came from ArcGIS Data Interop running on ArcGIS Server.{"code":1000,"description":"The request limit has been reached. Contact esri support for assistance."}(Also cross posted on the esri community)

Hello,This is my first use of the Writer with Oracle, I only used SQLExecutor before.  The problem is, all features are stored correctly, but I cannot get the Writer to store the geometry - it just remains empty.  First I put the name of the table and have specified the spatial column like this:Secondly I basically enumerate all columns:It works, but no geometries are being stored in the "AREA" column. All features come with geometry, I see them cached in the Inspector.  Thanks for any suggestions!   

Hi! I'm validating the quality of the CityGML and CityJSON building datasets. I'm wondering what is the real difference between all self-intersection rules implemented in the FME's GeometryValidator. So shortly: Is the rule Self-Intersection in 2D same as the Self-Intersection under the OGC Valid and OGC Simple?  I think I understand the difference between Ring Self-Intersection, Surface Self-Intersect and Shells Intersect at least. Still, I would be grateful for proper definitions of all these errors. The document of GeometryValidator is a little bit unclear in the case of these "sub-errors". Thank you a lot!

Hello, i have a point cloud data file in e57 format and i plan to reduce it by transform PointCloudSimplifier. There is my workspace.And it appears that warning "The workspace may run slower because features are being recorded on all output ports". The data is very large, more than 100GB, so i wish it cloud be processed faster.​I'm not exactly sure what "recorded on all output ports" means, what should i do? Do i need to add a transform like AttributeManager between the Reader and PointCloudSimplifier or something else?Thank you in advance!

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