FME Form

Hi, I have been trying to look into options/ possibilities for setting a format attribute in a Sketchup file. In more detail I'd like to set and write a [FME_JOB_ID] as a format attribute for some tracking and verifying purposes later on. I have used "GeometryPropertySetter" to set Traits and GeometryName with attribute value, but as the geometry could be deleted in the Skp file by user, attribute information could be lost.Therefor I tried to look into the SketchupParameters and the Schema Attributes section for writing format attributes instead of exposing. I also had a look into SketchUpFeature. Does anyone know more about the section "Attribute Dictionaries" and how it works, or any idea on how to track a Sketchup file by setting a custom ID? Thanks!  

I'm reading a feature layer from ArcGIS Online containing about 20 layers into FME, each one with proper domains and field aliases. Unfortunately, it is not possible to: first, resolve domains without including only code output attributes, and second, there is no option to "resolve" Attribute names using aliases. I'm then trying to find a time-efficient way to solve this by using AttributeRenamer. I'm currently importing an Excel schema that contains only two columns for Input and Output Attribute and the list of attributes I want to keep from the reader output. In the Import Wizard, I deselect "Sorted" (img 1) to keep the original order of attributes and then I set the "If Input Attribute Is Missing" to "Remove Output Attribute" (img 2). What I'm experiencing is that imported attributes from the schema are still alphabetically sorted despite the "Sorted" box being deselected (img 4) and second, when I run the transform

Relative beginner here! I'm trying to set up a workbench so it can take features, assign them groups and then assign sequential values per feature in a group. The Counter transformer does the first part but I need help with the second part. I've used the StatisticsCalculator transformer which adds sequential numbers but is there a way to add letters (e.g. a, b, c... and so on)? Or is there a way to do this in the text editor? Thanks for any help!

Helllo everyone, I´m quite struggling about loading files to MS Sharepoint on-premise. I´ve found some tutorials, but just for Sharepoint Online. Any ideas please?Lubo

 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. 

I have a workspace that inputs property polygons and bounding boxes from an oracle database and it feeds into a WMS feature reader to obtain a raster image. It then overlays property boundary as a redline on top of the image. How do I maintain constant height and width of the image without stretching it? The WMS I am reading from does not have scale hint, nor does it have scale denominator in its implementation.

Why are inputs or parameters the "\\" is getting changed to "backslash" when using FME Form 2023.1.0.0? Seeing it happen on Workspace Runner for log file as well as database name on database joiner. How wide spread is this issue? Previous version was 2021.2.0.1

I have a network of lines, and I need to identify the genuine odd one out.In the diagram below, the red lines represent "Active" lines and the pink lines are "Inactive" lines.Those lines that branch off from the network to a dead-end are genuine, the "Inactive" lines that have an "Active" line either side have been incorrectly attributed, and theses are the ones I need to identify. I am new to FME, so a nice step by step guide would be appreciated please.

Hi I have a LAS dataset that contain small pointcloud one for each signpost along a street. Mi goal is to extract the 3d coordinates of the controid of each small pointcloud.I tried with 3dbuffer but no results thx Francesco

Hi I have a GDB file with feature layers from ArcGIS Pro in it that I would like to use workbench to convert to CAD while maintaining the symbology colors. I have extracted the colors of the symbology in hex code format *(E.g. #ffffff) into the attribute tables of the layers. I added my GDB in as a Reader, added in an AttributeFilter, link the field that my symbology is dependent on back in ArcGIS, then added in a DWGStyler to every single possible option in that field in AttributeFilter. I set the color of DWGStyler to be the field containing the hexcode, and then added in my output vis writer and connected everything. But no matter what I try, the CAD file doesn't register any of that at all.As you can see, none of the hex colors seemed to have gotten into my CAD file.

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? Second, i made use of the FME Workbench and copied the table structue of the

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 be used in this way but I thought it was a nice finding and I'm going to try and see if I can use this approach to help compare changes across various projects. I was wondering if anyone has pl

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 ?