Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,682 Posts
  • 50,740 Replies
12682 Posts
Z
zacharylee1204
asked in Transformers
HTML Report Generator - Time Output Problem

Hello everyone, So I would like to generate a HTML report by using "HTML Report Generator".For the final product, I would like to generate the report with the "current time" on the HTML page. This is what I write in the text editor:   KE Indoor run on @DateTimeFormat(@DateTimeNow(local),ISO) The output is:   KE Indoor run on 2022-01-18T16:58:52.1754106+08:00 However, this is what I want for the result:   KE Indoor run on 2022-01-18 16:58:52 May I ask how can I fix the problem? Thank you in advance.

154
Z
2 years ago
od10
Contributor
od10Contributor
asked in Transformers
Best way to generalise contours

Hello,  I have an issue with generalising contours inside a tiling system. All contours need to match at tile edges, hence a surface tolerance of 0 is required. When this happens, vertices are added in what seems to be every 0.1m. Therefore i need to generalise.  The standard generalizer causes overlaps between different elevations, so the only option is sherbendgeneraliser but it takes an age with the amount of vertices. I have tried adding a generaliser with 0.1 tolerance before the sherbend generaliser but this also causes overlaps. I want vertices roughly every 5m or so in the output. Question:How do i fix these generalised overlaps?is there a quicker way to speed up sherbendgeneraliser?

1190
od10
Contributor
2 years ago
lambertus
Enthusiast
lambertusEnthusiast
asked in Transformers
User experience - Asynch HTTP Caller

I consider to replace my Http callers by the Asynch Http caller.  I am curious whether other users have experience with this Asynch HTTP Caller. This is related to this idea which is worked out in a transformer.  Because the test suite states 'failed', I doubt whether I can use this transformer safely. Anyone experience with this transformer?  

370
lambertus
Enthusiast
2 years ago
fme_can_do_it
Supporter
fme_can_do_itSupporter
asked in Transformers
truncate table and append

I need to truncate the existing table and append data. I have two tables one from versioned sde and the second table is in FGDB. I need to delete rows from the table in sde and append data from FGDB. I have to do field mapping after appending data from FGDB. I am not sure what would be the workaround to accomplish this task. Please suggest any workaround.

7730
fme_can_do_it
Supporter
2 years ago
birgit
Enthusiast
birgitEnthusiast
asked in Transformers
TIN Surface to Raster - Quality problems with RasterDEMGenerator

Hi, I am having problems with converting a TIN surface to a raster with height information. The input data is a LandXML which contains a surface of type IFMECompositeSurface. Right now I feed the surface into the RasterDEM generator with the following settings: The coordinate system is EPSG:28992 so the surface tolerance is set to 1cm, however the results are quite jagged:To give you a sense of scale, the image above is for an area of around 1300 meters wide so the the jagged points seen above are sometimes a 100 meters wide. To check my results I decided to convert the result to a pointcloud so I could take a look and compare it with the original surface in the 3D view in FME Inspector. In the image below you can see that the pointcloud that was created from the raster actually dives beneath the original surface:Does anybody have an idea what could cause these problems? I a doubting whether the RasterDEMGenerator is the right transformer for this job. I already have a workaround whe

1140
birgit
Enthusiast
2 years ago
F
friedhelm
asked in Transformers
Hi there, I am looking for a transformer or a solution that allows me to check if any attribute of a feature has a specific value (e.g. string "remove"). Only then I want to remove the attribute. Renaming would work as well. Thanks for your help.

Hi there, I am looking for a transformer or a solution that allows me to check if any attribute of a feature has a specific value (e.g. string "remove"). Only then I want to remove the attribute. Renaming would work as well. Thanks for your help.

110
F
2 years ago
T
ts_84
asked in Transformers
How to calculate the percentage of 'nodata' cells in a raster file?

I'm trying to calculate the percentage of nodata cells within a raster by using the point cloud combiner + point cloud splitter in fme to extract the value of cells with data vs cells with nodata, and get a ratio.  It's clearly not the right approach as it is taking forever. Is there a better way to do this?  Usually it would be fore raster tiles with 1,000,000 cells. Counting the nbr of nodata cells in each file basically  

550
T
2 years ago
B
byjukattoor
asked in Transformers
Looking for sample python code (for PythonCaller transformer) that can iterate through various parts of a feature geometry and process part's coordinates.

Hello , I have a feature geometry with two parts (IFMEMultiArea with two IFMEPolygons). Using PythonCaller transformation, I want process line segments in various parts of the geometry.Is there an API for getting the coordinates of any part of geometry?I am able to get the part count as follows: partsCount = feature.numParts(True,True) I can get the parts as follows: areaPart = feature.getGeometry().getPartAt(0) But I could not find a suitable API for getting coordinates of a particular part in the API documentation. Thanks in advance. Regards,Byju  

735
B
2 years ago
A
artec186
asked in Transformers
Add color to Point Cloud, hello dear community, i have a point cloud in a .xyz format, only with coordinates. I would like to add sth. like a color or a height ramp, which depends on the height of each value and gives each point an unique RGB valu

