- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,684 Posts
50,749 Replies

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

12684 Posts

edmjoe

asked in Transformers

Adobe Geospatial PDF reader page range

Hello everyone,I've created a workflow analyzing text within a pdf-file with the Adobe Geospatial PDF reader. To limit the amount of data to what im intressted in i've tried to use the "page ranges" field to specify which pages to read. The problem is that the pdf index the first page in each file as 0, the second as 1 and so forth, and the Range field returns 0 as an incorrect value. If i put in page range 1-2 the reader reads page 2-3 in the data. Is there someway to use this field with my dataset?

110

4 years ago

msuzuki23

asked in Transformers

FME Tool Workbench: SQLCreator does not update when records are inserted into Database

I initialize my workflow with a SQLCreator that queries an Oracle Table, transforms the data and update the table back in Oracle. When I insert a new record thru a sqlplus/Toad into the Oracle Table, after that I re-run the Workspace in FME Workbench, the records from the SQLCreator does not update, it keeps the same records as when I first ran it. What am I doing wrong here? Any help is appreciated, I've been trying to run this for the last 2 days with no luck.

100

4 years ago

perry

asked in Transformers

Hi, I want to export a picture to JPG or BMP out of a Oracle-non spatial table. This picture is stored like: FFD8FFE000104A46494600010101006000600000FFDB00430006040506050406060506070706080A100A0A09090A140E0F0C10171418181714.....

Hi, I want to export multiple pictures to JPG or BMP out of a Oracle-non spatial table. These pictures are stored like: FFD8FFE000104A46494600010101006000600000FFDB00430006040506050406060506070706080A100A0A09090A140E0F0C10171418181714.....In a different table there is an unique explination of this picture (ie street and number)Is it possible with FME to convert and to export this table to a directory on my network with pictures with format JPG or BMP? I need this pictures to provide an external office so they can use these pictures as offfered.

740

4 years ago

lambertusEnthusiast

asked in Transformers

How to access a zipfile from a URL which contains a GML file?

I want to download a zipfile using an URL and continue with the GML file which is within this zipfile. The following URL contains the zipfile:http://geodata.nationaalgeoregister.nl/top100nl/extract/kaartbladen/TOP100NL_33W.zip?formaat=gml I tried to use the HTTP caller first with these settings:HTTP method: GETSave Response Body to: Attribute ..then I used the FeatureReader to open the output of the HTTP caller.However, I got stuck. The HTTP caller did not generate any output. Could you advise me in this?

460

4 years ago

shiamliborge

asked in Transformers

As a new user of FME, I would like to understand if it can extract tables from PDF to excel sheet?

4 years ago

lifeinabox

asked in Transformers

Spatial Filter alternative?

Hidoes anybody know of a good alternative to the spatial filter? Due to the volume of data involved it doesn't seem feasible to use the spatial filter but I can't really see an alternative. Unfortunately I have around 3 million polygons to pass through a filter of around 1 million polygons. I have used a feature reader to break up the data into manageable chunks, which makes the workspace run at a reasonable speed but this requires me to rerun it multiple times with each chunk. I was hoping to be able to run it in one go. Using a workspace runner has also helped with processing, but again, still not feasible to run it in one go.

360

4 years ago

sprongandre

asked in Transformers

Create simple surface from 3 lines takes very long with surfacemodeller?

I have a baseline and I want to offset it to create several lines. With these lines I would like to create a surface and convert it to a solid.In my opinion it is a very simple model, but to run it, it takes a lot of time.What do I wrong? thanks!

4 years ago

shankar

asked in Transformers

I am looking for ways to create 2 bypass lines and point. Refer to the attached screenshot. 2 lines and 1 point in black are existing. Looking for ideas on how to build 2 bypass lines and point red in color.

4 years ago

tdltd

asked in Transformers

Autogenerate QR code and Shortened Google Map URL

Hi guys I was wondering if FME could be used with automating what I need. It's easy to do manually, but potentially need to do this 100's of times. Basically I need Shortened "Share" Google Map URLs from a GPS bearing, and a QR code of the google maps. So e.g. I put in GPS beraing: 55.982017, -4.258112 Then I get these results: would be great to set up a simple web site to have a form for this

