Transformers

Hi, I have achieved the below XML using the following xquery in an XMLUpdater: XML: <base>  <level id="Level-1"/>  <group id="A" category="line">  <section id="A1">  <definition>  <edges>  <edge id="110992"/>  </edges>  </definition>  </section>  <section id="A2"/>  <section id="A3"/>  <section id="A4"/>  </group> </base><base>  <level id="Level-1"/>  <group id="B" category="line">  <section id="B1">  <definition>  <edges>  <edge id="128677"/>  </edges>  </definition>  </section>  <section id="B2"/>  <section id="B3"/>  <section id="B4"/>  <section id="B5"/>  </group> </base> XMLUpdaterUpdate Type:

Hello all, I have a series of flow paths along a network, each with a unique ID. I want to essentially produce an elevation profile graph along each path by sorting the data and writing into an excel template.I have split the single paths at each node, and linked the elevation of that node to each _from_node and _to_node. However, i'm struggling to figure out how to sort the data in the order of the path. Each path doesn't follow the pattern of Node 1 - Node 2 - Node 3, etc. Some will jump around, e.g. Node 1 - Node 2 - Node 13 - Node 7, and so on.The information is contained within the _from_node and _to_node attributes, but i cant figure out a way to sort this data, apart from possibly using an indefinite number of joins on the _from_node and _to_node attributes.Any ideas would be greatly appreciated!Thanks!Jack

Hi all,  Can the AttributeManager perform operations like the StringSearcher?  I would like to extract certain strings from an attribute called RAW_DATA, I'm looking for the value in "value="xxx" e.g. <span class="store-card__value">Mon-Fri 09:00 AM  - 09:00 PM </span> <span class="store-card__value">Sat 09:00 AM  - 06:00 PM </span> <span class="store-card__value">Sun 10:00 AM  - 05:00 PM </span> </p> </div> <div> </div> <div class="store-card__section"> <a class="store-card__action" href="/teststore.com">Store Details</a> <button class="btn btn-tool store-card__action storeSelectButton selectCategoryStore " id="selectCategoryStore_699" name="699" value="699">Store</button> </div> </section> </li> In a StringReplacer I would use RegEx like value=\"\d{1,3}\" to get what I need. I have to perform a bunch of operations like the above one so I'd rather keep everything in one Attribut

Pretty sure someone has this resolved. But I just could not find a clean solution to a seemingly basic request...Before we do an overlay operation of Layer A and Layer B, we need to first test if their CSs are the same. If they are not, Layer A needs to be reprojected to the CS of Layer B.CoordinateSystemExtractor is used to extract CS as "Attribute" from the two respective layers. But that was how far we could go: A - How can we compare the CS when the two CS Attributes are in two different datasets? B - How can we set the "Destination CS" parameter in the Reprojector transformer of Layer A to point to the CS Attribute from Layer B?Thanks!

I am using FME workbench plugins in ArcGIS Pro to translate my IFC to Shapefile, where after I assign a coordination system for London it shows many projection error. So, how to solve it? Is there any solution for it? 

hello,i am confused a little bit ,how can i use FeatureMerger correctly.I have two excel on my workspace ,Excel A : has three rows but one of them is duplicate from Excel B ,and two rows not .Excel B has 50 rowsi want to merge Excel A with Excel Band if we have any duplicate row (i mean the one of Excel A) ,remove the duplicates and keep the rest of rows .so As a result,i need to have Excel that contains 52 rows .i read alot the Documentation but iam still confused in adjust properties of Featuremerger ,i will be thankful if someone help me .thanks 

FME 2018.1.1.2 Is this expected behaviour? I've set 2 Lists to be removed from the WorkBench features by AttributeManager. Opening the Partial Results of the Output Port in Data Inspector, they are indeed removed.Yet, in the very next Transformer (happens to be TopologyBuilder) the 2 Lists reappear again on the Features when the Output Port is inspected in Data Inspector, complete with the original list values? Not only that, but trying to remove them with a subsequent AttributeManager, AttributeKeeper etc. does not work, because these Transformers don't think that either of the Lists exist anymore in the Schema and hence won't appear in the selection of Attributes/Lists available to modify! These Lists continue down the Workflow in the Partial Results but remain invisible in the Schema. Further, if I replace the AttributeManager with an AttributeKeeper, the Lists stay removed (and I guess is a workaround?). I'm guessing this may be a bug in how AttributeManager tries