Add color to Point Cloud, hello dear community, i have a point cloud in a .xyz format, only with coordinates. I would like to add sth. like a color or a height ramp, which depends on the height of each value and gives each point an unique RGB value.

420
A
2 years ago
richemcd
Contributor
richemcdContributor
asked in Transformers
How can I get FME/AttributeValidator to recognise 2.0000000 as 2.0000000 and not as 2. I have a field with a Type Double, but FME brings the values in as whole numbers, even rounding up, so 2.9999999 becomes 3. I want to stop this behavour...if poss

I have checked with other values and 2.1234567 is fine and so is 2.8888888 and 0.1234567. this issue only happens with whole numbers 

260
richemcd
Contributor
2 years ago
T
timkoers
asked in Transformers
How to get build in topology from OSM XML

Hi,I have been playing around with FME Desktop for a great while now and I think it's definitely capable, however, my knowledge lacks a bit here. I am trying to convert an OSM XML (Luxembourg for example, but not limited to) into a couple of information levels:level 0point (equals nodes)xyz id (equal to node id)node id/indexFace idline (equals edges)xyz idedge id/indexfrom node idto node idleft face idright face idpolygon (equals faces)face id/indexedges{}.edge_idedges{}.orient (boolean value of all_edges{edge_id}.fknot > all_edges{edge_id}.tknot)level 1point (equals nodes)point id (this correlates with the level_0 point id of this point)desc id (type parameter, maps to an array of strings)feature code (an integer, which maps to an array of strings)attributes{}.segmented_attr_idnodes{}.node_id (all the level_0_points that are connected to this point)line (equals edges)line id (correlates with level_0_line id of this line)desc id (type parameter, maps to an array of strings)featu

180
T
2 years ago
R
robyn_studts
asked in Transformers
I need help with translating a shape file into SmallWorld. I am having problems finding any info on the subject. Was hoping to get some example code so I can move forward . I usually translate from Smallworld to MicroStation

I need help with translating a shape file into SmallWorld. I am having problems finding any info on the subject. Was hoping to get some example code so I can move forward . I usually translate from Smallworld to MicroStation

60
R
2 years ago
W
wooter
asked in Transformers
How to Generate multiples lines from sequenced points

Hello, I'm looking to generate a number of lines from coordinate data within a spreadsheet, each with distinct start/end points, but grouped by a common attribute. Each of the points are ordered numerically (and geographically). Using LineBuilder seems connects all points in a line to eachother, rather than creating one line sequentially. The image attached shows how the relevant data is organised, so with this data I'd need 3 lines, one each for group A, B, and C, with each line each starting at point 1 and ending at point 5.  Thanks for any help!

200
W
2 years ago
ekkischeffler
Contributor
ekkischefflerContributor
asked in Transformers
How to write IFC Material Layer

I'm manipulating an IFC file, writing it back to IFC with a few changes. So far I couldn't figure out how to write a Material Layer Set. I can see it is defined in the geometry traits of my original IFC file but when I write it back out it seems to remove the information. Has anyone done this?Geometry traits on original IFC:Original data:IFC file translated with FME:

870
ekkischeffler
Contributor
2 years ago
nissedahlsten
Contributor
nissedahlstenContributor
asked in Transformers
AGOL Featureservice writer - writing integer to string field converts to float with one decimal

I'm writing data to a hosted ArcGIS Online feature Service, one field is of type string but I sometimes writes an integer to it. When I do that the number is converted to decimal. So 25 becomes 25.0.Has anyone solved this (without adding a space at the end)? 

490
nissedahlsten
Contributor
2 years ago
R
richard_che
asked in Transformers
Is there a Transformer that lets you download OSM/Openstreetmap Address points for a country?

Is there a Transformer that lets you download OSM/Openstreetmap Address points for a country?

160
R
2 years ago
lance
Contributor
lanceContributor
asked in Transformers
Issue running workspaces from Python

We are using FME Desktop 2022.0 Beta and have created many workbenches for nightly data processing. I want to run these in varying sequences using python but cannot get fmeobjects to load. We are running Python 3.7.11 64-bit (arcgispro-py3:conda) installed with ArcGIS Pro on a windows machine. The following code fails on import fmeobjects: ImportError: DLL load failed: The specified module could not be found.import syssys.path.append(r"C:\Program Files\FME\fmeobjects\python37") import fmeobjectsI see many posts pertaining to this issue but none of the recommend approaches work. I have also tried adding the path above to my PYTHONPATH with the same results. Input?  

241
lance
Contributor
2 years ago
jfd553
jfd553
asked in Transformers
Is it possible to set fme_geometry at runtime using an attribute value?

