FME Form

 Hello,  I am updating an existing AGOL Hosted Feature Service with changes in a File Geodatabase. The workbench in the screenshot is what I am using. The Feature Service updates no issues, and it does update the feature service. But I have a question:When I add 1 new feature in the file gdb (Updated FGDB Feature Class Bookmark in screenshot), I run the workbench and in the ChangeDetector it shows 1 record Inserted and 238 records updated for a total of 239 records; The only change I made was to add 1 new feature (which I expect to be in Inserted), but why would there be 238 records in Updated in the ChangeDetector when I only Inserted a single record and Updated zero records, should these 238 “Updated” records be in Unchanged?I then reran the workbench it showed 239 records in Updated (which includes the one I added in the 1st run), but I Updated zero records so I would assume these 239 records should be in Unchanged?

Greets,  Any idea to cut the polygons in the layer 2 based on the polygons in layer 1 in the same shape and close or same ratio of cutting , please note that there is a shifting between tow layers.or move the polygons in layer 1 to match the location of polygons (based on corners) in layer2    

Hello everyone,I'm facing a challenge in processing data in Excel and I'm seeking assistance. I need a method to search in one Excel table for entries that contain values from another Excel table and then create a new table with the found entries.Specifically, I want to search an Excel table (Table A; 8 collumns) for certain keywords. These keywords are located in a separate Excel table (Table B; 1collumn). When any of the keywords are found in Table A, I'd like to create a new table with these entries.I would greatly appreciate any advice, tips, or examples that could help me solve this issue.Thank you very much in advance for your help! 

Hi all!I have a polygon where every vertex/point (don’t know the correct termonology) has a xyz coordinate. I would like to create a buffer where the buffer size depends on the z-coordinate. Couldn’t figure it out how to do it. Anyone who can help me figure this out?

Hi,I have some texts and want to export them as IFC along with the other geometries.Can anyone help me please?

Is there a way, similar to AttributeExposer, I can import the columns from a CSV file and use that to identify what columns to keep? I’m reading a number of CSV files into a workspace with different attributes for 3 different file types and there are over 300+ columns. A picklist approach is a bit cumbersome.

Hello,I need some help.I am a major student and I am in my final paper for my diploma. I Have to make a 3D map of a town using Citygml.I have used Arcgis to create the shape file and pgadmin to create a data base.But when I try to connect my database to Citygml It doesn’t work.When I open the command line to insert the parameters it says that there is a problem.I have installed postgresql and Java in my computer.i don’t know if someone can help me but you are my last hope haha(Not an native English speaker so if something is not explained good please be understanding)

I have installed FME form (2023.0.0.3) and am trying to run workbench or licensing assistant or any of the suite but I run up against the Qt6Gui crash. The articles in the FME community forum have mentioned that this has been a known issue and have suggested upgrading to the latest version to resolve this.Unfortunately at this time there is not a later version. After several reinstalls and deleting every FME folder I can find I still get the same error.To get around this I have reinstalled FME 2022.2.3 and workbench works as normal. Is anyone running into this issue with the latest version?Do I need to wait for the next release to resolve this?Has anyone had luck with replacing the dll to get around this? The below is a screenshot is what I am seeing:The only thing I can

Hi.I have millions of XYZ points (as an Space Delimited XYZ file read) and want to build a triangular mesh out of them.Which transformer(s) should I use? Thanks in advance.

I am reading data from a PostGIS table and writing to an ArcGIS eSDE, but I’m not able to create tables in the eSDE from FME, I can only write to tables created by ArcGIS Pro in the eSDE, is this normal?   I'm getting an ArcObjects error ‘-2147220655’, DBMS table not found. 

Hi, I have many polygons with height attribute. I need to dissolve the adjacent polygons and keep the max and min height of polygons dissolved. The problems it’s the quantity of polygones that are dissolved it’s random, can be 2, 5, 50, 100 or more. I made a dissolve with generate list, then a ListSorter but then I don’t know how to get automatically the min and max. I think to use attributeCreator with Arithmetic Editor after the ListSorter but I don’t know how to set it to get systematically the min and max of entities dissolved Thanks

Hi, I tried it with a mod counter,  Inputs seem to work but no output at all comes out of the custom transformer. I am passing all attributes (not many anyway) into the custom transformer. It makes no difference  I am trying to add a Z value to each point (frorm vertices). With the TIN I get a much cleaner result than with a raster, but it slows down the entire process x4. Thanks in advance for any suggestion.

Hi FME users,  The main purpose of my recent FME workflow is to GET the files from the folder from the FME server using HTTPCaller. Although the process displayed green which means the process is running correctly, the inspector showed the HTTP status code 200, which means the results are rendered in the response body (Figure 1. ) but not created successfully in the local drive. Figure 2 is the basic setup in HTTPCaller. Figure 1. FME Inspector. Figure 2. HTTP Set-up  Then, I tried another URL copied from FME API using POST, /fmerest/v3/resources/connections/Data/download/Logo/CPB_Logo.jpg, then the FME gave me the

is it possible to  Exporting OLE Civil 3D Objects From Drawings to excel 

