Transformers

Is there a possibility to schedule the workbench on our local system rather than putting it on the server due to data confidentiality issues?

Hello,I have some data which shows if an event occured per month. Events 202301 202302 202303 202304 202305 202306 a 1 1 0 0 1 1 b 1 1 1 1 0 0 c 0 0 0 1 1 1 d 1 0 1 0 1 0  I want to count the events which occurred 3 or more times consecutively. So I want to get thisEvents More than 3 consecutive events? count  b yes 4 c yes 3  Not sure how I should do this in FME. Can someone help me?Thank you!

Hi there, If I have been given a TIN and a point cloud, how can I find out which points are above the surface and which are below, without rasterizing the surface to retain maximum surface fidelity.Thanks,Marc

Hello,I am trying to transform a point cloud with ellipsoidal heights into orthomethic heights (DHHN2016) using the CsmapReprojector. The settings can be seen in the image. For the Geoid Height Grid I need a file in .gdc format. My target system is DHHN2016, for which I have the quasigeoid in various file formats (e.g. JPG, TIFF, GEM, TXT, GSF, GFF, GGF) but not in .gdc. Is there a website from which I can download the appropriate format or another way?Thank you very much.Translated with DeepL.com (free version)

Geometry type "CompoundCurve"Because of the given schemas the postgis writer has problems with the geometry "CompoundCurve". I want to convert this in the process into a normal line element, which can be read in the osm_line table with the geometry "linestring". Today my process in the Workbench crashes with an element with the geometry "CompoundCurve". Geometry type "Curvepolygon"The second problem is the geometry type "Curvepolygon". This is written correctly into the postgis table osm_polygon. But then I have to delete these objects manually in pg_admin, so that the generated data can be read by the application software. Is there a possibility in FME to convert the elements with the geometry type "Curvepolygon" into a normal polygon? With best thanks for your support! Erido

The PDF-reader seems to have disappeared from FME Form 2024 for Mac (silicon). It worked fine in the 2023 version. I took a look at the writer, and there is no dot under Read there either. Has this reader been removed for some reason? Or is this a bugg?  

Hi there,I have a small project where I've performed a join between two tables (Table1 and Table2) using the CityName field as a common identifier.However, I've noticed some minor inconsistencies in the city names between the two tables, resulting in 10 unjoined features.Is there a transformer or method available to manually specify that the X row from Table1 should be joined with the Y row from Table2?Regards   

Hi all,I’m using: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)I do want to know if there is the possibility to use the HttpCaller to launch chunk of requests. My DELETE request: https://xyz.api.here.com/hub/spaces/@Value(space)/features/@Value(xyz_id)each request sends to that Hub the action to delete each Feature by its ID (xyz_id).I need to delete around 4M records, and running the workbench feature by feature, takes days.Is that possible to get it faster? Thanks for you help,Juanma

I need to pick all segments of a line (they are separate features) that go between the end of the line (the last segment, in blue below) and a point that is along the line, but which I need to define with the rule of being the 3rd closest to the end of the line. I tried to illustrate in the figure below. I managed to find the end of the line (the last segment in blue). Between the blue segment and the points A (red) and B (dark blue) there are 6 segments (separation between them are marked in black). How can I find point A and B and have the IDs of the 6 segments between the last one and the point B? Hope this is clear enough and thanks in advance. 

I got this question from a colleague. I know after reading in a dgn file you can aggregate features together based on igds_model_name, but I was wondering if there is a way to make a distinction/aggregation based on the type of model (drawing, desgin, Sheet). Within Microstation you have to attribute msdModelType which can contain the following values that correspond to Sheet, Design, Drawing:1) msdModelTypeSheet for Sheets2) msdModelTypeDefault3) msdModelTypeModel I was wondering whether there is an equivalent for that attribute within FME desktop or whether there is another way one can make distinction between those three type of models (Sheet, Drawing, Design).

