Skip to main content

Transformers

Using transformers to modify data.

  • 12,965 Posts
  • 51,737 Replies
10000 Posts
justinweaver
Contributor
justinweaverContributor
asked in Transformers
Is there a way to see the HTTPCALLER Post without it sending?

Im wanting to see the http it’s generating so i can understand where its going wrong. Is there a way to see this - without it being submitted? Or even if it’s being submitted? Im sure im missing something. JKW

313
nielsgerrits
VIP
lance
Contributor
lanceContributor
asked in Transformers
Excel Reader - Incorrect String Length

I am using FME Form 2024.0 to read an excel file for processing. The reader is not determining the correct max length of multiple text fields in the XLSX file. I have set the max rows to scan to a value larger than the total row but short of manually setting these values I cannot get the reader to detect the correct field length. The FME Help for the MS Excel Reader states to leave this setting blank to scan all rows but the transformer will not except a blank value. I also tried to use the FeatureReader rather than a standard Excel Reader with the same results. I want this to be dynamic as the data being read is variable. Any suggestions or workarounds?

672
justinweaver
Contributor
ohashkii
Contributor
ohashkiiContributor
asked in Transformers
GDB feature class reader as published parameter

Hi, How can create a published reader parameter for gdb feature classes? The gdb conation Point, line Polygon feature

263
crutledge
Enthusiast
lifalin2016
Contributor
lifalin2016Contributor
asked in Transformers
Using HttpCaller with custom SSL client certificate - doesn't work !?

Apparently this feature was finally introduced 5 months ago, yay. I’ve been waiting for this for 5 years. I’ve just tested it today, with a PKCS#12 certificate, and unfortunately it doesn’t work. We’ve sofar been using our own C# service provider for this, and the certificate is used here on a daily basis with success. And I’ve verified the private key password. Has anyone tried this feature (with PKCS#12) yet with success ? Using 2024.2.3 (build 24825). Cheers.

421
lifalin2016
Contributor
sujitbhunia
Contributor
sujitbhuniaContributor
asked in Transformers
Hi, I am having a problem where LAZ is not being read.

Reading laz from Local / Network drive throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it. Any ideas why this happens?

969
donalmateer
Safer
tb09114
Supporter
tb09114Supporter
asked in Transformers
FeatureMerger and FeatureJoiner do not match visually identical values

I need to use FeatureMerger or FeatureJoiner based on two varchar(200) attributes. Visually those values do match. No white spaces trailing anywhere, the strings are the same, yet neither FeatureMerger nor FeatureJoiner are able to combine the data. settings for FeatureJoiner As an example from the the Feature Information pane right attribute to join on left attribute to join on The join/merge is supposed to happen within a custom transformer, but I also tried it in the main workflow, where I received the same results. FeatureMerger is in version 21, and FeatureJoiner is in version 1001. Any suggestion on how I can identify the culprit and get these features to join/merge?

998
tb09114
Supporter
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Linear Referencing Speed along line / Event CSV and Line Geometry

Hi All, I have been trying to put a workflow together to linear referencing a few event tables in GIS. I usually do the task in ArcGIS but this time I want to automate the process as much I can. I have been checking a few of the LRS FME tutorials online but can’t get it to work. The aim is to linear referencing speeds along a railway route (line) using an event table that relates the lines and speeds. The input of my workflow as follows: Event table (xls) that shows the Line and speeds, example below: Line geometry with the line ID as well the ‘From_Chain’ and ‘To_Chain’ fields as parts of the attribute I have got to this point in the automation but can’t get the Snipper to work for some reason since doesn’t split the lines according to the speed lengths: Any advise how to accomplish the task? Thanks

312
galigis
Enthusiast
ebygomm
Influencer
ebygommInfluencer
asked in Transformers
ArcSDE FeatureReader - Workspace succeeds even when there is an error

