- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20214 Posts

Recently active

Most views Most replies

marjan_nikoukarContributor

asked in Data

Daily Data update in FME

Hi everyone,I’m working on an FME workbench where I download a full dataset file geodatabase daily. I also have a CSV file that lists daily changes.My goal is to remove files from the main dataset based on the CSV and add updated files from file geodatabase back into the main dataset.I’ve tried using the FeatureMerger and FeatureJoiner transformers to identify changes, but they were not effective due to time constraints. Since this needs to be done daily, time efficiency is crucial.Do you have any suggestions, Python scripts, or SQL queries, or any other ideas to speed up this process?Thank you!

203

3 hours ago

danielleatsafeSafer

asked in Question of the Week

Question of the Week: How did you first get into GIS?

Hi FME Community,In celebration of National GIS Day on November 20 this week’s Question of the Week is: How did you first get into GIS? Share your answer in the comments below.New to the Question of the Week? Every week, we’ll post a simple but thought-provoking question that could be about your FME journey, the power of spatial data, FME innovation, or the future of FME.Each weekly question you answer earns you an entry in our monthly draw for exclusive Safe swag ($50 value) and points toward badges! Answer our November Questions of the Week by Saturday, November 30 at 5:00 pm PDT to be entered in this month’s draw.Answer your first question and you’ll get the Socializer (Ice Breaker) badge. Answer five questions and you’ll get the Socializer (Talker) badge.

11014

6 hours ago

gjaguilarContributor

asked in Deployment

Error 502 Bad Gateway when trying to access https://hostname.mydomain.eu/fmeserver

Hello everyoneWe have a problem, we upgraded from FME Server 2022 to FME Flow 2024.1.1FME Flow was installed on a virtual machine in Azure, after doing the express installation it was configured to use a .pfx certificate and HTTPS according to the documentation (https://support.safe.com/hc/en-us/articles/25407434854157-Configuring-FME-Flow-for-HTTPS-Using-a-PFX-or-P12-Certificate)In the fmeServerConfig.txt file it was assigned to FME_SERVER_WEB_URL=https://<hostname>:443From that machine we tried accessing using https://<hostname>/fmeserver/ and it works fineFrom any other computer we used https://<hostname>.mydomain.eu/fmeserver/ and it worked but now this gives an error 502 Bad GatewayIs it a DNS error or are we missing something to configure in FME Flow? Thanks in advance

171

9 hours ago

jakestenson

asked in Transformers

Emailer not connecting to microsoft - unable to retrieve access token

Hello, I’m trying to connect to my microsoft email with the emailer transformer. I get the ‘Unable to retrieve access token’ error after logging into my account and using authenticator app. I get this error with veryify HTTPS certificates enabled or disabled. Any help on this?Thanks

111

11 hours ago

ivanwriterContributor

asked in Security

For Added Security, Can the out-of-the-box admin Login Be Disabled?

Out-of-the-box, FME Flow has an admin login for administration (member of fmeadmin and fmesuperuser).As a measure of added security, can a different, less common, login name be used for administration? In other words, if I were to create a login for administration purpose named MickeyMouse, add MickeyMouse to fmeadmin and fmesuperuser roles, and disable admin, does that work? Are there gotcha’s with doing that? Is it a measure of added security?

121

11 hours ago

lifalin2016Contributor

asked in Transformers

2024.2 yields an error in SharepointOnlineConnector ?

Hi.I built a workspace in 2024.1, that fetches a number of files from a customer Sharepoint site. It works (in 2024.1) without problems.I just installed 2024.2, and ran the workspace (with no changes).Now it issues an error with a SyntaxWarning from the package “safe.microsoft-sharepoint”:C:\Users\xxx\AppData\Roaming\Safe Software\FME\Packages\24783-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W' return re.sub("\W+", "", string)Is this something that I should worry about ?SharepointOnlineConnector is not listed as an upgradable transformer in 2024.2Cheers.

133

11 hours ago

helmoetzContributor

asked in Authoring

Duplicate records reading from zipped open file gdb

Hi this puzzles me: using FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64), when reading an Open File Geodatabase from a zip file, features are duplicated. I created and attached a template which demonstrates the error. The workspace uses two readers to demonstrate the phenomena, both of type File Open Geodatabase.The first reader reads from ..\test.zip\test.gdb The second reader reads from ..\test.gdbRecords on the first reader are duplicated. When reading from just test.zip the duplication does not take place. Is this behaviour as meant to be?

