Skip to main content

Transformers

Using transformers to modify data.

  • 12,966 Posts
  • 51,743 Replies
10000 Posts
U
uaclement
asked in Transformers
Loosing z-values at Bufferer - how to avoid?

Hi all, I'm trying to create a Mesh out of Esri Shape polylines. I have shape files from a public transport network and need them as a 3d model (FBX). The single lines do not have the same z-values, they are changing. You can find my workbench in the attachments. Unfortunately the ascii grid file is too big to upload here. My workbench "works", i'm getting an FBX but i loose the z-values at the bufferer, so my Model is extruded but all lines are on the same altitude. After some research i found the 3DBufferer (Now Hub3DBufferer) but FME stopps the translation after around 1h with the following messages:Extruder_Rejector(TestFactory): Extruder_<REJECTED> Feature Counter -1 2147680263: Failed to seek to beginning of `%0' -- perhaps there is not enough disk space Failed to seek to beginning of `C:\\Users\\Clement\\AppData\\Local\\Temp\\no-conn-ffs-1512660184987_17620.ffs' -- perhaps there is not enough disk space I have 120GB of disk space, so i'm not sure what's the problem. I asked this

600
jhu_20
Contributor
lorinda
Contributor
lorindaContributor
asked in Transformers
Passing a Path Filename to JSON reader

Hi, I've found how to get the latest file from a directory and get the file name. I now need to pass this file name to a JSON reader. I'm having difficulties in doing this. I realize that the FTP Watcher in Server would be my best bet, but unfortunately we don't have FME Server available. I will be using another program to download the json files from the FTP server. Then using PATH with Sorter and Sampler to get the latest file. I've tried to use the Feature Reader setting it to JSON with the pathfilename , but must not have the proper items set up as of yet as it rejects what I've entered. This data is ultimately to merged with a feature dataset to map specific points based on one column that is unique between the two.

2000
lorinda
Contributor
R
rogerrapp
asked in Transformers
Details needed to make Python shutdown script delete input file

Hi, I have a workspace that uses the custom FeatureCounter followed by a TestFilter. If too many features for my conversion I port to a Terminator transformer. Following termination I want to delete the input file as part of a Python Shutdown script. The path including filename are in a Published Parameter. Example: [source_file]: c:\\folder\\file.ext I've looked at lots of info but my attempts produce errors or the file doesn't get deleted, or both. Can someone with good experience with this provide details on all lines needed in the shutdown script (and if needed, any Python needed in the body of the workspace)? Thanks!

282
R
D
dmatranga
asked in Transformers
Get number of days in month

@takashi I have a dataset like this: DateValue01/01/2018201/01/2018001/05/2018301/12/2018102/01/2018302/02/20184 I want to create an attribute for Daily Average Value in Each Month, and store the daily average (sum of values within each month ÷ number of days in that month). The denominator is where I'm having trouble. Any suggestions on the best way to find the number of days within a given month?

575
D
P
pfetob
asked in Transformers
Workspace running Systemcaller won't complete

