Transformers

For example, I have two features with different code in their field "code".These two areas overlap when I use the transformer "AreaOnAreaOverlayer"and I have a field named "overlap" where it writes "2".  But now, I would like a field to know if these overlap include the same code of no. In this example, the features (area) haven't the same code. Thank you!

Hey everyone, I am trying to write a file to a temporary filepath in my PythonCaller script and I thought that using the TempPathnameCreator transformer might save me some time coding something which is a basic function in FME. Unfortunately if I try to write the file to the location I get a python error that says that the location does not exist. I have used the OS python package to test if the temporary path is valid and it is not. Am I using the TempPathnameCreator incorrectly and is it logical that my PythonCaller is unable to write to the temporary location?

Hi I need to post requests to SOAP to retrieve some information about Planning cases back in XML and I have read the article: https://community.safe.com/s/article/working-with-soap-services Our process is more complicated as I need to log in and out of SOAP at the start/end of the process.  I created steps in a TestCase in SOAPUI and it worked and I have set up a workbench with the following transformers: CreatorXML Templater (for login)HPPTCaller (for login - cookies enabled)XML Templater (to Get data)HTTPCaller (to Get data)XML Templater (to logoff)HTTPCaller (to logoff) While this worked for retrieving one planning case I actually need to retrieve information on multiple cases but cannot get this to work. I tried two things: 1) I created a spreadsheet with multiple planning case references in, read this into FME (replacing the Creator) and changed the value in XMLTemplater to use the attribute value (using fme:get-attribute), instead of a hardcoded value.This appeared to be attempti

Hi Community,Based on the Figure 1 table, two fields exist as mentioned and I want to find the results as mentioned in Figure 2I tried so many transformers and had no luck.Figure 1Figure 2Please help me with how to get the results.

I created trees in citygml based on point data. The tutorial is described here:https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representationWorkflow:Result: No I will set a color for this trees. Unfortunately it is not working with appearance setter. No appearance is set inside citygml file. In the description it is written: "tree models: can be any kind of 3D object (Sketchup, OBJ, DWG, ...) but currently does not work with geometry containing color appearances" So does anyone know if this is possible maybe? We need to color this trees Hope someone has ideas how to solve this kind of problem?

This process used to work fine but I realised lately since updating the database connection due to SQL server moving I see it does not update the table like it used to. It stops working at the GeometryExtractor but no errors.  I do getEND - ProcessID: 888, peak process memory usage: 226836 kB, current process memory usage: 93912 kB Can that cause the issue and what would be a way around this issue? Regards, Josh

So I noticed that when using a parameterized INSERT statement in SQL Executor:INSERT INTO MYTABLE(FIELD1, FIELD2)VALUES ('@Value(FMEATTR1)','@Value(FMEATTR2)',)Any NULL becomes an empty string. How do I use logic like the above and still keep my NULLs? I've tried to wrap the entries in VALUES in case statements to catch NULLs and handle them differently - but to no avail. 

We want to convert a GDB to SHP file with field type string and length>254. How can we keep the data with maximum size 254, but not ignore the dataThanks

BADNEWS: Cannot convert null string into an integer(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:346) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &)... Last 2 lines repeated 6 times ...​this error often display,when read excel 、shp 、 dwg file​

Hi all, I will create trees[citygml] based on point geometry. On the internet I found this tutorial: https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representation Unfortunately *SKP format is not supported for my fme version. So I have tried it with obj models. But this doesnt work for me! I got this rejection code: INVALID_SHARED_ITEM(SharedItemIDSetter). How can I solve this problem? Workflow:

I have a Python script that cleanses a specified document and then creates a logfile in a local directory. I am trying to embed this Python script to run out of FME via the PythonCaller, so instead of creating an independent log file, it will print out as an attribute and I can create additional functionality via FME based on the content. I was able to successfully run the data cleansing side, but I'm getting stuck with the logging side. That is, I was able to print characters inside the FME Validation Log, but I don't want that as I can't use additional transformers on that log content.  Can someone provide an example file or structure of how I can add this feature to my existing PythonCaller? I'm currently running FME(R) 2021.1.1.0 (20210730 - Build 21619 - WIN64) and Python 3.8.

