Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,684 Posts
50,748 Replies

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

12684 Posts

Recently active

Most replies Most views Newest first

ngstokeContributor

asked in Transformers

Query A Date Field To Only Return <=90 Days From Current Date

I'm trying to develop a workbench that will only return records from Excel spreadsheets that are within 90 days from the current date when I run the workbench. I'd like to not have to enter the current date every time I run the workbench. Is there an expression I can use or a transformer to perform this.Any help is greatly appreciated. My dates are formatted as seen below. 20170525201706242017070820170902

kumarkannan1980

asked in Transformers

Hi, How to create microstation cell contains data fields from Oracle spatial to Microstation v8 format.

asked in Transformers

Reading a segy file, is possible to fine tune how the byte are read?

I was thinking something like Seisee (http://www.dmng.ru/en/freeware.html)

asked in Transformers

How can I reduce the size of a raster mosaic made by the mosaicker. The geotiff mosaic is about twice the size of the edge matched tiles - made by Pix4D.

gisgeekContributor

asked in Transformers

Buffer Coastline

Hi I am trying to add a 30m buffer around the coastline. See the attached file. Unfortunately with the buffer tool I am not getting the results I want. It buffers all the polygons so I get overlaps between polygons. I've tried a few things but not getting the right results ie. area on area but this is not working for me as all I get is all the overlapping bits

katericondoContributor

asked in Transformers

Remove decimal and decimal values without rounding.

Say I have 105.6546 and 5646.546356, how can I drop only the decimal and values to the right of the decimal? So my final values will be 105 and 5646.

asked in Transformers

Invert polygons

I have the sea as polygons in an esri shapefile. But now I need to invert this - I need to make polygons of everything that is not sea. How do I do this? I have tried searching for FME help on "inverting polygons" and other related, but no luck, there must be such an transformer though... :) ?Thanks,Ben

asked in Transformers

TestFilter with similar test conditions or Multiple Testers?

I have a set of Rain Gage Thiessen polygons where I would like to test for the IDs that are in a certain area. The areas of the Thiessen polygons and the underlying areas overlap, so there are instances where a Rain Gage may need to go to multiple output ports for further calculations.TestFilter uses If...Then so if I test for RG #6 to go out output port 'A', I am assuming that it will never go out port 'B'. One solution is to connect the input ports to multiple Testers in parallel. This ensures that RG #6 goes to both areas. This works but I'm trying to see if there is a transformer or more efficient process where a single input record can go out multiple output ports.Thanks!

asked in Transformers

How to stop a workspace when a tester fail?

Hello!I have two features set that i want to check if they have the same geometry. I am using a tester to do that check. My question is: how can i make the workspace halt if the tester fail? Is some sort of transformer or parameter that stop the running workspace if a tester fail?Thanks for your help!

asked in Transformers

SQLCreator unable to read published paramters in SQL statement

