- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,682 Posts
50,732 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

checcosisaniContributor

asked in Transformers

Extract info from wensite using HTTP caller

HiI tried to read this website https://stilo.comune.torino.it/albopretorio/#/albo/59 but in the response body I don't have the info Pubbl. N°Atto N°Dettaglio (probably some javascript are present but I' not an expert..) How can do this ? thx Francesco

2 years ago

ed31500

asked in Transformers

Hello , i would like to use a date (20221117) as an attribute , how can i do ?

Today i use the datetimestamper to have my date in a string, but i want to convert to an attribute Thanks in advance and sorry for my bad english ! 🙂

2 years ago

tbs_gis_teamContributor

asked in Transformers

Chart Generator Date/Time

Has anyone had any luck with Date/Time in the Chart Generator?

255

2 years ago

_harmen

asked in Transformers

Is it possible to disable automated scientific number formatting?

With the CAT reader, I'm loading a text file many small numbers, some of which are automatically converted to scientific numbers in the Visual Preview. These then become impossible to work because, for some reason, any transformations of the data are based on those scientific numbers rather that the decimal numbers. Is there a way to disable this automatic transformation from decimal to scientific numbers?

1001

2 years ago

kattContributor

asked in Transformers

How can I convert an attribute from string to number? I want to write to a JSON file and have them in a number format.

Hello, I am reading some attributes from a database. Some are in string format, some in number (int, float etc.). I want to write these attributes to a json file.I noticed that all the attributes in string format are automatically output in quotation marks and the numbers without. In my case I have three attributes: district, lat and long. District is an int, lat and long are strings. How can I change lat and long so that their output is also without quotation marks like the district one (see image) ?

73313

2 years ago

checcosisaniContributor

asked in Transformers

CSS Selector for HTML Extractor

HiI need to extract the 1 2 3 4 5 td element inside class paginated_element in separate rowCan you hlep please ? I'm able to extract the entire class but not the single value thxFrancesco

151

2 years ago

flugan87

asked in Transformers

Create interval in dates. The transformer doesn't accept ESRI:s dateformat. I've tried to convert it to fme_date but it still doesnt work.

I have been given the task of creating an e-mail function. It should send an email when another date is about to expire. For example, a customer receives an email when there are 14 days left on their current booking. But datetimecalculator does not work to calculate intervals of days when it comes from ESRI file geodatabase (is SDE in the original data) I suspect it is the format of the attribute that is incorrect but can't find how to change it to a working date. Is there anyone who can help me? Attaching my workbench and a file geodatabase as a zip file Best regardsJesper

2 years ago

aronContributor

asked in Transformers

Getting weird artefacts from ContourGenerator

I am getting some strange spikey artefacts from ContourGenerator. The dataset is a goverment isued DTM, pictured are some sea islands. The data is preprocessed with rastercellrounding and a notatasetter to ensure that the sea surface did not hold any data. Settings as follows:First image elev 2.5 tolerance 5Second image elev 2.5 tolerance 0Third image is a close up of the the second (elev 2.5 tolerance 0) Any ideas on how to deal with this?

146

2 years ago

kellerContributor

asked in Transformers

How to create lines from points

(I have attached the dataset)I have survey points where each point is less than 2Metres from the next point per run, in a run i can have more than one section, as shown in the attached file, but all the points within this one run are still within a distance of less than 2M from each other. The difference in distance between runs is more than 2M. So it is evident when a new run starts and ends. If i had the attribute run within my dataset i would use the linebuilder and create lines from points.So what i am trying to achieve is to group the data per run. So far i have tried creating a new attribute in the Attribute creator transformer using conditional values but to no success. Anyone with an idea of how i can achieve this? Thanks,Keller.

206

2 years ago

rowdy

asked in Transformers

ESRI GDB Mosaic Dataset add raster error?

Using Workbench 2022.2 and try to insert a TIF into an existing mosaic dataset and FME is returning the error: Unable to retrieve path to raster dataset from feature Yet, I can see the fully qualified path to the TIF in the incoming fme_dataset attribute from the geotiff reader?

1223

2 years ago

tcroninContributor

asked in Transformers

What is the best way to download data from an Open Data ArcGIS Site that does not require a login?

247

2 years ago

nibon

asked in Transformers

Is it possible to remove list elements of a feature based on an arithmetic expression (without exploding the list)?

I have roughly 12.000 features (points). Each feature has a list with 400 elements, which all have an X and Y attribute. I would like to remove the elements of which the distance between the point of the feature and the element attributes is bigger than a certain number. Currently I'm first exploding the list, and then using a tester with the arithmetic expression(@sqrt(@pow(@XValue()-@Value(x_end),2) + @pow(@YValue()-@Value(y_end),2))). The problem is that this way I first explode the list, which results in more than 4 million features! If I could eliminate them before exploding than I would only have roughly 200.000, which would improve performance.

783

2 years ago

paul_c_2Contributor

asked in Transformers

Data validation & finding differences: CRCcalculator vs Matcher vs...?

I will soon have two sets of (hopefully) identical data to check against each other, sat in FGDB's. There are quite a lot of records (thousands, if not tens of) and I'm looking for differences in any attribute between the two versions of the same record. I can see this taking a long time, and note there are different options within FME, including Matcher, CRCcalculator, etc. What is likely to be the most efficient method?

