FME by Safe Software Community

Recent activity
Unanswered
Categories

Custom Ireland Tours for US Travelers: Design Your Dream TripNew

Tailor your dream trip with our custom Ireland tours designed for US travelers. Choose from a variety of experiences, including scenic routes, historic sites, and cultural activities, all crafted to match your preferences.

56 minutes ago

bwnEvangelist

Align SQLite, Spatialite, Geopackage Writer Table Name.Field Name constraints to specificationsNew

Currently the SQLite, Spatialite and Geopackage Writers (all SQLite based) enforce constraints on table and column names that do not align with the format specifications.For example, all formats allow Upper Case characters, spaces etc. within Table Names and Column Names, with only limitations that has to being with an alphabetic character and certain SQLite Reserved words cannot be used without enclosing the field name in “”.In order to maintain Schema alignment between Eg. a Data Source, like a Geodatabase, that may contain Upper Case characters, spaces etc. then the corresponding SQlite based formats above should, by default, keep the Schema Attribute Names as-is, since similarly there is no requirement in their format specifications to enforce these rules, and most applications consuming the data will interoperate with these naming conventions fine.Enforcement of lower case/removal of spaces should instead be optional as a user set Parameter.

1 hour ago

arnold_bijlsmaEnthusiast

Data

What are fast Geospatial Formats to Read?

A bit of a subjective question, but what are fast file-based geospatial data formats to read in FME?I have a set of geodatabases (10GB) covering the whole country, and it’s located locally on the C-drive of the FME Flow server. Users specify a bounding box to extract the data for their area of interest.To make the current setup faster, I have played with indexes and made sure that I’m doing a bounding box intersect on the FeatureReader, etc. But it still takes at least 10-15 minutes to get the output.One other idea that I’m playing with is to use a different format for the source data instead of geodatabase. GeoPackage got a mention somewhere; FlatGeoBuf apparently is fast; and I have heard good stories about GeoParquet. Any other formats I should consider?Has anyone done any comparison on this? Any pitfalls / drawbacks I should be aware of?At the moment I’m looking more at file-based formats, as formats that require additional (database) software would involve IT too much.I will do t

10911

2 hours ago

pknoContributor

Transformers

Identify matching substrings from multiple attributes

Hi everyone,I am trying to match attributes and write the matching part of the substrings into a new attribute. The following table explains it best: 1 2 3 4 match 03.02.06.03.02.01 03.02.06.03.04 03.02.06.03.02.02 03.02.06.04.03.01 03.02.06 03.02.06.03.04.02 03.02.06.03.09.01 03.02.06.03.01.01 03.02.06.03.04.01 03.02.06.03 03.01.04.05 03.01.04 03.01.04 Note that the fields may also be empty and should then be ignored and not all strings are the same lenght. I am also trying to match from the start of the string only. The only idea that came to me so far is to create lists for each attribute using the attribute splitter and then use conditionals to compare each two-digit part seperately, create each sequence and then string them back together. Maybe there is an easier way? Best reagrds.

504

2 hours ago

marjan_nikoukarContributor

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!

193

2 hours ago

fmelizardContributor

Streamline FME Server SSL ConfigurationGathering Interest

The FME Server documentation provides multi-step instructions for configuring SSL (HTTPS). The steps include: the need to copy certificates to specific locations, running command line tool, & editing config files. The process is prone to issues for a variety of reasons. Often the skills necessary to resolve issues are beyond the typical FME Server administrator and requires the recruitment of IT Staff and possibly support from Safe Support.Is it possible to streamline this configuration?Could it be done as an option during the installation? (HTTP|HTTPS)Could it be done through the Web UI or some wizard after FME Server is installed?Could there be a way to test the configuration and determine where an issue exists?Is it possible to make HTTPS the default?By reducing the human interaction for this type of configuration there would be fewer issues and a better experience for FME Server administrators.HTTPS is becoming a very common configuration tweak after FME Server is installed.

119

6119

4 hours ago

danielleatsafeSafer

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.

10914

5 hours ago

dbaldacchino

Microsoft Word .doc/.docx ReaderGathering Interest

We are getting a shiny new Writer in FME Workbench 2018. We also need a Reader! Believe it or not, sometimes we have data in a Word document that we have to read and do something with the contents. I just spent a couple of days figuring out a workaround (great thanks to some of the forum posts that led me to a workaround in the meantime) to harvest images from Word documents and rename them using a piece of data within the Word document. It was a bit painful to say the least.PS: You can read a .docx by extracting it first with 7-zip so I'm using the command line utility to do that via a SystemCaller transformer first, then read in the Office Open XML file.

456

7 hours ago

deanhowellEnthusiast

Transformers

Lines from Points file

I have a text file that has a list of pointse.g. ID, X, Y I then have another file that has a list of linese.g. ID, FromPointID, ToPointID How do I create the lines using the coordinates listed from the points file?

233

7 hours ago

gjaguilarContributor

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

161

7 hours ago

pknoContributor

Transformers

Identify matching substrings from multiple attributes

504

2 hours ago

marjan_nikoukarContributor

Data

Daily Data update in FME

193

2 hours ago

danielleatsafeSafer

Question of the Week

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

10914

5 hours ago

gjaguilarContributor

Deployment

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

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

101

9 hours ago

ivanwriterContributor

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?

111

9 hours ago

lifalin2016Contributor

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

9 hours ago

helmoetzContributor

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

13 hours ago

fmelizardContributor

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!

14 hours ago

jobvdnoortContributor

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

14 hours ago

Welcome

A space for news, notes and introductions

Announcements

26 Posts
75 Replies

Community Q+A

88 Posts
230 Replies

Question of the Week

24 Posts
413 Replies

User Spotlights

3 Posts
9 Replies

FME Form

A space to discuss FME Form

Authoring

3024 Posts
12530 Replies

Data

6782 Posts
24942 Replies

Integration

1042 Posts
3648 Replies

Transformers

12673 Posts
50700 Replies

General

4033 Posts
13786 Replies

FME Flow

A space to discuss FME Flow

Automation

803 Posts
2719 Replies

Architecture

619 Posts
2008 Replies

Security

135 Posts
399 Replies

Deployment

84 Posts
189 Replies

Flow Hosted

84 Posts
253 Replies

General

606 Posts
1882 Replies

Community Alerts

Alerts about activities taking place in different parts of the FME Community and Safe customer ecosystem.

FME Hub Alerts

80 Posts
0 Replies

GIS-StackExchange Alerts

31 Posts
0 Replies

Blog Alerts

12 Posts
0 Replies

Leaderboard

Show full leaderboard

Redeem Reward Code

Enter a reward code and click submit to redeem the code for community reputation and badges.

List My Webinars

Click the button to retrieve your own personal webinar transcript.

List your webinars >

List My Badges

Click the button to find out which badges you have, and which you are yet to earn.

List your badges >

Welcome to the FME Community!

Community News and Announcements

Leaderboard

Redeem Reward Code

List My Webinars

List My Badges

Last Badge Awarded

More Useful Links

Need more help?

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded