Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Search

Recently active posts

355 Posts

Recently active

Most views Most replies

emerson_stylesContributor

Strange characters appearing instead of date

I have a script that pulls numerous datasets together, formats them into a consistent set of attributes and then writes them to .TAB files.I’m having difficulty with date field (STARTD) in the final output because although appearing to be correct in the .TAB files, ArcPy is not able to detect the dates in the .TAB files and instead shows the data as odd characters. Please see the image below for more information. Has anyone seen this before or aware of how to fix the issue? I’m not sure if there is a setting in my FME script that may need to be amended.

asked in Community Q+A

GeometryExtractor does not keep polygons orientation in geoJSON

Hey I think I found a bug in the GeometryExtractor, where the geoJSON writer and the GeometryExtractor that writes geoJSON geometry to an attribute lead to different results. I have a sample workbench where I buffer a point, the GeometryExtractor writes the coordinate following the wrong orientation (clockwise vertex order) but the geoJSON writer generates the correct geoJSON (counter-clockwise vertex order).is there any way to fix it? I need to write the geoJSON geometry string into an attribute. Thank you,Andrea

eric_armitageContributor

asked in Transformers

XMLTemplater issue - missing comma "," between expressions

Hi I am trying to use the XMLTemplater with a SUB template. The start of the ROOT expression looks like this (from an existing xml file that it valid)When I run the workspace I get this message. Does anyone know what the syntax error is and how to correct it?

judithObserver

Find and Replace function for given attributeNew

Hi, renaming an attribute in large workspaces oftentimes takes a lot of time because of the related manual adjustments needed. I would appreciate a function that is able to change a given attribute to another given attribute within a whole workspace in every Transformer and Writer.Best regardsJudith

brunoContributor

asked in Transformers

How to add IFC property

Hello to all,I need to add a missing property into an existing Pset. I tried the workbench shown by Liz in the post “Updating IFC example” but it doesn’t work in my case. Before testing with an Excel sheet contaning GUID and properties to add, I just test to add manually a single property:First, I created 2 attributes:Then I used the GeometryPropertySetter:With the XQuery:I find my previous properties in the “Proprietes” Pset, but I don’t have the new one “TypeVitrage”. Did I forget something or do I have to use “IfcPropertySetDefinitionCreator” ? Thank in advanceBest regardsBruno

mmccartContributor

asked in Automation

FME Flow 'Debug' Log Option for Workspaces in Automations

In the ‘Run Workspace Dialog, there is a ‘Log Debug’ option under ‘Advanced’ settings here: Why isn’t there an option to enable this ‘Log Debug’ in Automations when configuring the ‘Action>Run Workspace’ interface? I need debug logging details to run my automation in ‘production’ mode. It’s not honoring the logging setting when I published from FME Form. Shouldn’t the option be here: My ultimate goal is to have log files from workspaces ran within Automation have full debug logging enabled.Is there some setting in a config file I can change?Version: FME Form/Flow 2024.1.1.0 (Build 24619)

femoContributor

asked in Community Q+A

Reading Excel files with different columns

Hello,i need to process excel files, currently by means of FME Form 2023.1, perspectively using FME Flow. These files, however, can differ in columns available. See attachments. The files are processed individually, only one file at a time.If i run the process with file “tk_template_v0.0.xlsx” I want the featurereader to display only the columns, containing in this file. If I run “tk_template_v0.1.xlsx”, which has got 3 more columns, i want these columns to be available in the process as well.I would like to run the script with these files without clicking on the “Feature Types to Read” button any time I process a new file! The sheet name always have the name “Tabelle1”.Unfortunately I do not find a set of parameter that results in the desired output.The existing posts have not yet enlighten me! Any ideas?

raymondbrunnerContributor

asked in Community Q+A

SQL Creator/Executor using an ArcSDE connection works in FME Form but is unsuccessful when published to FME Flow

Our FME Form installations are able to establish ArcSDE connections with a SQL creator to our enterprise SQL Server geodatabase and perform SQL Select statements.When these workspaces are published to Flow the following warnings are received and the records are not read:“Esri Geodatabase: ArcMap has limited SQL functionality and may not be able to process query 'SELECT CPSUPV,CPTECH FROM AICC.GLP_BDinfo'. Consider installing ArcGIS Pro for broader SQL functionality”FME Flow is able to use the same ArcSDE connections, and read records with an ArcSDE Reader from our enterprise SQL Server geodatabase. It only seems to complain when we attempt to execute SQL through the connection with a SQL Creator or Executor.Additionally, FME Flow successfully executes SQL statements using SQL Creators/Executors against the enterprise geodatabase when connecting via a Microsoft SQL Server Non-Spatial format connection.Is there a configuration that could be addressed on the Flow Servers to enable SQL Cr

scarterContributor

asked in Authoring

Fanout failing to write fanned out files

