Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,685 Replies
10000 Posts
aashnaparikh
Contributor
aashnaparikhContributor
asked in Transformers
Feature Writer - Feature Count Limit

Hi,  How can we set the set the limit for max features to write in the feature writer? I have set the limit of 10,000 in max features to read in the feature reader; will that automatically imply to write 10,000 to the feature writer

352
alexbiz
Influencer
muhammadsambe0
Contributor
muhammadsambe0Contributor
asked in Transformers
Calcul de statistique zonale sur raster à partir d’une couche polygone

Bonjour,Je souhaite calculer une statistique zonale afin d’obtenir la moyenne des valeurs de pixels d’un raster, sur une couche polygone (vecteur), comme on a l’habitude de le faire dans un logiciel SIG (voir capture ci-dessous).Merci pour votre aide. 

596
muhammadsambe0
Contributor
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
2024.2 yields an error in SharepointOnlineConnector ?

Hi.I built a workspace in 2024.1, that fetches a number of files from a customer Sharepoint site. It works (in 2024.1) without problems.I just installed 2024.2, and ran the workspace (with no changes).Now it issues an error with a SyntaxWarning from the package “safe.microsoft-sharepoint”:C:\Users\xxx\AppData\Roaming\Safe Software\FME\Packages\24783-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W' return re.sub("\W+", "", string)Is this something that I should worry about ?SharepointOnlineConnector is not listed as an upgradable transformer in 2024.2Cheers.

21820
lifalin2016
Supporter
esmgron
Observer
esmgron
asked in Transformers
Locating a duplicate column

SOLVED - I found the error Hello!I've been working on a script that has 56 columns (client needs all the fields of information), and now I need to write it using an Esri File Geodatabase writer. I have double- and triplechecked whether there is an invalid character (since gdbs are quite strict with field names) or a duplicate of one of the fields, but I cannot find it. Is there a tool in FME that let's you identify a duplicate of a whole column in the attribute table? Or a duplicate field name? Or does anyone know if there is another common solution to this error?This is the error code:ERROR |An error occurred while attempting to create the feature class 'Test'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Test]} I am using FME form 2024.1.Thank you in advance!

512
esmgron
Observer
max_h
Supporter
max_hSupporter
asked in Transformers
Datetime DD-MM-YYYY in userparameter

Hello!Is there a way to change the displayed date in a datetime userparameter as DD-MM-YYYY?The chooser interface is helpful to check if it is the right date, but it can still be quite confusing, especially in Flow, when not every user knows about the picker and just enters the date. Is there an option I am missing or is a text-field instead my only alternative? Many thanks in advance!

632
max_h
Supporter
djmcdermott
Contributor
djmcdermottContributor
asked in Transformers
Does FME use round-to-even or half-round-up?

Hello FME’ers,I am currently comparing FME and PostgreSQL/PostGIS when transforming some line geometry. In each scenario I need to round the coordinates to 3 decimal places. This has thrown up a anomaly when rounding coordinates ending .4999. For example, the coordinate 104269.57149999999 will be rounded to 104269.571 by ST_ReducePrecision but 104269.572 by the FME CoordinateRounder. I believe this is due to different rounding techniques like round-to-even or half-round-up. Can anyone explain this behaviour? Is there any “right” answer?Thank you,David  

455
djmcdermott
Contributor
aaron
Contributor
aaronContributor
asked in Transformers
How to expand Query String Parameters dialog in HTTPCaller?

I’m stringing together a bunch of HTTPCallers, each of which has several query string parameters. From what I can see, you are only able to see two parameters at a time in an HTTPCaller transformer (see screenshot). Is there a way to enlarge/expand the dialog box so I can see all or most of them at once? Should be easy; I feel like I’m missing something. It would be so much easier, helpful, and efficient so see all query string parameters at a glance. (FME Desktop 2023.2.0.0, Build 20231201).

514
salvaleonrp
Enthusiast
stezi
Contributor
steziContributor
asked in Transformers
Adding attachments with ArcGISAttachmentConnector 3.9.5 not working with ArcGIS Enterprise

