- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20225 Posts

Recently active

Most views Most replies

faresContributor

asked in Community Q+A

ExcelToPDFWriter

Has anyone tried running the ExcelToPDFWriter in an FME flow? I’m encountering an issue where Excel cannot open the file when I run this transformer in the FME flow. However, I don’t face this issue when running it directly in FME Form. Any insights or solutions would be greatly appreciated!. I found the sloution here : Microsoft Excel cannot access the file (Java -> cmd /c python -> Excel) - Stack Overflow

Health check failures after 24hrs when running FME Server in AWS using Aurora PostgreSQL Serverless for the FME Server Database

I'm running FME Server in AWS using Aurora PostgreSQL Serverless for the FME Server Database and I check the health of the server by calling the fmerest/v3/healthcheck?textResponse=true&ready=true REST API periodically. Everything runs ok for 24hrs but after that, the health checks start to fail and do not recover again. From the errors logged (below), I think it might be a connection pooling issue. I don't get the same issues on an Express install and there's a line on https://aws.amazon.com/blogs/database/best-practices-for-working-with-amazon-aurora-serverless/ that says "Aurora Serverless closes connections that are older than 24 hours. Make sure that your connection pool refreshes connections frequently.", so I think this might be the cause. I've copied some errors from the logs (can provide full logs if required), am I right in thinking this is caused by Aurora Serverless killing the connections or is this something else? Is there a setting anywhere that will force FME to ref

424

1 month ago

fmelizardContributor

asked in FME Hub Alerts

OvertureMapsDataDownloader

FME Hub user ardadurmus just uploaded a new transformer to the FME Hub.OvertureMaps Downloader custom transformer allows FME users to directly access and download geospatial data from the OvertureMaps Foundation using DuckDB a high-performance SQL-based analytical database system. Runs with Executable file or command line system variable duckdb or duckdb.exe using System Caller. This transformer retrieving and storing overture map data in a local environment or temp folder that can be accesible during your process enabling integration with FME workflows for further spatial analysis transformation or export into other formats. It's designed for users who need fast access to large-scale open-source geospatial datasets in a seamless and efficient way.Would you like to know more? Click here to find out more details!

1 month ago

markotObserver

asked in Transformers

How to buffer a line?

How to buffer a line with different distances on the left and right side?The question is about road centrelines, where buffer needs to have different distances from centre line on left and right side.

512

1 month ago

tbarker1986Contributor

asked in Data

DWG Writer: Preserve Template File Paper Space Issue

Hi All, i’m having an issue writing to an AutoCAD DWG file, with a template file. I want to preserve the Model Space, but not the Paper space as i’m editing some attributes within the drawing title block in FME which I want to write back out in the paper space.Even though I am setting preserve paper space in the writer to No, the original blocks from the template file, including the original attribute values, are being written as well as a copy of the block with the new attribute values I have updated in FME. As a result I have 2 overlapping blocks, 1 with the new values I want to keep and 1 with the original values I am trying to replace. I just want a single block with my new values.In the attached, you can see the output from the writer, with the same block duplicated with the new value I have updated and the old value in the template (highlighted in yellow).Any thoughts/ideas/assistance with this would be greatly appreciated, whether this is possible or not possible. I have done si

421

1 month ago

osacode

asked in Transformers

How to fix bugged user parameter ?

I had a workspace with 13 user parameters. When renaming them all, I accidentally erased one's identifier, and it duplicated it and the new one is bugged. When I try to save, the workspace crashes. After publishing it on the server, trying to run it shows not a single user parameter. I can not delete it, and it is linked to every single transformer of the workspace (copy pasting any transformer from the bugged workspace to a new one imports the bugged user parameter and therefore corrupts the workspace).

17512

1 month ago

kidegaContributor

asked in Transformers

Manage custom paths, Included Data from Writers in Form 2024

