Transformers

i used Network topology builder calculator , and each line has specific id so i get the output for which id is connect to which id ,but i have one problem when more than one line intersected it repeats id more than one time bcs as example id 5 connects with id 7 and id 9 and id 10so it repeats one id ,many times it depends how many lines connected to the same point ,so i would like to ask ,how could i give for all connects point the same id_network bcs if A connects to Band B connects to Cso A CONNECTS TO C so all of them should have the same id _network id_network for A =8id_network for B= 8 id_network for C = 8I WANT TO give the same id_network for all lines connects to the same point i do not want to repeat one id more than one time .  

Hi. I am working with FME 2019.1 and I have created a workbench that needs to be run by a person new to FME.The wb uses PostGIS database where the connection details are 'Embed Connection Parameters'. There are multiple hosts which come as dropdown options (choice parameter). So, when I have select a database from the dropdown, next thing is the schema that should be reading/loading by itself of the selected host. But, that's not coming.What is now- Problem faced: It is done manually by copying the schema name from PostgreSQL server to FME. Any ideal solution for this?Thanks.

Hello All,I apologize if I am not making much sense, as I am new to 3d modeling.I am having trouble trying to think of solution. I want to take spatial-vector data and output to local coordinate system. The local coordinate system, ideally, would be constraint to min and max extents of: -1m, -1m, 0.5m & 1m, 1m, 0.5m.Right now, I am getting values larger than min and max extent when using localcoordinatesystemsetter X CommonLocalReprojector. I am not sure what I can do to equalize each x-, y-values in order to scale appropriately. Nor find transformer that I can input area-extent as min/max extent constraint. I am sure there is a mathematical formula, but am lost. For example, point-1_Local = -7.5403653628193155, -5.638463266998554, 0.5point-1_LocalConstraint ~= -0.4817, -0.504, 0.5 point-2_Local = 7.502099056082192, 5.551721092860062, 0.5point-2_LocalConstraint ~= 0.8439, 0.828, 0.5 

Hello,I'm trying to find only the letter D on its own in a string such as the following: B,G,D,DM,TD,DM,TD,D. In this example, that would be 2 D's (the third D and the last D I've marked in red).Unfortunately, all the regex expressions I've tried also gets the D within TD (e.g using D,|D$). Thanks.Tony

I used the surfacedraper to drape the cogopoints on a surface, i'ts look like he doesn't do anything.My goal is to compare the height of the cogopoint with the height of the surface on the same x-y coordinate.My thought was to drape the cogopoint on the surface and compare the height. civil3d2none.fmwbasic.dwg

Whats the best way to extend a raster to fit a larger extent, filling the additional space with the nodata value of the raster? Many Thanks for the help

Hello Team,I am loading data from .JXL to SDE, While loading data i got following error, Could somebody help me out with some resolution for the issue.|ERROR |An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.} Thanks...

Hi I have been provided with a dwf file with pipeline information. I would like to extract the pipeline and attribute data. I was thinking I can use nearest neighbour method for this but I can't even extract the text or specific pipeline data. Could someone guide me with what I need to do to expose the attribute to get this information.

Hoping someone can help with this. Since upgrading to 2019.2 our existing workbenches have begun to fail. Each time a coordinate system is called on it appears to be missing a curly brace at the end. E.g. "{EPSG:27700 is not a valid key name." or "{OSGB-GPS-2015 is not a valid key name.... Last line repeated 11 times ..."These are only warnings until eventually the workbench fails under:"No definition was found for coordinate system `{EPSG:27700' "Wondering if this is a bug or if we are missing something? Let me know if I need to provide more info.

Hello,  I try to connect points to assess certain river characteristics. I used LineBuilder > connection break attributes (to the attricube that speficies one specific profile along river). However, it's not one, line but split up in several parts, even though the attributes do have exactly the same number.  What is the reason for these 'cuts'? And moreover, how can I connect the lines?  Thank you very much!   

I'm trying to generate a cell averaged DEM to generate smoothed contours within FME. After converting bare earth las points to a DEM using the Raster DEM Generator (1' cell), I want to average the values of those cells for smoother contours and it seems that the Raster Convolver is my best bet. Within the Raster Convolver I'm using a 5x5, weights all set to 1, Divisor set to 1 and Operation set to Mean but my results arent really matching what I can create in ArcGIS, they appear to be shifted to the side, about 2.5'. The Focal Statistics tool in Arc can be used to average the cell values of my initial DEM in a 3 cell radius with proper results. Are there different settings I should be using in the Raster Convolver or is there a better way to go about this?

I have approx 600 points based on top of a surface. I want to be able to generate a 5 meter long line in each of these which is in the normal direction of that surface.This is to be used for planning boreholes in a tunnel.Finding the normal of a surface is ok - but the normal of the point on a surface seems to be more difficult. The lines that needs to be generated is created manually on the last image. 

