- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,682 Posts
50,742 Replies

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

12682 Posts

Recently active

Most replies Most views Newest first

od10Contributor

asked in Transformers

Remove specific vertices in a list from a polyline

Hello, How would I remove specific vertices from a feature that are stored in a list, the vertex remover only allows one vertex be removed. I have a list with: Coordinate Index - vertices_to_remove{}.vertice_indexX - vertices_to_remove{}.xY - vertices_to_remove{}.yZ - vertices_to_remove{}.z Thanks

263

3 years ago

nataliekovachParticipant

asked in Transformers

Read CSV multi-line header to define attribute value

I am really, really new to FME and so trying to wrap my head around everything. Essentially I have a CSV that has multiple data sets one after another, split by a multi line section of header information that it not formatted the same way as the data. I'm trying to read each section of data and write it to a single database table. So for each section I need to read a specific line within the header area (Serial number and Counter Name) and then use that as one of the attributes in the writer. Data should look like : SerialNumber, CounterName, Date, Time, Value When complete in order to write it to the table. From the various posts I've found I think it might involve using a variable setter and variable retriever but I'm not sure how to make that work. Any suggestions are appreciated.

546

3 years ago

litung8

asked in Transformers

Parse ESRI Json file output, add new static variable, then rewrite back to Json file with new variable

