Transformers

I have a complex geometry which contains one vertex that I want to remove.The 'offending' vertex is in the first element, the PolylineGeometry(35):The vertext I want to remove:I tried using something like @takashi suggested in my previous post, but obviously the arcs were lost.I would like to ONLY remove that one point (and similarly in other complex polygons) and have the rest of the geometry unchanged. I'm an FME neophyte, so is there a way to do that?Thanks for any help!

hi everyone ? have polygons and point cloud. ? use Clipper after that ? change point cloud z data ? need this math fonction (( all point cloud z value - polygon z value)) can you help me pleasersvp.

HiI am creating a table using the HTML Report Generator. I have some hyperlinks in my table and the report generator replaces these and it doesnt display correctly in the email that finally gets sent out.I am using the StringPairReplacer to sort out the < > and & but I am stuck with "Using this: < < > > & & " """Doesnt work:StringPairReplacer: @Tcl2 -- failed to evaluate expression `StringPairReplacer_replace' -- list element in quotes followed by """ instead of spaceUsing this: < < > > & & " "Doesnt work either.What is the best way to go about replacing " with "Many Thanks as always,Oliver

Hi,I have an FME script that gives java errors (FME desktop 2018.1.0.1 on Windows) : java.lang.Error: IP Helper Library GetIfTable function failedjava.lang.NoClassDefFoundError: Could not initialize class javax.crypto.JceSecurityManager The translation finishes successfully, but I would like to avoid these errors. I tried to reinstall Java, but with no success. Any idea ? ThanksDaniel

I have two data stream, both have count attribute. I would like to compare the count_1 and count_2, if the count_1 > count_2 the set attributes by count_1 go ahead...if count_2 > count_1 the set attributes by count_2 go ahead.Thank´s

Hi. I got this problem while converting my IFC model to gdb (geodatabase folder). My model is quite complex which consist of the Architecture model. When I try to convert it to gdb, there are only some features that are successfully convert. Others features with "Encountered 3D Geometry missing appearance information. Geometry will be written without textures" warning is not converted to gdb. I actually need that texture to be in my geodatabase model. Can anyone help and guide me to solve this problem? Im a new user of FME.

Hello All,Problem:I have a csv that has 2 sets of UTM coordinates (Eastings,Northings) for each location. I would like to compare the length of the values and choose the set that has the most precision (most number of decimal places) and then write that pair to new columns. I am using the StringLengthCalculator to create and populate a field for each Easting and Northing. Eg: 1EastingLen, 1NorthingLen, 2EastingLen, 2NorthingLen.I'm getting stuck on how to use a TestFilter to write one of the pairs based on some logic.If I were to pseudo code what I want, it would sound like this:For all records in csv:If 1EastingLen >= 10, then write 1Easting to new Easting Colum AND write 1Northing to new Northing column.Else write 2Easting to new Easting etc....All help is appreciated.Thanks.

I'm getting the most current readings for streams via an xml table provided by http link. I want to make 2 tables of the readings: 1-with the most current readings and one with the history or previous days readings. What I have so far set-up in FME does the job but I cant seem to seperate "history" from "current". Also I need the time format to stay in UTC-GMT in the AttributeCreator_2 (see screenshots). I'm trying to make a live feed map in arcpro of the sensor readings so any help would be appreciated as I am totally new to FME ANYTHING!Thanks!

Hi,Bit of on odd one i cannot work out. I have some tabular data e.g.203040325The headers are 20,30,40 with values 3,2,5.Is there a simple oway to end up with20304020,20,2030,3040,40,40,40,40Thanks

Hi, I have a Schema Source and Destination in a database and the Feature Type names contain the Table Qualifier (e.g. <prefix>.<table_name>). One one side it is dbo. on the other it is tab.I tried to follow the guide https://knowledge.safe.com/articles/1156/dynamic-workflow-tutorial-destination-schema-is-de-3.html but with this same data source you can remove the prefix as an option. With SQL Server it doesnt appear to be possible. How do you get round this?Many Thanks,Oliver 

Hello, My name is Fred from the Netherlands and i have a problem creating lines from attribute values. I hope somebody can help me!In the attached file beschoeiing.xlsx you can see the RD-coordinates (dutch EPSG:28992) of line objects in 3 different columns:Option 1: rds coordinaten X- and Y-coordinate cobined in one feature Option 2.1: rds X: only X-coordinate in a feature Option 2.2: rds Y: only Y-coordinate in a feature (use option 1 or combine option 2.1 and 2.2)I want to create line objects from this data. I think i have to loop through the coordinates, but i do not know how to do that. After looping i need to make geometry (lines). I want the features "naam", "nummer" and "object id" from the excel file attached to the line-geometry.Can somebody help me please?Kind regards, Fred PS1: (i'm not completely new to FME, but i'm not (yet) a super-user) PS2: i hope you understand my english ;-)

I have compiled a workbench which writes to a multi page PDF. It groups objects by 'page number' derived from a Group_id (using count) after the PDFPage Formatter. My problem is: I have other objects (standard text/logo) which I need to write to every page. How do I get other objects to appear on every page?

Instead of splitting a line by distance or specific vertex indexes, I want to split lines whenever the angle to the next segment is not within x degrees.  Any ideas on how to accomplish this?

