Transformers

Hi FME community.I would like to merge two columns value in once like that :Col1Col2AZERTYHELPAZERTYNOBODYQWERTYENJOY>Col1AZERTYQWERTYHELPNOBODYENJOYCan I do that with a transformer ?Thank you.

Hi guys,I'm trying to offset lines (SHP) with z-value geometry using OffsetCurveGenerator. I have two attributies to offset roads at left or right site of the road. It works ok, by I'm loosing information about z-value which is significant becouse I'm trying to get flat surface of the road (the second phase is to update DTM). Function @Buffer(@Value(RBuffer),22.5, RIGHT_SIDE_ONLY) gives the same resoult. Any idea how to offset road but keeping z-value? Thanks for the help,

I am looking to convert some points from a shape file into blocks. So far I managed to convert the points into the block type I want by using dwgstyler, selecting the dwg template and the name of the block. I also specify the same dwg template in the dwg writer (maybe its unecessary?)  Now what I cant seem to be able to do is:  Those points have an attribute that I would like to save as the label/text attribute the block has. So ideally for example, point with attribute A value 18 would be saved as a block with attribute B value 18. Is it possible to save the attribute as an autocad attribute? I have tried searching for that block attribute when i used attributeCreator, or even using attribute exposer, but I can't seem to be able to find it...Edit - The block has 2 layers, one for the geometry and the other is a text for the attribute.

Has anyone ever / Is it possible to do an upgrade from 2017 to 2018 Server but move drives and restore your config in the process.For example 2017 is installed on the C Drive- company policies is to only allow 50gb on the C Drive and no permissions for me as an admin to write on the C Drive. So I can't delete old files make changes etc without bringing in I.T which is very frustrating.Only solution is that we move FME Server to a new drive where we can have as much space as required. So my question is, if I take a backup of 2017 where everything is configured on the CDrive and I install 2018 Server and restore to the EDrive for example will everything work as expected? Or am I expecting too much :)

Hi,I have one workspace that uses GoogleGeocoder, but in some weeks ago, my workspace don´t work properly. Below follow the log:2018-03-23 13:43:38| 4.2| 4.2|STATS |Router and Unexpected Input Remover(RoutingFactory): Tested 5 input feature(s), wrote 5 output feature(s): 5 matched merge filters, 5 were routed to output, 0 could not be routed.  2018-03-23 13:43:38| 4.2| 0.0|STATS |Unexpected Input Remover Nuker(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)  2018-03-23 13:43:38| 4.2| 0.0|STATS |Plan1 (XLSXR_1) Splitter(TeeFactory): Cloned 5 input feature(s) into 5 output feature(s)  2018-03-23 13:43:38| 4.2| 0.0|STATS |Plan1_XLSXR_1 Feature Counter -1 18(TeeFactory): Cloned 5 input feature(s) into 5 output feature(s)  2018-03-23 13:43:38| 4.2| 0.0|STATS |Geocoder_CATCHER(TeeFactory): Cloned 5 input feature(s) into 5 output feature(s)  2018-03-23 13:43:39| 5.4| 1.2|WARN |Geocoder (Geocoder): Geocoding result invalid, status: 'ERROR - Unhandled Exce

Hi i downloaded FME Trail version and using Workbench. And I am trying to convert WMS "link" to shapefile format.It is reading well but, while writing into shapefile it is throwing error. See the below error information"A fatal error has occurred. Check the logfile above for detailsFME Session Duration: 2.8 seconds. (CPU: 0.2s user, 0.1s system)END - ProcessID: 4020, peak process memory usage: 40856 kB, current process memory usage: 39564 kBA fatal error has occurred. Check the logfile above for detailsProgram TerminatingTranslation FAILED."Please help me regarding this issue.@vamsi krishna

I have a center line...i want to have buffer polygons 100m each right and left...but they have to be single polygons which every of them is 100m width.....so i need one 100m right, 200m right, and so on but every of them have to be 100m in width....soMultibufferer brings me the right target but the transformer gives me donut geometry with a polygon right one left and a line which connect both of them...so whats the process when i want this.... or is another transformer better?

I am using the UpdateDetector to update GDB_A. GDB_A is entering the UpdateDetector through the Original Port.GDB_B is an updated version of the same data and enters the UpdateDecector through the Revised Port.GDB_B more often than not includes all of GDB_A plus some new features, these correctly exit through the Insert Port.GDB_A has had many changes made to its attributes since the last update (basically attribute data has been entered in manually replacing Null values with more useful data)As these manually added values do not exist in GDB_B, any rows that have been manually adjusted in GDB_A exit the UpdateDetector through the Update Port, with the manually added data in GDB_A having been replaced with the Null value from GDB_B.I am looking for an elegant way to prioritize any value over a null value for every attribute, regardless of whether the value is sourced from the Original (GDB_A) or the Revised (GDB_B) dataset. But also if there is a true update; ie both GDB_A and GDB_B ha

I have a shapefile with multiple float-fields. I want to calculate the minimum value of these fields. For some of the features the calculation is correct, but for some features the values are not used.I use the AttributeCreator with the Arithmetic Editor: @min(@Value(BOVENGRENS),@Value(ONDERGRENS),@Value(WINTERPEIL),@Value(VAST_PEIL))This gives the following result in the field Rekenpeil:Thank you for your replies!

Hello, I hope someone can help me with my problem. I am fairly new to FME and my first task is to close parcel polygons from .SHP. My approach was to use transformers LineCloser, Matcher and AreaBulder in that order and this works fine if data is good(Picture 1). I will be working with .SHP that are not 100% correct for example not all lines in .SHP will touch in same point (see Picture 2) or they will intersect (Picture 3). And at last my question. Is there a possibility in FME that I can test my SHP for this type of issues?Picture1Picture 2Picture 3

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 ...