Transformers

Dear All, in the attribute "id" I have strings that have the following format411d8e4d-2de6-0f5b-e100-00000a4c0a0dI would like to remove the dash in an AttributeManager (I know, I could do it with StringReplacer). I've tried the following formula :@ReplaceString(@Value(id), "-", ""))but it does not work (id remain unchanged), whereas the formula with FindString here below gives the expected result (8).@FindString(@Value(id),"-") Why the FindString is working but not ReplaceString ? What am I doing wrong ?I was also able to do it in the regular expression-way, @ReplaceRegularExpression(@Value(id),"\-","") but I don't understand how ReplaceString works. Has anyone an explanation ?Thanks in advance

This might be an easy one but i could not find a way around it, I have two files File A (lines with geometry) and File B CSV file(lines without geometry). Both files have ID,START,END columns as shown below. So i was wondering how can i merge them on ID as the first key and also specify the range of the start value as the second key, (any other approach is welcomed)so what i expect is the first two values of FileB be given geometry from the first value of file A, and the third value of FileB be given geometry from the second value from FileA.Thanks ,Keller.

Say I have data like the following;sequence_path (string: UTF-8): 1.2.3.4As a result I wanted to fetch the parent from this sequence_path (i.e. '1.2.3'). In order to do so I wanted to do the following;Use a reverse search to find the position of the last '.' in the string, Fetch the (Left) substring up to the position of this last '.' To perform the first step, I thought to use the FindString() string function (with a negative startIndex). So, at first I thought that @FindString(@Value(sequence_path),.,-1) could be used. However, that returned '-1' (not found). However, somewhat unexpectedly at first, I noticed that '@FindString(@Value(sequence_path),.,-2) ' did return the desired value. Upon second reading of the 

Hello, I wish to write to a specific version in a versioned feature dataset, by default the arcgis portal feature service writer writes to the SDE version aka the main/base version. Where can I configure which version the writer will write to?  Thanks.

Hey there,I have to download several CSV Files from a website. I do it with the HTTPCALLER Transformer. It works perfect. I get ALL the data (several columns and lines) in one "cell":I need the informations in lines and columns, so that I can manipulate the data. I have tried with Pythoncaller, ListExploder, AttributeCreator,... but it doesn't work.Do you have any idea, how can I get that? I think the problem is the configuration of the HTTPCALLER or of the other Transformers but I have tried a lot of things and nothing works. Many thanks in advance! 

I have two POST API calls to the Microsoft Graph API in my workspace. The workspace functions as intended on desktop ,but when I upload it to FME Server the POST call on the second HTTPCaller will fail saying that there was no token provided (message below).  "message":"Access token is empty.","innerError" How can it work on one POST call and not the other when its using the same Web Connection? Also why is it functioning fine on desktop and not FME Server?  Thanks

Hi Darren. I'm a new user of FME and am interested in your 2014 post about translating to DWG as 1km grid squares. Do you have anything you could share that would help. I see in the post you say you got it working. ThanksChris DickinsonNorth Yorkshire County Council

PDF to SHP with Text embodied in pdf

The error message shown is "XML Parser error: 'unable to open primary document entity '\\1_Src\\Bag\\Inspire_data_NLD\\9999STA*.zip''Failed to obtain any schemas from reader 'GML' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. "

Hi all I have buildings polygones with height attribut. when the height was calculated some of buildings were cutted in two. So now, I would like to dissolve those buildings and keep the max height of both. I can dissolve easily because they share an identificator, but I dont know how to keep the maximal height of both.  Thanks you all

Hmm, I am struggling with this for a day now and I tried the tutorials, but it seems I am doing something wrong.So, basically I have an xml file out of which I want to put certain elements into an Excel output. But here is the issue.I want those outputs in a certain order - and no matter what I do, FME will always write the columns into alphabetical order. Which just will not do for this application. The transformation is a simple one: But somehow I always end up with the same output.As You can see, I already renamed the attributes with the numbers, trying to sort it that way, but no matter what I do, the output then looks like this:(Also with those weird widths for those columns)

I am upgrading from FME Desktop 2016 to 2021.2. I am facing a issue with my FME script, getting error as "SCHEMA_DATASET" not found. I don't want to supply data set sometimes so haven't fixed it's value. In my script I have only one schema reader and it is causing issue as I see I can't give null dataset to it.I have tried enabling "Ignore Failed Readers" to yes and "Rejected Feature Handling" to continue translation.Any help would be appreciated

I added a FMW file that shall create a PDF page with the names Arnold and Sylvester. It creates the page but with nothing on it.

Hi,I've a polygon feature with an attribute "LEVEL" containing values from 1 to 10.The polygons can be overlapped. I want to dissolve the polygon grouped by "LEVEL" and only keep the polygon with the lowest "LEVEL" value. It's easy to dissolve the polygon grouped by "LEVEL" but how to only keep the polygons with the lowest value ?Here is an illustration of what I'm trying to do, the number correspond to the attribute "LEVEL": 