222

2 years ago

jan

asked in Transformers

How can I assign a unique identifier to all areas that intesect each other?

1410

2 years ago

with_honours

asked in Transformers

My question is in two parts. I am having to insert Excel spreadsheets from OneNote to FME in order to correctly format them for upload to an actual DB. However, due to how the information has been entered in OneNote multiple pieces of information

that should be in separate fields are in the same cell. So, how do I remove peoples job titles that are sharing the name field and place them in a field of their own and is their a standard FME practice that will target duplicate entries into Excel sheets? Any help would be greatly appreciated.

131

2 years ago

crocharibeiro93

asked in Transformers

Hi, i need to convert one geotiff to kml/kmz but i´m a absolute begginer in FME workflow. Anyone can help me with a tutorial or similar ? Tnks

1031

2 years ago

jbs

asked in Transformers

Emailer transformer needs oAuth 2.0 support.

Microsoft is disabling SMTP on Microsoft 365, and we have to switch to oAuth 2.0 authentication. We have some Emailer transformers in our workspaces, unfortunatly they only support oAuth2 for Gmail. What is the alternative to use for this transformer ?

123

2 years ago

kalbertContributor

asked in Transformers

FeatureReader select multiple files with condition

I use a FeatureReader to read multiple shape files from a .zip. The FeatureReader run in FME-Server. A published parameter is used as 'Dataset' (i.e. the FME server path to the .zip file). 'Feature Types to Read' is empty to read <All Feature Types> because I don't know the exact name of the provided shape files per monthly run. The set up works pretty well. the Reader loops over all shapefiles in the zip and the records are provided through the <Generic> port as intended. Now I have the following challenge:One group of shapefiles in the .zip are point classes and the name starts with POINT_****.shp. Another group are lines and the name start with LINE_***.shp.Question: Is there any option to read only one group with my FeatureReader setting? I tried to play with wildcards in the File/Filter field of the 'SelectMultiple...' control but with no success My current mitigation is to use two FeatureReader. The first one is only reading schema and the

2895

2 years ago

tvaContributor

asked in Transformers

Storing json format into XML

For some reason in one of our processes it was decided that an XML is needed that contains partly json data (I know how this sounds :( ).I'm struggling to get the json data correctly parsed (or the XML correctly formatted). The json data is generated via json templater and looks like this:{ "editOptions": { "cascadeEditOptions": { "cascadeStrategy": { "type": "NoCascadeStrategy", "enabledTypes": [] } }, "userProvidedIds": true }}The XML structure should be like this:<data> <metadata> <projectName>SomeProject</projectName> </metadata> <action> <Modification operationId="test_operation_id_1" Id="1" requestBody=' { "editOptions": { "cascadeEditOptions": { "cascadeStrategy": { "type": "NoCascadeStrategy", "enabledTypes": [] } }, "userProvidedIds": true }} '/> </action></data>Th

10037

2 years ago

jorge_rosalesContributor

asked in Transformers

Different results for the same polygon overlap

In this workspace, the results of AreaOnAreaOverlayer (using the default tolerance) and SpatialRelator (using a custom DE-9IM matrix) are different. I suspect it's a precision issue with the AreaOnAreaOverlayer transformer but it's curious that the transformer that doesn't allow changing the tolerance (SpatialRelator) is the one that works fine.

456

2 years ago

vxn43Supporter

asked in Transformers

PointOnLineOverlayer - No Split Lines?

Wondering what parameter to change so that when I use PointOnLineOverlayer it does not split the lines? is this possible?

131

2 years ago

fme_hansContributor

asked in Transformers

How do you create geometry from an array of coordinates?

Hi,I have array with geometry type and coordinates. How can I easily make geometry out of it? I could make a wkt text with string replace but I suspect it could be easier. The string with geometry type and coordinates is (shortened):{"type":"MultiPolygon","coordinates":[[[[155469.406,463438.624],[155469.253,463444.217],[155467.196,463444.174],[155467.077,463444.172],[155462.4]4,408. [ 155469.406,463438.624]]]]}

652

2 years ago

safesoftaccount

asked in Transformers

Which transformer can be used in the place of MRF2DCleaner transformer?

2 years ago

rmpayabyContributor

asked in Transformers

Converting large numbers

Hello, I have an Excel-file where one of the attributes contains large numbers such as 3.0230003003349996e+19. I want these numbers to be in a format without the e-notation such as 30230003003349996. What's the fastest way to do this?

232

2 years ago

redspell

asked in Transformers

How to fill a polygon with lines

I have a 2d polygon and I wanna fill it with as many parallel lines as possible given the distance between the lines and the angle. I have some problems to create the lines I need. In the image ignore the points.Input:+ the angle (i.e. 80°) Result (ignore points)

412

2 years ago

Page 92 / 508

Badge winners

hr404has earned the badge Teacher (Grey)
majed_abdallahas earned the badge Integrate Spatial Data
bayramhas earned the badge Welcome Back
a.hamannhas earned the badge Welcome Back
aurelienhas earned the badge Integrate Spatial Data

Show all badges

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