Best Answers

Hello everybody,I found many discussions about this topic, but, I just want to renew this discussion. Is there any way, how to convert word (docx) file to PDF format in FME, please?Thank You so much for all tips!Lubo

I’m trying to make a KML from a CSV with Geometry in WKT. I have got up to the Extract Geomery transformer but keep getting the INVALID_GEOMETRY_VERTICES error. Example i’m trying to extractLINESTRING Z (212197.02298451745 6343709.643456226 -405.22127891605567, 212199.2655298651 6343696.0119692795 -406.87294763726277, 212201.50807521114 6343682.380482333 -408.246661504635, 212203.75062055816 6343668.748995384 -409.3429700220356, 212205.99316590338 6343655.117508436 -410.1623117274895, 212208.2357112494 6343641.48602149 -410.7050143686031, 212210.47825659852 6343627.85453454 -410.9712950336693, 212212.7208019459 6343614.223047592 -410.9612602385047, 212214.96334728913 6343600.591560645 -410.674905969057, 212217.20589263522 6343586.960073698 -410.1121176798006, 212219.4484379844 6343573.328586748 -409.2726702479159, 212221.69098332908 6343559.697099801 -408.1562278832371, 212223.9335286767 6343546.065612854 -406.7623439939325, 212226.01318177005 6343533.424279183 -405.22127891605555) 

Hello, I was just wondering if anyone has successfully used the AutoCAD Dimension attributes to validate angles?I have a example drawing below where the angle of the lines is added as text in AutoCAD using the DIMANGULAR function in AutoCAD. When FME reads in the features, using ‘Explode Dimensions’ set to No, I get a series of attributes against the text point with the coordinates of lines used to determine the angle in AutoCAD. What I have found is that defpt2 to deft4 aren’t always in the order to create lines and test the angle between them and was wondering if anyone else has had success in validating angles from a DWG?

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.

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!   

Hello there,I’m looking into finding how to decide on the actual geometry type of a MultiGeometry feature using python API.How to know which OGC type it is ? MultiPoint, MulitLineString or MultiPolygon.I need this for reporting on ingested data types. class FeatureProcessor(object): """Template Class Interface: When using this class, make sure its name is set as the value of the 'Class to Process Features' transformer parameter. """ def input(self, feature: fmeobjects.FMEFeature): """This method is called for each feature which enters the PythonCaller. Processed input features can be emitted from this method using self.pyoutput(). If knowledge of all input features is required for processing, then input features should be cached to a list instance variable and processed using group processing or in the close() method. """ feature_type_name = feature.getAttribute("fme_feature_type") if feature_type_name not in self.feature_

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. 

Does FME Flow (server) have a way to store FME workbench metadata? I can’t seem to find anything.I mean metadata about the fme workbench, for example info such as describing what it does, who its made for (customer), having some tags and a owner doesn’t cut it. Also a way to export this information would be useful. How does everyone else manage their FME Flow servers with hundreds of workbenches and automations?Open to any third party application suggestions too.Thanks.

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.)

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  

Our team uses GitHub, VS Code and FME Workbench for our data engineering projects with good results. Now we want to leverage FME Flow to automate the deployment of FME assets upon a GitHub merge to the Staging and Production environments. I would appreciate any suggestions or experiences in this regard. 

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 

Hello everybody!I have a server app to calculate routes. The workspace needs about 3 minutes for that and the user get an english text during the operations (calculating or something like that). But the app is in german language. Can I change those english words into german? thanks a lot in advance! 

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 everyone,I am currently making a script that looks for houses that have a garden. In my current script I have two datasets: 1) houses, 2) gardensI used for now the NeighborFinder transformer and I have a maximum distance of zero, since the gardens and the houses need to touch one another. So far, so good. However, now I get another problem.I have the following situation. You can see in the drawn example below that the garden and House 1 share a line, while this is not the case for House 2. However, based on my current settings in the NeighbourFinder, the garden is as well considered a neighbour for House2.How can I go about it, that House 2 is not included, since House 2 and the garden don't share a line, but only one vertex. Do I need to change  some settings in the NeighbourFinder or do I have to go differently about it.  

