Authoring

I have set up an automation process that retrieves information from an API to generate a report. However, this task has become complicated because an essential piece of information we need to include in the report is located in a different API, which requires an ID to access the relevant data.I am considering generating the report first, which will consist of the necessary IDs. Then, I plan to make a second API call to retrieve the information from the second API, one ID at a time. I have successfully completed the first part, but I am now stuck on the second part and unsure whether this can be achieved using FME or if a Python script is the only solution.

I think what I’m trying to do should be pretty straightforward and that I’m just missing something obvious, so I apologize if this question is not great …I have a workbench that uses sqlcreator to connect to some data in my db. I do a few transformations and then finish everything up with an excel writer. I’m having an issue configuring the excel writer correctly. 1.New records are being added to the db, and I occasionally need to rerun the workbench. I want the new records to be appended to original excel output. 2.Also in between runs, I am writing notes and other relevant information in the excel sheet on empty columns I created in the workbench. I want to keep the text I’ve written.The first time I ran the workbench I had the writer configured to INSERT. No problem. I thought I simply needed to change it to UPDATE and it would start to append new features to rows below the original, but instead I get an error because I don’t have a field to put in the Row Number Attribute field. I

Hello there how could we find the closest road facing  the Building  from the North, south, Est and West the ides is to take each side of the building  check its facing what direction and then towered that direct we should check the closest road we can see from that building side  we are expected to get this result  each color represent the relation​​​​​​​I am attaching this sample data for referenceThanks​​​​​​​

Hi,I think this question has been asked before, but the links in its answer were broken so I’m unsure what the answer was.If anyone is able to put me in the right direction that would be greatBasically I have a complicated workspace doing a few things on large files. In order to make it more efficient I would like to know if there is a reasonably easy way to get a rough indication how long each individual transformer was running in total. Then I can get an idea of where bottle necks are, or things I could improve.Currently I just look through the log to see if something takes a while, but that's tedious. Is there a better way? Is it possible to get some sort of summary how long each transformer takes to run?I do run the workspace on FME server/flow, though I do test it locally as well.Thanks

hello there we need to calculate the length of each polygon edge , the polygona could be in irregular shape considering the polygon is 4 edges if we use chopper or Geometrycoercer  transformer we get many edge  we are suppose to get only 4 Thanks  

Happy 2025!I’m processing some OpenStreetMap PBF data and have found a duplicate attribute name, hard to believe but I think an artifact of OSM’s XML ancestry, two attributes differ only in string case, like my_attribute and My_Attibute.  My processing changes all attributes to lowercase so I have two fields my_attribute.  I tried a ListDuplicateRemover on the Schema output of a SchemaScanner but I get an invalid schema definition.  Does anyone with knowledge of FME internals have a tip for dropping one of the duplicate attributes?  Thanks.

This is a HowTo.I had a hard time adding a raster to an HTMLReportGenerator. Thanks to some remarks in an old Question of the Week I found a solution. Many thanks to ​@mark2atsafe!I share my solution here for others that may encounter the same problem (and for myself, in case I encounter the problem once more in a few months 😉).HTMLReportGenerator can't use a raster, but it can use an image. This image must be in binary encoding. The image can be embedded in the HTML, so it suffices to have a temporary image. The temporary image will be automaticaly removed when the workspace finishes.So the process becomes:Use a TempPathnameCreator to provide a path for temporary storage of the image file Use a RasterExtractor to convert the raster to a blob Use an AttributeFileWriter to export the blob to a temporary file. Specify FME-binary Encoding In an HTMLReportGenerator embed the temporary file as an image 

Dear community,I want to automatically write all metadata for my geodatabase using FME. So I managed to set this up using XMLUpdater. But I only manage to do this for feature classes. I would also like to write metadata for the feature dataset, and even on the highest level, the geodatabase itself. How can I access the XML for these higher levels of gdb structure?The XML that I find with FME for a feature class only contains metadata for that particular class and not for the higher levels.Thanks in advanceNathan

Hi all,We have a set of points that we want to replace with symbols that are currently in a .dgnlib file. Opening the .dgnlib file does not give us the symbols directly within FME.How can we style the points using the symbols from the .dgnlib file?Kind regards,Ivan

This is my first time using the FeatureReader and the WHERE clause. I’m trying to tidy up my workspace and make it a bit more efficient.In the workspace I want to read in all the track points from an ArcGIS Online feature class and then in the WHERE clause filter it to just the last 24 hours.This is the WHERE clause I’m using. It has the correct date field. I’ve formatted it in the DateTimeConverter like this %Y-%m-%d %H:%M:%S."location_timestamp">='@Value(_24hrsago)'It filters immediately (I think) to what I need (first screenshot), but by the end it has passed through all the points in the feature set. Do I have the wrong output port connected up? Is there something I need to select in the parameters? This is what the FeatureReader Parameters look like. An additional question I have is if I want to filter to the last 24 hrs (as mentioned above) plus Projects A, B and C. How would I combine this in a SQL expression? I currently have this going into a Tester and then Clipper, but wo

