FME Form

I export a shape file, the prj file includes only this: PROJCS [ "MAGNA-SIRGAS / Origen-National" which is the name of my cs. What I have to do to have a correct prj file?

I dug out one of my old FME 2014 workbenches. It has this PythonCaller defining a local CRS. It had worked beautifully for years.import pyfme#define custom CRSmyCSMan = pyfme.FMECoordSysManager()fmeParams = {}fmeParams['CS_NAME'] = "local_polyconic_cs"fmeParams['DESC_NM'] = "Dynamic CS"fmeParams['DT_NAME'] = "WGS84"fmeParams['PROJ'] = "PLYCN"fmeParams['UNIT'] = "FOOT"fmeParams['X_OFF'] = 0.0fmeParams['Y_OFF'] = 0.0fmeParams['MAP_SCL'] = 1.0fmeParams['SCL_RED'] = 0.9996fmeParams['SOURCE'] = "HESS"fmeParams['QUAD'] = 1fmeParams['ZERO_X'] = 0.0001fmeParams['ZERO_Y'] = 0.0001surf_lat = float(feature.getAttribute('surf_lat'))surf_long = float(feature.getAttribute('surf_long'))        fmeParams['PARM1'] = str(surf_long)fmeParams['ORG_LAT'] = str(surf_lat)myfmeCS = myCSMan.defineCoordSys(fmeParams, "myfmeCS") Now I am at FME 2024 where

Hi all, I would like to trim the first 7 characters from all the columns in my dataset. I think this can be accomplished with the BulkAttributeRenamer. But I'm struggling with the String Parameter. Any ideas?

Hi there,I don’t know if I am doing something wrong but I am trying to use the new ESRI ArcGIS Feature Service connection to read a public layer from another organisations AGOL account. I have it working using Standalone Server as the source type. I can’t seem to get it working using the ArcGIS Online source type as I don’t have a login to their AGOL and I don’t need one as it’s public data. I can only login to our own AGOL account.Anyway I have this working - it’s reading the data but I am now coming across the whole reading dates as Epoc time again and my DateTImeConverter is spitting the dummy.I have updated the reader to v3.20.1 and I have checked out the article below:Esri ArcGIS Feature Service - Reads Dates as Epoch Milliseconds | CommunityIt is showing that you need to change

Whenever I try to open the AttributeRenamer transform properties, FME Form crashes. It doesnt matter if it is an existing workflow or if I start a new one woth nothing but only one AttributeRenamer. Any thoughts, anyone? The screenshot below if from FME Academy: But it also happens on an otherwise empty workflow:  

Hi thereI’d like to convert the whole OS MasterMap Topography layer for our district in to individual 1km DWG tiles which are to be accessed in a variety of CAD packages.I have had some success in converting a Geopackage of the above layer, through a MultiClipper to create the individual grid squares and finally written as a DWGs with the output ‘fanned out’ by each 1km grid reference number.When one of the resulting files was opened in CAD, the geometry was present, but none of the attributes. However, I will try the UK OS MasterMap Topography Layer (GML) Reader, once my GML download is available from the OS Data Hub site.Would anyone who has had some experience with this type of conversion kindly forward me some tips or advice on how best to achieve populating a DWG, or series of DWG exports with the attributes from the file which is being converted, please?Many thanks :)

Hi.This is either a no-brainer that I haven’t figured out, or not doable, I think. But it’s a simple task.I need to count the items in a JSON array, but I need to do it in a looping custom transformer, so it needs to be non-blocking.In a custom transformer, I use a HttpCaller to get a JSON response, which includes an array of items. I may have to issue more http calls within the custom transformer, so it contains a loop back to its input.JSONFragmenter can easily find the array items, but as features, not in a list format, so I need to use a blocking transformer like Aggregator to count them. This is no-go.So either I need to extract the JSON array items into a list, and use ListElementCounter to find the length, or count the JSON array items in a different non-blocking way.Does anyone have a solution for either of these tasks ?Cheers.

