FME Form

This seems easy but I'm not sure how to go about it. I want to do an initial match on ID1 and then detect if ID2 has different values. So A has different values in ID2, and B does not. Initial dataRequired Data   

Hello, I am exporting data to kml and in the placemarks list, an html table is included.I would like to have only the placemarks listed without the html table preview. Here is an example: What I would like to get is this:Would anybody have experienced this and know how to sort it out and make it look like the second one ? Thanks,Best regards,Thomas 

I'm trying out FME Flow 2023.1 and need to run my workspace with breakpoints. When I reach a breakpoint, the Feature Inspector pops up, as expected, but I'm unable to inspect the attribute values. A new column containing the Data Type of an attribute has been added and the Value column has dissapeared. The only thing I can adjust is to show the Data Type column or not. This makes the usage of breakpoints and feature inspection almost useless. I'm interrested in viewing the values for each attribute, the data type is rather irrelevant.

I am trying to set up a KafkaConnector to read from a topic. For the SSL certificate, I provide a keystore that I've used to connect through OffsetExplorer, but it is unable to retrieve the topics. Does FME expect a different type of certificate? I get the following error: An error was encountered while retrieving existing topics: 'Failed to create admin client: ssl.ca.location failed: error:0B084088:x509 certificate routines:X509_load_cert_crl_file:no certificate or crl found'. Please check host names and ports, security settings, and credentials

I just started with the FME AR app available in Google Play and deployed it on my Samsung A73 5g mobile phone. This supports ARCore and the Depth API. I also granted permissions to use Camera, Location and Notifications. I made use of the sample fmear file available at the FME site and tried opening that in the app. As the tutorial says, I should be able to see the sample AR content even without me having to be present at the true location of the assets in Canada. At the time of opening, I pointed the phone to the floor after which it displayed a message Searching for planes. This was followed by a display of an array of points on the floor on my house with a message Pick a plane for model elevation with a green circle like icon spinning. After i touched the points displayed on the screen, i saw a push buton like icon and a small box with a label Hydrant.  Pls refer to attached image. Am i missing something? 

Hi,I have a workbench that is using an azure blob storage connector. It runs fine on form but when I try to run it on flow I get the following error: I've tried to manually upload the ABSC.fmx file to flow, and to the workspace file repository but nothing seems to get me past this error. I can see the .fpkg file in the resources>engine. I've looked through documentation but can't find where I should placing this package. Any help would be much appreciated. Many thanks, Sam

Hi, I'm running a large workbench that I can't seem to troubleshoot as I'm getting the following on the log as per below. It runs fine on different smaller test batches, but upon running on the actual dataset it seems to crash or stop. Is there a way to override if there is a single file that is breaking the process? Log below. Thanks for the assistance (happy to include more files if need be). ListExploder (ElementFactory): Processed 7927 elementsCreating reader for format: Autodesk AutoCAD DWG/DXFTrying to find a DYNAMIC plugin for reader named `ACAD'ACAD_1 Reader: Using rich geometry.AutoCAD Reader: Successfully opened file xyz etc....AutoCAD Reader: Renamed attribute 'Sign Type' to 'Sign_Type' to remove the following invalid characters '<>/\\&$|:!~ ()"@'Error running translation. 

We have a lot of CustomTransformers which we use across projects and we also use git. I recently posted another question about the Workspace Compare tool supporting CustomTransfomers (.fmx files) but the answer is that it's not currently supported but it might be coming (https://community.safe.com/s/question/0D5Dm00000c770oKAA/any-plans-to-include-formats-and-custom-transformers-in-the-compare-application) I know that I can compare the transformers if they're embedded in a workspace, however, initially I thought this wasn't very helpful as the product is the CustomTrasnformer. I did some experimenting and digging and discovered that there is a way to "Export" a CustomTransfomer from a workspace via the command-line. It's very hacky and not really at all designed to

Hi Everyone, I have this KML and I cannot seem to figure out how to convert to shapefile without losing the data in html description field. Ideally, I want these to be parsed to attributes. Any help would be appreciated.

Hi,Is it possible to halt the normal data flow (preferably with a transformer), and ensure that a certain transformer receives and processes one feature at a time before the next feature is provided to it ? Some sort of "semaphore" or "street light" functionality ?I have a custom transformer that works perfectly, but its logic is only valid on a single feature.Plan B is to redo the logic, but if the above is possible, it would be much simpler.Cheers. Lars

I have a HttpCaller that reads different kinds of information depending on the user input and therefore the attribute column names are all the time different. With the JSONFlattener you can import the column names that you want to expose, but ideally I would like to expose them dynamically. I was wondering if something like that is possible.

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 have for example 10 excel files in the sourcefolder that all be read from FME but only 8 files have the right basenames to go through the first tester and the rest of the workflow.......i want at the end move the excel sheets from the source folder in a destiantion folder....all that works already.....but now the filecopywrter move all files from the source folder......how and where i can put a condition that FME should only move the excel files which have the right basenames? Cheers and greetzFranco

