Best Answers

FME Desktop 2020: How to concatenate based on a particular field when working with “AreaOnAreaOvelay” tool? When performing the “AreaOnAreaOvelay” tool, I wanted to create a field at which the values of the “autocad_color” field are concatenated as per the screenshot below. How this can be accomplished?           

FME Desktop 2020: How to filter all features that are “not equal to” a particular value,  For example, in the screenshot below, I wanted to filter all polygons that autocad color doesn’t equal to 10. How this can be performed in FME?      

I have created one text attribute using the AttributeCreator transformer and by default, its length is 50, there is no option to change this length in FME. This attribute is created for the feature class to save filename which is over 50 characters.

I receive an empty shapefile from our client and if I don't add any features, have to rename it.Since FME is feature based it won't write to a new shapefile if empty. The shapefile can also not contain a null feature so the NoFeatureTester or a null Creator is not an option.I'm currently on FME version 2019.2.1 How can I write empty shapefiles?

Hi! I'm trying to get the effing per-cell formatting to work in Excel but I'm not succeeding. My excel output doesn't come out with a yellow background. Please check my screen dumps and help me figure out why!

Hi guys,just wondering when using AreaOnAreaOverlay on single input, can it add attribute to show which records's overlap which? Currently i only get the overlap count option but ideally I'd like each record to be added as an attribute field and with a return value so i can see. Thanks in advance 🙂 

I inherited a flow with an embedded transformer.This transformer uses a variable, for example $(TARGET_URL), but I am unable to gather it's value when paused on breakpoint.

Hi everyone! I was trying to use the CurveFitter packaged transformer in FME 2019, but I received a weird message, telling me that I'm not authorized to use/download it (because of some licensing problem). Here is the message : Note that everything is OK with FME 2021 (it seems that this package was converted into a "real transformer"). I'm also able to open a workspace that includes this transformer with a 2019 version (this FMW : https://community.safe.com/s/article/using-and-understanding-the-curvefitter-transforme). However, I'm not able to access to it via the quick add or the transformer gallery.. So it's not really efficient. PS: I'm using a FME database edition + I've already done an update of the transformer gallery.

I recently inherited a workspace (sorry for all my other questions related and thanks for your time and patience 🙂)The problem with the workspace is that it has over 1400 transformers, at least according to this command of my provenience which might be incorrect:cat my_workspace.fmw | grep \<TRANSFORMER |wc -lI can hardly orientate myself in all the logic, since the canvas won't fit to my screen even at the lowest zoom. I only managed to oversight it printing to A0 pdf:Anyway, I don't know if this is common in real life FME projects. Are there any best practices regarding the complexity and extent of the workspace? Are there any possible performance drawbacks with bigger workspaces?My intuition would be to divide it and execute the resulting flows separately with WorkspaceRunner, but I cannot find a clear recommendation on it in the docs.

I was able to implement this in the python caller which produces the result but when I substitute the hard coded data for "myList" it does not work for me.import itertools myList = [  ['a1', 'b1', 'c1'],  ['a1', 'b1', 'c1']]for x in itertools.product(*myList):  results = list(itertools.product(myList))  print (x) How do I pass the output in my list out? How do I substitute myList with the data from my DB. CODE in Python Caller which lists results in the translation logimport fmeimport fmeobjectsimport itertools# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameterdef processFeature(feature):  pass # Template Class Interface:# When using this class, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameterclass FeatureProcessor(object):  def __init__(sel

I inherited a flow with an embedded transformer.This transformer is being reused multiple times in the workspace. If I put a breakpoint in it, I don't know how to find the place it is being called from the main flow.

 FME Desktop 2020: How to count the number of dissolved polygons and store them in a field? For example, in the screenshot below, I wanted to create a field that stores the the number of dissolved polygons. How this can be performed?     

FME Desktop 2020: How to identify the overlap (duplicates\\intersection) within the same layer? I couldn’t figure out how to identify the overlap (duplicates\\intersection) within the same layer. For example, in the screenshot below, what I wanted is to identify the marked area of intersection.      

Hi,  I have a script that I want to use in FME server. The script is creating vertexpoints from an excelfile and the outcome is points with relevant attribute. However when I run the script in my FME desktop and attach a geopackage writer that saves a file locally it creates the points without a problem. But in FME server nothing happens which is strange since it does create other polygons in the geopackage file. But the vertexpoints that are created in the script are not created in their respective geopackage file. Does anyone know why? I have attached the fme script.

Hi team, As i am new to FME Desktop, I 've created 3 workbenches like Add, Update & delete processes. I need to run these workbenches in following order.1.Add2.Update 3.Delete Kindly provide which transform can i use to fulfill the requirement without FME Server option.It will be highly appreciate for your Solution. RegardsVIPLAW

I'm just trying to do a simple join of LSOA areas and an excel with some ONS data, joining based on the field 'LSOA_code'. The join mode is set to inner and appears to join based on the visual preview below from the joined output port but when I write to gdb, the fields I want to add from the excel don't appear to be exposed in the writer.  

Hello!We've got two Engines (FME Server 2020.1.0.1). The workspace accesses files which could be accessed by only one editor. But the workspace can be started by many users. How do I prevent running the same workspace at the same time on both engines? The FME Server should detect whether the workspace is running. If the workspace is running, the new job shall be queued.  Thank you for your help!

I have a workspace1 when completed posts the topic message to another workspace2 that subscribes to it. I get details about the status of the workspace1 which is received via the JSON file in the topic message (FME_TOPIC_MESSAGE). Is there also a method to extract the published parameters of workspace1? I tried HTTP caller with the link to the log file with a GET request but I am not able to achieve it 

post-install steps:fmelicensingassistant_cmd.exe --floating <your license server> <Your FME edition>

On our FME Server (version 2019.0.2) we have many Automations running; and many Automations include a schedule.I would like to get the time and day when the Automation is running. I can't find this in the API, is there any other way I could extract this information?

Hi, I'm very, very new to FME and I'm working my way through the FME Academy. Everything has been going swimmingly until I've got to the point of publishing workflows to FME Server as part of the Publish a Self-Serve Workplace to the Web section of the Automate Workflows module in the Integrate Data with the FME Platform trail - https://safe.my.trailhead.com/content/safe/modules/automate-workflows/publish-a-self-serve-workspace-to-the-web The issue I have is that the module refers to a gdb file called CommunityMap.gdb and I can't see it anywhere. It doesn't appear to be a resource on any previous sections. Am I missing something obvious? I'd really appreciate it if someone could point me in the right direction to find this gdb file. Many thanks Brendon

Hi, newish user here trying to figure out dwg to shp conversions. I've got the attached DWG file that has 31 feature types that I need to convert to SHP. But when I run the attached workbench it's projected to 0,0 what am I doing wrong? Thanks

FME 2020: How to label the output in the graphic part based on particular field? For example, in the screenshot below, I wanted to label the polygon based on the “parcelnumber” field but couldn’t figure out how to perform this  

FME 2020: How to join the none intersecting lines? In the screenshot below, I wanted first to break at intersection and then to join the none intersecting lines. How this can be performed in FME to end up with 4 lines?