- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,725 Posts
50,912 Replies

When you subscribe we will email you when there is a new topic in this category

12725 Posts

Most replies

Most views

Newest first

scarecrowContributor

asked in Transformers

Error "The table name or field names may be too long or invalid for the server"

Hello,I’m trying to read specific feature classes from an SDE database using a user parameter within a feature reader.I’ve not had a problem with this previously so not sure if it’s a bug (I’m using FME 2023.1.2.0 (20231110 - Build 23641 - WIN64) The issue I’m having is:When selecting feature classes manually in the ‘Feature types to read’ section of the Feature Reader window I can select as many as I want and they’ll all read fine.When using the user parameter (please see settings in screenshot below):Selecting one dataset reads fineSelecting 2 or more feature classes I get the error “Error creating feature dataset 'feature class a feature class b'. The table name or field names may be too long or invalid for the server” Thanks for you time

1183

6 months ago

cosminciotinaContributor

asked in Transformers

Assign first vertex start as different km than 0 for snipper.

Hi.I’m using the snipper transformer to extract portions of a line at specific values from the attribute table.I set these parameters for the transformer. I set these parameters for the transformer.The problem that I noticed is that the program considers the first vertex of the line as 0 and the last one as the maximum, and the snipper will split between these two values.Is there a method to define the start value using another value, not 0? I would like to start from 4.21 km.Thanks.

241

6 months ago

gogopotter90Contributor

asked in Transformers

how to write the new data into different Feature Classes into Esri arcsde ?

Hello ,i would like to create new points and new lines in FME and write the output in Esri arcsde (I have license for that )I have to write the new data in Feature class and and table class and establish a foreign key relationship between the data between the two classes . 1. is there other classes should I write the new data into it ? what should be i edit in workbench and the next steps to show the data in arcmap without any problem ? Arcmap generates obj_id when we add the new point ,will be possible to write obj_id that not used before in arcmap ? does anyone did a simple workspace ,could upload it to understand the idea ? thanks in AdaVance Fme 2021

353

6 months ago

huguesContributor

asked in Transformers

Create a zip from line and polygone shapefile

Hi. I’ve a FGDB how contains polygone and line feature,.I need to create a separate shapefile for all feature of the FGDB.After that, I’ve to create a zip with all the shapefile. Can i do that with FME ? Thank for help

423

6 months ago

tsigParticipant

asked in Transformers

Transformer values

Hello everybody, i want to know if someone know how i can to do to rename a value in an attribut ? which name for the transformer ? thank you !! Bonjour tout le monde, je voulais savoir si quelqu’un savait comment modifier une valeur dans un attribut ? quel transformer dois-je utiliser ? Merci par avance.

505

6 months ago

friedhelm

asked in Transformers

Hi there, today I have a question about the SchemaMapper lookup table. The SchemaMapper filter allows me to define conditional clauses to perform attribute mappings based on specific conditions.

Let's assume we have a feature attribute called "two_digit_number". The attribute can have any integer value from 10 to 99. The condition "not an unlucky number" is met, if the value is not "13". I was wondering if I could represent this condition in a single line of my SchemaMapper's lookup table? Something like two_digit_number != 13. I could probably use a "TesterFilter" to filter out features with unlucky numbers before they enter the SchemaMapper - however, in my project I have dozens of attributes that need to be handled in a similar way. I would have to send all of them through a "TesterFilter". And this is what I would like to avoid. I am excited to learn if there is a simple solution I may have overlooked.

835

6 months ago

rudystricklan1Contributor

asked in Transformers

Geospatial PDF writer DPI resolution

When converting a Cloud Optimized TFF to a Geospatial PDF, the output resolution is very pixelated (see attached file). How can the output Geospatial PDF resolution be specified?GeoPDF Resolution Example

562

6 months ago

hkingsburyCelebrity

asked in Transformers

Bulk Mode in PythonCaller

I see an idea to add/support bulk mode in the PythonCaller has just been updated to "Released" - https://community.safe.com/s/bridea/a0r4Q00000HbriAQAR/support-bulk-mode-in-pythoncaller I'm wondering what the usage of the bulk mode is in the PythonCaller, by design the PythonCaller iterates over each feature individually, therefore going against the idea of bulk mode.

973

6 months ago

dsign-worldContributor

asked in Transformers

How to insert an empty object in JSONTemplater?

I need to create a JSON attribute with a key that only has an empty object as its value as you can see at key1.{ "key1": {}, "key2": { ... } "key3": [ ... ]}Problem is that the JSONTemplater turns empty objects into null. An empty object is valid JSON and is very different from the value null so this behavior is completely incorrect.How can I set an empty object as a value inside a JSON attribute?I tried using the JSONUpdater but it works in the same way. If you set value type to JSON/XQuery it replaces the object with null. If you set the type to plain text, it only creates a string “{}” containing two curly braces.

412

6 months ago

sigbonoContributor

asked in Transformers

Where can I change this 'xlsx_field_names_formatting' parameter in an Excel writer?

I have several Excel writers in a workspace and one throws the warning below. I checked the parameters and they are all the same. Does anyone know where this can be changed? Thanks!Excel Writer: Invalid value '<Unused>' supplied for parameter 'xlsx_field_names_formatting'. Reverting to default value 'yes'

1014

6 months ago

spalkarContributor

asked in Transformers

Unable to update values in ArcSDE Geodatabase

Hi All,I am updating few values in ArcSDE Geodatabase (in flat table) using FME workbench but its giving an below errorerror : Error while retrieving an ArcObjects update cursor for the table/feature class 'gis.xxx'. The error number from ArcObjects is: '-2147220652'. The error message from ArcObjects is: {}Stack : FME workbench 2021.1 , ArcSDE Geodatabase, Flat table ,MS Sql Server Workbench screenshot : Error message : Feature writer properties Till now tried below : Using SQL query its possible to update values in SQL management studio with sde use SDE user has privilege to insert/modify/delete Workbench has proper permissions to run it Using ArcPro Standard licenses If we truncate then its truncate the table Since we are using flat table still use geometry remover to remove additional geometry Flat table has valid primary key Any help/inputs/suggestions would be great !!!thanks in advance !!

721

6 months ago

ninani

asked in Transformers

Delete values

Hi!I have to extract data and write it into excel sheet. I got to the point where I have the information ready but I need to delete missing values and move the features so the table looks different. I add an example.This is what I get:DaysMonthsCity<Missing>March<Missing><Missing>March<Missing><Missing>MarchParisMonday MarchParisWednesday <Missing>ParisSaturday<Missing>Paris<Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing> And this is what I want to write into my writer. DaysMonthsCityMondayMarchParisWednesdayMarchParisSaturdayMarchParis MarchParisMaybe it is easy but I´m still learning... Any help here??Thanks in advance!!

1567

6 months ago

jcvanlingeContributor

asked in Transformers

Vector Tolerance works differently for Matcher and ChangeDetector?

I am working to compare the geometry of two datasets and I am specifically interested in doing so with Vector Tolerance. For some testing purposes I have tried two different transformers to do so, namely the ChangeDetector and the Matcher. I added them in the same workspace with the same input data. For both I only checked the geometry (not the attributes), with the settingsMatch Geometry: 2D Lenient Geometry Matching: No Check Coordinate Systems: No Vector Tolerance: the same user parameter, e.g. set at 0.5 or 0.1. Always the same though.When looking at the documentation the vector tolerance seems to have to work the same for both transformers (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/changedetector.htm & https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/matcher.htm).When running I noticed however that the output was different. I was expecting that my Matcher SingleMatched output port would give the same

1325

6 months ago

sarah.h.aContributor

asked in Transformers

HTTPCaller - API Limit Reached!

Hi all, Yesterday this worked fine, but today its returning ‘{ "success": 0, "errorMessage": "API Limit Reached!" }’ in _reponse_body column? What do I need to do to resolve this issue? Thank you in advance!

342

6 months ago

tcnkContributor

asked in Transformers

Can the TINGenerator be used with geographic coordinate systems?

In ArcGIS Pro a TIN can be created using the “Create TIN” tool. The usage notes of the tool say that it should be avoided to use a geographic coordinate system when creating the TIN, as the Delaunay triangulation might not work correctly when the coordinates are in angular units.The “TINGenerator” transformer in FME does not provide such a usage note in the documentation. Does this mean that the “TINGenerator” transformer can create a TIN without problems when the input dataset is in a geographic coordinate system or is it also recommended here to reproject the input data to a projected coordinate system first?

622

6 months ago

spalkarContributor

asked in Transformers

Provide range to 'distance' parameter in NeighborFinder

Hi All,I am new to the FME Software and have a small question related to NeighborFinder.We have points and contour tables in Arcsde Geodatabase. We are finding points near contour by providing specific distance say 20 in neighborfinder In actual case distance is varies like in some cases nearest contour is at 30 , some contours at 40 etc. How do I tell to neighborfinder that select a point which is near by contour having distance in between 10 to 40 ?. In SQL if we use between operator then we are getting values so similar I want to use this for neighborfinder Below is the screenshot : What I tried so far : Creating Custom parameter On Web found below useful posthttps://www.baooytra.com/knowledge/questions/52143/using-neighbor-finder-with-condition-neighbors-att.html?smartspace=automations-fme-serverAny inputs/suggestion on above would be great !!thanks in advance !!

581

6 months ago

takanakaContributor

asked in Transformers

FeatureMerger turns nulls/missing into asian characters

Hi,Unfortunately i cannot provide the test data due to confidential data. I also cannot encode/dummify the data because then the issue no longer occurs. It is likely related to the large amount of data being processed. What I can include is the image you see here. My question is: how can the following happen? Is this a bug? I merge two flows, both have a lot of attributes. Requestor is 1.9m features. Supplier is 6k features. Supplier has only in ~1% of cases a value for attributes ‘X’ and ‘Y’ - the other 99% is <missing>. But supplier also has a lot of other data and attributes.After merging, for attributes x and y a lot more values are found. They are chinese or japanese characters. They are supposed to be numbers or english words.. Also I think they are getting also values from other attributes entirely, but then the actual value instead of random chinese or japanese characters. How is this happening? I am sure that: the attribute I test is the same (I duplicated the statistic

1296

6 months ago

jackydContributor

asked in Transformers

Customer transformer converting string to integer

I am using customer transformers in a work space, but they are converting a string value to integerThe values are 002 and 003, they need to stay this way for the http calls inside the custom transformer but are getting converted to 2 and 3 (without the 00)As read from dbAfter entry into the custom transformerAny thought on how to prevent this?I would like to have to avoid having do something in each custom transformer to revert the values back to the strings

422

6 months ago

bayramContributor

asked in Transformers

shp to Citygml

Hello,I'm having trouble converting shp file to City Gml, can you please help?

1101

6 months ago

nathan.levelingContributor

asked in Transformers

Removing Null Columns by geometry with dynamic output

Hello, I have an input dataset, that has numerous fields which are Null, and only a handful of fields that are useful. I want to completely remove the attribute fields that are Null, only leaving the useful data. Input is a geo-package, and output is a file geodatabase. I have actually achieved the goal to 90% but have hit a snag, which this post is about. The geopackage has numerous layer I am doing this for, but for this post I will focus on the OBSTRN layer. My current work flow is:Reader (OBSTRN) > NullAttributeMapper (Sets Nulls to Missing) > SchemaScanner (Removes Empty Attributes) > Dynamic Writer The dynamic writer settings: Feature Class/Table Name: fme_feature_typeGeometry: From Schema DefinitionSchema Source: “Schema from Schema Feature”Schema Def Name: fme_feature_type_nameAs mentioned , this output gets me to what I want about 90-95%. The problem is. Within the OBSTRN object class, there exists Points, Lines, and Polygons. I have noticed in other objects that have

775

6 months ago

ncc

asked in Transformers

Dynamically filter unique values? Attribute-based probability sampling?

Hi all, I am relatively new to FME, it would be greatly appreciated if someone can shed some light on a couple of problems I can't seem to figure out. 1. Is there a transformer similar to the attribute filter transformer but would enable me to route unique value to the output port dynamically? I understand that I can using the import value function to bring in the unique attributes values, but sometimes I would only like to only filter a portion (which could be about 50 unique values) of the total number of unique values. Inputting the required attribute value manually is laborious and prone to mistakes. What I would like to achieve is a 2 step dynamic filter of features, each feature has a Local Government Area (LGA), and a Suburb (suburb is a subset of LGA) attribute. Depending of the first LGA filter (ideally a check box list), the second transformer would route filtered features with unique suburb attributes to an output port. Is this possible? 2. I am currently trying

2113

6 months ago

jennychuContributor

asked in Transformers

gml_id and geometry issues in extending citygml 3

Hello everyone,I am a beginner with CityGML and am currently trying to convert a dataset to CityGML 3 with generics extensions using FME Workbench. However, I am encountering a couple of issues:Warning about inheritance relationship: The output gives a warning indicating no inheritance relationship. I have used AttributeMerge to add gml_parent_id, but the system does not seem to recognize it.<GML_2 Writer> - '12482' orphaned features found, XML comments representing these features will be present in the output file: Geometry export issue: It does not export correctly after setting up the geometry. In the Inspector, the data appears as a table without geometry.Additionally, the original dataset complies with the CityGML 3 standard, and its geometry's encoding is Name (encoded: UTF-16LE). Could this encoding be affecting the process?My settings and the transformer export are shown in the attached image.I would g

230

6 months ago

woltersContributor

asked in Transformers

Minimum value per pixel in a multiband raster

Is it possible to get the minimum pixel value, per pixel, in a multiband raster? Rasterstatisticscalculator seem to only do single bands. But what I want is to find the minimum value of a pixel in a raster of 20+ bands. Thank you

744

6 months ago

leroyContributor

asked in Transformers

Define parameters in database which use as JSON query in JSONExtractor

Hi folks,In my situation, I am using JSONExtractor but the JSON queries differ between the testing and production environments. Rather than creating and maintaining two separate FME scripts, I prefer to define the target attributes and JSON queries in a database. This way, the correct configuration is used based on the environment's database.However, the challenge is that multiple rows of configuration records are retrieved (with target attributes and JSON queries as table columns). Is there an example that shows how to convert these database records and assign them to the JSONExtractor in a generic way?Thank you very much!

611

6 months ago

vimva679Supporter

asked in Transformers

HOW to assign RED Colour to CELL in Excel File ?

How to assign RED colour to this cell in final output of EXCEL file. Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file, this is default OUTPUT This is how I WANT

932

6 months ago

Page 19 / 509

Badge winners

emiliodepalmahas earned the badge Welcome Back
poncetahas earned the badge Student (Bronze)
poncetahas earned the badge Student (Grey)
poncetahas earned the badge Teacher (Bronze)
poncetahas earned the badge Teacher (Grey)

Show all badges

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