FME Form

Hello all,I want to build a Tester that detects if an attribute value has a left-bracket in the stringFor example;ASCOT (TOOWOOMBA REGIONAL)Would be detected, because it has brackets surrounding TOOWOOMBA REGIONALI then want to extract just ASCOT and throw away that part of the string in brackets 

hi everyone! some of my line features (ex. pipes) have text features floating above (top left) of the line, describing what type of pipe it is. I want to add that text as an attribute field to that feature. but also not all of the lines have one and I want it to only match if it's describing that feature (not grabbing a random text field nearby). This is my workflow so far, with some brief descriptions. I'll also note that everytime I've tried to use neighborfinder, the autocad_text_string AND fme_text_string values of certain lines show numbers (ex. 356.77, 623.44) instead of the descriptive text it should have shown. im guessing those are possible distance values it’s grabbing….I've been trying this for hours and would appreciate any help given. thanks in advance! my workflow is attached below.

Hi All,I am working on an automation process to generate cutlines for use in a map series. These cutlines must have a consistent length and be positioned within the overlapping areas of the map sheets. In addition, the cutlines need to follow the orientation of the main alignment to support accurate mapping production. Below is an example illustrating the challenge: I have tried several workarounds, but I have not been able to get it to work.Any ideas?Thanks :)

So im reading the dwg file to fme, than just want to put it out to elswhere, while converting the elements to an autocad block. The problem is that no matter how i parameter the feature writer, it messes up the output dwg file. So the elements need to look like this:But after writing out to the new dwg they look like this mess:I also put the feature writer parameters here:I tried to aggregate the features, in that case this problem doesn't occur, but than i loose all the colors and other attributes, which is not an option.

Hello all,I would like to automatically record different Output Port names ​​into one new attribute. So in the newly generated output file there is al column with the name of the Output Port and a column with the value from the TestFilter.Desired outcomeI know it is possible to do it by hand, place a AttributeCreater behind every port and fill in the Output Port name. But I have a large number of TestFilters, and to avoid errors and keep things organized, I would like to do it automatically with one AttributeCreator/AttributeManager.If the AttributeCreator/AttributeManager is not the correct transformer, or I need two other transformers that do the job, that would already make a big difference to me.  A snipped of my workbenchI have asked AI for answers, but there was none that worked. AI referenced mentioned the following options: fme_feature_type and @portname(), which for me resulted in a column containing the text "fme_feature_type" or in the second case "@portname()", but not the

Hello, I have an Excel Spreadsheet that I need outputted in a specific format. I am only working with 175 records, so I could complete the customizations using Excel in a couple hours. But, I wanted to run this by the FME Community first. Here is a screenshot of the spreadsheet output format I need:Column names must be bold. Col A cells need to colored yellow. Col A cell values need to bold and red. Whenever there is an X in Col A then the entire row needs to be bold red The APN column needs to counted with the total shown in the row of the above screenshot.At this point I am not looking for specific instructions on how to set up a spreadsheet like this. If you can provide any that would be helpful. I know I would use the Excel Styler Transformer. Maybe the Aggregator Transformer to sum the APN column, But can someone provide me at least a general idea on how to set up a spreadsheet like this using FME? is it possible? What parameters would I use/set up using the Excel Styler? Given I

I was busy creating a Custom Transformer and wanted to link a Published Parameter to the Advanced Parameter 'Maximum number of iterations’.  However, the dropdown option shown below did not pop up. This screenshot is showing a workbench derived from this tutorial:Looping with Blocking Transformers – FME Support Center Any clues?

Hello, I use the TemplateToDocumentBuilder. All numbers are formatted equally. I would like to format as current. 4233,78 --> 4.233,78 €How can I do this?

Using various recent versions of FME Form, I’ve discovered that a common key field that we use to join datasets on has a sloppy join when the FeatureJoiner Comparison Mode is set to Automatic.Since Automatic is the default comparison mode and the results are not at all what I would expect, I find this somewhat concerning. One needs to get into the data a bit to realize that the join is happening in a sort of loose/”like” fashion instead of a clean match.The key values are alphanumeric plus other characters such as a period or hyphen. As an example, on a subset of data, these are the record counts with the default Automatic comparison mode: And these are the record counts with the String comparison mode: The Automatic comparison mode is joining ID values that are close, but not the same, at least in some cases by dropping a trailing “0” (or more than one trailing “0”) and making bad 1:M matches instead of the expected 1:1 matches. For examples: and The above is in FME Form FME(R) 2025.1

