A space to discuss FME Form
Recently active
Every week I have to update a File Geodatabase in AGOL using “Update Data”. What transformer would I use in FME Form to automatically update the data without me having to sign into AGOL and drag/drop the zipped file? My ultimate goal is to add this to an existing workbench and create an Automation in FME Flow where this is done automatically each week.
Hi FME teachers and users, I have files in (.fme) formats, how convert them to (.fmw) formats?
I'm trying to update an IFC file by assigning it a coordinate system. However, FME doesn't seem to recognize the coordinate system used by the IFC2x3 file.I understand that the IFC file operates with a local coordinate system, but I don’t have information on which specific system it uses.I've attempted the following approaches:CoordinateSystemSetter Reprojector Setting the Writer’s coordinate system to WGS84 UTM33Despite these efforts, the file always ends up with the coordinate system IFC_COORDSYS_0.Does anyone have a solution or a recommended approach to resolve this?
The main idea:I have this combination of transformers that are meant to clip a raster and from the result of that clip extract the values for every point using the RasterCellCoercer. This way I can do some statistics with the values of the raster that fall inside some polygons. The problem:I started realizing that the results coming out of the clipper were not consistent. I thought I was losing my mind. Sometimes when I use the clipper using multiple polygons the clipper clips as expected, tight and beautiful (what I need), some other times the clipper clips using the bounding box of every polygon feature that is supposed to be clipping. Also I get way more points, which is a pain bc I am working with big numbers here.Case 1 (Expected):Case 1, its clipped tightCase 1 transformer view: As you can see I have 153k Points coming out of the RasterCellCoercer and none of the points has a value 0 (last tester RetirarCotas 0)Case 2 (The unwanted): Case 2: The clipper clipped using the bounding
Hi,I have HTML content stored in a table's html_content attribute, and file names in a file_name attribute. How can I upload these directly to Azure Blob Storage using the FME Azure Storage connector without writing local files or using the HTTPCaller? Is it possible to provide the HTML content directly to the connector as an attribute? I need to dynamically set the blob name using the file_name attribute. Any help is appreciated!
I have a number of workspaces, lets say 5, but this could expand.Each of these workspaces is like a validation check / test. There is a lot or duplication between the tests and I’m thinking about creating some linked customer transformers in order to not have to make changes 5 times in a row. I know this is usually good practice in programming in general.I’m a little hesitant though because adding linked custom transformers can add complexity (passing attributes 7 parameters etc etc) and makes testing/edits kind of annoying. I’m interested to hear others experience with working with linked customer transformers -pain points, whats great, when you use them over when you don’t
Hi there,I’m using the ChangeDetector to update some point data in a ESRI enterprise geodatabase (SDE). I’ve set up the CHangeDetector to check geometry as well as attributes. I have 3 points out of 1224 that seems to being updated due to a geometry difference. I think it’s just that typical geometry change you get between FME and SDE so I have set the vector tolerance to 0.001 which is very generous. I’ve try all the various settings 2D, Lenient Geometry even changing the tolerance to 0.01 but these still come up as being updated. Below are my setting for the ChangeDetector:I’ve specified a change list and it used to be that you could see the original coordinates and the revised coordinates so you could tell if it was a real change or just a artifact but I can’t for the life of me see where to find these coordinates anymore. It just gives me nothing in the change list:Can anyone tell me where I can see these coordinates? Or why these three points are behaving this way and what to
Hi! I am currently writing data into an Excel spreadsheet. I have added two feature types that are configured to truncate existing data and overwrite it in the spreadsheet. Now, I need to add another feature type that includes charts and some formulas. These formulas have been set in Excel to sum data from one of the tabs I created in the spreadsheet, and I made a chart based on that data. Is there a way to keep the third tab intact when I overwrite and truncate the data in the first two sheets? Thank you!
Hello, I’m using Feature Writer to save my output in mdb format. I want to name the output file by User Parameter. When I run the workflow in FME Form, the file named by my input user parameter is generated correctly. When publishing to FME Flow, the user parameter is ignored and the output file is named randomly (e.g. “FME_5C2B2C70_1739440402445_7677.mdb”). In the log I can see that the parameter is not read, so the output name is empty. This is how it looks like when publishing the workflow: I’m using FME 2024.2.2 Do you know if this can be fixed? Thank you for your replies!
Hi everyone,I am new to FME and need some assistance with a project. I am trying to create clusters based on a point layer, using one of the parameters where the total hours equal to 'n' and a spatial parameter. The objective is to find clusters where the total hours equal 'n' and ultimately demarcate boundaries for these clusters to optimal coverage. I have been using the NeighborFinder transformer, but I am having trouble moving forward. Could anyone provide guidance or suggest a better approach to achieve this?Thank you in advance for your help!Sahan
The Coordinate Systems Gallery is missing EPSG spatial references we use all the time. How to update the gallery list so that more EPSG codes are available? (e.g. anything on https://epsg.io/)
Hey. Does anybody know how to solve the situation where I need zipextractor to not preserve the tree structure of the archive ( if it contains subfolders ) and save the file itself?Thank you
A user is supposed to use FME Server's web interface for running a FME workspace that has been published on it. That FME workspace takes a file geodatabase as input. The user should upload his/her file geodatabase at runtime in the web interface for that workspace. The problem is that the browser will not let the user select the folder defining the file geodatabase. Furthermore selecting all subfiles of that geodatabase will lead to a failed run. What is it that I am overlooking? Thanks in advance!
I want to build a flat JSON array using the jsontemplater. I try to use this example to understand the syntax but using the pipe character does not go well.Starting with a simple creator for the root object and sending the actual information to the ‘ADDRESSES’ sub template. I try to define the root template as [| fme:process-features("ADDRESSES")|]and the sub template as{ "ID": fme:get-attribute("Site_ID"), "Address": fme:get-attribute("Address")}Taking it from the linked example the pipe character is needed to separate the array items by commas.My translation log return the following warnings, and error messageJSONTemplater (XMLTemplaterFactory): The following error occurred near line 1, column 3 of the query:JSONTemplater (XMLTemplaterFactory): invalid expression: syntax error, unexpected "|"JSONTemplater (XMLTemplaterFactory): An error occurred while parsing the ROOT template How do I use the jsontemplater to create some flat JSON array structured as [ { "ID": "Site_ID", "
Hi there,Creating many workbenches over the years, and this is very rarely a problem.But it is very rarely a problem because FME automagically selects the postgres writer writes the data using the correct geometry type, not because I have been able to specify.However, here i have a workbench reading in spreadsheet data using a [vertex creator] on the X/Y columns, but when I write the data out to postgis/postgres i find that it arrives there in linestring format. At least, QGIS then sees the layers as linestring!What is super wierd, is that this workbench has been reused for several years, each year with the postgis writer being modified to create a new table for the years data. All previous years it has created point data, this year it has decided on polygon. This happens when i modify the workbench in FME 2022.1.3, or in the current FME 2024.2.3.So, obviously this is unsatisfactory, and I want to be able to tell FME to create that postgres.postgis table with the geometry type of point
Using FME 2021, I am trying ton import ArcGIS Python API package into FME to be able to use from arcgis.gis import GIS I used CMD and ran the following commandC:\Users\User\Documents\FME\Plugins\Python>fme.exe python -m pip install arcgis but I am getting this error ERROR: Command errored out with exit status 1: command: 'C:\Program Files\FME_2021.1_b21607\fmepython38\python.exe' 'C:\Program Files\FME_2021.1_b21607\python\pip\_vendor\pep517\_in_process.py' prepare_metadata_for_build_wheel 'C:\Users\User~1\AppData\Local\Temp\tmp8yey1i4s' cwd: C:\Users\wUser\AppData\Local\Temp\pip-install-mweucxk9\pywinpty Complete output (6 lines): Cargo, the Rust package manager, is not installed or is not on PATH. This package requires Rust and Cargo to compile extensions. Install it through the system's package manager or via https://rustup.rs/ Checking for Rust toolchain.... ----------------------------------------ERROR: Command errored out with exit status 1: '
Hello,Using SpatialRelator, I want to test if a feature line from Requestor, is "Requestor is OGC-Within Supplier", where supplier is an other layer line.If end vertex of line are the same, the test works but otherwise doesn’t work.OKNOK
Can someone please let me know how I can grab two values from a JSON snippet like below image? Using FME Desktop I am trying to grab two values “portalURL” and "id" from two fragments of "info" and "events" and assigned them to two User Parameters “PURL” and “PID” Can you please let me know what Translator/former I can use to the task for me?
Hello , I'm working on finding the path for specific lines and reorder points .I have several lines, each defined by a start and end point, but these lines also contain intermediate points. Should I merge the intermediate points with the lines before using a shortest path finder, or how will the transformer know which intermediate points belong to each line if I don't provide them? My goal is to reorder all points, including the intermediate ones, to find the correct sequence from point A to the final point, such as A, B, C, D, E, F, G. Thanks in advance
Hello! I have a problem regarding using a FMEFlowJobSubmitter within a workspace when running on fmeflow using only one engine. When testing the same setup on an old fmeserver i dont have this problem since a “child” engine is created and the procces does not halt. This also works ony my localhost fme flow. However when running on a new fmeflow setup i get the following error:346 2025-2-12 14:53:56 | FMEFlowJobSubmitter_5 (ServerFactory): Reason - 'Error communicating with FME Server host FME-flow uses a “"FME Engine of a distributed FME Server deployment". Could this cause the issue or is there any other known problems that i can look into? /Fabian
Hi allI have an FME Workbench file which has to do the following things:Ask for multiple directories via a published user parameter read two files in each directory which end in _changes.shp and _to_remove.shp AND are always located in a subfolder v1 in each directory.The transformers and writer after that are already doing what they should do, but I can’t seem to confgure my reader to do what I asked here. Is this even possible to do? And if so, how should I do this?Thanks in advance for the help!
Hello,I'm using FME form 2024 and I would like to know how to configure the software so that the Inspector automatically opens in a separate window after a translation is completed. I’m having trouble finding this option in the interface.Could someone please guide me through the steps to achieve this in FME 2024?
Hello, I am seeking help with using a Regex to replace the first instance of an underscore in a string. I am using a BulkAttributeRenamer to rename a series of attributes with multiple underscores like this as an example: 0_4_C11_M I am trying to replace just the first underscore in the string with a dash with a regex replace to change the name from 0_4_C11_M to 0-4_C11_M. The regex I’m using is ([\_]+) When I test that expression in RegEx101 is does exactly what I need and only replaces the first underscore in the string as shown below:However, when I use the same expression in the BulkAttributeRenamer it’s returning and replacing all underscores as shown below:Hoping someone can help with advice on how to limit the return to just the first underscore in the string please - it the expression incorrect or is there something else I need to add to the parameters? Thanks :)
I am new bee and want to generate FME flow which reads every day file from SFTP server and populate the datathe first half of the file is default then their is date concatenation with “MMDDYYYY” format and then suffix with file extensioni use datetimestamper transformer and found the date but when pass that date to FeatureReader in Dataset with “default text”@Value(_Date) , it does not generate the fileCan someone help with if their is any example which can provide me guidance on how to set auto filenames
I have a field that contains values with parentheses, like (0601310951181134359628), and I would like to remove them. The parentheses always appear once at the beginning and once at the end of the field.I am currently able to achieve this using two StringReplacer transformers, each removing one parenthesis. However, I would like to do it in one step. I tried the recommended regex expressions from previous posts, but none of them worked.Any suggestions?