161

15 hours ago

fmelizardContributor

asked in Blog Alerts

Improving transportation data: 8 real-world success stories using FME

Blogger Tiana Warner just posted a new article to the FME Blog.Title: Improving transportation data: 8 real-world success stories using FMESummary: Read how real transportation agencies use automated data integration workflows to improve data quality and operate more efficiently.Introduction: Planning, managing, and delivering modern transportation services starts with a good data integration plan. For example, by leveraging real-time data and automation, organizations can improve the safety, reliability, and efficiency of their transportation networks. And by connecting data across departments, valuable insights can be delivered to the right people, both across teams and to the public.Would you like to know more? Click here to read this new article!

16 hours ago

jobvdnoortContributor

asked in Integration

Can FME as app publisher in Microsoft be verified?

Hi all,I have been informed by our IT department about the requirement to ensure that the publisher of our Azure app is verified by Microsoft. You can find more information on the publisher verification process here: Publisher Verification Overview.Could anyone from the confirm if this verification process is already being arranged, or if there are any steps that we need to follow to initiate this process?

291

16 hours ago

fme_hansContributor

asked in Data

Divide planes by area sum

Hi,I have a layer with closed polygons. On top of these polygons lies a layer with smaller areas. These areas are divided into 3 types.Each type of area needs to be assigned a year, and the total area per table type should be approximately equal within the larger area.How can I create a distribution where each type of area is used, and the total area of each type is approximately equal?How could I achieve this with FME?

472

16 hours ago

galigisEnthusiast

asked in Transformers

Force FME to use ArcMap instead of ArcPro?

Hi All,How can I force FME to use ArcMap 10.8 for reading GDB instead of ArcPro 3.x? I have a workflow that needs to use ArcMap because of a python script and everything works fine on my machine, my current versions of FME (2018, 2020, 2023...etc) use ArcMap to read GDB. Happy days. See below: One my colleagues also uses the same workflow, same version of ArcMap and FME but his workflow goes to ArcGIS Pro instead to ArcMap,How can I force FME to use ArcMap to read/write GDBs?Thanks :)

213

17 hours ago

fmeodata

asked in Community Q+A

FME to S/4HANA Rise

Currently we are using FME work bench to connect to S/4 via OData, however there are performance issues with using Odata, Is there any threshold limit uptil which FME can support the data extract using Odata without any performance issue. Any document or any recommendation from SAFE.What are the other options to connect to S/4 Rise if we do not want to use OData, our FME will be in AWS .What all config options we have other than OData to get rid of the performance issues. If at all there are other options available what all are the components needed to have the same Please help urgent

19 hours ago

carstenhpt

asked in Transformers

Python Caller MinMax Problem

