FME Form

I ran a workbench that reads data from .xlsx spreadsheet into a MS Access database (.mdb) table. I got this single error message:"Failed to read the metadata for 2D rendering" I have never seen this before, any ideas on what it means and a fix? I am using FME Desktop Version 2021.2.6 (Build 21821).

Hi, I would like to do something very simple. I guess. I have one feature in Oracle spatial with differents locations. The cities have one set of the code. Example: Paris (345) with 500 features, after Mumbai (346) with 4335 features. I want basicaly no have duplicated cities by code. I need even run again with Paris and delete all features with ID 345, and put the new features. Even like this, delete all stored line and insert the new lines if the ID is equal. Thank´s  

Hi there! I have about 30 different very long workbenches that we use for one very complex process. Every time we have a change, we want to be able to search in our list of transformers from each bench. Is there a way to generate or map out or investigate workbenches and have that list of all transformers from all of those benches?  Python, xml, anything will do. Need some ideas guys please.

Is there a shortcut to creating the connections automatically instead of dragging and connecting readers to writers one by one? 

I am using SpatialETL Tool for ArcGIS Pro

I have a csv-file containing WKT's, and I want to use GeometryReplacer. However, I want to remove the z-coordinates in the linestring. The linestring is formatted like this:LINESTRING (252388.4 6630392.1 39.726, 252360.1 6630378.5 38.626, 252350.3 6630372.4 38.626)What's the fastest way to do this in FME?  

Hello, I'm new to FME. I found how to view AIXM data but I don't see a view option for AMXM? Is it possible?

Greetings,I want to merge a number of polygons that share a common attribute value. I currently have 552 polygons.The Dissolver transformer outputs:Area: 540 Remnants: 50 (Interior_Line) The ListBasedfeatureMerger outputs all as errors?? Any assistance appreciated 

Hi there,I need to run through a large number of GIS layers to run the rubbersheeter over and was hoping to be able to iterate through a list, rather than need to add the SQL Spatial reader for each layer. Is there a way to do this? Also I will be outputting the result to another database. I imagine I just need to read the input name and save out the output feature class. Regards, Josh

 Hi folks, I'm having some issues when setting a loop. I input a TIN in loop,and then I do some processing (smoothing). At the end I've set a parameter to match; if it doesn't , then I want the TIN to be reprocessed (with a new value for refinement).  I seems like the loop is not accepting a TIN as a trigger for the next loop, or this is what i understand from the log:   Loop to testLoop_INPUT1620857756 Input Splitter (BranchingFactory): Transformer/Factory testLoop_Clipper_5_Solid is blocking and cannot be used in a loop, but was found between 'Loop to testLoop_INPUT1620857756 Input Splitter' and 'testLoop_INPUT1620857756 Input Splitter' Transformer/Factory testLoop_Clipper_5_Solid is blocking and cannot be used in a loop, but was found between 'Loop to testLoop_INPUT1620857756 Input Splitter' and 'testLoop_INPUT1620857756 Input Splitter'testLoop_VolumeCalculator_9_GQuery (

Using an undetermined number of records as input, I want to process 20 rows at a time with an html report generator to produce a table, and then output pages of 20 rows each. I have a process that works, but it uses a separate html report generator for each page of twenty rows. How can I create a loop that outputs sets of pages with 20 rows ?

I have let's say FirstWorkbench.fmw which is calling SecondWorkbench.fmw using FMEServerJobSubmitter transformer without waiting for secondWorkbench's completion. ​Now there is a third party application which is using FMEServer REST API's to trigger the FirstWorkbench.fmw and also checking its STATUS. Once the job FirstWorknench is completed STATUS is showing as success in REST API Job status endpoint. ​I want to get the JOB ID of SecondWorknench.fmw which triggered from FirstWorknench. Is there a way to do this ?

 i would like to connect FME Desktop with Azure Data lake storage gen2,to let FME read the data from there . my first question : will be possible by using only FME Desktop ? i have read some articles that they are using FME Server ,i would like to know also , when we have decision to use FME Desktop or use FME Server ? i have currently FME Desktop 2020 my second question : i have found this transformer : Azure Storage on FME hubhttps://hub.safe.com/publishers/safe/packages/azurestorage so this transformer where should i start my workspace , which steps should i follow to connect FME desktop with azure storage gen.2 ? Thanks in advance .FME Desktop 2020.2

I have a request in Postman that returns a "cookies" section. It's not in the headers like I need. How do I obtain these using fme? I tried using the response_header attributes but they all aren't available, only the first InstaceID.

