Transformers

How to compare two database schema (File GDB & SDE) including subtype & domains values.

The input looks like this:The result must look like this:

Hello,Can anyone explain the difference shown below? Inside a standard workflow, the SchemaScanner captures the order of the attribute names correctly as they appear on the input file. However, when used inside of a custom transformer, the incoming attribute names are sorted alphanumerically. Does anyone have any ideas why this is happening? 

Hi!I would like to export my datas (only attributes) on a jpeg file.I would like to create a sort of table like on excel, with blacks border and dimentionnate the columns in order to not truncate the datas. And then export an jpeg file.I used ExcelStyler and an JPEG writer, but it failed because it's not an raster format. So I tried with ImageRasterizer but I don't succeed. I'm not use to manipulate raster format. So could you give me advices to suceed?Thanks !

I had two features that both had FME Geometry of single point that I merged together with FeatureJoiner. The result of join I have single feature with FME Aggregate, with both points inside that. My question is that I want to get the distance (preferred in feet) between the two points that are now inside a FME Aggregate.  I figure the easiest way to do this is with Python caller. I tried looking at the forum question below calling Python. However, I couldn't determine how to use it to get both my FME Points out of FME Aggregate. https://community.safe.com/s/question/0D54Q00008z6yR3SAI/distance-calculation-per-pipe-segment If there are other suggestions, please let me know.  I'm attaching a sample FFS file with the data points. Can open and see the features each have FME aggregate with two FME points inside tha

I am currently creating a network by running nodes to a central point, using a 2d Grid as my network. I am noticing that points that should follow a similar route, sometimes take a slightly different path see below. I'm wondering if there is anything i'm missing to try and avoid this?  

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 spreadshee

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

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, CitySta

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