I am using a python Caller to determine if a value is in a range of two other values which are read from a csv file.For Example: Is SearchValue LMH_HNR_Z in the range of value PTOa and value PTOb? If yes, set the variable Fall = B3, if not set it to B3f.LMH_HNR_Z = 5, PTOa = 1, PTOb = 10 should return: Fall=3B, LMH_HNR_Z = 11, PTOa=1, PTOb=10 should return: Fall=3Bf The Code in this picture is part of a bigger function where I discovered the problem but I narrowed the problematic part down to this. The row where the problem happens is this:if (min(PTOa, PTOb) <= LMH_HNR_Z <= max(PTOa, PTOb)):What happens is, that this request randomly returns false even if the search value LMH_HNR_Z is in the range of PTOa and PTOb. The output of some tested values and ranges is also visible in the lower part of this post. I can’t really see a pattern there, maybe one of you?Is someone aware of a bug that causes this behavior? I am using FME Data Interoperability, FME(R) 2022.2.1.0 (20221202 -

connection timed out error: Postgres

I am trying to convert an old script that loads 100+ tables in Postgres to a FME Server automation. One of the things I am doing is a INSERT INTO schema1.table SELECT * FROM schema2.table with a SQLExecutor where schema2 is a Oracle foreign table. This works fine for some smaller tables, but for a large table around 33gb I eventually receive a 'could not receive data from server: Connection timed out' error whether I run it on desktop or server. This worked fine when run from the script. I'm at a loss here, what could be causing the problem?

722

22 hours ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 品質検査01-2 必須属性等

FME Hub user takashi.pss just uploaded a new template to the FME Hub.Tech PreviewPLATEAU標準製品仕様書第4.x版に基づいて作成されたCityGMLデータについて、拡張製品仕様書において必須とされた主題属性・関連役割、原則として作成対象とされた主題属性・関連役割が記述されているかどうかを object_list_xlsx に基づいて検証し、結果を下記のExcelシートに出力します（問題が検出されなかった場合は、列名だけのシートが出力されます）。必須属性の欠落 : 個々のフィーチャーについて、記述されていない必須主題属性・関連役割の名称のリストを出力します。severity が Warn のものは、例えば Building, BuildingPart のどちらか一方のみに記述するなどの条件付きの必須事項であり、確認のうえ仕様どおりであればOKです。現われなかった属性等 : 必須ではないが作成対象とされている属性・関連役割が検査対象データセットにおいて全く出現しなかった場合に、それらの名称のリストを出力します。注 : 現時点における検証の対象は各地物型の直下位の主題属性・関連役割までとしております。関連役割以下の必須属性等の検証については、今後のバージョンアップで追加を検討します。 Would you like to know more? Click here to find out more details!

1 day ago

sussexpeteContributor

asked in Authoring

FME Workbench and other FME Form software broken by VMWare Tools

Since updating our FME Form host computer with the latest version of VMWare Tools, FME Desktop, FME Data Inspector, and all other FME Form GUI software does not run.We briefly get a spinner and then nothing. The problem was noted on FME version 2021 but is a problem with all version of FME Form up to the latest version FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64).It is still possible to run Workspaces in batch mode.The issue seems to be with OpenGL as indicted in the log, below.I would be interested if others have the same issue and, if so, how the issue can be resolved.Here is a snip from the log file:VMWare Tools v12.5.0.24276846Faulting Module = vm3dgl64.dllWorking Version = 3.5.3.2Faulting Version = 3.6.0.0 Event Log:Faulting application name: fmeworkbench.exe, version: 2021.7.41.21614, time stamp: 0x60f7b7a5Faulting module name: vm3dgl64.dll, version: 3.6.0.0, time stamp: 0x66a16726Exception code: 0xc0000005Fault offset: 0x0000000000e3696dFaulting process id: 0x1becFaulting

137314

1 day ago

marjan_nikoukarContributor

asked in Data

Convert annotation class to polyline or point in FME

Hi,I have a annotation class in a file geodatabase. I want to convert it to a polyline or point in a file geodatabase. I could not fine any transformers in FME. I really appreciate your assistance.

100

1 day ago

kibaileyContributor

asked in Community Q+A

Excel Writer: Error Message is 'col must be in range 0- 16383'

I’m encountering this error and am at a loss. Everything in workbench (SQLCreator - Attribute Mgr - Excel Writer) seems to work fine, up until it gets to the writer. Excel Writer: Failed to write an attribute of type 'string' with value 'XMLDATA' to row '0' column '-1015942868'. Error message is 'col must be in range 0-16383'. Skipping featureWriter Mode: UpdateOutput Field Names: YesFormal Field Names: NoUse Attribute Names as Column Positions: YesStart Position: Start Column: 1 Start Row: 1 Any suggestions?

221

1 day ago

mikeinhamiltonParticipant

