Best Answers

Greetings, I created an Automation and when one of the workspaces fail I would like to receive an email that includes in the body the actual text of the error(s) as shown in the screenshot below, not necessarily that format, but at least the text.In the Email (External Action), I added these keys, but when the workspace got an error, I received the vague and cryptic text here in the email body:Error Message: A fatal error has occurred. Check the logfile above for detailsError Type: DeadLetterJob Status: FME_FAILUREJob Status Message: A fatal error has occurred. Check the logfile above for details I would assume that “Error Message” would include something like what is seen in the screenshot.Any ideas how the log file errors can be added to the email body? 

When using the Transaction Type: Versioned Edit session in an ArcSDE geodatabase writer, all edits will be rolled back in the event of a translation failure. The geodatabase writer is set to Insert records in my workspace and I noticed numerous duplicate records after the translation failed due to conflicts identified during reconciliation. Do we need to modify anything in the writer? Thank you!

I’m a newbie using FME although I have also experience with SQL and GIS. I recently started working on a transformer using the AttributeManager. This contains ~ 40 attributes and the goal is to convert part of those attributes based on different conditions, and others attributes based on a same expression: @double(@CurrentAttribute())I was wondering if there was a method to apply the same attribute expression on several input attributes at once while keeping everything in one transformer.Thank you in advance!

I recently upgraded my FME Workbench install on Ubuntu 22.04.  Everything had been running correctly before this.  I had set up the .profile in Linux to point at a much larger hard drive (7 TB) rather than the small 50Gb drive they have configured as the HOME/default.  When I am running processes on large data sets (hundreds of millions of records) the temp fills up with gigs of data so I needed that pointed to that larger drive.  After installing FME 2024 it is acting like it doesn’t see the FME_TEMP setting and longer.  I even went in the .profile this morning to check that it was still there. Have there been any changes made to the software related to this setting? If not, how do I get workbench to start playing nice again? Any information or guidance would be appreciated. 

I have a column of data with a 10-digit alphanumeric value.  I need to keep those values and in a new column return just the last 5 characters of that columnI thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost.  I use this exact same string function in MapInfo all the time and it works like a charm.  But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.What am I doing wrong?results inThanks in advance

