- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,681 Posts
50,732 Replies

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

12681 Posts

Recently active

Most replies Most views Newest first

dallas2011Contributor

asked in Transformers

Database export

Hello, I would like to ask how to solve this problem,that there are several databases. In line, polygon, point and text formats. The question is whether it is possible to create an excel file that contains all database names, as well as what attributes are there as well as attribute names and alias names. In addition to this, what are the results in the attribute table and the corresponding domain names.And export it to xlsThanks in advance

141

1 year ago

prive

asked in Transformers

Does FTPCaller consider sftp/ftps URL the same way ?

Hello everyone, I searched a lot about this topic but nothing matched the same problem. I have a functionnal ftps URL that return the good file in filezila. But when using it with the FTPCaller, it return a timeout. Whatever the parameters are.But if I declare the URL as a SFTP, it does the job. It work here because the server do accept the query with sftp but if not, I am afraid I'll be block with the ftps only.Does someone face the same problem ? Did you find why and how counter it ? Thanks in advance ! Have a good day.

401

1 year ago

robyn_studts

asked in Transformers

Translating from Smallworld to MicroStation using 2018 works fine but using 2020 the text is not translating correctly. I am using the same FMW file and the same Coordinate file.

I have tried a bunch of different coordinate combinations to find one that may work. Using the one that I have always used the objects translate in the correct location, but the scaling is incorrect. Other coordinate systems the text is the correct scale but not in the correct location. I am translating from NAD27 mm to NAD27 ft. looking for an answer so we can move forward with a software upgrade. See below for coordinate info that I am using. # KB 01/11/2013 - SRP database projectionCOORDINATE_SYSTEM_DEF SRP_AZ_Central_mm \\ DESC_NM "SRP Arizona Central NAD27 millemetre" \\ SOURCE "SRP GIS" \\ DT_NAME NAD27 \\ PROJ TM \\ UNIT MILLIMETER \\ PARM1 -111.9166666666667 \\ ORG_LAT 31 \\ SCL_RED 0.9999 \\ X_OFF 152400305.0 \\ Y_OFF 0 \\ MAP_SCL 1.0 # KB 01/14/

1 year ago

vxn43Supporter

asked in Transformers

Exclude 1st Row of Excel Table

I have an Excel file (table). How do I prevent it from reading the 1st row of the table?

1401

1 year ago

jrlalessiContributor

asked in Transformers

Do I need a writer to commit changes in an existing table column?

I am reading in an ESRI File GDB, and using several attribute transformers to populate existing fields. Everything is working the way that I want it to (looking at the inspector), however the changes are not being committed to the tables when the translation completes. Do I need to have a writer in place to commit the attribute changes to the table? Is there something else that I need to add to tell the process it is complete, and the changes can be committed? I am not looking to create any outputs just update the attributes that I have targeted.

545

1 year ago

4dlink

asked in Transformers

Hi. I would like to create a workspace that can convert various points shape file into kml/kmz.

I could make a simple workspace that can convert from shape file to kml, but it is only allow to covert one specific shape file, due to the Name/attribute value differences for each shape files. Therefore, I would like to make a workspace to available to convert various shape file having different Name/attrbute value that can automatically read/extract each file attribute values, beyonds files and allows to select to show in output Kml file. i.e.) set varrious attirbute value available in Kml property setter. I'm very beginner, so my question is bit silly, but if you have some suggestions, idea, method, that would be really helpful. Thank you for your reading.

151

1 year ago

jonathanklarup

asked in Transformers

Create 3d donut polygon with an incline of 1.2 percent from center to edge?

I'm trying to Create 3d polygon with a center polygon and a buffer around it, I need to have an incline of 1.2 percent from the center polygon towards the edge of the "buffer". Hope someone can help, and thanks in advance. I've come this far, but I'm missing something:

1 year ago

lukas108Contributor

asked in Transformers

Is it possible to create straight labels along curved lines with MapTextLabeller

Hello. Is it possible to create straight labels along curved lines with MapTextLabeller? Usually this transformer creates curved labels spread out to every single letter that I do not want. Lukas

166

1 year ago

nicholasContributor

asked in Transformers

How to read a JSON file from waze

I have a JSON file from waze that I am trying to read.I am using the JSON (JavaScript Object Notation) reader.There are three schema; alerts, irregularities and jamsI can read alerts okay with this queryjson["alerts"][*]Flatten Nested JSON values into Attributes = YesRead Entire Feature as JSON Fragment = Nowhich reads 433 alerts, each with a location.x and location.y which allows me to built a point object (Vertex) for each feature.But I am struggling with the irregularities and jams.The irregularities have a line object which obviously does not convert into two neat columns.How do I read the line object?I have attached the json file here

681

1 year ago

spidermanContributor

asked in Transformers

Problem to extract coordinate of start and end point of line

I have lines , I have used coordinator extractor with index 0 , coordinate extractor with index 1 so I got start point and end point for each line .but I have still few lines ,although I see them in inspector as lines but the coordinates that I extracted for each line of them by coordinate extractor transformer ,has same coordinate for start and the same coordinate for end of line as attributes what is the reason of that ?how could I get coordinate of start Point and end point for theses few lines but it should has different geometry in start rather than end FME 2021Thanks for help

1203

1 year ago

dallas2011Contributor

asked in Transformers

Add a new column which include the previous column data type(string, data ect)

Hi, I have a question, I would like to ask if it is possible to insert a column that contains the character encoding of the previous column.Do you think it is possible to do this?

1 year ago

smfks911

asked in Transformers

How to add an attribute in files exposed by File and Path directory transformer?

Dear Altruist, I have a consistent series of excel files but saved under different folder in respect to model_run no. Now I would like to add a column in each of the excel files as per the folder name that file is situated in. I have used 'Directory and File Path' transformer to expose all those excel file and used stringsearcher to create a column that extracted the folder name from the path. Can anyone please tell me how can I add the folder name as an attribute to the individual excel file?regards/