asked in Transformers

Formatting Headers In Excel

I’m trying format the headers of an excel file. I’m attempting to use a template but can’t get it to work. The output always has a tab that is formatted like the template, and a tab with the data without the formatted headers. I’d like to write the data to the formatted tab. Is this possible?

301

1 day ago

antjaContributor

asked in Transformers

INSPIRE GML writer - importing wrong XSD

Hi,I have a workspace transforming data to write it in INSPIRE GML format (theme Hydrography). Earlier this year, some of the INSPIRE application schemas (XSDs) where upgraded to a new version Include changes from 2024.1 schema release · Issue #1027 · INSPIRE-MIF/helpdesk-validator, including the hy-p one that I’m using here (v4.0 to v5.0).Therefore I changed my INSPIRE GML writer to point to the new XSD URI and adapted the xsi:schemaLocation parameter consequently. However, when indicating the v5.0 the output GML is not written correctly: there are remnants of the v4.0 in it.First in the imports, see xmlns:hy-p4 and xmlns:hy4:<gml:FeatureCollection xmlns:omor="http://inspire.ec.europa.eu/schemas/omor/3.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sr="http://inspire.ec.europa.eu/schemas/sr/4.0" xmlns:base="http://inspire.ec.europa.eu/schemas/base/4.0" xmlns:gts="http://www.isotc211.org/2005/gts" xmlns:hy-n="http://inspire.ec.europa.eu/schemas/hy-n/4.0" xmlns:omop="

656

1 day ago

quanguContributor

asked in Transformers

Hi, fellow FMEers! We have some trouble to working on I3S.

We want to automatically write 3D data to an existing 3DScene in ArcGIS Online. The data consists of borehole samples (geometry simple 3D-cylinder). We have tried using the Esri Indexed 3D Scene Layer-writer but the output does not show correctly and we can't create pop-ups showing the attribute data (although it looks like it's there). We're not sure why this doesn't work but figured we'd try here first to see if we can get any pointers to a best practice. So, can anyone please help shed some light on the best way of doing this - updating 3D-data to an existing 3D-scene in ArcGIS Online? (We will want to be able to do this also with mesh-data... for instance a ground model.)

10911

1 day ago

spalrobertObserver

asked in Data

QGIS python library not able to load

Hi, I am trying to run a custom python code that uses QGIS library in PythonCreator. However when I run the code I get this error:Python Exception <ImportError>: DLL load failed while importing _core: The specified procedure could not be found.I tried everything, I followed the documentation/manual how to setup custom python interpreter, I tried to setup dependencies and environment variables but none of that worked. Can someone tell me what am I doing wrong? Thanks!

120

1 day ago

jugoslaviaaSupporter

asked in Transformers

Preventing Small Holes in Polygons from Being Removed in FME

I’m reading a GPKG table, and when I view the data in the Data Inspector, I notice that FME removes some small holes in my polygons. How can I prevent this from happening?

Optimizing i3s (slpk) LOD

I'm converting 3D data from Postgres to an Esri Indexed 3D Scene Layer (slpk). I'm converting this to an i3s service on Azure (not ArcGIS Online). When loading this as an external layer in ArcGIS Online, the LOD seems totally random, buildings are being visualised but not the way I'd like to see (not based on distance). Is there a way of optimizing this in FME?

30812

1 day ago

marta.podsiadSupporter

asked in Transformers

Split polygon into equal parts

Hi, I am trying to edit the workbench from https://fme.safe.com/blog/2016/05/point-cloud-power/ so it splits the polygon into the number of parts or area I provide. I cannot figure out how to change the PointCloudCoercer to allow me to do so

231

1 day ago

Page 1 / 809

Badge winners

vojtechmyskahas earned the badge Welcome Back
delaneytoursihas earned the badge Student (Grey)
gavinparkhas earned the badge FME Certified Trainer
TandraAtSafehas earned the badge GIS Day 2024
eqwansyafiqhas earned the badge Webinar Watcher (Grey)

Show all badges

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