Transformers

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?

Hi everyone,I’m struggling to change/update values of an IFC-file. Example:old PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 15  new PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 350 I used the GeometryPartExtractor to extract the IfcPropertySets from a IfcBuildingElementProxy geometry. Then I tried to adapt this https://community.safe.com/s/article/updating-ifc-example into my workspace. I used an AttributeCreator:ifc_property_set_name = VolumeQuantity = 350 After that I configured the GeometryPropertySetter and GeometryPropertyRemover. Unfortunately, the original PropertySet Volume will be deleted after writing. In the updated one, Position and Unit are missing. Is there a way how I can keep the traits of the original PropertySet and only change/update one specific value? thxNel 

Hi, I encountered something peculiar last week. I had to compare two datasets about chemical substances measured in groundwater.To compare the datasets, I used the ChangeDetector. While doing so, for one substance an update/change was found for the value of a CASnumber. However, when I look at the originalValue and the revisedValue, I don't see any difference. Also, when I perform a compare using (a plugin of) Notepad++, it also detects a difference in the two CASnumbers. So there seems to be a difference, I just can't seem to spot the difference ;) Maybe some people here can help take a look and provide an explanation? Any feedback is appreciated. The CASnumbers are:CASnumber_1 = '‎483-63-6'CASnumber_2 = '483-63-6' See also the screenshots below for a dummy workspace and the comparison using (a plugin of) Notepad++; 

Hello,I'm very confused, I don't find how to remove the two last elements of a address list and concatenate the other words.I think it's quite easy but even with the ListElementCounter, I dont find the answer!Thank for your help.

(i need to choose one dataset from many dataset in geodatabse)

I am reading some data from a ESRI based web GIS and need to convert them to DWG. The data contains XYZ data, but the Z-values are missing when opening the DWG in CAD-software.  I got Z-values before writing: This is my workspace: AutoCAD: How can I make sure the file contains Z values?

I m reading the data from Snowflake database and there is a date type in timestamp z (9) and when I tried to insert the data in MySQL is giving me the error Date/time string  Snowfleke Data Mysql Data Strcuture

Hi everyone, I have a workspace where I am trying to test some element attributes to see if they match certain conditions/values. So kind of like: Location: Melbourne (fixed for all elements in file)Asset type: various (varies per element) I have around 80 of these attributes to test. The tests parameters are contained in an Excel file, i.e. I have a file that has the following columns: Attribute NameAttribute value (either has a value that I want to check against if Fixed)Attribute type (contains term 'fixed' or 'varies') Other than writing each individual rule into the Tester, is there a more efficient way to do this, particularly as the parameter spreadsheet may update and I want to avoid re-writting all the tests? Thanks in advance for your help! Amit

I want to test my GML file against a schema to make sure that it is valid. To do this, I am using an XMLValidator transformer. I am not sure how it works.When I add a reader for my GML file, it loads all the different feature types. I also selected my .xsd file containing my schema. Connecting these to the XMLValidator goes excruciatingly slowly and everything seems to fail anyway.If I select my GML file as the "XML Filename" parameter for the XMLValidator, and then my .xsd file as the Schema Location (Validation type "Syntax and Schema", and then unconnect the Feature Type readers, it seems to work, but I have inspectors connected to the "Passed" and "Failed" ports on the XMLValidator and nothing seems to go through either of them, even though the workbench runs successfully. Am I using it right? 

For example, I am splitting 'label' - TCY/D/N3000000. In this case, I only need the 'TCY' to be part of the list. I have multiple labels with different values instead of 'TCY'. I then need to display these as row names in Col A. upon writing to Excel as below: (Col B should count how many 'TCY' labels in the dataset. DA_List CountTCY 150BGS 20CUR 50