FME Form

I have a table of data. I want to merge it to itself so that the data is side by side. I tried FeatureJoiner but it lists the data stacked not side by side. I suspect this is because the field names are the same. I added a AttributeManager to one of the table inputs and converted the field names to "original field name"+2 and I get the results I am looking for.. Is it possible to perform a side by side merge on the same table without having to rename all the fields in one table? Is there a transformer that will rename automatically?

Everytime I try to import a database there aren´t any informations about buildings. I also tried to look into the db through pgAdmin4, but dont even see the tables. I would like to import the data and get the data exported as CityGML (.gml) format.  

Hello, I wanted to calculate RMSE between two DTMs. How can I do that?

Hi, I'm pretty new but this workbench should be straightforward I thought 🙂I have an Excel Sheet with 40 land parcels of interest that I want to display on a map. So I used a feature joiner to get the spatial information (from a spatial dataset) for these 40 land parcels based on a parcel number. All looks good. My output has the 40 polygons with all the attribute data. So then I used the EsriReprojector to project to Web Mercator Auxiliary Sphere. That's the projection used at work in ArcGIS Online. All looking good in the data inspector. Polygons look good, attributes look good, coordinate system is what I want. no errors in FME. However, THEN the problem starts. I can write this to a geodatabase, but the coordinate system disappears and becomes UNKNOWN during this last stage of writing the output. So, suddenly the coordinate system disappears.  I just wonder if this could be because of my FME version (2018.0)? Or am I doing something wrong. Because it all seems strai

I have followed the tutorials available and also tried following other questions on the forum on this topic. Workspace template with data cache included.

I have 12 netCDF files downloaded from https://data.ceda.ac.uk/badc/ukmo-hadobs/data/insitu/MOHC/HadOBS/HadUK-Grid/v1.1.0.0/1km/tasmin/day/v20220310. Each contains 1km-1km grid values of the minimum temperature for each day of a specific month. I would like to create a single combined file that counts the number of days where the temperature was below zero. I've tried RasterExpressionEvaluator but I can't get it to generate anything sensible. Can anyone help please?

Hi , i have path file name in attribute C:\\*\\*\\*\\filename.dwgi would like to extract only the (filename.dwg) Please , I want to remove C:\\*\\*\\*\\Thanks in advance

Hello FME community, as I work a lot with raster data and File Raster Geodatabase, I noticed in the 2022.1 version of the FME desktop version that I can not clip raster data (aerial photos). Both the transformer "Clipper" and the option in the reader "Use Search Envelope" do not work. Neither as TIFF nor as raster GDB. In the 2021.1 FME desktop version it works without problems.  Does anyone know the problem?

im thinking the feature merger but my attributes are not merging

Hey community! How can I read and then modify property set data in an IFC?Which transformer should I use? How can I read the IFC in the most correct way for my goal? I cannot read thE "IfcPropertySingleValue".....

Using AttributeManager to update 86,000 (existing) records using APN for key. Is this process optimized by FME? It takes a long time, and I assume it is N*N time. (Does the Reader iterate through each record, one at a time, then searching through all the records in the Writer to find the matching key?)

We are about to install Server for the first time on a dedicated virtual machine. Since our subscription now includes floating Desktop licences, does it cause any problems to have the Desktop licence manager installed on the same box? Thank you.

I have an AutoCAD drawing containing points, lines, polygons, and text layers. I want to do the following: have the actual AutoCAD text values in the kml file and set the yellow push pin icon for text features to null or no icon.

Hi,I am struggling to change the color of polygon, line and point as well as popup and labels on map included in HTML Report. It seems like an easy task but I am struggling to find a solution. I assume my questions are:How to change the colour of polygons, lines and points on the map base on the value of the attributes?How to edit labels and popups so they have different values? I have followed the instructions from Add Conditional Coloring to Map section of How to Customize HTML Reports (safe.com). Unfortunately, suggested method is not what I am looking for. I have attached my workbench. Thank you for all suggestions. 

