Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,710 Replies
10000 Posts
westerbrink
Contributor
westerbrinkContributor
asked in Transformers
Determine in-between alphabetic values

I've got a table with POSTCODE_FROM and a POSTCODE_TO attributes, constituting several alphanumeric ranges, for example:(from) 7887AA (to) 7887AA(from) 7887AB (to) 7887AC(from) 7887AD (to) 7887AJ(from) 7887AK (to) 7887BBEach feature has a FROM and a TO value and I would like to determine all in-between values, e.g. 7887AE, 7887AF, 7887AG, 7887AH, 7887AI. Does anyone know what (sequences of) transformers are capable of doing this?

84
westerbrink
Contributor
gis2020
Contributor
gis2020Contributor
asked in Transformers
FME desktop line divider wb optimization

Hi, I am trying to run a workspace and it fails due to memory issue. In my workbench, I am using line divider which stores feature in a temp file and it fails after a while at this transformer.Can somebody suggest what I can do to optimize the WB?

160
redgeographics
Celebrity
veyselakatay
veyselakatay
asked in Transformers
convert Multipatch 3D urban model (with texturing) to Cesium 3D tile

Hello everyoneas can be seen in the picture above , I have a Multipatch 3D Urban Model with Lod2 detail level and my Multipatch 3D urban model in GDB fileI want to convert the 3D urban model to Cesium 3D tile format.I'm trying but I can't create the json file.Can you help me

1190
virtualcitymatt
Celebrity
B
bcrowley10
asked in Transformers
JSON Validation Issue - Brackets, Braces, Commas (CONFUSED!!!)

