FME Form

 Dear FME community,I hoop you will help met with the problem I am try to solve . I am reading WFS data which has more than 200,000 records. I just want to replace one of the fields from my own Excel file. I used to Attributevaluemapper to replace the value of fieldname owner with the value name owner from my exce list. I am not succeeding Do you have any idee how to tackle this?Any help is apricated and thanx in advance!! 

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

My customer want me to automate a report how many times diffrent map services has been reqested.It’s on a unfederated arcgis server with arcgis server manger.In arcgisserver manager i can export this information one by one to a csv file and get how many times a service has been requested in a set time period.I need to find a way to automate this process. Is it possible to retrieve this statistics using FME and then print it to an Excel file? Then on FME-server I need to get a report every month how many times diffrenbt map services has been used. 

Hi All I have a point distance data set in a parquet file with x y coordinates and a geom column with geometry encoded in hex binary and i have line data for coastline I want to calculate distance between these points and the coast polyline .In my workflow am using geometryreplacer to get the geometry then projecting both layers using csmapProjector then using neighborfinder but am getting unexpected results ...is there a better approach 

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. 

Hi Community, I am developing a workbench which is reading and writing data to ArcSDE Geodatabase. As per the information which is available in the Knowledge base I need to have ArcGIS Enterprise(Server) Software to be installed and Licensed in the same machine of FME Flow installation. Here my question is:  If I have the ArcGIS Server License which is installed in some other machine, can I assign the License with the FME Flow machine?

Hi,I have a polygon file. I want to make MapboxStyler for it. But I don’t see it styled.I use parameters as the below:Could you tell me why? Thank you

Hi I have an address that I would like to access with login (username/password) using HTTP Caller but I am not able to pass the username/pwd forward using POST.Webaddress is php, any ideas?  

Hi, I have acheived an attribute update in an existing table in QGIS.The transfert to PostGis works well when I use "Insert" and "Drop and Create" handling.However, I can not figure out the operation with "Update" and "Use existing" in order to properly transfert the updated value of the attribute code_dep. Any help is welcome.

My goal is to split the green polygon at the edge of the pink polygon. However, the pink one is not aligned properly. The black line indicates the cutting line I want to achieve. I am thinking of creating a buffer around the pink dataset, however only at the top and bottom border. At the left side, where the cutting line is present, a buffer is not allowed. When such a buffer is created I could use an Intersector probably to split the green polygon. Any support is appreciated! 

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

I’ve tried searching for answers to this but I’m sure I must be using the wrong search terms as I get close matches but nothing that has pointed me in quite the right direction yet. I’m hopefully that someone can help me understand how to expand the following JSON fragment into a set of features, where each feature contains the same initial set of fields, but only contains one of the final array entries.Here’s an edited example of the JSON I’m dealing with and how I’d like the out to look. {"UPRN":"12345678","CaseNo":"15/01234/ABCDE","Address":"16 Some Rd Surrey SM1 1AA","Name":"Miss T Mountain","DocumentID":["7654321","7654322","7654323"]}I’m trying to extract this into 3 features, each of which includes the uprn, CaseNo, address, name and a DocumentID. I’ve been able to extract the whole array of documentIDs but haven’t figured out how to extract each one in turn and pair it up with the remaining information.The JSON output I’m dealing with contains a number of such records, in each

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 upgraded FME Workbench to FME:FORM  FME(R) 2023.0.1.0 (20230630 - Build 23332 - WIN64) In the previous version, when I wanted to review the written data in a file I simply clicked on the icon to View Written Data and the data would load in the preview window,However, since I upgraded to FME:FORM, every time I want to review the written data in a table, I have fo go through the following steps, even when the qualified table name is already present.  I have done this, saved the workbench and come back and still had to follow the below steps.  In fact, if I go to another area in the workbench and try to review written data I have to repeat these steps.  Is this a bug or a feature.Click on the View Written Data icon Select Dataset to ViewClick on Parameters buttonUnder Constraints specifiy the tabke from a dropdown (even if the qualified table is already listed) 

Hi,I’ve been working on a pretty large export workbench.The subject is related to real estate. We’ve got a relational database and we drill into about 20 external layers to get some info and to filter our own data.The workbench has grown a lot over time and now it’s really hard to maintain or yet expand. I’m afraid it might break anywhere.Are there best practices on how to go about many processing jobs ?Is it sometimes best to split a workbench into several separate workbenches ? If yes, how to structure the processing parts ?Where to start the cleaning up chore ?

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?