A space to discuss FME Form
Recently active
Working in FME Workbench v.2024.2I am working on a process that validates my metadata format and converts it if needed, then exports the final format to xml for backup. We are trying to ensure all of our metadata is in ISO 19139, but we know some feature classes are FGDC CSDGM Metadata. We would like to use FME to convert the format and then update/write to the existing feature class's metadata in our enterprise geodatabase with it. Secondly, we want to also create a backup of the xml file which will be saved to a local folder. I have done this using an "Attribute File Writer" and only writing the geodb_metadata_string to a .xml file, however, when trying to reimport it into ArcMap/ArcGIS Pro I receive a "Failed to import metadata" alert. Comparing it an export directly from ArcGIS it is clear they differ. It seems like FME is converting it to their own format when reading it in.Any suggestions on either of these processes would be appreciated, thanks!
Hello. I’ve read an old closed thrad saying that there was an issue on virtual machines with FME 2023/2024.At our side we did not experience any issue on virtual machines with FME 2022-2024.But we just installed FME 2025.1.1 and get this issue “SetThreadDescription entry point not found in Qt6Core_fme.dll.Any idea? Stille the same issue?(It is on Windows 10 Pro)
Ive been wondering about this for quite some time now, but couldn’t get any satisfying reply so far. The only solution I had in mind was to create a pythoncaller that automatically checks this..but that does feel a bit supoptimal. Maybe I am missing something? I’m building a daily monitoring workflow in FME Flow (REST API v4 / fmeapiv4). Goal: once per day I want to store counts like “successful runs” and “failed runs” for a specific repository + workspace.I currently use the /jobs endpoint like this:GET /fmeapiv4/jobs ?status=success &repository=repo%20Name &workspace=workspace.fmw &limit=1000 &offset=0Problem: I only want today’s runs (or a specific day), but according to the Swagger docs for GET /jobs the available query params are things like status, repository, workspace, sort, limit, offset, etc. There is no start / end or other date range filter.Swagger notes:default sort is by timeFinished descsorting supported on workspace, timeFinished, timeStarted, statu
If you have ArcGIS Pro installed on your machine then you have access to the arcpy.geocoding module with its Locator class, which can be serverless. This puts geocoding in the hands of anyone with (say) a file-based locator.
Hello,I am a student who is discovering FME and learning it through self-training. I have a dataset that I need to process in FME, and I have been given the following technical requirements:Expected specifications:Each linear segment must not be longer than 10 meters. If there is no network point at a vertex of a linear feature, a point must be created with the following two attributes: Network depth (in cm): to be calculated according to the interpolation rules below: If there is no depth value at both the upstream and downstream ends of the linear feature → set depth to 100 cm. If there is a depth value at either the upstream or downstream end only → interpolate from the known depth to 100 cm at the unknown end, ensuring that the difference between two consecutive points does not exceed 20 cm. If there are depth values at both the upstream and downstream ends → interpolate the depth between them, weighted according to distance. If anyone has suggestions on how to implement thi
In the Esri ArcGIS Portal Feature Service I can reference a Feature Service in the parameters with the service name and an ide.g.But in the Esri ArcGIS Feature Service it’s not possible without a group? Is this correct?Is there some secret syntax i’m missing?
Newer SDKs (v4/5/6) of the ECW image format supports a fourth alpha band. This seems to begin to occur for rasters from drones. It would be nice to include support for the new v4 (or even v5 and v6) of the ECW SDK in FME, as newer versions of ArcGIS Pro is able to open these files and support are arriving in AutoCAD Civil 3D as well, even though there still seems to be occasional issues with large four-channel ECW files in AutoCAD. The support for newer ECW SDKs in other GIS software, that FME often supports with data in many workflows calls for the inclusion of support for the newer ECW SDK version in FME too.Support for the newer versions would be desireable in both reading and writing.
I have written a workbench were user can upload a excel spreadsheet and the workbench will convert the coordinates in the spreadsheet to a variety of different coordinate systems.The last step is a dynamic(excel) writer which works perfectly if I give the new coordinate attribute (column) a generic name (new_X and new_Y).I introduced a bulk attribute renamer to add a suffix reflecting the new coordinate system ( for example: X_WGS84 and Y_WGS84) which makes the output more intuitive and will avoid any confusion.When I do this the dynamic reader changes the order of the output columns to alphabetical.All the spreadsheets are different, so I don't think I can use a template.Is there an easy way to achieve this?
Hi,I would like to know how to pass a dynamic variable to the FeatureWriter that is generated in the SQLCreator at the start of the process. If I explicitly write the name of the feature class name it works, if I try a pass the table name identified in the SQLCreator it fails, it looks like it is passing an empty string as the nameBelow is a screen shot of the table_name variable being used. Below is a screen shot of the name being written, this works.Thanks for any assistance.Elliott
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.