FME Form

Hi, I have a MySQL database which I'm using the non-spatial MariaDB reader to get access to. Most fields are coming into FME Desktop ok, with the exception of a unique identifier field. The source data has a field called rg_key_id which is defined as char(21) in MySQL. A typical value in this field would be 'RG 022000001' But, when read FME is setting the datatype as fme_binary and I'm seeing '52472020303232303030303031' as the representation of 'RG 022000001' Can someone please point me at a resource, or help me understand, how I can either honour the source datatype or change the FME datatype so that it's no longer fme_binary. Here is the Feature Information showing the fme_binary encoding. Many thanks Brendon

While attempting to set up a web connection to cityworks via FME/ESRI’s data interoperability externsion, the connection continues to result in “Unable to authenticate using the specified connection information”.  We are on CityWorks Server 15.4.2 so the authorization token is set to be passed by query string.  Any other changes or tips that we should try?

I have a complex workflow where a specific attributes, i.e. “PositionID”, which are referenced across multiple transformers. I need to rename these attributes to another name throughout the entire workflow. Manually opening each transformer to change the reference would be very time-consuming.Is there a way to quickly rename this attribute in all transformers without having to edit each one individually? Any tips or tools within FME that can help streamline this process would be greatly appreciated.Alternatively, next time I create a project can I set these up as parameters or variables and reference them that way and hence change them more easily? Thanks

Hello,I am trying to start a workbench that uses data from my enterprise geodatabase. I have a feature class called WaterDevices and it has attachments. However, the FeatureReader does not read the relationship class. I attached an example where does read the relationship class in a different enterprise geodatabase for sewer.I’m not sure where to start troubleshooting this. Any advice would be appreciated. I’m on FME Form 2024.0.3.0.  

Hi All -I have been trying to convert a GeoTiff (also converted to ESRI Raster to try it too) and write to ESRI polygon feature class. I have used the steps below….. However, the translation fails and I get the following error:“Cannot write a non-point feature to a point feature class”There are no point features at play in any steps. RasterCellCoercer output cell geometry is set to ‘polygon’ and writer is set to polygon too. Does anyone know what is wrong here? Is another step in terms of geometry replacement or definition needed? Steps: Reader to read the GeoTiff (or Raster). RasterCellCoercer to convert the rastercells to polygons. AttributeCreator to convert the raster cell value to attribute. In this case _band{0}.value. Relevant writer to write the result to polygon FC.Thanks in advance! 

Hey all, I'm trying to do some webservice calls with the httpcaller. Unfortunately i'm getting the famous SSL connect error. I've tried setting the 'verify ssl certificate' to no but i'm still getting the error. I'm using FME 2020.1 and as an example i'm trying to do a get on the next endpoint/url:https://jira.atlassian.com/rest/api/latest/issue/JRA-9 My http caller settingsThe endpoint in the browser gets a nice Json back as response. The httpcaller however doesn't. The certificate is a wildcard certificate (could the be an issue?).Can anyone check it out if it works for them or if they get the same result? Just wondering cheers

I have a Simple  PythonCaller code to delete all .gdb files is a directory import osimport time# Define the directory and the age limitdirectory = r"../../../10_9_1"age_limit_days = 1current_time = time.time()# Calculate the age limit in secondsage_limit_seconds = age_limit_days * 24 * 60 * 60# Iterate through the files in the directoryfor filename in os.listdir(directory): if filename.endswith('.gdb'): file_path = os.path.join(directory, filename) file_age = current_time - os.path.getmtime(file_path) # Check if the file is older than the age limit if file_age > age_limit_seconds: try: os.remove(file_path) # Delete the file print(f"Deleted: {filename}") except Exception as e: print(f"Error deleting {filename}: {e}")Now using FME Flow(Server) I want to send an email based the Result of this code If there was a .gdb file to be deleted! then I need to get and expose the name of the  delet

how to find the all paths between start node and end nodeexactly i have 8 nodes ,as point A,B,C;D;E;F;G ;Hi want to check the all paths possible what ever the length of path but i want to find any path available between every Node between Node A and the rest of nodes (B,C;D;E;F;G;H)then checck between Node B and the rest of Node (A,C;D;E;F;G;H)and so on ,i want to check between one node and the rest of nodesfor sure some of them has no connections liens ,i want to define that also which two nodes has no possible paths. i used shortest path finder but i think,it is working only to find the short path between path A and path B,but i want to find all possible paths between A and B even it is long or short and get the id of each line through this path . i prepared my network so all lines are connected without any gaps so i have now paths between some nodes and some not depend on the network .Thanks for any help