Hello:I have an issue that I can't seem to understand. I'm new to JSON (in fact this is the first json output I've ever created). I have a structure that has a ROOT and SUB. The JSONTemplater says my current structure is valid and produces the file. However, when I run it through https://jsonlint.com/ the results are invalid. So, I looked at the output of what another area is expecting and I manually modified the file to see if the updates I made were valid. The short of it is, I need to modify what's in my JSONTemplater to add a comma (,) before each NEW record and add brackets ([ ]) around the entire output file. EVERY attempt I've made in modify the JSONTemplater has failed or I get an error. I'm loosing it! :) I've attached the file I manually revised and the one from the actual results of the workspace. Can someone tell me what's wrong with my JSONTemplater? ROOT Structure:{   "totalInvestment": xs:double(fme:get-attribute("tota

40614
B
jneujens
jneujens
asked in Transformers
Reading constant properties from an AutoCAD block

Is it possible to read constant properties from an Autocad block?Constant properties are never changing in a block and can be displayed. This is an example:It shows 1 block, with some dynamic attributes ('12 345'). The 'N' is a constant property, so there is no attribute defining it.My questions is: is there somehow a way to read this information?I am aware it is possible to explode the block and extract this autocad_text entity, but that is not the solution I am after. 

570
jneujens
lau
lau
asked in Transformers
FME Server Fault Tolerant installation - Queues behavior

Hi,I plan to install a fault tolerant FME Server 2018.1. I would like to install 2 systems that each have 2 engines. A load balancer will manage the requests to these 2 systems (as below)I have 2 questions:1/ Is it possible to dedicate one engine to a "message streaming" workflow (WebsocketReceiver/WebsocketSender). Let say the engine1 of the host1.2/ Is it possible to send "big job" only to the engine1 of the host2? In my comprehension, I will have to duplicate queues on both hosts so it seems not possible to only use one engine... Thank you in advance! Laurent 

350
lau
R
rhcb
asked in Transformers
Downloadlink MRF2dCleaner plugin

Hi there, The MRF2DCleaner plugin for FME Desktop contains some very interesting transformers. I am however, having a hard time finding the link for a trial or full version download. Where can I find that? I've already reached out to the sales people of MRF but they answered that I should ask safe for the prices and download.  Can anyone shed some light on the origin and availability of this plugin. Cheers Rolf

500
H
tbs_gis_team
Contributor
tbs_gis_teamContributor
asked in Transformers
Chart Generator

I am trying to make a chart with XY coordinates generated from the Profile Generator. I have two inputs and trying to plot both on the same chart with different color. I can run with one dataset, but when I try to run with data series it gives me this error: ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numeric.

1400
tbs_gis_team
Contributor
W
wbs
asked in Transformers
how to integrate building model

Hi, everyone, I meet some problems when converting the CityGML file to glTF file, the export city model is divided into many parts (Building, WallSurface, RoofSurface and GroundSurface). I want to know how to integrate them into one complete city model. Thanks

60
nampreetatsafe
Safer
philippeb
Enthusiast
philippebEnthusiast
asked in Transformers
Delete features from ArcSDE with a condition

I have an ArcSDE database on SQL Server 2016 and I want to delete features from a condition.Each night I want to delete thousands of points older than 30 days from now.My points layer has a datetime2 field (created_date).I thought using the SQLExecutor to do this and run this script.DELETE FROM GPSDataWHERE [created_date] < DATEADD(DAY, -30, GETDATE())Unfortunatly it doesn't work and I don't understand why. The log doesn't say much :Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Â Query Text `DELETE FROM GPSDataWHERE [created_date] < DATEADD(DAY, -30, GETDATE())'. Provider error `(-2147217871) Query timeout expired'If I replace DELETE by SELECT *, it works though.Is there any SQL beast here who would know if it's my query or FME the problem? I don't have access to this SQL Server, so I can't test my query over there.For sure I could create a procedure straightly in SQL Server, but my FME script is doing a FGDB backup of those points bef

340
philippeb
Enthusiast
marionmahot
Contributor
marionmahotContributor
asked in Transformers
mosaic and nodata

HelloI'm looking for the rasters that are in the same polygon to assemble them and then cut the mosaic according to the polygon.In this treatment I try to remove the black edges of the images to make the mosaic but I still have black pixels.Thanks D045_3P_79_4_0001.zip

670
gio
Contributor
P
pascatl
asked in Transformers
How to export data as .js?

I am using the QGIS plugin "QGIS2WEB" for publishing spatial data into webmaps, written in javascript. The plugin converts all the data showing into .js files, stored in a data registry. Now I want to replace/add spatial data manually, without using the plugin. Is there a way to convert and export spatial data, e.g. json as .js with FME? Thank you.

585
nielsgerrits
VIP
I
irene2018
asked in Transformers
aspect calculation

I have 3D polygons where I need to calculate the aspect for each polygon and add it as attribute. Is there a way to do this? I found a transformer to calculate the aspect for raster but not for vector ,is there a way to go around? Thanks !

1280
I
kumarkannan1980
Participant
kumarkannan1980Participant
asked in Transformers
Extruder transformer

Hi,I have the building data captured through stereo plotting process. My task is to create citygml using this data, when I try to extrude the feature using "Extruder" transformer(ref attached screenshot Extrude.png) the building is not extrude properly (ref attached screenshot Issue.png).Same building I tried in Arcscene using the extrusion option, it rendered properly (ref attached screenshot arcscene.png)  Kindly help me to resolve this issue. Regards,K.Jayakumar   

480
kumarkannan1980
Participant
takashi
Celebrity
takashi
asked in Transformers
Suspicious Behavior of StringReplacer

From this Q&A: Replace attribute values for all attributesMy first idea was to use a StringReplacer to replace every attribute with '0' if it matched the regex '^0*$' (0 or more '0'), '1' otherwise.I thought it should work theoretically, but the StringReplacer replaced '0' with '1' in fact.If you set a character (e.g. 'x') other than '0' to the Replacement Text parameter, it worked fine.I'm afraid that there could be a bug here. See also the attached workspace. (FME 2018.1.0.3)Original:Unexpected Result: Every <empty> was replace with '0', but '0' was replaced with '1'.Comparison: Every '0' and <empty> was replaced with 'x'.

50
takashi
Celebrity
gisuser
Participant
gisuserParticipant
asked in Transformers
Locate the overlapping in this NW as a points in a new FC

hi guys,I have an NW line FC, I need to locate the overlapping in this NW as a point in a new FC any suggest?

40
mark2atsafe
Safer
J
jofaucher82
asked in Transformers
Dissolve overlaps polygons

Hi, this is my problem :I have a lot of overlapped polygons and I would like to dissolve the intersected part with the bigger polygonI would to dissolve only the intersect part. Thank you to help me because I'm on a dead now! Jonathan

2640
B
marionmahot
Contributor
marionmahotContributor
asked in Transformers
no data white

Hello,how is it possible to have nodata in white?ThanksMarion

270
marionmahot
Contributor
gio
Contributor
gioContributor
asked in Transformers
Extract message from the terminator. Is it possible?

Is it possible and how would I do that?

2711
gio
Contributor
V
valentijn
asked in Transformers
Suggested Command-line to run a workspace doesn not work

I have a workspace that has a published parameter of type Filename (Multiple) and I have multiple files in a folder with spaces. At the top of my fmw file is says that this should be the command-line to run the workspace "C:\\Program Files\\FME\\fme.exe" "ImporteerTrimble.fmw" --DB_Service "ODSDEV" --DB_User "GVR" --DB_Password "********" --Project_ID "22"--SchemaName "INWINNING" --Bronbestand """D:\\Path with space\\file1.dxf" "D:\\Path with space\\file2.dxf"""But when I run this command line it complains that there are uneven number of command line arguments.I just can't get this to work from the command line, running within FME Workbench does work. When I remove some quotes it accepts the arguments but then the reader fails AutoCAD Reader: Unrecognized extension for source file 'D:\\Path'.

546
takashi
Celebrity
S
shintaku
asked in Transformers
Convert GeoTiff to 3d WKT

I am trying to convert some DEM in .tif image to polygon geometries representing 3 dimensional triangles that is Well-known text (WKT) - 3D (x, y, z) . What is the work flow for doing this?

610
takashi
Celebrity
F
faifai1214
asked in Transformers
Intersection Point between 3D Line and 3D polygon

Is there any transformers to generate intersection points between 3d line and 3d polygon?Thx

4204
r5
Contributor
T
tobiasrydlinge1
asked in Transformers
Scaler tree model

 I have a problem and it looks fine until I add the scaler. I can´t get the result good with the scaler. I scaled the orginal model to the size of one meter, so the scale factor is right, e.g. a tree with the height 8 meters should have scale factor 8. Why inspector showing strange geometries when I add scale or z in the scale parameters?

280
T
B
bcrowley10
asked in Transformers
JSON Writer Issue

Hello: I have a workspace that I attempted to write a JSON file with the JSON writer. The problem is, the structure of the JSON has a SUB associated with it and the SUB features are not produced with the write. I'm currently using the text file writer where it simply writes the text_line_data from my JSONFormatter. The problem with this approach is that the output are strings and I have some fields that must be numeric. I saw on another thread to dynamically convert the strings to int/double using the xs:int(attribute) or xs:double(attribute) function. This approach is fine BUT there are some number values that have NULL and in order to use the xs function, I've discovered these attributes can't be NULL. Can't I take care of this using the JSON writer by setting the datatype of the output? But again I can't seem to get the JSON writer to generate my SUB features.

1100
B
pmarseil
Contributor
pmarseilContributor
asked in Transformers
Possible combinations for each ID

Hi,I have a problem and I was wondering if you could help me.I have a road intersection table like this: OdonymeIDIDRueIDINTNameCountIndex730350012611Robert, Rue20730350013121Roxanne, Rue21730350013132Roxanne, Rue20730350015142Thérèse, Rue21730350012092Rue Raymond32730350012653Robert, Rue20730350012963Rosaire, Rue21730350012974Rosaire, Rue20730350015184Thérèse, Rue21  I need to create a table of intersection combinations (IDINT). In other words, for each intersection id I want to know the possible intersection 2 streets at a time.Ex:IDINTIDRue (1)IDRue(2)112121234243249294239293 Someone would have any idea?thanks  

62
pmarseil
Contributor

Badge Winners

  • FME Form Basic Training
    dezuviriamhas earned the badge FME Form Basic Training
  • Welcome Back
    dwade10has earned the badge Welcome Back
  • Integrate Data with the FME Platform Training
    johnrochehas earned the badge Integrate Data with the FME Platform Training
  • Student (Grey)
    westerbrinkhas earned the badge Student (Grey)
  • Teacher (Grey)
    westerbrinkhas earned the badge Teacher (Grey)
Show all badges

Community Stats

31,798
Posts
120,793
Replies
39,417
Members

Latest FME

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.