Transformers

I am trying to create multiple 'masks' at once.I have a shapefile with a lot of small zones, and a shapefile with one large region. I would like to create a shapefile with as many features as the number of small zones, each feature holding the geometry of the large region with 1 of the small zones cut out.In short: I would like to create a shapefile that can server as a mask for all of these smaller regions individually. It is meant to be used for Data Driven Pages printing purposes in ArcGIS.My attempts with the Clipper transformer were not succesfull so far: when clipping all the small zones out of the large region, at the 'outside' port only one feature emerges: the large region with all of the small zones cut out at once.

Hi There,I am new ini FME. I have the latest version.I used the DISSOLVER transformer to dissolve the polygon and the generate list functionality to get the list of all the blocks have been dissolved by the group field. The result is I can see the POLYGONS dissolved but I don't think I am generating any list of these polygons. Also how to get the count of how many polygons have been dissolved by the group field?Thanks for your help

Hello FME masters,I have a set of housenumbers I'd like to update. I'm trying RegEx but not getting the result I want.What it boils down to:HaveWant1-A1A22-2422First example: I'd like to clean out the dashes but keep the letter following the dash. Second example: Clean out the dash and any digits following it. How can I do this in the StringReplacer?Thanks, Ed

Hi,I have many polygons in my file, that have these random lines which are preventing me from processing the polygon further. I was able to identify which polygons have the issue using the geometry validator, but I don't know how to fix the issue.Attached is a screenshot and a sample data.Anyone experienced the same problem and know how to resolve it?Thank you!

The question is pretty self-explanatory, there is a select by location option in ArcMap that allows you to select polygons from a dataset that have their centroid in polygons from ANOTHER DATASET. I think one would need to use the CenterPointReplacer transformer to create centroids of the polygon and select the centroids that are within the other polygon then join (DatabaseJoiner?) the selection back to the original polygon but I would like to know if there is an easier way.

Howdy!Seems like this is an easy one but I couldn't find where this solution might be found in the Knowledge Base... my brains just not clicking today!My Goal: Use the max value output from StatisticsCalculator, add one to get the next sequential value, use that value as the start value for a new Counter transformer. Background: Early in my FME workflow I use the Counter to tag each street intersection point feature/record with a unique ID, this gets stored in a field named "FME_CountID". Later in the workflow, I need to add new street intersection point features/records to those earlier records. Issue to resolve: For those new intersection point records I need to pick up the existing FME_CountID record numbering where it left off.   Thank you in advance!

I have a small mystery, hopefully someone can help me with it.I have several points (53) that I clip with a polygon shapefile. Some points (51) are inside the polygon, others (2) are outside. In the FME workflow I also see the correct number of features being sent to the shapefile. The data inspector also shows 51 points. But in the actual exported shapefile and .dbf file, I only find 47 points.I am not using the group feature or anything, and the points all have a unique ID code. Picture 1 shows what I see in FME workbench, picture 2 what data inspector shows me, picture 3 what QGIS reports/FME Data Inspector showsThe file is not open in another app or whatever. When I export to say GEOJSON, I do get the correct 51 points.What am I missing? Is there a bug when exporting to shapefile? Running FME 2018 build 18284-18301-18305

Has anyone had experience with the TransXchange transport information format used in the UK ?I'm unable to get the xml reader in Workbench to read/ translate the data into another format (i want to import into a GIS)This is the schema:ttp://www.transxchange.org.uk/schema/2.4/TransXChange_general.xsd and the following the error message Opening the XML reader with source dataset 'F:\\FME_processing_data\\Carto_jobs\\TravelineCymru\\NewAdventureTravel63-Brecon-Sennybridge-Ystradgynlais2_TXC_2016510-0220_PWAO063.xml'The uri-map document 'C:\\Program Files\\FME2017\\xml\\urimap\\gml_aixm.xml' is being used to map from URI to URIThe uri-map document 'C:\\Program Files\\FME2017\\xml\\urimap\\gml_citygml.xml' is being used to map from URI to URIThe uri-map document 'C:\\Program Files\\FME2017\\xml\\urimap\\gml_inspire.xml' is being used to map from URI to URIThe uri-map document 'C:\\Program Files\\FME2017\\xml\\urimap\\gml_urimap.xml' is being used

I am reading table name and attribute values from text file. I do not have column names but only table name and values in the list.I would like to insert the values into SQL Server table. How do I map list to destination table schema. The order of column values match with table structure. Following is the example of text file row.I~6000000~PDEN ~A058951~PI~PI~DEHYDRATOR~~261384~~~B&C; COMPRESSOR STATION~802103~~~~~~~~~~~~A~~A~USA~17~027~~61~022033~~~~~~20171001~~~~~~~~N~~~~CONGRESS_PRD~~3~~~~~~~~~~~~~~~~G~LA~~L~~~~~~~~~~~~~~~~~~~~'I' is the transaction type.6000000 is table idPDEN is the table name.Rest of them are Attribute Values.Text file can contain values for multiple tables and it can have update or deletes also.For now I am trying to find a solution for inserts.Please let me know your thoughts.

Hello, JSON-lovers!We've been trying to extract the attributes from this response body but however we do it seems like we need to input the attributes we need manually. This can't be true. We would like to get all the attributes no matter what. We're no JSON-specialist as you can probably guess... Is there an easy way to do this?Response body:[{"ObjectId":507,"ComponentId":3,"Metadata":{"KomponentNamn":"AB+56232=270XO001","Lansbokstav":"AB","Objekt":"56","ObjektId":507,"KomponentId":3,"Area":"2","Placering":"32","System":"27","Underniv":"0","Beteckning":"XO","Nr":"001","Underlitt":"","Beskrivning":"Övrigt konstruktionselement, Polygonpunkt","Entreprenor":"","Leverantor":"Ab

