Transformers

Hello,I'm looking to read a feature class from a GDB (for testing purposes, but eventually this will be many feature classes so this process requires minimal manual handling) and add the date on the end YYMMDD and write back into the same GDB.E.G READ - "TEST"WRITE - "TEST190415"I've look at ways of doing this and not many seem to work. The closest I've got is to set the reader to expose the 'fme_basename' -> Date/Time Stamper -> Date/TimeConverter (adding _date column to attributes) -> Attribute Manager where I add a new attribute called "New_name", the value is @Value(fme_basename)@Value(_date)The write is set to Dynamic Schema Definition with the source as the GDB used and the Schema Definition Name set to "New_name". The output is the GDB name. When I edited this to just the _date, the output was the date.So the basename is being read as the gdb, and the date is being picked up in the new attribute. Can someone p

Hi there,I've never had to use the workspace runner before, and I'm kind of lost on how to set it up in the way I need it to function.So currently I have a very simple workspace that is essentially just a SQLCreator and an Excel sheet writer outputting some measurement summaries. My SQL statement connects to a PostGIS database, which contains a list of per-country tables. All these tables are named the same (i.e. "France_full_2019", "Ireland_full_2019") except for the country name.In this workbench I added a plain text parameter in the SQL lines instead of a specific country, so in this way, running the workbench, I can type "France" in the parameter window and get France's data. This all works perfectly fine and as intended, but of course limits me to 1 country at a time...This is where my request comes in:I want to know how to use the workspace runner to somehow input an entire list of countries and have it run the above mentioned workbench f

Dear all,I hope you can help to solve this question. I need to calculate Length ranges and I have as data class and Length. Can you help me please?Class Length Lenght-rangesA-1 100 100A-2 250 (100-250) = 50A-3 300 (250-300) =50B-1 10 10B-2 30 20B-3 80 50C-1 40 40C-2 100 60C-3 200 100

Hi, I'm creating a new feature service in ArcGIS Online and it works great except the writer coordinate system is ignored, I get the default web mercator (3857). Is a particular version of coordinate system required on the features or how do I get the writer one respected? I know my desired CRS is supported by AGOL. Thanks all.

Hi everyone, I would like to get outline polygon of multiple polygons that group by some attribute. Currently, I have used HullAccumulator which works perfectly unless the polygons are not curvy. Any idea how can I get outlines of those two polygons or a curvy polygon in the images?

I have folder that contain multiple shapefiles (polyline, polygon, and point), and I would like just to copy of all polyline and save to a new FGDB, there is a filter could help me, I used geometryfilter and multipleGeometryfilter, but the transformer create one feature class, I would like to get the data separate. thanks in advance

Hi all, I have overlapping polygons and I am using Dissolver to avoid this. However, I would like to keep some attribute from both polygons that are overlapping in case attribute value is different. For example, those polygons have attribute calls "Side" and i would like to have list of these in case of both polygon has different value for it such as Side = W and Side = E but if both attribute Side = W and Side = W. I want to do it because in some cases i have 6 polygons are overlapping and if i generate a list regardless from the values of those attributes, I am having very long attribute list. Thanks in advance. Best

Hello. I have a shapefile, in that, I have added some fields which are populated with error remarks. Now I want it to be pivoted with the error wise count. please see the image attached.

Hello,The BulkAttributeRenamer in FME 2019.0 build 19238 seems to have some issues. For example,Regular Expression Replace: Backreferences (back slash and number) won't be replaced with the referenced sub-string.Attribute Name containing Multibyte Characters: The attribute value won't be assinged to the renamed attribute.See also the attached workspace: Workbench interface looks fine, but... the result is wrong.In the example above, the resulting feature should have these attributes.NameValueTEAM12345prefix_?a?_sufixb

