FME Form

Hi, fellow FME:ers, this is an urgent matter! We just upgraded FME Desktop and FME Server to 2022.1.2. We have 100+ solutions in our consultancy firm building on the use of excel template files - *.xlsx and *.xlsm.  After the upgrade the output becomes corrupt.  Is this a know issue? Is there anything we can try to avoid corrupt files? Or do we need to go back to previous FME versions…I attach two example template files we’re using.Any help will be appreciated!Peter

Hi, this question has been asked previously in the old forum but I couldn't find any answer.  I have a workspace that writes an Excel file. The destination dataset uses the value of a published parameter to set the output filename. e.g. DEST_DATASET = $(PROSPECT).xls  When running the workspace on the desktop the replacement works as expected. e.g. the output filename becomes "my_prospect.xls".  When the workspace is published up to FME Server (2013 sp2) as a data download service the workspace runs but the XLS file returned inside the .zip file is called "$(PROSPECT).xls". ie. no parameter substitution is occuring.  Does anyone know how to do this?  thanks, Nic

Hello,I have a point cloud and I would like to get a buffer around each point (to apply an intersection with another mesh)I have placed the following transformers: PointCloudToPointCoercer to separate each point (output geometry: individual points) and then a buffer (buffer type: solid)The workbench works fine, only in the operation, somehow, I lose the georeferencingDoes anyone have a solution? Thanks

How to let this arcpy code in Python caller work my input type is ArcSDE Esri the target here to get the list of relationships of classes between eachother and save the output in csv  i am not familiar with Python ,what should I add and change here to let the code work in pythoncaller and write the  output in csv fileimport os, pprint all_rs = listRelationshipClasses("path/to/your/database.sde")  # see above pprint.pprint(all_rs[0]) # filter by namers = [r for r in all_rs if r["name"] == "FilterName"]rs = [r for r in all_rs if "PartOfTheName" in rs["name"]] # filter by cardinalityrs = [r for r in all_rs if r["cardinality"] == "OneToOne"] # filter by origin or destination tablers = [r for r in all_rs if "OriginTableName" in r["originClassNames"]]rs = [r for r in all_rs if "DestinationTableName" in r["destinationClassNames"]]rs = [r for r in all_rs if "Or

The FME ASPRS las file format 1.4 reader seems to omit withheld points. How do i import all points (including the withheld points ) and then use classification_flag to filter the withheld points in and out? The point cloud splitter doesnt give me classification_flag as an option, and the withheld points dont import via the reader (withheld points verified by lastools), and cant see a parameter to control whether withheld points are imported. Advice welcomed. Thanks in advance.

Hi All, I am using FME Desktop 2022.1; We have some GML files that FME does not read. I don't know why. Please help me out here. File is attached.

I have a workbench that creates points from coordinates then generates lines. I am only getting three sides of the polygon and I have not found a transformer that will close the forth side. Can you suggest a solution?

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​