Hello All I'm new to FME but i think it's a great tool to helpanyway i have this problem that i hope that somebody can help me to solve it I have a TXT file , most of the sentence are not with dot at the end.I need to add a dot at the end of every sentence and then save the TXT file back again with the same encoding settings ( I want to make this thing to go automatically)any help guys thanks

Hi,Is it possible to copy the conditional values from one attributemanger to another? Thx!

I have some point objects that need to be rotated. The source data has a starting position and contains a offset in metres from the origin. This would give me two points and from there I could draw a line between the two and finaly measure the angle of this line using AzimutCalculator. Ergo my rotation value.I need some advice on the best way to construct the line. So far I have tried combinations of the Offseter, VertexCreator and LineBuilder to construct the new point but I have not found a way to pair this with the source object. The features all come with an unique ID, but I have not figured out how to pair the original back to the offset point before drawing the connecting line. Below is an early embryo just to give an example of what I am trying to do.

I can do it in QGIS simply by using "name" LIKE '%LDN%' to sort the data, but this is not working for me in FME using the Attribute filter and text editor. Forgive me if I have got it wrong, this is my first go at using FME.

Hello,I have a network of (+) intersecting lines (There is no (T) intersections). I have also nodes of these + intersections also extracted.I want that whenever there is an intersection, the shortest line to be splitted to 2 lines but the long ones remains as it isCan anyone help me with this ?Thank you very much

Just for fun :-) Try this workspace. Assuming that different two versions (latest one and previous one) of FME have been installed in your machine. (FME 2018.0.0.3)Published ParametersNew Transformers: "<NEWER_FME_HOME>/transformers/fmesuite.fmx" of the newer FMEPrevious Transformers: "<OLDER_FME_HOME>/transformers/fmesuite.fmx" of the older FMEDestination Microsoft Excel File: Excel file which will store list of transformers - Added, Upgraded, Unchanged and Deprecated.In fact, I wanted to know what transformers have to be newly localized in FME localization job for the latest version of FME.

Hi all!I'm trying to do a simple reprojection from ESPG:3021 to ESPG:3006 but there seems to be some kind of problem. The transformer(?) are "flattening" the polygons (zipcode areas) in the north-eastern part of Sweden. Why? And what can I do to solve or work around this?Thank you!:nicklas

I have a workspace producing various outputs, I'd like to produce a further output which details the number of distinct customers and number of distinct products for each output but this appears to be either convoluted involving multiple steps and statistics calculators or slow involving a count distinct in the inlinequerier. Wondering if I'm missing a trick

I have a reader (file geodatabase) that contains about 900 polygons and want to use each feature independently as a clipper in a Clipper transformer, since I want to clip a few rasters based on that clipper. The result should be connected to that input somehow.

I was wondering if anyone has any ideas on how I would approach the below problem.I have a road network where there are short single carriageway centerlines of short distances between dual carriageways. I want to identify where there is a break between dual carriageways that is less than x meters. The image below shows a simple example and it is the geometry highlighted in red which I want to identify.

Hello,How can I copy content of the table?     For instance, my table looks like this: Out of above table I would like to create below table:

Using FME Version: FME(R) 2017.1.1.0 (20170929 - Build 17650 - WIN32)Getting this error in the FME log: |ERROR |BADNEWS: Features of the same type must all use the same coordinate system, given 'EPSG:26782' and 'EPSG:32002' (schemscn.cpp:2014)Each feature has it's own destination coordinate system attribute. Using the Reporjector transformer, I specify the destination coordinate attribute to reproject the feature into a local UTM coordinate system so I can then use the snipper to get an accurate measurement. I get the error above, however, It doesn't stop the workbench from working. I'm afraid it's not reprojecting the geometry correctly. According to the reprojecter documentation each feature is allowed to be reprojected independently. Is this truly an error and if so what do I need to do to reproject each feature independent of each other?FYI: I tried this with FME 2018 (FME(R) 2018.0.0.2 (20180414 - Build 18301 - WIN64)) and I still get the sam

I have a workbench that has to process about 600,000 lines and apply updates to a master dataset (.gdb). The attached workbench is a very small sample of what has to be completed. The main issue I am running into is the update detector is extremely slow. A sample run of about 1000 lines took just over 2 hours. So any suggestions of things I can do to speed it up would be much appreciated. I have also found that when I try to run the whole the workbench with the complete dataset the FeatureMerger rejects the suppliers with the rejection code EXTRA_REFERENCEE_FEATURE. This only seems to occur when the number of suppliers gets quite large. I have seen this same rejection code mentioned in reference to duplicates but I don't have any duplicates in the complete supplier dataset. Any help on either issues would be much appreciated.Sample of bench Pic of whole bench

I'm using RasterTiler to create tiles from a larger raster. However, I noticed many resulting tiles contains only nodata values. How can I avoid writing out these tiles.

Hello,I have a map of questionable quality and I'd like to use the geometry validator. Since there is actually clear warning that this transformer is intended for experienced users, is there a guide of some kind I could refer to?I did see the help section, but I am looking at some simple how to start ... what are the best ways to set up the transformer, if you have no idea what you are doing etc. Few hints really.I have attached sample of the file.Thank you