Transformers

XML to excel convert- how to convert below xml file in excel?All attributes should be populate in single row with separate columns<PlaceList><Place><LocationList><Location type="MAIN"><Address><ParsedList><Parsed languageCode="en-GB"><CountryCode>IND</CountryCode><PostalCode>303805</PostalCode><Admin><AdminLevel><Level2>Rajasthan</Level2><Level3>Jaipur</Level3><Level4>Amber</Level4></AdminLevel></Admin></Parsed><Parsed languageCode="hi-Latn" languageType="TRANSLITERATION"><CountryCode>IND</CountryCode><PostalCode>303805</PostalCode><Admin><AdminLevel><Level2>Rajasthan</Level2><Level3>Jayapur</Level3><Level4>Ambar</Level4></AdminLevel></Admin></Parsed><Parsed languageCode="hi"><CountryCode>IND</Coun

I am trying to drop features in the PythonCaller (see below my code). I manage to delete attributes and geometry in the last else statment, but for some reason the feature itself is not deleted. The number of features in the input and output is namely the same, while the geometry is gone (Look at the image below)  . I just find it interesting to see that the features without geometry are still kept. Does anyone know how I can drop the features in the Pythoncaller in the else statement when I am removing the redundant geometry?import fmeobjects def processFeature(feature):         lstAttributes = feature.getAllAttributeNames()        testList:=['B-OI-KL_ET_MS_KABELBED-G']         for lvl in lstAttributes:            if lvl == 'igds_level_name':                levelName = feature.getAttribute(lvl)                if levelName in testList:                    print(levelName)                    #print(levelName)                    for attr in lstAttributes:                         if len(at

Hi! Is there any way to set up a XYZ Tile background such as https://tile.openstreetmap.org/{z}/{x}/{y}.png (works fine in QGIS) into the FME Data Inspector?I suppose this type of service doesn't work like a WMTS service. Thanks for your clarifications! Best regards, Olivier

Now I'm suffering from keeping the attributes with the same schema. My workspace is quite simple, just reading IFC and writing IFC. I only need to remove some fearture types. So I think it's not necessary to do some touchups. And I'm trying to change some reader/writer parameters to solve the problem. Unfortunately, it doesn't work.From the IFC reader, we can see some IFC attributes which are regarded as geometry traits (IFMENull).After running the workspace, I found the all the IFMEAggregate with named "IFCPropertySet" were disappeared. Originally, there are 15 IFMEAggregates, including "Part 0:IMEAggregate (18 Parts)", Part 1 which is IfcMaterial, and Part 2 to Part 14 which are IfcPropertySet. After running the workspace, only 18 Parts are kept from original "Part 0:IFMEAggregate (18 Parts)" and its level is going up to the top.I'm not sure whether it's related to the setting of Representation Contexts. Does anyone have any idea?

Similar question is already asked here Does any one has migrated data or know how to migrate data into raster data type into ESRI feature class. Screenshot attached for better understanding...

Only the latest version of Proj (version 9.x) supports transformation (3D -heights!) between the norwegian Nautical Sea Chart Zero (EPSG:9672 and EPSG:9883) and NN2000 (EPSG:5941, EPSG:5942, EPSG:5973 etc.), but also between Nautical Chart Zero and ellipsoidal heights. This does provide a number of advantages, including the possibility of seamless transformation of z-values between sea and land data in Norway. (E.g. from EPSG:5973 to EPSG:9883) FME currently uses PROJ version 7 in the PROJReprosjector- Are there any plans to upgrade to version 9? Do you have any other suggestions on how to transform data in FME from EPSG:5973 to EPSG:9883? Thank you.

Is there a way to write a new line in an excel cell?

Hi all, In the last few days we've set many small steps leading up to the problem we now have. We have polygons, where one attribute of each polygon is a list of bird species, which occur in that area. This list is of course different for all polygons, the polygon-specific list. We also have a list of bird species which should occur in that area. This list is the same for all polygons (in this subset), the general list. Now, we would like to compare the list of each polygon, with the list for all polygons. We have tried many transformers, and our last option (at the moment) is the PythonCaller, where we hardcode the second list as a set, and compare it with the polygon-specific list, converted to a set. We group by the id of the polygon, because we want to compare each polygon-specific list to the general list. This is our Python-code:import fmeimport fmeobjects x = {'item 1','item 2','item 3'} class FeatureProcessor(object):    def __init__(self):        self.feature_list = []        

This is my JSON file. I want to insert, in "structure_ids" array, the value 79538. Maybe the problem is my value, I can't write it like that. Thanks for your help 

Coordinate system setter is in the workspace, so I can select local coordinate, but I want to add offset value in somewhere in the workspace. Please kindly let me know how to add off set value (Latitude shift, Longitude shift, and height shift). Thank you.

Like described in the header, In short I'm wondering what the default (X,Y) coordinate order conventions are in FME (particularly in relation to the 'Lat/Long vs Long/Lat discussion')? Reason/motivation of the questionThe reason I'm asking is that in quite some workspaces I prompt users to enter an extent for a particular area (mainly to filter out data for the user defined area). Recently a user asked me if it was possible to incorporate an option to also allow the input extent to be entered by means of explicit Bounding Box (BBOX) coordinates in the form of a specific envelope, i.e. to enter both the (Xmin, Ymin) AND the (Xmax, Ymax) coordinates.Of course these explicit coordinates are meaningless without knowing how to interpret them (i.e. without knowing the underlying coordinate system). In the Netherlands it turns out that the vast majority of spatial files make use of the 'RDNew coordinate system' (EPSG:28992). However, I also wanted to give users the opt

