- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27566 Posts

Recently active

Most replies Most views Newest first

pflegpetContributor

asked in Transformers

Automatically remove unused attributes

According to several solved questions in this forum, there are two recommended ways to automatically remove attributes that only conatain NULL or empty values: using a small python script or using the NullAttributeMapper. Unfortunately both suggestions do not work for me (FME Desktop/Form 2022.2). Both the PythonCaller and the NullAttributeMapper keep the Null-Attributes and they are present when I write to Excel (see attached workspace). Is there something wrong in my workflow or is there an updated solution? Thanks for any suggestions!

6336

2 months ago

sam_appletonContributor

asked in Authoring

Deployment parameter - Local value doesn't work

Hi,I have a deployment parameter (Text) that is pointing to an SDE file on FME flow in my shared resources. When I try to set a local value in form, it ignores this value and throws an error saying it can’t access the share resources file path. I’ve tried creating a deployment parameter that is type: database connection, but this doesn’t work either. Here’s the error:This was working a week ago and now it refuses to acknowledge the local value. Many thanks, Sam

574

2 months ago

geodavid76

asked in Transformers

How to know what is inside zip file for processing

Hi all,New on the forum but not on FME :) (although not an expert). I come acrross a doubt on how to work with zip files. I know FME reads zip files directly but only if you know what kind of file is inside it. So If I have some URL with zip files but those can have dwg, shp, png...I cant really figure it out how to say FME ok, you shape file go this path, dwg this other path... I know I could use httpcaller and store them, unzip and work with them after unzipping by filtering out the inputs but I want to save disk space and dont really want to unzip.Any idea will be welcome.Thanks!

17711

2 months ago

axcel.fmeContributor

asked in Data

Substring operation incorrect in several cases

