FME Form

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

Hi allFirst time poster, long time reader of all the great advice on this forum.using FME 2021.2.6 (work limitation)I am currently having issues regrinding my CSAR (Raster and Pointcloud) files while keeping the lowest value in its original XY position in the regirded area. Example of regirded squares with the smallest values being picked.Note: the gridded squares are just a visual example, I have potential looked at applying a Buffer to the soundings based on the (SCALE) area they fall into but have had no success yet. I also have an Area file (Shapefile1) that contains the regrid values (SCALE) I would like the effected CSAR file to be regirded too.Example: Of the desired regrid areas (Shapefile1) overlaying the CSAR file. I really have 2 issues currently affecting me that I need help with. 1)      I need to be able to regrid my CSAR files (RASTER or POINTCLOUD) by keeping the lowest values in the regrided area.2)      I have a Area file (Shapefile1) that contains the regrid values I

I have a summary query with GROUP BY, HAVING, and ORDER BY clauses and I would like to send an email with the results from this query. My workspace can send html results of a query of listing all the records but that is not the summary I’m looking for. The Aggregator transformer doesn’t seem to have what I’m looking for either. Is there a way to send the result of this query shown below? My data is in SQL Server.  SELECT caseID 'ID', count(*) 'Count'  FROM my_table  group by caseID  having count(*) > 1  order by count(*) desc 

Hello, i need some help here.I recently had my workbenches stop working. I am pushing updated into to referenced feature services in arcgis portal. I have re-created every reader, wriiter and parameter but cant get the same process to work again.I have made new workbenchs and new connection where i have just Readers and Writers (No Transformer) and i cant FME to push changes to featuer services.The error’s i am get is :ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Unable to complete operation.'. Details: 'No edits ('adds', 'updates', 'deletes', 'attachment edits', or 'asset maps edits') were specified.'BADNEWS: ARCGISPORTALFEATURES writer:Or“Could not find a layer/table matching the feature type”It Seem to JUST be a FME issues as i can access the Rest end point and use post to make edits, using fme i can update hosted serivces. It isnt a permssions issues and to my knowledge nothing has change on th

Hello, I am struggling with conversion of several thousands of XML files (same scheme, but different attributes) in to single Excel/CSVThe tool works fine for single XML but not for multiple at once,The XML has nested levels so I am using xml_Id and xml_parent_id to navigate thru and join tohether with featurMerger tool.This is on the other hand the reason why I am struggling with the batch processing - since when  multiple files are processed at once, the xml_parent_id is the same among files and the so data are ovewriting themself, or they are rejected in the feature merge with multi-reference error. Don’t you know if there os a way how to proceed? To run one by one, for example with Loop in ArcGIS works but it’s soooo slow. Thank you!