Hi.Do the later versions of FME support writing GML 3.3 ?I've read in the "Implementation Standard Revision Notes" from OGC, that "GML 3.3 builds on GML 3.2.1" (which is supported by FME), and that "All extensions are made in seperate XML namespaces".I hope that this means, that a GML 3.2.1 file is a GML 3.3 compliant file. And so I can use 3.2.1 in place of 3.3 whenever this is required.Can anyone verify this ?Cheers.

Hi everybody,I have been trying to experiment the new Meta Segment Anything Model (SAM) library on FME Desktop via a PythonCaller transformer.After lots of debugging when making SAM compatible with the IFMERaster object, I finally reached the part in which I need to "decode a mask in COCO RLE format into binary."This is carried out via another library, named pycocotools"from pycocotools import mask as mask_utilsmask = mask_utils.decode(annotation["segmentation"])"Apparently

Hello,a while ago a user suggested to implement an "Option to control default sheet on Excel writer"Does anyone know if this is now possible ? I am writing an Excel file with up to 100 sheets and I want to force Excel to open the first sheet by default. Thanks.

Hello, I am trying to load in my gml data, however all attributes are coming into FME as data type strings, when i have even set the parameter obtain data types from xsd schema. I have also tried the xml validator and this thinks that all attributes are strings. Thanks, @Takashi Iijima​ @mark2atsafe​ 

I have workspace that reads data from SDE, does some attribute changes; ESRI ArcGIS Online Feature Service writer that writes data on ArcGIS Online. But its not working. Any suggestion is highly appreciated.

So, the workflow is as follows. I managed to download a folder from a URL-adress and to unzip it. Next step is where I got stuck. I want to remove all record in my feature class (ArcSDE-database) and then I want to append the same feature class with the records from the shapefile that I downloaded. Anyone got any tips on which transformers to use?Super thankful for your help.

I have an ArcGISOnlineConnector transformer at the beginning of my workspace (initiated by a single Creator object), and the Content Source is set by the user as a group in an ArcGIS Online (AGOL) portal. When the workspace is run, the output from the ArcGISOnlineConnector is a collection of definitions for feature services, web maps, etc. within that chosen group. Those definitions and their attributes are exactly what I need for the main operation of the workspace; however, during processing (within a PythonCaller, to be specific) I need dynamically to access the Group ID parameter that was chosen in the transformer by the user. How can I do that programmatically? In the PythonCaller, which leverages the API for Python and the REST API, I generate an Item object (Python API) for each feature service, so I could use that Item object as a starting point for finding the group id. I have used fmeobjects a lot--but my breadth of knowledge of classes, methods, etc. is

I tried to convert an IFC to CESIUM 3D Tiles in FME 2022.The IFC has a coordinate  and a projection  .After tramsformation , When i upload in cesium the coordonate still set to (0,0).I tried it this other IFC file and i have the same issue.Can ANYONE HELP ME?Suggest me a solution ?suggest me a set workspace to solve it ?

I am asking this question on behalf of my colleagues. My colleagues are facing a problem that they are running a .fmw script at different times of the day. Sometimes this script takes 1 hr and another time this same script takes 2-3 hours. Other applications are also quite slow, so it's probably wise to look at connectivity/databases issues and the likelihood that the problem lies on FME Desktop is probably to a lesser extent or nonexistant. However it could still be a combination of different factors that influence the different runtimes in FME Desktop. So I would like to get a rough idea if there are maybe some issues in FME Desktop that might influence the different runtimes. I was thus wondering if others face different runtimes in FME Desktop as well and might have some ideas about the reasons. One colleague opted some ideas that might impact the different runtimes and I was wondering whether you could stand behind those ideas. Query in SQL databasesTra

Hello, Could someone tell me how, from a PythonCaller calling a dropdown list via the PyQt5 module, to use the selected string (in the example below, the "select" variable) in the list to fill in a feature attribute and then leave the dialog box once the choice is made?# coding: utf-8from PyQt5.QtWidgets import QApplication, QWidget , QComboBoximport sys     def actionSelect():    select = qcombo.currentText()    print("Selected street : " + select)    app = QApplication(sys.argv)root = QWidget()root.setWindowTitle("Street Selected")root.setGeometry(100 , 100 , 500 , 300) # création de la liste QComboboxqcombo = QComboBox(root)qcombo.setGeometry(100 , 10 , 150 , 30)qcombo.activated.connect(actionSelect)# création de la liste des itemsL = ["Street A, City A" , "Street B, City B" , "Street C, City C"]# ajout des items à la liste QComboboxqcombo