FME Form

I'm having a custom transformer that needs an URL as input for API calls, so I made it a user parameterHowever if I take the value from an attribute, that value is lost after another custom transformer that contains a list builder. If the value comes from another user parameter (set in the main), there is no issue:This is the setting by taking the url from an attribute (table shows the output from a parameter fetcher inside the custom transformer after the list builder CT) This is how it is by taking the value from another user parameter (+ output from same parameter fetcher): Is this a bug? Am I missing something?How could I solve this in a performant way?Is there a way to change a value from a user parameter to an attribute value? Say I define user parameter "URL" as private one and leave it empty. After I deduct what the URL should be (fetched from a database), can I add the fetched value to the empty user parameter?   

Hi, I am trying to make the FME KafkaConnector working. I first tested this connector to produce to a local Kafka server without SSL and authentication. That all works fine.  Now I am trying to get it working on our company Kafka instance. This instance requires two-way SSL authentication, which means that I have client certificate, private key and password for the private key. I have configured the Kafka connector as in the screenshot below:  The advanced options are set to:  with this configuration, I get the following error message: This message is very non-descriptive; it could be anything. Also if I turn on further debug logging in FME, it doesn't give any more details about the cause of the error. As the FME Kafka connector is based on the Confluence Kafka Python library, I have downloaded and configured a producer using this library. The Python code is shown below: from confluent_kafka import Producer  p = Producer({    'security.protocol': 'SSL','bootstrap.servers': 'broker.str

I have a drawing which contains more than 700 hundred identical blocks and a lot of other features. The Autocad Blocks are dynamic. They can have one of 6 states where they will display a different geometry. I need to extract the correct shown geometry. I have a new working version I would like to share. And I am curious if this is the most efficient way. These block types are used more often and it is very difficult do show the user in GIS what he is seeing in CAD. My new version reads the file with and without exploded blocks. I use the unexploded block to detect the parameter that controls the 'visibility' state. I need to read the exploded version with 'preserve insert position' to get the correct autocad handle that I can match with the unexploded version. And the autocad block number to connect the correct the autocad handle to the other geometry. Then I can filter out the correct display state. See my attached example. "Get Autocad Block Visibility State.fmw

Is there a difference in performance when it comes to working with Missing vs Null values in FME?  I'm working with some database tables which have a lot of null values. The output is something like JSON so In the end I want the null values to be missing in the output rather than a null or an empty string.  but when it comes for manipulating the data is there a difference between missing and null values?

Helo FME Users, I am using FME for my data processing tasks, and I am trying to determine the number of points that fall within each polygon in my dataset.Specifically, I have a set of polygons and a corresponding set of points distributed across a geographic area. My objective is to count the number of points contained within each polygon. However, I am unsure about the most efficient way to achieve this using FME.Thank you in advance for your time and expertise.

Hello, I am attempting to take over support for FME Smallworld translations and the first task is to add some new features to an .fmw file. I am able to add the features but notice that doing this or changing the file in any other way causes seemingly unrelated text features to no longer translate.  Looking at some text features in the file, there is a warning: The following attributes do not exist: 'sworld_text_string'. This seems like it could be related to the features no longer translating; I am not sure since they do come across before touching the file. Any information is appreciated. attached are some examples and a log with the error message (updated). I am happy to share more information or meet to try and get this resolved. Thank you.  

Hi,Does someone have a workspace example how to collect all files in a folder for creating a ZIP-file to send to the Mailer-transformer?I am using FME Desktop 2022

 I have tried both attribute checker and attribute manager to pull the data from the dgn and then run it into geometry filter to place it into an existing gdb, and this does not seem to be the correct workflow. Is there a standard setup for converting a DGN to a GDB?

Hello, We are desperately trying to make FME working with our Kafka cluster in SASL_SSL mode (SCRAM-SHA-512).The Kafka cluster runs well : we are able to produce/consume from any Java/Python source code as well as via Apache NiFi, but on our FME Desktop, we get the following error message :   I don't have any more message to help me to troubleshoot it. Any idea ? Thanks in advance for your assistance. LC    

Hi, I am working on a project with 3D Pipe Network features. I want to create reader for excel and IFC file format and DGN would be the writer. The ifc and excel files has a common ID (Tag). I am trying to join the metadata based on the common ID (Tag) and trying to write 3D solid geometry MicroStation DGN file? is there any solution for it?Attached is the sample file. Could you please support me to create a workbench template  Thanks in advanced.

I want to create blocks from the lines in each layer and give the new blocks the last 5 digits from the original layer name. so lines in layer 12345xxxx1 will be a single block with a name xxxx1 and the block placed on original layer 12345xxxx1I got the block created and placed in the correct layer but couldn't figure out how to name it.    output blocks