Hello,I have previously in Form 2023 added custom paths in the “Edit Data Download Properties → Include Data from Writers” when preparing to upload to Flow.The issue I now have in Form 2024.1 is that after I have published the workspace to Flow or if I reopen the workspace my custom paths are not saved within the workspace, or if it’s saved to Flow as it was in Form 2023. This makes the Republish option button not useful as I can see as I have to rewrite the custom paths. Or have I might missed something? To be clear I belive this only counts for custom paths and the benifit with custom paths is that I can customize how files are organised within the .zipped file from the Data download service.

540

1 month ago

nfriParticipant

asked in Community Q+A

Intersect with lenght along line (station values)

Is there a way in FME to run a workflow similar to esri Intersect tool where a 1 line feature (1 route) could intersect a second line feature (roads) with multiple lines and get a point feature for each crossing point with the distance along the first line feature. Basically crossing point and stationing along a line?

422

1 month ago

kattContributor

asked in Transformers

selfoverlapping lines

Hello,I have several lines in my data base which are self overlapping. On the the picture you see the vertices and the order when drawn. Vertices 3 and 4 have been drawn before vertex 5 which makes the line self-overlapping or self-intersecting. How can I detect lines in my database which have that kind of problem ? I tried the geometry validator but I noticed that it detects only some of them. So it is not fully reliable in my case. Is there any other transformer ? I thought maybe of calculating the bearing as the change of direction could indicate that problem as well. Thanks for your help. (btw I don’t want any transformer to automatically correct them, I only want to detect them)

415

1 month ago

arnold_bijlsmaEnthusiast

asked in Transformers

Check the value of User Parameter

This is either going to be a very stupid question or a very silly bug.I want to check if MyUserParameter has a value, so I put a Creator and a Tester on my canvas checking whether MyUserParameter does have a value. It tells me it doesn’t, whilst it clearly does! Hmm, what’s going on?Am I being dumb? Why can I not test a User Parameter?I can get it by using a ParameterFetcher, so it’s not a big issue.We recently upgraded from v2023.1 to 2024.1, and I thought this used to work, but I could well be mistaken.EDIT: It does work if I check if MyUserParameter is of type string or when using RegEx. It sounds like the ‘has a value’ and ‘is null / missing / empty’ doesn’t work with user parameters.

342

1 month ago

kircContributor

asked in Integration

Integration/Interaction FME & Microsoft Copilot

Hi Community!Is there anyone who has experience regarding interaction/integration possibilities of FME with Microsoft Copilot? Maybe in connection with image recognition tasks?Thanks in advance!Cheers,Christoph

1315

1 month ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 品質検査09 橋梁・トンネル・地下街

FME Hub user takashi.pss just uploaded a new template to the FME Hub.PLATEAU標準製品仕様書第4.x版に基づいて作成された橋梁、トンネル、地下街モデルCityGMLデータについて、位相一貫性に関する品質検査を行います。使用方法や検査結果についてのお問い合わせは、次のアドレスあてのメールでお願いします。plateau-helpdesk@aigid.jp 今後も必要に応じて、ワークスペースの機能追加、改良をし、FME Hubを更新することがあります。FME Hubを更新した場合は、Slack PLATEAUコミュニティの「2024技術支援チャンネル」でお知らせしますので、適宜ダウンロードしてお手元の環境も更新してください。このワークスペースはいつまでもご利用になれますが、上記のメールやSlackによるサポートは2024年度末で終了します。あらかじめご承知おきくだいますよう、お願いいたします。Would you like to know more? Click here to find out more details!

1 month ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 品質検査08 地形

