- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Recently active posts

399 Posts

Recently active

Most views Most replies

pknoContributor

asked in 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.

545

58 minutes ago

delaneytoursi

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.

2 hours 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.

2 hours ago

arnold_bijlsmaEnthusiast

asked in 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

3 hours ago

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!

193

3 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

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

10914

6 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

8 hours ago

deanhowellEnthusiast

asked in 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

8 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

161

9 hours ago

bmwhbmwhContributor

asked in Transformers

Splitting .las

Hello, my previous post was not well Described apparently, i need to split .las just like that. please if you suggest any workflow do describe it a little more than just the name of transformer as that is usless for me (i dont really know how to use FME)

576

10 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

101

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?

111

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

mark2atsafeSafer

Add a Sampler option to drop unsampled dataNew

I wondered, maybe Safe could add an option to the Sampler to drop unsampled data, instead of sending it out of the unsampled port.Why?Because when I run a workspace with caching turned on, it’s using up resources caching unsampled data that I don’t need. This is especially true since I was set up to sample only the first feature. Having obtained that single feature, I really don’t need the Sampler to carry on storing other data. In fact, I don’t really need it to carry on processing at all!

191

13 hours ago

virtualcitymattEvangelist

Make it easier to output temp files e.g., with FeatureWriter/HTTPCallerOpen

The use of temp files in FME is not uncommon and the process for creating temp files right now in the middle of a workflow seems more complicated than it needs to be. The current workflow requires a user to put down a TempPathNameCreator and each feature which goes through this will create a new pathname, this is rarely desired. You need to use a FeatureMerger or something similar to get the correct path onto all of the feature which over complicates the process. Better would be an option to either put the same path on each feature, or add a GroupBy. Even better still would be an option directly in the FeatureWriter/HTTPCaller to just output to a temp location and doing away with need for the transformer in many workflows.An additional benefit of changing the way this works would also be in debugging. At present if you want to inspect the temp file in a workflow you either need to modify/disable parts of the workflow and/or change the path in the FeautreWriter/HTTPCaller. Furthermore,

492

14 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

john_gis4Contributor

posted in Integration

Views on recent FME price changes

I’m not sure if this is the right forum or category (I couldn’t select “general”), but as I’m sure you’re aware, Safe recently changed it’s pricing for FME, which includes annual maintenance pricing. We are a small consultancy business, long term Safe customer (10+ years) and have been FME advocates amongst our customers for many years. We have just received details of pricing for our annual maintenance in 2025 and for FME Form (previously FME Desktop Professional) for us this has increased by approximately 600%.The new maintenance price for FME Form is going to make it a lot more difficult to justify for a small business like ourselves.We were also previously lookng to expand our FME use by purchasing Flow, but the new pricing has also forced us to cancel those plans.We will also find it difficult to recommend FME to our customers, especially smaller ones, as the bar to entry in terms of pricing has been set so high.I have previously raised the issue of pricing with our reseller in th

2683

16 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 -

181

19 hours ago

galigisEnthusiast

Remove the moderators review after posting a question with hyperlinksNew

Hello,I have noticed that any question with hyperlinks posted on the community goes to the moderators for review now. I think this slows the process of answering questions as the questions are reviewed by moderators in another timezone and would take a day to publish and another day to get answered.My idea would be remove the moderators review.Thanks

404

19 hours ago

Page 1 / 16

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.