Transformers

I have a template with differents divs with id and class, I want to delete or remove them with javascript code, I am not sure if I should use javascriptCaller or if there is another way to do that, if javascriptCaller is the right way, how can I do it? if not what the other option is and how I can do itThanks

Hello,Is there a method to combine a STANDARD TEXT with the VALUE of a PARAMETER and use thia as the NAME of an ATTRIBUTE?The value of the parameter varies with the loop.Ie:TEXT : DAYS_PARAMETER-VALUE : 2017, (next time) 2018, , (next time) 2019 So I want to name the new attribute:- the 1st time: DAYS_2017- the second time: DAYS_2018- the third time: DAYS_2019- ...etc. The value of the attribute is calculated by DATE_END-DATE_START in days.So the output looks like this:NumberFile DD_START DD_END DAYS_2017 DAYS_2018 DAYS_20195124 20180101 20200131 0 365 31 Please response if it is not possible to make an ATTRIBUTE_NAME while looping with parameters.(I also tried the AttributeDereferencer and attribute exposer and other transformers without succes.)Thank you,Perry

Hi,I want to create a custom transformer that concatenates the elements of a list entered as a parameter. This list is like: elements {0}, elements {1}, elements {2}... elements{x} and contains words. The start index is also an input parameter. As the number of items in the list varies, I created a loop where I get the index of each item.My problem: my list $(_ list) is a parameter and I don't know how to call its elements to add them to the string I want to build.Can you help me?Nicolas

I have a Workspace with a CustomTransformer that get Input values, Uploads file via SSH to a MFT (managed file transfer, fancy ftp server), generates a unique link for downloading. I can't use WorkspaceRunner/FMEServerWorkspaceRunner, it can accept Input values but only returns a basic successful but not the unique link. I started to create the FMX so I can save the CustomTransformer on FME Server to be used as a LinkTransformer. I'm not worried about users using the CustomTransformer, but I would prefer users not seeing the password for the upload accounts.  QuestionI there a way for me to scramble the password so the users of the CustomTransformer can't see the password?ORWebhooks and create an API so it could use by anybody?The idea would be any FME Workspace that needs a file upload would HTTPCaller, FME Server URL address (Webhooks) with Query String of Input values and then I think a Data Streaming Service to get back a JSON or HTML?Can Webhooks be use without a Token

Adding cost attribute : i have specific attribute and i would like to find the path that has the lowest value of this attribute ,even if it is shortest path or longest path ,does not matter of the length .i tried to use Cost type by one attribute ,i did not get any paths so i used by two attributes and i get output but it goes through two paths . one path has cost attribute=30 ,and the second path has cost attribute = 60 ,i did not understand why it goes through this path that contains 60 . i thought ,it will goes only through path 30 . secondly ,i was watching videos about shortest path finder and i did the same parameter for attribute value mapper but i did not understand why should i make the parameters like that ,default value 2 ...why will be better for Cost to use two attributes instead only one attribute ?i need only to get one path that contains lowest cost of attribute ,how could i achieve that and does not matter of the length ? the network is noded correctly ,because i used

Hi, I have 399 polygons that I want to dissolve on their nearest neighbour. I'm using the spatial relator to create an id between the polygons to be dissolve and the polygon they will be dissolve on. In the vast majority of instances when I run these polygons through the spatial relator it works. For example if a polygon to be dissolved touches another polygon it will get a shared id. But in some instances where I can see that the two polygons are touching I'm not getting an id created between these two. Would anyone have any idea why this is happening? I can share any details through screenshots, just ask.Thanks for any help. B

So, I am working with a river linear dataset. I am assigning an ID to every river that all of the unique features of the river share. But, the issue that I am having is that there are some general names and one name is shared between 50 different streams (that contain 350 features). I located most of the using NodeValence and FeatureCounter where I group by name and valence 1. However, I cannot distinguish with 100% certainty which rivers are different even when they share the same name so that I may assign them different river IDs. I would need to include coordinates or similar. Any idea?  So, I am using the aggregator to aggregate by name, creating a list of unique IDs and appending the same ID to same named features. But the problem is that some same-named features are actually at different locations so I need to separate these and provide a separate river ID.