Hi For different reasons I am trying to use FME Server to run a batchfile scheduled. The batchfile's task is to run a specified Powershell-script that converts a spreadsheet to PDF using MS Excel.(Yes, if FME would have had a proper plain PDF-writer I would have used this.). Both powershell-script at batchfile are working flawlessly when used manually. I've created a workspace with a systemcaller to run the batch-file. When I start this workspace, it runs the batchfile and it does what it is supposed to do, and fme logs what is happening. From the fme-log: SystemCaller: Executing `C:\Scripts\RunPowershellScript.bat' Z:\Some\network\address>>ECHO ********************************************************* Z:\Some\network\address>>ECHO ** run powershellscript to convert spreadsheet to pdf. ** ** run powershellscript to convert spreadsheet to pdf. ** Z:\Some\network\address>>ECHO ********************************************************* Z:\Some\network\address>PowerShell -NoProfile -Executi

540
J
mferwerda1111
Participant
mferwerda1111Participant
asked in Transformers
Get Schema into attribute from SQLExecutor

Is there a way to get a list of exposed attributes/schema from a SQLExecutor into an attribute value or as a list? I know I can write out a record with a featurewriter and sue a schema reader to get at it, but that is a convoluted way to go. I guessing ti can be done with python, but my python skills are limited

736
mferwerda1111
Participant
R
raalst
asked in Transformers
localized operation on big datasets

Hi All, I want to count the number of houses that intersect (gas)lines, in order to do some quality checking. most gas pipes only intersect one house. Any pipe with multiple intersects is suspect. The gas pipes are of limited length (typ. 30 meters). However I need to do this for > 1 mln pipes aganinst > 3 mln houses. That crashes my pc due to lack of memory. I'm looking for a way to process this in chunks, by dividing the country in some grid, make the gridsquares slightly overlapping (say 50 meters) and then intersect only the houses and gaspipes in the squares. No need to check a pipe against houses in another city... How can I achieve this localized processing (using e.g. line on area overlayer) ? I tried clipper with a hand made "grid" that divides the country in 5 chunks, but I'm forced to process these slabs of land manually, by running the workbench 5 times and combine the output after running the jobs. I feel this must have been delt with more elegantly and with less manual la

50
ebygomm
Influencer
hirooimaki
Contributor
hirooimakiContributor
asked in Transformers
schemamapper doesn't change field names

Hi FME community. I have a simple task to change Japanese field names in a shapefile to English field names. So I was using SchemaMapper to do this task. I created a simple csv file which has two columns, old_name and new_name. Then, I used this csv file in the ShemaMapper. I save the resulted layer as a shapefile. But the shapefile I crated had the exactly same field names as original one. All Japanese field names... I realized that when I inspect the output with the Inspector, I can see that SchemaMapper actually changed attribute names. Please see an image below. However, it did't reflect these changes when I save this result as a shapefile. Can someone tell me what I am doing wrong?? Thank you in advance. Hiroo

650
hirooimaki
Contributor
boubcher
Contributor
boubcherContributor
asked in Transformers
featureReader and spatial filter parameter

The featurereader is not giving the expected result when we use the spatial filter option as you can see the polygon ( initiator) overlap with the shapefile, but as you can see the there is no output is there any setting we need to fix Thanks result

2800
taojunabc
Participant
I
ikast_mofri
asked in Transformers
Using markdown in MSWordStyler to create a link in a Word-file

I'm trying to write a link in the Word-file, that I'm creating with MSWordStyler-transformers and the Microsoft Word writer. I'm using markdown, but it isn't written af a link - just as plain text. I'm writing this in the Text-field in the MSWordStyler with Content Type set to Paragraph: [Klik her:](http://www.ph.rm.dk/Omraader/sundhedsberedskab/arrangementer-begivenheder-og-events/)

1793
jovitaatsafe
Safer
geo-x
Contributor
geo-xContributor
asked in Transformers
Generate complex lines with points

Dear FME community. I've to generate a complex line with a points listing. Complew why ? Because the line is a composite of lines and curves. The information of the geometric type is in point's attributes like that : I only tried with the LineBuilder but I don't know how to do with the curves objects. Thank you for your help.

270
david_r
Celebrity
B
bakkermans
asked in Transformers
Conditional raster band value

I want to redefine raster band values, based on another raster band value. More specific: If raster band 3 has a value "0", raster bands 0, 1 and 2 should have a value "nodata". How can this be done most efficiently?

120
B
S
sean
asked in Transformers
Create a curve between two intersectng segments

How would I go about creating a curve where two lines intersect? I am basically just trying to smooth the intersection and create the red part. See picture below:

110
S
amolparande
amolparande
asked in Transformers
Refining, delete extra vertices, smoother geometry for raw road geometry

I have raw road geometry need to create network geometry need to refine and delete extra vertices and make smoother geometry to make can anyone help I have used generalizer but could not able to do so can anyone help me out?

130
david_r
Celebrity
L
loicroybonjob
asked in Transformers
Create 3D mesh DTM from rasters,Create a 3D DTM from photo raster and elevation raster

Hye, I'm trying to create a 3D terrain model (export format : .obj/.fbx/.3ds or any other textured mesh format) from imagery raster (France, IGN) and elevation raster (France, IGN). Inputs formats are : 1. For imagery Multiple *.jp2 files with *.tab files associated (same file name) A sample of .tab file : !table!version 300!charset WindowsLatin1Definition TableFile "01-2015-0830-6540-LA93-5M00-E100.jp2"Type "RASTER"(830000.00,6540000.00) (0,0) Label "Pt 1",(840000.00,6540000.00) (2000,0) Label "Pt 2",(840000.00,6530000.00) (2000,2000) Label "Pt 3",(830000.00,6530000.00) (0,2000) Label "Pt 4"CoordSys Earth Projection 2003, 33, 7, 3, 46.5, 44, 49.00000000001, 700000, 6600000, -792421, 5278231, 3520778, 9741029Units "m" 2. For elevation Multiple *.asc files with *.asc.aux.xml files associated (same file name) An extract of *.asc file : ncols 1000nrows 1000xllcorner 74962.500000000000yllcorner 6750037.500000000000cellsize 75.000000000000NODATA_value -99999.00 -99999.00 -99999.00 -99999.00

2390
daveatsafe
Safer
aron
Supporter
aronSupporter
asked in Transformers
Create depth zones (polygons) from depth contours (polylines)

I am trying to create depth zones (polygons) from a set of depth curves (polylines). I would like to create one polygon that covers the area between the 0m and 3m curves, one that covers the area between 3m and 6m, and so on. There are also shallows and deeps that need to be taken into consideration. What would be the best practise to do this? I have experimented with Testfilter » Areabuilder » Disolver » Clipper. But that quickly gets very convoluted... I am guessing that I could use one of the donut transformers to manage the shallows and deeps?

400
aron
Supporter
jeroen
Contributor
jeroenContributor
asked in Transformers
AreaonAreaoverlayer after Polygoncutter does not always produce wanted results.

I'm using the following flow and getting two different results: The flow uses a cutting line and gives back the original (un)cut results. The polygon for this example is: POLYGON((145055.748 479705.959,145059.802 479704.301,145060.003 479704.791,145061.669 479704.11,145061.468 479703.619,145079.166 479696.383,145084.101 479708.452,145066.422 479715.682,145066.222 479715.191,145064.556 479715.872,145064.756 479716.363,145047.05 479723.604,145046.285 479721.734,145043.203 479722.994,145042.471 479721.338,145039.139 479722.701,145038.458 479721.035,145035.116 479722.401,145034.481 479720.846,145014.358 479729.074,145012.216 479723.836,145013.891 479723.15,145012.653 479720.124,145008.46 479721.838,145002.488 479719.333,144994.651 479700.17,144989.025 479702.474,144968.486 479652.247,144971.54 479650.998,145020.56 479630.952,145021.696 479633.729,145039.976 479626.254,145038.841 479623.477,145046.477 479620.354,145072.687 479684.501,145050.657 479693.509,145052.257 479697.422,145055.748 47

98
jeroen
Contributor
B
bakkermans
asked in Transformers
Change label position to labelpoint

When creating a label with the Labeller or LabelPointReplacer, a labelpoint is made at the asked position. However, the label itself is always placed on the right above position from the labelpoint. I need the label to be placed on the left above position from the labelpoint (thus having the point at the end of the labeltext instead of the beginning), in order to garentee a good label fit in the end result. How would this be possible?

1780
B
kimo
Contributor
kimoContributor
asked in Transformers
time conversions over midnight

The new DatetimeConverter works well for the gtfs stop times which are stored as only a time string field. But it rejects (naturally) any times greater or equal to 24:00:00. The gtfs convention is to roll over midnight for bus routes that do not finish before midnight. How might that be handled? I am trying to calculate the total time of a route using Arrival_Time - Departure_Time. I cannot just replace the 24 with 00 because I have to add up two intervals. I can see a clumsy three part conversion. There are 1.4M records so elegance and speed would be welcome.

310
kimo
Contributor
dmerrick
Contributor
dmerrickContributor
asked in Transformers
KML Watermark Icon

Hi, Does anyone know how to get rid of/remove the KML warning when you add a overlay to the KML? KML: Raster feature has no fme_basename attribute; destination filename will be based on the feature id Thanks!

120
danilo_fme
Evangelist
B
bobo
asked in Transformers
Is there a way to batch get river/road width?

I've got thousands of thin polygon and their centreline. And I can calculate average width of each by using polygon area divide centreline length. I want to generate some random width number based on the average width and the numbers are between max and min width of the polygon. My first thought is to create points along the centreline with small interval like 1 meter, and create station lines based on the points. Then use polygon to clip these station lines, the shortest and longest length of station lines will be the max and min range. So I can generate random width numbers in excel. I've already got the interval points by using @takashi 's LineDivider, and some articles about calculate line angle and create bearing line. I just want to know if there's an easier way to do so, and only in FME. To get my thought work, I have to switch between FME and ArcGIS, and also some third party add-on in ArcGIS. It is too complicated for others to use it.

915
takashi
Influencer
B
boniagbaniyaka
asked in Transformers
Splitting Lines by Polygon Boundaries

Hi, Im trying to split a large dataset of lines (~1.2m records) by an almost equally large dataset of polygon boudaries (~900k records). I have tried Line Over Area Overlay, but no luck there. I tried creating points at the intersections of the lines and polygons boundaries, and executing point on line overlay, but I came up empty there as well. Has any one run into this problem before, and what conclusion/solution did you come to?

3140
takashi
Influencer
S
sammyc
asked in Transformers
Trouble Reading AutoCAD Dynamic Blocks

Hi, Is there any way of reading AutoCAD dynamic block names/visibility states? Currently all I can seem to get is the anonymous '*U___' value in the 'autocad_block_name' field. I feel like there should be a way of reading the real block name somewhere, as it picks up the correct block names in the reader parameters under 'Explode Selected Blocks'. Any help would be appreciated! Thanks.

220
S
L
lba
asked in Transformers
boucle sur les éléments d'une liste / loop on the elements of a list

Comment effectuer une boucle sur les éléments d'une liste pour pouvoir créer autant d'attributs que de valeurs de la liste ? How to loop the elements of a list to be able to create as many attributes as values of the list?

800
virtualcitymatt
Celebrity
K
kburata
asked in Transformers
UDP Traffic to port 1434 blocked

Anyone able to help me with this? com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host DEV-TFS, named instance TRAVEL failed. Error: "java.net.UnknownHostException: DEV-DB". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. Working on FME Desktop but when I published the workspace to FME cloud this error comes up. I believe I already enabled inbound UDP traffic to pass through on port 1434 shown below. Any idea what else am I missing? Thanks in advance.

2250
virtualcitymatt
Celebrity

Helpful Members This Week

Badge Winners

  • FME Form Advanced Training
    jorisbvehas earned the badge FME Form Advanced Training
  • Welcome Back
    jorisbvehas earned the badge Welcome Back
  • Welcome Back
    takacstamashas earned the badge Welcome Back
  • Teacher (Grey)
    26642523has earned the badge Teacher (Grey)
  • Student (Bronze)
    j.botterillhas earned the badge Student (Bronze)
Show all badges

Popular Tags

Community Stats

31,148
Posts
118,088
Replies
38,768
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.