Transformers

I have turned my roadnetwork in a LRS (linear referenced road network) with measures. Now I have a table with roadaccidents without coordinates, but with the measures corresponding to the LRS (e.g. km 12.90). Is it possible to locate these locations on the map, using the LRS, and thus find the coordinates? The best solution I've found so far is to extract the nearest measure values, but these dont get close enough.

HiA colleague is making maps in QGIS and is using an Open Street Map WMS layer to provide the background mapping. However, the exported map does not match what is displayed in the QGIS project. It appears to be a different zoom and the labels are hard to read.I'm looking at using FME to export the area of interest to a raster file. I'm using the WMS reader as my input and set a search envelope. But the exported image is not at the required zoom level.Is it possible to change this behaviour?If required, the WMS feed I am using is https://ows.terrestris.de/osm/service? and the layer is OSM-WMSThe bounds are:Min x: -59.9741977894788221Min y: -14.7534977323780918Max x: -54.6051733096797207Max y: -11.1201081643435327EPSG 4326FME version: 2020.0.2.1 (20200511 - Build 20238 - WIN64)Many thanks.

Hello, I am having some issues getting the proper format of a table I am trying to transpose. I attempted a couple of methods using the FMEHub AttributeTransposer and did not get the required results. If you see it is almost a half transpose, I need to get the records in the first sheet to line up like the records in the second sheet in the attached spreadsheet . I have hit a roadblock. 

How do I activate thousand separator in translation log? FFS writer: 1300000 of 3305727 features writtenFFS writer: 1430000 of 3305727 features writtenFFS writer: 1570000 of 3305727 features writtenFFS writer: 1700000 of 3305727 features writtenFFS writer: 1840000 of 3305727 features writtenFFS writer: 1980000 of 3305727 features writtenFFS writer: 2120000 of 3305727 features writtenFFS writer: 2260000 of 3305727 features writtenFFS writer: 2380000 of 3305727 features writtenFFS writer: 2520000 of 3305727 features writtenFFS writer: 2650000 of 3305727 features writtenFFS writer: 2780000 of 3305727 features writtenFFS writer: 2910000 of 3305727 features writtenFFS writer: 3040000 of 3305727 features writtenFFS writer: 3170000 of 3305727 features writtenFFS writer: 3305727 of 3305727 features writtenSpatial Index: Adding 3305727 featuresSpatial In

Hi  I was wondering would anyone know what I am doing wrong here? I need to run an FME workspace on a second machine in an automated way from my first machine. So I am using the systemcaller and passing the following using PSExec to remote call the fme workspace on the second server. Nothing is happening and im getting the exitcode 1 PSExec \\myservername "c:\Program Files (x86)\FME2019\FME.exe" d:\FME_Workspaces\test.fmw If I run the above in cmd directly this runs exactly how I expect, is there something I am missing on the system caller side?I have tried a few variations by adding cd C:\Windows\System32 before PSExec but I cant seem to get anywhere. It is essential I find a method to start an fme workspace remotely from the first machine, seems like it would be easy to do ?? Any ideas? Thanks 

Hello there I have an attribute with values concatenated, I am looking to add character for each value Before Attributephoto1,photo2,photo3 looking to get this after : attributehttp://photo1/text,http://photo2/text,http://photo3/text

Can FME do a bulk rename of all attributes to combine the original name and the first row. See picture for example. The left side is the input. The right side is the desired output.

I am using FME 2018.1 32-bit and while reading an .accdb file, I am encountering this error "WARN |Microsoft Access Reader: The epoch time is out of range. Please ensure it is specified in seconds, and not in milliseconds or microseconds". Translation stops after this with a Fatal Error message. There are more than 2.5 million records in the table i am accessing. If I give a where condition an extract 100 odd records, it does execute. When i run the same Workbench in FME 2017.0 32-bit without any WHERE condition, it executes successfully. Any info on how can i troubleshoot this error ?

Hi I'm getting this error a lot: Resampler: Failed to process raster with invalid dimensions: 0 rows by 1 columns. This operation can only be performed on rasters with positive values for both rows and columns@ResampleRaster: Failed to resample raster to cell width '0.032' and cell height '0.032'RasterResampler_2_RasterResampler: A fatal error has occurred. Check the logfile above for detailsClipper_Raster (RasterClippingFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details. I'm getting this in a workbench that reads tiff tiles and blurs some parts of them.The workbench works in most cases and sometimes I'm getting this error. Is it possible to detect which tiles are bad? 

Hello There During a cleaning process, our work space failld process due to the reader attributes with value are 0.we need to add a process to set the width and type of the atribute in order to avoide such issue

