Transformers

Hello ,i am struggling with get the relationship between classes .i have Exported xml from arc catalog and I would like to find the relationship between classes .I have used the workspace here https://community.safe.com/s/article/geodatabase-xml-workspace-document-schema-readerlist exploder for data element ,I have chosen relationclasses but it seems for me , it does don’t show all relationship classes with others ( some are missing ) My target to find name of feature class and the feature classes related to it FME 2021 please if someone has sample workspace ,I will be appreciated .Thanks in advance

I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly:  But when I connect the joined output to the geodatabase writer no records are written to the feature class in the file gdb and I get an error saying "Cannot write a non-area feature to an area feature class": I have tried both Drop and Create and Truncate Existing for Table Handling.  Any suggestions are greatly appreciated.

Hello, I'm trying to convert datetime format with SchemaScanner dynamically but I haven't been able to. I have Oracle tables (thousands) and am trying to migrate the data to Google BigQuery.Since it's nearly impossible to create an individual reader for each table and the corresponding writers, I'm using a dynamic Oracle reader and a dynamic BigQuery writer.In the data migration process, I need to convert datatime from Oracle to a different format so that BigQuery can ingest the data. When I was researching for an automated way to convert the datetime data, I came across the SchemaScanner transformer which in theory can detect datetime columns and convert the format dynamically. I've tried to place a SchemaScanner between a dynamic reader and a dynamic writer but it doesn't seem to do anything.In the "Date Handling" section of the SchemaScanner Parameters, I chose "Convert Input Date Format to FME Date" and I chose "Yes" for "

The ESPG library contains some reprojection methods. Is there an easy way to import a reprojection method from the ESPG library? For example, can you copy the text from https://epsg.io/8450 to create a new reprojection method in FME?

Hello everyone, I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. Can you help?

I am trying to read in two separate .dwg files, make changes, assign layer names with Feature Writer inputs, and then output to a single .dwg file. But, the data is not combined and it outputs two files from their respective reader instead.My hunch is that the Feature Writer is seeing different schemas coming in, but I can't figure out how to combine. This is one of those "seems easy, what am I missing" issues..I guess?

Hi everyone, I have some seismic cross sections that are in bitmap format. I would like to transform them into vertical georeferenced cross sections, something like this (https://gis.stackexchange.com/questions/295586/displaying-cross-sections-3d-volumes-in-qgis-3-x), and export them as 3D object if possible (I'm not sure wich format would be suited for that). I can create lines that represent the acquisition lines for those seismic images but I have no idea how to "hang" them vertically below the line. Does anyone has an idea if it's feasible in FME ? Thanks

Hello FME community, I would like to use batch file and FME to create a tool that is able to export an Excel file to a shapefile and transform the coordinate system at the same time.with batch file i get parameters from user. The sheet name and name of the columns can be different for each transformation. when I try to run the process for different file, Sheetname and Column name should be same as previous file and create shapefile without column or empty columns. I need my Read and Writer to automatically recognize new sheetname and Column name   

I have 2 PointClouds I want to merge their components using PointCloudMerger, however their x,y,z and coord values differ. They both represent scan of same building, but one has been set with global coordinates. I have applied Reprojector/CommonLocalReprojector but their location still differ. How do I change one of the PointCloud x y z values to be same other than forcefully changing it? And if I must change them by force what type are their in (Real64, Uint64, Int64, ...) ? Alternatively, how can I pass the component value from each point to other point cloud through an index method as both Point Cloud have same number of points and should have same index.   

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?