Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,742 Posts
50,970 Replies

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

12742 Posts

rylanatsafeSafer

asked in Transformers

What are your Tips and Tricks for Anonymizing Data?

While working with customers and sensitive data, we on the Safe Software Support Team often run into road blocks troubleshooting issues when FME Workspaces and source data cannot be shared (nor can an NDA be arranged in a timely manner – and for this argument, neither can a screen share be arranged).There is an excellent Knowledge Center article that takes a real world example, and provides a tutorial with many actions the user can take to anonymize sensitive data.Particularly the following techniques are used:- Removing Attributes (AttributeRemover, AttributeManager) - Renaming Attributes (AttributeRenamer, AttributeManager) - Replacing Attribute Values (AttributeManager, StringReplacer) - Geographic Manipulation (CenterPointReplacer, Offsetter) What actions do you take, or what do you think is missing from this list? Are there any custom transformers that could help? And is it possible that a custom transformer could be created to aid in automation of this practice?Looking forward to

oliverakaranovi

asked in Transformers

How to remove extra coordinates?

Hi! I have one problem with coordinates of my objects. For example, I created a simple cube in Revit and exported to IFC file. After that I opened file in FME Data Inspector and I have 24 vertices or coordinates instead of 8 which I think I should have. So they are tripled. Therefore, when I calculate volume it is three times bigger. On the other hand, area calculator works fine. Is there any possibility to remove coordinates and leave only one for each vertex or maybe something else is a problem?

tonoContributor

asked in Transformers

How to convert a surface into triangles without using SurfaceModeller transformer?

I have a fme_surface and I need to clip it. As long as it is not possible to clip a fme_surface, I have tried to extract triangles from that feature and then clip them. Is it possible to extract triangles from a fme_surface without using the SurfaceModeller?

asked in Transformers

Results shown to the Data Inspector, but not written out?

I have a very simple workspace which is basically 3 steps: readers, UpdateDetector, writers. It is intended to compare changes between two ArcGIS feature classes, which represent data from different years.The UpdateDetector has 4 output ports: updated, inserted, unchanged, deleted. The outputs from the unchanged and added ports seem to be more or less what I'd expect. However, the outputs from the inserted and deleted ports are not being written out to the final feature class - although the post-run numbers show that features were routed through these ports. When I preview the output in the DataInpspector, all the features from all 4 output ports are there. I thought I may be able to workaround the non-writing by doing a 'Save As' on the data in the DataInpspector, but when I try this I get a 'fatal error' with the following message: "In order to update/delete a feature in the table/feature class 'Inspector_UPDATE_area', the FME feature must have the

asked in Transformers

DWG to ESRI file gdb - Ellipse features

Greetings,I am trying to export ellipse features to an ESRI file gdb.1)Do they need any processing by a transformer first??2)Should they be exported as a line or polygon??Any suggestions appreciated.

asked in Transformers

DateTime Format Issue

Why does this not work?SSIS Errors (Since @DateTimeFormat(@Value(init_start_time),'%b/%e/%Y') at @DateTimeFormat(@Value(init_start_time),'%T'))

asked in Transformers

DateFormatter shifts time if Source Date Format setting is "Unknown - Automatic Detection"?

Hi Everybody,I am using FME 2016.1.3.1In date time format I used* Source Date Format = "Unknown - Automatic Detection"* Destination Date Format = "FME Date/Time (%Y%m%d%H%M%S)"Then if the input is "2017-09-13T16:30:01" it will output "20170913173001".Attached is the FME workspace I used for testing. Did I do anything wrong? I don't want to have the hour shifted.Thank you!

danilo_fmeEvangelist

asked in Transformers

Merger Line with attributes

Hi,My Workspace two Source : 1 feature of line and a Excel file with 3 features.The goal is bring the attributes of the XLS into a line.How can you see in my Template file, i used the FeatureMerger and after ListExploder. I have 3 lines but i need just one with all attributes.Attached my Workspace.Thanks, Danilo

asked in Transformers

How to compare attribute of previous feature and detect change

