Transformers

Hi all,I am using Change Detection to compare 2 geodb_tablesAt the delete ports, the correct number of deleted rows is 2But it is not being cleared in my writer, the result in the output table is still 11Please let me know how to fix this error.For the geodb_point and geodb_line data, the result is completely correct, only geodb_table has an error as I showed above. 

Hi,This is a question that is really related to another piece of software (lastools) but it is using a product of FME.Basically in lastools you can colour a point cloud by an aerial image (the same as PointCloudOnRasterComponentSetter). I want to set up a script to do it in lastools because that is faster for this task.Anyway, lastools only accepts one raster (tif) as an input. I have multiple overlapping rasters. The overlapping parts are identical. What I want to do is merge these rasters and chop to the extents of each input point cloud.That is all easy but I’m having a little trouble getting it to work. It seems that lastools doesn’t like the RasterMosaicker transformer. The input (pre merged) rasters work fine, and even the clipped rasters (clipped but not merged). Which I’m taking to mean my writer properties are correct. I can’t see any difference in properties between ones that work and a mosaicked raster. I.e the bands/palettes are all the same b

Hi,I was wondering if you could please provide me with a sample FME script that uses PythonCaller or PythonExecutor transformers.I’m trying to setup FME Form to ensure PythonCaller is working. As well, would greatly appreciate any instructions you could provide to configure FME and Python and ensure that PythonCaller would work.Thanks, Wilfredo

Hi All,Today’s million dollar question: I have created a workflow to process some polygon and table data into a template GDB. The process isn’t too complicated but I think the most consuming transformers in the process are the DataTimeConverter and the FeatureWriter. I have done some tests but assume that processing around 94M of records will takes days. Mainly, writing 94M of records into a gdb template will be a nightmare.Here is a screenshot of the workflow, I have also attached a version of it:How can I improve the performance of the workflow and process around 94M of records in a clever way?Open to suggestions :)Thanks

Hello everyone , I am willing to combine 2 cityGML files that has the same CRS but with different LODsi need this in my studies project and i wonder which transformer shall i use , can someone help I am still new to FME software .I’ll be so thankful to any feedback ! Regards, 

Hello!I created a workbench using FME 2022 and then updated to the FME 2024 version. After the update, I also updated some transformers.Now, I need to revert to FME 2022, but some transformers are incompatible and not visible on the workbench.Is there a possibility to restore those transformers to a previous version to be compatible with FME 2022?Thanks!

I am using inspection point before and after the CoordinateRounder transformer to notice that only few coordinates are rounded while others are left untouched.  Is it something others have noticed?

I have an XML file generated by a specific SW, and there is an issue with one element, which content I cannot influence as I would like to. So I decided to try to update it with XMLUpdater, but I am just walking in the circles.The (very simplified) file looks like this:<?xml version="1.0" encoding="UTF-8"?><gdb:Utilities xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:atr="atr"... etc.> <gdb:Data> <gdb:BiogasStations> <bgs:Records> <bgs:Record> ... <atr:IDZone>58KVK-96</atr:IDZone> <atr:IDSpecific>0</atr:IDSPecific> ... </bgs:Record> <bgs:Record> ... <atr:IDZone>58KVK-07</atr:IDZone> <atr:IDSpecific>0</atr:IDSPecific>

The images are successfully uploaded, but the server assigns the incorrect mime type. This causes the images to download, and not display in browser. I have tried setting the 'content_type' manually to 'image/jpeg' - but the server seems to assign the mime type to 'application/octet-stream' every time.  my config is below. am I using the wrong syntax/config? thanks.... Multipart upload is as follows:  

Hello there, I feel like this should be incredible simple, but I feel like I am banging my head against a wall.  I am trying to update the name value in this JSON, ‘cp2regions’ to ‘new_name’ for example: {  "featureType": {    "name": "cp2regions",    "nativeName": "cp2regions"}}  Using this this workbench;Set up like this : I can’t seem to find a good tutorial/example workbench on how this Transform works. Many Thanks!

Hello everyone,I'm looking to place the maximum number of points within an irregular polygon, ensuring a minimum distance of 250 meters between each point. Initially, I considered using a grid, but I've realized that this method doesn't optimize the space within the polygon very well.Do you have any suggestions or more effective methods for solving this problem?Thanks in advance for your help!

I am trying to write polygon features into a Esri Geodatabase writer where the layer name is NV_NATURRESERVAT. But, the writer is trying to add a suffix “surface” so the output name will instead be NV_NATURRESERVAT_surface. This is not correct.First of all I dont want the a layer with a name like that. And second, before it reaches the writer the script filters out if theres a need to create a layer or not in Esri Geodatabase.If theres a need to create a layer it will create on in another writer. If there exist a layer with that name the flow will continue to the second writer. In this case the layer exist, I just want to update it with new data. So, up until writer(s) the layer name is set to NV_NATURRESERVAT. But when it reches the writer it gives me error messages saying that no such layer exist:“Esri Geodatabase Writer: Feature Class or Table 'NV_NATURRESERVAT_surface' must exist when Table Handling is set to 'Use Existing'

Hi guys,I am trying to automate a process which requires to write into a new file-geodatabase everytime I run a translastion. Essentially I am reading data from 1 database trying to stage it in a new geodatabase and then moving it to its final destination. I am using FeatureWriter to continue the translation but i am getting a geodatabase is locked error. That is why I am trying to create a new file geodatabase for the staging part of the process as this is where the error keeps on occurring. Is there a way that FME workbench can create a new file geodatabase for my feature classes in a same workbench?Thanks!