FeatureReader setup with a parameterized connection. If an incorrect connection is selected, the errors are reported “The error number from ArcObjects is: '-2147216100'. The error message from ArcObjects is: {Insufficient permissions” But the workspace doesn’t terminate and nothing exits the rejected port of the FeatureReader. Rejected Feature Handling is set to Terminate Translation. I would expect the workspace to fail/and or output from the rejected port on this sort of error FME 2024.1 (Form & Flow)

160
ebygomm
Influencer
danilo_fme
Evangelist
danilo_fmeEvangelist
asked in Transformers
Set attribute JSON with Python

Hello all, I have a Workspace that makes the reverse geocoding using PythonCaller. import fme import fmeobjects import json ,urllib2 # def processFeature(feature): att = urllib2.urlopen('http://maps.googleapis.com/maps/api/geocode/json?latlng=-23.2186725,-45.9056706') data = json.load(att) print "o json é ", data When i run my workspace i see the results on the log file because i put the Print: How can i get this result with a new attribute? Thanks in Advance, Danilo de Lima

1455
gedgg
Contributor
evagardner
Contributor
evagardner
asked in Transformers
Directory and File Pathnames

Hi, I just upgraded FME Form and FME Flow from 2024.0 to 2024.2.3. One of my jobs failed using a FeatureReader with the Directory and File Pathnames due to the extension not being in all caps because the extension on the file it’s looking for is in all caps (.CSV). Originally the parameter was set to filename.csv and the FeatureReader would have no issues finding the file on 2024.0. Now the FeatureReader is not able to find the file in 2024.2.3. I changed the parameter to all caps .CSV in the featureReader and it finds the file with no issue. Anyone else noticing this with 2024.2.3?

853
ebygomm
Influencer
calvin.fme
Contributor
calvin.fmeContributor
asked in Transformers
Count the Number of Responses

Hi All, I have a survey asking participants to rank their favourite colours—Red, Blue, and Green—in numerical order (1, 2, 3). I want to use the results to create a workflow that counts how many times each colour has been picked based on the ranking. Here is some example data. Sample Data Unique_ID Colour Rank 1 Red 3 1 Blue 2 1 Green 1 2 Red 1 2 Blue 2 2 Green 3 3 Red 1 3 Blue 2 3 Green 3 What I am trying to achieve Colour Rank_ 1_Count Rank_2_Count Rank _3_Count Red 2 0 1 Blue 0 3 0 Green 1 0 2

906
geomancer
Evangelist
howeitzor
Contributor
howeitzorContributor
asked in Transformers
Issues with feature reader execution order

I have a feature reader that’s reading an Oracle non-spatial database. I have a workbench that writes all of the read tables to a file geodatabase. Some tables, I process twice; one where just the flat table is written, and another where the coordinate attributes in the table are used to create a point feature class written to the same file geodatabase. For some reason, only the flat tables are being written and none of the point feature classes are being created. Both work if I run them separately but not if I have two coming out of the same reader port. I’ve hidden the lines to write the flat tables to the feature writer. Is there a setting in the feature reader that I need to change to ensure it processes multiple outputs for each feature?

181
howeitzor
Contributor
brad
Contributor
bradContributor
asked in Transformers
Error writing to Temp GeoDatabase using Arcpy via Python Caller

Hello there, I am trying to execute some Python using the ArcPy module in a workbench base on this Tutorial, Using Arcpy for FME Feature Processing, but I am getting this error the following error: Geodatabase Error (-2147220970): Cannot acquire a schema lock because of an existing lock.Could not open File Geodatabase dataset `C:\Users\’USERNAME’\AppData\Local\Temp\wbrun_1740499345598_2444\fmetmp_24\1740665793794_2528_d\tor470\temp.gdb' for readingFailed to obtain any schemas from reader 'FILEGDB' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information It the issue seems to be the GeoDatabase is still “open” in memory, but my Google Fu has failed to come up with a fix

332
j.botterill
Influencer
sami26beniaouf
Contributor
sami26beniaoufContributor
asked in Transformers
Increment from a starting value until reaching another value

Hello FME Experts, I am working on processing a point cloud and need to create height-based sections to later filter the point cloud accordingly. Here is my goal: Extract the minimum and maximum height of the point cloud (already done). Create sections every 1m, starting from the minimum height up to the maximum height. For each section, create a buffer of ±0.5m (so each section spans 1m). Finally, filter the point cloud to extract the slices based on these buffers. My idea is to extract the Bounding box of the pointcloud, extrude it 0.5m lower, and then slice it starting from bottom every 1m until reaching zmax, and use them with Clipper. How can i slice this bounding box? I thought about creating a new attribut Number of slices = zmax - zmin and then use it as increment? or is there a simpler solution? Thank you for your help

342
sami26beniaouf
Contributor
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
Writing to File Name created from multiple attributes

I am trying to write out to a DWG from multiple inputs and need the output file name to be a combination of variables i.e. Extract_@Value(lot_number)_@Value(survey_type)@Value(survey_number)_@Trim($(_extractCoordinateSystem),EPSG:)_@DateTimeFormat(@DateTimeNow(), %Y%m%d).dwg The variable creates fine using a variable setter But when I try to run the writer it fails. It appears it is trying to write the file multiple time and fails to overwrite Any ideas on how I could set the variable file name better?

423
deanhowell
Influencer
liz.g
Contributor
liz.gContributor
asked in Transformers
AttributeManager - Remove Attribute

Hi All, I have recently upgraded from 2022 to 2024. Previously, when choosing to remove an attribute from within the AttributeManager transformer, the name of the attribute was removed from the ‘output Attribute’ column. This was very handy as it gave a good visual prompt for how the new dataset would appear. Example shown in the screenshot below: I now notice with the new version that the name is no longer removed and stays visible in the Output Attribute column. Example shown below: Does anyone know if this is this something that can be changed in a setting somewhere? I know this is only a small thing but it made a big difference to my day lol :D Thanks!

1295
crystalatsafe
Safer
raghavendrans
Contributor
raghavendransContributor
asked in Transformers
Configuring and Setting up GoogleGeminiConnector FME Hub transformer

I have been trying to setup the GoogleGeminiConnector in my FME Workbench to able to prompt and use the Gemini 2.0 Flash model to get me the results. Since GoogleGeminiConnector is a FME Hub transformer, the documentation is not friendly for a first time user of Google Gemini. The GoogleGeminiConnector makes use of the Google Gemini Web Service available on the FME Hub, which again needs some configuration. There are several things to be configured from the Web Services in FME to Client ID/Secret, using the on the Google Console and other configurations, some within FME and some outside FME using the Google Console. Due to the documentation is bits and pieces, a FME user is required to jump between various help documents and web pages. It will be good if Safe can provide a single page workflow, that lists out the steps in the correct order to be followed to make the GoogleGeminiConnector to successfully work in FME Workbench. Tx SRG

301
evieatsafe
Safer
ohashkii
Contributor
ohashkiiContributor
asked in Transformers
2D Arcreplacer

I have the blue lines drawn identical to red line.with right and left angle of 90 deg as shown on left. How can replace the 90 degree angle with small arc with specified radius lines(fillet). This group is wonderful and members are gratefully giving always such help.

813
ohashkii
Contributor
arash_hokm
Contributor
arash_hokmContributor
asked in Transformers
Joining Features Based on Identical Shapes in FME

Hello FME community, I have two feature classes and I want to know which features have identical shapes. It's somewhat like a FeatureJoiner, but I want to join based on identical shapes. Thank you

181
ebygomm
Influencer
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Remove extra vertices and retain geometry (Line)

Hi All, I’m trying to create a 10m node line from a 2.5m node line. I have tried ‘Densifier’, ‘Line Combiner’ and also ‘Chopper’ but can’t get it to work, How can I reduce the number of vertices and to obtain a 10m node line? Thanks

392
galigis
Enthusiast
arash_hokm
Contributor
arash_hokmContributor
asked in Transformers
Line disappears after using AreaBuilder

Hi everyone, I'm using the AreaBuilder transformer in FME to create polygons from line features. However, I've noticed that some lines disappear after processing. It seems like the AreaBuilder ignores or removes them in certain cases.The lines are neither in the Area nor in Incomplete nor in Rejected. The lines that have disappeared are marked in yellow. after Areabuilder before Areabuilder What could be the reason for this? Are there any settings or common issues that might cause lines to disappear? Thanks in advance for your help!

432
arash_hokm
Contributor
philipwhitten
Contributor
philipwhittenContributor
asked in Transformers
Clipping Rasters when the clipper size is similar to the raster cell size

I was tasked with determing raster statistics (e.g. flood height and DEM elevations) for a large number of building footprints. I didn’t expect that the Clipper transformer would treat the following input Clipper polygons the same as outside Clipper polygons: With the “Determine Cell Location By: Centers” parameter, any clipper polygon that doesn’t intersect a raster cell center is treated as being outside, even though it intersects the raster. That is the polygons labelled below as “bounds only” and “no point or bounds” are treated as being outside the raster. With the “Determine Cell Location By: Bounds” parameter, any clipper polygon that doesn’t intersect a raster cell boundary is treated as being outside, even though it intersects the raster. In this situation the clipper polygon can have an area much greater than the raster cells. That is the polygons labelled below as “point only” and “no point or bounds” are treated as being outside. A raster (green grid with red centers) being

220
philipwhitten
Contributor
iamprem
Contributor
iampremContributor
asked in Transformers
Attribute Validation - Not Null

I am performing data validation of a excel source data. I have configured multiple validations in Attribute validator. Issue:FME validates the not null validation and all other validations given, but what I require is if any of the attribute is null, I don't want to do any other validations. How do I perform these in FME?

243
crutledge
Enthusiast
so_much_more
Supporter
so_much_moreSupporter
asked in Transformers
PostGIS writer set to create if needed, still i get "table does not exist"

I have a a workflow of moving several tables from one database to another one. I needed to make a change and wanted to test the workflow writing to my localhost instead of production database. So i changed the postgis writer from “Truncate existing” to “Create if needed” targeting my local test environemnt. Still i get an error complaining that the tables does not exist?.. It does not matter if I hardcode the Table Qualifier or not. Or if i remove it all together. I have tried to not running the wb in cached mode etc..Tried running the WB in both 2023 version which it was created in and in 2024 version. “POSTGIS Writer: Table 'rplan.PblMidlByggAnleggOmråde' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format Parameters” And yes the schema “rplan” does exisit in my localhost database. I have no explanation to why FME would struggle with this?

316
nielsgerrits
VIP
tnarladni
Enthusiast
tnarladniEnthusiast
asked in Transformers
get owner information from ArcGISOnlineConnector

Is it possible to get the owner information using the ArcGISOnlineConnector? if not, is there something else I can use? I used the List Action and was able to get a list of the services/maps, but because there are the same item in two different AGOs in this group, I am unable to get the right one unless I know the owner. Thanks

232
j.botterill
Influencer

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,146
Posts
118,073
Replies
38,763
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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