Hello,I want to report a bug related to adding attachments to a feature in an ArcGIS Enterprise Feature Service using the ArcGISAttachmentConnector in the latest version.I receive the following error:(C:\Users\x\AppData\Roaming\Safe Software\FME\Packages\25606-win64\python\safe.esri-agol\fmepy_esri_agol\attachments\handler.py:104) add_attachment    return AttachmentResult.from_dict(response.get("addAttachmentResult", {}))                                      ^^^^^^^^^^^^910523  Python Exception <AttributeError>: 'generator' object has no attribute 'get'The problem is that the ArcGIS REST API addAttachment endpoint returns text/html instead of json. This appears to happen specifically for Enterprise Feature Services, as described here. As a result, the result cannot be decoded. However, the attachment is actually uploaded successfully.Bug fix:Change the line 43 fromfiles = {"attachment": (filename, file_obj, mime_type))}tofiles = {"attachment": (filename, file_obj, mime_type), "f"

241
crystalatsafe
Safer
makt
Contributor
maktContributor
asked in Transformers
How to change NaN to NoData?

I have a workflow where I am creating a raster using SurfaceModeler. As documented, this transformer may output some NaN values when using PLANAR interpolation. I indeed have a few cells that come out with a NaN value.  I am not certain what transformer can change my NaN values to NoData values (or any other values)?  I read through this article: http://blog.safe.com/2013/11/fmeevangelist119/ and thought the NullAttributeMapper would be the answer, but it does not seem so.  

25119
virtualcitymatt
Celebrity
messagemauri
Contributor
messagemauriContributor
asked in Transformers
Reading a Feature Service URL in FME Desktop 2025.1

Upgraded from FME Desktop 2022.2 to FME Desktop 2025.1 (Build 25609)In FME 2022.2, I had a FeatureReader reading to a FeatureService URL with no issues. Perfectly was able to read it and extract its spatial content and attributes. Upgraded to FME Desktop 2025.1 and it no longer works. Could this be like an internal firewall blocking access to this or is it the way FME 2025 handles SSL certificates? If so, how can I remedy this?Any insight is much appreciated.SAMPLE WorkbenchI have the latest package installed Error message: ArcGIS Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services.arcgis.com', port=443): Max retries exceeded with url: /mMUesHYPkXjaFGfS/arcgis/rest/services/ROLL_ENTRY/FeatureServer?f=json (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Basic Constraints of CA c

373
messagemauri
Contributor
paulmacintyre
Contributor
paulmacintyreContributor
asked in Transformers
FME Flow 2023.1 - Issues with SQL Transformers and Deployment Parameters/Database Connections

Morning All,  Has anyone else identified an issue with all SQL transformers when specifying the connection via either deployment parameter or database connection? When run on Form it operates correctly but when run via Flow (either scheduled or manually submitted) the following error is returned:  Error occurred while opening database reader with server type `MSSQL_ADO', server name `XXXXX', user name `', database name = `' : `Encryption Error: AES Decrypt finalization failed.' If the database connection is embedded into the transformers Flow is able to operate these transformers correctly, however this would then require each transformer to be reconfigured as we migrate between environments.  Thanks in advance, Paul.

5072
robd
Contributor
navid.fotovaty
Contributor
navid.fotovatyContributor
asked in Transformers
Attribute comparison

Hey everyone, I hope I am just missing a very obvious point here. I am trying to compare two SQL input data sourcesOne with these columnsAnd the other with these columns The customer and account number combination is going to be my primary key. I need to extract the email addresses of customers based on that combination. I have tried the feature merger which seemed to be the obvious solution, but I am not getting any matches?Any idea where I am going wrong? 

775
takashi
Celebrity
bubblebeb
Contributor
bubblebebContributor
asked in Transformers
FeatureReader not accepting point data

I have found that the feature reader will not accept point data as the initiator. I have since found that in Version 15 a change was made: -Spatial operations will reject initiator features with point geometries to match native reader behaviour.Does anyone know why this was changed and if there is a way to force it to accept points without having to create a very small buffer to it and then recreate the point after the feature reader. 

491
desiree_at_safe
Safer
nstem
Participant
nstemParticipant
asked in Transformers
Assistance needed converting Lines to Polygons Using AreaBuilder

Good afternoon, I am extremely new to FME so apologies in advance if my question comes across as exceedingly simple or unnecessary. Anyways, I am attempting to convert a set of line features that originated in AutoCAD into a GIS formatted polygon layer. To start, I cleaned the layer as best as I could and performed snapping within QGIS. I then have tried using AreaBuilder in combination with other transformers such as LineCloser to obtain a set of polygons, but the output so far has been less than ideal. I have also experimented with Snapper and some other transformers such as LineExtender but those have introduced new errors that then lead to no output from AreaBuilder. Below I have attached an image of my workspace currently, as well as an image of the current output I am receiving. I will also attach a sample of the dataset I am working from! My conclusions are that LineCloser is causing the issue which leads to these slivers and polygons outside of the scope of the data, however I

665
takashi
Celebrity
carlm
Contributor
carlmContributor
asked in Transformers
DocumentPDFStyler: URL in a table

Hi,I’m trying to put an URL in a table using the new DocumentPDFStyler and I can’t make it work.One of my issue is that the URL breaks because it doesn’t fit in the table box, also it doesn’t show up as an url. I tested many things to make it work: Image Link, add the pdf_url attribute (doesn’t work because this is the documentpdf writer),  put quotes around it.I’m trying to make this work without having to use the wkhtmltopdf 😅

444
saraatsafe
Safer
ecx
Supporter
ecxSupporter
asked in Transformers
DateTimeConverter issue, formatting correct, but wont transform

Hello, Please see picture above, DateTimeNow is my value i am feeding into DateTime attribute, which matches the preview data format, but the output keeps getting rejected saying the errors above. I’m a bit stumped to as why this is not working. Any ideas?Thanks.

16810
datablue
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
RasterExpressionEvaluator Expression to select raster GRAY8 values

Hi All,I often encounter difficulties when attempting to select specific raster values using FME. I am currently working with a raster dataset that contains two bands, and I need to isolate the following values:Band 0 (GRAY8) = 3 Band 0 (GRAY8) = 4Could you please advise on the appropriate expression to use within the RasterExpressionEvaluator to achieve this selection?Thanks :)

