- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27564 Posts

Recently active

Most replies Most views Newest first

1seanContributor

asked in Data

How to Convert the Last Character to Lowercase if it's an Uppercase Letter in FME?

Hello everyone,I'm looking for a way to check if the ending character of a string attribute is an uppercase letter, and if so, convert it to lowercase. For example:Foo1K → Foo1k BAR4 → BAR4 BAZ → BAzWhat's the best way to accomplish this in FME? Are there any specific transformers or approaches that I should use to achieve this result?

p15rajanContributor

Hello there, How can I read a tsv file in FME? Do we need to use csv format only:? Thanks,Siva

352

2 months ago

chaoluoContributor

asked in Transformers

How to remove the repeated words in FME

Hi All,Anyone could help me with this specific question in FME? I want to remove the repeated words in each row, e.g. A,B,C,A,B in a row, the A, B have been repeated twice, I would like to remove the repeated A and B only. please see attached the sample data. many thanks.

935

2 months ago

bradnewersContributor

asked in Transformers

ChangeDetector give different result on FME Workbench 2023.1 and FME Flow 2023.1.1.1

I have created a workbench to detect schema different.I am using two ChangeDector Transformer in this workbench which is producing output as I intend. Figure below shows that part.Workbench for that part This is output data (in csv file) based on that workbench.Output by FME Workbench 2023.1 (FME Form 2023.1)However, when I used the same workbench with the same data, the following output were produced. It got extra error. For error code E302, those not bold should not be there.Output by FME Flow 2023.1.1.1The workbench used is the same.The data is the same.Only output 1 run in FME Workbench 2023.1 (FME Form 2023.1) and output 2 Run on FME Flow 2023.1.1.1 and FME Flow 2023.2.Note: The additional error contain field that is unchanged in first ChangeDetector and does not included in the second ChangeDetector (ChangeDetector3)

362

2 months ago

doug_herrickContributor

asked in Data

FME can't read SpeedZones shapefile

I have a shapefile that can’t be read by FME Workbench 2024.1.1 or 2022.2.3. The copied log is attached.The “Speed Zones” shapefile comes from https://opendata.transport.nsw.gov.au/dataset/speed-zones where you have to login and download the "Speed Zones data" as a ZIP file. Once unzipped you get the standard 4 files.When I load the shapefile into QGIS, it shows the following properties: 434MB MultiLineString 442,943 features EPSG:3308 - GDA94 / NSW Lambert Fields: Type Text (string) 200 length Status Text (string) 200 length Direction Text (string) 200 length Speed Text (string) 200 lengthThe only issue I can see is that there is no unique identifier field but I didn’t think that was an issue for FME. Any suggestions on how to read this file into FME?ThanksDoug

647

2 months ago

mr_fmeEnthusiast

asked in Data

Standard Deviation calculations

Hi,I have an NDVI raster and need to clip it with many polygons. After that, I need to calculate the standard deviation for each piece of the raster (clipped by the polygons), and in the end, I need to correctly assign the deviation value to the attributes of the corresponding polygon. Thank´s

311

2 months ago

totobobiasos

asked in Transformers

httpcaller to geoserver for getcapabilities to xml

I'm trying to build a service catalogue of our municipality's services (WMS and WFS) for easy search and access. I have successfully used xml readers and httpcaller along with xml flatteners to extract the information into a queryable json table and presenting it with datatables (https://datatables.net/ ). Very handy and fast. But now I've run into some trouble that I can't really understand or work around. Getting the info from well over 600 services has been easy but the last one I added does not work. See attatched workspace. "TK OPEN" works just fine. "Miljö" does not. It seems to be related to XML and HTTPS, but that really isn't my strongest field. getcapabilities.fmwAm I doing something wrong? Is there, perhaps, a simpler or other way to do this?

733

2 months ago

bruceharoldContributor

asked in Authoring

Should XMLFragmenter remove geometry?

Hi, I’m finding XMLFragmenter removes geometry, is this expected?Data Interoperability in Pro 3.3, so FME 2024.0.1.0 build 24202.Thanks.

755

2 months ago

arepsherbentearContributor

asked in Transformers

GeoJSON Reader - Cannot Add Additional Attributes

Hello Friends!My current setup: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64) ...from ArcGIS Pro Data Interoperability Extension I am attempting to use the GeoJSON Reader to capture information from api.weather.gov/alerts/active (Weather.gov API). I am not having any problems getting data. The problem I am having is populating all of the available fields within the API - in case I ever do get them from the API. The first time I connected to the URL from the Reader, I got most of the attributes, missing maybe 10 fields. Adding another GeoJSON Reader and connecting to the URL an hour later, I get a different set of attributes. I do understand that the data is changing and their API is not delivering any unnecessary nested attributes.When opening the Reader’s Properties and then User Attributes - there is no way to add attributes. Am I missing something? Is there another way to add attributes?Thank you,--Adam

bmwhbmwhContributor

Hello, anyone knows how to split a DWG into tiles? i can make it happen with tiler however i cannot split it or simply chhose the tile i want to export

221

2 months ago

fmesafe.podporaContributor

asked in Transformers

JSON formating

Hey. I'll try again and better. On the attached fmwt I am trying to assemble the correct geoJson structure - the data structure formatting is done on the "JsonTemplater5" transformer. The sample file for the data structure is the attachment "example_collection"( better to look here: https://github.com/UASGeoZones/ED-318/blob/main/examples/Example_Collection.json?short_path=e3f0eef), according to which I am creating a template (JsonTemplater5). The output from the workspac is "rmz.json" - the whole data structure is not created on jsonTemplater5, so it does not match the complete sample file.My question is. Does it really have to be this complicated and lengthy to define a template on jsonTemplater5 to send data to? Wouldn't it be possible to export the schema using a combination of some transformers from example_collection ( sample data )? Or if I have some schema available, can't I use this schema so that I don't have to create a template in such a complicated way? attachments: rmz_te

975

2 months ago

leanne_michaelContributor

asked in Transformers

Running a workspace via Task Scheduler

Hi All!I’m new to FME and have (hopefully) a simple question. I have created a workspace that reprojects data from one projection to another in ESRI Geodatabase (sde). I have embedded the connection parameters. The workspace successfully runs. I have created a batch file, using the command prompt information from the result of the translation log. The batch file successfully runs when executed manually. When I schedule via Task Scheduler, its fails (0x1). Return code 2147942401The user account that runs the task is my own username. On local PC. Runs with highest privileges set. Under Action, it points to the location of the batch file. What am I missing?Thanks,Leanne

1157

2 months ago

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!

56117

2 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

2 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

784

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

1715

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

303

2 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

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

905

2 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

2 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

1285

2 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

2 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

846

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

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

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

Page 21 / 1103

Badge winners

hkingsburyhas earned the badge I Savour Raster
paul.taylorhas earned the badge Welcome Back
carstenhpthas earned the badge Teacher (Grey)
offi24has earned the badge Welcome Back
jakes3has earned the badge Teacher (Grey)

Show all badges

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