Transformers

I need to take serial tabular data and join or pivot it to columns joined on the common field UniqueID. I've been reviewing joins and mergers but cannot determine how to create this transformation.The resulting data columns should be UniqueID, longitude, latitude, Cat1,...Cat9 Thank you,Gilbert

Hi Is it possible to read a portion of a Cloud Optimised GeoTiff using a bounding box? I'm trying to use the GeoTiff reader with the search envelope set but just get an "Error occured during translation" message after the Geotiff is opened.  Thanks Tom

The output needs to be a horizontally flat line that is built on the values from the measure field. I would also like to insert a vertex at every measure change.

Hi,I think the best FME Transfomer for such type of extractions is the "XMLXQueryExtractor", but I do not know how to build the query.The XML is contained within an attribute and could be something like this: "<?xml version="1.0" encoding="UTF-16"?><value xmlns="http://spec.tn-its.eu/schemas/"> <gml:measure uom="kph" xmlns:gml="http://www.opengis.net/gml/3.2">50</gml:measure> </value>" For that particular case, I wanted to extract that "50" value from that XML.Thanks!   

I have a model that has to select rows(points) out of a large collection of large csv files. To encrease performance I want to go throught them one by one. What is the best way to do this?

Hi Guys,I am not familiar with Land XML files .....but i need to get a geometry out of this files...i attached a screenshot of my xml format structure...there should be lines in it....but i don't know to do it....i did it with this xml_fragment attribute and Geometry Replacer or GeometryExtractor but nothing happened Thx for helpFranco

I have got data as below  AssetID X Y Z A. 0 0 1B. 1 0 0C. 0 1 0D. 1 0 1E. 4 5. 6F. 9. 8. 7G. 6. 9. 5  am able to extract max of each row min of each row  how to obtain medium of each row as simple as possible ?  am using @max ( value of x , value of y, value z)@min ( value of x , value of y, value z)  medium ?????( plz note it’s not average or median of 3 value ) It’s exactly absolutely value the same as it is in excel files.   

Hi, fellow FME:ers, this is an urgent matter! We just upgraded FME Desktop and FME Server to 2022.1.2. We have 100+ solutions in our consultancy firm building on the use of excel template files - *.xlsx and *.xlsm.  After the upgrade the output becomes corrupt.  Is this a know issue? Is there anything we can try to avoid corrupt files? Or do we need to go back to previous FME versions…I attach two example template files we’re using.Any help will be appreciated!Peter

Hello,I have a point cloud and I would like to get a buffer around each point (to apply an intersection with another mesh)I have placed the following transformers: PointCloudToPointCoercer to separate each point (output geometry: individual points) and then a buffer (buffer type: solid)The workbench works fine, only in the operation, somehow, I lose the georeferencingDoes anyone have a solution? Thanks

The FME ASPRS las file format 1.4 reader seems to omit withheld points. How do i import all points (including the withheld points ) and then use classification_flag to filter the withheld points in and out? The point cloud splitter doesnt give me classification_flag as an option, and the withheld points dont import via the reader (withheld points verified by lastools), and cant see a parameter to control whether withheld points are imported. Advice welcomed. Thanks in advance.

Hi All, I am using FME Desktop 2022.1; We have some GML files that FME does not read. I don't know why. Please help me out here. File is attached.

I have a workbench that creates points from coordinates then generates lines. I am only getting three sides of the polygon and I have not found a transformer that will close the forth side. Can you suggest a solution?

Hi, I would like to do something very simple. I guess. I have one feature in Oracle spatial with differents locations. The cities have one set of the code. Example: Paris (345) with 500 features, after Mumbai (346) with 4335 features. I want basicaly no have duplicated cities by code. I need even run again with Paris and delete all features with ID 345, and put the new features. Even like this, delete all stored line and insert the new lines if the ID is equal. Thank´s  