Good morning,I am trying to do a spatial join between two polygon files.  One is the property boundaries and the second is conservation easements.  The goal is to combine the parcel id from the property boundaries to the conservation easement polygon, where a new polygon will be created for each intersection.  I am trying to recreate a model I built in ArcGIS Pro.  Screen shots below.  

Hi,  This subject is discussed already quite some times but I don't get it working. I have a loop where a feature enters with 3 fields (field_name, field_value). I want to use the AttributeCreator to make a field that is named after the value in "field_name" and gets the attribute value from "field_value". As there is an option inside the AttributeCreator "Attribute Name from Attribute Value" is supposed this would do the trick. But this does not create a new attribute. If I type the actual field name in the "Attribute Name" field in the transformer it just works fine.  The attribute names are like this: net_elements{0}.xlink_href net_elements{1}.xlink_href net_elements{2}.xlink_href net_elements{3}.xlink_href ...

Hi All,Im trying to do a spatial join of attributes from the red line (running parallelish) to the black line, not the attributes from the red line running down Duke Street.I have tried a range of thingsbuffering the black line and seeing what it contains ( it contains a piece of Duke Street) and the parallel red line but i cant work out which record to take getting the polar angle of the lines and looking at the list of records that spatially join it - im struggling to sort the list to find the correct record. I think i need a Spatial Angle Join but am struggling with the logic on the listsAny help or suggestions appreciated. Thanks Steve

I am using an SQLExecutor to write spatial data into an ArcGIS Enterprise database table.It took me a while to get it done, and there is still more work to do but currently a smaller chunk of data is for the first time written into the table. What bugs me is the 4 lines of warning that I get for every feature written.Microsoft SQL Server Spatial Reader: Getting Custom SQL schema failed. Custom SQL query 'INSERT    INTO    building (OBJECTID,SHAPE)VALUES (27, geometry::STGeomFromWKB(here is of course the binary, 25832))' may execute in an unexpected manner. Make sure all columns are named (any ambiguous columns, e.g. GEOM.STBuffer(1), must have an AS clause). If there is an ORDER BY clause, either remove it or add a TOP clause. If this warning is generated in a SQLCreator or SQLExecutor, you can avoid it by picking Data Features in the Features to Read field the message coming from Microsoft SQL Server Spatial Reader

It used to work in older versions (2020?), but now will only use the value set in the writer. If I set it to 0 for automatic width, it results in "Error running translation"I need the cell size to be a specific decimal value, but the writer will only let me set an integer for the cell width.

Hello,Context : FME 2024.0.3, Windows 11I'm currently working on a project with source data and files “.shp” files within it. Each of these files has several columns, one of which is called “IdGen”. Only this column is not written in the same way according to the “.shp” file, example: IDgen, idgen, IDGEN, idGen……To insert it into our GIS, I would like to know if there was a way to change, at once and with a single transformer, all the columns having “idgen” regardless of how it is written to “ IdGen” as I wish ? All this with the aim that my FME project can work automatically during the next updates without having to use AttributeManager behind each of the files…Thank you !Antoine

Hello, I’m a beginner to FME and need help with how to exctract the images from a scanned pdf to fit with the OCR text I got from Tesseract. The idea is to create new pdf files from the scanned ones where you can copy the text and so on, and I also want to keep the original layout of the text and images. I have attached two images to illustrate what I mean. One is of the original scanned pdf and the other is my OCR extracted text and where I want to put the images. Also attached is my workspace.  Thanks!

Hi, I have a workspace that writes a XLSX from a template. The source features come from Smallworld (there's also a very simple Excel spreadsheet that is joined in the process). I can run it in FME Desktop 2018 (32) + Smallworld 4.3 with no problem. But when I run it in FME Desktop 2021 (64) + Smallworld 5.2, the resulting XLSX seems to be corrupted. While starting Excel, I get a message: "We found a problem with some content in... <file name>. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes". After clicking Yes, Excel does its recovery thing, and tells me "Removed Feature: Named range from /xl/workbook.xml part (Workbook)". To rule out an Excel problem, I opened both output files (FME 2018 and FME 2021) in the same computer, and got the errors only in the FME 2021/Smallworld 5 file. I also see these warnings in the FME log when

Hello,We are trying to manage changing attachments on a feature layer on ArcGIS Online using FME. We can successfully read, compare, and add attachments using a combination of HTTP Callers and Python Callers. However, we are having difficulties deleting attachments that are no longer relevant. The easy solution would be to delete the entire record but we are trying to avoid that.Has anyone had success at using the deleteAttachments POST request outlined in the ESRI’s api guide.https://developers.arcgis.com/rest/services-reference/enterprise/delete-attachments/Or has anyone found another way of managing attachments?Thanks,

Hello,I would like to export all the layers of a revit file to an ifc model.I used the ETL described here. Here are the layers of the input revit fileAnd the obtained layers of the output IFC file.The only layers that I'm getting rigth are:Architectural.DoorsArchitectural.RailingsArchitectural.RoofsArchitectural.StairsARchitectural.WallsThe other layers of the revit input file are missing in the output ifc file while I used the same logic to bu

I’m trying to write a PDF, currently attached to a GIS point feature class, to a PDF file. Preference being that this would be an additional page to another. I currently have a FeatureReader accessing the Attribute Table for the feature class. I have tried using the Adobe PDF GeoSpatial Writer but I am not getting anything but a blank PDF document. Is there a transformer or set of transformers that handles this specific workflow? The Data attribute on the Attachments table contains the original PDF document’s information.Thank you all,