Hi,I have to carry out a project to produce and publish an interactive web map to disseminate data on traffic osbstructions and works in progress in Montreal.However, the data used can be downloaded in CSV format from the City of Montreal's open data portal, but also accessible via the API provided by the City's open data team, the link is as follows:https://donnees.montreal.ca/dataset/info-travaux/resource/cc41b532-f12d-40fb-9f55-eb58c9a2b12bWhat is the complete workflow process to retrieve data from CKAN Web Service API using FME Form?Attached is my incomplete workbench of my workflow that I tested using HttpCaller Transformer to test connection.Please provide me with some possible solutions.Regards, 

Hi, I've been working with a web connection to Sharepoint Online, created with help from this article:How to Create a SharePoint Web Connection for FME Form [Single Tenant]For SharepointOnlineConnector. It works for a time, but after a day or two there is a problem with refreshing my access token. This was the error message today:Updating access token for 'Microsoft SharePoint Online'Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad RequestPython Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.If I reauthenticate my web connection It works again for a time.Any ideas what the problem may be?

Hi, I'm reading around 5 million rows from the 252 Excel files. I need to view the rows to delete many columns and edit values, but indexing the results is taking a long timeHow can I improve this? Thank´s

Hello,So I am having the time of my life with Italian WMS’s 👌 and some of them even have some table data queries connected to them. I would however like to get the table information for more than one feature at at time, instead of opening in PRO and click each polygon and collect. Knowing that FME does not support standard GetFeatureInfo yet then I’m speculating if someone has created some artful way of achieving this anyway (sure there are plenty of those).So far my idea is to fetch a center point for each of my respective polygons, do coordinate extraction and then add those values to a standard HTTP based GetFeatureInfo request with some FME string gymnastics. The WMS in question is this here:

I have a dataset of around 200,000 records (point geometry with approximately 10 attributes).I am using the Change detector transformer to update only those records that are updated and to add new records or to mark some as deleted records.I am using the Feature Writer transformer to write the data into an ESRI Enterprise geodatabase in MS SQL in Azure Cloud. Source data resides in the same geodatabase in Azure Cloud.!!! FME Server is installed on premise, not in Azure !!!When initializing the ETL by truncating the destination table and initial loading of the data, the 200,000 records are written in about 7 minutes.!!! There is an index on the attribute that is used as Primary Key and that attribute is indicated After the initialization, the time to perform the ETL is still low (5-8 minutes) if there are no updates on data, or if the

Translating using 2014 igds_text sixe 8 translates to Height and width 0.08 however translating using 2021 using the same parameters it translates to 0.00 and if it is a multi line text with 3 lines of text it translates to 0.03.  I did try other scaling sizes even up to 20 and the results were the same. Please advise  Since I need to do an upgrade and don't want to have to redo all of my text items I installed and tested FME 2017, 2018, 2019, and 2020.. It appears that the text change happened in release 2020. I can use the same FMW file that I created using 2014 and it works fine for 2017, and 2018.. I did have a glitch using 2019 but once it ran the data was correct. Starting in 2020 the text sizes were all messed up. I am hoping someone can advise me on what may have happened.

Hi all, We are trying to configure Azure AD SAML authentication for FME Server 2022.2 . We have used the express installation and then configured an IIS reverse proxy. We are getting the error in the attached image. Is Azure AD SAML authentication with an IIS reverse proxy supported? https://community.safe.com/s/article/Configuring-FME-Server-for-Azure-AD-SAML-authenticationhttps://community.safe.com/s/article/using-iis-and-arr-as-a-reverse-proxy

As the title says, I have two different point feature classes, and then a table in the geodatabase.  Point A has a unique field value that matches from the point to a record in the table and then, that record in the table has a unique value that matches to Point B. I want to use this “connection” and the vertexcreator transformer to create a line from Point A to Point B, for situations where they match, but I am stuck at the moment and can’t seem to connect the dots. Pun intended. 

I have an AttributeManager in a custom transformer (may be part of the problem but thought I would start simple with the AttributeManager) that has the following data (correct) on the input but the name of the attribute (not the attribute values) is assigned in the output.Input Attribute “Public_Water_System_ID” with correct values and output with wrong values:Settings in the AttributeManager is as follows:For data type I’ve tried buffer (default), varchar(20), and char(20). None of the other types seemed to make sense since the values are string.Perhaps a related problem is that this attribute (“Public_Water_System_ID”) is passed as a parameter into this custom transformer

I have been tasked with connecting to an FTP site, retrieving a csv file, parsing that file into multiple Excel worksheets within one workbook and then FTPing the Excel spreadsheet back to another FTP site.I have all the component pieces working, in 6 different workbenches, the download of the original csv file, the parsing and writing of the data for each Excel sheet and creation of the four individual worksheets and the upload to the destination FTP site.  However, I have been advised by the local FME Admin that the process should be housed in one FME workbench.  And in order to achieve that, instead of downloading a physical csv file, I should be downloading the data as an attribute so that all of the subsequent processes could be housed within one FME workbench and the attribute data shared by each subsequent process, leaving no artifacts at the conclusion of processing.I have created one FME workbench and copied all of the processes into it and made all the adjust

Wich versions FME desktop are compatible with pluggin Smallworld 4/5?