Transformers

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?

I create a 3d dataset, and work with the Extruder transformer , after that write to a fbx file, I want to set the "fid" filed to this fbx file, how to set?

I'm new to FME and I need to convert a 3D as-built model in CAD format to shapefile. The as-built model contain 3D solids representing pipelines and cylinders. Any help pointing me to the right direction would be greatly appreciated.

I have a table with many state and county values listed in separate rows. I want to flatten the attributes so that each CessionID has states and counties listed in separate fields. For example, State1 would contain the first state, County1 would contain the list of counties within the State1, then State2 would be the second state, County2 the list of counties in State2 separated by semicolons, and so on. See example in attached spreadsheet.

I use the HTML Extractor in a number of workbenches: it is a very useful transformer. There was a minor glitch in FME 2017 when this was introduced, as it did not handle lists in the customary way: when a list attribute was selected as the required output, I had to use "list{}" as the list attribute name instead of "list". (This did not seem worth raising at the time)  This appears to have been fixed now in FME 2018 but requires modification to transformers created in FME 2017 to reverse the above workaround, otherwise the attribute title is taken as "}" once the list has been exploded or otherwise accessed.  Are there any further details on this issue, or can I assume it has been resolved between 2017 and 2018?

How can I change the email address associated with my Knowledge Centre account?

Has anyone found a transformer or process to convert survey metes and bounds to a geospatial file type (CAD/GIS/KML, etc.)?

Hello,I am trying to use the In operator in the Tester on a comma separated list of strings.In ArcMAP Select by Attributes, I would do this:SELECT * FROM <tablename> WHERE:<attribute name> in ('00002','00003', etc...)When I try this syntax with the Tester, I am getting this error:2018-05-07 16:23:01| 12.7| 0.0|ERROR |Tester(TestFactory): An error was encountered evaluating a TestFactory test: Illegal operator `IN' supplied for test evaluation -- operator must be one of < > <= >= != = ==2018-05-07 16:23:01| 12.7| 0.0|ERROR |An error was encountered evaluating a TestFactory test: Illegal operator `IN' supplied for test evaluation -- operator must be one of < > <= >= != = ==I know that I can limit the values returned by using SQL in the reader, but this method would be preferred.I have tried/tested changing the mode, removing the ( brackets, putting the values in line. No luck. Does the In operator work with the tester?Thanks

Dear FME community,  I have a road dataset with lines that looks like this:VNKNNKVSTBSTLEN102010402005001000102010406008001000 The columns VNK/NNK are just identifiers for the road segment, the columns VST/BST are the measures (in metres) and the in column LEN is the value for the absolute length of one road.  The above table means, that one road segment 1020-1040 is divided into the segment from 200m - 500m (with a value for XYZ), and then from 600m -800m (with a different value for XYZ). The complete road goes from 0-1000 metres.  Problem: I need to fill the "invervalls" with Zero-Values. If the road has the length 1000 metres, then there are no values from 0-200, from 500-600 and from 800-1000. I can calculate the missing values from start (0-200) and the end (800-1000), but how do I get the interim value (500-600)? The could be many intervalls :-)  Goal: The target table should look like this (the bold lines were added):VNKNNKVSTBSTLEN1020104002001000102010402005001000102

FME 207.1.1.1 (17652) on Windows Server 2012 R2 DataCenter.I'm using PointOnAreaOverlayer to add point attributes to polygons which contain the points. It works for 721 out of 754 points, but the other 33 don't get assigned to a polygon. Some of these points are not in a polygon, but others, including the examples shown below are definitely inside a polygon. I have tried de-aggregating the polygon layer first and have also used the GeometryValidator - all tests except the 2 OGC ones - all features pass.Any suggestions apart from trying FME 2018.0?The second example below is actually one polygon. The Deaggregator appears to merge this into a single polygon with the wiggly internal boundary removed. Either way, I would still expect the polygon to pick up the point attributes.

I am writing my first FME transformer using Java Plugin SDK. I am following the CenterOfMassCalculator sample. I have a problem understanding the .fmx file structure though. When I run my transformation in FME Desktop it fails. Specifically, it complains about the arguments of '@JavaCenter' which I copied and pasted from the CenterOfMassCalculator.fmx sample, as I didn't know the purpose of the following code: FACTORY_DEF * TeeFactory   FACTORY_NAME $(XFORMER_NAME)   $(INPUT_LINES)   OUTPUT FEATURE_TYPE $(OUTPUT_OUTPUT_FTYPE)      @JavaCenter($(X_ATTR),$(Y_ATTR),$(Z_ATTR))      $(OUTPUT_OUTPUT_FUNCS)Can anyone suggest some reference on this? The FMEPluginSDK_Java.pdf does not cover this well.