FME Form

how can I arrange attribute in assending order like: 5,6,3 = 3,5,6 also i have check FME python caller but its not work.output is not generating.  import fmeimport fmeobjects  class FeatureProcessor(object):    def __init__(self):    """Base constructor for class members."""    pass   def input(self, feature):         cell_value = feature.getAttribute('Address Component Type')    cell_value2=sorted(cell_value)     feature.setAttribute('sorted',cell_value2)     self.pyoutput(feature)   def close(self):    """This method is called once all the FME Features have been processed    from input().    """    pass

Hello All,  Please have you got an idea how i could store more then 100+ records ? When i run the WB it should compare or find the value and do the needful.    thank you all

I have followed the below process .First I used the Spatial Filter with electrical Line as a candidate and Electrical devices as filter and the spatial relationship as "Intersects". Taken the failed records from the spatial filter to neighbour finder with base as device and Candidate as "Line feature ". Using the output of closest candidate X and Closest candidate Y , Vertex created with the replace point option to overwrite the geometry .  Tried the Anchored snapper as well which is not giving the expected result . I am still seeing some of the devices are away from electrical line .Can you please help me on fixing the issue ? Thanks & Regards,Kokila    

Hi,I have a scenario where I have a 2D polygon and 3 3D points. I need to force the polygon to 3D in such a way that it lies on the plane defined by the three points. Thoughts?

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?