I'm looking for a way to find linesegments in a network behind a selected segment. In this case the red line is the selected segment.The result is the line marked with 2-45.9. In this case resulting in 1 line but there can be more segments. My question is similar with this issue: https://knowledge.safe.com/questions/56654/analyzing-water-network-connectivity.html Does anyone have an example with the NetworkFlowOrientor?Thanks.

Hi, I have a problem that I can't seem to wrap my head around maybe because it's monday or maybe it really is difficult?  I have a series of "events" (5000+) with random timestamps. I want to count how many events between every whole hour.  20180101010000  20180101011854  20180101013542  20180101015233 Count = 3  20180101020000  20180101021854  20180101024705 Count = 2   I want the resulting table to be like this Time Count 20180101010000 3 20180101020000 2 Thanks!  /Jacob   

Hi, Is there a way of being able to replicate excel's sumifs/Averageifs functions in FME?I have two tables, the first table has unique ID's and the second table contains data which I need to aggregate. Is there a transformer where I can use the unique values in table 1 to match against the data in table 2 to perform a Sumifs?Thanks in advance.

After geolocate in my SketchUp 2017 when I am trying to convert SketchUp file into GML file with epsg 24370 crs it cannot properly convert bounds that's why I lost my location I almost try with every crs of my country I usually face this problem. Please have a look at my fme skp to gml conversition file and direct me for further changesThanks.

Hi,I have a image folder (.TIF) which the structure MODIS_2017001.tif, MODIS_2017009.tif, MODIS_2017017.tif,...My target want to convert julian calender to YYYYMMDD.For example : MODIS_2017001 -> MODIS_20170101; MODIS_2017009 -> MODIS_20170109; MODIS_2017017 -> MODIS_20170117Could you tell me how to the way to make it?Thank you

I am trying to copy the data from our staging database to our production, but it hanging at this stage forever (more than 12 hours now). 35.9| 0.1|INFORM|Geodatabase Writer: Truncating table/feature class `GEODBMGR.Assess_Parcels'I don't see any error message. It used to work. This is first time I run it after I clicked the 'Update writer'. I don't know if that has anything to do with this.Thank you in advance for any of your help!

My goal is to create a JSON file that matches the following template. I've been struggling getting the coordinates in the linestring geometry property properly formatted. Note the addition of the "tippecanoe" property.{    "type" : "Feature",    "tippecanoe" : { "maxzoom" : 9, "minzoom" : 4 },    "properties" : { "FULLNAME" : "N Vasco Rd" },    "geometry" : {        "type" : "LineString",        "coordinates" : [ [ -121.733350, 37.767671 ], [ -121.733600, 37.767483 ], [ -121.733131, 37.766952 ] ]    }}Things I tried:Basic geojson writer - Writes the maxoom/minzoom property under "properties" instead of "tippecanoe".JSONTemplater - concat('[[',geom:get-points('xy', ', ', '],['),']]')This method works, but feels hackish; it adds quotation marks (") which I remove later. geom:get-text-data(geom:get-name())The second method returns null values. I give the geometry a name with the GeometryPropertySetter, but still returns a null value. If someone can post a working example, I can go from th

I'm writing line and polygon data to an OSGB-file and need color info to be preserved and written correctly. At the moment I can't seem to get a written file with color data in it. Everything else however works and is represented as expected. Am I missing something in order to get the writer to write color data? As textures and diffuse color values are supported according to the quick facts page I figured that simple color values would be as well, but maybe this isn't the case?

We have a new server (windows server 2016) on which we have installed FME2018. Before that, we had FME2016 installed on a server with an older operating system (WindowsServer 2007). On the old server, the names of the open workbenches and whether they were runnig were displayed in the taskbar, which was very handy. But now on the new server, only FME symbols are displayed and I have to do something to get to those informations. I guess this is rather a windows than a FME2018 issue, but is there a possibility to display the name and the running-status of the open workbenches?Thanks, Vera

Hi,I am writing out to KML using a FeatureWriter from a File Geodatabase and want to set the geometry of the polygons to not tessellate (default is for tessellation).I have found the geometry tag but I am unable to figure out how to insert it into the workflow. I need to optimize a large dataset in google earth for less than ideal computers.Thanks!

Hi,I'm trying to create a shortest path from point A to B, yet FME is not outputting any path. I've looked at similar questions asked on here, and I've adapted my workbench accordinly, but still no luck.I'm using an OpenStreetMap highway layer as input. I've explicitely set my snapping tolerance as relatively high in the shortespathfinder, just so that I could just get some output. But it didn't work either.Printscreen of my workbench: 

I am really a neophyte at SQL so could use some help. I have 2 tables, my primary data is a dgn file and the table to update from is an Excel spreadsheet.dgn file: excel:I want to join the excel to the dgn file when the first 12 characters of igds_level_name contains the NameCode in the Excel file. I will then update the dgn.Category from the excel.Category. My output should only be the dgn file.The last attempt at making this work:SELECT * FROM Output    LEFT JOIN "US36_dgn_Categories00" ON (SUBSTR("igds_level_name",1,12) LIKE "US36_dgn_Categories00"."NameCode")    SET "Output"."Category" = "US36_dgn_Categories00"."Category"