FME Form

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.  

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 multip

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

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?

Dears, we have recently upgraded fme server windows machine to 2022. Post that character encoding default changed from Ansii to UTF8 because of this files generated by our workspace having special french characters causing issue for interface systems. Earlier with ansii encoding format they were able to read files with out issue. Im not able to find how can i change to Ansii encoding fo rthe files generated by our workspace. As of now im opening the file in notpad and saving in ansii and then sending to them as a work around. Pleas ehelp me ot automate this utf to ansii conversion. Thanks

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 work

Hello everyoneI have installed the module xarray with pip but I always get the error message :Screenshot error messagePython Exception <ModuleNotFoundError>: No module named 'pandas._libs.interval'Error executing string `import fmeimport fmeobjectsimport xarray In the old FME desktop version 2021.1.3.1 the module worked perfectly. In the new version FME Form 2023.2.2 it no longer finds the intervall submodule from Pandas, although it is present in the installation path. The Python interpreter is set to 3.8+Can anyone help me with this?

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  

Hello, I’ve run into a strange issue. I am accessing a polygon feature class via a SDE connection. Whenever I add the reader it does not appear on the workbench, it does appear in the navigator panel, but not on the actual main workbench menu, where the workbench is visually developed.item appears in navigator panel, but no where else. I can run other readers from other .sde connections but there is something wrong with this one. I can access/read the data via the same SDE connection via ArcPro. 

Hi guy’s A workbench that worked before gives me some crazy errors that’s driving me nuts.I used the workbench before and it worked normally.  It has to write some geotif tiles with deflate compression. No matter what I do, I always get errors about me using jpeg compression. I tried everything. Clearing cache, deleting cache manually, restarting pc, copying everything in new FME file, updating all the transformers, making a new wb, try running it on another pc with more recent version of FME... I had a similar question in the past and than the solution was to use a bulkattributeremover with ‘geotif_’. This doesn’t work either. This is the wb, it’s just shapefiles and geotifs as import: Any one with ideas?

I’m looking to determine the number of line segments (green) to the end of a network branch (road network) from a given point in the network (red dot).Ultimately, I want to do this to be able to determine if a network branch is a dead-end up to a certain threshold of number of road segments (i.e. 30 segments, but would not consider 5000 to be a dead-end...threshold to be determined)I feel like using the StreamOrderCalculator to determine the Strahler Order is almost what I want except that loops may be present (as shown in teal) which removes that option.I’ve tried various things with the Stream and Network transformers, but can’t seem to figure it out.I’ve also tried with a PythonCaller, but I really struggle to translate a Python solution on dummy values to one that actually uses features and their geometry. I fe

Question of the WeekThis question was asked in Live Chat this week, but to be fair it has come up several times from various users...Q) I've forgotten the password to the admin account on our FME Server. Is there a way to recover it? A) In short, no! But because the FME Server Support team has seen an increasing number of cases recently where a customer is unable to log in because of a forgotten password, I think it's worth outlining what the options are at this point, and how to avoid getting here in the first place!What's the Default Admin Password?Up until recent FMEs, the default administrator account used to be admin/admin. You can see why we felt that wasn't a good choice, because it's so easy to guess.So now - although the default is still admin/admin - you are forced to change it when logging in for the first time. The username remains admin, but the password becomes one of your own devising.I've Forgotten the Ad

Hi, I would like to share a solution to an issue I had, just to hear what you think about it. The challenge is: to create hyperlinks in a Word document.FME allows you, with the use of MSWordStyler transformers, to create a Word document in a very versatile and easy manner. These transformers, however, do not allow you to insert hyperlinks into the doc.Please see the attached zip file hyperlinks-to-word-python-docx.zip for a workflow where the document is created using MSWordStylers, followed by some post-processing with a PythonCaller to insert the hyperlinks: POIs with a link to Google Maps, in this case.No, I did not write all of the Python script myself, hell, no! I used some existing bits and pieces and tweaked them a little bit to get the job done.The add_hyperlink function was found on

Recently I have been playing/fooling/struggling around with the creation and modification of Word documents using a combination of MSWordStylers and the Python docx library, called from a PythonCaller. A very instructive journey :-)To make sure I don't forget immediately everything I've learned, I have decided to summarize my findings in a template. And because a lot of input has come from this community I will share the results here. Please see the zip file attached: images-to-table-python-docx.zipIt starts by reading Parcel information from a database (gpkg) and it creates a summary table in a word document, including a little image with the parcel plotted on an aerial image.Inspiration has been taken from these to discussions:

hello i’ want to assign one single elevation(Z) for all the vertices in a polygon based on the elevation point available inside the polygonplease suggest any ideas  

Hello... I’m new here, and I have a basic question. I’m trying to update a hosted feature layer in AGOL, but I have a 400 error about HTML. I check my attribute table, and I have one attribute with notes (string), and the character that I have a problem with is <, but I cannot change it because I need the information. So, I cannot use the text encoder or change the character. Can anyone give me an idea of what I can do?