Hi, We are deploying FME Desktop 2022.2 in our server (it’s a virtual machine).  The security team had done a security scan and expected us to upgrade the FlexNet Publisher to version 11.19.6.0 or later. However, the FlexNet installer downloaded from this link (https://fme.safe.com/downloads/) is Build 11.19.2. And it looks like bonding with FME Desktop so that we cannot upgrade FlexNet Publisher individually. How can I upgrade the version of FlexNet to version 11.19.6.0 or later? Thanks in advance. Best Regards,Qubbie

Hello everyone, I transformed some Orthophtos in a new coordination system and the nodata areas are black. How can I make these areas transparent? (The output data formats are TIFF and JPEG.)(I have read the related discussions, but couldn’t find the solution for my case.) Thank you for your help!  

Hi,I’m getting data from a streaming source (Kafka) that contains multiple geometry per feature read in WKT. To process the geometry, I “desaggregate” the feature first, produce a geometry from the WKT string, then try to aggregate it back with the Aggregator transformer. As stream processing doesn’t allow blocking transformers, I have set the Group Processing parameter to “When Group Changes”.My issue with this solution is that the feature leave the Aggregator only when effectively, the group changes which means when a new feature is read… I was wondering if there was a way to force the output of the latest feature, or if it was possible to make the process “Desaggregate/Produce geometry/Aggregate back” treat one feature per feature. Edit: this is most probably possible with a PythonCaller, I’m wondering if there was a “native” solution.

I’m wondering whether the dashboard workspaces for various versions are available online anywhere.I note that this question has kind of been asked before for a couple of reasons, most commonly that a restore and overwrites the dashboard workspaces of a new FME Flow installation.While it’s probably best practice to download the workspaces before the restore occurs, with the best answer for the previous question was for the workspaces to be attached (attachment is no longer available though), I’m wondering if it would be possible to have some hosted or available online, potentially via the FME Hub.As always, thanks in advance.

Hi all,I’m looking for assistance with calculating the Internal Rate of Return (IRR) in FME for a dataset containing annual cash flows grouped by a RecordID attribute.I’ve attached a sample CSV file ("Annual_cashflows_by_RecordID") that includes the data I’m working with. Each RecordID represents a unique group of annual cash flow amounts. My goal is to calculate the IRR for each RecordID.From my research, it seems the best approach is to use a PythonCaller transformer, but I’m not familiar with Python coding or how to configure this transformer for the task.If anyone has experience with similar calculations or can provide guidance on setting up the necessary transformers (or Python script), I would greatly appreciate your help!Cheers,

Hello!I am new to using FME and I am working on converting an FBX file storing a 3D terrain model into a CityGML format. I have come across with two questions. How to generate a TINrelief from an FBX file in FME? Does a TINrelief have/need a GML/JSON encoding in CityGML/CityJSON for conducting further geospatial analysis? Can it be a TIN file or a Geotiff file?Thanks!

Hi!I have a list, containing between 5 and 50 values (varying). How can I append a value to this list? I can only assume there has to be a non-pythonic way, but I struggle to find one. My approach was to use AttributeCreator, but I can't dynamically specify the position in the list. Had the list size been fixed, then that's a solution - but not in this case.Any ideas?

Hello Forum, I have two polygon datasets, each with just one object in it. The edges of the two polygons abut in places. I’ve created a workspace where I‘m reading in the ‘Above’ polygon dataset and the ‘Below’ polygon dataset. I want to create a line feature of where they share a border. To do this I’ve used an Intersector which gives me a new _overlaps attribute… The exact line I require is where _overlaps = 2… So, I added a TestFilter to filter out where _overlaps = 2…  But when I wrote that to a new feature no geometry was created. So, I added a LineBuilder, hoping that that would force the line to be drawn. But the resulting FeatureWriter is still not creating a line dataset - it creates a dataset, but with no geometry.  Any ideas?  Thanks,Stuart

Hello Forum, Is it possible to artificially create a polygon based on the lower edge of an existing polygon? Imagine I have an existing polygon, I’d then want to create a new polygon that snaps to the lower edge of the existing polygon. The depth of that polygon doesn’t matter, for example it could just be roughly 50 metres away from the shared boundary. What really matters is that is snaps to the lower edge of the existing polygon. An alternative approach could be that the artificially created polygon is a doughnut polygon which wraps around the existing polygon to say, a depth of 50 metres. I could then split it manually where required…  I hope this makes sense. Any ideas? Thanks,Stuart

Hello everyone, I have some published user parameters, and the choices will be retrieved from the database. Is there any way to have the user parameters to be updated automatically once the workspace opened? Thank you everyone.

hi !FME name machine parameter does it exist? I see the name of my computer at the beginning of the log but I don’t find where is this parameter.Thanks !

Hi, I have a time format like below (hh:mm:ss) and I want to round seconds as below. What is the best option to achieve this? 00:00:22.464 > 00:00:2200:01:22.825 >   00:01:23Thanks in advance for your feedback. 

Hi folks!I am torn as to what workflow to use between FME and python. I am more comfortable with FME so hopefully FME would be the winner here.The workflow I am trying to achieve for the business user is to have a GIS editable feature layer containing field summaries translate into a docx with a table template (ideally with the same attributes as the GIS feature layer).A sample of the table template in the docx is below:Any time a new field summary project gets entered into the GIS editable feature layer, ideally, a net new Word document with a separate table with populated values from the GIS editable feature layer will populate in the corresponding values in the table within the docx. Any updates that are made to existing field work project records within the GIS editable feature layer would have the updated records/values also translate into the associated Word Document with table template values as well.So in the above, the values from the project name, date, crew, permits, divisio

Can you convert a Polygon M shapefile to a Polygon shapefile?

Before I updated to Form 2024.1.2.0, when I added a writer it would automatically name the Feature/Table and assign the geometry type. Also, if there were multiple readers in the workspace the add writer function would prompt to select individual or all feature/table names associated with the readers. Now the writers have to be individually added, named, and assigned a geometry type. This can be very tedious and time prohibitive in many cases (which goes against all things FME). Is there a default setting that I’m missing?