- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20225 Posts

Recently active

Most views Most replies

scarterContributor

asked in Automation

Seeingh when a scheduled event last run in FME Flow

Hello Forum., This sounds like it’s a straightforward function. I’ve looked but can’t see an obvious way of doing it. I’m looking at FME Flow>Schedules>Manage Schedules. I want to be able to see the last time that a selected schedule item actually run. A bonus would be to see a successful/not successful flag too. Alternatively, this information could be captured in a log. But there doesn’t appear to be log option on that page, nor is there a column stating last time run. Or am I just missing it? Thanks,Stuart

353

4 months ago

fmelizardContributor

asked in FME Hub Alerts

都市計画決定GISデータ（CityGML形式）変換

FME Hub user takashi.pss just uploaded a new template to the FME Hub.国土交通省が次のサイトで公開している都市計画決定GISデータ（CityGML形式）を OGC GeoPackage データセット (市町村別ファイル、フィーチャータイプ別テーブル) および GeoParquet データセット (市町村別フォルダー、フィーチャータイプ別ファイル) に変換するワークスペース例です。都市計画決定GISデータ全国データダウンロードページhttps://www.mlit.go.jp/toshi/tosiko/toshi_tosiko_tk_000087.html変換結果テーブル名、属性名 (列名) について都市計画決定GISデータ (CityGML形式) に記述されているフィーチャータイプ名や主題属性名はキャメルケース (例: UrbanPlanningArea, validFrom) ですが、変換結果の GeoPackage テーブル名、GeoParquet ファイル名や主題属性名はスネークケース (例: urban_planning_area, valid_from) となります。コードリストの参照についてgml:CodeType 型の主題属性のうち、codeSpace 属性によって参照すべきコードリストの URL が指定されているもの (例: function, city) については、その URL に基づいてウェブ上で公開されているコードリストを自動的に取得・参照し、コードに対応する意味文字列 (description) を取得して元の主題属性の値を置き換えるとともに、元の属性名にサフィクス "_code" をつけた名前 (例: function_code, city_code) の属性を追加して元の値 (コード) を格納します。注: ウェブ上のコードリストを取得できるよう、インターネットに接続している環境で実行してください。変換をサポートするフィーチャータイプUseDistrict : 用途地域 UrbanPlanningArea : 都市計画区域 AreaClassification : 区域区分 GenericCityObject : 立地適正化

180

4 months ago

fmelizardContributor

asked in Blog Alerts

Using FME to Analyze and Predict Dengue Outbreaks in Malaysia

Blogger lyesmokraoui just posted a new article to the FME Blog.Would you like to know more? Click here to read this new article!

220

4 months ago

naveenContributor

asked in Transformers

Anchor snapping and overlapping points

Hello All, I hope you all are doing well. I am trying to figure this out - I have to align points on the lines without overlapping with each other. I have used Anchorsnapper(segment snapping..group by line global id). I have passed lines to anchors and points to candidates. The results have some overlapping points (using matcher). To disperse along the line, using sampler and offsetting by 5 ...and still some points are overlapped...so tried to -5 offset the points and then snap to line. I am still ending up with some overlapping points. Is there a better way to achieve this?Any help would be appreciated. Thanks,Naveen

563

4 months ago

emerson_stylesContributor

asked in Data

Output excel file hiding column names (row 1)

I am writing data to an excel file but when I open the written file, the first row of the file (that includes the column headings) is hidden and I have to manually expand it to show the headings. Is there a way to fix this in the writer at all?

3963

4 months ago

stuarmitagehomeContributor

asked in Transformers

Move values from one column to create column names

Hi, and of course “HELP!” 😁I need to take some values in a column and create column names from them, taking the associated values with them.My starting table looks like this (note this is in Excel, but the table exists within an FME workflow, I am just showing it like this to make it easier to understand… hopefully!!!!!): Asset_ID is my unique identifier. You will see there are either 3 or 4 duplicates of that number.Column B “CHAR_TYPE_CD” has the values I want to turn into new column headings, combined with the existing column headings in C, D, and E.This is ultimately what I want it to look like: Note The values from the original Column B are transposed and combined with the previous column names. There are 4 individual attribute values in the original column B, namely:CM-ELCNT; CM-GRPNG; CM-VOLVL; and CM-VNOriginal column C “EFFDT” now becomes “EFFDT CM-ELCNT”Original column D “CHAR_VAL” now becomes “CHAR_VAL CM-ELCNT”Original column E “SRCH_CHAR_VAL” now becomes “SRCH_CHAR_VAL C

