FME Form

Heya FME specialists, can you please give a thought on the next issue:Created a new table in PostGIS with FME from shape, using the PostGIS writer. (see 00_initiate.fmw) Point feature, attributes pkey and a, b, c with values. Insert, drop and create.Updated this table with the PostGIS writer. (see 01_update.fmw) Point feature, pkey, and only a, b with values. Update based on pkey, use existing.The problem is: We decided to maintain attribute c with QGIS directly in PostGIS but kept editing the geometry and attributes a and b in the shape. I deleted the attribute c in the writer assuming it wouldn't write it anymore to the database. That assumption appeared to be wrong and to prevent updating attribute c I had to use an AttributeKeeper in front of the PostGIS writer. My problem solved but curious if this is a DB writer syntax or a bug?Using FME Desktop 2016.1.0.1 on Windows 7. Uploaded workbenches in zip for reproduction.Thanks!

Hello everyone,At the moment I am doing a conversion from BGT to NLCS (Dutch cad standard)I have an excel file (bgt to nlcs conversion) which has the corresponding color, line weight and linestyle names that I need for the conversion to NLCS.I have created a seedfile and via the Line style editor in Microstation 2023 I imported the rsc files that I needed in the seedfile.In fme, I don't use the dgnstyler, but I just defined the following attributes in the Attibutemanager:igds_style_nameigds_colorigds_weightIn the Level manager in the seed file, I haven't defined the levelname and the corresponding style yet, since it would be too much work for me. So based on Fme I just hope to give elements their corresponding color, lineweight and style. Color and weight has been succesfully (see below for snapshot of the output in the data inspector), only igds_style_name not yet. I haven’t used igds_style, since I don't know the number and I have the igds_style_name available in the excel file, so

I am getting the following error message when I try to run my workbench.“FeatureWriter_UtilMaster (WriterFactory): MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or FeatureWriter_UtilMaster_13_DATASET or FILEGDB_DATASET”I cannot for the life of my figure out what the issue is. My only theory is that because it is trying to write to a geodatabase, but the data I have been given to test with doesn’t actually have any geography. The writer is Featurewriter with output format Geodatabase (Esri Geodatabase (file gdb open api)) with the dataset as one of the attributes.Does anyone have any ideas that might help, or think I might be on the money that the lack of geometry is causing a geodatabase writer to fail.

We are in the process of building a new FME workspace that is using the FTPCaller transformer to upload a file to a remote SFTP server. To ensure we are compliant with our internal security standards around cryptography, I am looking into SSH protocol versions and cryptographic algorithms in use by the FTPCaller transformer.My questions are:Which versions of the SSH protocol does the FTPCaller support? I know from connecting to a local SSH-2-only SSH server that it supports SSH-2, but does it also support SSH-1? (I hope not!) Is there any way of configuring the cryptographic algorithms used by the FTPCaller? Or, as an alternative, listing the supported/enabled algorithms?Thank you,Jonathan

Hello, I have a point dataset which represent the noise level at 1x1 intervals on a wall.  I need to convert those point into a raster  which i need to convert into a graphic (jpg or tiff)  Any ideas how can i do that ?Thank you, David

Hi Im reading an API with health data that updates every week. The goal is to aumomatize the process so FME reads this API every week to take out the new data. Now this API has an attribute called “temporal” which has values like this: “2024-W30” or “2020-W10” which is just the year and the calendar week. The data goes back several years and each week the last week gets added.I only want to use the latest data each week so what I need is somekind of a filter that looks at the attribute “temporal” and only takes the data from the current year with the highest numbered week which corresponds to the data that got added last week.  Any suggestions on how I could do this? Thanks in advance

Hi there!I want to let you know, that I'm writing a new tutorial covering XML Filter Expressions in WFS Reader:https://olivers-expression-lab.gitbook.io/filter-expressions-in-fme/ The basics are done.Please let me know, if it works for you and escpecially if not! Best regardsOliver 

I know this question have been asked few years back but unable to find its answer in the same thread today. I am using FTPCaller to download files from a remote SFTP server, I got logging in cridentials from the SFTP server admin and my computer is allowed to login to the SFTP server; which means there is no problem with connection and previledges. But FTPCallers responds with failed Initialization! any suggestion? Thank you!

I have a lot of polygons that represent buildings and I want to rasterise them but before I do I need all the polygons to be parallel to the horizon. I need to create a tool that calculates the polygon angles and then use these angles to rotate the buildings accordingly. 