6310

2 years ago

zacharylee1204

asked in Transformers

Matching two tables and output result

Dear Sir / Madam, Actually I am trying to match two excel table values (attributes name from two different samples). In the excel, I have one matching table and two models attributes in two tab sheet. I would like to compare the value with Model 1 and Model 2 based on the matching table. For example, apple matching apple. However, some of the naming are not exactly matched with wording and are slightly different, such as Pineapple in sample 1 is equal to USA_Pineapple in sample 2. Is it possible to do that? Also, if possible, could it be not case sensitive? Then, I would like to perform a value check on two samples based on the matching table I provided. The result that I want to get is on the "Output Sample" tab in orange colour. I have attached my sample data here. I hope you understand what I said and I hope it is possible to do that. Thank you all and have a good day!

2345

2 years ago

arjanboogaart

asked in Transformers

Uploading files using python via data upload service

I want to upload some files for a specific workbench using HTTP.I'm using Python for this with requests library, but I'm having difficulty getting it to work.My python code is as follows: with open(file_path, 'rb') as file: url = f"{fme_url}/fmedataupload/{script_location}" data = { 'custom_file': { 'value': file.read(), 'options': { 'contentType': 'application/octet-stream', 'filename': file_name, } }, 'opt_namespace': directory, 'opt_fullpath': True } token = get_token() headers = { 'content-type': 'application/x-www-form-urlencoded', 'Authorization': f"fmetoken token={token}", } return requests.post(url, data=data, headers=headers, json=True)I do get a 200 OK response, so authorization is fine, but the file isn't uploaded.It even creates a directory at the right spot.The response is as

19010

2 years ago

mariakaContributor

asked in Transformers

RasterCellValueCalculator with overlapping images

Hey there,I'm struggling with the RasterCellValueCalculator. As I have raster files which are not congruent to each other and not of the same resolution (but overlapping), the transformer doesn't calculate properly. It's just a simple substraction.I already tried to bring the rasters to the same resolution.Can anybody help?I added a sample workspace. Cheers,Maria

2 years ago

fikusasContributor

asked in Transformers

Expose elements doesn't work in FME 2020 ?

Seems like exposing elements in AttributeSplitter doesn't work in FME 2020.0.1 (build 20218). Even exposing attributes after splitter with AttributeExposer is broken.Or maybe it's Data Inspector's fault for not displaying them. Any thoughts on this?

3616

2 years ago

ed31500

asked in Transformers

As a rookie of FME, i have an attribute call JEAN i want to create in the attribute , two choices of values in a string to use it in QGis Attribute : JEAN string : Yes or No How can i do please ? Thanks

2 years ago

maeldan

asked in Transformers

Hi I need to sort in ascending order and only keep the first 4 rows of the result. So I used a sorter but I can not find how to limit the number of rows in output. Thank you

152

2 years ago

jimoleary

asked in Transformers

Is there a way to trigger ALL of the schedules in an automation to run?

In the Manage Automations page I can select and automation and then select Actions, but the Trigger Automation item is greyed out. Do I have to trigger each schedule in the automation manually?

2 years ago

lribot

asked in Transformers

Problem with JsonTemplater and Aggregator

Hi!I have a problem with a Json Templater and an Aggregator. I would like to have this result :In my data, I have two items (Json_fragmenter_19) and I need to aggregate them to match with the result I want.I do this :I tried different code in the JsonTemplater but it doesn't work.Can you help me?Thanks Laura

2 years ago

bobakebi

asked in Transformers

Connect points following a road centerline

Dear FMEI want to connect a series of points that follow a certain road alignment.I have a set of point data that are snapped to a road alignment. The point data were registered by different equipment several times in a year. Unfortunately, the point data do not distinguish between different equipment. However, there are two registered dates for each point data that follow the from-to principle. I used these dates to find the sequence and then use them to connect the related points to each other. Even though I was able to create convex from the related points, the built convex were linearly connected.What I would like to attain is to find a method that can link the points based on the road alignment. I gave the point-to-line-overlay transformer a try, but it was not successful! I think the problem was basically because of not having attributes that could be used for grouping!If that was the case, does anyone know how I should assign an ID counter for the features that fulfill a certain

282

2 years ago

neaContributor

asked in Transformers

I'm trying to rename AutoCAD layers. Reading from DWG and using a FeatureWriter to write to DWG. In between I have a SchemaMapper with Source and Destination layer names mapped. Using MapAttributes in SchemaMapper. Not successful.

I have used SchemaMapper successfully with CAD to GIS conversions but apparently CAD to CAD is different. The output DWG has all the layers in the DestinationLayer column of the crosswalk.xls as well as the SourceLayer layers. No redefinition takes place.

311

2 years ago

phillip_bowman

asked in Transformers

Is it possible to auto assign different point fonts based on table data. ie. assign differnt points to pit, pole, electrical, water ect. I have a .tab to edit. I have some blocks from autocad, it is possible to use these? Would

2 years ago

zacharylee1204

asked in Transformers

Merged all layers of CityGML Model into one single 3D model

Hello Sir / Madam, So I have a CityGML (.gml) 3D model, it has three layers - Bridge, BridgeConstructionElement and BridgeInstallation. I am just wondering is there any way that I can merge all layers into one single 3D model? As I will have thousands of models that might be divided into different layers, I need to find a way to group all the layers for each model. Then, I can analysis the data later. I tried "Deaggregator" and "MeshMerger" but it seems like it is not working.I would really appreciate if anyone can give me a hand. I have attached a sample data below. Thank you very much.

577

2 years ago

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

Page 91 / 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,161: 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.