In my SQLCreator Parameters, I have created the following statement in the SQL Statement:SELECT * FROM contributor_dg.$(THEME)_$(AOI) WHERE SUPPLY_DATE = '$(SUPPLY_DATE)';...$(THEME), $(AOI) and $(SUPPLY_DATE) are all published parameters.I was able to run the process with no issues on version 2015.0. Since upgrading to 2015.1 and opening the same workbench with 2015.1, I can no longer expose the attributes based on the above sql statement. An error "Failed to execute the SQL Query" appears saying of an syntax error at or near "$".This is the log that it generates:FME Configuration: Using Named Connection values from 'xxx' for R_11Creating reader for format: PostGISTrying to find a DYNAMIC plugin for reader named `POSTGIS'FME Configuration: Source coordinate system for reader R_11[POSTGIS] set to `LL-WGS84'Coordinate System `LL-WGS84' parameters: CS_NAME=`LL-WGS84' DESC_NM=`WGS84 Lat/Longs' DT_NAME=`WGS84' GROUP=`LL' MAP_S

asked in Transformers

How to log output from an SQL excutor

HiI have a SQL executor which fires some sql queries to an oracle DB.They are very simple update statements where the where constraints come from attributes of the feature.The strange thing is that when I run a set of ~ 12000 features, I got ~ 10 where the sql executer queries seem to have not been executed. I.e. I expect to see updated records in the DB for all features in the set, but ~10 fail.Is there a way to log the sql executer transformer so it outputs every single sql that it fires to the DB?I want to see what the exact sql query is for a feature that fail.I know it would be a huge log, but I don't see a reason why 12000 will update OK and 10 won't.

asked in Transformers

Aggregate row values if a column cell value matches in Excel

Hello All,I am trying to aggregate values of rows if specific column values match with another row in the same column. I also want to add that value in that cell which has a higher value. for an example; In the provided screenshot Pararun 111 &112 have duplicated values. They exist in row 8, 9, 25 and 27. I want to sum up Pararun 111 values in row 8 and 112 in row 27 because row 8 and row 27 have bigger value than row 9 and 25.

asked in Transformers

List all attributes actually used in an workspace?

I have a change-detection workflow that triggers another workflow whenever input feature(s) changes. I need to fine-tune this process even more. Say for example, if the input feature(s) has 1000 attributes, the attributes relevant to me are only 100. I need the change-detection workflow to trigger only if any of those 100 attribute value changes. Is there a way to only get a list of attributes that are actually used inside the workflow?

asked in Transformers

How to Convert from SQL Server to MongoDB with Embedded Attributes

Hey,Sorry but I could not find an Answer on this Topic. (Generally the Tuts from safe are Kind minimalistic)To my Question how can I convert from Sql Server to MongoDB with Embedded Attributes.In SQL I got this 3 TablesTable Parts// Cardinality to Prices (1:n) and Archive (1:n)IdName...1Ball..............Table PricesIdPrice...11,50€............Table ArchiveIdOldPrice...11,49€...........The Simple 1 to 1 Convert is workingThe 3 Tables are Identically in my MongoDB as 3 Collections.But I want to have 1 Collection ( 3 in 1 as "BestPractice of MongoDB")https://docs.mongodb.com/manual/tutorial/model-embedded-one-to-many-relationships-between-documents/But I cant find a Transformer for this or other Functions?How can I achieve something like this{//Parts as Primary _id : 14011, isATPart : 0, SuppID : ["BMW","MINI"] ... priceByCountry:[{ Prices countryStr: "DE", CurrStr: "EUR", .... archiv:[{//Prices_Archiv price : 2,50€, date : 31.02.17, ListId: 1234 }, { price : 2,50€, dat

jeroenContributor

asked in Transformers

Cluster lines near each other into a single polygon

I'm working on a dataset that contains piano like clusters of lines that i want to merge into a single polygon per cluster.Example from the source in autocad:The end result will look the same but than it should be a polygon containing 3 features in stead of lines. So the line width contains information for making the polygon. But how do i group them together after or before i change them? Is there an (easy) way to group them with a certain buffer or would the neighbor finder be easier?

asked in Transformers

Some source data has not been used

Hello, I want to aggregate shapes from several subdirectories that have the same path and name structure. So "SourceDadtaset_SHAPE" = N: \\ service \\ group \\ thematic \\ ** \\ shape \\ unites _ * _ 2.shp. The script reads all shapes correctly, says the transaction was successful but displays "Some source data has not been used. This can happen if the dataset is changed or if a feature type is renamed or Deleted. " However, it is not the case Do you have an idea ? Thank you

kumarkannan1980

asked in Transformers

Hi, How to write tagset to the microstation element programmatically (c#.net) . Kindly let me know

oscardInfluencer

asked in Transformers

Python and FME Server - Unprocessable Entity error

Hi.I want to run a workspace using the Python script I have pasted here. But everytime I run it, I get the following error:HTTP Error 422: Unprocessable EntityMy Python version is 2.7.FME Server 2016Thanks for any help provided!import urllib2import jsonSERVER_URL = "http://100.100.100.100"REPOSITORY = "MyRepo"WORKSPACE = "First%20Test.fmw"TOKEN = "ddddddddddddddddddddddddddddddddddddddddddddddddd"# Set up the published parameters as objectparams = { "publishedParameters" : [ { "name" : "path_1", "value" : "C:\test1" }, { "name" : "path_2", "value" : "C:\test2" } ]}url = '{0}/fmerest/v2/transformations/commands/submit/{1}/{2}'.format(SERVER_URL, REPOSITORY, WORKSPACE)# Request constructor expects bytes, so we need to encode the stringbody = json.dumps(params).encode('utf-8')headers = { 'Content-Type' : 'application/json', 'Accept' : 'application/json', 'Authorization' : 'fmetoken token={0}'.format(TOK

asked in Transformers

Using SurfaceDraper to extract multiple z-value of a point on a surface model

Hi all,I have few points with known x and y coordinates. I can successfully use SurfaceDraper to extract z-value of those points. But it seems to get one z-value for points touch on one surface. If I have a point that can touch two surfaces, I cannot get two z values but any one only. How can I get two z-values?Is there any other transformer to extract multiple z-value of a point on multiple surface?Thanks

asked in Transformers

AttributeValidator - problems setting up Minimum Length Operator

Hi , I’m having problems configuring the ‘Minimum Length’ Operator in the AttributeValidator Transformer. Ideally, I would like it to test that the minimum length of characters is greater than 8. When I run the Translation I get the following message: An error was encountered evaluating a TestFactory test: Illegal operator `MINIMUM_LENGTH' supplied for test evaluation -- operator must be one of < > <= >= != = == I believe the issue is with my incorrect settings in ‘Rule Configuration’ column. Does anyone have a working example of how to configure the ‘Rule Configuration’ using the ‘Minimum Length’ Operator? Many thanks