I've encountered a problem since upgrading to FME Workbench 2024.0. Previously, I could select Feature Services using Esri ArcGIS Online (AGOL) or FeatureReader without any issues. However, now I'm getting an error resembling the following:"Could not find a Feature Service item matching the Feature Service directive 'Parks and Recreation - Tree Inventory/Tree Taxonomy List(<item ID>)'."Interestingly, removing the quotations and <item ID> in the Constraints parameter allows successful reading. Is this the expected behavior? Do I now need to manually adjust parameters for reading every feature service?Any feedback or advice would be greatly appreciated. Thank you in advance!

I have a simple Excel spreadsheet which keeps track of modification dates in the format (YYYYMMDDHHMMSS). I use the InlineQuerier to get the maximum date from the column called Last_Update. I have confirmed, by outputting this value to a text file, that it is pulling the correct date from the Excel column.  Now I wish to append this date as a new field on all records of another table coming from Oracle. Each record from Oracle should have the same new field called Last_Export and the same date coming from the Excel spreadsheet.  FeatureMerger does not work as I don't have a common attribute between the two tables.

I want to update a table from a HTTP request for x times depending on the last update and the current date. What would be the best practice? So I have to fill in the green part in this workflow.  

Hello,I am trying to transform a point cloud with ellipsoidal heights (WGS84) to DHHN2016 heights using EsriReprojector. However, only "None" can be selected for "Vertical Transformation". (see picture)Why is this the case and what can I do to make the transformation work?Thank you very much

I am trying to return values for multiple fields (codes), parsing data from one incoming field (NAICS_CODE), using a AttributeManager transformer and SubstringRegularExpression.The field containing the incoming data is called NAICS_CODE and can contain data for up to 30 separate codes.  For example, in one record the field NAICS_CODE has 10 separate codes.  Using an online regex editor, I have the following code, where the index for each parsed field would be 0-9.^\s*(?:\S+\s+){0}(\S+)   THROUGH   ^\s*(?:\S+\s+){9}(\S+)And when I test this code against the following data with the online REGEX editor:236210-DBE/MBE/SBE  236220-DBE/MBE/SBE  238210-DBE/MBE/SBE  238990-DBE/MBE/SBE  335311-DBE/MBE/SBE  335312-DBE/MBE/SBE  335313-DBE/MBE/SBE  335314-DBE/MBE/SBE  335999-DBE/MBE/SBE  423610-DBE/MBE/SBEThe results seem to be what I am looking for, returning the correct code from the field for each indexed value.^\s*(?:\S+\s+){0}(\S+) returns 236210-DBE/MBE/SBETHROUGH^\s*(?:\S+\s+){9}(\S+) retur

Using two files: a PDF with no geodata, and a georeferenced polygon. They cover the exact same area (bounding box of PDF = polygon). The polygon and the PDF were originally created in the same coordinate system. There should be no need for "warping". Its just only the georeferenced coordinates in the PDF that are missing.  Q: How do I georeference the PDF using the polygon? 

