Transformers

I'm aiming to compare the values of multiple tables from two different data sources with FME. I've already prepared two tables, that list all values from either data source.The 'left data source', consisting of two tables (Fruit and Vegetable) and their values over various columns:IdLeftTableNameLeftColumnNameLeftValue1FruitNameApple1FruitColorRed1FruitKcal522FruitNameBanana2FruitColorYellow2FruitKcal893VegetableNameCarrot3VegetableColorOrange3VegetableShapePointy The 'right data source', consisting of two tables (FRUITS and VEGETABLES) and their values over various columns:IdRightTableNameRightColumnNameRightValue1FRUITSDESCRIPTIONApple1FRUITSCOLORYellow1FRUITSCALORIES522FRUITSDESCRIPTIONBanana2FRUITSCOLORYellow2FRUITSCALORIES903VEGETABLESDESCRIPTIONCarrot3VEGETABLESCOLOROrange3VEGETABLESSHAPEPointy The tables and columns of both data sources can be related using the following mapping:LeftTableNameLeftColumnNameRightTableNameRightColumnNameFruitNameFRUITSDESCRI

Hi Im experiencing issues trying to use GML in XMLTemplater.  Code:  {fme:get-xml-attribute("_conc")}  Works fine for  _conc = <xml:Point> ....... </xml:Point> Prints nothing for _conc = <gml:Point> ...... </gml:Point>  Perhaps this not supposed to work? In that cas is there a workaround?  Best regards

Hi list.I'm currently trying to generate a composite XML using XmlTemplater.One of the details is that tags without text value must not be output at all.I tried to utilize the following expression (from the help page):{ if( {fme:has-attribute("mailadresse")} )then <ler:mailadresse>{fme:get-attribute("mailadresse")}</ler:mailadresse>else ()}My expectation (for "else") is that output is only generated if an attribute value is present.Much to my surprise, "<ler:mailadresse/>" is output instead, even though the attribute value in question is <null>.Can anyone share how to tweak the expression, so "else" produces absolutely no output ?And yes, the presence of the "else" part seems to be mandatory.Using 2020.0

Hello,Within the ChartGenerator is there any way I can have a second line in the Title, but with a smaller font size? i.e. like a sub heading.In fact having the ability to dynamically adjust the font of text within text elements in FME would be great. This way I could just add a return in the text editor to give me text on a new line and then wrap any text in a set of parameters that overwrite the font settings in the transformer. In my case it would be the same font, but a smaller size.Also, is it possible to add labels to the point markers or a selection of the point markers in a line type plot?Thanks

I hope you are doing well during these different times. I have some point data that represents addresses. Sometimes one address (123 Main St) can have more than one feature because one represents the building and one the parcel. I have used the Matcher, matching on the address string field. Now, I have a _match_id that is unique for each different address. Now I want to filter the data. Ex: For each unique _match_id value, filter out features that are an address_type of Building. How do you suggest doing this? 

Hello,  I am having problems modifying existing appearances on geometry.  I have an FBX file (no textures, only mesh colors) that i want to get the appearance from, do some changes on the diffuse, emissive, ambient and so on. This I have managed with an AppearanceExtractor node then do the changes in from a pythonCaller.  Now the problem I have is I don´t know how to append the newly modified appearances to the geometry again. I guess i should use the AppearenceSetter node, but I don´t know how to get an attribute from the geometry to join on.   Does anyone know the solution to this problem?

I am trying to create multiple attributes based on the string in a single attribute. E.g. I have a series of features with percentages for each. I want to create an attribute for each feature. There may be multiple features with the same name.  This is the example source Week NoUser% 1Tim151Sam252Tim122Sam193Tim93Sam104Tim254Sam15Tim145Sam726Tim526Sam3 And this is what I want it to output  Week 1 %Week 2 %Week 3 %Week 4 %Week 5 %Week 6 %Tim15129251452Sam2519101723 I have tried BulkAttributeRenamer and cant get it to work. This is how I tried it (one of many attempts).  any help on this would be great.ThanksSeb

For years I have been using a small helper function to log in both FME Desktop Log Window and Logfile (and FME Server):def myLogger(string):    print(string)    with open(fme.logFileName,"a") as f:        f.write("{}\n".format(string))With this, my log messages were written to the Logfile and when executed in FME Desktop Workbench also visible in the log window.Now, FME 2018.1 and newer redirect stdout to info logging and stderr to warn logging in the FME session.But in the Shutdown Script the FME Session has already been terminated.Is there any way to put info into the FME Desktop Log Window from a Python Shutdown Script?

Hi, I'm very very new to this so apologies if the question is stupid or posted in the wrong place. I'm trying to learn FME usuing the online resources and this forum as this is the first work chance I've had to do it and liking it so far. I have researched my question already but didn't find relevant recent answers (unless of course I have missed them) I'm trying to generate a Clip and Ship type of service. So I'm starting with the Austin download example which will give be a great foundation for my requirements, however I'm falling over on the first hurdle. The current user parameter list for austindownload is pre configured as a text comma separated list .... my potential requirements is a for a more dynamic list which would be controlled by a table in Oracle (sde) with a number of attributes in the table that I envisage as being required to delivery additional components related to the dataset. So I have a worksbench that connects to a gdb and based o

If you provide proj4 parameters string to PROJReprojector with extra spaces in "towgs84" clause - transliation finish with error:PROJ: proj_create: Non numerical value in towgs84 clauseReprojector: Invalid reprojection parametersFME version 2020.0

We want to confirm the availability of the 60 day trial for a pilot project we are working on.