Apologies if this has already been asked - seems like it should already have been reported.FME Form 2025.0.1FeatureWriter Version 0Writing to Esri Geodatabase on MSSQL Server 2019When using either Create if Needed, or Drop and Create table handling, the geodatabase_sde writer appears to ignore the table qualifier set on the feature type. The table gets successfully created, visible in SSMS - but under the default user database schema eg: domain\john.smith.FeatureClass1 However the flow then fails because at some stage it does take into account the table qualifier and is looking for a table called sde.FeatureClass1

Hi,has anyone had any success creating User Parameters for the SharePointOnlineConnector Site, Document Library and Path values?I’m using FME 2025.2.2 (latest version) and SharePointOnlineConnector version safe.microsoft-sharepoint  [1.13.1] (latest version)I would like to embed a SharePointOnlineConnector in a custom transformer but I don’t want to hard-code the Site, Document Library and Path values. However, when I create User Parameters to expose these as custom transformer parameters I am not able to actually select values for them. I have also tried creating User Parameters for these values as input parameters for a SharePointOnlineConnector in the main workspace but run into the same issue.This is how my SharePointOnlineConnector is configured (I have used all default values when creating the User Parameters):

I’d like to maintain my database documentation in an Excel spreadsheet like this:Attribute Name FME Data Type LandID int32 Acres real32 Name varchar(128)  And then I’d like to import that into an AttributeCreator. When I try importing, the attribute names come through, but FME Form sets all the data types to varchar(200) instead of what I specified in the field ‘FME Data Type’ and imported in the import dialog.How can I fix this or set up my spreadsheet differently?

Hi all,I am attempting to create an FME script that looks at the FWI information provided as a WMS by NRCAN to perform some risk analysis based on the WFI cell values. When I load the WMS into ArcGIS Pro and examine a cell, I can see a discrete WFI value: (It is hard to tell from the picture, but this display is showing up when I click to examine a single cell. As I click around in the polygon, the WFI value changes.)When I load the data into FME, I cannot seem to get that FWI value to be exposed. When I click a cell in the investigator, this is what is returned:

Hello,I have a main FME workspace where I call multiple child workspaces using WorkbenchRunner.The issue is that even when one of the called workspaces is terminated, the WorkbenchRunner still reports the execution as successful.My goal is to stop the main workflow immediately if any problem occurs in one of the child workspaces, so that the next WorkbenchRunner does not execute. What is the correct way to ensure that: If a child workspace fails (error or termination), the main workspace stops immediately, And subsequent WorkbenchRunners do not run? Any recommended best practice for this scenario?Thank you.  

Does anyone know a good built-in or pre-created solution to read “Tabular JSON” that’s in a format of schema followed by values rather than key:value? See example below. I have ~40 schema values but only included 2. I’m looking for something dynamic rather than manually assigning column names in a specific order.{ "schema": { "title": "Data Export", "type": "array", "properties": { "id": { "title": "id", "type": "integer", "default": "", "minimum": -2147483648.0, "maximum": 2147483647.0 }, "code": { "title": "code", "type": "string", "default": "" } } }, "data": [ [ 1, "DEMO1234" ] ]} 

I have a SQL Server Database that has 156 tables. I need to extract the schema for each table and table names into a CSV. I know one way is to add all 156 tables to the workbench as separate Readers and then use FeatureReader (with Features to Read set to Schema Features). This could be a start, but it seems rather tedious.  Is there a better way? I want to write to a CSV that has the attributes in one column and the table names in another column.  Any thoughts on the best way to tackle this?

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)

Hello everyone,I looked at thread DGN writer RGB color | Community and I am dealing with the same problem.Ideally I would like to get the RGB color (true values) instead of the colorindex from the color table.I read in the above thread that true color should be available from FME Form 2023 on, but I still get the index number from the color table. Iam using FME Form 2024.2.1 by the way.I do the following thingI have a dgn styler configurated as follows in the Writer I use a seedfile with RGB values for the layers Output is 

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.Swag

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.

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.

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