General

Hello,  As part of an application I am developping, I am using the FME Flow API to submit a job asynchronously (using the webservice POST /transformations/submit/< repository >/< workspace >).  I have also created a specific webservice used in the workspace runned on FME Flow so it can communicate specific information about the result of the workspace to my application.  I would like to know if there is a way to use the jobid returned in the response body of webservice POST /transformations/submit/< repository >/< workspace > in my workspace so that it can be passed as a user parameter in the HTTPCaller used to call the webservice I have developped.  It would be very usefull for me so that I could create a link between the job sumitted on FME Flow and the information it sends back to my application using the webservice I have developped.  I remain at your disposal for any additional information.  Best regards,

Hello , i have xml document schema ,that includes subtypes .I have exported it from arc catalog  in FME my input is arcsde ,i have used quick translator to convert it from arcsde to file geodatabase ,in configure parameters I have used the schema xmlI have read in article this is the way to get subtypes in file geodatabase to use schema xml .But after checking the file geodatabase by ArcGis pro ,does not include any subtype . How could I get file geodatabase include subtypes ? FME 2021

I have a PowerShell script that copies files from a network drive to a SharePoint site. I can get the script to run manually on the FME Server Server using both my user credentials and the FME Server Service user but when I wrap it into a 'System Caller' it runs but does nothing.  The workbench runs in FME Server calling the following in the System Caller C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe"D:\\TMR\\SaferSpeeds\\copyToSharePoint.ps1"  My guess is it is some sort of permission issue but not sure where to start.Any ideas?

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

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

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

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?

 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

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?     

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

Hi, I have a bunch of fairly complicated SQL queries, which I frequently use in an SQL Creator. This saves me a tremendous amount of featuremergers and such, because the sql basically re-creates the business object from the normalized database tables. Up to version 2020 this worked just fine: insert an SQLCreator, select DB Connection (SQL Server 2016 SP3), copy-and-paste SQL from my code snippets, click on the ellipsis to Expose attributes, click on Populate from SQL Query, and I'd be done. Now that we've upgraded to 2022, that does not work anymore. The Attributes to Expose dialog stays empty, and no error messages or warnings appear in the log. It is rather annoying because I have to do this all the time, and now I have to copy the attribute names manually from my sql statement. It's causing me quite a bit of extra work. Am I missing something? I am currently using FME(R) 2022.2.6.0 (20230523 - Build 22800 - WIN64) , and up to now this method has always worked just fin

I've gone into Manage Web Services and managed to configure the Microsoft Mail (safe.emailer) web service and it tests and authenticates without issues. However, when I add the Emailer transformer from Hub and go to select the Email Service from the Service section I only see Generic SMTP and Gmail. Is there something special I need to enable or refresh for the transformer to see my new web service? edit - have tried this in both versions of 'Form' I have installed (2022.0, 2022.1) thanks

Hello , i would like to create a line between two attributes that has coordinates at same tableThis table has many points .Id_1 | x1 |y1|id_2|x2|y2 x1 ,y1 relates to id_1x2,y2 relates to id_2Both of them are points. How could I create a line between id_1,id_2 and add text that include the value of id_1 and add text of value of id_2FME 2021

Hi Community, I'm trying to run an existing FME 2018.0 workbench on FME 2020.2. and just received ArcObjects is: '-2147219879' error. Tried to search online but couldn't find the workaround/solution. The FME workbench reads a GDB and applies metadata based on XML file as well as an excel file. Attached the log file for reference.  Any help more than welcome 🙂

I have workspaces that allow a users to define an area of interest when looking for data. Instead of the openstreetmap coming up, now it is just a grey box. Coordinates still get passed, but the user cannot see where they are drawing their polygon.

Introduction: I am encountering an issue with an Esri ArcGIS Server Feature Service link. Over the past few days, the link has been functioning correctly; however, starting yesterday, it started throwing an error. As a newcomer to FME, I lack the necessary understanding to interpret the error message, specifically the AttributeError: 'NoneType' object has no attribute 'name'. I would greatly appreciate any assistance in resolving this issue.Problem Description: The link causing the problem is as follows:Link: https://mapservices.weather.noaa.gov/tropical/rest/services/tropical/NHC_tropical_weather_summary/MapServer/Details: Upon accessing the aforementioned ArcGIS Server Feature Service link, I receive the following error message in Python:Python Exception <AttributeError>: 'NoneType' object has no attribute 'name'Request for Assistance: Since I am new to FME, I am unsure about the root cause and implications of this error. I am seeking guidance an

I have a workspace which is scheduled through Windows Task Scheduler on a Virtual Machine. This workspace writes out to an Excel file on a mounted drive. When running the workspace manually, it has no issues. However when running through Task Scheduler, the workbench gives an error "Can't open file for writing". The target Excel is not opened anywhere and I do have writing permissions for it. Has anyone dealt with a similar issue before?

For a job that has been working for years, it is now endlessly polling job status and returning awaiting worker. In Server, the last message you get is about the Socrata Write executing. In the desktop software you get more information and it reflects endless polling. Something has changed and I'm having trouble figuring out the cause. 2 of 24 of these (county specific) ran and the rest hung, and now even the two that ran initially will hang. It appears to be happening in the last step involving the Socrata Writer. This is the last log information, with the "Polling the job status: Awaiting worker" repeating endlessly. Other jobs that write to Socrata are still working. It isn't blanket failure on writing to Socrata. Any thoughts on cause or leads to investigate are welcome. ThanksSocrata Writer: 0 features treated as points, 0 features coerced to point, 0 features with unsupported geometries written without geometrySocrata Writer: Invoking Socrata DataSync with control file action 'Ap

I have a zip file that has a csv file and multiple jpgs. I tried a CSV feature reader-- not a CSV reader-- as I was trying to read the file with in the zip file but that didn't work. I am using FME 2022.2.2. Is there a way to only extract a particular file from the zipfile? I dont want to unzip the entire thing as it will take a long time. Thanks in advanced.