Hi, I have several XML files with the following content: <gmd:contact>  <gmd:CI_ResponsibleParty>   <gmd:organisationName xsi:type="gmd:PT_FreeText_PropertyType">    <gco:CharacterString>Information in main language</gco:CharacterString>    <gmd:PT_FreeText>     <gmd:textGroup>      <gmd:LocalisedCharacterString locale="#ENG">contact info in English</gmd:LocalisedCharacterString>     </gmd:textGroup>    </gmd:PT_FreeText>   </gmd:organisationName>  </gmd:CI_ResponsibleParty> </gmd:contact> I will like to add contact in other language, for example: <gmd:contact>  <gmd:CI_ResponsibleParty>   <gmd:organisationName xsi:type="gmd:PT_FreeText_PropertyType">    <gco:CharacterString>nformation in main language</gco:CharacterString>    <gmd:PT_FreeText>     <gmd:textGroup>      <gmd:LocalisedCharacterString locale="#ENG">Cont

Hi, this is a really basic question, but none of the other answers I've read have quite fit. What I want to do is simple - find the percentages of these two values:The answer would be NoBlank - 78.22% , BothBlank - 21.78%I'm aware the trick is to find a way to sum the Individual ID.total_count column in the Expression Evaluator, but "@sum@value(individual ID.total_count)' doesn't work, only returning the original values.  This so frustrating because I'm sure it's very simple.

New for FME 2020.1 is data-aware transformers. When data is cached via Run with Feature Caching, the attribute values can be retrieved from within specific transformers. Retrieval of these values will prevent any data integrity issues that occur with spelling mistakes and makes the workflows faster as you don’t need to keep viewing your data to get the value you want to test for or expose.  This feature is currently available in the Tester, TestFilter, AttributeExposer, and anywhere that test clauses are used.  How to Use this Feature1. Ensure that you have FME Desktop 2020.1 or later installed. Then read in your data. Run the workspace with feature caching enabled. This step is key!   2. Add a Tester, TestFilter, AttributeExposer, or any other transformer that uses test clauses. Once connected, open the parameters. In the parameters, select the Left Value attribute. For this example, I’m using Common Name. Then select your Operator.  To retrieve the cached attributes, click on the dro

For example, the user has selected 4 dates in this order:We wish to retain this date order for the output table, but after running the formatted dates through the AttributePivoter to set the dates as attributes, they come out in alphabetical order, as follows. Note that dates 3 & 4 have switched. The order of attributes should be Jun 2019, June 2020, Sep 2018, Mar 2019.Has anyone managed to deal with this issue?Thanks in advance :)

Hi, I want to count values for individual fields in excel. There are 110 fields. I want total counts column by column for all values that are not missing, empty, or null.

Hello,I have a little problem and I hope you can help me.I use the transformer xmlTemplater. It works fine. But there is one problem:If I insert an attribute with "<" or ">", the Transformer will change it in "lt&" or "gt&". Is there any option, that the transfomer doesn't change the attribute?

Dear community I have just started using FME. I have an excel sheet with some x,y coordinates in the danish s34 (DenmarkS34-S) that i need to reproject into ETRS89 zone 32. I have tried using the attributereprojector but the coordinates i get are incorrect. I have also tried the csmapattributereprojector, but i cannot find that particular transformation.  I hope you can help. Regards--Rasmus

I have a list of connections (ServiceID) that are attached to a main (MainID), that are grouped by a network ID (NetworkID). There can be one or more connections to a single main, and there can be multiple mains in a network. See example -I need to list out the mains with all possible service connections within a network. Each main ID would have all connections within that networkSo the above example needs to turn into this -I thought I would be able to use a feature merger, or joiner, grouping by network ID, with both requester and supplier coming from the same table (kind of like a many-many join) but that doesn't seem to work. Maybe my parameters are off, but I am not even sure if my logic is on the right track. I am somewhat new to FME. Any suggestions would be welcome!!

Hi everyone,I really appreciate the data inspector for z visualization of point cloud, but I can't find a way to plot or see a color bar / color scale to easily read wich values are associated with wich color. Is there's a way / trick to do this ? Thanks !

I have a folder with soil shapefiles. The schema all vary slightly and I want to merge them into a new schema. I can only connect one field to the output field. So for example, here I want to have 'PCT_A' and 'A' loaded into the output shapefile 'PCT_A' field. Can this be done?

Hi everyone,I have an output from a PointCloudCombiner with 4 components (x, y, z, _distance). The _distance attribute comes from a NeighborFinder. What I want to do with the point cloud is to replace the z component of each point by its _distance value. I tried to use the PointCloudExpressionEvaluator after the PointCloudCombiner but _distance doesn't appear in the component list. I only have access to it as an attribute (not a component) and then get the same z value for each point of the point cloud... But when I check the PointCloudCombiner output in DataInspector I can see by clicking on each point that there is a _distance component that changes with each point. How can I have access to this component for further processing ? Thanks !

