Transformers

Hi All, I have kml and image as input files. The requirement is to generate another image by merging both. I have merged both and able get the raster, but I'm not getting transparency in the area within the polygon.I have attached pdf file of requirements and workbench for better understanding... Thank youPratap

I have a raster that gets cut up to smaller sections in a clipper. Within these sections the cell values need to be identical. I have used a RasterStatisticsCalculator to get a mean value for each section. But how do I write these to the cells? My guess is that there is a step missing in my workspace below where the attribute need to be "written down" to cell level? Unfortunately I can't find a transformer that does this. I might ad that I have tried a different aproach where I wrote the mean values as a new band, and then removed the old one. This got half the job done, unfortunately, it also overwrites null values. Which means I end up with bounding boxes around everything, and corresponding stray values.  

I was wondering if it is possible to convert KMZ-files to CityGML? The KMZ-files contain a doc.kml file and a folder (models) which contains model.dae, model_textures.txt and a texture folder containing a .png. I´ve been searching for a valid solution but I can´t seem to find one. I have looked at the common data workflows (https://www.safe.com/convert/). Does anyone have any ideas how to solve this problem. To note: each KMZ file is representing a building, which we want to convert to CityGML so we can use 3DCityDB.  Thanks

Hello everyone,I have been scouring these forums for a solution and found a few posts with similar problems but no solution seemed to work for me. Granted that might also be due to my limited experience with FME so here I am. I am trying to rework a table from this:to this: I have been trying out transformers such as AttributePivoter, Aggregator, AttributeExploder and a few more and also tried to create colums using AttributeCreator and AttributeManager (but I couldnt get it to automatically create colums based on the unique Methodology-Codes, there is too many in the original dataset to do this by hand) I would be thankful if anyone could push me into the right direction, as I cant seem to make progress on my own here. Thank you.

Hello everyone, I have a question about the resolution of Raster I want to know, why we can not convert a raster with larger pixel size to smaller?

I have 15 .csv files with different names but the same fields and a total of 1406 records. They are in the same directory. I want to merge all 15 files together and append the source file name to each record. I've tried FilenamePartExtractor, FilePathExtractor, and FeatureReader but haven't been able to to get the desired result. I usually get back more records than I put in. Is there a straight forward method to append file name to each record?

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.  

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?