Transformers

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.

Hi, I am trying to create a multi-line label as a part of mapnik rendering. I use a string concatenator to for a a label (e.g. "top label" + newline + "bottom label" and then I render it along a line/segment. What happens is that label is rendered on the top of line/segment as ONE long label. Somehow, Mapnik doesn't honor my multi-line label representation. I tried it with FME Desktop 2015/2016. What I would like to have:text top---------------------text bottominstead I have, 'text top [square symbol] text bottom' over a segment/line.I appreciate any advice on this issue.Thank you,Alexander

Hi, I'm trying to generate a median line between two groups of features, a mixture of lines and points. The inputs are shape files. In the cases I'm interested in the two groups do not overlap spatially. The resulting median line is a line that, at every position along it, is equidistant from the closest point (or point on a line) of each of the two groups. Has anybody done anything similar?

Hello,I created a new coordinate system + transformation based on a grid .gsb file. While using the Csmapreprojector the transformation fails, can someone help me to figure out the reason ? Thank you very much.Here is the transformation I definedHere is the error I get :CsmapReprojector_8(TeeFactory): CsmapReprojector_8: Reproject: Could not reproject the geometry of the preceding feature: Reprojector: Could not create reprojection engineCsmapReprojector_8: Reproject: Could not reproject the geometry of the preceding feature: Reprojector: Could not create reprojection engine  and here is the Csmapreprojector configuration 

So I am trying to work on a capstone project I am creating and one aspect of it is to figure out what counties all the national parks are in and what percentage of each county does the park take up if it is in it. My thinking is to use the "area on area overlay" and then the "percent overlap". Any ideas or suggestions on how to get this done it would be great. I am just in the initial brain storming and so far my trials in FME have not gotten me what I am trying to achieve. I really just need the percentages the parks are in each county for an appendix for the project I am working on.I dont know if this matters but the files are a shapfile with all US counties and the other is a shapefile with the US Parks in it as polygons.

In my workspace I have a FMEServerJobSubmitter, that submits several tables for processing, and a FMEServerLogFileRetriever that collects the log to be sent through a FMEServerEmailGenerator(the PythonCaller just condenses the log content)My problem is that just the last logfile gets sent, obviously because the log_attribute, in which the retriever copies the content, gets emptied at that stage.How can I collect all log messages to get them sent together when the workspace finishes its work?