FME Form

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

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.

Hi everyone,  I have a workbench that downloads a extent from a bigger database by Esri (by using a Esri feature server reader) and writes it to a file Geodatabase that we host on a server. Our arcGIS users use a layerfile in ArcGIS pro that uses the file GDB as source.  I use windows task scheduler to run a batch script that starts the FME workbench every month (at mightnight, when no users are logged in).  For some reason the file geodb still has locks active during that time, which cause the overwrite database function in the FME writer to fail.  Is there a way to update the file GDB while the locks are active, or a other way this problem can be solved?

 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 All, I am trying to send the Kafka events but it not going through can somebody guide me on this .I am newbie to kafka topic .herewith i am attaching the screenshot of the setting which i have done . i also i am attaching the screenshot of the input file .

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.

How would one create a new line that lies right in the middle between two existing lines? Imagine that we have the blue and pink lines below, they are parallel but not identical, and we want to find the centre (doted) line between them.  I was thinking one could AreaBuild the lines and then chop the resulting polygon into shorter segments, use a CentrePointReplacer on the segments and then finally connect the points. But before I dive down that rabbit hole I was wondering if there was a more efficient method to achieve this? 

I want to write some 50000 features to Excel with fanout enabled by some attributes.One of the fanouts contains 23487 features and fails the workspace with the message Error running translation with 8179 features inputted to the writer. If I filter it out the remaining 118 fanout files get written to disk.I tried both normal writer and FeatureWriter. I have attached the workspace.I started with FME 2021.1.3 and updated to 2021.2.0.1

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

Hi, does anyone have any experience with the following error: - "Unable to connect to the File Geodatabase at '------'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147220893'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for details" We have recently just started receiving the error on all workbenches that are reading feature classes from a .fgdb. The error is inconsistent between what database it happens on and when (i.e. re-running workbench multiple times in a row, it may read a few times without issue). We have alot of automated processes that should run in the background that are now failing.We are using FME 2018.1 via ArcGIS Pro Data Interoperability and have recently had a company wide roll out of windows 10 laptops.

Attached is a testkit with a raster (geotiff 10mx10m), 3 overlayered polygons and workspace. I would expect that if I clip the given raster with the smaller polygon the raster sum would be smaller. Clipping with a larger polygon (which contains the smaller polygon) would yield a larger rastersum. The polygon named T20 in contained within T100 - but the rastersum is larger for T20 than for T100 - if the cellsize is 7 or 10m.The last transformer calculates the ratio on the rastersums between the different clips, and there doesn't seem to be any pattern.   

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.  

Hi Folks,we are trying to monitor sftp folders and kick of workspace when there is any new file or existing file is modified. something similar to DirectoryWatcher. any idea how to accomplish ?

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 

I have a dataset containing fields representing year and shape length and would like to know how to sum the shape length based on different ranges of years. For example, if I had years 2010- 2020 how would I get the following? 2010 = sum of shape length 2010 2011 = sum of shape length for 2010 and 2011 2012 = sum of shape length for 2010,2011, and 2012and so on up to 2020.  For reference, please see the attached image of my data set.  I've attempted to work this out using test filter using the "IN RANGE" operator but it seems to filter out the values for each consecutive year. Would creating a new field using a combination of math functions and string functions within Text editor in attribute manager be a better method?

Hello everyone, So I have many points and lines in my data set. I would like to extract those points that are not on/touch the lines.  May I ask how I can do that? Thank you and sorry for all the questions. 

Hello there,​So I have a list of data - Floor and units. For the units, it could have more than one categories (with space to seperate different categories). And I have a excel list that shows all the categories.What I can ​to do is to check all the Units are within the excel table categories. Might I ask how to do it? Since there could be several cateogries in one unit, I am not sure how what transformer I should use to solve my problem. Data:Floor UnitsG/F Lobby1/F Office Toliet Excel:TypeLobbyOfficeTolietBathroom Thank you for your help!

Sometimes when reading various files I get different behaviour for the coordinate system the FME chooses. Sometimes I see 'NonEarth_Meter' while other times is something like XY-M. Seems to be somewhat random, however, it could be specific to the input formatDoes anyone know if there is a difference of why both these definitions exist?

I have 2 readers. I am trying to add new fields and values from the 2nd reader to the 1st reader if there is a match. There isn't always a match and I want to keep the order of the records in the output. I'm trying both featuremerger and feature joiner but neither are reproducing what I expect.The featurejoiner failed because not all job records have a lineID. I still want all jobs in the output. One note is there the Lines have a 1:M relationship with Jobs. There is only 1 line record that would populate the output new fields.Thanks!

Hi, I am new to FME. I have a Mapinfo TAB file from UK Mastermaps which contains the map text ( housenumber, streets etc). I would like to conert it to gdb annotations to be used in arcgis.

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

I have exterior wall and balcony . I create area between two shapes.I attached example file and photo .

Hi, I have a polygon layer that represents the building footprint (attribute: building id). In .csv I have a list of apartments (attributes: building id, Apartman id). One building consists of x apartments. So, I need to x duplicates of the building footprint and each clone needs to have a different apartment id. I used the FeatureMerger to join shp and csv and clon to create duplicates of geometry but all duplicates have the same apartment id.

Hello there Just wondering why intersector and lineOnlineOverlay transformer are not giving the expected resulteven when the 2 features are intersecting Attached is Data in shapefile format