Transformers

Hi,I want to insert or replace a json document in a collection using PUT and mongodb_id with a Featurewriter.If the document don't exists, no problemeIf the document exist, there is an errror message: E11000 duplicate key error collection: fdppma_dev_pdpg.Couche index: _id_ dup key: { : ObjectId('62b01e134c2300007e0001a5') }: generic server error I believe that Put delete the object before insert it. Someone have got an idea ? Thanks 

Hello, How to remove inner boundaries of polygons?  For example, on the screenshot above, I would like to remove the central part of the selected polygon so that it does not have inner boundary anymore. Thanks!

I am attempting to convert the date format of an Esri layer file and am met with "The loaded plugin's FMEPluginCapabilities 'LogCount_func' has changed the process locale to 'English_United Kingdom.1252' which is incompatible with FME 'English_United Kingdom.utf8' locale. Please see 'pluginbuilder/cpp/fmeplugincapabilities.h' documentation"https://www.safe.com/support

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"><Cou

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 lstAt

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)"

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'} 

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 al

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

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.  

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.