Hello Forum, I’m attempting a fanout on a geojson file based on specifying an attribute. This is a simple task which I’ve carried out dozens of times before with success on other datasets. However, for some unknown reason it’s failing to fanout on a particular dataset. I’ve read in the geojson with FeatureReader. This is connected to a to a FeatureWriter. In the FeatureWriter I have… Selected format: Geojson (Geographic JavaScript Object Notation)Browsed to a destination UNC path and ensured the .geojson extension is shown. Note that the geojson writer it defaults to .json extension, so you have to change it to .geojson manually.In Parameters changed ‘Reproject to WGS84’ to NoIn General>Feature Type Name selected ‘open text editor ‘ and then selected Primary_Function from the FME Feature Attributes list. Note that Primary_Function is the attribute I wish to fanout on. The attribute exists in the source dataset and does contain values. However, this then fails to write fanned out geo

79king đảm bảo môi trường trải nghiệm an toàn, công bằng và minh bạch. Với đội ngũ hỗ trợ chuyên nghiệp hoạt động 24/7, 79King cam kết mang đến dịch vụ tốt nhất, giúp khách hàng tận hưởng niềm vui không giới hạn.Phone: (+84) 503 612 322Địa Chỉ: 206 Đ. Phú Thọ Hòa, Phú Thọ Hoà, Tân Phú, Hồ Chí Minh, Việt NamEmail: 79king.pink@gmail.comZipcode: 70000#79king1 #79king2 #79king3 #79king4 #79king6 #nhacai79king #nhan100k79king Brand: https://79king.cooking/

lifalin2016Contributor

asked in Deployment

FME Form 2024 fails to connect to FME Server 2022?

Hi All.Our FME servers are still running 2022.2, but I need to run a specific job in FME Form 2024.1, and have it execute a workspace on the server.But the workspace refuses to connect to the server. This happens regardless of using FMEServerJobSubmitter (as copied from an old workspace), or a brand new FMEFlowJobSubmitter.The web connection used is saved in an older version (2020-2022), and works there. I tried to create and use a new connection in 2024, but that also fails.What caveats are present when trying to connect 2024 to a 2022 server ?Any insights and experiences are welcome.Cheers, Lars I.

pehrsContributor

asked in Community Q+A

IFMEFeature with aggregated/multiple geometry

We have a reader plugin (c++) that should be able to set aggregated/ multiple geometry to an IFMEFeature.For example:We have only several IFMEGeometry objects. These IFMEGeometry objects should be set to an IFMEFeature. So that we have finally an IFMEFeature that consists of several different geometry objects/ parts. IFMEFeatureIFMEGeometry_Part_1 IFMEGeometry_Part_2 …. IFMEGeometry_Part_nfme_type = fme_areafme_geometry = fme_aggregatefme_feature_type = DepthArea How can we solve this?

georgiecContributor

asked in Authoring

Reference a Global variable within a Tester Transformer

I am trying to compare the total of features from my original data source to the number of features ultimately written to a dataset. I thought I’d create a variable from Statistics Calculator result to refer to in my Tester. Is there a way to reference the global variable I have set within the Tester phrase ?If not, is there an efficient way of comparing the stats between the beginning and the end ?

chris.schulzParticipant

CouchDB deprecation