All,Need some help. I have a httpcaller hit a webpage but the package it brings back is only a partial response body. The first file attached is the response body from the HTTPCaller and the second is from copying the html using the Chrome developer tools. Do I just have a setting wrong?  Using FME 2021.1 with the default HTTPCaller settings for 'Get'@Takashi Iijima​ 

HiFairly new to FME!I have connected to my AGOL account and downloaded the data through the AGOL reader. I wish to change the date format from the AGOL default yyyymmddhhmmss.sssss to something more sensible i.e dd/mm/yyyy hh:mm:ss I have tried using the DateTimeConverter to output but whatever combination I try the Attribute (Survey_Date) stays the same. Any help or advice would be great

Corrupt GML file error Hello everyone, I am creating an FME script, the input data are DGN files and the output data are GML files.  I am using the "XMLValidator" transformer which contains a template file used as an example to model and structure the output GML file.  Here's my problem: I need to convert several DGN plans into GML.  1) : When I input the DGN plans created with the Microstation software, the 'XMLValidator' indicates no errors and the output GML file is correct and matches my expectations.  2) : On the other hand, when I input DGN plans created with TopoCalc surveying software, the 'XMLValidator' transformer indicates several errors: (see photo) - no declaration found for the 'featureMember'" element - prefix 'gml' can not be resolved to namespace URI". Error in QGIS when opening the GML

I have a workbench which takes two inputs - both are polygons. One clips the other one. After clipping I use aggregator to aggregate the polygons with same attribute and the output i want to write into a gpkg file as multipolygon. The workbench works perfectly if i write single geometry to gpkg or if i write multipolygon into shp. However it is not working with mutlipolygon in gpkg. I have tried many things which were suggested in the forum. But nothing helped so far.  Please let me know any ideas. I am out of ideas

I have a land records data set that has a beginning page and an ending page. Both are numeric values. I would like to create a list of all possible page numbers (integers) between the beginning and ending page number. Is there an easy way to accomplish this?

I have 2 feature types in my work space. One being a report from field staff that collects data on manholes and another being a shapefile containing a "master" set of manhole data. I want to match features from the report to the master manhole shapefile based on an asset number, then filter out the features that are outside the +/- 20cm e.g. if the master manhole data has a depth of 1.1m and the report has a depth of 1.05 i want to ignore it, but if the report had a depth of 1.3m i want it in my end result.  I currently have my 2 readers going into a FeatureMerger which compares the asset numbers and any matching are allowed through. I then have those merged results going to a ExpressionEvaluator which is subtracting the report depths from the Master manhole depths. All that is feeding into a .xlsx writer which produces a spreadsheet that i can look at and decide if i want to update the depth in the master manhole shapefile.  I hav

Dear all, Very simple question (sorry if it sounds naive, I am newbie to FME) : I would like to set to uppercase all attributes that start with a given prefix (or that match a given pattern). Is it possible to do that with the BulkAttributeRenamer ? Or what would be the ''cleanest'' way to do that without using custom transformers ? (NB : I know I could achieve this with a custom transformer (for example, inspired by this question), but I would like to avoid this kind of solution as then I face the tricky issue of having attributes that need to be dynamically exposed and I would like to avoid also the complicated things with schema mapping and so on...) I would

I would like some inputs if possible. I want to write several thousand of rows to a database (each of these rows represent a pdf file). I have created an attribute called 'status' that should have the value 1 or 0 based on whether the particular row has been written into the database. This should be a precaution if FME breaks down. Then it is possible to see which rows have been written into the database and which haven't.  I don't expect a complete answer at all but perhaps just some ideas on how to achieve this. Thanks in advance.

I have an FME workspace in which input from an DWG file is read and exported into an FGBD file. I am using a dynamic FeatureWriter. Whenever a Text feature is written to a layer whose name contains an Umlaut (i.e. ä/Ä, ö/Ö, ü/Ü), the translation fails with the following error message:"GEODATABASE_FILE writer: An unknown exception occurred" Very strangely, layer names with Umlauts are not a problem for any other feature type, i.e. Point, Line, and Area features all can be written to corresponding layers without a problem. (As another rather confusing side note, Text features can actually be written to layers whose names contain 'ß' which from a technical/encoding point of view should cause the same problems as 'ä', 'ö', 'ü'). Here is a screenshot of my workspace:

Hi,I have been using FME 2019.1 for some months now with no issues. But strangely now I can no longer view the cached features. I have 'Run' set with 'Enable Feature Caching' but when I click on the green magnifying glass and select 'Inspect Cached Features', nothing happens. There are definitely records going trough these ports... I have probably changed some setting but can't work out what it is!Thanks,

 <mdContact><rpOrgName>AAA</rpOrgName><rpPosName>BBB</rpPosName> rpOrgName is appearing at multiple locations in the XML file.How can I update its value from AAA to CCC for all of them in a single go without having to go to each element using Xpath.