560

4 years ago

ileung_cnwContributor

asked in Transformers

Fill columns based on conditional values?

Hello FME Community, First time posting here! Hope to explain my problem better with screenshots of my current situation and what I hope to achieve. I have 3 empty columns I like to them to be filled with values from Status_Percentage.sum based on the feature's status (e.g. Built, Intended, Interim). The result should look like this:The image shows values from Status_Percentage.sum filled to each empty columns based on the feature's status. I've looked into AttributeManager and conditional values but not getting what I want. I've been advised to look at VariableSetter and VariableRetriever but am not familiar with the transformers. Any help is appreciated! Thanks in advance.

340

4 years ago

har40428

asked in Transformers

Transposing dynamic text data

I have data in the following structureI need to get it into the following structureAfter the data has been transposed I intend to carry out some transformations on it so ideally this would be part of a workflow rather than the end of it. And the exact name, type and number of attributes will change with each run so the workflow needs to be dynamic.I've been going round in circles with AttributePivot, AttributeTransposer, AttributeExploder, Aggregator to no avail. Anyone got a way of doing this?

190

4 years ago

kattContributor

asked in Transformers

Hello, I have this list (see image): the Business RulesID & their count. I would like to add to this list all Business Rules IDs that are within the range of 1 to 25 & whose count is 0 (that's why their are missing),e.g. BusinessRuleId =4 & count=0

4 years ago

brian.telintelo

asked in Transformers

How do I reduce the points generated from an Area Amalgamator?

So I have some areas that have gaps. I used an area amalgamator to combine them. It works really well. However, it makes the polygon/area have tons of points. Is there a way to reduce the number of points on the polygon? In the screenshots, before Amalgamation, the number of polygon points is probably 10-20. After, there are probably a hundred points that make up the polygon. All are very close together and could be removed and still keep the shape

4 years ago

nisa

asked in Transformers

In the SQL Creator transformer, what is meant by 'attributes to expose'. When do I need to use it? For example if I have a query which extracts fields, wouldn't the attributes be exposed from the query itself.

4 years ago

gtiemens

asked in Transformers

Is UUIDGenerator generating UUID version 4?

Is the UUIDGenerator using the algoritm to generate IETF UUID version 4 (random) ? If so, can you add to documentation with reference to the IETF standard ? If it is version 4 (random), can you explain which library is used as seed for the random number?

640

4 years ago

callummcclure

asked in Transformers

Filter las1.4 poincloud, model key point classification flag

I looking to filter a classified las1.4 LiDAR file, to extract the model key points (classification_flags = 1) on classification = 2 (ground). Although classification_flags doesn't seem to be an attribute and is null if i expose it.-LAS reader-PointCloudFilter (class =2)-AttributeExposer > classification_flags (returns null)-PointCloudFilter > should filter by flag here. Any helps would be much appreciated.

330

4 years ago

rich90599Participant

asked in Transformers

Get polygon perimeter dimensions from irregular polygons

Hello, I have a shapefile with various polygons on land parcels. I've been tasked figure out the dimensions of the polygons and display them on a map for engineers and planners to examine. How would I go about this using FME 2018.1?Since some of the polygons have curves, I figured I would use the PolylineAnalyser tool from the Hub and use the Segment output. Then use the Sorter to first sort by the ObjectID and then by the angle of the segment. Then I wanted to merge line segments that are within a 2-3 degrees range of each other so I would get a continuous line, instead of a bunch of small lines to make up a side of a polygon. Perhaps I'm going about this entirely wrong and there is an easier way to do this. Any help would be appreciated. Thank you

1120

4 years ago

robinrutten88

asked in Transformers

Is there a way to automatically filter out the values of a feature with the use of a testfilter?

I am using a test filter to filter out all the different values of a feature type. In this case there are 21 different values, so I have to manually create 21 different test conditions. Is there a way to automatically create the test conditions? I also have features with more that 50 different values, which would be a lot of work to filter out manually.

2640

4 years ago

nedwatermanContributor

asked in Transformers

Extracting data using the XML Flattener

Hi, I'm trying to use the XML Flattener to extract the attributes from an xml response_body: <loggers><summary><APIVersion>DatagateAdmin V2.48 (14-Sep-2020 12:38)</APIVersion><accountID>5279</accountID><accountName>Main Account for all SWW loggers</accountName><accountOwnerId></accountOwnerId><accountHighestMessage>4526752363</accountHighestMessage><accountUpdateTime>2020-09-28 08:39:17.6</accountUpdateTime><accountNumLoggers>2563</accountNumLoggers><CentreLongitude>-3.86433819774539</CentreLongitude><CentreLatitude>50.6236029248117</CentreLatitude><MinimumPhoto>0</MinimumPhoto></summary><logger><loggerid>74508</loggerid><mobileNumber>447924658356</mobileNumber><dateLastMessageReceived>2019-12-17 16:00:00.0</dateLastMessageReceived><type>FW-102-001</type><serialNumber>80823</serialNum

1520

4 years ago

jsprattParticipant

asked in Transformers

How to spatially join attributes to any type of geometry? Or is there an easier way?

I have a set of geometry 3D objects containing, points, surfaces, cubes, and lines. Each geometry object in the set has attributes defined for them but the attributes are read into the workspace through a different reader.The geometry and attributes for this set are coming from the same file originating from AutoCAD Mechanical 2020.1) How can I join the set of attributes to the set of geometry objects?I have tried using FeatureMerger with a join on `_geometry` which is successful for points because the geometry matches the 'insertion point' of the attributes being read in but the join fails when the geometry is 3D or not of equal size.I have tried Matcher with vector tolerance but the results were not was I was looking for. Could be a transformer configuration problem.I have tried NeighborFinder but the results were not was I was looking for. Could be a transformer configuration problem.I have also tried SpatialRelator to find containment and Clipper but inputs were rejected for both o

