Transformers

Hi, I would like to convert a dataset with GPS tracking points to routes using the the LineBuilder transformer. My challenge is that I want to create separate routes based on break values/attributes. Each route start with zero (value) and ends with one (value). Based on break values/attributes I would like to add an unique routeID to each route (collection of points) and use this as connection break attribute in the LineBuilder. See attached example of attribute table.Any idea how to acomplish this?Thanks in advance,Morten

When I use the RasterCellCoercer within a workspace in FME desktop, it works fine. But when I run the same workspace in FME Server, it returns the polygons in the wrong order it seems.See example1 image, the blue polygons should be on the same position as the raster, but they aren't.Does anyone has any idea what the solutions could be?

Hi all,I want to use FuzzyStringComparer but I'm wandering is it possible to force it to rate sth like this higher? eg. Pizzeria Saracino <-> Saracino Pizzeria => 0.47So the words are correct but the order is wrong, and I need to know if the name is basically the same. In this case it is the same for me. Is there possibility to configure this transformer to check words in string separately? Thanks in advance!

Hi all,We've just upgraded to 2018.0.0.2 from 2017.1.x and a workbench that used to run in about 5 minutes is now running at 1 record per second and I have 62,000 records to process. The bottleneck appears to an AttributeValueMapper with 140 lookup values. The FileGDB and AttributeRemover read all 62,000 records in next to no time and then they hit the AVM and everything slows right down.We've tried a FeatureWriter (to CSV with DuplicateRemover) to get a file of unique values and updated this with the new mapped values and then used a DatabaseJoiner but that is still slow at 2 features per second.Any suggestions on how to speed things up?The workbench takes a FileGDB table and uses DatabaseJoiners to join two more FileGDB tables (with a common key field in each one) to build one output table in PostgreSQL with selected fields from each table.ThanksRoss

Hello, I need to transform my DWG to SHP. I have one layer that contains 2 types of elements, block reference and polyline, how can i get 2 shp files, one point shape with block reference elements and one line shape with polyline elements? All attributes must be kept in attribute list of shape files.

I'm evaluating FME Workbench for our company GIS ETL processes. It doesn't look like the SQL reader supports stored procedure data sources. Is this correct?I can work around it by using a view as source and a filter string on the reader but want to know if there's a way to use the stored procedure directly.Thanks.

Hello, I am new to FME and would like to try and obtain geotagged Flickr / Instagram posts based on specific search criteria, e.g. keywords and coordinates. This is for a conservation project. Using Yosemite National Park as an example, I would like to search for images within a 10 mile radius of Yosemite (37.8651N, 119.5383W) with the option of filtering out posts based on the keyword “black bear” and then place those queried results on a map. I have had some success using the TweetSearcher Parameters transformer for aggregating Twitter posts, but am wondering how and if this could be applied to Flickr and Instagram to reveal posts and images. From what I gather I should use the httpcaller to talk with the api, but any ideas on how to create a search query? Is such a thing possible? Thanks so much for your help. Charlie

Hi, I am not able to upload my transformers created with FME Desktop 2016 to FME hub. I tried two of them and here are the error messages:Category 'Geometric Operators' is deprecatedCategory 'Linear Referencing' is deprecatedIs there a list of current valid categories?Thanks in advance.

Hi all,I want to compare line data for change detection in attributes and in geometry. I prefer the UpdateDetector transformer but in outputs I do not get separated the changes in attributes and the changes in geometry. These are mixed in the output. For example, in the Insert output, I’ ve got insert new data and attribute changes. Do you have any idea how can I do that?Thanks a lot for your time and helpNoni

I have created a custom coordinate system using the online FME tool. I have downloaded the files and placed them in C:\\Program Files\\FME\\Reproject per the instructions, I have defined a shared path in the Default Paths. How do I get FME to recognize the custom coordinate file?

I have a polygon in a large text field (below) which should be in WKT format. I need a way to convert that WKT to a Polygon with error handling for unsupported polygons. I tried geometryextractor, but all 100 sample records failed with "INVALID_GEOMETRY_VERTICES". Here's the example of the WKT from the database: POLYGON (( -76.581093 39.315575,-76.581776 39.315554,-76.581631 40.313857,-76.581347 40.314542,-75.582766 39.314861,-75.582726 40.313963,-75.583088 39.315309,-76.582269 40.314383,-76.583239 39.315550,-76.582827 39.315085,-75.585164 39.315707,-76.584283 39.315503,-75.585379 39.315321,-76.584517 40.313984,-75.586260 39.315786,-76.585689 39.315684,-76.585819 39.315475,-75.586589 40.314790,-75.586844 39.316014,-75.587591 39.315511,-75.588035 40.314793,-75.587795 40.315077,-75.588154 40.315657,-76.587613 39.315782,-75.588892 40.315519,-75.589434 39.316231,-75.589486 39.316014,-75.589911 39.317039,-75.591006 39.316106,-76.589366 40.

Hello everybody.I would like to calculate the shortest path between two points and I found this transformer : ShortestPathFinder Is it the best way for do that in FME ?Thank you.