494

4 months ago

joySupporter

asked in Transformers

Is there an environment variable for the R interpreter?

Hello everyone,I was wondering if there is an environment variable available for the R interpreter.If I look at the following post, there appears to be an environment variable for python, but not for R.It would be nice that the R interpreter would be able to look at a certain folder on the C disk for example and when there is different version of R, then the R interpreter would automatically change it.For now, I manually changed the interpreter, however ideally I would like during an update of R, that the R interpreter would automatically change the R interepreter.Does anyone know whether that is possible or might be possible in the near future?

241

4 months ago

budaimatyasParticipant

asked in Automation

Creating Map Report with FME

Hi, I am using FME Flow (desktop) and I need to make workspace for producing map reports (image or PDF) like a layout in QGIS or ArcGIS, but as I know it is not so easy. What I need:a basemap (preferred areal, but standard would be good as well) visualize my line layer georeferenced on the top of it some additional informations (tables, map legend etc.) around the map Does anyone know an easy solution/approach fir this, or FME is simply not for such a visualization and I should search for other tools to do it? Thanks for the help!

1613

4 months ago

boomer87Contributor

asked in Data

SQL Executor vs Python Caller to consolidate data schema/fields for Change Detection with API and GIS FC

Hi everyone!Curious if I could pick your brains on how to achieve the workflow:I am connecting to an asset via API as well as another separate GIS Feature Class in an EGDB. The workflow will start with a user editing the GIS Feature Class. When a user updates or creates a new record in the GIS Feature Class, I am pulling it into the Change Detector, and wanting to write to the API table only if the asset_id does not exist in the API table. The asset_id field in the GIS FC = unitid in the API Table, as the field has a different name than the same column has in the GIS Feature class.Here is how my workspace is looking now, with the top line connecting to my API as the original source in the Change Detector, and my GIS FC as the Revised source in the Change Detector. That’s one of the main prediciments here is that the data schemas are different as the original source is a Hansen API table whereby the fields have different schemas/naming conventions than the fields in the GIS FC (by desi

231

4 months ago

boomer87Contributor

asked in Authoring

Change Detector Python Caller for GIS FC and API

Curious if I could pick your brains on how to achieve the workflow:I am connecting to an asset via API as well as another separate GIS Feature Class in an EGDB. The workflow will start with a user editing the GIS Feature Class. When a user updates or creates a new record in the GRI_TEST1 Feature Class, I am pulling it into the Change Detector, and wanting to write to the API table only if the assetkey does not exist in the API table. The assetkey in the GIS FC = unitid in the API Table, as the field has a different name than the same column has in the GRI_TEST1 Feature class.Would I be going the right route here in using the PythonCaller to achieve this? Right now my writer is writing to a xlsx document and not the API table yet so I could test out the logic. # Import necessary modulesfrom fmeobjects import *# Function to check if asset key exists in feature classdef assetkey exists(assetkey, feature_class): # Implement the logic to query the GIS feature class # Assume 'feature_c

331

4 months ago

kattContributor

asked in Transformers

SQL Executor - Oracle Spatial Object with two tables having a geometry

Hello,I am using the SQL Executor to read two tables from oracle using a join.I would like to use Oracle Spatial Object as Format to have the geometry included.This is my sql query:select a.nm, a.fid, b.mlpst, b.featfrom t_csm ajoin t_fl bon a.clss=b.clssBoth table a and b have a geometry (GEOM). When I use SQL Executor - Oracle Spatial Object, how can I know the geometry of which table will be used ? I want it to be the geometry of table b but I don’t how to specify it. The geometries of these two tables are not the same and my next transformer is the neighborfinder so it makes a big different if I use the geometry of table a or table b.Thanks for your help.

221

4 months ago

fmelizardContributor

asked in FME Hub Alerts

KLIC Genius FME Connector

FME Hub user trd2021 just uploaded a new transformer to the FME Hub.Een FME-transformer om te gebruiken i.c.m. KLIC Genius.Voor vragen email ons: info@klicgenius.nlWould you like to know more? Click here to find out more details!

140

4 months ago

adele_jContributor

asked in Transformers

Coordinate System Gallery Inaccessible through Transformers (2024.0.1.0)

Hi all,When using a FeatureReader, FeatureWriter, or any other transformers, I can’t seem to access the Coordinate System Gallery. However this doesn’t seem to impact readers or writers (when accessed through parameters anyway).Excel ReaderReprojector (note that Source Coordinate System does use the Coordinate System Gallery)I’m currently using FME via Data Interoperability through ArcGIS, is this a limitation of the extension? Or have I missed a setting to use the gallery in all cases?Cheers for any help.

774

4 months ago

j.m-vismaContributor

asked in Transformers

Is there a better way to use the HTTPCaller for Multipart/ form data?

I am using the HTTPCaller to interact with an API, for that I use the setting Multipart/ Form Data. This is the way another user got the Endpoint to work for them and I just always used it. This works pretty well, the API does what I want, the connection is stable, but there is one problem. Sometimes it takes a lot of time to configure the Multipart-part.For some jobs I need to configure dozens of parameters, this leads to a lot of typing, proofreading, etc. For this particular endpoint I don't just need to give parameters about the object I want to edit (some inspection), but also something like a table definition. The row (row_id) and the value, for each attribute of my dataset. Since this API endpoint doesn't like it when I send in null values as values, I need to run several configurations of the same HTTPCaller one that drops each variation of Null values in the dataset. Now I was wondering if I could somehow build the whole statement about the rows and their values with something

332

4 months ago

imaric0503Observer

asked in Transformers

Read and write feature one by one

Greetings, I should read and write features one by one, namely in the feature reader I have a condition by which I retrieve data from the database, more precisely the ID. But every time I should first write a feature in the database that gets a new ID, and when reading the conditions for the second time, it should select that new ID, and not immediately select that first ID for me. how to create this?

412

4 months ago

csaba.szabadkaiObserver

asked in Transformers

Parallel lines

Hi!I have a shapefile with a lot of lines with the same geometry, but different data. They are the fibers of an optical cable.How can I shift them parallelly to each other?

604

4 months ago

jobvdnoortContributor

asked in Data

Change default installation location Arcgis PRO.

Hi All,For a project I need to write a geodatabase with a time_only field in one of the objects.To be able to do this I had to change my Python Compatibility to Python 3.9, which only works if Arcgis Pro 3.2 is installed.Otherwise I get this very helpfull error:But I don’t want to use 3.2 as default. Now I have 2 folders:C:\Program Files\ArcGIS\Pro2_9C:\Program Files\ArcGIS\Pro3_2I manually renamed the Pro folder to include the version number.The issue now is that FME can’t find my Arcgis Pro, which makes me very sad 😥. How can I tell FME to just use C:\Program Files\ArcGIS\Pro2_9 and stop looking for C:\Program Files\ArcGIS\Pro.Only when I want, I manually will change the folder to 3_2.

726

4 months ago

jasperwisEnthusiast

asked in Transformers

DWG: writing custom hatches (pat files) on a Linux/Kubernetes FME Flow

Hi,I would like to write custom hatches in a DWG file. But our FME Flow is deployed with Kubernetes.So the OS is Linux.Since the RealDWG writer is only available on Windows, I will need to use the other DWG writer (Acad).Where should I put these .pat files to write these custom hatches successfully?The documentations says:The ACAD format writer will look for custom hatch patterns in custom <filename>.pat files located in folder specified by the ACAD operating system environment variable, or in the related folder for any installed AutoCAD product.On windows, I have tried to create an “ACAD” environmental variable, pointing to a folder where I placed my .pat files. But no result.Secondly, will this be possible on a Kubernetes FME Flow?Thank you in advance Jasper

270

4 months ago

fmelizardContributor

asked in FME Hub Alerts

PDALPipelineApplier

FME Hub user antoine just uploaded a new transformer to the FME Hub.PurposeTakes a pointcloud input, applies a PDAL pipeline and output the modified pointcloud.PDALUsageInput Ports :Input : This transformer accepts pointclouds.Output Ports :Output : Pointcloud transformed.RequirementsFME 2014.0 pdal and python-pdal in a conda envconda env specified in FME parameters.Published Parameterspipeline : PDAL pipeline (read the help to see example)FME_PROCESS_GROUP_BY : group bycomponents : Custom pointcloud dimensions you might have in your inputgenerateMetadata : Allows to print the status of your pointcloud along the the pdal pipelineLimitationThis transformer is restricted to las to las pipelines in PDAL.Would you like to know more? Click here to find out more details!

340

4 months ago

nicholasContributor

asked in Transformers

FeatureReader fails to recognise Attributes in CSV file

FeatureReader does not recognise attributesHello all, I am having problems with a FeatureReader that does not recognize the attribute columns of a CSV file.The background is, I regularly download the GNAF dataset from Geoscape Geocoded National Address File (G-NAF) | Datasets | data.gov.au - betaThe GNAF arrives as a zip file containing a large number of CSV files. I only need five of them.I have built a Directory and File Pathnames Reader that returns all of the CSV files, which I then filter down to just the five that I want.I am attempting (but failing) to build a FeatureReader that reads the CSV file.I should point out that the CSV file is actually a pipe-separated-value file. The separator is a pipe “|” and the file extension is “.psv” But I have confirmed that a normal CSV reader does successfully read the psv file.Now, the FeatureReader is successfully reading the correct number of features. And FME automatically recognises that two of the columns are LONGITUDE and LATITUDE and

481

4 months ago

gberdozParticipant

asked in Authoring

NeighborFinder list of distance

Hi,I’m on the version 2024 of FME Workbench, I have to calculate a number of neighbor between points (let’s say 5) in a distance (of 20 for example).But the issue is that I don’t know how to export the 5 distances in specific attributes…If someone can help me I’d love that !

562

4 months ago

chaitanyamallaContributor

asked in Data

Cut 3D dgn/dxf lines by using 3d surface (pointcloud las, laz, dtm etc.,)

I have dgn/dxf formatted CAD 3D lines which are "cables" below the ground. These cables are sometimes 1m below ground and sometimes 50cm and 10cm etc. below the ground. I have pointcloud LAS data as ground elevation data.Now I want to extract the cables(lines) which are below the ground upto 50cm. I want to cut the cables layer with elevation model to selct the cables network from 0 to 50 cm below the ground.How can I cut those lines? I am trying with qgis and FME but, unable to get the right solution. Anyone has idea what software or methods to follow.

463

4 months ago

galigisEnthusiast

asked in Data

Load Data into a template GDB

HI All,What the best way of loading data into a blank template GDB? Attributes, domains, etc are already set up in the template GDB but need to know how to load data into the template using FME,Do I need to use the template GDB in the writer and then map the fields from the reader to the writer?Any idea how to do this?Thanks

251

4 months ago

martinjaegerContributor

asked in Data

SQL Server Error: "Unable to decrypt data"

In FME Form 2024.0.1.0 I got an error when trying to read data or schema with “Microsoft SQL Server Non-Spatial” Reader: “Unable to decrypt data”. On the same server, connection with SQL Server Management Studio works fine.Does anybody know this problem or has a solution?Regards, Martin

823

4 months ago

david_Contributor

asked in Data

How to update geometry column in SQL Server

I simply need to update a geometry column in a SQL Server table that is previously set to NULL. Could someone provide me with a simple example? I can't do it neither with a SQL Executor (previously using a GeometryExtractor to convert this geometry in Microsoft SQL Server Binary) nor with a featureWriter. I found this conversation from a while back but it didn't help me: Thank you!

802

4 months ago

Page 32 / 809

Badge winners

mahmoud_m.talalhas earned the badge FME Form Basic Training
nick_ahas earned the badge Integrate Data with the FME Platform Training
reveszhas earned the badge FME Flow Authoring Training
magdahirschhas earned the badge FME Certified Professional
sandrawanghas earned the badge FME Flow Authoring Training

Show all badges

30,159: 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.