FME Hub user takashi.pss just uploaded a new template to the FME Hub.PLATEAU標準製品仕様書4.x版に基づいて作成された地形モデルCityGMLデータ (TINRelief) について、位相一貫性等に関する品質検査を行います。注1: MassPointRelief (gml:MultiPoint) で記述された地形データには対応していません。注2: TINを構成する三角形の辺が隣接する三角形の辺と共有されていない場合 (辺の一方または両方の頂点が鉛直方向でずれている場合も含む) に「共有先のない辺」エラーが検出されますが、データ作成範囲内に部分的に原典データが存在しない領域 (水域) が穴のように存在した場合に、その境界を構成する三角形の辺も「共有先のない辺」として誤認識されることがあります。この検査項目は標準製品仕様書において品質要求として規定されたものでもありませんので、このエラーが検出されても検査不合格とはしませんが、水域境界以外ではこのエラーが生じていないことをご確認ください。また、「共有先のない辺を検出する」パラメーターに No を設定することにより、「共有先のない辺」エラーの検出を省略することもできます。使用方法や検査結果についてのお問い合わせは、次のアドレスあてのメールでお願いします。plateau-helpdesk@aigid.jp 今後も必要に応じて、ワークスペースの機能追加、改良をし、FME Hubを更新することがあります。FME Hubを更新した場合は、Slack PLATEAUコミュニティの「2024技術支援」チャンネルでお知らせしますので、適宜ダウンロードしてお手元の環境も更新してください。このワークスペースはいつまでもご利用になれますが、上記のメールやSlackによるサポートは2024年度末で終了します。あらかじめご承知おきくだいますよう、お願いいたします。Would you like to know more? Click here to find out more details!

1 month ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 品質検査07 土砂災害警戒区域

FME Hub user takashi.pss just uploaded a new template to the FME Hub.PLATEAU標準製品仕様書第4.x版に基づいて作成された土砂災害警戒区域CitGMLデータについて、位相一貫性等に関する品質検査を行います。使用方法や検査結果についてのお問い合わせは、次のアドレスあてのメールでお願いします。plateau-helpdesk@aigid.jp 今後も必要に応じて、ワークスペースの機能追加、改良をし、FME Hubを更新することがあります。FME Hubを更新した場合は、Slack PLATEAUコミュニティの「2024技術支援チャンネル」でお知らせしますので、適宜ダウンロードしてお手元の環境も更新してください。このワークスペースはいつまでもご利用になれますが、上記のメールやSlackによるサポートは2024年度末で終了します。あらかじめご承知おきくだいますよう、お願いいたします。Would you like to know more? Click here to find out more details!

1 month ago

fmelizardContributor

asked in FME Hub Alerts

PLATEAU4 品質検査06 浸水想定区域

FME Hub user takashi.pss just uploaded a new template to the FME Hub.PLATEAU標準製品仕様書第4.x版に基づいて作成された洪水・津波・高潮・内水浸水想定区域モデルCitGMLデータについて、位相一貫性等に関する品質検査を行います。使用方法や検査結果についてのお問い合わせは、次のアドレスあてのメールでお願いします。plateau-helpdesk@aigid.jp 今後も必要に応じて、ワークスペースの機能追加、改良をし、FME Hubを更新することがあります。FME Hubを更新した場合は、Slack PLATEAUコミュニティの「2024技術支援」チャンネルでお知らせしますので、適宜ダウンロードしてお手元の環境も更新してください。このワークスペースはいつまでもご利用になれますが、上記のメールやSlackによるサポートは2024年度末で終了します。あらかじめご承知おきくだいますよう、お願いいたします。Would you like to know more? Click here to find out more details!

1 month ago

parke372Contributor

asked in Authoring

XLS->XLS - copy validation formulas?

I am looking to have a workspace run by a workspace runner to parse out some data to be grouped by individual tabs based on an attribute name.i have an excel workbook with a dozen or so sheets, each sheet is a type of mechanical system with 3 columns - Column A is BLD which is a string building name. Column B is System Type which had data validation in place with named table references and Column C is System Name which is a string value.i am using a feature reader with the read formulas checked:i want to have the workspace runner pass a value for BLD and search all of the sheets for matches - for instance, it looks something like this once run: The workspace is finished, except for the writer - i want to create a new workbook for each unique BLD feature and copy from an excel template that has the existing named ranges for the various data validation lists from the original read file - however, i can’t get the validation to copy, nor the sheet with the named ranges.my writer is set up

250

1 month ago

katericondoContributor

asked in Transformers

Extract minimum Z from rasters on intersect with polygon