Hello, I have a sequence of points along a line. I have to detect change in an attribute (called "framing") of a point from its previous point. The points are sequential. Sequences are stored as an attribute too "sequence". I imagine I can use an AttributeCreator to create a new attribute called "change" and make the value conditional. Problem is, I am not good at RegEx or conditional statements to know what would be useful. I need to compare the "framing" attribute with only the previous point within the sequence. Not the one ahead. I have been trying to follow the example in the thread below but no luck. https://knowledge.safe.com/questions/33705/compare-attributes-from-two-features.html Eg, if there is a way to compute something along these lines: IF point.framing = point(sequence-1).framingThen, Change = No. Any help will be appreciated.PS: Working with FME 2016.0

asked in Transformers

How do you get expressions to evaluate and return a result in Attribute Manager?

I'm trying to create an attribute ("incorporated") whose value is 0 or 1, depending on the value of another attribute ("Code"). I'm trying to do this in Attribute Manager. But I can't seem to get it to evaluate. I've tried many different permutations of the expression. The attempt shown in the attachment uses Python syntax highlighting which I would assume means it would be interpreted as Python code. Anyway, it doesn't work, as you can see in the breakpoint data.

jelleContributor

asked in Transformers

Linked Transformer loses attribute values on FME Server

Hi All, I am using a linked Transformer, creating an attribute, let's say Z. Attributes X and Y already exist on the object. On FME Desktop, the three attribute values X, Y, Z are passed by the Linked Custom TransformerOn FME Server, where the same version of the Linked Transformer is installed (double checked), the X and Y attributes are lost. Attribute Z, created by the Linked Transformer is the only remaining attributeIf I Embed the Linked Transformer and republish to FME Server, the X, Y Z values are all retained.Does anyone have an idea why this happens?best regards, Jelle

pinkopoContributor

asked in Transformers

Points on Area Overlay: count points on multipart features

Hi guys,I am trying to use point overlay to get a point count over polygons, but everytime the Point Area Overlay transformer seems explode the multi-parts polygons. Is there anyway i can avoid this?Thanks!

asked in Transformers

SharePoint NTLM authentication '401 Client Error: Unauthorized'

We recently updated NTLM from v1 to NTLM v2. After this changes we getting '401 Client Error: Unauthorized' when we are trying to read SharePoint list with "Microsoft SharePoint List" reader. Our FME version is 2016.1.3.1 (Build 16716) Does FME support NTLM v1 and v2? Any suggestion here? Thanks in advance Yarko

asked in Transformers

Can FME facilitate the transfer of data between an 'acQuire' Database into a ESRI geodatabase?

asked in Transformers

Sequence of points along line

