Skip to main content

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,155 Posts
  • 12,966 Replies
3155 Posts
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
two API calls in a single automation

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.

1095
fme_can_do_it
Enthusiast
kibailey
Contributor
kibaileyContributor
asked in Authoring
Excel Writer: How to keep edits and append new features

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.

434
kibailey
Contributor
boubcher
Contributor
boubcherContributor
asked in Authoring
Find road facing Building

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

635
boubcher
Contributor
james_c_452
Supporter
james_c_452Supporter
asked in Authoring
Performance log of each transformer

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

424
james_c_452
Supporter
boubcher
Contributor
boubcherContributor
asked in Authoring
irregular polygon edges length

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

529
geomancer
Evangelist
bruceharold
Contributor
bruceharoldContributor
asked in Authoring
Anyone have a good way to drop a duplicate attribute name?

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.

425
bruceharold
Contributor
geomancer
Evangelist
geomancerEvangelist
asked in Authoring
Use a raster in HTMLReportGenerator

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

420
geomancer
Evangelist
nathand2
Contributor
nathand2Contributor
asked in Authoring
Update metadata for Geodatabase

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

1715
rosst
ivanbakker
Participant
ivanbakkerParticipant
asked in Authoring
Point styling using symbols from .dgnlib

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

101
james_c_452
Supporter
epro_admin
Contributor
epro_adminContributor
asked in Authoring
First time using FeatureReader and WHERE clause

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 w

302
epro_admin
Contributor
qubbiewu
Contributor
qubbiewuContributor
asked in Authoring
How to Upgrade the Version of FlexNet License Server

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

4734
crystalatsafe
Safer
n.d
Contributor
n.dContributor
asked in Authoring
Removing black areas in a transformed raster

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!

778
n.d
Contributor
kkq
Contributor
kkqContributor
asked in Authoring
Aggregation/Grouping in stream processing

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.

425
ebygomm
Influencer
milo89
Enthusiast
milo89Enthusiast
asked in Authoring
Are the dashboard workspaces available online?

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.

232
milo89
Enthusiast
maxelmer1997
Contributor
maxelmer1997Contributor
asked in Authoring
Calculating an Internal Rate of Return from a list of Cashflows

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,

1122
maxelmer1997
Contributor
cossy27
Contributor
cossy27Contributor
asked in Authoring
How to generate a TINrelief from an FBX file using FME?

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!

416
cossy27
Contributor
F
fhilding
asked in Authoring
How to append a value to a list?

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?

3236
syedh2993
Contributor
scarter
Contributor
scarterContributor
asked in Authoring
Intersector and TestFilter produces result, but no geometry

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

669
liamfez
Influencer
scarter
Contributor
scarterContributor
asked in Authoring
Artiificially creating polygons

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

955
liamfez
Influencer
nmily89
Contributor
nmily89Contributor
asked in Authoring
Populate User Parameters automatically

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.

533
nmily89
Contributor
alc33
Contributor
alc33Contributor
asked in Authoring
FME name machine parameter

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 !

322
alc33
Contributor
sunnywaygis
Contributor
sunnywaygisContributor
asked in Authoring
DateTime Format - Round Seconds

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:23 Thanks in advance for your feedback.

902
sunnywaygis
Contributor
hawaiialex
Contributor
hawaiialexContributor
asked in Authoring
FME vs Python in GIS editable feature layer and Microsoft Word Template Table

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

1146
hawaiialex
Contributor
ksjohnson
ksjohnson
asked in Authoring
Polygon M to Polygon

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

271
emmaatsafe
Safer
stearnsweaver
Contributor
stearnsweaverContributor
asked in Authoring
Issue when adding Writer

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?

515
evoteck
Enthusiast

Most helpful members this week

Badge winners

Show all badges
30,851
Posts

Popular tags

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.