Hi there! I have about 30 different very long workbenches that we use for one very complex process. Every time we have a change, we want to be able to search in our list of transformers from each bench. Is there a way to generate or map out or investigate workbenches and have that list of all transformers from all of those benches?  Python, xml, anything will do. Need some ideas guys please.

I am using SpatialETL Tool for ArcGIS Pro

Hello, I'm new to FME. I found how to view AIXM data but I don't see a view option for AMXM? Is it possible?

Hi there,I need to run through a large number of GIS layers to run the rubbersheeter over and was hoping to be able to iterate through a list, rather than need to add the SQL Spatial reader for each layer. Is there a way to do this? Also I will be outputting the result to another database. I imagine I just need to read the input name and save out the output feature class. Regards, Josh

 Hi folks, I'm having some issues when setting a loop. I input a TIN in loop,and then I do some processing (smoothing). At the end I've set a parameter to match; if it doesn't , then I want the TIN to be reprocessed (with a new value for refinement).  I seems like the loop is not accepting a TIN as a trigger for the next loop, or this is what i understand from the log:   Loop to testLoop_INPUT1620857756 Input Splitter (BranchingFactory): Transformer/Factory testLoop_Clipper_5_Solid is blocking and cannot be used in a loop, but was found between 'Loop to testLoop_INPUT1620857756 Input Splitter' and 'testLoop_INPUT1620857756 Input Splitter' Transformer/Factory testLoop_Clipper_5_Solid is blocking and cannot be used in a loop, but was found between 'Loop to testLoop_INPUT1620857756 Input Splitter' and 'testLoop_INPUT1620857756 Input Splitter'testLoop_VolumeCalculator_9_GQuery (

Using an undetermined number of records as input, I want to process 20 rows at a time with an html report generator to produce a table, and then output pages of 20 rows each. I have a process that works, but it uses a separate html report generator for each page of twenty rows. How can I create a loop that outputs sets of pages with 20 rows ?

Hi.Do the later versions of FME support writing GML 3.3 ?I've read in the "Implementation Standard Revision Notes" from OGC, that "GML 3.3 builds on GML 3.2.1" (which is supported by FME), and that "All extensions are made in seperate XML namespaces".I hope that this means, that a GML 3.2.1 file is a GML 3.3 compliant file. And so I can use 3.2.1 in place of 3.3 whenever this is required.Can anyone verify this ?Cheers.

Hello,a while ago a user suggested to implement an "Option to control default sheet on Excel writer"Does anyone know if this is now possible ? I am writing an Excel file with up to 100 sheets and I want to force Excel to open the first sheet by default. Thanks.

Hello, I am trying to load in my gml data, however all attributes are coming into FME as data type strings, when i have even set the parameter obtain data types from xsd schema. I have also tried the xml validator and this thinks that all attributes are strings. Thanks, @Takashi Iijima​ @mark2atsafe​ 

So, the workflow is as follows. I managed to download a folder from a URL-adress and to unzip it. Next step is where I got stuck. I want to remove all record in my feature class (ArcSDE-database) and then I want to append the same feature class with the records from the shapefile that I downloaded. Anyone got any tips on which transformers to use?Super thankful for your help.

I have an ArcGISOnlineConnector transformer at the beginning of my workspace (initiated by a single Creator object), and the Content Source is set by the user as a group in an ArcGIS Online (AGOL) portal. When the workspace is run, the output from the ArcGISOnlineConnector is a collection of definitions for feature services, web maps, etc. within that chosen group. Those definitions and their attributes are exactly what I need for the main operation of the workspace; however, during processing (within a PythonCaller, to be specific) I need dynamically to access the Group ID parameter that was chosen in the transformer by the user. How can I do that programmatically? In the PythonCaller, which leverages the API for Python and the REST API, I generate an Item object (Python API) for each feature service, so I could use that Item object as a starting point for finding the group id. I have used fmeobjects a lot--but my breadth of knowledge of classes, methods, etc. is