Hello,I have a few ESRI generated json response files from ArcGIS Server feature service that can contain 1 to 200 records per response and these do not have geometry. What I want to accomplish is to add one new parameter "projectnumber" and assign it with a static variable and rewrite the output back to JSON or ESRI JSON file again. Thanks in advance ! Original: { "attributes": { "sapfloctplnr": "MASG-GASD-SA01-SERL-0055647", "lifecyclestatus": 1, "GLOBALID": "{E839E029-529F-4D6B-9C4E-85BD875BC582}", "ASSETGROUP": 1 } }, { "attributes": { "sapfloctplnr": "MASG-GASD-SA01-SERL-0055649", "lifecyclestatus": 1, "GLOBALID": "{A9BF1A40-C1E4-4BC7-A538-7011FA9C55EA}", "ASSETGROUP": 1 } }, { "attributes": { "sapfloctplnr": "MASG-GASD-SA01-SERL-0055659", "lifecyclestatus": 1, "GLOBALI

3 years ago

runnealsContributor

asked in Transformers

Reading a QR Code with FME Transformer (FME Server App)

I'm looking to build a workspace for an FME Server App to read a generated QR code that has a CSV list of attribute values in as an attribute and further transform it. Does anyone have any experience?

592

3 years ago

chris_accContributor

asked in Transformers

Repair Invalid Polygon Geometry Type

Hello,I wish to generate a count of points within Polygons [PointOnAreaOverlayer] but I am unable to generate a count for some polygons because of fme_rejection_code: INVALID_POLYGON_GEOMETRY_TYPEThese Polygons are either Self Intersecting or Multi Polygons. I believe I need to resolve this before I can start counting points inside but Aggregator and Geometry Validator do not seem to fix the issue.Thanks.

2744

3 years ago

trevormContributor

asked in Transformers

Segmenting a polyline feature based on rolling average of fields within the feature.

I found something back in 2009, but nothing since and no solution built for this. I have Intermedite knowledge of FME. I have a records for every 50 meters along a roadway that contains 3 fields Ride value, Rutting, and Surface condition. These 3 values make up our Condition state of our segments. I want to reverse this and build my segments based on a Rolling average for say 1 km minimum (20 records) where the average IRI = >x, Rutting = >y and SCI = >z. it would then build a polyline or group by averages. This would be a massive upgrade to our current system which involves shovels, hammers, and coffee!!! Sample graph where the red line would be my split, the roadway here groups into 2 segments.

3 years ago

monsieurlatte

asked in Transformers

Split Mapinfo Table into 3 equal sizes.

We have a Mapinfo file with customers and we're using this stupid third party geocoder (for now hopefully changing) and we're pretty sure it's having an issue because of the size of the table we're sending it. I was thinking maybe I could get around it by having FME split the table into 3 equal tables and then geocoding them and then combining them back together. Does anyone know of a way to do this? There's no real column info that I could export based on anything it would have to be after X rows or something similar to that. Thanks so much! 😀

184

3 years ago

cwisse

asked in Transformers

I'm using the AppearanceSetter to set textures as an appearance to surfaces. The Texture Mapping Type is set to Surface Normal. The result for the walls is correct, but the roofs are wrongly oriented. Does anyone know what the right workflow is?

141

3 years ago

alan.philpott

asked in Transformers

HTTP Caller Sending Too Many Requests (Slack Webhook)

I am running a workspace that detects changes in data between an API and Web App and applies only updates to the Web App using a change detector transformer. I am sending a notification to a Slack Webhook but instead of a single HTTP request being made, it makes 1 request for each data record updated. What I Want:"Successfully updated 70 records". What is Happening:"Successfully updated 1 records"."Successfully updated 2 records".And so on till 70... Is there a transformer that will allow me to sum the number of updated records and only send a single HTTP request to the Slack Webhook? Workbench Screenshot: Thanks!

3 years ago

mattenvsys

asked in Transformers

Output data not reading as specified EPSG code

Hi all, I am generating a workspace for a client. A requirement is that output data should be in EPSG:29902. The writers have been defined to use 29902 as the output coordinate system. However, when I open the datasets in QGIS or Arc, the data is reporting as coordinate system EPSG:29903. Is there a way to correct this behaviour? Attached is a simple workbench with a creator transformer and a writer set to use 29902. But the output generated is 29903. Many thanks

3 years ago

sean.anderson

asked in Transformers

I have a list of hyperlinks in Excel that lead to PDF's held in a website. Can FME iterate through this list and download the documents to a folder? Thanks in advance. Sean

372

3 years ago

nick824

asked in Transformers

Hi all, I am fairly new to FME but have a problem with an httpcaller in a loop. I cannot seem to stop the translation when all records returned. Any help would be appreciated.

I've got a HTTPCaller in a loop that retrieves data page by page (I use offset and limit). I have a tester that tests whether 'has_last_page' is true. This all seems to works ok but the translation does not stop - it just keeps repeating the last URL even though all records have been returned.

576

3 years ago

nedwatermanContributor

asked in Transformers

Split list of values to time periods

I'm extracting some data from a DB that stores values for time periods against a date in a comma separated list (above). I've used a cloner to create the time period for the date. Any idea how I split the csv list (presumably using an AttributeSplitter) and append the value to the desired timestamp? Any help appreciated!Thanks

203

3 years ago

lars_de_vries

asked in Transformers

XMLTemplater and braces in text

I have an issue where I have text that contains braces that are inputted into an XMLTemplater through a SubTemplate (and also through ROOT). Since I don't want the XMLTemplater to parse the text, it is referenced as @Value(text) and not {fme:get-attribute("text")}. Still I get an issue as if FME expects a function. The log tells me: "context item": undeclared variableFor this issue I prefer not to escape the braces in my text, which of course would be a workaround.

102

3 years ago

geoman

asked in Transformers

How to convert points to multiple lines considering gaps in data and spatial sequence/ order

Hi Everyone, I need your help to solve a problem. I have many no. of points that are not in order if we look at them spatially and in many places, there is a significant gap considering its distribution. I have tried Sort and then Line builder transformer in FME but the output was generated based on the layer drawing order. Another issue is line builder does not consider the gap within point distribution and connects all points to generate a single polyline. Looking for a solution to convert points to separate lines based on their spatial sequence. The attached below screenshot could make you clear about the issue I am talking about.

142

3 years ago

bibold

asked in Transformers

Is a NULL Writer the best way to cause my workbench to complete when certain conditions are met and I do not need anything written. Or is there a better way to gracefully terminate the workbench.

I am running workbench an FME Server automation that is fired from a SQL Server insert trigger for a ArcGIS feature class that has editor tracking enabled. On the workbench I check previous records for the feature and only want the workbench to complete under specific conditions - it is writing an HTML file. I was considering using the NULL writer but the documentation indicates this should only be used for testing. Looking for the best way to accomplish this. I considered modifying the trigger but this is so involved and much easier and cleaner to do in FME... Any tips would be appreciated.Thanks!

3 years ago

chris_accContributor

asked in Transformers

Variable Retriever not receiving value from Variable Setter

Hello,I am trying to obtain Max OBJECTID value from a database and pass it into Variable Setter.The SQL Creator > Variable Setter is obtaining the correct value (just one record at present) but the Variable Retriever cannot obtain the value I think?I hope this is a simple step or order I am missing.Thanks in advance

827

3 years ago

awais

asked in Transformers

Hi All. I have a Civil 3D file that has block data that contains several attributes. When I set the parameters to explode blocks to entities all the attribute information is lost. Is there anyway to preserve the attributes?

If I do not explode, I loose the 3d surface and the geometry is shown as point.

3 years ago

larsec

asked in Transformers

How to download files in a folder via ftp?

Hi all,I'm trying to download files (in this case zip files), which are in a parent folder on an ftp. The folder name changes once a week, when new updates are uploaded. I would like to automaticly download the updated files once a week, but it seems that the ftp caller has some limitations in that department - (asterix and subfolders). I have searched the forum for answers, but haven't really found a solution yet. I've seen suggestions using python caller and ftp caller combined, but I dont really do python :-) Any suggestions? Thanks

3767

3 years ago

canerakinContributor

asked in Transformers

FBX to AR | I am getting an error "FME-AR_FBX' of type Directory, expected a dataset of type Regular file"

Hi all,I am trying to convert fbx file to FME AR. I am getting the error below."FME-AR_FBX' of type Directory, expected a dataset of type Regular file"I tried to deaggregate to see if it works workout but no luck.

3 years ago

topotomaContributor

asked in Transformers

Populating unique values for multiple attributes and writing to excel

Hello, Let's say i have an excel table containing multiple attributes and features, and I would like to output in an excel table a summary of the unique values for each attributes. Using duplicate filters I managed to get the results but they are ordered in rows in order of arrival instead of being nested for each attribute. Example with three attributes:ID ----- Name ------CityA1 -----Mark -------MoscowA2 ------Paul -------GlasgowA1 -----Joanna ---CapetownA3------ Paul -------Glasgow Then in excel I get three columns but the results are spread in the order of arrival of results for each column unique values: Column A -- Column B -- Column CA1A2A3--------------Joanna--------------Paul--------------Mark --------------------------------Glasgow---------------------------------Moscow-------------------------------- Capetown Instead of having the results over various lines, I would like to get the unique values on top of each column. Is there a way to do so ? Maybe working with lists ?

822

3 years ago

mat_1

asked in Transformers

Hi All, I have a complex polygon with smaller polyons within a bigger polygon, multiparts and lots of overlap issues. I want to be able to desegregate, remove multiparts and be able to select each polygons individually. Any thoughts will be helpfu

112

3 years ago

mhabContributor

asked in Transformers

AttributeFilter is stopping all features in BATCH mode but works well in Workbench. What could be a reason for this ...

I run features through an AttributeFilter Transformer in order to split the stream for specific manipulations downstream. If I test this in Workbench everything works as expected. If I call the workspace in BATCH from a DOS script all features end at the AttributeFilter (identical data).In FME Log of the BATCH run I see lines likeAttributeFilter_9 AX31001 Transformer Output Nuker (TeeFactory): Cloned 818 input feature(s) into 0 output feature(s)AttributeFilter_9 SD41000 Transformer Output Nuker (TeeFactory): Cloned 1154 input feature(s) into 0 output feature(s) What is going on here ? Why are the features not passed ... very,very confused 👿 😮 FME 2021.0 up to 2021.1.3 all the same

111

3 years ago

akozielec

asked in Transformers

Why does the "Resolve Domain" parameter in the ArcSDE reader change the data type of the fields?

I have an attribute called "Status." The coded value is an integer and the domain value is a character. When I do not resolve the domains in the reader, then the automatic writer sets as an integer field, but when I resolve the domains, then the "Status" attribute and the "Status_resolved" are both characters. Is there a way to get "Status" field as an integer and get the "Status_resolved" attribute? I don't want to have to use a manual writer because I have >100 fields.

230

3 years ago

jdhContributor

asked in Transformers

Snapping end points to segments

I have a use case that is not covered under the three snapping modes available in the anchoredSnapper.My candidates are a set of lines, the anchors can be either lines or polygons, but for this discussion will be polygons.The lines need to have their end points (and only their endpoints) snapped to the nearest polygon segment. The rest of the vertices of the line should remain untouched. Currently I am developing the following workflow:Create a unique id for the lines.Extract the end points of the candidate lines, send them to an anchoredSnapper with the polygons as the anchor, use snapping type Segment.Take the original lines and send them to a second AnchoredSnapper with the points as anchors and snapping type End Point, grouped by unique id. Is there a better solution I'm overlooking?

1194

3 years ago

Page 142 / 508

Badge winners

scottshas earned the badge English Speaker
scottshas earned the badge Welcome Back
boxcase01has earned the badge Welcome Back
jen.mulliganhas earned the badge Welcome Back
jeovishas earned the badge Welcome Back

Show all badges

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