I would like to get the predominant line for each polygon. I have tried using the 'CenterlineReplacer' but that doesn't work well since a lot of these shapes aren't long and narrow areas.  I only need one line per polygon, but it needs to be straight. The length of the line doesn't matter. I'm interested in the direction. Does anyone have an idea about how I can approach this task? 

Custom format of version 2017.x (32-bit) not working when saved with 2022.1 (64-bit) version. Enclosed the custom format of version 2017.x for your reference. Above screenshot shows the v2017 custom format when consumed as Workspace Resource in FME Desktop v2022.1. Above screenshot shows the v2022.1 custom format (same old v2017 custom format opened and saved in FME Desktop v2022.1) when consumed as Workspace Resource in FME Desktop v2022.1.

Hello,I have a number of Workspaces that are run by colleagues using FME Server. These typically connect to a database, do some stuff, and create file-based output. The can run on three different environments, and because of that the database but also the output directory should be different. Right now I allow for that by using a database connection parameter and an output path parameter. It is to easy though to set one and forget the other, so that Production output ends up in a Test directory (or the other way around). Is it somehow possible to have a single Choice-Parameter, that influences which database connection is selected in the database connection parameter? I know I can use the ${} notation, but that does not see to work for a database connection.

Hi, I have a problem that is bugging the *** out of me. By know it's a question of FME pride since I assured my colleague that FME was the way for this :) I have a rather sizeable SQL table containing measurement data from gauges. It is listed in a fairly common way (described by the attached picture). For analytical pictures I would like it to turn the attribute "name" inte columns that have their value displayed for each time step. This is for data analytical reasons.  I have tried with attribute pivoter without success, working with lists, creating a structured table than make a join. The problem is that the amount of names is so large that I can't make any manual type-ins for name etc. It has to be dynamically otherwise it won't work Please, any suggestions or will I have to admit defeat and hand it over to a sql colleague. It will give him alot of work (and also he will laugh in an evil way). Thanks in advance

The line combiner when used in 2018 and 2021 behave differently for the same input data. In 2021, the output does not correlate to the explanation on the FME help.  For the following dataset, the output expected is as shown in the 2018 output screenshot however, for 2021, despite the configurations being set as per the result which is expected does not yield the same results. It appears that for some reason the duplicate lines(?) are not merged as expected. In the example below, K1, K2 etc. are kring_id and the numbers are _overlap (As set in line combiner)  The help states that duplicate lines are accepted by the line combiner for 2018 and 2021. Here are the transformer settings from 2018 and 2021 that are used in the workspace.  2018 - Break Across Attribute ValuesIf this parameter is set to Yes, two lines with the same values for the attributes selected above will not be combined if the node at which they meet is also connected to another line with different values for these attribu

I would like to be able to populate a user parameter dropdown choice list from the results of a sql query and/or stored proc every time the workbench is run. As in, the dropdown choices need to always be able to reflect the database results every time. This seems unusually difficult to do. I need the dropdown to always reflect whatever the latest values in the database are, every time the workbench is called. Using Workbench 2021.2.1.0 (20211203 - Build 21797 - WIN64) Any help is greatly appreciated.

Hey there,So i've modified the Data Downloading script on FME Server and am having some issues exporting to a dwg with object data. The script lets them pick from a tree list what to download and then export to DWG and it completes fine but the issue is if I only download one layer, say contours, its including every single feature class as a layer in the DWG even tho its empty. I can see it creating object data during the FeatureWriter process.  Is there an option to not include layers if they're empty im not seeing? thanks for any help.

Hello,I wish to copy polygon data from SQL DB to ArcGIS Online. The only way I have found that seems to work is in attached image. Having to delete the data before I can insert the update seems incorrect albeit appears to work.I assume there is a better way?Thank you

I have a raster with downpour data (with water depth in different areas) and a vector layer with sewer pipes data. I want to know the maximum water depth of a sewer pipe. I have found an ArcGIS Analysis tool called Sample, is there anything like that in FME?https://pro.arcgis.com/en/pro-app/latest/tool-reference/spatial-analyst/sample.htm

I have FME workspaces deleting and writing records to the StagingAddress table in an ESRI GeoDatabase. For every agency, the STAGINGADDRESS table is purged using the DatabaseDeleter transformer and then the subsequent workspaces insert records into the STAGINGADDRESS table and then transferred to the ADDRESS table. This process is repeated for multiple agencies.For every cycle, the purging part with the DatabaseDeleter transformer takes the most time.Can I use some other transformer to speed up the purging part? How about using SQL Executor? I am not sure if it will cause any issues, hence asking.

I have multiple layers in my GDBI know I can get the correct projection using share from arcgis pro, but I don't have an arcgis pro subscription for this account, only arcgisonlineI will need to keep updating the layers keeping the projection in arcgisonline 28992 thank you in advance for your help

HiI am using fme to work out the spatial relationship between two polygon datasets. Some requesters will have multiple suppliers and I have enabled the list to store the references for each supplier. Following this transformer, I have use a list concatenator to show these references in one field. This works great when I have only one predicate selected. Where multiple are selected, I have created a second list concatenator for the relationships{}.pass{}. Unfortunately, both these can contain different number of values. For example, there could be two suppliers, but one of these could pass intersect and within and the other just intersect. My difficulty id knowing which pass attribute relates to which supplier. Please can someone let me know what I am doing wrong? Many thanks 

What is the order of operation for fme_db_operations when sending the results to a writer?  If I have a feature counter attached to the Unchanged Port of the Change detector and test the number of records, can I analyze and terminate the workbench before the Deleted, Inserted, and Updated records get processed in the Writer?