Hello to all the members of the FME Community!We would like to know if you have any applications or workflows that are currently using the FME Server JavaScript API. It is no secret that we have not prioritized enhancements or upgrades to the library, and, if at some future date we decide to deprecate support of the FME Server JavaScript API, we want to make sure that we have provided alternatives to keep your apps and workflows running when you upgrade. What are you using the FME Server JavaScript API for that you cannot do with the FME Server REST API?We have started development on V4 of the FME Server REST API, and this would be a great opportunity to add new capabilities so that there is a smooth transition path available. What impact would the deprecation of the FME Server JavaScript API have for you and your organization? If there are any questions or concerns, we can start thinking about them now.  Note: Please keep in mind that we do not have a target date to deprecate the FME

Hello again everyone, I have a question for anybody who's worked with passing JSON data in the body of a POST request for a webhook. I am working with a developer on a script to call FME server from an outside application and pass the needed JSON data in the body. She is using an AJAX script that looks somewhat like this: $.ajax({        url: <my server url with webhook token>,        method: 'POST',        data: {"A":"1",         "B":"2",        "C":"3",           },        dataType: "json",        success: function (response) {                             alert(JSON.stringify(response));                     },               error: function(data, errorThrown){                             alert('request failed :'+errorThrown);                             //document.getElementById("response").innerHTML="Failed"+errorThrown;             } }); Here's the thing: I have a

Unable to get the Web Service to Authenticate (redirect url)BTW, we are no longer allowed to use our personal accounts for Auth, therefore we have Service Account files we use. Therefore, unable to create a Web conn either. Only way I can create a writer is to select Service Account file and define the table myself. Then I preface the writer with a PythonCaller to get the creds.When defining a NUMERIC in the writer, does not allow me to specify width/precision. Any updates to this writer planned soon? 

BonjourJe souhaite à la lecture de ma couche commune, exclure les communes d'une dizaine de département identifiée par leur nom ?Merci

Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.

I have pdfs with multiple pagesi have to split them up by a certain textstring (e.g. SS 66,16)This textstring is always nearly on the same coordinate on the page, so i can isolate them and write the text in a new attribute but how can i fanout them that i have all content right from one page (e.g. pdf_page_number 2) and the pdf is named after that textstring (SS 66,16.pdf) Greetz and cheers Franco

In the workspace I have a geometry extractor transformer, which outputs OGC Well Known Binary format.After geometry extractor, SQL server non spatial writer follows. In the writer, the WKB field is defined as the varbinary (width 8000) type.In an SQL server database, this field is defined as a varbinary (MAX) data type.All translations went smoothly in the latest FME Workbench 2021 version.However, in version 2022, it does not work. I tried different data type combinations for sql server writer and for database, however without success. 1. casewriter data type: database data type:varbinary (8000) varbinary(MAX)  Microsoft SQL Server Non-Spatial Writer: Attribute 'abc' of feature type 'xyz' has specified type 'varbinary(8000)', but existing database table field has type 'varbinary_max'. Information may be lost during conversion.Microsoft SQL Server Non-Spatial Writer: Attribute data '\\x01\\x03\\x00\\x00\\x0\\x95\\xAC!AR\\xB8\\x1EU\\ ... ' too la

We have an IFMEFeature from type FME_GEOM_AGGREGATE.The window "Feature Information" in FME Desktop displays the IFMEMultipoint property with 299 parts of IFMEPoint.How can we get these multipoints in the writer plugin? If we call feature->numCoordinates() we got 598 but if we call numParts () or numVertices() we got the correct number of 299.And if we call feature->getAllCoordinates() we got a list of 598 coordinates, but only 299 of these are correct and the other ones consists of a point with coordinates (1, 1, 0). Where does this point (1,1,0) come from?The list of coordinates starts with1,1,0valid point1,1,0valid Point1,1,0....

Hi list.I got a curious error in a workspace, which I needed to update.I needed to update some schema references (from .../1/... to .../2/...) and thought that it was a good idea to create a private user text parameter, containing the "2" needing to be inserted.However, this yielded a strange error when applied to the root expression in my XMLTemplater. Something like this: "... can not expand namespace prefix to URI"Is it correct that XMLTemplater cannot use user parameters replacements ?And if so, why not ?Aren't these applied to whatever parameters a transformer may have, prior to its execution ?Cheers.

I am wanting to read and write features to a POSTGIS connection however I can't even connect as I am unsure what to do for the schema field. Can someone provide examples of what to add in the schema for table field.