ContextI am building a custom transformer. I need to transform input features into points to process them and then build back the features geometry before to output them. Output features are expected to have the same geometry type as input ones. ProblemI thought I could just reconstruct the geometry of the features using the LineBuilder transformer, but it creates polygons with closed lines, even when the input feature is a line (fme_line), not a polygon. QuestionHow can I reset the features geometry to their original ones before sending the features to the output port? The GeometryCoercer could do the job if I could set the output geometry at runtime (e.g. using an attribute with original fme_geometry value).

1310
jfd553
2 years ago
J
jhc36
asked in Transformers
Importing into Smallworld Error (using shapefiles) with the the spec_id field (mandatory).

I have imported data, from a shapefile, into an existing object in Smallworld before but we recently acquired a smaller Telco and will be importing their data into ours. I have a reader (shapefile) transforming into an existing object in our Smallworld writer.  In the type_ field of the shapefile there is data that matches what the spec_id should be in the SW object, and the spec_id field is an enumerated (integer-string) list. I have changed the data on the shapefile side to match what the spec should be, both integer wise and string wise. I'm still getting the Translator Error: Value "x" not in enumerator set.  I've tried to run just a basic import without setting the spec_id field from the shapefile and I get specification is mandatory error in the magik prompt box on the SW FME session. I'm sure this is a user based error, but have tried this on multiple objects and still running into the spec_id issue.  Thanks for any help.   

120
J
2 years ago
rtreecare
Contributor
rtreecareContributor
asked in Transformers
FeatureWriter writing GlobalID and GUID as Strings

I am using a featurewriter to overwrite 2 feature classes in a file geodatabase. The attribute definition panel shows the correct GlobalID and guid types. However, the result is string fields. Any ideas?

400
rtreecare
Contributor
2 years ago
superjets
superjets
asked in Transformers
Generating several new attributes with value in name

This has been asked before, at least here and here.  The problem is best described in the picture, with the starting point on top and desired outcome below. The data is huge, so manual attribute creation is not an option, the attributes should be generated like "Year@Value(number)" and "Explanation@Value(number)"I have tried the method used in these, with AttributeCreator with every option I can imagine, but to no avail. I've used it in conjunction with AttributeExposer, but without any good outcome.  Dear all, is there a solution to this?

400
superjets
2 years ago
Z
zacharylee1204
asked in Transformers
Not sure how to match the data

Hello, here is my question. I have two table. The first table is like a glossary. The second table is the input data.​Table 1 (glossary)​Number Fruit1-1 banana;apple <= (meaning can be either banana or apple)1-2 orange​Table 2 (Input data)Number Fruit1-1 banana1-1 apple​So my goal is to see if table 2 match with table 1. I have a input data (table 2). Both are number 1-1 and the fruit name also match with table 1. Hence, both the result should be passed.  However, I am not sure how to do the matching. As the table 1 fruit name is "banana;apple", separating by ";". I would like to have some guidance. Thank you very much!​

70
Z
2 years ago
C
chithramc
asked in Transformers
How add unique ID/Value to an Element

Hello friends,Im a new user of FME. I have a dgn file with hundreds of points with or without tags. i need to convert this dgn to shp with unique custom ids. Is it any procedure or transformers to do this in fme. I mean each point have unique id numbers I tried with many videos and tutorials didn't solve my issue thanks

240
C
2 years ago
S
steve.mohawk
asked in Transformers
Modifying a nested attribute value with JSONUpdater

Hi, I'm looking to update a value of an existing JSON structure once it has already been constructed.I feel I'm using JSONUpdater for its correct purpose, but might be messing up the syntax. Attached is how it looks for me:Does this appear to be the correct syntax for trying to modifying a nested key/value pair?I also wonder if using the attribute "ProgramProfile" for the JSON Text field would be a better approach, as it does show up in the list of selectable attributes. I have not had luck with this approach either though. JSON sample being used:{   "UserInfoList" : [      {         "IntegrationUserID" : "123456789",         "UserProfile" : {            "FirstName" : "Johnny"         },         "ProgramProfile" : {            "UserCategoryName" : "PLACEHOLDER"         },         "AddressProfileList" : [            {               "CountryName" : "Japan"            }         ]      }   ]} 

680
S
2 years ago
amdubois
amdubois
asked in Transformers
How to limit processing extent using search envelop

Hi, I'm fairly new to FME. I'm curently trying to set up a workbench that reads data from multiple sources and merges it. However, I have to be able to work repeatly within a specific extent which is provided with a shapefile (see pic below). For now, I just wan to manually input a shapefile with one feature ( hopefully I manage to find a way to loop the procedure with many features but that might be for another question). Right now, I can't seem to be able to pass the extent coordinate (which I get from a BoundsExtractor) to the search envelop of a FeatureReader. This post (https://community.safe.com/s/question/0D54Q000080hXiFSAU/assign-bounding-extents-to-reader-search-envelope) talks about using spatialFilter after the Feature Reader but that means I have to read ALL the data and then filter it (which I don't find very optimal).  Has anyone have an idea on how I can go around this?Kind regards,Anne-Marie  

640
amdubois
2 years ago

Badge winners

Show all badges
30,171
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.