Transformers

I have a workbench that reads features from a large database to find feature that match a certain set of criteria. I only need 2000 features to be output. At the moment I use a counter to count the matching features and only route features to the writer whilst the count is less than 2000. However the workbench continues to read features from the database until all features have been read. What I would like to be able to do is to stop the reader when 2000 suitable features have been found.   The workaround I have at the moment is to guess at how many feature I will need to check and set that as the maximum number of features to read. It can take several hours to find 2000 suitable features and several hours more to continue reading the remaining features that are not required from the database. I already have a reader Where clause to do as much filtering on the database as possible

Good day FME'ersI am trying to calculate the percentage green/grey from an single band NDVI raster image, i.e. the percentage of the raster that have cell values >= and < -0.1. Can anybody help?Thanks,David McDermott

Hello,Is it possible to read and unzip .tar files?  I have an interesting project that starts with a .tar file, I need to unzip that to get a .gz file, need to unzip that to get another .tar file, one final unzip to get a folder containing the data I need to edit. So in short the structure: .tar -> unzip -> .gz -> unzip -> .tar -> unzip = folder containing DBF and SHP files I need to edit. Once edits have been made I need to zip everything back up in reverse order.How would I do this? Thanks, all the best, Ed

I am trying to download a zip file containing some shapefiles from a website that requires logging into with a username/password. From what I've read so far, it appears that the HTTPCaller transformer is what I should use. I've pasted my settings below, but nothing seems to download when I run the workspace. Anyone else figured out a way to download shapefiles from a password protected site?

I have some addresses that have been parsed fairly well. However I several thousand that have a letter after the house #, my geocoder requires a space here.For example I have 123A Main Street I need 123 A Main StreetSo I was thinking I could use the StringReplacer transformer to search for [0-9][A-Z], but I don't know what to put in the Replacement Text field.

I have a working workspace to update metadata documents based on information from different sources like JSON files, file geodatabases, and so on. Now I've realized that some of these sources may not have values for some of the metadata elements I'm updating.For example, a JSON file may have a key-value pair: "_xmin": ""To avoid updating elements with an empty value I'm using conditional xqueries in my XMLUpdater transformer, but I don't know what I should write in the 'else' statement. If I leave it empty, element values are updated with and empty value and I don't want that.For the above example:{if (not(fme:get-attribute("_minx") eq "")) then (fme:get-attribute("_minx")) else (*keep existing values!*)}

Hello,I am using the Move to Local Coordinate System option in my SketchUp Writer in order to fix too big coordinates issues. Thing is, now, my scene origin seems to be set to an arbitrary location within my scene. (see picture below). How to set a specific location ? Center, or bottom-left corner ? Also, this is more related to SketchUp geolocation : about the geographic coordinates indicated on the model info window, are they the one of the 3D scene origin ?Thanks in advance,Kind regards,  Mickaël

Hello everybody.I've a question with the transformer Snipper.Before transformer I've lines with start and end measure.My transformer parameters are :After transformer I've cut lines with the start and end measure of before and points alones.I don't understand why I've points in exit have you got any idea ?Thank you for your help.

HiWhats the easiest way to get the Azimuth to a compass bearing?Thanks

This has just popped up a workspace I've been working with for some weeks after making a series of adjustments. The problem is the message is too vague to track the issue down. The only qualifying statement is The invalid values are in: Main. Do you want to continue and run the workspace with the invalid values?If I continue there's no obvious failure.I presume Main is the whole of the workspace. That's not too helpful. I would have thought if the inconsistency could be detected then the target would be known.How do I debug this? What am I looking for?Thanks in advance.

The documentation "FMEPlugInSDK_Java.pdf" refers to a script "rename_format_java.py" that presumably renames classes and files so you can build your own custom plugin.Where is this file? It does not appear to be installed (though similar corresponding scripts for C++ and Python plugins are present).

Hi,When using JDBC connections, there is an option to enter in user/pass as parameters, but I am unsure how to format the connection string to leverage these parameters. So far, I can only connect if I embed my user/pass (as plain text) in the JDBC connection string. Any ideas?jdbc:scwapi:<server_name>;<powerhub_user>;<passwd>;<database_instance><database_name;<username>;<dbpasswd>

Hi, As new user of FME and because I haven't found any answer elsewhere on the Internet I created this topic.I would like to use MV blocks an AEC Objects from Autocad in FME respectively as Simple blocks and Polyline.With FME:-MVblock doesn't provide anything.-AEC Space provide a rectangle with the dimensions of the Space (draw as a polyline in Autocad). So the specificities of the polyline are lost.I can modify my DWG file to make it workable and this is what I am doing. But my question is : How to read correctly MVblocks and AEC Objects in FME ?Dylan. 

I am building large datasets and am outputting to a geojson. Since I can't put in an index, I was wondering if it was possible to sort the feature order from east to west?

