- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27662 Posts

Most replies

Most views

Newest first

arnold_bijlsmaEnthusiast

asked in Data

Geodatabase Error (-2147219884): The Field already exists

Not a question, but just an issue I thought worth sharing. When converting my data to a geodatabase, I kept getting the following error message: "Geodatabase Error (-2147219884): The Field already exists". Not a very helpful error message and googling this didn't help much.It turned out that my sewer pipe input file had a field named 'shape', and geodatabases don't like that! Using the AttributeRenamer to change the field to 'shape1', everything then went tickety-boo!

60117

3 months ago

nicholasContributor

asked in Transformers

FeatureMerger Join on a number equal or greater than a number

Hello all,I have a two roads datasets with a road_id, a through_distance_start and a through_distand_endI want to do a merge, FeatureMerger, where;road_id equals road_idtdist_start equal to or greater than tdist_starttdist_end equal to or less than tdist_endHow do I accomplish this in FeatureMerger? Or is there a different transformer?

301

3 months ago

vkiContributor

asked in Transformers

DateTimeConverter and NULL values

I want to convert the format of a date-attribute from %Y%m%d to %Y-%m-%d by using the DateTimeConverter. This works fine, as long as there are no Null-values. As soon as there is just one Null-value, all other values are set to Null as well (even though the option “Passthrough Nulls, Empties or Missing” is set to Yes).I tried to filter out the features with the Null-values, convert just the features with values and merge all features after the DateTimeConverter again, but here too, all attributes are set to Null.If I set the Null-values to a dummy-date, then it works. But I don't want dummy-dates, but Null-values, so how do I do this?Thanks in advance, Vera

844

3 months ago

gjaguilarContributor

asked in Transformers

There a way to debug the execution of the script in FME?

In a process in my company we use a Python script (PythonCaller) to call a download API, we need to modify it, but we get some errors that I don't get when running the script from Python on the Windows command line.Is there a way to debug the execution of the script in FME?

1785

3 months ago

david_Contributor

asked in Data

Read dinamically any Excel file without header

Is there any way to read dynamically any excel file and that the header are simply the column name A, B, C, D...Through a Reader I can read any Excel file but the problem is that it always takes the first row as the header.Thank you!

323

3 months ago

skotnicamParticipant

asked in Data

FME 2021.0.3.2 crashes on macOS 14.6.1

Hello,I am running on macOS 14.6.1 and I use FME 2021.0.3.2 which stopped working from today. It crashes after “Initializing Main Window”. I am attaching the relevant part (I hope) of the crash report. Has anyone run into the same problem?(Data inspector and Quick translator work, only Workbench crushes)Thank you! Notes:PC register does not match crashing frame (0x0 vs 0x7FF89317AA78)Crashed Thread: 0 CrBrowserMain Dispatch queue: com.apple.main-threadException Type: EXC_CRASH (SIGABRT)Exception Codes: 0x0000000000000000, 0x0000000000000000Termination Reason: Namespace SIGNAL, Code 6 Abort trap: 6Terminating Process: FME Workbench [1810]Application Specific Information:abort() calledError Formulating Crash Report:PC register does not match crashing frame (0x0 vs 0x7FF89317AA78)Thread 0 Crashed:: CrBrowserMain Dispatch queue: com.apple.main-thread0 ??? 0x7ff89317aa78 ???1 libsystem_kernel.dylib 0x7ff802e92db6 __pt

471

3 months ago

dxirguContributor

asked in Authoring

Export GML with Date attribut using Dynamic Reader and Writer

Hi everyone,I have a workflow that exports data from Oracle to another formats, like Shp, GML... using dynamic readers and writers. This workflow recive some parameters, like table name, that is used to read de Oracle table and to write the file name. The question is about GML file and date values. When the Oracle table has datetime attribute, FME exports as text, by default. I've achived that FME exports GML with attribute as date type, but this attribute has null value, beacause the format of date is wrong. That is, the exported date value is "19630904000000" but it shoud be "1963-09-04".As I said, I use dynamic readers and writers, beacuse I don't know what table will be exported and I can’t see the table structure, neither, when data goes out by Generic port of Reader. So I can't use StringReplacer and DateTimeConverter, because I would need to know the name of attibute. Anyone has any idea how to modify the format of the date?

985

3 months ago

lifalin2016Contributor

asked in Integration

Where has the FMX file documentation gone to ?

Hi all.Today I needed to build a custom Python based transformer from scratch, after a two year hiatus, and needed to explore some new things in the FMX file part.So as always I opened https://support.safe.com/hc/en-us/p/documentationBut apart from the Format GUI Type documentation, I can only find a new “.fmxj” documentation, but not the proper FMX file ditto. And fmxj looks nothing like FMX, it seems.Why has this crucial piece of documentation been removed ?Can I find it somewhere else ?Cheers

343

3 months ago

arthyContributor

asked in Authoring

How to dynamically read excel sheets?

Hi,I have the values of an attribute which corresponds to the names of sheets of an excel file. In other words, the attribute of interest has the values attrib1, attrib2, ..., attribn that also corresponds to the sheet tab names of another excel file.What I would like to do is to be able to dynamically read the sheet tab names of the excel file based on the values attrib1, attrib2, ... attribn that varies per feature. Those values are unique per feature so I won't need to read the same excel sheet twice.Any ideas?Thanks

1455

3 months ago

nitheshmp422005Participant

asked in Authoring

DEM to Foot print

we are having a DEM of cartosat satellite but we can't convert it to footprint as it only contains terrain data. but a problem statement given by isro in SIH they mentioned to create a LOD1 model using cartosat1 or cartosat2/3 data

180

3 months ago

davorinkObserver

asked in Transformers

Splitting a polygon in half over a donut hole

Hi,I have a polygon with a donut hole, and I would like to split it in half, e.g. across the center of the donut hole. The result should be two polygons, as illustrated below. The polygon isn't necessarily always "horizontal," like in the example below; it could be rotated in any direction.Does anyone know how to do this? Any help would be appreciated! A polygon with a donut holeResulting polygons

886

3 months ago

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!

6896

3 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

624

3 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!

19911

3 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

586

3 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

3 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

3 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

1033

3 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

895

3 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

562

3 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?

602

3 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

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

926

3 months ago

1
...
24
25
26
27
28
29
30
...
1107

Page 27 / 1107

Badge winners

rishavsharmahas earned the badge FME Form Basic Training
emiliodepalmahas earned the badge Student (Grey)
emiliodepalmahas earned the badge Teacher (Grey)
emiliodepalmahas earned the badge Welcome Back
poncetahas earned the badge Student (Bronze)

Show all badges

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