Authoring

When I migrating a workspace from FME 2019 to FME 2023, the FMEServerJobSubmitter in FME 2019 version returns _status feature attribute which helps me debug if the job is suceeded or failed. However, when I opened it in FME 2023, there is NO _status attribute returned after the workspace runs. FME 2019: FME 2023:How can I get the _status attribute back in FME 2023? or is there any other way to get an attribute value similar to _status to info the user if the run is succeeded or failed? Thanks for the help!

I can see from the translation log after running with the GUI that there is a plugin imported that allows the readers to operate. How can I incorporate this plugin while running with command line interface?Here is the output from command line:fme "C:\FME\my.fmw" --BlockNameLookup "C:\FME\BlockNameLookup.csv" --DWG_InputFile "C:\FME\my.dwg" --DWG_MetaData_File "C:\FME\my.dwg" --DB_Input_CSV "C:\FME\my.csv" --PostGIS_DB_Connection "DEFAULT_NO_CONNECTION" --FEATURE_TYPES "" --FME_LAUNCH_VIEWER_APP "YES"                FME 2023.1.1.1 (20231011 - Build 23636 - WIN64)                        FME Form Fixed (node locked-crc)                               Permanent License.                        Machine host name is: mymachine     Operating System: Microsoft Windows Server 2022 64-bit  (Build 20348)                 Copyright (c) 1994 - 2023, Safe Software Inc.                               Safe Software Inc. Translation FAILED with 1 error(s) and 3 warning(s) (0 feature(s) output) Module 'acad

After upgrading to FME Flow and Form 2023.2 (Build 23764), I'm receiving errors publishing workspaces to FME Flow. Even when testing with the superuser credentials, I receive an error message. Has anyone else experienced this issue or have a workaround? Steps Taken to ResolveReinstall FME FormReinstall FME FlowRecreate FME Flow ConnectionsError Message2023-12-15 11:27:10|      |     |INFORM|Starting connection to '<redacted> FME Flow'2023-12-15 11:27:10|      |     |INFORM|Connecting to 'https://<redacted>' (web connection, authenticated login)...2023-12-15 11:27:10|      |     |INFORM|Successfully connected to FME Flow 2023.2 (build 23764).2023-12-15 11:27:12|      |     |INFORM|Connecting to 'https://<redacted>' (web connection, authenticated login)...2023-12-15 11:27:12|      |     |INFORM|Successfully connected to FME Flow 2023.2 (build 23764).2023-12-15 11:27:20|      |     |INFORM|Retrieving service properties...2023-12-15 11:27:20|      |     |INFORM|Successful

Hi I need to reproject from EPSG 7791 to wgs84 but I received an error I use data interoperabilit 3.2 with reprojector engine ESRI can you help please ? thx Francesco   

I have a bunch of attributes that I want outputted into a list on a pdf. What's the way to achieve this? Somewhat stumped. Thanks!

Hi all, Is it possible to add a generated histogram to HTML? I was going to output as a PNG also but wanted to export within an HTML dashboard. Doesn't seem like it is going to work based on the options of linked or from an already exported image.  Thank you!

We (Red Geographics) often organize masterclasses to show and tell people on how to do something in FME.Our last masterclass of the year is going to be the opposite. In the Anti-masterclass we're going to tell people how NOT to FME. It's gonna be a fun way to end the year and share some funny situations, oops-moments and things to avoid. I'd love to get some examples from FME experts from all over the world. What has been a blunder or a funny mistake you want to share that we can incorporate into our (Dutch) webinar?

Hi,Using FME Desktop 2022.2.1.0 against FME Server 2022.2.2.  Using an HTTPCaller to download a ZIP file (60MB) from a remote host, FME server (Windows 2019) started sending errors from a certain point in time. the workbench in FME Desktop still runs well.  Earlier downloads using this HTTPCaller worked fine with same settings in HTTPCaller.  Attached the error log. Any ideas? Kind Regards,Gerro   

Morning, I have two FME Form 2023.1 workspaces. one requires Use System proxy settings in FME options to be on, the other to be off.Other than use two different installs of FME Form (.1 / .0.2) with this set, is it possible to parameterise this setting in the workflow at all?

Hi,I treid to use css for this websitehttps://www.servizipubblicaamministrazione.it/servizi/saturnweb/Pubblicazioni.aspx?RicCro=1&CE=brnttcn1113 and I'm able to extract the value oggetto using tr:nth-child(-n+10) > td:nth-child(3)> a> span but I can't extract the title part because if I use tr:nth-child(-n+10) > td:nth-child(3)> a I receive back all the valuescan you help me ?  thx Francesco PS I read the documentation but I'm not able to find a solution 

Is it possible to set a style for an excel cell if setting attributes dynamically?

Hi, A simple case; insert some excel data into an oracle table and afterwards move the source file.The workflow consists of the following components: The data is written to the oracle table but no features appear from the output port on the featurewriter.Does anyone have a clue to why there is no output?Transformer documentation states that after succesfull writing all features appear from the output port.Thanks!

Hi there, This one is fairly simple, I want to combine so the duplicate count is on a single row for each discipline feature:  should look like:  Duplicate UniqueRail Track and Civil 40 22 I've tried aggregator and attributepivot and haven't quite got it across the line! Cheers! 