Hi there, can anyone please help me how can I filter some record that have a particular word. For example, I would like to filter all the road name starts with 'The ' (e.g. The Meadow but not like 'Theodor road'. If I use contains/begins with in the tester, it gives me all that have string part 'The'. I never used Regex editor. A good response will be highly appreciated. Thanks in advance.

With the help of the following request url in the Httpcaller, it was possible to get a returned xml output with information about one feature. However instead of retrieving information about one feature, ideally I would like to retrieve metadata of all the items from ArcGIS Online. Does anyone might have an idea how that can be achieved? This url gets me metadata of one feature.https://<companyname>.maps.arcgis.com/sharing/rest/content/items/<Item Id>/info/iteminfo.xml 

 

We translated a GML file to GDB, Then we get two problem:FeatureColleation layer induced, how to remove itlayer name with geometry, how to remove itThanks

Hello all, I am trying to replace a macro in Access that makes a series of SQL queries to update a table used in more processing afterwards. I am pretty new to creating work benches and wanted to get some input as far as how I might construct a workbench to do this and the transformers I would use. I am getting lost in whether I can create a more linear process with transformers in sequential order, or if it will take a different way of thinking to build it that incorporates different pieces at different times. I am more used to ArcGIS Modelbuilder and this is just different enough get me second guessing all ideas.Here are all of the SQL queries the macro executes, in order with a couple of notes I added for clarification: NOTE: I know this part can be done with the truncate option in the writer: DELETE StagingTable.*FROM StagingTable;________ INSERT INTO StagingTable (PIN, MailingTo, FullAddress, CityState, ZipCode)SELECT SourceTable1.PIN, "" AS MailingTo, SourceTable1.StreetAddress A

I have a dataset containing 10ish attributes. Most of the fields are empty (if an item has a value in attr1, it has no value in attr2, attr3, attrN, etc), and I want to have a single attribute containing the value of all the others.

I have two geodatabase.I used "AreaOnAreaOverLayer" to have the intersections of features for the one of the geodatabase and then, for the second geodatabase. It creates for both, a field named “Overlaps”.It works correctly. After that, I wanted to join the two geodatabases The two geodatabase overlap but they haven’t the same name so I can’t use « feature joiner » because I haven’t a common field.With the transformer “clipper” I haven’t all fields  (It misses the field “overlaps” of one of the geodatabase)With “AreaOnAreaOverLayer”, “SpatialRelator”, “SpatialFilter” and NeighboorPair” one of the field "overlap" is null That’s why I want a transformer to make a spatial join and not a attribute join with all fields of two geodatabase. Thank you !  

I'm reading and writing dynamically some spatial data and this works as intended, however there is a usecase where if a certain attribute has value 'X' something else needs to be done (different kind of projection). The caveat is that the input isn't consistent on the name. it can be AtributeName, Atribute_Name,attribute_name,... Is it possible that when the user specifies the input data location, the user can also specify which attribute from it's data that contains the correct information? I've tried with a AttributeName parameter in the UI, but this is always linked with the attributes that are present in the initial reader and doesn't refresh to a new gdb if I provide one

Hi. By default we use Property Extractor geometries, but how can this be used if both geometries (part0, part1) have the same name? Thank you

Instead of logging in and looking at the credits usage on ArcGIS.com daily/weekly, I would like to have a script running finally in the FME server that runs daily or weekly and informs me via a mail that the credits has reached a certain amount. This informs me that additional credits need to be bought.  Does anyone know what would be achievable in FME desktop? How can I retrieve credits information within FME deskstop?

 X1/Y1 is the left bottom corner and X2/Y2 is the right top corder. Cannot find how to do it...? Vertex creator with Add point and LineBuilder just draws a line

Hello My 2 recent posts were related to issues experienced with FME 2022.I was hoping this one would disappear however it still persists using the latest build. It did stop (previous build) some of my critical workflows from functioning properly although the translations were successful. Basically Attribute Manager will highlight some of my values in Red.But the transformer's cog itself isn't red. It seems to affect Arithmetic values or use of functions.  Here's the workflow - Nothing unusualLet's check the Attribute ManagerValues highlighted in Red for no apparent reasons I click on the Attribute Values and they return to "normal" however when you close / re-open the Transformer sane thing happens. Not sure what is going on here.Translation is successful though. ThanksSameer

I am working with rasters and want to fill some No Data Value cells with new data using a Raster Convolver (square matrix, with 0 in corners). To do an extent.When I use this, it still creates cells with value 0.0 in the corners where I would still want no data in this corner ; so I could repeat the process if needed (and fill a new gap instead of using a 0 value that will have an effect of values for next iterations).I am asking if there is a way to have this in FME, or to use any self-made matrices to be applied on rasters.ThanksSG

I have Geotiff file and I need to convert in shape file with data I am new in this so I don't know how to Extract fields and attributes from Geotiff + this is the file https://www.nhc.noaa.gov/gis/inundation/inundation.zip