Transformers

I know i am missing something obvious here, but i need to select all of the polygons containing points. I have tried the point on area overlapper which works fine for those polygons containing only one point, but if it contains more than one point it will only select the polygon once.How can i export the same polygon with the merged data for each point the is selected?I.e. 3 points = 3 polygons albeit the same geometry but different attributes.Thanks for your help?Andy

I am reading from a postgresql database. Attribute [publication_time] has a primary key and type timestamp. In the postgresql database this attribute has values, but FME 2018.1 inspector shows no (blank) values.Can timestamp as primarykey be the cause? Kind regards Kees 

I'm new with FME. I have one attribute with this value "Zonne-energie in woonplaats vermogen 0,2394 MW, beschikte productie per jaar 227,43 MWh, looptijd 15 jaar. Het project is nog niet gerealiseerd (peildatum januari 2020)."I want 4 values out of this values and put them into 4 attributes.- 0,2394 MW into VERMOGEN- 227,43 into PRODUCTIE- 15 into LOOPTIJD- januari 2020 into PEILDATUMI want to use StringSearcher but i don't what Regular Expression to use. CWho can help me?

I have IFC data that originally used a local cartesian coordinate system. It originated in Navisworks and I used Intergraph Smart Interop Publisher to convert it to IFC format so I could use it in FME. I want to use the data in GIS software (ArcGIS Pro/Online) so will likely convert to multipatch/revit.What is the best approach for georeferencing this data/working out control points, etc.? Some of the IFC files are quite large (500MB+). Any suggestions appreciated!

I have an orthophoto in ESRI GRID format stored in a file geodatabase. It works really well in ArcGIS and ArcGIS Pro; however, I need to convert this image into a GeoTIFF for a contractor that does not have an ESRI based GIS. I have tried to do this in ArcGIS Pro but I keep running into resolution and grainy output problems, and the documented fixes and remedies are not helping.  As I have FME Desktop, and I have seen that FME is capable of converting raster imagery from one format to another, I thought I would give that a try...but now my output is even worse than before.  Not being one to give up I thought I would come here to see how I should approach this using FME. Is there a trick to converting raster images? I thought it would be something quite straight forward (e.g. Geodatabase raster reader --> TIFF writer), but obviously the process will be a little more complex than that, at least this is my current thinking.What is the best way to convert an image from one format to

Is it possible to read in multiple files from a parameter with FeatureReader? For example:C:/some_path/fileA.shpC:/some_path/fileB.shpSourceDataset parameter value would be: C:/some_path/fileA.shp,C:/some_path/fileB.shpBut this approach doesn't work, it gives an error.

Hello,I am interested in how to get a given point distnce with FME.I have points arranged by counter (pontID is ascending) and I want to get the next point's distance. I tried NeighborFinder, but the problem is that sometimes an other point is closer,so it gives a wrong distance.Thanks!

Now, ever since discovering Bulk Mode transformers like FeatureJoiner, AttributeFilter, AttributeManager etc. my WorkBench designs look radically different to my "old" ways of doing things in FME. Gone are almost all of my Testers, FeatureMergers etc.One of the things I had been meaning to test though is "Does FME automatically activate Bulk Mode where possible or do you maybe have to "Force" it? "It appears that in many workflows they do not automatically switch the Transformer into Bulk Mode!!!Example 1 - AttributeFilters (Bulk Mode capable) fed from a Tester (Not Bulk Mode capable)Takes 55 seconds to complete.Example 2 - AttributeFilters (Bulk Mode capable) fed from a Dummy FeatureJoiner (Manually forces Workflow back into Bulk Mode)Takes 23 seconds to complete despite having a extra FeatureJoiner! Here I just match on any random fields with FeatureJoiner. I'm not actually trying to Join anything, but rather "force" the workflow back

I'm trying to map levels names from one MicroSation DGN file into different level names in another DGN file. Most of the levels are being mapped correctly but some features are not being mapped at all. Not sure why that is happening. Has anyone else had this problem?

Currently the MapnikRasterizer will not render lines/polygons if the output raster dataset exceeds ~32,800 columns - text and points will render normally regardless of the size. For example, if I try to process a dataset that spans 40000 x 45000 pixels, the output will be missing the rasterized lines past column 32,768.

Hi, I'm working on a workbench to report on changes made to a data set. I have a database table with a column of unique IDs. I store a previous copy of the IDs so I can compare current against previous.Using a FeatureJoiner I can establish NEW/DELETED IDs - brilliant......The issue is that I may not have Unjoined Left/Right every time so at the moment my workbench doesn't proceed.I need to get to the point where the workbench can continue/report even if either/or both are null. Is FeatureJoiner the best transformer?Any ideas? Thanks 

How to make LoD3.0 or LoD2.3 buildings in 3D shape. I have roof constructions and the floor in 3D. Is anyone doing it? The data set is in dwg format.

Hello,Can you please help me with HTML parsing. Which settings I should using (css selector and etc) into HTMLExtractor that I can get only value of data-title attribute ?Regards, Pavel.

I've got a *.dwg with a surface and an image attached on the right coordinates.I would like to drape the image over the surface, the image will drape but I coudn't get it on the right coordinates, who could help me please? The files and workbench are attached. Thanks!!