172
galigis
Enthusiast
romainguinot
Participant
romainguinotParticipant
asked in Transformers
Position measure on a linear

Hello, I think my question has been asked before but I can't find anything on Google.Input Data : One table wothout geometry with : Id Id route measure One table with linestring geometry and :  Id Id route (the same) geometry I want to position my point data with the measure field along the line and generate a new Point Geometry

321
nielsgerrits
VIP
pdorio
Contributor
pdorioContributor
asked in Transformers
FeatureReader & clip search envelope on raster dataset

The feature reader does not allow you to make a clip on the initiator geometry. I need to read a fairly large raster (13GB). Input I get some small zone geometries to analyze. The idea was to create a BBOX on the geometry and use the feature "Spatial filter: intersects or bbox intersects" to load only the part of the raster needed for the analysis. Even configuring intersects or bbox on the feature reader, in output there is always and anyway all the raster. This problem is great because it slows me down considerably the server side script. If you add a raster reader instead you can check the "Clip on search envelope" flag and it works. But without FeatureReader i can't give my search envelope by the initiator. Could this be a missing-feature?Does anyone have a workaround? I use the FME Desktop version 2019.1

20610
ebygomm
Influencer
omerseyfettin
Contributor
omerseyfettinContributor
asked in Transformers
During Using FeatureTypeFilter Update the _relationship attribute lost.

When a database is updated using SpatialRelator, FeatureTypeFilter, and DatabaseUpdater Transformers from feature classes inherited from two different readers, the _relationship attribute disappears when the FeatureTypeFilter Update button is used. All DatabaseUpdater transformers are in the "incomplete transformer" status. When examining the DatabaseUpdater transformers, the _relationship values are red. Copying and pasting the same value fixes this. To avoid this issue, you must manually edit the FeatureTypeFilter, which is time-consuming.  