HiI would like to filter/resample (I don't know the FME terminology) a point cloud based on spatial distance.In short I would like to obtain a new point cloud where I have 1 point every 2 cmWhich is the best transformer ? thx Francesco

When adding a new part (containing 5 feature mergers) to an already excisting workspace, which was already published on FME server, FME Server runs into a Failure without expressing why. The workspace is mainly made out of FeatureMergers and AttributeManagers. When replicating this problem in FME Workbench 2021.2 with cashing on the whole workspace runs smoothly without any problems. If I run the workspace normal manually the FME workbench stops working. Hopefully anyone knows how to deal with this problem? Maybe there is a work-around?

How can I change the text sizes for individual elements in blocks? In AutoCAD itself I can set the text sizes within the block. In FME I set text size with autocad_text_size, but this sets the text size for all the elements and overwrites what is in the block.  So I'd like to set the 1-2-3-4-5-6-7-8 to be much smaller than Existing and Grass

I have a csv with start and end lat longs and other attributes like road name and road number. I want to snap it to the route (road network) polyline dataset based on matching attributes (road name/road number) and then generate the line geometry of that road network from start to end coordinates provided.  Is this possible to accomplish in FME?  

 I have tested it on a small piece of road scanned with mobile mapping. The road surface is very dense. But when I run the Simplifier the points on the road is not even touched. See attached screenshot. The orange points is the removed points.What settings should be used to simplify the road surface?

Hello FME Community. We are trying out something new with a Beta Megathread!  With the release of the FME Desktop 2023.0 Beta, we'd love to get your feedback on any of the new features. Download the Beta and test it out.  Use this thread to provide feedback, report minor bugs, or even start a discussion. If you've submitted another question or a new idea related to FME 2023, add the link(s) to the comments. If you do find a production-impacting bug, please create a support case.  See the Change Log for up-to-date information on what is new, updated, or fixed.  Note that Beta builds can be removed from the downloads page at any time, and new features may be removed in a build without notice. Please do not use a Beta for production. For more information on FME Betas, see the FAQ.  Once the FME Server 2023 beta is available, another Megathread for FME Server will be published and linked here.  Happy testing!

Hello ,How to convert file geodatabase to arcsde ? thanks in advance FME 2021

Hi FME Community..Need your guidance , I'm receiving different dates in a particular column called "date_1" total records 401 including null when im using date time convertor to standardise it , Give me all null values to that column..Need expert GuidanceI have attached the templateThanks

I want to reproject DWG files with Pipe Network features from UTM Zone 17 NAD83 (Original) to MTM 10 NAD83 CSRS  using ON83CSv1.gsb.when I use ArcGIS data interoperability and EsriReprojector, it reproject all feature except Pipe Network features.is there any sollution for it?

Hello,I have a json response body that I am trying to get into a table. Using the JSONFragmenter I have gotten each record to populate as a different fragment. I have a long string with all the key value pairs. See below, {"ActualFinishDate":"2023-06-01T18:00:00Z","DateSubmitTo":"2022-05-02T13:37:46Z","Description":"FLT - Service Requirement","InitiateDate":"2022-05-02T13:37:46Z","StatusDescription":"Completed","WOCost":0,"WorkOrderId":"3006845","Comments":null,"Instructions":null} Now what I would like to do is create a table that would have each of the value keys as an attribute column and to have that tabled filled out with the corresponding data.  What would my next steps be?     

I am able to use AttributeValueMapper to translate single values (ie if col1 == 1 then col2 = 'A') but I need to get it to map ranges of values, something like if (col1 > 0 AND col1 <= 50) then col2 = 'A' I keep getting 'Invalid Test Expression' errors so it sounds like I'm not writing the conditional tests correctly but I cannot see where I'm going wrong. Here's an example: Can anybody help me fix this, or point me at another way of setting a value in one column based on more than one possible value in another column? Thanks, Mike

Hello everyone, I've a quite simple workflow but I'm stuck with error '500'. I'm trying to link polygons from hosted feature layer A (ArcGIS Portal) with attributes from a CSV file and write them into another hosted feature layer B (empty, with same schema than CSV file). The writer is configured to truncate and insert all polygons & attributes. I guess that this error is coming from the lack of unique ID for the new inserted polygons, since this field cannot be modified (see below) : ArcGIS Portal Feature Service Writer: Attribute 'objectid' on feature type 'Master_nutrition' is marked as read-only in the corresponding layer/table. Attribute values will be ignored. NB: same for "globalid, shape_length, shape_area" Similarly, I've a more complex workspace involving a "many-to-many" FeatureJoiner, with the same error. The solution is probably similar.  I'm not sure how I should handle ObjectID or GlobalID for it to wor

When writing to a hosted feature layer in ArcGIS Online we are getting duplicate features on occasion. In the latest run where this happened, there were 15,304 features in the dataset which were reported as written to ArcGIS Online, although the feature layer actually had 16,304 features written to it. Features with OBJECTID 9001 through 10000 were exactly duplicated making it seem like a batch of 1,000 features were written exactly twice during the process. OBJECTID 10001 was an exact duplicate of 9001, 10002 was a dupe of 9002 and so on.... After this batch of duplicates, subsequent features were not duplicated (features before OBJECTID 9001 were also not duplicated).

This is very simple.  I have two different point feature classes and I just simply to want identify which points overlay each other (several should be an exact spatial match) and transfer attributes when there is a positive spatial match.  I first considered using PointOnPointOverlayer as I thought it was the most logical transformer but that doesn't seem to carry out a "spatial join" but rather 'aggregates' points based on proximity. I found that NeighbourhoodFinder with tolerance set to 0.01 was the closest tool to a typical GIS spatial join. Other options may include using FeatureMerger.  Any suggestions on which transformer will work best here? This should be straightforward enough! Thanks.