Picture 1: Picture 2: I want to do a Raster Mosaik so i need to make sure that the Rasterbands of the two Pictures are the same.why has the picture nr 2 behind the channels "#"? Never saw a Raster with the Band behind the Channel.

Hi all,I am using 2DGridAccumulator, which works perfectly fine. I would like to write also the bbox coordinates of each grid to my final output. I can see those values in the inspector but I don't know how I can extract those attributes so that i can write it. Any idea how i can do it? thanks in advance.  

Hello FME users,I am trying to configure the RabbitMQ JMS client for FME Server, without success. I copied the client files and dependencies directly in "FMEServer\\Server\\lib\\jms". Next, I configured a JMS subscriber to send message to my RabbibMQ Server :- Protocol : JMS- Provider Type Or Context : com.rabbitmq.jms.admin.RMQObjectFactory- Provider URL : server-name:5672- Connection Factory : com.rabbitmq.jms.admin.RMQConnectionFactoryUsername and password : OKDestination: a queue nameWhen I confirm my configuration the following error message appears : "Unable to find provider named com.rabbitmq.jms.admin.RMQObjectFactory. Ensure that the appropriate libraries are available and the correct provider is selected."What I am missing? Any help will be really appreciatedThank youAlex

Hello Everyone,I am trying to run the translation on the Electric Migration workspace for Electric Asset Package V3.2 (Electric Migration V3 2019_12_18.fmwt file) using FME Desktop version 2019.2.3.1. It fails because it is missing a file called "NapervilleElectric_2019_10_22.gdb.zip". Is the file available for download, and is the workspace supposed to produce an asset package that is ready to load into a Utility Network without further configuration?

Friends help me find a solution to the problem.1 There is a cloud of points falling into the field of all areas - (A, B, C)2 Areas have intersection zones - (1,2,3,4)When I start the scheme, I get the result(A + 1 + 2 + 4B + 3-1-2?-4-2-3)And I need a result(A + 1 + 2 + 4B + 1 + 2 + 3C + 4 + 2 + 3)That is, all grouped point clouds must have a zone of intersection in each result.What am I doing wrong?

Can anyone advise how I can read a .shp file two sub-folders down from a zipped file? I've looked at previous posts on this group and they have suggested using wildcards to navigate the sub-folders (e.g. .zip/**/**/*.shp) but this hasn't worked for me.The .zip file is found here and the pathway to the shape file I want is below, you can see that it is two subfolders down from the parent directory:...\\HS2_Phase_2a_Additional_Provision_2_and_Supplementary_Environmental_Statement_2_February_2019.zip\\Shapefiles\\Construction_Proposed_Scheme\\CON_CN_ConsolidatedConstructionBoundary_Ply_CT05_AP02.shp The shape file reader works fine when the folders are unzipped but won't work otherwise. I've also had no luck using a FeatureReader or when the .zip file is stored locally. I'm using FME Workbench 2019.2.

I have a DWG file that is using the NAD83 CRS and when I convert it to a SHP file and load it into QGIS the placement is way off according to the base maps I have loaded.At this point I have only been trying to do a single layer to try and figure this out but eventually I will do more layers. I am only looking to get certain geometry for now (eg layer T-CABL-FIBR-AREL-N (72ct)) and I will add attributes later.I have tried leaving the CRS at NAD83 and also tried to change it to WGS84 (which I ultimately would like to end up with).Sometimes I even end up with the geometry changed from what it used to be, sometimes minor and sometimes extreme.I've been trying different combinations of changing the CRS in FME and changing what CRS is being used in QGIS. At this point I feel I have tried every combination so there might be something else I am missing as I am still new to FME and QGIS. I haven't changed any of the settings of the reader or writer and just left them all as default bec

Hey, I want to calculate values from 2 columns and get the results into a new column. Its only a multiplication: values of column a * values of column b = values in new column. Does anyone know how i could do this?

Hi,I am trying to set up within an FME workspace a way to run select transformers within the workspace based on the day of the week, and other parts based on the month.I have various external datasets I want to refresh internally (SDE) by pulling them externally; some datasets are to be pulled every Tuesday, while others are on a quarterly basis (2/1,5/1,8/1,11/1). I would be running the workspace from FME server on a daily basis but have the coding within the workspace to refresh based on preset conditions.I am running FME 2018.1 build 18547

Hello, I'm trying to download a series of excel files that are on a website. There is a starting date of 9/19/2005 (its hyperlinked for each excel file) and it increments by 7 days (so its a page fill of hyperlinked dates). I'm guessing I need to create a list of all dates starting from 9/19/2005 so that I can use httpcaller to download each file. I'm having trouble creating the starting date so that I can use DateTimeConverter to create the range (and consequently create the full url's to each file). I tried using AttrubuteCreator with a new value of DateTimeCreate(2005,09,19) but this expression errors.Thoughts on this and I'm all ears if there is a cleaner approach. Thanks in advance

Hello,I have a vector in 3D ( building edges), vector is stored as a line. I would like to create polygons around every line (10 cm buffer for every line). Polygons should get the same height as the line. I don't want to create a cylinder, I just want a 2D buffer on a proper height.Thank you Kate