Dear all,I’m spending a lot of time trying to sort out an issue with a substring operation but I cannot see my results are not correct in several places.In FME workbench 2024.0, I use the the AttributeManager to read a substring from the attribute _response_body and to write it to the attribute info. The response body is the result from a reverse geo-coding with OpenStreetMap and I want to extract the location for the given coordinates. To extract the relevant part, I use the following sequence of String operators:1) Take everything left of </result>2) From this, take everything right of address_rank3) From this, take everything right of >The actual (unfortunately complicated) condition statement which I’m using is:@Right(@Right(@Left(@Value(_response_body),@FindString(@Value(_response_body),</result>)-1),@StringLength(@Left(@Value(_response_body),@FindString(@Value(_response_body),</result>)-1))-@FindString(@Value(_response_body),address_rank)),@StringLength(@Righ

556

2 months ago

joku041199Participant

asked in Data

Only loading in Raster data based on Area of Interest (from a GeometryReplacer and User Parameters)

Hello, I am using FME 2022.2 and I’m trying to load in Raster data, based on an Area of Interest (AOI), specified by the end-user in FME Server (yes my organization is not using FME Flow yet, but the old FME Server). We have a few big Raster datasets on a local drive (of the entire Netherlands), which are loaded in as regular Readers. Then, using a Creator and GeometryReplacer, the end-user can specify an AOI (using a User Parameter), and the Rasters are then clipped in the Workspace using a Clipper. However, this means that the big Raster datasets need to be loaded/processed every single time the Workspace is ran, which is bad for performance. What I want, is that the Raster data is loaded into the Workspace, but only the data which intersects the AOI, specified by the end-user. I tried using a FeatureReader and use the AOI from the end-user as trigger to load in the Raster data. However, for some reason, the entire Raster dataset is loaded every time, instead of only the Raster data

392

2 months ago

raabsterContributor

asked in Data

Can't get workspacerunner to run as expected

Hi!So, I have a workbench that takes a shapefile and an excel file as input, does some magic and outputs an excelfile. The workbench works as expected. So far so good. Se image below. Now, I have a number of shapefiles that I want to process in the same way, so I figured a workspacerunner would be a good solution, instead of replaceing the input shapefile in the image above.So in a second workbech, I take a PATH as reader, filters out my shapefiles and into the workspacerunner (see img below). Everything seem to be working - but only the shapefile that has the same filename (test.shp in the images) gets treated properly.So in this example, test.shp get an output excel file that seems fine, but the other two does not. Any ideas of why that is? My guess is that I’m doing something wrong 😅 I can’t share the workbenches I’m afraid. Cheers!

333

2 months ago

mr_fmeEnthusiast

asked in Data

Get attribute value in Python Caller

Hi,I'm programming in Python using FME Desktop, specifically using the Python Caller transformer. I'm trying to use a variable called test in my script, where test should have the value assigned to the attribute _creation_instance. I'm declaring it as follows: test = feature.getAttribute('_creation_instance'), but I'm getting the following error:Python Exception <NameError>: name 'feature' is not defined How can I properly get the value from _creation_instance? Thank´s

773

2 months ago

fmelizardContributor

asked in Integration

HTTPCaller and Twitter API authentication problems

I am currently starting a project requiring me to pull images and videos from a Twitter page. Originally, I was using the TwitterStatusFetcher transformer to pull the individual JSON object of every tweet, and extract the corresponding image and/or video. While this was working to an extent, I noticed that the JSON extracted from the TwitterStatusFetcher at times did not contain an image and/or video when there should've been one. I believe this is due to a recent change in Twitter's API requiring an extra parameter (tweet_mode=extended) to retrieve a full tweet. As such, I've been trying to access the Twitter API directly with this extra parameter, using the HTTPCaller transformer. However, Twitter requires the use of Oauth 1.0 for me to pull tweets. I'm unsure of how to set up the web connection for Twitter to use Oauth 1.0, as FME 2016.1 uses Oauth 2.0 to establish a web service. I have all the required consumer and access tokens already, I'm just unsure of how t

755

2 months ago

lambertusEnthusiast

asked in Data

Looping a set of varying user parameters

Hi, I have a workbench which is fed by a set of user parameters. It produces a dataset of 10.000+ buildings for a chosen municipality and extraction date. Is it possible to create an input which loops through these user parameters:Userparameter 1: CityUserparameter 2: Extraction dateRun City Date 1 A 2020-01-01 2 B 2020-01-01 3 C 2020-01-01 Workbench should behave like first run City A with first date, than City B with 2nd date, than City C with third date

552

2 months ago

marta.podsiadSupporter

asked in Integration

DYNAMIC plugin

Hi,I’m experiencing issues with searching for a path for a PDF. Unfortunately, the process is extremely slow and seems to be stuck at this message. Could you please advise on how to proceed?

mr_fmeEnthusiast

Hi, Sometimes after running some workspaces, the process freezes at the point shown below: The workspace doesn't run anymore. It can stay like this for hours and not progress... Has this happened to anyone else?

572

2 months ago

schulte.aContributor

asked in Authoring

Help with getting my timestamp data merged correctly so ArcPro time slider will play nice with it

Hello, any help would be greatly appreciated with this idea I have: I am trying to figure out the least convoluted way to take my current data and get it into the format ArcPro likes it to be in to take full advantage of the Time Slider. My ultimate goal is to use the time slider in arcpro and the user can slide the time to show how a floor was occupied throughout time.So, I have a large amount of motion detectors. The data is fed to me like so:SensorName Timestamp SensorStatus 1 12:00 1/1/2024 On 2 12:05 1/1/2024 On 1 12:06 1/1/2024 Off 2 12:10 1/1/2024 Off Then Sensor 1 could be triggered again and so forth Arc seems to want the start and end times in the same row. like so:SensorName Start End 1 12:00 1/1/2024 12:06 1/1/2024 2 12:05 1/1/2024 12:10 1/1/2024 It needs to organize 100s of results from numerous sensors and get the start/stop times on the same row, for the correct sensor, for the correct period of time.

333

2 months ago

lambertusEnthusiast

asked in Data

Assign street codes - spatial order

I have a dataset with 3000 polygons represting streets. Each street is divided into subparts and need a unique code to be assgined. The first part refers to the streetname and is the same for each subpart, 2nd part is a unique counter.Image below shows my current (top) and wanted situation (bottom part).Any support is appreciated!

Further investigation after getting "Esri Geodatabase Writer: XXX attribute value(s) were truncated" in log

I want to write to an existing FGDB and I'm getting "Esri Geodatabase Writer: XXX attribute value(s) were truncated" (in my case: XXX = 500+) in my translation log. Concerning the attribute values that should get written and given data types, everything seems to be fine. What could be a way to determine which attribute values are truncated and why? I can't find further information on this.

PostGIS dynamic writer forces lowercase attribute (column) names

As is stated in the title. However I need column names to be created exactly as they are, for example I have incoming attribute "OGC_ANGLE.uom" and even though I have Lower Case Attribute Names unchecked,tables in database have column names are created lowercase ("OGC_ANGLE.uom" becomes ogc_angle_uom) - this is a problem, if I read those tables and try to use xsd to create gml again, as these attributes are unknown to the xsd, therefore failing creation of the gml. I could manually rename those columns, however I would need to rename those columns every time xsd file changes, which is why I need to do this dynamically in the first place, as those xsd files are going to be updated quite often... And it seems that the dynamic PostGIS writer ignores Table Qualifier, it always creates tables in default schema, unless I specify schema in Table Name (schema.@Value(fme_feature_type))

16824

2 months ago

fabio.simaoParticipant

asked in Transformers

AzureIOTConnect transformer in FME

Hi Community,I am encountering an issue when attempting to connect to Azure IoT Hub using the AzureIOTConnect transformer in FME. Despite successfully generating an X.509 certificate using OpenSSL and being able to connect to Azure IoT Hub through a Python script, I am unable to establish a connection using FME. Here are the steps I followed:Generated the device key and certificate using the OpenSSL;The generated certificate includes the following relevant details:X509v3 Basic Constraints: CA:FALSE X509v3 Extended Key Usage: TLS Web Client AuthenticationThe connection works perfectly when tested through a Python script, but fails when using the AzureIOTConnect transformer in FME. The error message returned by FME is as follows:Failed to connect to the broker. The reason given is '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)' Given the details above, I am seeking guidance on the following:Are there any specific configur

432

2 months ago

lifalin2016Contributor

asked in Authoring

Template "Microsoft SharePoint Online (safe.microsoft-sharepoint)" not available in 2022.2 ?

Y’all.I’m trying to create a connection to a customer Sharepoint for the first time. And I’m confused.I got something to work in 2020.2, but would rather it ran in 2022.2 (same as our servers). But I’ve also tried it in 2024.1There seems to be two web service templates, (Template) and (safe.microsoft-sharepoint).According to this article they are each designated for use with Sharepoint List r/w and SharepointOnlineConnector respectively.But apparently I can’t create a new web service based on the latter in 2022.2, and the latter isn’t even available in 2020.2So when did this change, i.e. in which FME version ?CheersLars I.

452

2 months ago

bwnEvangelist

posted in Transformers

Customer Transformer: AttributeTruncationChecker

My first “proper” Custom Transformer for maybe public consumption is AttributeTruncationChecker (attached)I’m not sure I have totally debugged it, but it seems to work now in most samples I throw at it. Will leave it here for the Community to possibly use it and improve it.This is trying to address possibly one of the more common headaches we run into, in getting the dreaded Truncated Values warnings in the Translation Logs when a Feature Attribute string is too long for the Writer destination field. At the moment, it is very time-consuming to track these down in large Feature datasets/Multiple Feature Datasets being written simultaneously, to design and run some Transformations to try to find the offending Features and which Attributes.This Transformer aims to detect these in the Workspace, by comparing the Workspace Features to Reference Schema Feature(s), typically from a FeatureReader. Originally I found I could “solve” this relatively easily with AttributeExploder based standar

472

2 months ago

laxmi_2590Contributor

asked in Transformers

XML Templater to read a List

Hi Everyone, I have recently started with FME. I have a case where I have to format an XML from a list. I am using XMLTemplater Transformer to build a request xml which looks like below<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wnb="http://sample.com.au"> <soapenv:Header/> <soapenv:Body> <wnb:fetchNotificationDetails>  <notificationNo>121</notificationNo> <notificationNo>131</notificationNo> <notificationNo>141</notificationNo> </wnb:fetchNotificationDetails> </soapenv:Body></soapenv:Envelope> I am passing some ten notification numbers to a XML templater and they are coming out individually like below <soapenv:Header/> <soapenv:Body> <wnb:fetchNotificationDetails>  <notificationNo>301</notificationNo>

485

2 months ago

cavarlyContributor

asked in Authoring

SchemaScanner and dynamic FeatureWriter method

I am attempting to write out data using a schema scanner and dynamic featurewriter.It is simply not working. I always get "Unknown feature type 'BOUNDS' passed to the JSON writer.It doesn't matter what I do, always the same.BOUNDS is my fme_feature_type and fme_feature_type_name.I will eventually use group by attribute but it doesn't even work with just one typeI believe I am following the standard practice but I have always been stumped when trying to write dynamically. Please could someone outline the boiler plate method (with the steps ordered) to use a SchemaScanner and Dynamic FeatureWriter in the scenario where one would need to create or overwrite fme_feature_type and fme_feature_type_name or use a custom names for these. As I understand it, I should only need to make sure I have an attribute on the data with the same name as the Schema Definition Name.THANKS! NOTE below, feature_type_name is not available to choose, in this iteration

323

2 months ago

ravibansalContributor

asked in Transformers

How to reassign address ranges to segments after breaking the segment

I have streets with LEFT and RIGHT address ranges assigned. In some cases, I need to break the segment into 2 or more segments (for example, when a railway track is crossing the street). How do I re-calculate the NEW address ranges for the NEWly created segments? For example, as shown in the image, parent segment has address ranges of 0-100 and 1-99. After braking it up into 2 segments, I am expecting to calculate and assign address ranges of 0-28, 1-29 and 30-100, 31-99 to the child segments.Which transformers can I use to calculate the address ranges for the new segments?

581

2 months ago

marta.podsiadSupporter

asked in Integration

DYNAMIC plugin loading

Hi,I’m experiencing issues with searching for a path for a PDF. Unfortunately, the process is extremely slow and seems to be stuck at this message. Could you please advise on how to proceed?

232

2 months ago

susmarContributor

asked in Authoring

Snowflake - SHOW GRANTS TO ROLE syntax

I want to display a list of tables/views that a specific ROLE has access to. I can do this in SQL with the command SHOW GRANTS TO ROLE TESTROLE. However, putting this SHOW command directly into a Snowflake Reader WHERE Clause generates an error (syntax error line 1 at position 270 unexpected 'GRANTS'.) and returns nothing in a SQL Executor transformer. Is anyone please able to advise either what the correct syntax is or if there is another approach/transformer that should be used? Thanks.

393

2 months ago

gattogisContributor

asked in Transformers

Issue with AttributeValueMapper and Cached Values in FME

Hi everyone,I'm facing an issue with the AttributeValueMapper transformer in FME. My goal is to remap all values in the "abbreviazione" field using values I want to input manually. However, I've noticed that I'm unable to set the distinct values of the "abbreviazione" field as input values because the transformer doesn't seem to offer the option to read cached values.The only option I'm given is to import the values from an external dataset, but I'd like to avoid adding too many steps, especially since in other cases, I was able to select the distinct values directly from the layer I'm working on (or at least I think so...).Has anyone encountered a similar issue or have any suggestions on how to proceed? It would be really helpful to understand how I can retrieve and manage these distinct values within the workflow to use them in the remapping.Thanks in advance for your help!

Can FME write to an Excel table?

I have got some beautiful Excel templates containing tables (not normal ranges). It's quite easy to write to a named range within Excel but I haven't figured out how to write to a Table. Does anyone know how to do so?

964

2 months ago

1
...
19
20
21
22
23
24
25
...
1103

Page 22 / 1103

Badge winners

kjetilpetterssohas earned the badge Welcome Back
jorge_rosaleshas earned the badge English Speaker
jorge_rosaleshas earned the badge Spanish Speaker
gjaguilarhas earned the badge Student (Bronze)
mpittingerhas earned the badge Teacher (Grey)

Show all badges

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