Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,721 Replies
10000 Posts
nepalikiwi
Contributor
nepalikiwiContributor
asked in Transformers
Error trying to connect ESRI mapservice with "Esri ArcGIS Feature Service" Reader.

Hi, When i try to connect open service: https://gis4.waimatedc.govt.nz/arcgis/rest/services/Public/RoadClosure_Waimate_Active_Planned/MapServer using "Esri ArcGIS Feature Service" reader, I get Python exception error. There is no authentication required as its open service. The fact that I can use HTTPCaller and get the data with query service tells me, this service doesnt require authentication. Am I missing something? I tried few other rest service from this council with no luck. Python Exception <HTTPError>: 403 Client Error: Forbidden for url: does this error means anything to do their IT system infrastructure? Any help would be appreciated? Cheers,

650
hkingsbury
Celebrity
S
samanah.s
asked in Transformers
Problem with creating fmetemp file

I want to read a Geopackage file, but when I run the FeatureReader transformer, it creates a new geopackage file with the name of "file name"_0.gpkg so as cannot be located. I cleared several times my temp folder with ClearTemp.cmd, also Purge temporary files in my FME-script. But still I have problem with temp-file! Can you guide me how can I fix the problem? Thanks I can read my file via Reader and there is not any problem, but when I read it via FeatureReader, I have problem with temp file!

90
hkingsbury
Celebrity
H
haroe
asked in Transformers
Anyone know if there is a way to only expose the selected features from ArcGIS Pro to the FME ArcGIS Portal Feature Service when using the interoperability extension?

I am in the process of creating an FME script to download photos as attachments features in ArcGIS Portal using the FME ArcGIS Portal Feature Service.The script runs fine from the ArcGIS Pro application using the interoperability extension.The only problem is that images from all the features is downloaded, even if only some is selected in ArcGIS Pro.

100
kailinatsafe
Safer
mehdibokaei
Participant
mehdibokaeiParticipant
asked in Transformers
Hello I am a GIS analyst and I want to learn FME for the first time. I checked different parts of the website but still don't know completely how to start to learn here!

Hello I am a GIS analyst and I want to learn FME for the first time. I checked different parts of the website but still don't know completely how to start to learn here!

540
mehdibokaei
Participant
paul_c_2
Contributor
paul_c_2Contributor
asked in Transformers
Dates in charts

I have yet to successfully use dates as an axis in ChartGenerator. Ideally, I would like to be able to use more natural date formats e.g. %B %Y or %m %Y and set the scale accordingly based upon time increments. Is this possible (in Chart Generator or another transformer) ? Or am I going to need to take it out into PowerBI, Excel, etc?

330
paul_c_2
Contributor
M
melissahuntbach
asked in Transformers
Trying to apply a max number + row number into a new attribute field.

I have a dataset from a spreadsheet that i have created a counter for each row successfully. The SQL table i am importing this dataset into has a primary key (highlighted). This primary key is not recorded anywhere in the database as a sequence number. I have added in a statisticsCaculator transformer to obtain the max number.  I want to insert each row from my dataset (first screenshot) but i want to insert the LUPID as count + LUPID.max. so i end up with 1691+1 = 1692, 1691+2 = 1693, 1691+3 = 1694 etc for each row what transformer would i use to do this?  

552
F
ronnie.utter
Contributor
ronnie.utterContributor
asked in Transformers
Get Autocad Layer attributes from empty layers *Solved

Solved with LISP (.lsp) and csv export. Read my last post I working on a script that need to test some parameters in a hundres of dwg files.Just to make it short. Autocad_layer_frozen and Autocad_layer_description are two attribute that I need to check and what I use in this example. However, the only way I have succeeded so far to get empty layers visible is to use a dwg reader and choose individual file types. B No data of course. Nothing is read since the layer is empty.  Both DWG reader and feature reader can only read layers that are not empty. Feature reader and with format "Any schema" can read all layers, also empty layers, but does not contain the native autocad attributes like Autocad_layer_frozen and Autocad_layer_description. Is there any way to read empty layers to get all the attributes that exist in a autocad layer feature with only use of FME?

1080
nielsgerrits
VIP
timboberoosky
Contributor
timboberooskyContributor
asked in Transformers
Python Caller Repair Geometry

I'm wondering how to use the Python Caller transformer to run the arcpy.RepairGeometry_management geoprocessing tool. I'm working with some input File Geodatabase data that's getting re-projected and producing self-intersections. The Geometry Validator transformer is identifying these but not repairing them (i.e. they come out the Failed port, not the Repaired port). I confirmed that using ArcGIS Geoprocessing tools on the same machine fixes the self-intersections, so I wanted to use the Python Caller to do the exact same thing in the context of the FME Workspace. What I'm getting is a generic error though, see below. Maybe my syntax is incorrect but I've tried a few different ways and haven't had success. Any help would be appreciated! Python Syntax:import fmeimport fmeobjectsimport arcpy # Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameter

