Transformers

Hi community,I have something very simple so it seems, but I can't figure out how it's done. I have area features A and area features B. I would like to calculate an attribute per feature from A which contains the calculated from the overlapping feature B. This should be very simple and it normally is. I would use the Clipper en calcultate the areas comming from the inside port. Or I would use the AreaOnAreaOverlayer and test the number of overlaps > 1.The problem is that within A features can have overlap. Features B don't overlap themselves. So some area's of B have to be calculated per overlapping feature A. The Clipper doesn't give me overlapping areas and in the AreaOnAreaOverlayer I can not distinct A from B. Anyone any idea how to solve this? Greetings,Arno

I found this list of most used Transformers (https://knowledge.safe.com/questions/2367/most-used-transformer.html ) but is there a list of most used Formats also?

Hi,I am in new in Json file formatting and I have a flat file that contained data to be used in HTTPCaller to an API that need structured Json formatting file. I am struggling with converting my flat file into structured Json format. I tried many options and can't get it to work. I have attached my input and desired output filesThanks for your assistance. 

Hi FME python experts,  I'm working on a problem where I have 3D objects returned from a python library. Thanks to @david_r and @gerhardatsafe's help I've been able to successfully port the geometries I need in most cases to FME Geoms which I'm super happy about.  Now I am trying to take it a step further and create the appearances - for non-textured appearances I've got a fairly decent working method, however, for textures the only way I've been able to get it to work is to dump the textures to files (JPEG/PNG) and then read them back in with FME before creating textured appearances and applying them with the SharedItemSetter. As you might imagine this is a little slower than I would like given the data are already in memory.The images seem to be in the form of "PIL.image" ("C:\\Program Files\\FME\\python\\python37\\PIL\\Image.py") Has anyone attempted this? Any hints on how I might be able to

Hi,  we are using fmeserver 2019 1.3.1. After starting the backup the server is generating files in the temp directory in a compressing way.  So the temp directory grows up to 2.3 GB till finishing the backup.  How can the fmeserver directly does the job on an SHARED_RESSOUCE backup without caching files in a temp directory?    Best regards,  Matthias

Is their any document or link which can help us understand intergraph gtech electric data model.

I have autocad files i am pulling some polyline entities from. i am currently using the PointVertexReplacer to extract the coordinates of the polylines.The problem i am having is that i began expecting 3 vertices; (a begin, a vertex, and an end). I encountered a line with 4 vertices. Previously i just iterated with AttributeFilter through 0,1,2 as these 3 vertices.But because 1 line has 4 vertices the 3rd vertex is not the end. (it would be nice if there were a begin/end attribute that could be grabbed.)I am trying to figure out how to filter these prior to this and can only come up with using the feature information but cannot expose this information. I can see the number of vertices value but it is not exposable. I assume i could do a count but it seems that would require quite a few more transformers.Can anyone suggest how to accomplish this?

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?