Transformers

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.315024,-76.590231 40.315464,-75.591421

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 put the SQL in one single line without success. I've also set the environment variable ORACLE_HOME without succes (although I'm not 100%

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-16LE) UUIDs into a number? Perhaps I just don&

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.

I have points where each point has 5 points which all share the same geometry and share the one field name but with different values in that field between the records.How do I transpose those different field values down into a single geometry where they intersect, while keeping the field values?

I have a LAS liDAR file that was accidentally saved out in the default coordinate system of ITRF2008 - EPSG:5332 and it needs to be reprojected back to Texas State Plane Central (4203). I have never heard of ITRF2008 - EPSG:5332 and it seems to be a European Projection System. Can anyone tell me how to add this projection to the FME list?

I have to create a workspace that runs a not-predefined number of copy/conversion jobs and at the end send back a REST-call with a json body to signal success or failure.The sending party wants to submit a json structure in the form{  portalid = 4711,  source = 'config',  target = 'qs',  tables = [    'gsm.viertel', 'rgu.abfallanlagen', 'plan.gruen_poly'  ],  raster = [ 'flaechennutzungsplan.tif'  ]}with variable numbers of tables and rasters, and my workspace has to* receive,* parse,* run the tasksand collect the information on the subprocesses.While I know how to submit the single jobs through FMEServerJobSubmitter, I have no idea of how to realise especially the receiving part. When the json request body has arrived in the workspace, I guess the JSONFlattener will be the Transformer to use in order to get at the different parameter, and probably a list exploder to extract the list of tables.Any support, especially a hint where this is described in the documentation, will be greatly 

I create two ploygon,one is IFMEPolygon,the other is IFMEMultiArea (2 Parts). After that, work with the Extruder transformer, but only the the polygon of IFMEPolygon had been extruded, what can i do to help it ?

Hello, I have a network of lines where I wanna detect and aggregate touching lines just as in the case shown below (lines that touches each other at the end or start node) can someone help me with this, please ?thank you

I'm using FME 2018.0.I originally thought this was a problem with the dynamic attribute definition of the writer, but for this test I have used a Manual schema. I don't understand why, but the writer is trying to parse a date that I am not seeing in the inspector. The value for Modified_date in the inspector is: 2011-05-27The response I get from the error is:{    "took": 3,    "errors": true,    "items": [        {            "index": {                "_index": "testing_2",                "_type": "drawings",                "_id": "3mN9KWMBLz2D_kWNISIW",                "status": 400,                "error": {                    "type": "mapper_parsing_exception",                    "reason": "failed to parse [Modified_date]",                    "caused_by": {                        "type": "illegal_field_value_exception",                        "reason": "Cannot parse \"0000/00/00 00:00:00.000\": Value 0 for monthOfYear must be in the range [1,12]"                    }                }

Hi all, I'm not creative enough to think up a way to count, in a single feature, for a subset of 6 specific attributes the number of attributes that contain a missing value.ex: featureID, attA, attB, attC, attD, attE, attF, attG, attH1234567, hi, <missing>, there, 1234, <missing>, friend, <missing>, <missing>count of missing values in (attB-attG) = 3the actual names of the attributes are not so structured, so I cannot use any cleverness there. Can you suggest a wat to achieve this ?Much Obliged !Regards, Ronald van Aalst

Hi TeamI created the complex polygon from utility map(buffered the line geometries and dissolved the buffered polygon). I am able to write to oracle spatial table. able to open in fme viewer. But when i consume this table in arcmap it gives geometry error msg saying that "one or more layers failed to draw".and not rendering in arcmap. the polygon looks like the image in the attachment.Please help.