Hi, Ive noted that CouchDB has been deprecated. Of course, this is the exact thing I need right now :( Is there any alternative way to access this database using the latest (2024) version of FME?

philippebSupporter

Create new field to ArcGIS Portal Feature

Hello,Is it possible to write new fields in ArcGIS Portal Feature Service with a writer ?I’m getting that message : ArcGIS Portal Feature Service Writer: Attribute 'NAME' on feature type 'Roads' does not match any field on the corresponding layer/table. The attribute will be ignored I can’t believe I have to create those fields with ArcGIS Pro, publish the layer and than run my workbench. Update:OK I just found out that I need my fields to be in lowercase to make it work.But for some reasons some field type are not working.Is there any existing list of all the constraints we need to follow for the fields in Portal? That would save me time! Thanks!

arash_hokmContributor

asked in Community Q+A

create polygons from polyline

Hello FME community,I'm trying to create polygons from Polylines. With Aerabuilder I could create 95 percent of Polgons. As you can see in the picture, in some cases no polygons were created.Polygon creation failed (yellow frames)

ecxContributor

asked in Community Q+A

How to extract FeatureReader/Writer parameters using FMEFlow Rest API v3

Hello, I currently have a workbench that extracts all of my job history, auotmations, dataEndpoints (readers/writers) which I feed into a powerBI dashboard so I can more easily track data i/o, and jobs via using httpcallers and the fme flow rest api v3.I have just realised there is a issue with this, FeatureReaders, FeatureWriters, SQLExecutors and SQLCreators are excluded when using get “/repositories/{repository}/items/{item}/datasets/{dtype}”… to extract my readers/writers, dtype refers to source or destination, which is only assigned to readers and writers.The issue is FeatureReaders and FeatureWriter are transformers, they are not included in this output!What other methods can I use to extract these parameters from the FeatureReaders/FeatureWriters? (source/destination datasets specifically)

ridleyjContributor

asked in Integration

Sharepoint List Reader returns unexpected NULL values when Sharepoint Column settings allow multiple selections

Is there a solution to correctly read sharepoint list attributes that are multi-select columns?When reading a sharepoint list with relevant permissions to read,write etc. the data table returned shows only <NULL> values for any column that has multi-selection enabled - adjacent columns with single select settings that hold the same data type (username) are returning the expected values - only the column settings differ.[Note the column setting for allow selection of {people only / people and groups} may also play a part in this question]The column that is returning NULL only has settings as below: List columns that return the expected values have settings:

evoteckContributor

asked in Automation

issue performing this (FME Flow Connection dialog opens, and he fills it out to connect to FME Flow running on his own machine:)

I am finding it difficult completing the task’s above on the image. how can I check my own username and password set during installation . Get the connection details from your FME Flow Administrator. If you are using FME Flow on your own machine, use http://localhost and your own username and password set during installation.

danielleatsafeSafer

posted in Question of the Week

Question of the Week: What's your go-to source for technology news?

Hi FME Community, We’re back with our Question of the Week: What’s your go-to source to find out about what’s going on in technology? Do you have a favourite podcast, newsletter, trade publication, or other resource?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 and points toward badges! Answer our September Questions of the Week by Monday, September 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.

philippebSupporter

Read multiple Excel file with different starting line

Hi,I have thousand of Excel files I need to read but all of them have different starting attributes line. Sometimes line 15 or 16 or 17.(not me who developed that method of working….)The attributes are all the same for all the files.Any idea how I could have the Excel Reader to detect the starting line?Thanks !

joaniegeo99Contributor

asked in Automation

Scripted parameter values _undefined_ in FME Flow emailer

FME Flow 2023.1.1, Build 23631 - win64Hello FMEers,I have a simple workspace that is hooked up to a Resource or Network Directory trigger in FME Flow. I connected an emailer to the success port of the action, like so: The workspace contains scripted parameters which get written to an Automations writer called ScriptedParams. I want to get the values of some of the scripted parameters in the email, so through the text editor interface I navigate toWorkspace > ScriptedParams > MyParam and it drops{route.ScriptedParams.MyParam} into the body of the email.But when the automation runs I only get the value _undefined_ in the resulting email. If I ONLY connect the emailer to the ScriptedParams port (i.e. delete the success port connection) the values are correctly passed. But of course I want the email to be sent when the workspace runs successfully.So what is the correct way to configure this automation to get the scripted parameters from the workspace into the success email?Thanks!

jbradforContributor

asked in Automation

On Call Incident management software integration

We would like to convert a large number of scheduled FME flows we execute today via Autosys. Autosys has built-in integration with our Incident Management system (ServiceNow). So if any FME wokspace fails in the flow, it creates an incident in ServiceNow and our on call person is notified by ServiceNow.Automations in FME Flow have the ability to execute a workspace on failure of a workspace, which could use the ServiceNow API. However, we have many flows with many workspace executions in each flow. We run 15 min, 30 min, hrly and daily flows.What is the recommended best practice to integrate our incident management system into FME Flow. Some of the items:When we publish a workspace to flow what are the recommended services (ie Job submitter, Notification Service)? Flow - in the automation do we connect every workspace failure to a Topic then to a ServiceNow API call workspace to send info like workspace name and error code/msg info too? Or do we call the ServiceNow API call works

virtualcitymattEvangelist

Spell Check in WorkbenchOpen

For comments and workspace description etc a spell check would be a nice to have. My splling is terribkle. Currently I have to copy all the text into another tool.

danielleatsafeSafer

posted in Announcements

User meetup in Dallas! FME Breakfast of Champions on October 18

Hi FME Community, We’re excited to announce FME Breakfast of Champions: a new in-person meetup series to connect with other data enthusiasts, exchange knowledge, and see what's possible with FME.Join us at the first meetup in Dallas, Texas on Friday, October 18 from 8:00 am to 10:30 am CDT at Fairmont Dallas. Sign-up here. Here's what to expect:Breakfast and Networking: Enjoy a delicious buffet breakfast as you connect with other data enthusiasts. FME Update and Customer Stories: Hear directly from our CEO and Co-Founder Don Murray on what's new in FME, including the latest updates and enhancements. Plus, you'll get a look into our Winner's Circle, featuring customer success stories. Share Knowledge: We'll close with additional time to connect with other attendees and Safe staff to share your data challenges and opportunities. Go home with goodies! Attendees can expect to take home some FME swag with them.Registration is complimentary and spots are limited. We kindly ask that you only

1
2
3
4
...
15

Page 1 / 15

Badge winners

nbeekershas earned the badge Welcome Back
oskarhas earned the badge Integrate Data with the FME Platform Training
amelchiorrehas earned the badge Student (Grey)
kira_pvc2has earned the badge Welcome Back
speknlhas earned the badge Welcome Back

Show all badges

29,695: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK