- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

215 Posts

Most replies

Most views

buttonsmcParticipant

asked in Community Q+A

Connection To FME Hub in version 2021

Hi there,Has anyone found a solution to FME Hub connection in Version 2021?

Unique login to user for certificate exams

It is better, if Safe software application login process is unique. Since, login process was not there for attempting for certificate exams. It is asking mail and other details. Instead, it would be better, if profile is created uniquely for desktop and server

142

4 days ago

mestarijaakkoParticipant

asked in Deployment

Arcis Online Connection

Hi,We updated our FME Flow from 2023 to 2024.2.1 yesterday. After that workspaces that have connection to Arcis Online not inside our network are not working. Those that are in our internal network still work.Error message that we have is the same in all workspaces, we tried this also with a workspace that has only a reader and got the same issue. 53 2024-12-17 08:20:02 | Message Type: fme::internal::_v0::py::Exception 54 2024-12-17 08:20:02 | Python Exception <AttributeError>: 'NoneType' object has no attribute 'supportQueryStringAuthorization'

Is this an error in the training materials about the VertexCreator?

Hi Team, I'm doing the training for FME Professional, using FME Desktop 2022.2 and am now at https://safe.my.trailhead.com/content/safe/modules/turn-coordinates-into-geometry/exercise-turn-coordinates-into-geometry-using-the-vertexcreator-transformer . The last question on this page is about VertexCreator making a line instead of a point geometry. The question gives the impression that creating a line using this transformer is "a feature" from that transformer (and values the answer given accordingly), while the page https://community.safe.com/s/article/Known-Issue-VertexCreator-creates-lines-instead-of-points clearly shows that this is a glitch that was corrected in later versions. I suppose it was never intended for the VertexCreator transformer to create line instead of point geometry at whatever Mode setting? Besides, in FME Desktop 2022.2 I can't reproduce the "feature" anyway (which makes sense as the "error" was supposed solved in recent ver

742

4 days ago

gorangoContributor

asked in Transformers

Esri SDE Writer truncating function doesnt Reset OBJECTID Counter.

Hello,does anyone know why the Truncate Existing Function in Esri SDE Writer does not reset the OBJECTID Counter of a registered Table. (Table is not Versioned).SDE Writer File is based on World Parameter (not SID) and I am using ArcGIS 3.1.4 and FME 2022.2 (but had the Issue also in constellation ArcGIS 2.6 and FME Desktop 2021)The data is written on Oracle 19.15BrGoran

1244

4 days ago

pedro.villaObserver

asked in Transformers

How to properly merge three separate features?

I have three separate CSVs (readers below in yellow) to which I have added several transformers. I first added a “AttributeFilter” to filter through two values. I then connected to an “AttributeValueMapper” to map the previous two values to given names. Then I added a “StatisticsCalculator” to sum the values within these two values. Then an “ExpressionEvaluator” to convert the values from feet into miles and after an “AtributeRenamer” to rename the field names. Lastly, I added an “AttributeCreator” to add a third field of data. This is seen in the picture below of my workflow. At the end of the workflow, I added an “AttributePivoter” in an attempt to merge all of these together before attaching a Writer and exporting the results as an Excel Sheet. I am not sure the AttributePivoter might be the best way to merge all of this. What would be a better approach before adding the Writer?Thanks!

211

4 days ago

woltersContributor

asked in Transformers

Perform date conversions within rasters

I have a raster wherein the values are in epoch time (number of days since 1970-01-01)Is there a way in FME to convert these values into different date formats, such as yyyyddd?DateTimeConverter seems to only work with attributes, but translating all pixels to polygons with attributes for the pixel value is not optimal. I would guess this could be possible with RasterExpressionEvaluator, but if someone can give an example that would be really helpful. Thanks!

313

4 days ago

evoteckSupporter

asked in Transformers

I built Excel file attribute feature joiner workflow and I am happy for that.

Hi folks, I had some urgent need at my workplace, as the GIS database administrator working in a electricity distribution company, I was required to draft out various district data to be used by another department which will require me to decode and clean the data to enable them understand the data format based on their needs. I tried using manual method of copy and past after extracting this data from the database but it was time consuming.I tried FME and I was able to create a workflow using two transformers FeatureJoiner and Matcher and I am happy how this workflow was able to query the two excel files added to the left and right part of the FeatureJoiner transformer thereby giving me the output based on joined attributes file, one is coming as a number and varchar. Feel free to connect with me on linkedin https://www.linkedin.com/in/anthony-ezema/

171

4 days ago

kenortey8Participant

asked in Transformers

GML LOD2 To point cloud

I’m at working on matching indoor point cloud data to gml LOD2 data using ICP so I want to transform my gml data to a point cloud data to help ease the matching. Can anyone please help me? question is how do I transform GML LOD2 to point cloud data? also if there are other suggestions to complete this task. Thank you

101

4 days ago

poonam21Contributor

asked in Community Q+A

Fetch retail shops nearest to my current location

Hello Folks,I am working on a use case where I need to retrieve data for retail shops closest to my current location or a given set of geographic coordinates.I am attempting to implement this using an FME Form; however, I am encountering difficulties in obtaining the current location dynamically.If anyone has experience or insights on how to effectively retrieve the current geographic location within FME or through any integrated approach, I would greatly appreciate your guidance. Thank you in advance!

897

5 days ago

texxkContributor

asked in Data

Transposing lists into multiple groups

I’m trying to output all property sets from IFC files into separate Excel sheets. So far I’ve found all of the property sets, their attributes and their attribute values. This is my data:What I would like to do is transpose this list into separate lists for each property set like so: After that I could simply write each list to separate Excel sheets, but this is where I get stuck. I create the sheets by feeding the writer from a DuplicateFilter, but how do I join each PsetAttribute to Pset as well as transpose the data so each PsetAttribute is a single column?I need to do it without knowing the exact names or number of property sets existing in each IFC file as well.

623

5 days ago

ugulsumerdoganObserver

asked in Transformers

Clipper

Hello, I want to cut raster data with a shape data. There are 10 objects in the shape data and 10 raster data. Sometimes the objects in the shape data overlap. There is a column in the shape data that contains the names of the raster data. I want to cut each raster data with only the object with this name. I couldn't find the result despite trying very hard. I am using the clipper transformer. If you have any advice on this subject, I would be very happy.

436

5 days ago

thecompanydog

asked in Transformers

Chart creation through PythonCaller?

Hello, I’m trying to create a custom chart (waterfall, combination, etc.) and I couldn’t find a transformer that could accomplish this other than PythonCaller. I’m having trouble integrating my code within FME (2022 version) which requires me to use a few packages to execute. Has anyone been able to accomplish this? I’ve already reviewed the existing FME material out there.

596

5 days ago

darkspatiallord

asked in Transformers

GDA2020 gotchas - Australian Datum shift

Hi AllA few learned gotchas in regards to GDA2020 transformations.- Dont use the Navigator to convert datums GDA94 > GDA2020 as it defaults to 7 param (unless thats what you want)- Reprojector Transformer is seemingly default to 7Param when it should default to gridshift (have a call logged with Safe)- CSMapReprojector - if you are using Desktop this is the best to use as you can force the transformation from the dropdownHowever if you are going to server and you want the user to select the output coordinate system which may or may not include a transformation you need to automate which method you use by setting it with either a parameter or a conditional value based on the selected coordinate system code Lots of fun to be had but some caution as well. No transformation is the same.

722

5 days ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 可視化用データ変換01-2 政令市の建築物

FME Hub user takashi.pss just uploaded a new template to the FME Hub.注: このワークスペースでは政令市の行政区ごとに「PLATEAU4 可視化用データ変換01 建築物.fmw」を実行するために WorkspaceRunner を使用していますが、2024年12月時点の FME 最新バージョン (FME 2024.2.x) において、 WorkspaceRunner のパラメーターを介して実行するワークスペースのログファイルパスを設定するとエラーが生じるという不具合が確認されています。2025年以降のバージョンアップによって不具合が解消されるまでの間、このワークスペースは FME 2024.1.3 で実行してください。3D都市モデル標準製品仕様書第4.x版に基づいて作成された建築物 CityGML データセット　(政令市に限る) を Cesium 3D Tiles データセットに変換します。このワークスペースは、WorkspaceRunner によって「PLATEAU4 可視化用データ変換01 建築物.fmw」 (以下「01 建築物.fmw」と言います) を実行することによって政令市の建築物モデルを区単位の3D Tiles データセットに変換します。このテンプレートを FME Workbench で開くと、WorkspaceRunnerが参照する「01 建築物.fmw」も同時に展開されますので、「01 建築物.fmw」を別途用意する必要はありません。「01 建築物.fmw」を更新する際には、このテンプレートも更新します。処理を効率化するため、最初の区の変換を行うのとあわせて全ての区の属性を読み込んで区単位でCSVファイルに保存し、2番目以降の区の変換を行う際には、CSVファイルから各区の属性とファイルパスのみを読み込むようにしています。 2番目以降の区の変換は、ふたつめの WorkspaceRunner によって「01 建築物.fmw」を呼び出し、1以上の句について並列で変換処理を行います。同時に処理する区の上限数 (1～7) は、Maximum Concurrent FME Processes パラメーターで設定できます。パソコンのスペック等に応じて、適宜調整してご利用ください。 2番

6 days ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 可視化用データ変換01 建築物

FME Hub user takashi.pss just uploaded a new template to the FME Hub.Tech Preview3D都市モデル標準製品仕様書第3.x版に基づいて作成された建築物 CityGML データセットを Cesium 3D Tiles データセットに変換します。 [注] このワークスペースによる変換を実行するには、「日本のジオイド2011」に基づく標高から楕円体高への変換用に、FME Hub "Vertical Transformation with GSIGEO2011" テンプレートに同梱されているグリッドファイルが必要です。Vertical Transformation with GSIGEO2011 https://hub.safe.com/publishers/pacific-spatial-solutions/templates/vertical-transformation-with-gsigeo2011上記テンプレートを一旦 FME Workbench で開いてワークスペース (*.fmw) として保存すると、 "gsigeo2011.zip" というアーカイブが抽出、保存されます。まず、これを解凍して展開される次の2ファイルをディスクシステムの適当な場所に保存してください。ここで、*.gdc ファイルから *.grd ファイルへの相対パスはこのまま維持しておく必要があることに注意してください。 ./gsigeo2011_ver2_2.gdc ./griddata/gsigeo2011_ver2_2.grd 可視化用データ変換ワークスペースを実行する際に、上記 "gsigeo2011_ver2_2.gdc" を Geoid Height Grid パラメーターに設定することにより、「日本のジオイド2011」に基づく標高から楕円体高への変換を行うことができます。このワークスペースは、入力データセットに含まれる建築物の最大詳細度 (LOD)、テクスチャの有無に応じて、最大で次の8つの3D Tilesデータセットを作成します bldg_lod1: 詳細度1まで (元データにテクスチャがある場合はテクスチャつき)bldg_lod2: 詳細度2まで (元データにテクスチャがある場合はテクスチャ

6 days ago

cochdpContributor

asked in Transformers

Work around for SQLExecutor when a column name contains a reserved word

A column name that I am trying to SELECT in the SQLExecutor is titled: STATEThe line in the SQLExecutor that contains it is as follows:I receive an error message that leads me to believe that it is not grabbing this column, and instead trying to grab the alias that I am trying to establish:Is there a reliable work around for this reserved word? I have tried using the following, to no avail:[STATE][“STATE”][state]“[STATE]”

161

7 days ago

tbsm223Contributor

asked in Integration

Question about manipulating Utility Network geometry

Hey all, I’m wanting to snap existing meter points in a Water Utility Network, to field-verified points collected in the field by a contractor. Currently, I am just using an anchor snapper to snap the points, however… the service lines attached to them are not moving, as I believe an “edit” has to be done on the lines to get the network topology to stay intact. I have tried using the anchor snapper on the lines to snap the endpoint to the meter location… but I am not getting the same results I am getting with the points. Is there something I am missing/a better way to ensure the line attached to the meter also moves its endpoint to the new meter location? CS is State Plane, 100 feet is the setting I am using for now. The endpoint of the service line is coincident with the meter location, if that information helps at all.

391

7 days ago

poonam21Contributor

asked in Community Q+A

FME Flow Login Issue

Hi Folks,I have previously installed and worked on FME Server, with my last usage being approximately 2–3 months ago.However, I am currently unable to log in, and the system displays the following error message:Could someone please assist in identifying the cause of this issue and guide me on resolving it?Thank you in advance for your support.

303

8 days ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 可視化用データ変換02 道路・鉄道・徒歩道・広場・航路

FME Hub user takashi.pss just uploaded a new template to the FME Hub.Tech Preview3D都市モデル標準製品仕様書第4.x版に基づいて作成された交通モデル (道路、鉄道、徒歩道、広場、航路) CityGML データセットを Mapbox Vector Tile (MVT) または Cesium 3D Tiles データセットに変換します。[注1] このワークスペースによる変換を実行するには、「日本のジオイド2011」に基づく標高から楕円体高への変換用に、FME Hub "Vertical Transformation with GSIGEO2011" テンプレートに同梱されているグリッドファイルが必要です。Vertical Transformation with GSIGEO2011 https://hub.safe.com/publishers/pacific-spatial-solutions/templates/vertical-transformation-with-gsigeo2011上記テンプレートを一旦 FME Workbench で開いてワークスペース (*.fmw) として保存すると、 "gsigeo2011.zip" というアーカイブが抽出、保存されます。まず、これを解凍して展開される次の2ファイルをディスクシステムの適当な場所に保存してください。ここで、*.gdc ファイルから *.grd ファイルへの相対パスはこのまま維持しておく必要があることに注意してください。 ./gsigeo2011_ver2_2.gdc ./griddata/gsigeo2011_ver2_2.grd 可視化用データ変換ワークスペースを実行する際に、上記 "gsigeo2011_ver2_2.gdc" を Geoid Height Grid パラメーターに設定することにより、「日本のジオイド2011」に基づく標高から楕円体高への変換を行うことができます。[注2] 広場モデルの交通領域、補助交通領域フィーチャーが xlink によって同じ都市モデルにおける道路モデルを参照している場合は、xlink:href 属性に記述されている場所に参照先の道路モデルデータファイルが存在している必要

8 days ago

killphil84

asked in General

Esri Geodatabase (ArcSDE Geodb) Writer crashing - Error Number -2147216072

I'm running a workbench on FME Server 2017 and after running through some transformers, the data should be writteninto a database. I'm getting an error ans this message: An error occurred while flushing the cursor for the table/feature class 'xxx.yyy.zzz'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting float to data type numeric.] [xxx.yyy.zzz]} Am I right to assume that the error is possibly invoked by an incompatible value? How can I find out which value is causing the error? Is there a possibility to retrieve more information to start the search for the cause of this error?

1355

8 days ago

nigelgriffithsContributor

asked in Transformers

(Images Included) - Calculate area of overlap for every individual feature from one source, with every individual feature from another.

Hello, I have a problem that I am struggling to get my head around recreating within FME. The images below are just for example.I have data from two separate sources for which I want to calculate the area of overlap, for each instance parcel data and problem area data.I want to calculate the area of overlap for every individual parcel and every individual problem area. So rather than calculating the overlap for every individual parcel against the entire other layer as would be the case in the image below: I want to calculate the overlap for EACH SINGLE feature, and essentially create a list, so I can then also see the attributes for the problem area, and the area of overlap that particular parcels has with that particular problem area, to then go on and filter out those that fall under a certain threshold of overlap. I have gotten up to the stage of generating a list, which has the parcel id’s and problem id’s for each instance of overlap. My issue is where to go from here and then c

201

8 days ago

fmelizardContributor

asked in FME Hub Alerts

IBM MQ

FME Hub user stephenwu just uploaded a new fme_package to the FME Hub.Integration with IBM MQ.Would you like to know more? Click here to find out more details!

8 days ago

doug_herrickContributor

asked in Transformers

The object at location ___ was previously deleted and cannot be retrieved from the Object Stash

When running an old script in FME 2024.1.1.0 we get 58 errors “The object at location ___ was previously deleted and cannot be retrieved from the Object Stash” (see attached log file). It doesn’t appear to affect the output, the log file says “Translation was SUCCESSFUL” and CPU and Memory usage don’t get close to 100%. Can we ignore these errors?This is part of a much larger script but only this part is producing the errors. We updated the transformers and saved the script to FME 2024 but still get the errors at the transformer FeatureJoiner_13. The only way to not get the errors is to run the script up to the 2 preceding transformers (“Run to this”) and then run FeatureJoiner_13. The output appears to be the same as when we were getting the errors. We tried adding in FeatureHolders before FeatureJoiner_13 but still got the errors. ByeDoug

463

8 days ago

mark2atsafeSafer

asked in 12 Days of FME

Day 9 Recap (Non-Video)

Hello FME friends,Here’s a short written recap about where we are so far…OutageYesterday (10th Dec) there was a short period when API calls weren’t working. It may have left some balloons without positions for a few hours. I really apologise for that. I’ve updated my code and it shouldn’t happen again.Current WeatherThe jet stream that has carried so many balloons around the world persists, but suddenly comes to a halt at the eastern side of the Pacific.Some balloons are getting shunted north, some south, and a lucky few are in a narrow slot that continues on across Canada and its 50 provinces to the south (joke!)I think the best scoring opportunities lie in continuing to the east, but it will take some delicate maneuvering to navigate and keep going in that direction. This could be the most important part of the game so far!Current LeadersI wanted to list the current leaders in each prize category.Top Points Scorers: Dirkdeballonvaarder (269 pts) and CommunityCats (263). But Dirk is c

646

8 days ago

Page 3 / 9

Badge winners

gazmanhas earned the badge Welcome Back
miguelhacarhas earned the badge Spanish Speaker
miguelhacarhas earned the badge Student (Grey)
miguelhacarhas earned the badge Expert (Grey)
miguelhacarhas earned the badge Teacher (Grey)

Show all badges

30,351: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.