Hi,I have a bunch of JPEGs taken with a drone that contain spatial information within the embedded exif.I am trying to enable each JPEG with the end goal of georeferencing them so that they can be made into a mosaic. I have tried combining transformers such as the PhotoCoordinateExtracter, CoordinateSystemSetter, RasterGeoreferencer, and the RasterMosaicker to no success.Also tried FeatureWriter to GeoTIFF then FeatureReader to no avail. When I drag them (JPEG or GEOTIFF) to ArcGIS for example, they all occupy the same space.What is the best workflow for this?Cheers

Hello,I would like to tranpose my data into a new table format. I found a similar post here https://knowledge.safe.com/questions/88862/transposing-data-into-a-new-table.htmlBut I am not able to get the result I want. The main difference is that I have much more columns and rows than in the post I mentioned above.The dataset I have:DBKAlCl...10.151.1...20.201.2...30.251.3...............With the 3 dots I want to indicate that it is a large amount of data. So much more columns and much more rows as well.I would like to get the following format:DBKParameterValue1Al0.151Cl1.11......2Al0.202Cl1.22......3Al0.253Cl1.33............... So the three dots indicate that there are much more parameters for each DBK and there are also more DBK's.In the post I mentioned above they use an AttributeExposer at the end. But I don't know how to use the AttributeExposer in my case because I cannot mannualy enter all the different values due to the large amount of data.Does anyone have a solution for

Hello!I am wondering how can I use FME to analyse graphe?I have points that represent a surface and I would like to analyse these surfaces with local maximum and/or minimum. But the surfaces are not always simple, some of them is almost like a line, but some of them are like a roof - as represented on the picture.Is there any way to fit a line to these points, and analyse the parameters of these lines, like determinant. Or is there any algorithm that could compare these generated lines with sample functions?Do you have any advice?

This one is already solved. Writing is for documentation only as I could not find the solution here.I had to debug a workbench from a coworker which was failing with the following error:WARN  |ChartGenerator: Non-numeric input provided.  Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericFATAL |f_24(PythonFactory): PythonFactory failed to close properlyERROR |f_24(PythonFactory): A fatal error has occurred. Check the logfile above for detailsDue to the log pointing to non numeric input in the ChartGenerator it took me some time to find out that the error was caused by something different: One of the attribute names used in the ChartGenerator in the "Y attribute" contained a space.I tested this in desktop 2017.1.1.0 / 2017.1.1.1 / 2018 beta (build 18220).This is a known issue and filed under C133238.

Hi there, I am applying a filter on record using tester transformer. My test clauses contains multiple And/OR conditions. I have attached screenshot of the test clauses. The problem is tester does not filter the record the way I wrote the condition. For example, I dont want to include the record in which CAUSE attribute has value 2A or 2B. However, in the tester passed category contains the record that has CAUSE value of 2A or 2B. Similarly, I do want to include the record in which the description attribute contains the value "BLOWN LV FUSE". However, passed category does contain those records. Could anyone guide me where am I making the mistake?

I would like to use an attribute value for a new attribute name using the Attribute Creator transformer, but this just not working. The new attribute is not created even if we can parameter the Attribute Creator to do so:I am using FME 2018.1.0.1 64bitsI have found this old question with the same issue. According to the accepted answer, the issue was suppose to be fixed in FME 2017. So is the problem fixed or not?

I am working on a project where I have to create maps. I have a file gdb and a personal database .mdb. Everytime I have to create a map I have to join them. Is there any way that the .mdb file can be just linked to the .gdb file so I dont have to do the join operation? Is there a way where the attributes that are stored in the .mdb file are just incorporated in the file geodatabase without doing the join operation?I further intend to convert the file geodatabase to a shape file, such that each feature layer has its own attribute table.Any help willl be much appreciated. Thanks in advance!@takashi @david_r @redgeographics

