FME Form

I have many SQLExecutor transformers and for any reason they use to lost the geometries.The visual preview nor the data inspector show any geometry, only a “There is no geometry in this view” message.When they should save the results in the next FeatureWriter (in a postgis database) only the alphanumeric fields are correctly writed, but the geom field is fill with nulls.When I execute the same sql sentence in QGis or pgAdmin I get the geom field with the correct geometries.I'm not be able to find the fix for this issue. Any idea will be appreciated. Thanks in advance.

Hi,I have an FMW (FME Form v.2023.2) with 4 datasets, and I would like to save the results as ArcGIS Portal writers. Each dataset could change due to modifications in the underlying databases or files used in the FMW. These changes may involve the deletion or insertion of rows, updates to attribute values, or, in some cases, no changes at all.I would like to run the FMW once a month without modifying the parameters for ArcGIS Portal.How should I configure ArcGIS Portal to capture all changes for these 4 datasets?When I used Insert for Feature Option and Truncate for Feature Type Handling 3 datasets where correct updated, the 4th dataset “Alle_Adr_Adkom” got:ArcGIS Portal Feature Service Writer: 0 features successfully written to 'Alle_Adr_Adkom', but the server rejected the 48751 features in the last request due to errors. See warnings above. Ending translationARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for details”I appreciate your helpElisabeth 

Hello. I am running workspaces using FME Python API and the class FMEWorkspaceRunner, where I am currently using the method runWithParameters.I would like to know how can I change the Log file name (and path) when running the workspace in this way. I saw in the documentation that runWithParametersAndDirectives have an example about change the log name, but it is not clear for me.Thanks.

Below you can see line and point features. Let's say each line segment has its own unique ID - in the example below, it will be from 1 to 6. I want to copy IDs from lines to poles that they intersect.According to my example, it would be:Point A: ID 1, 2, 3, 4Point B: ID 4, 5, 6 I have thousands of lines and points. What’s the best way to do it?Appreciate any help!   

Hi there, the table shown in the pdf image is missing in my data inspector. In some newer pdfs it does apppear. Can anyone help me '’expose'’ the tables. Also my attributes are only showing as format attributes. This makes it very difficult for me to turn my filtered data (.dwg file) Into an Excel. edit: I got it the table working by turning on all the parameters in my reader. I dont know which parameter did the trick… 

Hello,I was told that I can use HTTPCaller to automate some ArcGIS Online Admin workflows, such as creating/deleting user accounts.I found this ArcGIS REST APIs authentication document to guide me, but I can’t figure out how exactly. https://developers.arcgis.com/rest/users-groups-and-items/authentication/  Any help is appreciated! Nicole

I have a block sitting on a line and a block associated with a point in a DWG file. How can I save the label positions, including the rotation and alignment of attributes like 'ID', 'Slope', and 'IL_Out', using the CAD Feature Writer in FME?

I'm using FME Workbench version 2023.2.3. I have 2 datasets, 1 dataset contains around 2,5 million polygons, the other dataset is 1 polygon (a province in this case). I want to know which polygons overlap with the province (even if the overlap is small). I use a SpatialFilter for this, with the 2,5 million polygons as candidate and the 1 polygon of the province as filter. Below are the settings: Now I noticed some issues, where some polygons who do have an overlap, still end up in the ‘failed’ port. Like the example below:I asked some colleagues and they don't know what's going on here. Everything looks alright and we have no idea why this doesn't go in the ‘passed’ port. It almost seems like a bug. I use this SpatialFilter a lot, so I'm curious what's going on here. I hope someone can help me to figure this out. 

I am using FeatureJoiner to combine polygons from different source data layer. They all work fine and get combined apart from the data coming from the MapServer reader, this one gets rejected in the FeatureJoiner and gives this information:I see that data has an extra attribute: ‘arcgisonline_type: arcgisonline_polygon’, and the others from other data sources don’t have that. I am using a CsmapReprojector and converting from SPHERICAL_MERCATOR to MGA94-55 (written as “_MGA94-55_0” for all other data, and as “MGA94-55” for the data that passes through the Reprojector, the one that is being rejected, I don’t understand why they get different naming).Any suggestion if I am doing something wrong and how can I have the data not rejected please?