I am trying to upload an excel file onto GoogleDrive. However, when connecting the GoogleDriveConnector to my Reader, the transformer uploads multiple copies of the same document onto my drive How do I make it so it will only upload the one copy?

Hi! How to add custom 7 parameter geographic transormation (for example between MGI-C and WGS84)? Reason why i want add new transformation is because parameters in FME is not accurate enough for surveying purposes, so i want add new geographic transformation with official parameters released from state surveying administration

Hi all,I have in an excel sheet something like:I would like to determine the score according to my attribute value. So for example I hav an attribute with value 10 the score would be 1,5. The AttribueValueMapper could do this I know, but I would like to point to the excel so I can 'manipulate' the scores in excel and not in FME workbench. Is there a way to achieve this? Greetings,Arno

Hi, I upgraded FME Desktop on our Citrix environment to 2020.0.2 but as soon as I open any FME program, I get the following error: Licensing looks ok: Any tips on how to troubleshoot the installation? Thank you in advance!

How can I get multiple output based on unique attribute. I have 50 diffrent brand names in my input file & want to get 1 out for 1 brand, so for this input file I need 50 outputs.@david_r

Hi there, I hope anyone can help me, thank you in advance, Juan.I have an excel file where I define how polygons must be created .I have a Lines feature as spaghetti dataset, with an attribute feature name.The excel goes: Feature name / Feature required to make polygons Buildings / Buildings Sidewalk / Sidewalk, Building, Roads, Fences Roads / Roads,Fences,BuildingsNow I need to combine the excel rules and the spaghetti dataset to make my polygons?   

Steps to migrate data from intergraph gtech technology electric to fgdb.In Fme is their any gtech specific feature reader which makes migration easier.

Hi there I have a viewer https://maps.greydc.govt.nz/intramaps90/default.htm?configId=2f6f83a4-782b-45eb-9b60-d5819e718428 where I wish to extract the water assets including water, stormwater and wastewater. I would like some guidance in how I can scrape/extract this data. Can it be done?

HiDue to performance issues I had to roll back my fme from 2019.1 to 2018.1 (see post here).However, going back in versions appears to have thrown up a problem. I am trying to run about 5500 features through the AreaOnAreaOverlayer and it is giving me 80000+ features on the output. This was never a problem with the previous version (I was only getting about 7500 features output). Does anyone have any idea why this would happen? I've attached the log file if that is any help.Thanks for any help you can give.B

Hi, sorry for this newbie JSON extractor question but I am using the JASONExtractor transformer and I am trying to populate a column called 'Temperature' and populate it with the value, such as '50' shown below. My query is this: json["beds"].["Weather"].["Temperature"] but this and many, many other variations also do not work. Can someone please, please help me? [ { "id": 3009, "beds": { "Time": "Morning", "Weather": { "Temperature": 50 },{ "id": 2969, "code": "STPAL", "name": "Acme Co." }]

Hello,I have a DWG file with rooms drawn as closed polylines (all on one layer), and within each polyline, there are 2 text labels (on 2 different layers). I'm trying to transform these 3 layers into a single GeoJSON file, where the room polylines would populate the "geometry", and the 2 text labels would populate 2 different "properties" ('id" and "label"). I tried doing this using the FeatureMerger tool, however this doesn't produce the result I'm looking for, as the attributes from the Supplier ("id") are merged. The current result is that all the features in the GeoJSON have the same value for "id", which is not what I'm trying to achieve. I simply want to transform all the rooms to geometries and the 2 text labels to properties of the geometries. I'm sure I'm missing something simple, but is there a way to get the result I'm looking for? Here's a screenshot of

Hi, I have a .obj file and a geotiff file, the .obj file is in xy space and the geotiff file is in UTM-48N projection. I am looking for a way to "align" and reproject the .obj file. Is there a way to reproject the .obj file to geospatial coordinates?

Hi,Is it possible to place 3D created objects with the creator transformer, on specific xy coordinates from a point dataset?Thx,Mark

Hello,I'm wondering about data showing in the Visual Preview.  Below an example. Two flows of data going to two Inspectors. When I select the SRC_RAW Inspector the Visual Preview shows the SRC_NORMALIZED data. I will have to use the drop down menu in the Visual Preview to retrieve the SRC_RAW data.  That has annoyed me for quite some time now - why can't I just select the Inspector and see the proper data straight away?      Cheers, Ed 

Hi FME community,  I need help to do one little thing: I have a request to simplify the geometries I processed with a tolerence of 0.5 meterThe geometries come from two tables and at the end they are saved as Geometrycollection (with aggregator).  Thanks for you help...