I'm trying to intersect a line with several hundred polygons the problem I'm having is there are several polygons that overlap each other, so when I run the lines and polygons through the clipper I end up with some incomplete segments. Pictured is an example where the overlapping polygon got the start of the line segment thus not a complete line for the red selected polygon. I've tried a bunch of different transformers and end up with the same result or worse result no matter what. Update: the help mentions intersector for my situation but I can't figure out how to get at the result I need still.

I am creating an XMLtemplate that loops through all the id\\value pairs in a list and creates an XMLelement for each. I got the looping working after reading through some of @takashi's post replys, but the $i variable is not getting passed correctly into the fme:get-attribute function on the list number. Am I going about this wrong? Is there a different way that I need to call the variable inside the function? <update_transaction object="ObjectNameHere">{for $i in (1 to xs:integer({fme:get-attribute("_Result_count")}))return (<attribute_value name="{fme:get-attribute("Inspection.Results.Result{$i}.id")}">{fme:get-attribute("Inspection.Results.Result{$i}.Value")}</attribute_value>)}</update_transaction>  

Hello, I am trying to interpolate a raster surface from 3D points in FME like the Trend tool makes in ArcGIS but I couldn't find any tool like it. ArcGIS Trend tool definition: Interpolates a raster surface from points using a trend technique.  Is there anything similar? Thank you 

Hi everyone,I'm quite new to this community so I apologize in advance if I make some mistake in the introduction of my question.I have a column with building names (dromore lodge, killowen house, church of jesus etc.) and I want to use PythonCaller to capitalize each word except some of them like the articles (a, an, in, of...). I've tried this simple code with poor results :import fmeimport fmeobjectsimport re def processFeature(feature):    str=feature.getAttribute('BUILDING_NAME')    exceptions = ['a', 'an', 'of', 'the', 'is']        for word in re.split(' ',str):        if word not in exceptions:            word = word.capitalize()        feature.setAttribute("B_NameCap", word)     passWhat I have as a result is the last word capitalize as I want (Lodge, House etc.) in the column I've created (B_NameCap). I understand Python is giving me the last result overwriting the first one in the list.I've tried to .append a new variable with the capitalized data and .join the data anew to no

Hi there,I wonder anyone can help me on my query. I have a Point dataset and a Polygon Dataset they on ESRI file Geodatabase format.I have over 700 circles and 7million PointsPoint Data contain Premise Count , so I will require to sum up all Premises by each Circle and assign that number to each circle, including overlappingI have used Spatial Relater/Spatial Filter/Clipper none of them give me the correct answer. Let me know if this can be done using FME .  thanks,Regards,Pushpa

Hi,I'm trying to create Index on attributes for a feature class inside FGDB. I'm using SQL to run after write option available in Feature writer. But i'm getting invalid sql statement. But it works fine when I tested in sql developer. Below is the sql, FME_SQL_DELIMITER ;DECLARE strColumnNames VARCHAR(200); P_COLUMN_NAME VARCHAR(200); strStatement VARCHAR(2000); P_INDEX_NAME VARCHAR(200); P_TABLE_NAME VARCHAR(200); ind NUMBER; indexCount NUMBER;BEGIN strColumnNames := '@Value(idx)'; P_TABLE_NAME:= '@Value(processname)_WM'; ind := instr(strColumnNames,','); indexCount:= 1; WHILE ind > 0 LOOP P_COLUMN_NAME := SUBSTR(strColumnNames,1,ind-1); P_INDEX_NAME:= P_COLUMN_NAME || '_' || indexCount; strStatement := 'CREATE INDEX ' || P_INDEX_NAME || ' ON ' || P_TABLE_NAME || '(' || P_COLUMN_NAME || ')'; dbms_output.put_line('Statement is : ' || strStatem

Hello, I'm having issues when trying to get the BulkAttributeRenamer to perform the following: I need trim all attribute names down to only 10 characters in length. When I set the Parameters for Action: to Regular Expression Replace and use this regular expression:^.{10} I'm able to match all the first 10 characters, but I actually don't need to replace these, I just want to use the matches to become the new attribute name. Am I going about this the wrong way with a regular expression? Any help is greatly appreciated.  Example:Old Attribute Name ----> AREA_IMP_TEAMNew Attribute Name ----> AREA_IMPL_ 