Hi,I have the geometry of some points in GML format like this :<gml:pos>45.2690694444444 0.022336111111111</gml:pos> (Geometry obtained with geometryExtractor)In some cases, i have less than 6 decimals in the representation. For example :<gml:pos>44.8845083333333 2.4274</gml:pos>I search the way to add 2 zeros at the end of this number in such a way to obtain this :<gml:pos>44.8845083333333 2.427400</gml:pos>It's a validation ruleI used stringFormatter for simple attributes but in the cases of geometry written in GML format, i don't have an idea ...

I want to use Inline Querier to find all rows in table CSV that are not in table DCDB. Lot_plan is the common columnthis works (returns rows)SELECT Lot_plan FROM CSVEXCEPTSELECT Lot_plan FROM DCDBThis does not work (returns zero rows)SELECT * FROM CSVWHERE Lot_plan NOT IN (SELECT Lot_plan FROM DCDB)Why does the EXCEPT statement work and not the NOT IN statement?

Starting point: I have a broken topology with nodes an edges as shown in the first picture below. The problem is that not all edges are graphically connected with the respective node.Attempt to solve: I used a "AnchoredSnapper" with the nodes as anchor and the edges as candidate. The "Snapping Tolerance" is depicted with the grey area in the pictures. The edges and the node which belongs together have a equal attribute what I use to group the elements.Problem: After the "AnchoredSnapper" the edges and the respective node are graphically connected as shown in the second picture (green lines). But unfortunately also the ends of the edges which have already a node and are within the "Snapping Tolerance" (red lines). Question: How can I avoid the wrong connections (red lines)? Adjusting the "Snapping Tolerance" is not an option because the not connected ends are not always in the same distance from the target node.

@takashi I have a number of numeric raster datasets with the value of NDVI or vegetation type. I have a polygon dataset with various properties and property types (public, road, private, etc). First I tried the standard raster and vector tools in FME but found that compared to other programs I have used FME is very slow with images. So I got sidetracked into point clouds and FME was on steroids. Then I kinda ran out of tools and knowledge and also realised that the final output would have to include vectors not just the analysis so I will probably bite the bullet and revert to slow and traditional. I would like to continue to see what I could do with point cloud though. Fail points were 1. converting the point cloud into vectors - I did see some workflows of buffering the points, dissolving etc but ran out of time to play and wasn't sure how quick these would be. A brief play with HullReplacer just gave me a big square. 2. Analysing the point cloud against vectors (assuming I didn&

I keep getting an error in my translation because one of the reader attributes is a string (utf-16) and I'm trying to read it into an integer attribute in the writer. But I can't seem to find a way to convert it. I'm sure I've accomplished this in the past but can't remember how and am not seeing anything in the docs about how to do this specifically.

Dear everyone, I have an fme workbench which is maintaing a connection between my sql server enterprise gdb and having some paramaters, I am using it for data download. It is facing two problem, 1) fme is reading featureclass name as we see inside arcgis catalog (i.e, DBO.test) while in sql server we find it as dbo.TEST. We have also a automatic process to read metadata where the table name we read as dbo.TEST. But our fme workflow is reading it as DBO.test so our download button is not working. How can I change the schema name in lowercase? ANother this is , i was trying to use a choice list for automatically updating new featureclass or table name inside reader, but when I import it as fme_feature_type , it is importing nothing!

Is there a transformer in FME that can build sector polygons based on coordinates provided.     e.g. Source data has 10,000 point geometries. Output needs to be list of polygons with no more than 500 points within the polygon.

I am using the Arc Data Interoperability ext. FME 2016.0.1.2(20160224-build16177 - win32).Trying to maintain layers in the skp file, I reference @sander solution but am still having difficulty. When I say 'run' I get the translation parameters prompts below.This is my geometry property setter parameters, for the first layer. the others I tried to give numbers, but it makes no difference. And of course then doesn't run so I cant send you a log file. I have been using FME infrequently for years but definitely still at beginner level, clearly.Also battling with the help files for this issue.Below are two pics showing the difference I'm after. If I can maintain the layers (not all in 1 layer), it makes editing in skp easier. I need to simplify the buildings there, by taking cityGML LOD4 and making it +-LOD2.5.

When I create a tunnel from a long connection line than the first annatation is the same length as the connection line.

Hi,it may be a stupid question, but if you add a writer/reader/inspector in fme2018 to a transformer that is in a bookmark, he always puts it out of the bookmark. My model is very large and has a lot of bookmarks that run into each other so that is not so convenient. Is there a way around it?ThxNathalie

I am working to calculate Stream order for Geobase National Hydro-logical network for Canada. I used this link for my task -->https://knowledge.safe.com/articles/1228/calculating-strahler-stream-order-numbers-streamor.htmlThis is really good FME model and stream order are just fine for the network having just one destination point. But I have few problems with this model, which I am trying to solve:1. If the Hydro network have more than one destination point. How can I input more nodes as destination points for each network in stream order calculation tool, so that it calculates stream order for that network based on all the destination points instead of just one destination point. Also, is this even possible with the existing stream order calculation tool?2. I have few destination points for few networks which do have a lowest elevation but those points are on mainland (maybe inside a ditch, pond etc) and not inside the ocean but the network actually ends inside the ocean but mayb