I have an excel containing 3 columns with name of Belgian commune in 3 format : one with dash (ex Saint-Nicolas), one its regex counterpart (\\bSaint-Nicolas\\b), and one without dash (Saint Nicolas). My goal is to replace, in a feature layer, the attribute with the dash by the one without the dash. So, for this, I am using a conditional replacement in attributeManager, but it fails ( @ReplaceString(@Value(attributeToReplace),@Value(xls_regex),@Value(xls_FinalName),caseSensitive=TRUE). It seems that it doesn't recognize that the attribute fulfill the condition. But, if I put my condition manually, one commune at a time (attributeToReplace Contains \\bSaint-Nicolas\\b, etc.), it does work ! What am I missing here ?

I want to write a different json file for every time window defined in my TimeWindower.To make things simple I'm using the window number as the window ID attribute (when I manage to make it work like this I'll use the window start time).I want to write the data in each time window into a different (json) file and to name them I want to use the window id attribute together with some other string.Right now the first file (string_0) is output as expected but the workspace will only output 2 json files for a total of 4 time windows (I used a terminator after the 4th time window) and the second one is not properly closed.Any idea of what am I doing wrong?

I want to tile cache images and write them to the folder by Mapbox structure with PNG files.I have tried using WebMapTiler to tile cache images and found it different from Mapbox structure.I tried also Writer Mapbox Vector Tile (MVT) Tileset to write them and i found that the folder structure was correct (Level-Row-Colum) but its file is pbf formatHow do I create tiling cache images with the same structure above when I use Writer Mapbox Vector Tile (MVT) Tileset in order

Hello!this is a long shot, but I hope I might find some help here.Is there a way using FME to write Operational layers to enterprise web maps?If you are familiar, there are widgets, like the Drew, which produces an operational layer, which is actually a temporary layer.I would appreciate any kind of help.Thank you! 

In a Esri ArcGIS Portal Feature Service that we are processing some of the GlobalID's are in lower case without the culry brackets. When FME reads these GlobalID's the case is being changed and brackets are added. Hence the GlobalID "26565f7e-615f-43a6-8333-e156adc7cb46" is read by FME as "{26565F7E-615F-43A6-8333-E156ADC7CB46}".  One problem comes about when FME can't update this feature using the GlobalID because FME as reformatted the GlobalID. This problem is verified by using FME to change the case of the GlobalID to lower case and removing the curly brackets which then allows the feature update to occur. My question is, how can I get the Esri ArcGIS Portal Feature Service Reader to read the GlobalID's without reformatting? 

I am calculating angle between two points using the geographical neighbor finder. This returns an angle which starts from East and goes counter clockwise. To map to geographic coordinates I use the formula 90 - angle, if angle < 0 then angle +360 This is resulting in a set of angles which when visually inspected appear to be shifted clockwise. In Washington and on the West coast, this shift ranged from 50-70 degrees. on the east coast, it ranged from 20-40. Louisiana sat right in the middle at 40 degrees. These shifts seem reminiscent of the transforms between magnetic north and true north.  Is there a way that I can derive angles from the geographical neighbor finder so that they line up with angles expected through inspection? Thank you.

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

Hi, I have 2 attributes that are text from a pair of text files, i want to combine them into a single attribute. I'm using an attribute text file readers to pick out the text, then creating an attribute for each of the text_line_data ouputs and naming them initial (first file contents): First string contents:******************************************************************************  THE FIRE TROUBLE CIRCUIT IS REPORTING A MALFUNCTION!  ****************************************************************************** 3 and extended (second file contents - second file's filename is contained inside the first file, hence the extra processing):Second file contents:

I have a Geospatial PDF file, I want to convert it to Raster (Geotif) but I can't put any text into the Raster output. I use the TextStroker transformer before connecting it to ImageRasterizer Transformer but it always error, I also tried some way to run the TextStroker transformer but I have just received only one message "Error running translation".Anybody help me! ..... I'm using FME 2023 version

Hi all,I am almost where I want to be with my FME script, however am encountering a road block as the final portion of the script is writing duplicate records and adding geometry to my target feature class, when I want the original records in the target feature class updated.I have two separate polygon feature classes, one entitled TDE Projects and another entitled TPL Corridors and Concepts. There is one Project Number (text) attribute that only exists in the TPL Corridors and Concepts layer that I want translated into overlapping polygons where TDE Projects and TPL Corridors and Concepts polygons overlap and have the Project Number from the TPL Corridors and Concepts layer inputted into the TDE Projects records.Right now, my script is performing the overlay correctly and inputting the Project Number into a new field I created in the TDE Projects table entitled "TPL Project Number", however it is also generating duplicate records/geometry.