FME Form

I have a workspace that reads a database table (no geometry) from a file geodatabase from an on-premise subnet server location. When running the workspace from a Desktop VDI, I get read speeds of ~10K every minute or so. When running the same workspace on Server, I am getting speeds of ~10K records every 6 minutes. I tested to see if the location of the FGDB was the issue by uploading the FGDB as a server resource which resulted in the same slow reading speed. In my experience, Server has always been much faster than Desktop. Has anyone come across this issue?      

Hi! This is a general question re: what's possible with FME's SDE capabilities. We have some automated processes whose SDE readers take in large amounts of data, and they take a hit whenever they encounter corrupted or missing indexes. We are considering setting up some 'helper' processes to examine the indexes separately before the data is read in the main workflow. I know, for example, that there's ArcPy methods such as ListIndexes that can be used to check some of their properties for any given feature.  I'm wondering if FME can natively do something similar and without, say, calling ArcPy through a PythonCaller? Are there any exposable parameters or validation tools (or does anyone have an approach) that could be used to examine the SDE's spatial and attribute indexes and flag problematic ones? Thanks!

Hi, I'm using the string searcher to extract some codes out of a text field. I can extract the first match or build al list with all the matches but is it also possible to extract only the second match of the third match?This in an example of the text. When it says "2 opladingen" then I need the first two codes that are in the parentheses, but they can't be in the same field as I have yet to join them with another table. I already found the right expression to find the codes \\d{3}[_][A-Z]{3,}  Er ontbreken nog 2 opladingen voor aanleveringsgebieden: (ZG Beveren aan de Ijzer (rietveld VLM): AQUAFIN (556_AQUAFIN), ZG Beveren aan de Ijzer (rietveld VLM): INTERCOMMUNALE WATERLEIDINGSMAATSCHAPPIJ VAN VEURNE AMBACHT (556_IWVA))<br/>Een inactief gebied mag geen data meer bevatten (ZG Beveren aan de Ijzer (rietveld VLM): VLAAMSE MILIEUMAATSCHAPPIJ (556_VMM) -> Bewerkin

Is there a transformer that creates an ESRI AddressLocator tool?

Hello, I’m looking for a way to classify (order) the lists within a list attribute. Essentially I need all lists that have a “phase” value of ‘R’ to be on listattribute{0}…all list values that have a “phase” value of ‘Y’ to be stored in listattribute{1}…and all list values that have a “phase” value of ‘B’ to be stored in listattribute{2}.  Using List Sorter, I am able to accomplish this as long as there is a list for all three phases. The data sometime has only 1 or 2 phase values (example: Y and B, but no R). If I sort the lists that only have two phase values, “Phase” = ‘Y’ ends up in listattribute{0}. How do a force a blank list value for ‘R’, so that ‘Y’ still gets stored in listattribute{1} and ‘B’ gets stored in listattribute{2}?.... listattribute{0} could remain blank  These lists need to be structured correctly so that I can run them through an XML Templater and have them placed in the

I've got a knotty problem that I can't seem to think out.I've got a CSV file that comes out of system A (the coloured section of the image). It's invoices that need paying against Purchase Orders. An invoice starts with a H (header) and has a number of D (detail) rows.On occasion a PO Item may have it's TAX split and the source system outputs the tax splits.The target system can only cope with a single line per PO Item number so I create a list and group on the appropriate columns and return a list on the ones I need to aggregate...Tax code - first codeAmount - sum of the valuesQuantity - sum of the values So far so good. BUT the DOC_ITEM (blue) must be sequential based on the number of rows in the actual invoice.It's

I have converted a large geoJson into cesium 3d tiles -- wonderful... but not when enabling terrain -- tiles are partially visible obviously due to elevation. Is there something available in FME to consider the terrain?

Hi all,When I try to replace "back slash" in a directory path to "forward slash" it works in all but the last occurence. Tried with Regex as well. Since I'm passing the path to a PythonCaller where I have to use double forward slash I get output similar to this: "C://Folder//AnotherFolder//3rdFolder/lastfolder".  I tried using AttributeSplitter and ListConcatenator and use // as delimiter. The output is the same and the last occurence doesn't have double forward slash: "C://Folder//AnotherFolder//3rdFolder/lastfolder". Is there some fundamental logic to this I'm not familiar with or is it a bug?Also I run the 2021.2 Beta, don't know if it could have anything to do with that.  Thanks!

See attached images. I'm trying to read a Geotiff of an engineering drawing. When I view it in 3Dpaint the pixel values vary between black, grey and white. But when I read it in FME all the pixel values are either black (0,0,0) or white (255,255,255). I want to sharpen the image by filtering out the grey pixels. But how do I read the file to expose the "grey" pixel values?

i used feature reader to read WMS (Web Map Service) , to read cartographic map .i would like to access thedifferent colors in cartographic map and use tester transformer ,to let the lines that include this specific color not showing .i would like to cancel the pink color from cartographic map .How could i achieve that ? Thanks in advanceFME 2018

I have received an 3D PDF and would like to extract attribute information. It is an export from Synchro PRO 4D. If there is an other possibility to exchange information from Synchro PRO 4D that would also be an option.

I have a gdb with domains with a lot of feature classes and tables. They all have 8 fields that are the same and the remaining fields vary from feature class to feature class. I want to populate those same 8 fields with the same value for all the features but maintain their schemas. I tried doing this with an attribute manager and writing with the template file geodatabase with the attribute definition set as dynamic. I've also tried adding the values to the attribute definition. I know there must be a way, I just can't figure it out! TIA

SQL Server Link Templates have DataSource.Catalog.Schema.Table and I need to update the DataSource value.

I have successfully written the data to an OGC GeoPackage (over 7.6GB) I dont believe any of the shapefiles would have exceeded 2GB Largest shapefiles wrote perfectly 174,649KBJust to add, I have in testing it cached the workbench and all translators have data passing through, with even the Log, logging the number of features written, only the outputs are blank

using FME Desktop, i have a workspace that looks at two databases and generates a csv with information from one database that is not found within the other database. i need to then send that csv file to someone via an email, however, the csv file contains 11k rows and the emailer is trying to send 11k emails. how do i send one email with the csv as an attachment?

i want to create a tool that digest real time traffic layer from Google map. So is there anyway legally that FME can export this layer into raster or shp file to be used in my tool? Thank you

It's quite possible I'm missing something rather obvious here. But I can't figure it out. Funny how when searching the web what I stumble upon is my own post from a year ago. What I have put together since is a workspace that reads CSV and spits out JSON. I've published this to FME Server (2020.2) and selected "Data Streaming" and "Job Submitter" as services. Now, I'm sending a CSV file from a web page to FME Server using some of the examples here, and effectively calling the workspace with a Javascript line like this:FMEServer.runWorkspaceWithData( repository, workspace, params, callbackFunction);This works gr

Hi I have seen a number of questions relating to this flowline of using ArcPro python with FME but I cant find a solution for my set up. I have ArcMap 10.8 and ArcPro 2.6 installed in same environment I am using FME 2021 64 Bit. I currently have a lot of workspaces set up to use acrpy for fme feature processing through the python caller. This whole flowline is working for fme and arcmap using 2.7 python. I want to replicate my workspaces to run the same processes using ArcPro with python 3.6 . When I run my workspaces that include python callers I get the following error message immediately on startup 2021-10-05 00:39:12| 0.0| 0.0|INFORM|Using Python interpreter from `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python36.dll' with PYTHONHOME `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3'2021-10-05 00:39:12| 0.0| 0.0|INFORM|Python version 3.6 loaded successfullyFaile

ArcGIS Pro has this geoprocessing tool "Multipatch to Raster" to convert multipatch (3D) vector data (shape file or geodatabase) to rasters. Does FME have this functionality? Seems to me the few rasterizers in FME only handle 2D data. I am at FME 2021.1.1

I want to try openCV, but I get completely stuck with no real error message at all. I tried a lot of different approaches, but even the simplest doesn't work whatsoever. Workflow for the simplest:Use the openCV comandline to mark positive samples and generate an annotation file. To make it as simple as possible, I tried 1 positive sample, resulting in this annotations file: F:\\temp\\opencv\\positives\\0.png 1 45 35 38 63 Next I made a folder containing negatives with 20 negatives (tried .png and.tif) Next up is the samplepreparer: negatives: use existing (tred overwrite too) positives:number of samples: 1width/hight 200 and 200 (tried numorous different values) I allocate a negatives and vec file location and that's it. No spaces in anny of the folder structures. I get rejected features.  Storing feature(s) to FME feature store file `F:

Hi Everyone, I have succesfully managed to use a Custom Parameter to extract traits from an Ifc File with the GeometryPartExtractor. But when using the same said Custom Parameter as the Left Value in a Tester Transformer, no filtering takes place. Can one use CustomParameters instead of manually selecting the Attribute Values?  Test: After extracting the Trait, I can manually select the now Exposed Trait as an Input to use for my CustomParameter, but that defeats the point as the Custom Parameter is not really a parametric input.   Example File: I have shown three ways I attempted to use the custom parameter:Top Tester: Trying to use Custom Parameter for both exposing the Traits in the GeometryPropertyExtractor and in the first Tester: No success Mi

Hello, My current workbench is outputting an incorrect amount of Polygons using the FeatureMerger Transformer and I think the issue is partly to do with the number of vertices that make up some of the polygons and the fact some double back?Or is it perhaps at the PointOnAreaOverlayer Transformers as they seem to be creating too many records as well? Hopefully my images capture in essence what I want to achieve and the issues I am encountering. Perhaps FeatureMerger is not the correct Transformer I need? Thank you in advance

Hi I am looking for someone who knows/has expierience how to transform GIS Tree cadastre/register Data into BIM Objects with simple geometric representation of Tree crown, habit, root ball and trunk and of course the register Information as Attribute Data attached?  If anyone has ever done such a project, or knows someone who knows someone. I would be grateful to get in touch to get some basic information about their Project. Greetings tobias

Hi, fellow FME-lovers! I have an interesting problem that you can help me solve in an efficient way. I have many pipe segements as solids in an ifc-file, see example in Test2.ifc. The pipes are in 3D and can be connected in all directions. (I'm not sure about the fittings but for now don't mind them.). Now, I need to calculate length per segment and I started working no a complicated scripts (2D and algebra...) but there must be more of an FME-way. I'm thinking along the lines of creating a center line from pipe start to end... If you have any ideas I will gladly listen.  Bonus: what if segments are bent? Will this be handled in you solution? Peter

So I have written out the points into each featureclass that overlay a polygon... but now I want to get a list of unique values of one particular attribute (with a total count value of each), for each polygon. So that means the unique list (and count) will be different for each polygon. I've tried this workflow using StatisticsCalculator to get total count of point attribute (that I want unique values for) and grouped by the same attribute. Then passed to AttributeCreator to create a new attribute with this value. Then passed to Aggregator and then fanned out to a writer. However, the values are the same. I need to calculate the total count of the unique values for each polygon. Please help.