Hoping someone could provide me with a comlplete example of how to use fmeobjects.FMEFactoryPipeline() in a PythonCaller Specifically I would like to take points as in input and use the SurfaceModelFactory with the undocumented parameter MAXIMUM_EDGE_CALC_LENGTH to hopefully produce a mesh with trimmed edges.   

I am using feature reader to connect to an ArcGIS Online feature service.The feature service has multiple layers in there. I want to use a where clause against 1 layer only to filter the results from that table, but not apply the where clause to the other tables. 

I am reading a dwg with object data table in it. I set the mode to Group by Object Data. (set the workflow options to single merged feature type)I then created a tester to distinguish which features have been attached to the table. (tester_8). Then i use an attributekeeper. The OD table attributes are not available in the keeper. Then attach the same exact tester (tester_11) and all of the features fail. If i remove the attributekeeper the features route correctly. Also after using data preview correctly and viewing cache in the attributekeeper, the data preview will never show the OD table attributes again (add the reader again)Also setting additional attributes to expose does not stick. Each time i go in to the reader and update features i must add all the attributes to expose. These two problems seem to be related to each other. 

Hi All, I’ve tried to add in a custom coordinate system and it just doesn’t work. I’ve restarted my computer twice and the co ordinate system won’t come up in the csmap reprojector. I would love to use the online webform that has been created, but I am unsure at which username and password is required to log-in. My usual FME doesn’t work. I’ve created a file in the FME folder in documents and edited both coordinate files in the reprojector folder. This is what I have written below:# COORDINATE_SYSTEM_DEF PerthCoastalGrid1994     \\#      PROJ TM                                  \\ #      UNIT METER                               \\#      SOURCE "spatialreference.org"            \\ #      DT_NAME GDA94                            \\#      EL_NAME GRS1980                           \\ #      DESC_NM "Perth Coastal Grid 1994"        \\ #      GROUP AUSNZ                              \\ #      PARM1 115.8166666666667                  \\     #      ORG_LAT 0                                \\  

Using truncate and append with arcsde geodatabase writer . The SDE is on an orace database.Inserting 3milion rows. FME on prem takes 1 hour. but when on azure cloud it takes 8 hours. Any idea how to improve this.Any parameters that I can tweek.

In the column 'knoopnr', each feature consists of a fixed ID (in this example 'HT005500') and a variable ID (B1, B2, BL1, ...). The fixed ID is therefore identical for every row within a project, but it differs from project to project. In another project, for example, the fixed ID could be 'KWL735' for every row. Is it possible to identify the fixed ID and retain only the variable ID?

I am trying to read geometry of the leader lines from the Pro Annotation feature class.In the attributes which I see when loading it in the Data Inspector, I only see geodb_text_leader_line_anchor_point which contains correct coordinate but no geodb_text_leader_line. Does anyone knows if reading of the leader line from Pro Annotation is supported?I am using FME 2025.1.0.1.I tried changing reader parameters “Split Multi-Part Annotations” but it makes no difference in the way annotations are red.

I am having an issue converting data from an Excel file to xml due to an invalid character reference. In Excel the character appears as a space but as a square or “GS” when read in FME (see images). I am trying to build a validation tool that will find cells in the Excel file that contain these special characters. How do i find these characters using for example  test filter, attribute validator or stringsearcher etc 

Hi allI have been batting my skull against this for some time and havent been able to come up with a solution.I have about 60 datasets (and will be receiving about 60 every month from now on) where every line has a date and a time and a value containing a number. See attached file. its a dataset from a callcenter where every line is and hour and the number is the number of staff that are answering phones. the number of staff varies from hour to hour and from callcenter to callcenter. but the dataset only contains date hours where a staff memeber has been checked in, if none have checked in here isnt a line. My task is to find the ‘missing’ lines/hours where no staff has been active to monitor if the callcenter has been unstaffed when it shouldnt have been. I cant figure out a way to find these missing lines and add them in an automated way the i can use over and over again. Has anyone tried anything similar and found a solution?