I have several rasters with varying Z values and thousands of parcels. I’d like to extract the lowest z value from multiple rasters by parcel. Any help is appreciated!

353

1 month ago

mr_fmeEnthusiast

asked in Data

Run two custom transformer identical in Workspace

Hi,I'm using two SentinelDownloaders in my workspace: one to download data from a specific year and another to download data from the previous year. At the end, my workspace shows a "FAILED" message in the API after completing the first SentinelDownloader. I understand there is a conflict because it's the same transformer being used for different dates in the same execution.How can I run this workspace without problems?Thank´s

161

1 month ago

romarContributor

asked in Community Q+A

Oracle connection timeout for long running workspace

Hi! I have a workspace with a runtime of effectively 28 hours (this workspace controls slave workspaces, that get 50 million rows of external data). The runtime is only this long for the initial running of the workspace, However it is possible to get severe peaks in runtime due to hystorical data recalculations. I finish the workspace with a SQL executor that merges the retrieved data with already existing data and does some other cleanup. At this point this transformer fails though, forcing me to run the queries manually. I have not saved the log due to my brilliance :). the error given is paraphrased: there is no connection with the oracle server. I think the issue is that a connection is established previously with the oracle server, than put on hold for about 28 hours, than necessary again, with an elapsed acces key. Is there a way to circumvent this? I have not tried, due to time commitment, to untick persistent connection, should that work?

131

1 month ago

d.jimenezContributor

asked in Transformers

PythonCaller ArcPy 'FeatureProcessor' error

Hi,The below python code works in ArcGIS Pro:But returns the below error in FME:What would be the ‘FeatureProcessor’ python symbol?Regards

362

1 month ago

gisgeekContributor

asked in Community Q+A

Extracting tables contents from webpage

Hi there I have been trying to extract the contents of a webpage the Facilities Masterlist which is on our internal sharepoint. I have downloaded a local copy of the page I am trying to extract contents from and attached it. I haven’t had much luck extracting the contents to replicate the table on the page. This is what I have so far.

201

1 month ago

topotomaContributor

asked in Data

Featurewriter Excel error "Named range from /xl/workbook.xml part" only with 2024.1.2.0

Hello,When using Featurewriter with a template excel file, i encounter en error when trying to open the written excel file which indicates a problem with the Named range "Named range from /xl/workbook.xml part".This happens only since updating to 2024.1.2.0, if I use the same workspace with 2022 version it’s fine.Has this happened to someone else ? is there a workaround ?I’ve tried a lot of things but couldn’t find the issue so for now we run this workspace with 2022.Thanks for your help.

240

1 month ago

poonam21Contributor

asked in Community Q+A

FME Certified Professional Exam

Hey Safe,I’m planning to take the FME Certified Profesional exam and I wanted to know that what is the format of the exam and how many questiona are being asked. Also what kind of questiona do we get in the exam? Are they like the training program or different?Also I have read that the exam is open book. What exactly open book exam in this case means?

1257

1 month ago

pushpaContributor

asked in Data

Column names on Oracle VIEW doesn't show on FME workbench.

Hi there,I have placed few VIEWS on Oracle Database changing TABLE column names. ie: ID as PLANT_ITEM_IDWhen I connect the VIEW via FME 2023.2.1.0 all column names are showing as what is recorded on Oracle Tables. It is ignoring column names I have set up on VIEWs. How do I get around this issue?I don’t want to use “attribute manager” to change the names. I have already done that on my VIEWs.Is there a way I can see the Column names on VIEWS through FME?thanksRegards,Pushpa

401

1 month ago

bjoernContributor

asked in Automation

FME Flow Automations Parameter in a Group Box

Hi,In FME Flow (2024.1.1.1) Automations, I cannot set parameter values from a trigger to a workspace when the published parameters are in a group box. There is simply no select button. On the other hand, if I bring the parameter to the first level, it works. Is this a know issue or intentional?

181

1 month ago

Page 14 / 809

Badge winners

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
mglancloshas 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.