FME Form

Hi All,I need to identify exact attribute values changes when comparing two sets of data. The datasets have the same attributes but some attribute values are updated overtime and I need to identify which ones. I have been trying workflows with feature joiner and ChangeDetector, but I have to compare the datasets several times, discard attributes that remain the same until I identify which attribute value changed. I would like to find a more efficient way to identify the updates, any suggestion? Thank you

Hi everyone,  I am using FME 2013 for comparing geometry and attribute changes between two Shape files, one being more recent than the other. The two Shape files have exactly the same type of geometry and schema (same attributes names and definitions). They also have a lot of attributes (more than 50 I think). I have set up a logic for reporting significant differences in geometry as well as records having at least one attribute value not matching with the corresponding one in the other set. The attribute matching part can be achieved rather easily with a ChangeDetector, Matcher or CRCCalculator. These transformers will report features containing at least one attribute change among those that have been selected in the transformer properties. Given the great number of attributes I would like to to identify which specific attribute(s) has(have) indeed been modified between the two sets. I don't see an option using the standard transformers mentioned above. I did

In a FME workspace I have a SQLExecutor-transformer, which uses different database connections. I use one PostGIS-database per year called db2020, db2021, db2022, db2023.When the user needs data e.g. for 2021 a sting is generated, which contains the name of the database, in this case "db2021". This string is called "connection" and is referenced with @Value(connection) in the connection field of the SQLExecutor-transformer. This works locally in FME desktop. Alle connections are present both on FME desktop and on FME server. When I try to upload the workspace to FME server I get a error message saying "@Value(connection) is either missing or unsupported by this version of FME Server." Any suggestions or workarounds would be appreciated.

Hi pls help me with this. I just want to know which direction building is facing. I have thousands of building and i want that at once all buildings front direction should come out. The data i have are building foot print(.shp), 3d model (citygml) and road center line(.shp)

I have an attribute that contains location information (text-based) but it will say something like “Lake View, Chicago, USA”. I want to create a column that just tells me “USA”. Note, the data isn’t regular, sometimes there are many locality details, sometimes just a country, and sometimes no country. How do I just pull out the countries?

How can I fit a data in obj format to its real location in the world?

If I reproject geographic information from geographic coordinates to projected coordinates, and before I convert to geographic coordinates again, the final information has a little displacement regard the original information. I don´t have any other process in between. The displacement is very tiny, but I need to know why is it produced. I´ve make the same process in Arcgis and it doesn´t appear this displacement. I can see the displacement in QGIS because this application allows to make a very big zoom to the information. I think that ArcGis doesn´t allow to make such a very big zoom.

I have extracted files to an output folder like this. I want to extract the files inside the zipped folders and tag the folder name to the output file. How do I do this as a bulk process. The unzip transformers only seem to do one at a time but I am sure there is a better way.

If I remove the template file and write straight to Excel it is successful; with the template, FME crashes at exactly 32,715 records entering the Excel writer. I've tried a different template and a brand new template, but it fails at the same point. To confirm, the workbenches ran perfectly fine on v2018 and indeed it still does. (I have 2018 for the next couple of weeks crossover before it is being removed in favour of the 2021.2 version).  I have looked on the 'known issues with 2021' online, but don't see this issue there (though it notes not all known issues are listed)

I want convert a pure table GDB file(without geometry infomation) to DBase format.It show me success and the result can be read by FME reader.But It can't be read by any open source dbf reader included "dbf view of Microsoft" and "qgis".I studied the document of .dbf from wiki and found that the schema definition of your dbase file is difference from document.You use "I" for integer, But document is "N"Is any way can I solve this problem?Please check the definition of data type in documentThis is hex view of your .dbf file   

I have a workbench that transforms feature classes within the same sde to topojson files for each feature class. Currently I have the same feature in two feature classes that I am writing to topojson. However, the output topojson files are different for this feature. The topojson files are used in Power BI custom maps. One file does exactly what it should while the other doesn't. The issue is with that particular feature that is located in both readers and writers. I checked the number of vertices for this feature in both feature classes and they are the same (3045 - it is a large coastal feature). The output topojson contains different vertices count than the feature classes that is likely expected. But both output topojson files have different vertices count for the same feature: 3431 (topojson file that is not performing as it should within Power BI) and 3421 (topojson file that performs as it should in Power BI). I processed the feature class that produces the

