FME Form

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!  

Hi everyone,I am currently comparing lines in database A and database B, and I want to categorize them based on distance from each other:If line A < 10cm line B → class 1If line A 10 - 30cm line B → class 2If line A < 30cm line B → class 3I thought I'd do this using the Clipper transformer: if part of line A is within 10cm of line B, and another part of line A is 12cm from line B, I want line A to be split. See my workflow below:I have my Clippers grouped by ‘type’ and ‘level’, so [railroads on level 1] are compared to [railroads on level 1] and [road lines on level 2] are compared to [road lines on level 2]. I have Overlapping Clippers set to ‘Clip Interim Results’ and I am generating a list of IDs from line B on line A. This is the situation im currently facing:Database A in red, database B in black and a 10cm buffer around database B in grey. The darker grey area is where the two database B buffers overlap.In the situation above I want to compare ID_A = 1 to ID_B = 1, but ID_B

As title says, unable to convert lat/long to MGRS when latitude is -80.01 through -81. e.g., x= ‘100’, y= ’-80.1’ . I’m sure this isn’t the exact range but am able to reproduce the error.Was wondering if someone had additional information on how transformer calculated polar zones and, if there is preprocessing required for points located in south and north polar regions?Additionally, lmk as comment if you’re able to reproduce error in other FME versionFME Form 2023.2 

Hello, I’m trying to migrate data from a SQL Server 2016 spatial to a ArcSDE on SQL Server 2022. Using ArcGIS Pro 3.2 on same machine. I am using FeatureReader with schema and featureWriter with dynamic writer.   I don’t get any errors but I get thousands of this warning:GEODATABASE_SDE Writer: Renamed user attribute 'attribute{109}.name' to 'attribute_109__name' based on format constraints for invalid characters, length, and caseIf this waring occure the feature with this schema will not be written to the database, so it should yield an error not warning. yield waring on FME version 2023.2yields none-traceable error in version 2024.1Anyway I can’t figure out what it means. Any clues?  

I am transforming an IFC file to CityGML to upload the CityGML model to the 3DCityDB. I used the workspace published by Liz (https://support.safe.com/hc/en-us/articles/25407718003341-BIM-to-GIS-Intermediate-IFC-LOD-300-to-LOD-4-CityGML). The CityGML file created looks fine in the FME inspector. However, when I try to import the CityGML into the database, I get a lot of errors saying, “Failed to resolve XLink reference”. I was doing some research, and it seems the problem is that 3DCityDB does not support a gml:MultiGeometry with different dimensions (This is what they mention in the GitHub: In general, a gml:MultiGeometry is a collection of geometries that are allowed to have mixed dimensions: points (0D), curves (1D), surfaces (2D) and solids (3D). The 3DCityDB can handle geometries of different dimensions and collections of geometries having the same dimension. But collections containing geometries of different dimensions are not supported.). Is there a way I can modify the FME works

Hello, Here is what I need to do: I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. Looking for some ideas on what transformer(s) I would need to use before the Emailer.