Transformers

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, 

Hi All,I’m trying to write an existing ESRI GDB relationship 1:1. I have watched a few of the FME articles material here https://support.safe.com/hc/en-us/articles/25407490028813-Writing-Geodatabase-Relationship-Classes  but can’t get it to work. Here is the scenario:I have created the relationship (1:1) manually in ArcPro as the relations can’t be created using FME. The relation is one to one and needs to be done by Title_Number field. I have also created the relevant fields after reading the article above, here is an screenshot of the AttributeCreator:   Here is an screenshot of the relationship in ArcGIS:

Using generic feature reader to access a JPEG via a URL, that is an attachment for an ArcGIS Portal feature layer and requires authentication: this works well when explicitly stating the URL as the Dataset as the reader has the option to network authenticate in this mode. However, when the URL is supplied within an attribute, the reader has no authentication option and so the self same JPEG as above will fail with the message : 2022-06-29 16:47:51| 0.1| 0.0|ERROR |JPEG reader: `\\AppData\\Local\\Temp\\1\\wbrun_1656380366772_18540\\fmetmp_4\\TempFS_1656478070812_2916\\4' exists but could not be opened. File contents may be invalid, or the file format may not be supported2022-06-29 16:47:51| 0.1| 0.0|ERROR |JPEG reader: Failed to open the dataset '\\AppData\\Local\\Temp\\1\\wbrun_1656380366772_18540\\fmetmp_4\\TempFS_1656478070812_2916\\4'. Please ensure source data is valid and correct reader is selected2022-06-29 16:47:51| 0.1| 0