Hi, I am having a litlle trouble on labeling the road network using mapnikrasterizer.I am looking for some advise on this matter.So I am creating a tilled map for UK on a large scale, unfortunately I am not being able to label the road network, I have tried a lot of parameters, but I haven't reached my goal so far. please see the image bellow, as you can see the roads doesn't have labels at all. the image bellow show the parameters, used for labeling please let me know if you have any idea on how to manage this thanks for your help

I have a dwg circa 1998 that contains among other things contours and spot elevations. All of these features exis in 3d within the dwg I have confirmed this using AutoCAD viewer as well as the FME inspector. The only place I see the elevation value is in the coordinates section in FME Inspector. I would like to covert these features to a shapefile and capture the elevation as an attribute but don't know how to expose this elevation value. 

Hello everyone, I have a street centerline dataset and I would like to identifying where there are T intersection (3 centerlines intersect at same point). Here is the image and I would like to find the highlighted lines. Thanks in advance. Best,

please see below the json response from a httpcaller transformer.  I want to extract the items (only id and type attributes are interested) and format them to new fme features with 2 separate fields id and type. I have tried JSONFragmenter (setting like below). However the output gives me a flat table with 704 records (352*2) like below. How to output a table of 352 records with two fields id and type?{"total": 352,"start": 1,"num": 352,"nextStart": -1,"items": [{"id": "5c6729ea37f84ffbb9ece1f428d83bf4","owner": "Admin","created": 1425413285228,"modified": 1547658596161,"guid": null,"name": null,"title": "World Population Density","type": "Map Service","typeKeywords": [6 items],"description": "","tags": [5 items],"snippet": "World Population Density data service provided by ESRI","thumbnail": "thumbnail/World_Populations.PNG","documentation": null,"extent": [2 items], 

I'm new to FME. Just upgraded to FME2019 and since then seems that stability issues have multiplied. Workbenches that worked fine, not crash in the middle of the process. Most of the issues seem to be related with temp files. Provably FME is trying to go through temp files stored in the previous version? Are there any recommendations you would make in order to prevent these errors from happening? Maybe making a clean-up of FME temp files?

Hello,I have an external code in PythonCaller that generates a segment_id for each feature. and I would like to understand what it is doing exactly and what does the  if (feat_i*self.sampinv) % self.count==0.0 expression mean. It looks likedef close(self):             group=0        for feat_i in range(len(self.feat_list)):            if (feat_i*self.sampinv) % self.count==0.0:                group+=1            self.feat_list[feat_i].setAttribute('segment_id',group)            self.pyoutput(self.feat_list[feat_i])

Hi all,I'm quite new with FME, so I hope you can help me. I would like to change the value of multiple rasters. I know you can do that for one raster, but I have a lot of rasters (>200). Is there a way to this?I'm using FME desktop 2018.1.Many thanks in advance.Kees

Hello, I'm using sampler to reduce the output. If some parameters are set then I want to only read n rows and then move on with processing without reading all the rest. I know that in feature reader there is option to set: max features to read but then I perorm some polygon filtering so there is a chance that if i set it to 1000 then 0 features will be stored because none is inside filter polygon. Sampler works great but problem with it is that after sampling first n records it still keeps on reading new features but it forwards it to notSampled port.  So is there any option that would stop reading more features after reaching given number?

Hi, I'm trying to expose attributes from a JSON file using JSONFragmenter and it's working perfectly fine for all attributes except one which is stored in [] brackets. This is an example of how the JSON is structured:  [{"id":"5cad42","nummer:"697582","name":"place name","position":[51.51146259999999,11.5696619],"status":false}]  And once I have exposed the attributes I see all values except "position" value is missing, so I assume it has something to do with the [] brackets.  These are the JSONFragmenter Parameters:  Should something be changed here? I know it must be easy :) Thank you! Cheers,Linda