I would like to know how can create a reader with a dynamic schema. To be able to read the new schema from the source without doing a manual update on the main workbench because it's published on the FME server as a service. knowing that the used format is excel for both the reader and writer.

Hi can you help me to find the correct regex to extract only the string in bold (ALESSANO) \\\\199.168.30.208\\dati\\pippo\\PUGLIA\\ALESSANO\\INGRESSO\\ALESSANO\\tracciato unico.shp thx Francesco

Hi how can extract the line from the las (see picture) of these barriers ? thx Francesco

Hey hey ... I'm successfully writing feature classes from ArcGIS Map Server layers to GDB. My writer names and schema are defined dynamically because I'm iterating over many service layers (with a feature reader, driven by CSV rows).  I was able to name my feature classes based on a field (readable layer_name) other than the fme_feature_type, but rightly the writer strips s p a c e s and ( parentheses ).  I'd like to use the unmodified layer name as the geodb_feature_class_alias by setting a format attribute (which is exposed and connected), but it doesn't seem to ever take.  Advice on how to set this up is much appreciated. Thanks in advance.  

Hello, I have a workspace that is attempting to look for substantial changes to the schema/attributes of client data by comparing a past dataset to a new dataset. It does its job well, except for when it freezes. Irregularly, when processing one of its featurereader transformers, FME freezes completely. When it does freeze, the FME process is hung and will not stop/free the license until the machine is rebooted.  I am running this workspace via the CLI, but the freezes have happened running from the GUI as well. When it freezes, the log file appears to be attempting to either find a plugin to use for the file, or merging the schemas (based on the last thing written/what would be written next). The freezes sometimes happen on the first featurereader, sometimes on the second. I have grabbed the last lines of the log file below from a recent freeze. This workspace normally takes ~90 seconds to complete, and is still running 16 hours later. I've waited over 48 hours before with no change. 

I like to use bookmarks in my workspaces, both to hide stuff, to navigate and to run specific parts. If I collapse/un-collapse a bookmark my organized workspace ends up as below. Anyone recognize this issue? 

 Hi, I'm basically trying to create a dashboard summary of my data but in the statistics stage, want to clarify I'm heading in the right direction as my knowledge of transformers is still young.  I'm aggregating information based on a string searcher and want to collect all the object errors from the files and output them with the code name.  Hopefully this makes sense with the assistance of the below images (spreadsheet snip is a distilled version of what is in my attribute manager), in short aiming to get utilities - 10 duplicates, 5 outliers, Road - 20 duplicates, 10 outliers etc. Thank you. 

We are upgrading from FME 2019.2 to 2023.1. We migrated our server schedules and are testing them. I have a workspace with 3 feature writers, one each for insert, delete, and update on an AGOL feature service. When I run it on the server the log says it's performing inserts, updates, and deletes.When I download the workspace to FME Form 2023.1 and open the Feature Writers, the Feature Operation shows Insert for all of them!Is this expected?

I am having issues using Feature Reader to access ArcSDE geodatabase in FME Form 2023.1. When opening the Feature reader in the old FME version, there is a DataSet option to select after choosing the Format. I also have the option to create connection files as a user parameter. Now in FME Form 2023.1, After selecting Format, the Dataset option changed to Connection. However, when I try to select a new connection file within the parameters, I am unable to find the option. In my previous FME workspace, I utilized connection files as user parameters. Please let me know if I am missing anything while configuring the Feature reader to read ArcSDE data in FME Form 2023.1. Thank you!

So i have a sheet that contains a bunch of unsorted rows, and i want to read the most recent file, create separate tabs within the existing file for each unique attribute value and then copy all of the rows with that value into the associated tab. So i've got an excel reader to read the directory, then i'm sorting the files to get the latest one, sampling just the newest one and using featurereader to feed into the writer. i've attached a copy of my workspace for reference, as well as an input file. i've been trying to use this article as a guide:https://community.safe.com/s/article/fanout-1 but what is happening right now is the writer is creating a new file, with NULL as the filename with the new tabs, and, then editing the original file with an empty tab named "fme_blank_sheet" instead of writing them all back to the original file. here is a snippet of the original tab's data: so i'd like all of the unique specialchar values to be copied to their o

Hi I would like to make a REST call using FME HTTPCaller to Validate Network Topology as defined in https://developers.arcgis.com/rest/services-reference/enterprise/validatenetworktopology-trace-network-server-.htmI have obtained the token in the first call, and would like to pass all required parameters in the second call. (see attached)I am getting error:This FME Edition doe not recognise the '' function Any suggestions how the required parameters, inc the token can be passed to fmecaller

I am trying to create a webhook for a sheet in Smartsheet (https://www.smartsheet.com/ ). API documentation on webhooks can be found here: https://smartsheet-platform.github.io/api-docs/?shell#creating-a-webhookAs you can see in the diagram for creating a webhook, the webhook needs to be enabled after creation: this is where I'm having a problem and need some help! The "subscriber" (the callback URL, which for my test case I'm using a topic posted to FME cloud) has to respond with a 200 status and also echo back a "challenge" random number that comes in the response header by including it in the response header "Smartsheet-Hook-Response". Or it can respond with a json that contains this value in "smartsheetHookResponse" attribute.As you can see above, when I try to enable the webhook, the callback URL is triggering the topic (all good here; two attempts shown above). The highlighted string is what I need to return (step #5 of the image in