3260
timboberoosky
Contributor
apaul
Participant
apaulParticipant
asked in Transformers
Extracting maximum value from a multi band raster

I have a query relating to raster analysis in FME Form using the RasterExpressionEvaluator I want to extract the maximum value of each pixel from a multiband raster, so for example if band 3 has the maximum value compared to bands 1 and 2 for a particular cell, only the value for band 3 for that pixel will be extracted and used in the resulting single band raster.  The syntax I believe should work for this is as follows in the attached image but I cannot get it to work. The "maximum/max" functions are unavailable in the transformer and I am thinking that this logic not be usable on data of this type or within this transformer.  Can anyone confirm if maximum syntax is workable on this transformer or even have another method of how to go about this? Thanks Andrew

1111
takashi
Celebrity
J
j_pczx
asked in Transformers
Manipulate IFC property sets

Hi, I'm recently working on a workflow that creates a customs IFC property set and pushes it back to an IFC file. I have gone through all the materials I can find online but still encountered a problem.  The GeometryPropertySetter successfully outputs the traits I intend to set (see column 1&2 in the attached image) but for some reason they can not be written in the IFC file. I can supply more info if required.  Does anyone know what is causing this? Thanks a lot.

530
kailinatsafe
Safer
francescodb
francescodb
asked in Transformers
GDB Alias with dynamic schema?

Hi, I have a workspace that write to SDE using a dynamic schema. The schema is build from an excel sheet where I have the name of the field, the type and the alias. I manage to write to SDE with all the correct parameter: attribute{0}nameattribute{0}.fme_data_typeattribute{0}.native_data_type The problem is that I cannot find a way to write alias. Anyone know if this is possible within a dynamic schema?  thank you!

1240
adnanyazdani
Contributor
M
michaeljb
asked in Transformers
SQLExecutor with Exec - how to use the return value?

Given a call to a stored procedure like this:declare @return_value intexec @return_value = dbo.myProcedureHow do I re-assign @return_value to e.g. an attribute or a variable?

3480
aphilipp
Contributor
M
michaelz
asked in Transformers
Is there a way to store attribute references in text that is stored in another attribute

Got a situation where I would like the store attribute values, @Value(attribute_name), in some HTML code which itself is stored in a SQL table. The idea is that the @Value(attribute_name) will be different for each of our clients, sending them a personalised email based on their own data. Currently FME reads the table in and keeps everything as plain text, @Value(attribute_name) does not get replaced with the appropiate attribute value. Is there a way to get FME to recognise the attribute names in the HTML code and replace it with the appropiate attribute values? if I copy and paste the HTML code into atttributecreator then it works as expected, however we would like to manage all this in SQL server - saving us having to update the workbench everytime there is a change required to the HTML Thanks

475
M
simonlr
Contributor
simonlrContributor
asked in Transformers
Help fixing a missing number in an attribute in pointclouds

Hi, i have a problem where most of a large number of point clouds are missing the first number of the gps_time attribute, so "367091181.0231084" should be "1367091181.0231084". It is always a 1 that is missing at the start.What would be the best way to go about changing this attribute for every point in every pointcloud?The context for this is that the point clouds are data from lidar mobile mapping and need to be matched using the gps_time with trajectories in another software.Any help would be much appreciated.

140
simonlr
Contributor
sameer
Contributor
sameerContributor
asked in Transformers
Feature Caching icons (Run from / to this) do not appear above the transformers when creating a custom transformer

FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) Hello As stated in the subject line, the Feature Caching icons can be seen in the "Main" tab but not showing in the "Custom Transformer" Tab at all. However the features are cached. So I think they are just missing.   ThanksSameer

370
sameer
Contributor
S
sophieko
asked in Transformers
How to prioritize a layer using the AreaOAreaOverlayer

Hello, I would like to prioritize a layer using the AreaOnAreaOverlayer transformer, is it possible ?Thanks

70
dustin
Influencer
mzuer
Contributor
mzuerContributor
asked in Transformers
Crashing workspace when using PythonCaller