Hello,I am trying to start a workbench that uses data from my enterprise geodatabase. I have a feature class called WaterDevices and it has attachments. However, the FeatureReader does not read the relationship class. I attached an example where does read the relationship class in a different enterprise geodatabase for sewer.I’m not sure where to start troubleshooting this. Any advice would be appreciated. I’m on FME Form 2024.0.3.0.  

When I publish my workspace to our FME Server, and run it it works. After a while, published before Christmas 2023 -> ran now again, FME Server return with the following error: ArcGIS Portal Feature Service Reader: Authorization error. See http://fme.ly/AGOL401Error for more info. FMEException: 928221: ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '498' and the message was: 'Invalid token.'. Details: '' Trying to fix the issue I attempted to re-authenticate the web connection. The issue is, when I click on the 'Authenticate' button, then I get a browser window where I can authenticate myself against our Enterprise Portal and the portal returns a token. In other applications such as Jupyter the token needs to be copied and handed over to the requesting application. This would be here FME Server. However, FME Server does not offer any place where to place the token. How can I authenticate my w

Hi friends,I am trying to do converstion from a vertices to lines that I am working on for a somebody. He use a GPS to track prarire dogs for his work.So I looked at the shapefile he provided me and it has no GPS. So I create them with the latitude and longtitude. What I am trying to do here is to use the LineBuilder here and then use writer to create a new shapefile…It came out nothing…What might I go wrong here ? I work for US agency and we have FME Desktop 2022.2 version. Do not ask me why. Thanks