I know there are already posts about this, but couldn't find much info about it.I have a column in csv with multiple fields and values in the same column:col1 { "21" : 80.0, "81" : null, "21" : 100.0, "21" : 60.0 } { "21" : 60.0, "21" : 80.0, "81" : null, "21" : 80.0, "21" : 100.0, "21" : 100.0, "21" : 60.0 }  Representation-21- max speed81- max weightThe occurrence of fields:1st time- Car, 2nd time- Bus, 3rd time-TruckMax Speed (Car) Max Weight(Car) Max Speed (Bus) Max Speed (Truck) Max Speed(D Truck) Max Speed (B Truck) 80 null 100 60 null null 60 null 80 100 100 100  Attaching the csv. I am able to use AttribuleSplitter, SubstringExtractor and putting them in fields, but the values are not in uniformity. Any suggestions?Thanks in advance.

Want to Trace downstream of Electrical Network

Hi I have about 100 feature classes in SDE to migrate to new DB. Following initial load, I would like to only process change only updates on a hourly basis. Some tables have over 4 million recordsHas anyone have experience of using ChangeDetector/ UpdateDetector in FME. How is the performance like. Any best practice suggestion regarding reading/writing 100 feature classes?The new DB is on different SDE/SQL Server version, hence I would prefer to use FME rather than SQL replication for this.   

Hello, I have a File Geodatabase Feature Class that has a field with people's names in the format "First Last". I have another spreadsheet with the people's Last names in one field, and their Active Directory usernames in another field. I need to get the names matched up with their Active Directory usernames as well as possible. What would be the best transformer to use to join these to tables using something similar to a "Like" or "Contains" query to get an output feature class with the usernames?The FeatureMerger doesn't allow you to use LIKE queries as far as I can tell.For example, say the Feature Class "Fred Johnson" in the name field, and the other table just has Johnson, I would need a Transformer and Query that joins those two and outputs a new feature class with the username. 

I would like to extract coordinates in a different column using FME SchemaMapper. I would like to use AttributeReprojector as filter value column in FME SchemaMapper

Hey there, I'm trying to convert Microstation DGN files into DWG to use them in Revit. Unfortunately the coordinates change a lot while doing so (see attached) and I can't make out why? Anyone got any idea why that is?  I tried auto selected coordinate system as well as manually selected. DGNDWG

An old version of the Dissolver (Version 3) has a parameter called overlapping input which can be set to Overlap or No OverlapCan anyone recall what the difference is?

Hello,I am trying to use Python caller to check if a folder exist. Here is the code:But it doesnt geve back outcome to attribute "van". Where is my mistake?import fmeimport fmeobjectsimport osdef processFeature(feature):    van = os.path.isdir(feature.getAttribute('_LAS_eleresiutvonal'))    print van    feature.setAttribute('_van', van)class FeatureProcessor(object):    def __init__(self):        pass    def input(self,feature):           self.pyoutput(feature)    def close(self):        pass

Hello, have anybody any idea why the LengthCalculator is giving wrong length in meter?I set the reprojector and lengthCalculator as usual.Thanks

Is there a way to set default annotation styling? I find that the text size is too small and I like to use different colour backgrounds but have to set it on every annotation I drop on the canvas. I can't find any settings to set defaults. ThanksSeb

Hello, I would like to split the line with the intersected Points. Seems easy, but it does not work for me...I have a lot of line which I merged together with a "NetworkTopologyCalculator" it looks that it works. After with aggregator I get 1 Line (what I wanted to). Then setted PointOnLineOverlayer. There I have the points, which intersected the Line. But the result from Overlayer is not as I needed. does anybdy have any idea, whay it been splitted on "wrong" place, and not there where the are the points?I get a sum of 840 lines, what is completely wrong.  Thanks a lot

Hello,Some time ago I had troubles with an unwanted outcome of my AttributeManager, see here:https://knowledge.safe.com/questions/107194/what-is-causing-a-difference-in-attribute-handling.html Now I have a similar issue. I have a table with 224 records, but for 3 records the outcome of the AttributeManger is not what I want and what I would expect.It goes wrong for these three records:This table goes into an AttributeManager where I multiply the values in the 'top' column with 1000.I use this statement: @int(@Value(top)*1000) The outcome is as follows:Does anyone know why it does not result in these values:LocDepth_IDtopB49F0423-8.118110B50D0035-2.012010B50D0036-4.024020 And why it goes wrong for only 3 out of 224 records? Thanks in advance!Eva

Hello all,I am a relatively new FME user. I am looking for advice on the most efficient way to assign attribute values based on CAD layer name. Specifically I am working with several sewer main layers that all begin with the diameter of the mains contained within. The way I have built out my work space does achieve what I am looking to do, however as you can see by then screenshot, it is horribly inefficient. I am wondering if anyone has any advice on how to consolidate the process I built out in that ridiculous branching process? Any advice would be much appreciated.Note: I understand this can likely be achieved in python very easily. I am not expert with such methods so if there is a way to achieve what I am looking to do using strictly transformers, that would be preferable to python solutions. That said, python solutions are also appreciated.Thanks,Nate

Hello dear FME comunity, My company is making databases to government facilities. We are gathering data from the field and digitizing it in AutoCAD. the water and sewage line attributes are in the middle of the line in an attribute block and the accessories are in attribute blocks. My wish is to get an FME module that I can work with that will give me the option to take the dwg data and transfer it to a shape file. the module needs to be flexible enough that if I wish to change the names of the attributes or their types on either side of the module it will be possible. The module should also have the option to check geometry and data validation, and to make a report showing where the problem is.