Trying to create a new branch version, then update geometry on the existing features. I have the new geometry joined with Object ID from default, but running into issues on the safe.esri-agol writer.Where version was set to "Jan272026b":ArcGISFeatureServiceWriter: The ArcGIS REST API returned an error: HTTP Error Code: 400 : 'Unable to complete operation.' Message Code . Further details: '['Object is missing.']' Where version was set to include username "admin.Jan272026b" -- CASE matters. I went back and changed it to “ADMIN.Jan272026b” and now I’m back to getting the first error of Object is missing.:The ArcGIS REST API returned an error: HTTP Error Code:  : 'Invalid version name. [The Version name contains invalid characters. (admin.Jan272026b)]' Message Code . Further details: '[]' However when I look at the versions, I see:versionName: ADMIN.Jan272026bversionGuid: {9466ACCA-2E0A-4D75-9789-CE40F1E941BA}

 I’m currently working on a project in relation to building a major road network which can be used for future traffic surveys.  I’ve hit a snag where I’m trying to find potential way of detecting branches within the carriageways so that we can set a condition that should the branch be longer than 500 metres, then we need to separate this branch as its own features.  What I’m struggling with is trying to detect the branching by applying unique identifiers (e.g. integer values) if branching occurs within a connected groups of features, something similar to the below: Essentially, I’ve built a two-way road network using the Ordnance Survey road network data and I’ve merged the road sections based on their connectivity (using the [NetworkTopologyCalculator] and [LineCombiner] transformers) and also depending on their ownership (i.e. locally owned vs centrally owned roads) and their road classification number (e.g. A303, A1(M) etc.).  Within each of these merged features we need to work out

I am trying to join SQL data with csv data.  The field coming from SQL is uint32.  The field in the CSV is Char but converted to uint32.  Im joining the sets on this field and I get no matches.  here is the SQL data:Here is the CSV date after conversion to uint32:Feature Joiner information:Ive tried the following:Changing comparison mode between numeric and automatic - no change Changing both datasets to be char(4) - no change used Feature Merger - no result change.What am I missing here?

Hi, Is there anyone able to make the Quebec Adresses Geocoder work ?https://servicescarto.mern.gouv.qc.ca/pes/rest/services/Territoire/AdressesQuebec_Geocodage/GeocodeServerI can’t make it work and don’t know why.Thanks! 

Found that I had an old thread on the same subject. My question now should be: Are there any new methods that are faster than those suggested in the thread above?  --original question---I am trying to speed up a work bench. What I have: DTM georasters where the highest (statCalcMax) cell value of each raster has been extracted into an attribute. The other cells have been given a nodata value. What I want: I need to find the x-y postiton of the cells that have a value in each raster as fast as possible. I would like to find a way to somehow filter out only pixels that have a value before any spatial/geometry processing. What I tried but found to slow:The methods below convert the cells into points before identifying the cells I need. This makes them really slow.RasterPolygonCoercer › CentrePointReplacer › CordinateExtractor RasterCellCoercer › CordinateExtractor PointCloudCombinerAny ideas on how to find the position of the desired cells with as little spatial/geometry processing as pos

Hello All!I am trying to geocode a series of addresses that are in a CSV using a geocoding service on Portal/ArcGIS Server (11.x). I have the web services connection authenticated and specified in the tool, and have tried the URL with and without the “findAddressCandidates” section - the results are still being rejected stating that the address hasn’t been supplied. I’ve also tried using a string concatenator to create the address string before connecting it to the Geocoder transformer & I’ve also tried to call out the address using its individual components using the text editor and calling out the specific fields in the format of “100 Street Name, City, State Zip”.I feel like there’s something obvious that I might be missing - I’m just not 100% sure what it may be. Thank you for the help in advance! 

I just updated to version 25.2 and my oracle reader is failing and throwing this warning (not an error):An error occurred while fetching from query `SELECT a.*** FROM *** a' : OCI_SUCCESS_WITH_INFO: ORA-24347: Warning of a NULL column in an aggregate functionWhich causes Translation FAILED with 0 error(s) and 1 warning(s) (0 feature(s) output).My colleague tried the same on version 25.1 and whilst he also gets the warning his translation does not stop and he gets all features to work with. (As did I before my update)Ignoring the fact that the view should be fixed, is there a way to continue the translation with all features? Troubleshoot option Ignoring failed readers simply skips the reader and thus returning zero features.Furthermore I did see a few changes regarding oracle in the changelogs but I could not pinpoint which one is referring to this problem.