Transformers

Hi, I am looking a transformer that could work like the XY to line tool in ArcGIS. For each spot I have a beginning lat/long and an ending lat/long on the same row. I would like to connect the lat/longs on each row as a line and then move to the next row as a new line feature. I have tried pointconnector which works great for sequential rows but I have not been able to get it to work in this manner. Thanks.

Hi I'm trying to use the anchored snapper to snap polygon boundaries to cadastral lines. However, it only seems to snap the vertices of the canditates and doesn't create extra vertices in between to make the polygon boundary align to the cadastral. Is there a way to force it to create additional vertices where necessary?

We have a number of AutoCAD files that contain geographic information through a Geographic Marker placed in the file. The geographic marker contains enough information to project the XY data into latitude and longitude, but I cannot work out how to access the XY position of the marker, nor the rotation of the XY axis from North (these are embedded in the AutoCAD file). Any help describing how I can reproject the AutoCAD files to lat long (for output to GeoJSON eventually) is greatly appreciated. Thanks!

Hi does anyone know how to use RegEx to extract a URL from a tweet example have this: #Birminghamfloods This is Aston at 5pm https://t.co/XDDVtexNdT need to extract this into a new field - https://t.co/XDDVtexNdT

Hi, I am trying to figure out how to insert disclaimers/metadata from one folder to all zipped folders within another folder? My setup involves Reading from an SDE connection, an InlineQuerier transformer to definition query various private data fields out of the data, an Attribute Keeper transformer to keep only the pertinent fields for public viewing before 6 different writers take the data and convert and zip to file geodatabase, kml, shapefile, AutoCAD, CSV, and GeoPackage. With each feature class/dataset being converted into 6 different formats into a single export folder. The naming convention will be standardized (Parks_KML.zip, Addresses_shp.zip, Water_FGDB.zip etc), I need to insert a text disclaimer file into each of the zipped folders. I thought using the FileCopy Writer from this example (https://knowledge.safe.com/articles/881/including-additional-files-in-the-data-download-re.html)with a wildcard fanout of the export folder but I am unable to make that work. Thanks! @taka

The question is: Which areas have more than two points in it. So I want to make a selection of points in a lot of area.. Visualize if there are more than one point in a polygon (a lot off points and polygons)

Hi all, Is there a way to trigger a topic if a job is cancelled or just send a email? I have a script running in on a schedule with a Running Job Expiry Time. Sometimes my job exceeds this time and is cancelled, but that does not result in a failure (or success). Thanks in advance

Hey! I've been troubleshooting an issue with FME for a couple of days and I thought I would reach out to y'all to see if anyone has any insight into the problem. Our office publishes lobbyists datasets to a socrata data portal from tables in an oracle database. We use FME workbench to push the data from oracle to the data portal. The problem is, all of the dates are displayed as one day behind the correct date in oracle. The dates in oracle are stored as a Date/Time value and I've fiddled with the date formatter in FME, but no such luck on resolving the issue. I noticed that the dates in the data portal are stored as Date/Time (with timezones), so I have a theory that the issue has to do with timezones, but I can’t figure out to switch the socrata column’s data type to Date/Time in FME. Does anyone have a suggestions or advice? Thanks!

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 please rsvp.

Hi I 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 space Using 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 failed java.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 ? Thanks Daniel

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 changes Thanks.