Hi all,I'm wirting a program and I thing is alos usefull for other: FME-Starter simplifies the opening of FMW files when installing several FME version. The program must first be associated with the .fmw file extension (Windows context menu, Open with). When opening FMW-files, it will check if there is an FME version installed that matches the last one saved.If yes, this workbench will be opened with this version. Otherwise a selection of all installed FME versions is displayed. If a hotkey is pressed when starting the program, the selection is also displayed. In the settings you can choise the hotkey between Shift or Control. On dircet opening the executable yout can choise the FME-version to run. In the settings you can choise a hotkey (Shift or Control) to run the actual version directly. With FMX-files (custom-transformer) the FME-Starter has the same behaviour with the difference that the file is opened for editing instead of installing it. The settings are accessible via the

 Hello dear community,For our student project, we need to provide an evaluation using the FME software. We obtain our data via a REST API, which has a limit of 500 records. The output is provided in JSON format, and the JSON is structured as shown in the code. { "count": 523, "totalCount": 523, "results": [ { "score": 0.3534, "object": { "id": "1234234", "type": "LO/LOV/LOVZ", "leikaKeys": [ "99005004114000" ], "name": "Reisepass beantragen", "teaser": "Zur Einreise in bestimmte Staaten benötigen deutsche Staatsangehörige einen Reisepass. Über die Einreisebestimmungen weltweit informiert das Auswärtige Amt auf seiner ...", "textBlocks": [ { "type": { "id": "835343545", "name": "Type (z.b. PostAdress, Telefon, Stadt, etc.", "description": "Beschreibung/Hinweise", "key": "KEY", "notPublic": true }, "text": "Da

Which transformer can I use to identify overlapping polygons in a single dataset and show them as the output.

Hello experts,I need suggestions or some help on getting FME workbench to output 2 excel files based on a user parameter which the user will be asked to supply before the workbench begins to run.Both files will be the result of tracing a feeder (the user parameter) downstream from its origin at the feeder/hypernode point.The first file I am trying to output should contain something similar to the below.So up to column G is trace and H and I is result of spatial intersection. This is based on the above screenshot which shows the feeder extension (brown line). The hypernode is located at the zonesub (blue square) and then we want all reclosers (red and white circles) along the feeder to be captured and outputted as well as the fire polygon(s) the feeder intercepts.The second file I am trying to output should contain the ids of any spans/linear objects which follow downstream of the point object until the line comes to another point object (recloser) and then carry on with that device and

I have a very large dataset where all of the polylines have elevation that should be measure data.  The custom transformer ElevationtoMeasureCopier is such a memory hog that the workbench is failing on my computer and on my server.  Is there a different way to copy the elevation data to measures? 

FME kullanarak cad dosyalarını gis dosyalarına nasıl dönüştürebilirim?

Hi folks, I’m trying to setup a writer to a MySQL database table with a calculated column. When importing the table from the data source, FME (correctly) ignores the calculated field, so when I look at the table’s attributes (screenshot below), the column is not listed. However, when I try to use the writer, the calculated field gets included in the generated SQL insert and so the write itself fails with an error that a calculated field can’t be written to:Error executing SQL query ('INSERT INTO `StageDate` (`Date`,`Year`,`MonthNumber`,`MonthName`,`Day`,`Weekday`,`WeekdayName`,`IsWeekend`,`AcademicYearCode`,`AcademicYearDescription`,`FiscalYearDescription`,`Checksum`) VALUES ('19000103','1900','1','January','3','3','Wednesday','0','1899','1899-1900','1899-1900',NULL),...: 'The value specified for generated column 'Checksum' in table 'StageDate' is not allowed.' Note the `Checksum` in the column list and the NULL at the end of the feature values. We use this same technique with an Oracl

We have been running FME Desktop 2022.2 on Windows Server 2019 machines for over a year, but found out last week any function calls to datetime or datetime reformating fails with this error “Failed to load timezone data. current_zone() failed: A mapping from the Windows Time Zone id "" was not found in the time zone mapping database”. For example, in the AttributeCreator, an attribute creation with the value being @DateTimeNow() got the above error. Anybody experienced this before and knew of a fix? Unfortunately I don’t have the option to reinstall FME on those machines.

Hello, A related question & answer to mine is here:However, in my case, the layer being updated will likely contain features already.  In the DWG Writer, selecting to “Preserve Template File Model Space Data” will add data to the layer being updated, but of course will also preserve the existing features already present on that layer.  This essentially is just adding more data to the desired layer (resulting in many duplicate features) - which I don’t want.  I want to replace the features on that layer and preserve the features on the other layers.  Because I want to preserve other layers as they exist already in the template, I can’t select to not “Preserve Template File Model Space Data” in the DWG Writer.What would be the best way to essentially replace the existing features in selected DWG layers?BTW, these layers are coming from an Enterprise Geodatabase.

I have a dataset that contains the “_related_suppliers” field that contains either 1 or 0; I would like to add a counter that will increment, whenever the _related_suppliers field changes;  Is this possible?

Hello,I am abeginner with FME.I created a workplace test with a reader component PostgreSQL, a transformer component et a CSV Writer component.All it's works.I would like catch errors if there is un problem with de connexion to database or to write the csv file in a log file or send mail but there isn't a connection error like Talend to catch errors.How can I catch errors with writer or reader component?Thanks for your help

I have two workbenches, in which the emailers fail every night, the error being:Emailer_<Rejected> (TeeFactory): Emailer_<Rejected>: Termination Message: 'Emailer output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''Error encountered while calling method `input'for the one that runs first, and:Emailer: <class 'TimeoutError'>: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respondfor the second. First is an all out error that terminates the workbench, the second just being a warning, but the outcome is the same - no emails sent! It works perfectly fine on FME Form, and it was working perfectly fine on FME Flow for the last 2 months, now all of a sudden, it has stopped. This isn't affecting

Is it possible to write lines into IFC4x3 with FME and how to do that since IFC4x3 now supports lines?

Hi there,Today I noticed something peculiar when working with data from a PostgreSQL DB (that includes the PostGIS extension).Initially I used the PostgreSQL reader in an SQLExecutor to query for some specific data, and also included the geometry column 'standardized_location’ in the select statement.That seems to output the geometry column in a ‘Hex Encoded OGC Well Known Binary’ encoding. Using the GeometryReplacer I turned this back into a ~'fme geometry object’. If I then however filtered on the GeometryType, it shows up as a Polygon, where I knew in the PostGIS DB the standardized_location geometry column was defined with type ‘geometry(MultiPolygon, 4258)’.I then used the ST_AsEWKT(), ST_AsGML() and ST_AsGeoJSON() functions to return the geometry from the database in some different encodings. If I use the GeoJSON or GML encoding in the GeometryReplacer, the geometry does still show up as a MultiPolygon feature. Also the EWKT encoding depicted the geometry as 'MultiPolygon’.Furthe