I am using FME 2024 - 0.3.0 (WIN64). When I try to write a raster data (*.jp2 or Geotiff) the writer changes the raster resolution and the projection, even if the EPSG - code remain the same. This happens only in FME 2024 (not in the older one). Waht ist the matter?

Not really a question, but feel free to add comments or thoughts below.We are implementing pre-commit hooks and centralized Python linters in our git workflows, and for this we need to extract all Python code from workspace files pushed to git. Since we do not want to require a full FME installation for this, we’re parsing the .fmw files as text files using Python and extracting all the code blocks within, before passing them on to the linter as if they were stand-alone Python scripts.As code blocks are encoded in a somewhat non-standard way, I’m sharing a Python function to convert FME encoded strings to regular text, without resorting to any dependencies like an FME installation, (which would allow using FMESession.decodeFromFMEParsableText) or other third-party libraries.It can decode FME encoded strings on either formatimport<space>fme<lf>import<space>fmeobjects<lf>import<space>json<lf><lf&am

I’m using FME to push and pull some data from Neo4J. For the connection I’m using the JDBC driver from Neo4J with the SQLExecutor. I’m getting various warning message in my FME logs and wondering if some configuration that can be done with the driver settings (connection property/value) to either prevent them or quiet them.To be clear, my workbench succeeds and have no issue with everything completing. It is just these popup in FME Flow for completed Job logs.  Here are the two most popular (both warnings):JDBC Reader: Unable to preload JDBC Driver Class 'Neo4j'. Error: Neo4j JDBC Reader: Skipping data in column '.errorMessages' due to error (JDBC Type = JAVA_OBJECT, Vendor Type Name = MAP, Error: Method getBytes in class org.neo4j.jdbc.Neo4jResultSet is not yet implemented.)

Hello Guys,i have an issue with bringing our geometry from a oracle 12C format in a AIXM gml format. Whatever i tried so far, the writer just refuses to write any geometry, while anything else seems to work just fine. The output was good enough to satisfy the AIXM validation but it is useless for us until i am able to write the geometry too. I am trieing to achieve that with the help from the XML-Templator and so far, this is how it looks:It looks fine to me, the coordinates are hard coded for testing and will later be replaced by a variable holding the coordinates for each object. But i would like to write any geometry in the first place before i think about that. I will provide my workspace and the gml i managed to generate with the hope that somebody can make out the issue at hand. Ty for reading this and every bit of help is appreciated!

Hi there,last time, this community forum was so helpful and I hope someone can help me this time around too…I’m using the Clipper to clip polygons using the Group Processing feature. Only if the values of the attribute “att_1” are the same should the clipping occur. So far so good. However, it can be that att_1 is NULL (empty) and in this case, I would like to do Group Processing using attribute “att_2”. Is there a way to configure this in the Clipper directly?With my humble knowlegde of FME, I would filter for att_1 being NULL and have two Clippers (one for Group Processing att_1 and one for Group Processing att_2) and then merge the two data streams again. But is there a more elegant way?

I’m trying to use the DwgStyler to convert a GIS, point feature class to an AutoCAD drawing with inserts and attributes.

Hi I’ve got a bunch of points (1 to maybe 40+) that are changing regularly (live data), and I want to find out which polygons those points are intersecting.  They are big polygons with lots of vertices. What is the most efficient and/or fastest way to do that?Should I:Have a SQL Spatial Reader and read all those polygons and use a PointOnArea Overlayer transformer. Use a FeatureReader with a Spatial Filter Initiator OGC Intersection and use a PointOnArea Overlayer. Should I use a SQLExecutor and rely on the database?I’ve tried the first two and I’m not sure which is best.Thanks