Dear All, I am experencing the following problem on FME (FME Desktop 2022.1.0.0 - Build 22618 - WIN64)  : when I work with PythonCaller, my workspaces randomly crash. For example, starting from empty workspace, I add a Creator followed by a PythonCaller ; run to the PythonCaller -> it works fine ; I add "import arcpy" in the PythonCaller and run -> it works ; I add "print("hello")" in any function of the FeatureProcessor class -> it crashes. Also, the crashes happen in an unpredictable way : sometimes, it crashes after having inserted "import arcpy" ; sometimes I can add 2-3 five more lines in the function of the FeatureProcessor and it works and then after 1 more line it crashes. By crashing, I mean the following : after clicking "run", the mouse cursor takes the form of a blue waiting circle during a few seconds and the window suddenly closes -> when it crashes, it seems that the translation never really starts (nothing ha

660
verdoodtdries
Supporter
S
sophieko
asked in Transformers
The AreaAmalgamator has been running for 10 hours and still does not work

Hi, I want to amalgamate polygons from a map of natural environments to distribute it on a larger scale (1:5000 to 1:25000). For this I used the AreaAmalgamator tool with the settings that can be seen in the photo. I have 12193 objet in total. However, the software has been running for 10 hours and nothing is happening. Has anyone ever had this situation? 

260
S
J
jessica_webster
asked in Transformers
Re the aggregator transformer: I have an energy model of a housing stock of a city. We're using the aggregator to add all the dwelling units up to whole buildings by the Building ID attribute, but the buildings and energy are added up incompletly.

For instance, one 58 unit apartment results in 17 rows with variously 1-24 units added together. We can't explain why this is happening but need to fix it. Have also tried adding a dupliate filter and another aggregator but this didn't work. Any suggestions are appreciated.

00
ctredinnick
Supporter
benadei
Contributor
benadeiContributor
asked in Transformers
I am writing some tabular data to a text file using the CSV writer. How do I get my attribute names or column headings to align with my attribute values in a right justified manner or padding left?

 I have used @PadLeft(@Format(%.3f,@Value(FLOW)), 8) in an earlier attribute manager in the workspace to format the values to three decimal places and pad left. My output data and workspace are as shown below:

492
benadei
Contributor
matthewb
Contributor
matthewbContributor
asked in Transformers
How do I transfer measure values from points to lines?

I have polyline data representing roads and point data representing mile markers. The points are on the line, so PointOnLineOverlayer does segment the line as expected. The point data has a Measure value that I want to use on the line, how do I set the measure value of the points to the lines?

500
matthewb
Contributor
jalary
Contributor
jalaryContributor
asked in Transformers
Anybody have solution to connect to an LDAP/Active directory server after Deprecation of the reader in FME 2023?

Now that LDAP/Active Directory reader have been put on the deprecation list in FME 2023, I'm trying to find an out of the box solution in FME to update my workbenches and continue using it.  

5452
jalary
Contributor
so_much_more
Supporter
so_much_moreSupporter
asked in Transformers
Getting User parameters with python is formatting input values weird

I am writing a shutdown script to logg a workbench result to a postgres database.To log the output location of a gpkg file I am fetching a public parameter like so fme.macroValues['dest_path']But i get some weird formatting where backslash etc ar written as verbose text instead of the actual path? How can I get the actual path? C:<backslash>Users<backslash>User<backslash>Documents<backslash>FME_proj<backslash>20230913_FME<backslash>WIP<solidus>output<backslash>myoutput.gpkg 

383
david_r
Celebrity
rzrnc
Participant
rzrncParticipant
asked in Transformers
Hi; I have a question related to the Attribute Manager transformer, "Substitute Missing, Null and Empty by" option.

My input attributes have numeric or string values, with possible empty string values.I would like to replace empty string values with Null. When I use the option "Substitute Missing, Null and Empty by: Default Value", and set "Default Value: <null>", nothing happens. The values remain unchanged (with empty string values). I can get the desired result with the help of "Action:Set Value" and Value: Conditional Value -> If ATTRIBUTE IS EMPTY -> Value <null>". I know I can use the Null Attribute Mapper transformer, and the Set Conditional Value method above, but using the"Substitute Missing, Null and Empty by: Default Value" option seems the most elegant to me. Have I misunderstood the purpose of "Substitute Missing, Null and Empty by: Default Value" or am I using it the wrong way?

1730
rzrnc
Participant
chris_rmw
Contributor
chris_rmwContributor
asked in Transformers
Attribute Validator "In" List Validation

I am using the attribute validator to test a list of pavement marking line marking types coming from a AutoDesk SDF. The validator is throwing false errors when I use the "In" ValidationThe list of values in the rule configuration are: Broken 1-1,Broken 1-8,Broken 3-3,Broken 3-6,Broken 3-9,Double Solid,Simultaneous Solid/Brkn-1,Simultaneous Solid/Brkn-2,SolidEverytime I run my workbench Broken 3-3 is reported as an error even though I've verified that the spelling is correct.I've also tried subbing out the commas with double quotes and it doesn't seem to work either. 

484
no_id
Contributor

Badge Winners

Show all badges

Community Stats

31,820
Posts
120,854
Replies
39,451
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.