I'm trying to set up some conditional reprojections in a workspace using the reprojector and conditional values for the destination coordinate system.I'm using a published parameter in the workspace to select different regions around the world and run some processes on features in these regions.When I try to use the values from the published parameters to conditionally set the destination coordinate system, FME fails to evaluate the input expression and the the translation fails.The error message:Reprojector_2: Reprojector_2: Failed to evaluate input expression: FME_CONDITIONAL:DEFAULT_VALUE'Mercator_World_KM'BOOL_OP;OR;COMPOSITE_TEST;<Unused>;TESTNorth America=North America'NA-ED-CONIC83_40_FME'FME_NUM_CONDITIONS2___ Program Terminating Translation FAILED. What am I doing wrong? Is there a better way to setup conditional reprojections?  Thanks for any help.

Hi,I need to update a specific value in an Oracle database. However, I'm running into trouble when trying to execute an SQL Update statement using the SQLExecutor. The very same statement works like a charm when executed in SQLDeveloper. The statement :FME_SQL_DELIMITER ;update table_a set valeur = 'New_Value' where id in (select av.idfrom table_a av join other a on a.id = av.idother and a.libelle = 'PARTNER A' join table_p p on p.id = av.idproject and p.CODE = 'xxx' ); When I execute this from FME, he connects to Oracle, but never finishes. The log get stuck at this moment :Oracle database version is '11.2.0.1.0'Environment variable ORACLE_HOME is not set.Connecting to ORACLE database `ORCL' with user name of `TESTL' and password of `***'Connected to ORACLE database `ORCL'I've tried to pu

Why replace 1 button with 2 new ones that do the same thing?

I would like to know if there is the possibility of accessing WSDL files through the SOAP protocol (same form of access of SoapUI) as reading via FME. If so, could an example be provided. Thank´s

how should I do if I want to pick out the userID with 1 row only. For example USerID Long Lat Count  001 1 1 20  001 2 2 1  002 3 3 5  003 4 4 20  003 5 5 6  004 6 6 9  I need to pick out the userID 002 and 004 and keep all attributes

Hi, I have a dataset of point like thisUserID Long Lat Total_count001 1 1 13001 2 2 1002 3 3 20002 4 4 2003 5 5 30 003 6 6 5.....How can I pick only the user with maximum total count and keep the long/lat attributes in the output?

I have been running spatialfilter transformers on polygons from a grid feature class (G) to see which of them intersect polygons from another feature class (A). I am extracting the polygons from G that intersect A and applying the attributes from intersecting A polygons to their corresponding G polygons. Unfortunately some polygons from A intersect other, different polygons from A and the problem is I need to extract the G polygons for each intersection that is found between A and G. Essentially I need to extract duplicate G polygons for each intersection with different polygons from A and apply attributes from A to their corresponding duplicate. I really hope I was clear enough for someone out there to understand my issue. Thank you for your help in advance.

I have two uniqueidentifiers:4F23402A-BBCD-498E-9136-C0C06F20AB574DE5DCD8-5D50-4272-B9DC-6D3997CC2F47When both are set to UTF-8 encoding and run through a FeatureJoiner on Automatic comparison mode, they do not join - as they shouldn't.However, when both UUIDs are set to UTF-16LE (which is how they appear in FME if they were read in from SQL Server) and run through a FeatureJoiner on Automatic comparison mode, they DO join. The same behavior occurs when set to Numeric mode. When set to String mode, obviously they do not join.This behavior appears to be inconsistent with the FeatureMerger. With the FeatureMerger, these two UUIDs never join, regardless of comparison mode and UTF-8/UTF-16LE encoding.So my questions: Is this the intended behavior of the FeatureJoiner? Why does FeatureJoiner's attempt to convert (UTF-16LE) UUIDs into a number appear to have a different result than when the FeatureMerger attempts to convert the same (UTF-1

Hello, I am attempting to use the ODATA READER. I can use my odata link other places including HTTPCaller in FME. I did notice under constraints, there is an item called "FEED LIST". I don't see this documented anywhere though.Here is my error message.Failed to obtain any schemas from reader 'ODATA' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFME Session Duration: 2.6 seconds. (CPU: 0.9s user, 1.6s system)END - ProcessID: 15140, peak process memory usage: 88308 kB, current process memory usage: 88308 kB

Hello Community, I have a 2D line that was converted to 3D (solid). I need to 3D line (solid) to slope upwards or downward. Any suggestion(s) on how to do that ? I try the 3D interpolator, but it does not do anything. Thank you, David

Is there any reason that FME would not cast a value to an integer using xs:int(value)?i keep getting:"xs:string": invalid value for cast/constructor: can not cast to "xs:int"the incoming value is a 12 digit number from a GML file with type: xml_int64i try it without the cast and the JSONTemplator works but it comes out as a string when i need it as an integer.

HiI want to edit a few thousand attributes, basically adding a number of 0's in the middle and end of a string. For example I want 2017_420590 to become 2017_420000_590000.I think I may have to use the StringFormatter to edit the string use regexpr, I am not experienced using regexpr however.Thanks for any help in advance.B

I am trying to configure a means of converting a string such as 6.0.2 to a number 602 so that I can run it through a statistics calculator to get the Max. There may be only one entry, such as 6.0.2 or multiple entries such as 4.4.0, 6.0.0, 6.0.1 and 6.0.2. From either example I want to keep 602 and pass that as the Max attribute. That attribute is then tested to see if it is greater than or equal to 440. I am attaching pictures of my string replacer and statistics calculator. I have looked at a previous question "Converting Sting to Number" and tried some of those suggestions, even added a string formatter but still get an empty Max attribute.