Transformers

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

i have many lines with different id inside the polygon ,some of lines crossed the polygon from both side and some not as picture . overlaps equal 1 in any lines intersected with polygon even if it is intersected from one side or two sidebut i want to extract only the lines that intersected only from two side .i used lineonarea with tolerance automatic but the output overlaps =1i used spatial relator but always i got the same output with any transformer overlaps =1it will be nice ,if someone advice me how could i know which lines intersected two times or one timei used tolerance Automatice but no changes in output Thanks in advance

I have got multiple featureclasses within a database, which I need to compare with the same database in the future. The featureclasses all have a GlobalID (unique value), which is the same as the GlobalID in the other database. I need to detect any changes to geometry and attribute values and write these away in preferably a new featureclass, an Excel list will also do.  The "Changes" list or table should include the GlobalID of the feature, the "before" value and the "after" value. The geometry I have found is not an issue as I can use the "Change detector". However I seem to struggle with the change in attribute value, I have gone over several posts but none with a (working) answer (some links do not work anymore).  I am rather new to FME myself and do not have a lot of python knowledge, I am working with FME Desktop 2018.1 and the ArcMap the features come from/go back into is ArcMap version 10.3.1.  Any help or guidelines would be much appreci

Hi,I have been sent a road network in polygon shp file format and need to translate this to just the centreline of each polygon. This will show the road network as a polyline instead of a polygon. Please note I am not just looking to turn the polygons into polylines.Any help would be most appreciated.

Hi,Do you have any suggestion to convert a raster 4 band 16bits to a raster 4 band 8bits.I use RasterInterpretationCoercer and i select RGBA32. but the result is not good. Thank for your help

Hello,I am slightly confused and probably missing something with Deaggregator (or part counter).When I run part counter, I find out that 3 of my 48 features are multi-part. However when I want to deagregate those parts, one of these 3 features has no part number and isn't deaggregated.This file contains the 3 multi-part features, but only 2 of these are split up. The problematic multi-polygon has a donut hole, but this is the same for one of the other polygons and there it doesn't cause problems.Any ideas ?   

I need to convert Input image to 256 colors (8bit) by using the exist palette of Old raster. I suppose those FME -transformers are not correct for this case. Which FME-transformers are suitable for this problem?

Hi there,Using FME 2019.1, trying to convert GIS annotations (ArcSDE) to DWG.This is an example of my data source in ArcGIS.This is the final result in AutoCAD. Why am I getting those big disproportionate ugly annotations?Is there anything I can do? TX

Hi,I'm using dynamic writer using [schema from table] reading a workspace resource csv as per the tutorial.However the attribute types aren't created, and I can't for the life of me figure out why!schema csv as follows (Ive several feature_types)Esri shp Writer Any help/suggestions appreciated.ThanksDave

Hello everyone.I have a .dwg file including substructure data of an area. I'm studying on creation a 3D city model with virtulacityPUBLISHER. To be able to create this, I'm transforming dwg file into a geojson file format via "bufferer" transformer (Buffer Type: Solid). But solid type creating a semi-sphere at the end of the line. And then, generating surfaces which consist of 6n^2 faces. If we think about an awful a lot details for all substructure details (e.g. gas or water tubes, cables etc.) it will be too much surfaces to publish (with a web browser interface) for a city model. So, how can i simplify the lines (especially end of the lines) which is using for creating goejson file types.Thanks.

I'm nowhere near as experienced with dealing with Rasters in FME than vector data, so I'm looking for corrections/optimisations to my method of extracting Surface Levels from a City-wide 1 metre Raster. I'm simply feeding the Input DEM Raster and Input Points into PointOnRasterExtractor to extract the Pixel values onto the Point Features. However, this executes far slower than the ArcGIS equivalent 3DAnalyst ArcTool. 77,000 points take over 1 hour to calculate!The Raster Reader is the ESRI FileGeoDB Raster Dataset Reader.So:Is this the right Transformer or are there better ones?Should I be pre-processing the Raster with something else before putting it into PointOnRasterExtractor?Are there methods of limiting the Raster Cells to use in PointOnRasterExtractor which may make it faster (even though in theory this optimisation should be within the Transformer itself) by using a spatial comparison beforehand?

Hi community! I'm unsure how to tackle this so looking for any suggestions...What I have is a data set of hundreds of points. These are arranged in 'groups' by sharing a common attribute. I'd like to join point to point (create lines) in every permutation of each group. See example images of groups below.My ultimate objective here is only to find the longest distance (and generate a line) between the points per group. Bear in mind that there are multiple groups so I need to run the operation by group or have another means of performing the analysis per group. This is a 2D exercise however the points have a Z value that I would like to retain. Thoughts?

Hi guys,I got a challenge for you: I have 500k+ grid points with a distance of 0.5m and need to find the neighbors from each point within a given radius (let's say 2m).The NeighborFinder takes horribly long. The SpatialRelator has about the same calculation time.What I am now thinking of is to get the neighbors mathematically rather than spatially. For each point I can create the attributes minX, minY, maxX and maxY. Then, I just need to test if one of the other points' coordinates are greater or smaller, right?!In the end every point should have a list of all his neighbors (and their attributes).Any ideas? Or any hints how I can speed up the spatial tester?Cheers, Maria

Hello,I have summary output coming from the StatisticsCalculator that I would like to rearrange such that row values become column headings with values for these coming from the statscalc count output (see input and end result images below). I've tried AttributePivoter, AttributeTransposer without success.Thanks.Tony

Hi, I currently have 2 MapInfo table -First table contains points with fields Id1 and Number1 -Second table contains roads with fields Id2 and Number2.  I would like to calculate Number2=Sum(Number1) when Id1=Id2 AND the points are the closest to the line. The roads are divided into multiple segments but those segments have the same Id2.Multiple points can be assigned to one segments, and all those points share the same id1=Id2. So I think I should use NeighborFinder but is it possible to only search through segments with the same Id2 ? Thank you

 i have network of many lines in the map and i want to define start point from one line of different lines then i want to flow in each direction till the end as picture abovestart point will start then go in the first direction but it will find first intersection point with 3 directon so go one by one as example then it finds second intersection point with 3 direction then fo in first line till reach end line 1 and give me the coordinate of the last point (last vertices 1 ) then come bk to second intersection point and continue in the second line but it finds the third intersection point so go till end line 2 and extract vertices then come bk to third intersection point and go to end line 3 and extract vertices then come bk to second intersection point and go to last direct ion till end line 4 and give me coordintaes of last point and after finish it return back to the first intersection point and till reach end line 5 and so on . at the end i want to check the end coordinates of each

Hi,I would like calculate the distance between points by the road.I have 1 file with origin points ( 1 000 000 points) and 1 file with destination points (10 000).I would like the distance between every origin - destination points, so 1 000 000 x 10 000 distances.I try to do, with only 12 origins points and 5 destinations points : But the problem is for the FromTo, it take only one destination on a camp common with the origin points.How i can to do to have 12 x 5 = 60 combinaisons ? Thanks a lot, Matthieu