Hello all, I have a question for which I feel like the answer should be simple. But for some reason I cannot find anything in Knowledge Center or think of a way to do it. I have a network of lines with points all along them. The points are not necessarily at the start or end of a line but along them. I need to sequence the points starting from the start of a line segment to the end (it doesn't matter which direction). The first point along the start of a line should be flagged as point 1, the next as point 2 and so on. If a line branches off, the first point on that line will be point 1 again and so on. In the above example, we can also start from point 4 and go downwards in a sequence. Any help will be much appreciated. ThanksEdit: I am using 2016.0 fme desktop

asked in Transformers

Esri vs. MapInfo area discrepancy

Good afternoon, I'm working on a project where I am doing an area analysis for a set of polygons. The area is calculated in hectares in MapInfo and converted to a shapefile in FME; however, when the area is recalculated in ArcMap, the results are different at a consistent rate of 1.0039 (i.e. MapInfo: 34.6516368 ha; ArcMap 34.7855988 ha). The projection & coordinate system remain unchanged during the conversion so the area should remain the same. The same discrepancy occurs when an Esri shapefile is converted to MapInfo and calculated. Would you be able to provide insight as to the discrepancy?Thanks!

asked in Transformers

How can efficiently translate a 15G Jp2 to Jpg (old) for use in Map Proxy? Is there a better format to use?

asked in Transformers

Why does the Anchorsnapper not snap to all anchor points?

I have two point featureclasses and want to snap the points from Point_01 to Point_02. Both Featureclasses have 261 points, but after the translation, there is always only 245 snapped points and 16 which are untouched. I have tried many tolerances and snap-to-Vertex as well as snap-to-endpoints, but something is stopping the 16 points from snapping to the next point.If anyone can shed some light I would be most grateful

jdhContributor

asked in Transformers

XML Templater empty subtemplate

I am looking for a way to have a "default value" if there is no data in a subtemplate. Consider the house, village example from the help documentation. If we have multiple villages with an id, and multiple houses with a village_id, we can set the Root template to <village><name>{fme:get-attribute("name")}</name><population>{fme:get-attribute("population")}</population><houses>{fme:process-features("HOUSE", "village_id", fme:get-attribute("id"))}</houses></village>and the correct houses will be associated with the correct village. and you could end up with an output like <village> <name>Anytown, USA</name> <population>2568</population> <houses> <house> <address>123 Main Street</address> <owner>John Doe</owner> </house> <house> <address>324 Main Street</address> <owner>Jane Doe</owner> </house> </houses></vill

asked in Transformers

How to style DGN?

Hi,I want to know in detail about How to style DGN file based on attributes?What are Cell file and Cell Names?What is use of seed file and cell file?Thanks in advance.

asked in Transformers

Hi, all: I have a huge MS SQL Server Non-spatial database,each record has a "datetime" time stamp. Now I'm using "SQLCreator" to read the data. In the SQL Statement, I wrote: SELECT * FROM mytable WHERE ID='1007' AND YEAR(datetime)=2015 AND MONTH(datetime)=1 But I cannot get the data and FME say: MS SQL Server Reader: Query failed, possibly due to a malformed statement. Provider error `(-2147217871) Query timeout expired' Does anyone know the reason? Thanks in advance, Ariel

takashiContributor

asked in Transformers

Idea Pages Not Found

Hi @NatalieAtSafe, most Idea pages are not found - 2017-09-12 15:10+09. What's going on?

asked in Transformers

BngLatLongReprojector error

Hi,I'm hoping to reproject a MapInfo Tab file from BNG to ETRS89 and also extract the lat and long the process. My starting point was the bnglatlongreprojector (thanks you Safe) but I'm getting the following error when I run it: "could not reproject the geometry of the preceeding feature: Reprojector: Could not create reprojection engine".Any ideas anyone? I'm using FME 2017 Desktop.Thanks in advance,Jake

asked in Transformers

Seperate a single field values into two xml elements??

Hello Everyone, I have a field which contains table and column name together for Foreignkey using (,) and (#) seperators. I have created also List on this field already, now i am not understanding how I can make another list for getting those values. Now my result XML is looking like :bnr:table > element is getting all the table and column names now, but i want to see my XML as follows:A partial coding of my XML template is as follows: <bnr:MD_DataSchema> { let $n := xs:integer(fme:get-attribute("_element_count")) - 1 for $i in (0 to $n) let $aname := "_list_name{"||$i||"}.Spalte" let $atype := "_list_name{"||$i||"}.Datentyp" let $descrip := "_list_name{"||$i||"}.Beschreibung" let $fkey := "_list_name{"||$i||"}.Tabellenbeziehung" let $mval := "_list_name{"||$i||"}.Fehlende_Werte" return { if (not(fme:get-attribute($aname) eq "")) then <bnr:colu

asked in Transformers

Raster Expression Evaluator for segmentation

Hi,I have a pointcloud, each point has a value that spans between 0-50. I have separated these into 6 groups with the PointcloudFilter and collected these 6 categories of points into an attribute called Groups. Then I have created a NumericRaster grouped by Groups with a cellsize of 2mX2m.What I want to do now is to make them into polygons, I have tried alternative routes with success however I would like to try the RasterToPolygonCoercer, therefore I need to alter the band of the raster to my group categories. My question is how I need to formulate the RasterExpressionEvaluator so that the Coercer makes polygons based on my previous filter groups?

1
...
374
375
376
377
378
379
380
...
510

Page 377 / 510

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.