Transformers

I have loaded some features from an Open Street Map file (.OSM). Some features have the attribute "oneway" and "oneway:bicycle". I'm a able to create a test clause targeting "oneway". When I try to do the same for "oneway:bicycle", I get an error: "Specified attribute does not exist" (see image at the end). This causes the software to show a warning before running the workflow. Strangely enough, the filter is applied perfectly fine! Am I doing something wrong? Or can the warning maybe be a bug? 

I have a workflow where I use the schema port of a FeatureReader (format Geopackage) to check if the schema of the input gpkg is correct. This works fine for a single file, fme_feature_type_name provides the table name, and I have the list of attributes.However, if the input is more than one file, the schema is a 'global' schema combining the schemas for all input files, avoiding double tables. As a result I cannot check each file separately.I found out that using the FeatureReader with type Schema (any Format) gives on the generic port all tables as feature, with the attributes list, for all files. But here is the problem: when using Schema (any Format) on a geopackage, these tables as feature on the generic port do not expose the table name. I expected fme_feature_type_name, but this is not available in the output. fme_feature_type gives 'schema' as value.Is there any way I can get these table names ? Thanks,Marc 

Hello Sir/Madam, So I have many models in CityGML formats. I would like to put it on the Cesium to view the data. However, as some of the models (CityGML) are huge, I guess it have more than 300 features for each models. Hence, the FME cannot convert the CityGML to Cesium 3D tiles format.  I am sure my citygml model is fine, as one of the model is able to convert to Cesium 3D tile and able to view it on the Cesium. Is there any way I can convert all the models successfully? Thank you.

Hi FME community,I am still fairly new to FME. I'm getting stuck with date/time fields in csvs and excel documents. I've attached the field I'm trying to convert into DD/MM/YYYY HH:MM (%d/%m/%Y %h:%m ?), but it writes out empty if I try the DateConverter or AttributeManager> Text editor > DateTimeFormat. It's likely I'm using the transformers incorrectly. Is anyone able to point me in the right direction?

Hello ,I have multiple lines connecting to each other in shape file and each multiple lines has different id with increment 1 ,as example : multiple lines include id ‘s : 250 ,251 ,252,253 ,….and different multiple lines include id ‘s : 4090,4091,4092,4093,….I would like to combine the lines together that connecting to eachother and increment with one from others id  my target : to convert each multiple lines that looks like square to polygon and also the street lines to be together as seperate another polygon . i am not sure how to achieve that,so i have thought that may be i combine id with increment 1 , i hope if someone has idea ,let me know please  FME 2021Thanks for help  

In the attribute manager, I would like to create a new field called ('Age') and calculate the attribute value from another field called 'Date of Birth'. This is within an automated process that will be run multiple times a month, so I need it to take the time that the process is run and use that for the age calculation. How can I do this? This is my attempt at this : (GETDATE() - @Value(Date of Birth)) / 365 (although there is no GETDATE function as far as i'm aware of.)  Thanks in advance!

Hi,I have a rail network, featuring multiple polylines. I need to snip 50m from the ends of each line.Using the Snipper transformer, I use the Distance (Value) mode. The Starting location is 50, the Ending Location is the length of the line -100 (accounting for the 50 already removed at the Starting Location... maybe?!).The results are mixed: A dead straight line has 50m removed from each end, this is what I want.Any other shape of line only removes the starting 50m, but NOT the end, as shown by the red "X" below. The blue lines indicate the Remnants.What am I doing wrong? Can anyone help please?

I have an existing dataset with labels where I want to increase the font sizes of all features. This of course results in overlaps in places, and I am trying to figure out if parts of the repositioning could be automated with FME. What I have is the original placement and sizes of the labels. I would like to use these placements as starting points, increase the font sizes and then move anything that starts to "entangle".I have read up on the MapTextLabeler, as best I could. It should do what I need. But it comes at a price, I don't know how steep, and I only need parts of what it offers.Has anyone had any success building a workspace that spaces stuff out? My thoughts are:1. Create bounding boxes from the label, sized in ground units.2. Check if any of these are "to" close3. Move those in need further apart.4. Check to see that no new overlaps have occurred.  No 3 above would be the trickiest one me thinks. The repositioning distance would need to be calculated

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.