Hi, This is defeating me!Any pointers sincerely appreciated.See attached spreadsheet, Where I have features with attributes having multiple similar IDs as well as a name attribute.I have added the columns _num and _page, that is the desired output I manually added in.I can achieve the _num output easy enough with a counter set to Local and group by the two Attributes Name and ID. I set the Count to be _num and Group ID to be _page. This works fine until the Name group changes and the _page will continue counting, See screenshot. However, when the new Name starts with B I want the _page to restart at 1. How do I set it? Thanks. Nic  

Hi,I am trying to write data from database to 3 different Feature Layers (Hosted) on ArcGIS Online. 3 layers have different set of feature attributes.While trying to write data, I would like entire transaction to be rolled back if publishing data to one of the layer fails.Example: If writing data to layer 1 and 2 was successful, but layer 3 fails, I would like to rollback layer 1 and 2 as well.For this scenario, I am trying to use 3 readers and 3 writers in same FME workspace. Is there any kind of Try/Catch or related mechanism that can be used to rollback the transaction ? Any help would be much appreciated, Thanks in advance. Regards,Syed 

I have this json file (see the attached txt file) that I want to load into a table (shown as in the attached excel file). I have done many json conversions over the years, but this one puzzled me quite a bit and could not figure out a good way to do it. The difficult part is that for each asset Id, there could be a few years of emissions. Each emission has two emission type, n2o and co2.  How can I capture each year and its emissions into rows based on the emission type to be pivoted? {  "assets": [    {      "Id": 25494428,       "Emissions": [        {          "2021": [            {              "EmissionsFactor": 1,              "EmissionsFactorUnits": "U1",              "n2o": 10            },            {              "EmissionsFactor": 2,              "EmissionsFactorUnits": "U2",              "co2": 100            }          ]        },        {          "2022": [            {              "EmissionsFactor": 3,              "EmissionsFactorUnits": "U1",              "n2o": 11 

- Sketchup Studio 3d Modelling - I want to do it even if I transform the glb file into 3d tiles and go to cesium ion, is it possible in FME? 

I am a Chinese student who uses FME software to read shp files and create 3Dtiers files. There is a problem loading and displaying now. As shown in the video, there is an issue with zooming in and out.Others' 3dtiles were generated using other software and did not encounter this issue. I'm having problems using FME now, how can I solve this. Please help me. My English is not very good. Can you understand what I translated using translation software.I searched for some 3dtiles files and someone said it was a geometricError parameter setting issue.Where can i set the 3dtiles geometricError ???please help me .I am bad in English.my Emial 1985425275@qq.com   FME USE THIS .  Maxinum Number of Triangle Faces Per Tile  Trying to set 100 and 1000 times, but it doesn't work。Where can I set parameters？？？Someone told me that there is a problem with the geometricError parameter and it needs to be corrected。Hom to ???

fichier cadastre à fissionner dans FME hello ! j’ai 3 couches shapefile -bâtiments-parcelles-limites communesje veux les fusionner pour avoir un seul fichier dxf (Microstation).

j’ai deux couchesUne couche de points (ponctuel) et couche de lignes (linéaires).je veux vérifier les points isolés ou non connectés de ma couche ligne.solution svp.en pièce jointe les supports (points) à vérifier qui ne sont pas connectés aux lignes (tronçon). I have two layersA layer of points (point) and layer of lines (linear).I want to check isolated or unconnected points of my line layer.solution please.attached the supports (points) to check which are not connected to the lines (section). 

Hi there, I am trying to extract links from this page Mornington Peninsula Planning Scheme - Maps using the methods posted on this forum as well as from the official documentation HTMLExtractor (safe.com), however there is zero total features read, meaning no output. Would this be due to the way the site is structured? I am specifally trying to extract the urls for the PDF maps on the left, and output to a SQL table and link to our GIS, as these links change every so often.Regards,Josh 

Hello, Am I the only one who is experiencing lately that if I have several models open and I do a purge tempory files in 1 of them then it then does the same in the others? The numbers remain in the other model but the green box to view is gone and I have to run the whole model again :-(I do that because sometimes I update a reader but then it won't run again without me doing that purge.