asked in Transformers

How to prevent connectors to autosnap to transformers. I want to turn off this feature. I want my connectors to stay put until I move them myself!,How prevent that connectors on the canvas auto spap to av transformer

tim_woodContributor

asked in Transformers

WARNING & TIP! %Y%m%d%H%M%S Date/Time values in CSVs are NOT the same as FME Date/Time (%Y%m%d%H%M%S)!

I have CSV files with dates in the format %Y%m%d%H%M%S e.g.Mobile Inspection,Cancelled,20140905151941,20141107130117I'm using the CSV2 Reader in FME 2017.1 (17271) and reading in all CSV attributes as string.In DateFormatter, if I set my Source Date Format to FME Date/Time (%Y%m%d%H%M%S) and my Destination Date Format is %d/%m/%Y %T (I've also tried %d"/"%m"/"%Y" "%T), all I get is the Invalid Date value.However, if I set my Source Date Format to %Y%m%d%H%M%S and my Destination Date Format is %d/%m/%Y %T it works!So even though you might think FME Date/Time (%Y%m%d%H%M%S) and %Y%m%d%H%M%S are equivalent, they're not (at least not when reading CSVs).

asked in Transformers

Lines connected?

How can i check, if all my lines are ahve a connection to each other. I have a net of multilines and i want check that all lines have a connection to min. 1 neighborline. Case: Can the bus drive from point 'a' to the point 'b' without any interrupt way/lines.?

asked in Transformers

How to Change multiple substrings at one with StringReplacer?

I'm new to FME so sorry for a noob question.I have a text file that is in the below format. How can I replace the characters with an index of 15:15, 25:25, and 30:30 with just the '|' character (pipe)? There are only spaces in now. I have been trying to use StringReplacer and set the "Text to match" with @substring ( , 15, 15) but it doesn't work. Do I have to do each replace with it's own transformer or is it possible I can also do this with one StringReplacer?Thank you in advance!Characters 1:1415:15Characters 16:2425:25Characters 26:2930:30Character 31:31XXXXXXXXXXXXXX XXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

asked in Transformers

Strange side-effect of coordinateRounder

I seem to have a strange problem with the coordinate rounder. It looks like a bug actually, as I didn't have this issue in FME2016: I have read some features from an autodesk drawing (dwg). After using my coordinateRounder the information about entity type is deleted (see also the figures 1-3). It isn't that hard to make a workaround for this issue, but I don't understand why this is happening. I already found out that this isn't always happening with coordinateRounder.Does anybody have an idea?

1
...
392
393
394
395
396
397
398
...
508

Page 395 / 508

Badge winners

palmercd473has earned the badge English Speaker
davtorghhas earned the badge Student (Bronze)
davtorghhas earned the badge Student (Grey)
davtorghhas earned the badge Expert (Grey)
davtorghhas earned the badge Teacher (Bronze)

Show all badges

30,177: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

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.