Hi I have a GeoTif file and need to convert it to RAW format for import into Unity as a terrain. Anyone know how to do that? Tried different options but nothing seems to work.

Hi. A calculation has been completed in FME and a PDF of the results has been generated. The results are shown in tabular form. We also want to generate a graph/chart from some of the data and add this graph/chart to the PDF that is produced. Can anyone provide any guidance on how this can be done?

I have two MicroStation Files, one is a parcel map with parcel numbers inside each parcel polygon. The second file is a right of way polygon that intersect the parcels. How do I create individual parcel polygons of just the right of way intersections and attribute each polygon with the parcel number?

"2046": {        "ID": "020935",        "Address": "Bagg Close 9, 29643 Churchtown",        "Provider": [            "D2 - GSM09",            "D2 - LTE08"        ],        "Locationdocuments": {            "stob": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",                "LP": "0b37ed04-4d01-4f07-b67f-d8bd2590a66c",                "AD": "c019cc03-c812-4816-8024-407cedeb461c",                "IBA": "9684e283-10e6-4e95-8931-3906fd3a62cb"            },            "12.09.2014": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",               

 input  required output   i have duplicate ,same many id in first columnfor each duplicate has different values in attribuute worldas input excelfor id 400 has 1,2,7so i want to extract one id from the duplicated one id called 400 for the three duplicated id and in front of this id 1,2,7 change all values in attribute world that contains 1,2,7 to new value for any id not included in world attributethen chack again if we have another duplicate value in id attribute ,same method ,extract one id as 267 and it contains 3,11 in attribute world so change any value in attribute world to new value for any idso i want to check at first column if i have duplicate of id in first column so i want to extract only one id from duplicate and it contains 3,11 so change any value in world attribute than contains 3,11 for any value to new value not in cluded in world attribute i mentioned in color background ,what i need to do exactly .iam not sure how to do that,i hope someone suggests me good idea.Than

I would like to ask ,if I have four excel file I want at first to compare between two attributes ,Id attribute ,both of them should have the same attribute but some times one excel file has more than another.So ,I would like to check which has more and If first excel file has more than the second excel file so I want to know the new id and extract for each new Id from the third file the data in this row belongs to this id. And at the same time If the second file has more id than first time ,so I would like to extract know which Id is more in second file and add them to first file and extract the data from the fourth excel file .So I want both of excel file ,first and second should be matched in Id and each one extract the missing data from separated file .Because only common between first and second is Id and the rest of data from another two files

Is there a transformer that can easily define transformation parameters for affine transformation. What I do have is set of points with old coordinates and same set of points in new coordinates. Can this be used to compute affine transformation model.

Hi, I am trying to use the DateTimeCalculator on the calculate interval between two datetimes. The results I will get will be negative number as the date will be before the start date.  I am getting all the results rejected. Can the DateTimeCalculator output positive and negative numbers in the results? Looking to use this for stats between two dates and if under and over the target date. Thanks Kevin

Is there a way to apply local generalization? Or some other method to smooth out specific parts of lines without touching everything? I find that the generalizer algorithms are quite hard to understand. Take the example below, I would like to do something about the U-turn, preferably remove it, but the rest of the linework must not be touched. In other places I would like to smooth out 90 degree turns. Still without touching the rest of the linework. Any ideas on how to achieve this?   

In StringReplacer v5, if the 'Replacement Text' is set to % the transformer will only remove the 'Text To Replace' but not replace it with %.The workaround seems to be to enter %% instead of %. That's not the expected behavior I suspect.Have I missed something?Cheers FME 2019.2.2.0 (20200103 - Build 19817 - WIN64)

I'm looking for a way to filter a bunch of areas based on a minimum area. What I'm doing is essentially creating an area of lidar point coverage and comparing it to the AOI boundary. Any areas that have missing coverage get outputted however I would like to filter these outputted areas based on their size. Sometimes some false positive returns happen because of small gaps from no returns off of water. I tried removing these smaller areas using a test filter but I'm pretty sure the area it's looking at is the total area of all missing coverage spots and not each individual area.

It would certainly be useful to be able to CTRL+A all table results in the data preview window. At the moment I can only draw a rectangle around all the map elements or open the Data Inspector.   

Hi, I have two files,  One coordinate-file (measured rock bolts, X,Y,Z)One DWG-file containing theoretical rock tunnel.I would like to create a 3D-model of the rock bolts since i know the lenght of each bolt (3 meters). So, i would like to find the vector of each point the closest way to the surface (perpendicular), and then create a new vertex for each point and draw a line between the points. This would be the result (drawn in paint)