Hi All, I have date values in five columns, however, not all rows have date values in all five columns. For example, row 1 has values for columns 1, 2 and 3; row 2 has values for columns 1, 2, 3 and 4; row 3 has values for columns 1, 2, 3, 4 and 5; row 4 has value for column 1 only; and row 5 has values for columns 1 and 2. The rest of the columns not mentioned in each row have <missing> values.I want to create a new column called DATE and populate it with the last date before a column value of <missing>. For example, row 1 will have the date value from column 3; row 2 from column 4; row 3 from column 5; row 4 from column 1; and row 5 from column 2. Thanks for your help in advance.RowDate1Date2 Date3 Date4Date5 DATE114/01/201815/10/201916/01/2020<missing><missing> 16/01/2020219/01/201513/01/201711/01/201801/01/2020<missing> 01/01/2020 318/01/201415/10/201511/01/201601/01/201910/01/202010/01/2020 417/01/2020<missing> <missing> <missing> &l

Hellosorry for my EnglishWe want to create a modifiable client web so that the departments are able to create, modify or read on a single map which will be fed by the drawing departmentWe create layers and attributes in qgis to be able to create and modify it's addition in the client web.The dwg is only for reference in the web client editable web client (lizmap) Other departmentsqgis connects lizmap with linux server ..postgisautocad map (drawing dwg) Drawing department I would like to take a dwg which is still in production by the drawing department ... which will be visible in the client web ...My problem is that the dwg is not compatible with qgisIs it possible to send dwg in postgis .. so that I can retrieve it in qgis .... for which can be displayed in the web clientUnless you have another alternative I don't know if FME products will be a solution for me dwg to postgisBe specific in your answers

Hi, I'm trying to extract the table from http://skpos.gku.sk/en/stanice.php with HTML table reader or an HTML extractor but in the output I only see the column headers and there is now list I could explode further. How can I get the complete table? Thank you for your help!

Hello,I would like to extract attributes from a text file. The texfile contains different attributes separated by comma (,). It is like:104.474,104.474,649621.0654572968,245370.49979405673,0,0,146I tried this regex , but it gives back . delimited values (like: 474,104)(\\d+)(,\\s*\\d+)*Thanks!

Hello,I am overlapping a set of points on a combined raster from 200 previous ones and then exposing obtained values as attributes. However I want to get the attribute names as FME_Basenames (fig 2) and not as shown in (fig 1). Is there somehow how to to do ? Thank you very much(fig.1)(fig.2)

Hi,Any ideas how to generate a 3D footprint of a 3D object (e.g. solid)? Z value of the vertices of the footprint not zero.Something like deaggregating a 3D object to all individual surfaces and selecting only the locally lowest faces...Jasper

Hello everybody!I have a process that on ine libe calculates some values and write out in a text file. On an other line a system caller usues these files as an input data (with lascontrol command).I would like to know how can I define to delay these seconfd line until the file writer is not ready. 'Cause now the command gives back an error like: there is no input data (so the textfile).Here is a screenshot of the process.

What I want: changing temp location on the server with the FME Server express installation.  Last week, I installed FME server "express installation" on windows server and added a seperate engine also on a windows server.I added on both servers an FME_TEMP environment variable with a reference to another "temp disk", and restarted all the services on both servers. The seperate engine machine is writing the temp files verry well to this location, but the server with the "express installation" not. What can I do more to changing the temp location for this machine?

How to remove spaces in between numeric values.like belowBeforeI need like this0 909a 1 2 ga 12 ga125a125a 1 ba 1 ba 12 5 ba 125 b  

Hi there, I have a record that consists of 10 attributes/columns. I want to remove duplicate from the record. The duplicate would be based on the value of 5 attributes. When I say duplicate, it means that reduce the number of duplicate records to 1. I read the existing thread on the forum where someone recommended to use Matcher. However, Matcher categorizes the record into duplicate and non-duplicate. I don't want categorization. I want to reduce the duplicate records to 1 record. I also tried to use ListDuplicateremover, the problem in that was it only showed the name of one attribute. Any suggestion

Hello!I have some problem, how I can transform 3D surface (roof) to 2D surface? I want to do something like that:I used 2D forcer but I got different results area surfacace (3D and 2D), Maybe I'm using this function incorrectly??