I have a feature type of polygons, namely A, and want to use it as the candidate in a SpatialFilter against another feature type of polygons as the filter, namely B. B consists of a few groups of polygons, each group has an unique group name. What I want to achieve is like looping through each group of polygons in B as one filter against the same candidate of polygons of A. I see the SpatialFilter has a "group by" parameter but it requires both the candidate and filter having the same group names, which is not the case here for the candidate. Seems a simple and reasonable scenario, but I can't figure out a way to do this. Any advice or hints are welcome.

hello,I am trying to write inside an xml file elements only if a feature attribute has a value.I have 2 shp files :In first file I have "Eticheta" feature with names of the street.In second file I have "label" feature with attributes values are the same as "Eticheta " from the first file. Here, in the second file I have also "NR" which. I am trying to write in XML numbers for streets and I need to write the numbers on each street.I used an if-then-else statement that writes out the numbers only if street from first file is exactly like street from second file. in my XMLTemplate, in subtemplate I have: { if( fme:has-attribute({fme:get-attribute("label")}) eq fme:has-attribute({fme:get-attribute("Eticheta")}) ) then {fme:process-features("ADRESA")} but fails to write data inside xml file.errors from log:XMLTemplater (XMLTemplaterFactory): An error occurred while parsing the 'ADRESE' sub-templateXMLTemplater (XM

Is there a way to get AreaBuilder to produce results closer to Pro's geoprocessing? It seems that whenever I give FME lines similar to the example below, it builds one polygon and calls it a day unless I specify an absurdly high snapping tolerance, in which case it produces garbage (e. g. a 1m tolerance would create a small extra triangle in the middle of the northern line where the small /\\ is, but still leave the large area empty; 5m would create a large jaggy polygon. The example is roughly 100m across, btw.). The polygon parameters have no effect, neither do the snapping types. The lines are 2D, I've also included a 2DForcer before the AreaBuilder to make 100% sure it doesn't even get Z coordinates, but to no effect.​Pro, with all of the line vertices displayed and filled areas (three separate polygons, as expected):FME, with one polygon ☹

I managed to generate a new json from the original one getting the info I need but now I see there's some missing data.Each project group has an id, lat-lon info and an array with data for every project inside the group.I generate a new json with a feature for every project but need to also add a feature for every project group without projects in it.This is what I have:[    let $doc := fme:get-json-attribute("_response_body")    for $i in (1 to jn:size($doc))        let $id := $doc($i)("id")        let $lat := $doc($i)("lat")        let $lon := $doc($i)("lng")        let $proj := $doc($i)("projects")        for $j in (1 to jn:size($proj))            return              {|                {"id" : $id},                {"lat" : $lat},                {"lon" : $lon},                {"proj_name" : $proj($j)("name")}            |}]I've tried to nest an If statement to check when $proj is empty but it throws an error.  

Hi,I would like to use System Caller to run an ili2fgdb command (http://www.eisenhutinformatik.ch/interlis/ili2fgdb/). The command works in cmd but not with System Caller. Does System Caller only work with .exe and batch files? Here is my command:"java -jar "C:\iliTools\ili2fgdb-4.4.4\ili2fgdb-4.4.4.jar" --trace --proxy xxx.xx.xxx.ch --proxyPort 8080 --schemaimport --defaultSrsCode 2056 --fgdbXyResolution 0.00005 --fgdbXyTolerance 0.0004 --createTidCol --createBasketCol --createEnumTabs --beautifyEnumDispName --dbfile "\path\BL_Natstr_oereb_20190514_SU_4_4_4.gdb" --modeldir "http://models.geo.admin.ch"" target="_blank">http://models.interlis.ch/;http://models.geo.admin.ch" --models OeREBKRMtrsfr_V1_1 --log "\path\BL_Natstr_oereb_Schemaimport_Log_4_4_4.txt""How can I execute this command directly in system caller?  Any help is much appreciated!Many thanks in advance.  

I am having trouble in FME to find the correct scale in model space to find the correct size of text when there are multiple annotative scales and viewports. In Autocad the text element has Paper text height and Model text height, as shown below in the screenshotThis text element is in multiple viewports at different annotative scales. When viewing the 2 different viewports in paper space, one size is correct (in this example 3.5 at 1:400) and one is incorrect (when looking at the 1:200 viewport). FME sets the text size in model space using the model text height value, but we have no way to know which Annotation Scale was used to calculate that which I can see? It looks like to workout the original value we need to be able to find the model space annotative scale (set in the bottom bar of AutoCad see image below)  or alternatively we need to know the paper text height value (which is consistent when changing Annotative Scale in AutoCAD). Are either of these values saved as an attribute

Hi All,  I was wondering if anybody has any experience with reading WMTS services via FME. Any help would be appreciated. Itay