How can be determined (estimation is all right) if a polygon feature (A) fits within another polygon feature (B) and count how many.  thnks

Hello!I'm trying to create a tool in Data interoperability (FME for ArcGIS) that gives the User a list of attributes to choose from based on the read source. I'll make things more clear.Let's say i have X.X= People infoI'm reading X and filtering out with a tester based on a criteria and it returns me 3 entries. Next i want the user to see those 3 entries and have the possibility to choose which ones continue along the process of the tool.I can't make the user choose the parameter beforehand because he does not know what the first tester will end up with.Is it possible to accomplish this in FME? If so how would you recommend to do?

Hey FME team,My coworkers and I are trying to figure out a tough polyline overlay issue. We are building a routable transport network for a city. We received 2 polyline datasets for the city’s road network. One dataset (Roadmap) contains geometry that we are licensed to modify the geometry for (as the original data were poorly connected and incomplete), and the second dataset (Carriageway) contains geometry that we are not able to use for the transport network but can use attributes for. Attributes include the number of lanes, whether the centrelines is in a urban or rural location, and the start and end measures for the carriageway feature. The link between the two polyline layers is a field called road_id, which forms a many:many relationship between the map layer and the carriageway. An example is shown below (3 Roadmap features, 5 Carriageway features):Roadmap (modified, x3)Carriageway (x5)Our issue is there is a slight offset between the modified Roadmap geometry and the Carriagew

I have Roads which are at the borders of municipalities (polygons). But for many of these road segments, the LEFT/RIGHT municipality fields values are wrong. I am looking to rectify that data. I have looked into using LeftRightSpatialCalculator and NeighborFinder transformers but they don’t seem to be helpful for identifying which municipalities are on the LEFT and RIGHT side of each segment. Please suggest, how do I accomplish this?