Hi there,I don’t see the forest for the trees 🤔Input dataXML excerpt (source https://ifc43-docs.standards.buildingsmart.org/IFC/RELEASE/IFC4x3/HTML/annex-a-xsd.html):<?xml version='1.0' encoding='ASCII'?><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ifc="https://standards.buildingsmart.org/IFC/RELEASE/IFC4/3/DEV/9d19c824" targetNamespace="https://standards.buildingsmart.org/IFC/RELEASE/IFC4/3/DEV/9d19c824" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="uos" type="ifc:uos" abstract="true"/> <xs:simpleType name="Seq-anyURI"> <xs:list itemType="xs:anyURI"/> </xs:simpleType> <xs:complexType name="uos" abstract="true"> <xs:sequence> <xs:element name="header" minOccurs="0"> <xs:complexType> <xs:sequence> <xs:element name="name" type="xs:string" minOccurs="0"/> <xs:element name="time_stamp" type="xs:dat

Although the Python can connect with the information provide, the FME tries to connect but is not able to. This is simply downloading a text file from the site once the connection is made and storing the text file locally.The goal is to modify the process that currently uses three software packages into one FME solution. Details on the HTTPCaller in the attachment

I have a database table in which a number of the records are duplicated. I'd like to remove the duplicates but like to keep 1 record (so similar to the duplicateFilter unique port).I have no unique identifier in the table so if I match a record (based on a combination of attributes) I'll remove all of them from the table, I need to add 1 of them again afterwards.  Currently I use the following approach:duplicateFilter to find the duplicatesremove the records from the table using fme_db_operation = DELETE (this re re-insert the unduplicated record Any suggestions to improve this methodology?

Hello! I would like to convert a IFC building into a CityGML building, I created all the components of buildings(wall, floor, roof, etc.). But I don’t know how to merge all these components into one CityGML building. I would like to create a building with appropriate CityGML hierarchy. Could you help me?  

Hi,I have a multipatch containing buildings in a file based geodatabase (.gdb). I want to be able to replace the geometries and attributes of certain buildings by updating them with buildings from another multipatch based on a unique ID. This is successful but when I load the multipatch into ArcGIS Pro the updated buildings appear grey instead of white. I don't think it is a problem with the appearence stored within the multipatch (I have tried GeometryColorSetter) but rather that ArcGIS Pro doesn't recognize the difference between walls and roofs in the objects written by FME.  When lighting is not enabled all objects appear white  When I enable lighting the object in the middle (written by FME) has grey roof instead of grey walls (shadow) and a white roof as the other buildings have.   If I edit a multipatch created by FME in ArcGIS Pro the roof becomes white again. Has anyone encountered this or have an idea for a soultion?

I want to transform this JSON for import in a database what would be the best practice when using the standard transformers?{"keys":["day","domain","subject_identifier","kpi_type_code","kpi_count","kpi_value_min","kpi_value_max","kpi_value_avg","kpi_value_last","kpi_alert_condition_lower_limit_last","kpi_alert_condition_upper_limit_last","kpi_value_extremum_ok","kpi_value_avg_ok"],"values":[["20240407","production","7ab20028","RA_MAP_FREQUENCY",1256,"24,0000","24,0000","24,0000","24,0000","0,9000","50,0000",1,1],["20240407","production","7ab20028","RA_EXCEPTIONAL_CONDITION_PERCENTAGE",1440,"5,9418","5,9418","5,9418","5,9418",null,"25,0000",1,1],]}

I have the FME 2021 Workbench version. I have an API protected by an SSL certificate (.crt, .csr, .key, and .p12). How do I read my .p12 certificate and connect it to my API https://**** in FME? Is it possible in HTTPCaller?In my directory C:\Program Files\OpenSSL-Win64\bin\partner_key, I have my four files, the .crt, the .csr, the .key, and the .p12 (with a password for the .p12 file). On the other hand, I have my API https://api-pp-iop.******.com/******/******. I want to extract all the data from this API. It won't work if I can't associate the .p12 certificate with it.

Hi everyone, I have finished a FME Workbench and I wish to share it throughout my organization via an ArcGIS Pro Tool (Spatial ETL Tool). To create an ESRI Spatial ETL Tool, I followed this tutorial (Create an Esri spatial ETL tool—ArcGIS Pro | Documentation) and this specific section: “Reference an existing FMW file to an ETL toolbox”.Through the user tool interface (as in the Geoprocessing pane), I would like for a user to be able to:-         Define the output file name and the path where the file location.==> Those two parameters work.-         Select the unique input file in a Geotiff format (extension *.tiff)==> Doesn’t workTo do that in the FME Workbench (ArcGIS Data Interop. Workbench) --> Navigator (left panel) --> User parameters --> Right click --> Manage User parameter --> Insert new user parameter of type “File/URL” (trough the green cross) --> Click on the parameter to opens his settings à In File/URL Configuration :Items to Select : FilesFile conf

I have 100 items of data, which are grouped together in various sub groups using a field 'groupNo',I want to process each set of groupNos individually, I need to select a group, and do the following processes for each individual group: Take one item with status 'original' which has data and duplicate that data to the 'new' items in that group. How would I do this using the groupNo identifier? An example input output data set: Input:OID, Status, Data, Group1, Original, XYZ, 12, New, <null>, 13, Original, ABC, 24, New, <null>, 25, New, <null>, 2 Output:OID, Status, Data, Group1, Original, XYZ, 12, New, XYZ, 13, Original, ABC, 24, New, ABC, 25, New, ABC, 2