120

4 years ago

naste4kina

asked in Transformers

When I write dgn file in FME, my original added line style changes. How can I save it?

Here is my original file. I made my own line style for different objects.Then I make the simplest transformation with FME and it saves my line style. and then I write dgn file and in it, I see another line style. in some cases I can see one of default line styles, but sometimes it uses my added style but not that one, that I used before FME

4 years ago

deanhowellEnthusiast

asked in Transformers

Anyone converted LISCAD files or LandXML from LISCAD

I am looking for some advice on the best way to validate data coming from a LISCAD survey drawing? I know LISCAD can convert to LandXML so wondering if that might be a good option and looking for any advice on that as well.

4 years ago

catmoody

asked in Transformers

Trying to extract line features as separate feature classes based on areas within polygon data

I've been looking around trying to figure out how to extract subsets of some contour data based on where they fall within some polygon contour regions I have built. I have 10 polygon regions identified with a region name attribute. I'd like to input my large contour line data and get 10 separate subsets of contour data out based on the region they fall within. I've looked at Spatial Filter and a few other extract transformers, but can't figure out the best way to proceed. Thanks for any help!

4 years ago

zuzanna_sz

asked in Transformers

AttributeValidator - is there a way to feed the list of attributes to validate using parameters (user parameters)?

The idea is to create a generic workflow which will validate any dataset by checking all its attributes, calculating some statistics etc.I separated it into 2 (maybe even 3 workspaces) where parent workspace reads the dataset and creates a parameters for the child workspace which is analyzing the data. The only problem is - how to set up the AttributeValidator using these parameters? I did that without any problems with the Attributes to Expose parameter of the FeatureReader (list of attribute names with space separator). I am using 2020.1.2.0 (20200902 - Build 20620 - WIN64)

390

4 years ago

catmoody

asked in Transformers

I'm using a Workspace Runner to do a Shp to DWG converstion for several hundred files. I cannot get a prompt for the output folder to ask for a folder rather than a specific file name

Here's some screen shots of the very simple shp to dwg workspace and the workspace runner parameters

4 years ago

Page 185 / 508

Badge winners

victor_xviihas earned the badge 12 Days Participant (2024)
metwalyhas earned the badge Integrate Spatial Data
lucieropohl97has earned the badge FME Form Advanced Training
jipxhas earned the badge 12 Days Participant (2024)
tooli11has earned the badge 12 Days Participant (2024)

Show all badges

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