1303
desiree_at_safe
Safer
koenvdw
Contributor
koenvdwContributor
asked in Transformers
FME basename and rasterdemgenerator

I’m using the rasterdemgenerator and I can’t get the fme_basename passed it.   I have some lidar tiles and I want to make a DTM from them. I can do everything, but I cant get the DTM named like the input las file. It has either no name or it has the name of the transformer.  There is an old forum post where Takashi tell’s someone to expose the FME_feauture_type, fill it with the FME_basename, use a group by (using the FME_feauture_type) in the rasterdemgenerator and than use it as the raster file name.  It doesn’t work for me… Any other suggestions? I’m on FME 2025.0   

5811
geomancer
Evangelist
kristen
Contributor
kristenContributor
asked in Transformers
Merging Multi-Part Annotations into Onne

Hello Safers, I have a CAD file that has annotations inserted within it that should be one annotation but, for whatever reason, they were created as separate annotations: Above is an example of what I am struggling with. The text should simply read 10.88, but FME reads it as 1, and 0, decimal , 8, 8, and 0. What I would like to do is treat this as one annotation, and be able to round or eliminate extra numbers where needed (i.e. I only need two decimal precision, not three). Please note I already figured out the precision and rounding….I just need help with these multi-part annotations.How would I go about doing this in FME?Thanks!

312
pratap
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Filtering Date based on @DateTimeNow()

Hi All,I have tried to implement several suggestions from the community regarding date filtering; however, I have not been successful so far. I am trying to filter dates in a CSV file based on the "last login" within the past three months. The date format in the file is as follows:18/07/2025 09:16 08/07/2025 12:46 01/02/2024 10:07 16/01/2025 10:33I have converted those dates to %Y%m%d resulting ‘20230403’ then add an AttributeManager to change the ‘last_loging’ attribute to ‘date’ and finally used the following expression to filter the "last login" within the past three months:@Evaluate(@DateTimeFormat(@DateTimeSubtract(@DateTimeNow(), '3', 'months'), '%Y%m%d'))...but for some reason doesn’t work,Any guidance or support would be greatly appreciated.

251
galigis
Enthusiast
thijsknapen
Contributor
thijsknapenContributor
asked in Transformers
Parameters created in Custom Transformer can't be assigned an attribute value outside of the CT, also when 'Disable Attribute Assignment' is off.

When I create a Custom Transformer in FME, and (manually) create parameters within that custom transformer, it seems that I can't assign an attribute value for these parameters from outside of the custom transformer. So for example, I created 3 distinct parameters (text, number and (single) choide) inside of a custom transformer, all of them with the setting 'Disable Attribute Assignment' unchecked.then outside of the custom transformer I don't get an option to provide an attribute value for each of these parameters;Interestingly, if I expose attributes at the input port of the custom transformer, like so; then a text parameter is automatically created (in this case 'ATTR1'), whose value can be set outside of the custom transformer:It seems like a bit of a bug to me. I'm using FME 2021.2.2.0 (b21806 - win64). I found some ways to work around this, like in case of the text parameter, you can open the Text Editor window, and manually type @Value(attr1) (also i

24610
crystalatsafe
Safer
bill7875
Contributor
bill7875Contributor
asked in Transformers
Read Settings from Delimited Text File

I’m trying to read a text file with settings in it then, use the settings in the WS. The settings are formatted on lines like name = value. There are lines with other stuff on them like comments that I just want to ignore. The WS that I have seems to work up to the AttributeSplitter. I think it splits right because it shows 30 features created but it doesn’t fully fill the list{}. I think the list{} should have 60 items but it only has 2. The AttributeCreator just creates one attribute for the list{2}. I’m a bit confused how this should be configured. Also, if there is a better way of doing this (reading settings) then, please let me know. I have attached my WS (zipped) and my txt settings file.AttributeCreator: only one attribute gets created ‘APP_EXIT’. AttributeCreator 

353
panda
Enthusiast

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,397
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.