FME Form

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, I’m working on a script which copies data from an Esri arcsde geodatabase to a postgis database. I need to know if the table in the arcsde geodatabase is versioned before I run the rest of the script, and I have a pythoncaller which runs something like this (simplified here):layername = "schema.layerName"connectionFile = "path_to_connection_file"arcpy.env.workspace = connectionFiledesc = arcpy.Describe(layername)isVer = desc.isversionedfeature.setAttribute("versioned",isVer) self.pyoutput(feature)Now, I don’t want to type in the path to the connection file manually, but rather obtain it by some function which can collect the data from the list of database connections I entered in the settings. Is this possible? I’ve looked into the FME Web Services API reference for such a function without any luck. Best regards,Jacques 👷🏼 

Hello,I have an editable view in PostGIS (PostgreSQL) and I'm trying to write in it with FME.For that, I've:Added my view from a PostGIS reader (to have its structure - and confirm it exists)Duplicated this view in a new PostGIS writer (to keep its structure)Set the table handling as `Use existing`Connected a worflow to end in my viewBut when I run the workspace, I'm facing this error:POSTGIS Writer: Table 'xxx.yyy' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format ParametersSo my question is: is it possible to write in an editable view?For the record, I can write in my view with another client (QGIS) with the same credentials.Thanks for any input.Rémi

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?

I have a land cover raster with values that can be seen in ArcGIS Pro when looking at the raster's attribute table. When bringing this raster into FME using the "Esri Geodatabase (File Geodb Raster Dataset)" Reader, the raster is brought in with no attribute values (see screenshot). Looking for help with bringing the raster into FME so that the attribute records will be populated with the raster's values shown in the ArcGIS attribute table? A smaller example raster that was clipped from the larger raster can be found at http://robot.konturlabs.com/temp/rasters_temp.gdb.zip Thanks!

 Hello!I need help with this process:The process was getting dwf file, download it and signed manually on it. We want to automate the process, by approving and adding notes in the crm system we have developed for him, and by clicking(and sending fme form's webhook), fme will get the notes and write them on top of the new dwf. I run into several issues:irst: Write directly into the new file, The new file goes completely wrong.And second, the _Markup is not written correctly as well.The fmwt is here.I would really appreciate help with that!Thanks!

Is it possible to define the mandatory nature of a user parameter according to the value entered for another parameter?For example, if the first parameter is checked, then the second must be filled in. Otherwise, the second parameter is not mandatory.Thanks for your help

I have made the same project for 3 years the same way and I’m running into an issue now. I’m using the AGOL Feature Service Reader to read a feature layer that’s hosted on AGOL. I’m attempting to read the attribute table and filter/edit some data from the different features using tester and attributemanager, the goal is to eventually write the data out to excel spreadsheets.  The problem is that it doesn’t have any of the updates made were made on ArcGIS Online/ArcGIS Pro. I have inspectors that are editing the feature layer and myself with ArcGIS Pro via Portal. I can see the changes made online and in ArcGIS Pro when I view the attribute tables, however when I read the data in FME it only has the original state when the data was first uploaded to AGOL.  I have made sure that editing is enabled in the Settings of the Feature Layer. I’ve attempted to re-authenticate my AGOL credentials within FME and I’ve reviewed the source data path multiple times to make sure it’s grabbing the corre

Hi All,  I’m working on a workflow to export the photos (as .jpeg) collected with the Fulcrum app in the filed for a bridge inspection. I have been able to install the Fulcrum Web Connector from the FME hub here and make the relevant connection through a Token. Also I have put together the following workflow to read and extract the photos but for some reason when I paste the URL photo in my browser says ‘This page isn’t working’. I expected to view and download the photo through the API / URL (picture).Here is the workflow created so far:  I think am not too far off to get this working but would need some advise if am doing something wrong as can’t view the jpg files? example of the URL here.Also below an example of one of the photos extracted in my C drive:Any idea / trick will be appreciated.

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 All,I’m working on a workflow to extract JPG files using the existing Fulcrum API. I have been able to install the Fulcrum web connector from the FME Hub and make the relevant connection to my organisations using a Token. All good.The problem is am not be able to view the URL photos in my browser as shows ‘This page isn’t working’. Below the workflow to extract the photos:Creator HTTPCaller JSONFragmenter AttributeFileWriterBelow a screenshot of some of the URLs in the JSONFragmenter:Does anyone know why I am getting the This page isn’t working error?