Is there an option or setting that I have missed?I have a reader pulling in data from a portal feature service. I set it to resolve domains.I have a field that, for whatever reason, the coded value is not being resolved so the “_resolved” field is being populated as <null>.Rather than having to add transformers to each of my workbenches to check each of my domain fields, I was wondering if there is a setting I am missing somewhere?In this instance, I would rather have the coded values populate the “_resolved” field rather than it show up as “<null>”. Is there an option that I can set in the reader (or somewhere else) to be able to do this? I am using Workbench 2023.1. This post indicates that there was no option 3 years ago… hoping there’s been an update made? Also, looks like no progress made on this request (from 4 years ago!) to at least add a warning in this type of situtaion. Please go upvote: 

Has anyone experienced a workbench erroring when feature caching is disabled? For context I have had this workbench running through task scheduler for around two years (keeping it updated) and recently discovered an issue where it crashed at a specific transformer (feature joiner).In testing I have run the workbench with feature caching on (it worked fine) so I tested all the normal points - replace transformers, replace readers/writers, change user credentials. When I turned off feature caching is where the error occurs (in the same spot as when running it through task scheduler).The attached logs show where it crashed on the feature joiner, has anyone experienced this? My last step is to recreate the workbench from scratch and test that as well.

Hello, I am attempting to replicate the following PostGIS SQL code within an FME workspace: where ST_DWithin(property_boundary.shape ,restriction_area."SP_GEOMETRY",100) and ST_AREA( ST_INTERSECTION(property_boundary.shape ,restriction_area."SP_GEOMETRY"))/ST_AREA(restriction_area."SP_GEOMETRY") < 0.1 property_boundary layer is parcel data for an area. restriction_area is a collection of polygons where the same restriction applies but for different reasons which is listed in the attributes. If the above script is true for a given property an attribute is then applied. I am not very familar with PostGIS SQL, but from my understanding, this script is filtering for all property_boundary shapes that intersect a 100 meter buffer of the restriction_area. Then, it calculates the total overlap between each property_boundary shape, and each restriction_area shape. If the area of overlap for a property_boundary shape is less than 10% of the total for a given restriction_area it is selected in

Hi everyone, I have several Esri personal Geodatabases with similar schema but also some tiny differences.That is, they are required to have identical schema but in fact some don't due to various reasons. Some feature types and attributes are unexpected, while some required ones are missing. Now I want to choose a standard one from them as a template and merge them all to get a standard destination mdb. How can I achieve that?

Within the User Parameters I have added the option to Select a File.More specific the user has the option to select a Geodatabase (Items to Select).When the user has selected the Geodatabase, I like to have the user also select the database of his/her own choice within that Geodatabase. Is there a way to configure that?  

This is supposed to be a quality of life improvement when working with unreliable data providers or when you have unreliable internet connection. I hope this functionallity exists in FME already but I could not find it.I am trying to make a custom node that saves the data stream it intercepts locally and reads that data instead if the original source doesnt come through. There are two problems that I have been unable to solve. One is that i have to run the script with feature cashing to get it to save the files and there is an error upon saving, it does not seem to understande the grouping for some reason:localize_data_2_FeatureWriter (WriterFactory): Group 2 / 2: MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or localize_data_2_FeatureWriter_0_DATASET or FFS_DATASET So as the image suggests the custom transformer saves the data stream here at 3 points. It dynamically creates local files named by the customTransformer instance name and with dynamic schema.The second pr

I have a workspace that filters a folder for the newest .zip file contained within and then uses a FeatureReader to extract shapefiles out of it for further processing. This works perfectly in Form but in a Flow automation where it runs off of a folder watch, it fails with   '<filename>.dbf' is not a valid Shapefile and cannot be read.  So apparently when operating from Flow the FeatureReader is trying to read the sidecar files.  Why?  And how can I tell it to stick to .shps? Thank you

When a FeatureWriter fails for whatever reason, is the expected outcome that nothing is output from any of the ports, even if some or all other feature types are successful? In my example I have 2 feature types in a FeatureWriter and 1 of the 2 writes successfully, the other fails (I’ve forced it to fail to test this functionality). I want to be able to take the information from the successfully-written feature type further in the workspace for processing. Is this not possible? Currently I’ve resorted to 40 separate FeatureWriters for 40 different feature types in case 1 of them fails and the other 39 are successful. I do have Rejected Feature Handling set to Continue Translation. This is FME 2024.1.1.1 (B23620).Below is my example. The 312 features for for the one feature type successfully write to my database (ArcSDE GeoDB). I’m ok that the Translation Failed and is actually a good thing, I just want to use the summary and feature counts to write to log tables further along in the tr