Hello,I want write these in an OGC GML : <fme:AffleurantPCRS gml:id="id0ed4a56f-dd55-473e-a7f2-9ae5bcbf3af2"><fme:producteur>Producteur</fme:producteur><fme:symbolisation><fme:AffleurantSymbolePCRS><fme:angleRotation>142.70918</fme:angleRotation><fme:idSym>ID16da9e5d-ef01-4922-8cf3-a4058f4a888a</fme:idSym><gml:pointProperty>            <gml:Point srsName="EPSG:2154" srsDimension="2">               <gml:pos>619127.353 6753771.724</gml:pos>            </gml:Point></gml:pointProperty></fme:AffleurantSymbolePCRS></fme:symbolisation></fme:AffleurantPCRS> My geometry is in AffleurantSymbolePCRS/symbolisation/AffleurantSymbolePCRS

Hi guys,I am working on a basemap project in arcgis pro now I have to create raster tiles and vector tiles for the basemap.So my questions are​1) Can we open and visualize arc gis pro project or map package in FME if yes then how?2)Can we create raster tiles in FME?3)Can we create vector tiles in FME?4)If we are using web Map tiler then can we import our own arcgis schema?This is a part of my study project ​Thanks in advance.​​

What would be the best solution for triggering a FME workflow or FME transfomation file instantaneous, when a xlsx file is uploaded/created in an Amazon S3 bucket?

FME Desktop 2022 Build22153: The color and frame of transformers are not printed as the workbench is printed in A4 paper size with “fit to page” option,  I couldn’t figure out why the color and frame of transformers are not printed as the workbench is printed in A4 paper size with “fit to page” option as per the screenshots below What could be the issue here? The workbench is attached          

Hello, I have a table with some attributes and I created a new column which is called "Description" with the following string, by using the text editor in attribute manager : "New values, Dat: @Value(Dat), Nat: @Value(Nat), OBJNAM: @Value(OBJNAM)" However in some cases there are no values in all those attributes and the output looks like this:  "New values, Dat: , Nat: Underground heigh., OBJNAM: , " I would like to exclude the attributes that don't have a value (in my example the Dat and ONJNAM), for each row.I guess I should use somewhere a conditional formatting but I am not sure how and where to do that.  

Hello,I am trying to configure SharePoint List Reader/Writer using the Web service Template. I tested FME 2021 and 2022. I have an Azure Single Tenant environment and followed the documentation (https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection#singletenant, https://community.safe.com/s/article/Create-an-FME-Server-Azure-Active-Directory-Web-Connection-in-FME-Desktop,

We prepare kml files from Tab files as a regular practice to show our maps on our websites. However for multigeometries the popups don't work on our websites. These popups work in Google earth for the kmls but always fail in the web API. Any idea?

Dear FME community, we are working on developing a 3D Web application to visualize 3D Buildings (CityGML LoD2) and other 3D assets in CesiumIon/ CesiumJS. We have been able to create LoD1 and LoD2 3D Tiles that we can use in the application but the 3D Tiles output is very data intensive and really slows down the rendering in our application tremendously. That leads us to think that there might be something other optimizations we can undertake to improve our workspaces for better 3D Tiles creation that can be streamed better in Cesium (e.g. cascading structure of 3D Tiles or splitting of large tiles into smaller chunks for optimized web rendering). Furthermore, we are having problems with successfully creating 3D Tiles in LoD2. We would like to create building solids that are selectable and have all the desired attributes attached to it instead of having the surfaces being individually selectable.  I have attached 3 workspaces that we are cur

Hello there we have number of truck send there location over time and status as below we are looking to create an event for each in/out status , the result will bewe will create an event as soon as we detect status = in and we will close the event as soon as status=out  Thanks 

Hello FME Community, I want to create an access database from my tables.When creating the database, some columns must be defined as primary keys. I want to know how can I define column in FME as primary key before writing.  

I'm interested in generating SQL automatically, for use in SQLExecutor

In FME Workbench I have a Bufferer transform which is stopping on a specific feature. FME is reporting:Bufferer_SC1_2DBuffering (PolygonDissolveFactory): Buffering feature number: 49788And stops.How do I find out what feature number 49788 is referring to? What I want is not the FME Feature number but the value of a unique user identifier called search_criteria_pk_id.regardsSimon

Is it possible to upload a zipped File Geodatabase into a specific folder in an AGOL user account using FME? if yes, what would be the best transformer(s) to use?