Good day,I am using a JSON-Templater.My Root Template looks like this:{"GisData":    {"Lake" : [fme:process-features("LAKE")],        "River" : [fme:process-features("RIVER")],         "Park : [fme:process-features("PARK")]        }   }and in the Sub Template I have one port for the Lake, one for the River and one for the Park.In some cases I don’t have lakes for the JSON I want to create. So the JSON will look like this: "Lake": [], This is not useful and will create issues later on. How can I specify that I only want to add them to the JSON if they have a value ?

Hi,the AttributeTrimmer transformer does no longer trim correctly after updating from transformer version 3 to version 4.In my workspace I use the AttributeTrimmer to strip whitespaces from attributes. This used to work as intended and as described in documentation. It stripped all whitespace characters from the attributes, regardless how many there are. Recently I upgraded this transformer from version 3 to version 4. The new version works differently after that. Now it strips only 1 whitespace. When there are more of them at the beginning or end of the attribute the rest of them is left untouched (i.e. if there were 3 whitespaces at the end of a string entering the transformer, the result still has 2 whitespaces at the end).This seems to be not working as intended and described in documentation and should be changed in a future version. I use this transformer a lot to clean up attributes for comparison.Can someone else confirm this problem?Kind regards,Andras

Hi all,I’d like to use a FeatureReader transformer to read in an ArcGIS Feature Server and then have a user specify which specific Feature Service they would like to process. The Feature Server has ~15 services whose names I have added into a parameter. I added the parameter to the “Feature Types to Read” option, but can’t get the tool to successfully read in the service that I specify. I attached a screencap of how I have things set up so far...does anyone know how I can accomplish this? I think I’m close and might just be missing something small. 

I’ve imported a topographic map that is in GeoPDF format.  I want to convert to GeoTIFF.  I see advice posted to put an ImageRasterizer between the reader and writer.  My question is how to set up the ImageRasterizer “rows and columns” data.  Where do I get this data?   ThanksBill

Whats is the best way to connect to an IBM MQ 9.3 message broker from a workspace running as a stream on Fme Flow 2023? We need to be able to process several hundreds of messages/sec. I’ve done quite a lot of testing with the MQTT connector transformer and Mosquitto MQTT broker. Very fast and reliable. IMB MQ only supports AMQP 1.0 protocol and the question is if there is a connector transformer I can use for that? Fme Rabbit connector supports AMQP 0-9./Stefan Ljungstedt   

Hello , I got error from Python caller .i would like to get all paths from start node to end node then I have written this script but I got Ann error . could you please help me to fix this problem ?import fmeimport fmeobjectsimport networkx as nxclass FeatureProcessor(object): def __init__(self): self.graph = nx.DiGraph() self.start_end_pairs = [] def input(self, feature): start_node = feature.getAttribute('start_node') end_node = feature.getAttribute('end_node') arc_id = feature.getAttribute('arc_id') self.graph.add_edge(start_node, end_node, arc_id=arc_id) self.start_end_pairs.append((start_node, end_node)) def find_all_paths(self, start, end): return list(nx.all_simple_paths(self.graph, source=start, target=end)) def close(self): for start, end in self.start_end_pairs: all_paths = self.find_all_paths(start, end) for path in all_paths: feature = fmeobjects.FMEFeature()

Hello everyone, I’m currently working on a project where we have 3D mesh models (SLPK or 3DML) and I’m looking to convert these into point clouds. My goal is to use ArcGIS Pro with the Imagery Analyst Extension to extract and classify all tree points. We’ve had great success using the Tree Classification deep learning model with LiDAR data, and I’m curious if this approach could help us save costs by not needing to collect new LiDAR data when we already have 3D mesh models from the same year to convert 3D mesh to point cloud. Has anyone here had experience with this type of conversion? Any insights on the process, potential challenges, or tips would be greatly appreciated! Thank you in advance for your help!Best regards,Reno

I’m having a workspace with some connections to files that are on sharepoint. I did create the correct setup with the web connections to have a sharepoint account with client & tenant id etc in it. workspace works fine at my side, but the account that was provided is an account that has access to a lot off stuff.When I want to share the workspace with production so that they can run it, they also need to have the webconnection present in their workbench to get it to work (otherwise sharepoint online connector turns red etc).With this they can actually access more files than what is stricly needed (even though my workspace is password protected, nothing stops them from using that account for fetching different files) and this may lead to security issues.Although using a account with limited access to files on sharepoint would also help, I’m wondering if there is a different way to access files from sharepoint? I’m comparing it a bit with database connections:Connections are convenie

Hello , I got error from Python caller .i would like to get all paths from start node to end node so I have written this script but I got an error . could you please help me to fix this problem ? import fmeimport fmeobjectsimport networkx as nx class FeatureProcessor(object):    def __init__(self):        self.graph = nx.DiGraph()        self.start_end_pairs = []     def input(self, feature):        start_node = feature.getAttribute('start_node')        end_node = feature.getAttribute('end_node')        arc_id = feature.getAttribute('arc_id')                self.graph.add_edge(start_node, end_node, arc_id=arc_id)        self.start_end_pairs.append((start_node, end_node))     def find_all_paths(self, start, end):        return list(nx.all_simple_paths(self.graph, source=start, target=end))     def close(self):        for start, end in self.start_end_pairs:            all_paths = self.find_all_paths(start, end)            for path in all_paths:                feature = fmeobjects.FMEFeat

Hello, i am looking for a transformer that changes all objects of a dgn or a gdb by a certain amount in their z-value.Please help. Thank you.

using the Autodesk AutoCAD Map 3D Object Data reader and setting the parameter to “Group by Entity” (this is so i can get all the objects with 1 reader). I have the autocad_map_odtable{} format attribute enabled. i then have a testfilter to get >0 to separate the features with od values. do i need to enable an extended data value to get the table? How do i get the OD table values for these features?spoiler. I already have the data.i ran the workbench but looked at the wrong output. by separating the data i already have the attributes on all features within the testfilter. 

Hello, I am struggling with the INSPIRE GML writer and the new version 5 of the ProtectedSites xsd schema.Earlier this year, the XSD schema was adjusted, among other things for the following:Correction of spelling error in inspireID Converting enumeration to code lists Adding attribute "thematicIdentifier" Datatype of legalFoundationDate to 'Date' Changing multiplicity of the elements legalFoundationDate and legalFoundationDocumentSee https://github.com/INSPIRE-MIF/application-schemas/releases/tag/2024.1 and underlying links.When I retrieve the attributes of the old version 4 schema, I get the list from appendix 1, which includes:inspireID.Identifier.localId inspireID.Identifier.namespace legalFoundationDate legalFoundationDocument siteDesignation{}.nilReason siteDesignation{}.xsi_nilThis worked well for my application.However, when I now retrieve the attributes of the new version 5 schema, I get the list from appendix 2. In it:I do see the corrected inspireId attributes. I also see th