Hi Community, I am working on developing a workbench which is basically reading Data from ESRI Enterprise Database and Writing to another DB. I am using ArcGIS Pro Version 3, FME Desktop Version 2022 and FME Flow Version 2023. I am able to connect and read data using FME Desktop But the published workspace while reading the data it is showing error “779 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 780 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 781 2024-3-19 11:07:16 | Performing query against GEODATABASE_SDE dataset `' 782 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 783 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 784 2024-3-19 11:07:16 | Opening the Esri Geodatabase reader 785 2024-3-19 11:07:16 | An ArcGIS license is already checked out. The product checked out is 'Advanced' 786 2024-3-19 11:07:16 | Ins

I have been working on FME for a while now. But not much with geo-related issues.A user receives requests :  With and without address. Requests without addresses do contain coordinates (in both RD-Amersfoort and ETRS89)The user would like to see a map with a polygon in it.What steps/attributes do I need to realize this?I have already tried with the following attributes : AttributeReprojector, AreaBuilder, HullAccumulator Please give your advice and tips

 Dear FME community.I got xml data with geographic location,  I tried to use coordinateExtractor but I could not get x and y coordinates and I could not also visualize the polygon using FME inspector. How do  Extract the X and y attribute? Any idea would be apricated and thank you in advance.  

Hi There,i have workspace and trim transformer - Post/processe/Radarsat2/20240313 for example, it should leave 20240313 name of the file, but it remove 2 at the begining, 0240313 remains as file name. How to keep that “2” at the beginning? 

Hello,I have two polygon datasets: folios and townlands(see image below). For the most part, the folios(grey outline) are nested neatly within the townlands dataset(red outline) so the outer folio boundaries are shared with the townlands’ boundaries. I would like to extract the areas where these two datasets’ polygon boundaries cross...i.e. where they are not nested neatly. Most of these will be slivers.  SpatialRelator(and Tester) helps to extract the offending folios using the Spatial Predicates Test: "Requestor OGC-Overlaps Supplier" however the output is the entire folio polygons(not overlapping area) as SpatialRelator does not edit the input dataset. I am unsure as to what to do next, I would like to automate this process in FME Server if possible so having one workflow would be useful. 

I’m doing a project where I have to generate and compare multiple DTM TIN-models. In regards to this, I wonder: Is there a difference between TINGenerator and Surfacemodeller in regards to how the triangulation algorithms work?How does the triangulation algorithm(s) work, in more depth than that it is delaunay triangulation?​​​​​​​Are there any other transformers/methods to produce TINs in FME?

I am using ArcGIS GeoEvent Server 10.6.1 and FME Form 2021.In FME Form, is there a way to either reset the statistics in GeoEvent Server or notify me via an email when the Count reaches a certain number? For example, in GeoEvent Server, there is a Count column. I would like an email sent to me when the Count reaches 1,200,000. Currently, GeoEvent Server does not have a way to notify a user if the Count reaches a certain number. I was wondering if there is a way to do this in FME Form?  

Hi!I have many workbenchs to manage and I would like to find a way to create a table linking the workbench name with the output writers of each workbench. The goal is to find which workbench generates which table(s). My idea is to add a custom transformer to all my workbench. The information I would like to have is :name of the workbench directory of the workbench writer information (table name, table qualifier and writer)With ParameterFetcher, more specifically, the FME_MF_DIR and FME_MF_NAME parameters, I can get the information about the the name of the workbench and directory. But I cannot find a way to extract the information of the writers. All the writers I have are in a postgis format.I would prefer not to use Python if possible. I’m sure there’s a way to extract the information since it appears in the log, I just don’t know how to get to it! Thank you 😀 !

Hi FME community,Just wanting to ask has anyone had success using a HTTP Caller or a connector to obtain data from Konect  server? Cheers.

Hi there, I am getting an Error on Windows Server FME 2021.2.5  when add Reader FGDB and tried to open Tables. (Geodatabase Error (-2147024894) Please see the attached image for more details.I have used FGDBs many times using FME, Windows Server Patches installed by the IT Department recently and it seems since then I am having this issue on FMEI have tried on different servers, ie: Windows 2012 & Windows 2019 and FME on all servers have the same issue.I can drag and drop FGDBs on to the FME Workbench canvas without any issues. Could anyone help me to identify this issue and let me know how to resolve it?thanksRegards,Pushpa

Is there a way in Form to find out the active FME Flow Connection when running a workspace?I thought it might be a (hidden) parameter somewhere, but I can’t find it immediately, and it doesn’t seem to appear in the logs either.I was wondering if I could use it to determine which environment I’m working in, setting up a development parameter is an easy workaround but might be useful one day to know/log the active flow connection anyways

Hi, When I try to overwrite a layer in AGOL using the AGOL Feature Service Writer it creates a duplicate feature layer, with a different feature ID. I need to overwrite as there is a schema change in the data and i’m trying to avoid creating a new feature layer as we’ll have to re-configure the downstream map services.I ran the same workbench on a different environment and it had no issues overwriting the layer I was pointing at. Any ideas on how to get this to overwrite?I’ve attached a screenshot of the settings I'm using 

​Hello guys, Damjan here,i have problems with my FME process so i need your help.  Task:I have 1 dwg file with 6 polylines (3 pairs), each pair must go to PROCES (process makes a polyline between 1 pair, that's fine all works), then process must save this polyline in dwg and go to start for next pair.Shema: FME:DWG GRT: Each polyline has an attribute id which represent pairs (for example: 2 polylines (grt_dt & grt_lt) have the same id which means they are 1 pair), the second attribute is Description (DET_OPIS): grt_dt = right polyline, grt_lt = left polyline.  I add Creator to make counter, with the Attribute manager making the same attribute like in dwg (GRT), and then connect to tester. My idea is that the tester test if value of counter equals to id. If its true, then go to process, when process finish, save to dwg format and then go to start for next pair.  Problem:I have problem in tester cause i dont know how to setup tester to make him work. If anyone know how to fix that or

Hello,I need to write the xlink:type in an AIXM5 file (see below)  But when I look at the User Attributes of the feature type AirspaceTimeSlice (AIXM5 writer), I can only see 3 parameters of the xlink which can be set: href, role and title.  Anybody knows how to write the xlink:type with the AIXM5 writer ?ThanksAndré

Hi All,I need to concatenate the two values of the same cell into just one line. I’ve been (partially) able to do it by using a StringReplacer but some of the cells show an space which make the StringReplacer not working, see below an example:There’s an space between line 2 and Siding, how can I make the final result ‘CE Siding’ ?  

I want to compare different methods of generating TIN-models. To assess the quality of each model, I want to calculate the vertical distance between each point in the input point cloud and the generated TIN in order to later calculate for example the RMSE. Any tips on an approach?

I am using FTPCaller. If I add the Emailer to the rejected port will it send me an email if the output gets kicked to the rejected port? I would have the Emailer already configured to send me an email. I want to double check with the Community since my workbench will stop running if the FTPCaller output is rejected. Here is a screenshot of a mock up workspace (note I have not set up the transformer parameters yet hence you see the red gear icons.) Not shown below, I know it will send me an email if the FTPCaller output is sent to Output.  

I want to write lines into an existing PostGIS table, which has default values for most of the columns. With FME PostGIS Writer, when executing the process, I have errors returning (in french):Bulk copy failed on table 'XXX' using delimiter ':'. Error was 'ERREUR:  une valeur NULL viole la contrainte NOT NULL de la colonne « YYY» dans la relation « XXX » I would like to use the Postgres default values for these NOT NULL columns, but I cannot find the way to do it.I use FME Form 2023.2

Hi FME community,I’ve been tasked with trying to get the metadata we hold (in a SQL server database) into an INSPIRE-compliant format.I was hoping that we could use the metadata we currently hold (Title, Abstract, Temporal Extents etc) and run it through an INSPIRE XSD template. However, it’s pretty overwhelming when I look at the XSD templates (which I got from here - application-schemas/schemas at main · INSPIRE-MIF/application-schemas · GitHub) as there are so many nested parts (see screenshot). Is there a relatively straightforward method I could use for each topic of data (be they addresses, parcels of land etc - which have their own topic under the INSPIRE framework) which could be joined in FME and output an XML file which can be imported to the data in ArcPro? It seems a bit convoluted but I’m just trying to get an idea of where to go from here with a large shift in metadata storage and how we will be using it at my organisation going forward. Thanks

Hello, I am trying to update the date field records of a feature class using arcpy update cursor, but I am getting the following error (text in bold), please let me know If I am missing anything :   Field Name : e_result_datetimeField Values : 20230803081554 Field datatype : Date Also, want to mention that I am able to update the string, double data type fields using updatecursor in FME with no issues - it’s only with date data type I am facing the problem. Python Exception <RuntimeError>: The value type is incompatible with the field type. [e_result_datetime]Traceback (most recent call last):  File "<string>", line 46, in inputRuntimeError: The value type is incompatible with the field type. [e_result_datetime]Error encountered while calling method `input'PythonCaller (PythonFactory): PythonFactory failed to process feature