Transformers

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 wrong output topo

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 I have read the documentation : https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/gml/user_attributes_w.htmThat said : "Geometry attributesThese attributes are used to control the name and the posit

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?

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.  

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 currently working with.  I would greatly appreci

I am trying to use the HorizontalAngleCalculator to calculate the angle of some lines but it seems that even lines that are quite obviously 45 degrees are getting strangley small angle values. I have checked it it is set to be in Degrees, I'm wondering if anybody can point out what is wrong.  

ho un dato poligonale di tipo multipolygon. Ad uno stesso identificativo, corrispondono più poligoni. Per ciascun poligono, nel campo Area, è presente il valore della superficie. Devo calcolare la somma delle aree dei poligoni con uguale identificativo

I am working with Copernicus WorldCover data and I wonder how FME is reading pixel values. I read the data with a FeatureReader, to intersec t the input with my AOI, and looking at the cached results of the FeatureReader I get 'NoData' in the Data Inspector, when selecting an area where the color map is interpreted correctly and according to the product description from ESA the color indicates a map code of 90.The subsequent applied RasterMosaicker shows the following result, at the same location.Now the value changed from '0 NoData' to '10'.As described, the color indicates a value of 90! The problem is basically present in any of the mapped classes, and values are altered from 10 -> 220 -> 330 -> 4etc.90 -> 10 I am adding a link to the coding of the map layer and definition of the classes and two Copernicus images so you can try to read a single GeoTIFF and reading all GeoTIFF files in a folder -> https://drive.google.com/drive/folders/1jusyArd5

I used the ArcGIS Online Feature reader to read a hosted arcgis feature layer that has attachments. I can use the AttributeFileWriter to write the attachments to files. But when connecting the reader to a file geodatabase, the feature layer writes to a feature class, but the attachments are not included. Is this the expected behavior? I am at FME 2020.1.3.

Hi all. First post for me here. I have a workbench where I want to overlay a point dataset on a single band geotiff elevation raster dataset. This workbench will be published to FME server where ppl will uploaded their point dataset and terrain Info will be calculated. The GeoTiff dataset is large >10 gb. To speed up the process I have tiled the dataset into smaller tiles and created a shape file index. I only want to load the tiles which overlap the point dataset. I find out which tiles overlap the point dataset and then, using a feature reader transformer, I’m selecting the tile to load. My question is, what would be the best way to load multiple tiles if the point dataset overlaps more than one tile. Is it best to use multiple feature readers with each tile being passed to one feature reader. But I’ll never know how many feature readers I need. Any thoughts. TIATK

I have a feature service link from which I extract data, but I cannot see the latitude and longitude in the tables. When I inspect the data, I can see the details. Can anyone tell me how I can extract the location details?

I hope this message finds you well. I am reaching out to the FME community to ask for suggestions on how to map transmission lines data using sub1 and sub2 columns. Our goal is to find the node mapping between transmission lines and substations, and we have the necessary data in these two columns.I have been working with FME for a while now, but I am not sure about the best way to approach this mapping task. Any advice, tips, or best practices you could share would be greatly appreciated.Attached the piece of data for understanding.Thank you in advance for your time and expertise. I look forward to hearing from you soon! 

Hi, I am using the census bureau's API to gather population data for a county, and the data returns in the response as two separate arrays. One array contains the headers, and the other contains the data:  [["NAME","B01001_001E","state","county"],["Spokane County, Washington","546040","53","063"]] I am mainly having issues with transforming the data in this format as it isn't what outputs normally look like when using other REST APIs. Using a JSONfragmenter will correctly assign these as two distinct arrays, but I can't seem to figure out how to associate the corresponding values to build a table from these arrays.

What transformer can I use to snap the red line to the black line keeping the intersection point (blue circles) in place? Anchored Snapper would snap the edges but shortens the red line while Affine Warper works only for short lines. Thanks!

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