Transformers

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.  

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

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".....

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. 

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

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

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.

Imagine having a raster with transparent gaps (null) and wanting to fill these gaps with another dataset (presumably of lower resolution). If this second source is placed under the first the secondary data would "shine through" the gaps. This is how one would solve it in Photoshop, and I'm trying to figure out if the same solution is possible in FME. Is it posible to set the layering/stacking order of incoming datasources before running the RasterMosaicer?  (This is a follow up question to: https://community.safe.com/s/feed/0D5Dm000007hjgQKAQ)

Hello, I have a raster dataset. I need to intersect vector lines with it and then get the average values of the raster cells (pixels) that intersect with the vector line. I have a working solution to do this but I have to convert the raster to polygons with a RasterToPolygonCoercer. Some rasters are larger (8.2M cells) so this takes forever and is very memory intensive. Is there a better way to do this without converting raster to vector polygons? I'm not super experienced with rasters so please explain well.  Thanks in advance!  

I have read all the SchemaMapper tutorials and implemented what I thought should work for a SchemaMapper and input mapping table, but the feature type in question here is not being mapped at all. I am hopelessly confused, hence the following explanation and question: I have a feature type Safety/Fire (i.e. fme_feature_type = feature_dataset/feature_class) that I want to split into three different feature types based on the value of the Type attribute. The values are FDC, Fire Alarm, and Fire Extinguisher. I also want to put the three new feature types into a different feature dataset, namely Life_Safety. Here is a screenshot of part of the mapping table I am using:  In the SchemaMapper I have set first a Filter Features action with SRC_FIELD = SRC_FIELD_VALUE indicated and with Ignore Blank Attribute Values set. Then I have a Map Feature Types action with SourceFeatureType --> TargetFeatureType indicated. Finally, I have a Map Attributes action with SRC_FIELD --> TargetAttr indic

I want to connect the pipelines to each other in Z coordinates at the place where there is a mutual vertex intersection.

Hi. I would like to know how to apply a custom icon for kml styler. At this moment, I could convert from Csv file into Kmz file with icon that I can select at KML Styler with condition Statement (like value 1 = C1). However, I would like to change these icon into my custom icon (png files). How Can I set? Please kindly give some advise to me.

There are some postings on this but it does not work for me yet:I am trying to contact an external API via HTTP POST to get a token back.It already works with python. But we wanna integrate the workflow in fme server and Iam sure it will work with fme. Python script:# Parameter_____base_url = 'https://apieco.eco-counter-tools.com'api_key = 'XXX'  # Base64 encoded secrets  # Tokenabrufdef get_token(url, api_key):    header = {        'Content-Type':'application/x-www-form-urlencoded',        'Authorization': 'Basic ' + api_key              }    r = requests.post(url + "/token", headers= header, data={'grant_type': 'client_credentials'})     answer = json.loads(r.text)    token  = answer['access_token']    return tokenHTTPCaller: Erorr Message: HTTP/1.1 415 Unsupported Media Type  Which mime type should I use for the grant_type: client_credentials?

I have a raster DTM with some erroneous transparent areas. I would like to fill these using average vales of the surrounding pixels, to keep everything nice and smooth. GRASS has the 'fill nulls' function that does this, does FME have anything similar?

I have multiple shapefiles in a folder with subfolders. Example Folder "01" has 10 shapefiles, Folder "02" has 15 shapefiles, etc. I was able to create a gdb and load all the features into the gdb but the whole thing is too large. Is it possible to have FME create a new gdb for each subfolder name? What I would want is a new gdb named 01, for the data that was in 01. Another new gdb named 02 for the data that was in 02, etc.thanks!

Hi FME ninjas,I'm working on a data source that contains school names. The names in the source are too long and need to be shortened.Left is what I have, right is what I want: I know the StringReplacer can be used to correct single strings - but I fear I will need to create at least 40 of these to correct all possible strings.Is there a transformer that can replace multiple strings? Or can this be done by Regexing some transformer? If so, how?Thanks,Ed 

I'm finding that when you write a raster image to Excel while using the ExcelStyler to stretch the row height (e.g. 100), the raster will be stretched in the y-direction by a factor of about 7. This only occurs for the first column (xlsx_col_id = 0), and writes fine to other columns. Is someone able to confirm if this occurs on their version too?  It's possible to force a fix by adjusting the xlsx_raster_height to be about 7x less than xlsx_raster_width, or write to a different column. Version: Data interop FME(R) 2021.0.0.0 (20210305 - Build 21302 - WIN64). Thanks!

The TIFF has only angle unit and does not have linear unit and the shp file only has been defined Geographic coordinate system. What can I do?, Does the TIFF file have to have Linear unit before?

Hey everybody,​I would like to define the hierarchy from the first administrative level into the second administrative level, and I would like to do that with the spatial reference. So for example I have a shapefile of the first administrative level which is called "Central". The second shapefile are the districts, so the second administrative level, which are all in the Central state. Lets say we have 4 districts (south, east, west and north). The name of the Central state, so "Central" should get automatically get written in the attribute field "hierarchy" of the 4 districts. I would like to use the spatial reference as transformer. But it was not working. Has anybody an idea how to solve that problem?Thank you in advance.Cheers,Fabian 

I am not that familiar with the Emailer, but I experimented a bit with it and I find it a bit worrisome that I can send a mail from one mail adress (not necessarily mine) to another mail adress. I tested using my colleague's mail adress to send a mail to my own mail adress and I don't need to authenticate that I am the colleague.You can choose yourself to have the sender's authentication on, but I would prefer that it's always required so you will be sure that the person who sents the mail is indeed the sender and not someone else.

hi everyone,My colleague tried out the Emailer transformer and it's cool that you can sent a mail from one mail adress to another mail adress in an automated way. However the mail sent via the Emailer are not stored in the sender's sent items folder in outlook for example. Does anyone know a way in which it's possible to send a mail and the mail is stored in the "sent items" folder?I heard it's because the application server is allowed to sent mails from another mail adress to another mail address, so it's not yourself.However I would still like to know whether it's possible and maybe possibly via another method if the Emailer transformer is not suited for that.