Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,712 Replies
10000 Posts
sigtill
Supporter
sigtillSupporter
asked in Transformers
S3-connector - what happened?

S3-connector - what happened? Do we have a murder case - its gone?

160
G
marcoroose
Contributor
marcorooseContributor
asked in Transformers
create polygon from point.

I want a polygon that contains all points per group. (postcode)BUT the polygon may NOT contain points from another group.I want the maximum area. but it must not overlap.I have used the HullAccumulator but I get an overlap with that.the red line is what i want.

110
ebygomm
Influencer
a_afiaax
Contributor
a_afiaaxContributor
asked in Transformers
combine list in one point shapefile

Hello FME community,I am quite a beginner with FME and I have point shapefile includes country names. Each country name divided into 2 parts and the 1st part ended with (-).How can I combine a country name and remove (-) in the following list?To this:For each name sometimes 1st part sorted at end, for example Camb-Does anyone have any ideas or potential solutions?@takashi @david_r @jlutherthomas @egomm @mark2atsafe

150
a_afiaax
Contributor
D
deanrother
asked in Transformers
How do I specify NAD83<->NAD27 grid shift files for FME Server?

I've received this error -- Implicit NAD27<->NAD83 grid shifts may not be performed until Canadian or US grids are chosen -- running a workbench in FME Server that contains a CSMapReprojector reprojecting from NAD83 to NAD27. I remember choosing the US grid shift when installing workbench on my desktop, but don't recall an option for choosing this when installing FME Server. I think some information is given on how to rectify this in FME Server in the log file, but it is not adequate for me. 

110
D
L
lizzygradidge
asked in Transformers
List concatenator

I am supplying a list of 113 list attributes from a ListBuilder to a ListConcatenator How do I get this to concatenate into one long string with comma separator characters.My Results output is just    

1400
L
H
harshal.gharat
asked in Transformers
Workflow execution order

I have two separate flows for a process as shown below (upper and lower). These two flows are separate but it is required that the lower workflow must be executed after the upper workflow has executed. To handle this, I have created two separate workbenches for each flow and i am calling the second workbench after the upper workbench has been run. Is there any way, I can merge these two workflows in a single workbench and have control on which workflow executes first? 

1260
david_r
Celebrity
mlupien
Contributor
mlupienContributor
asked in Transformers
points to polygon

I have a lot of points, like a grid, that I would like to transform to polygons. Any point that is closer to 0.5m should be joined to forme the polygon. Any point with no close neighbor can be ignored. Any suggestion is welcome :) 

7200
mlupien
Contributor
N
nicksartore
asked in Transformers
Welcome to our collaboration space

Hi Jim and team, We hope this resource will be helpful as we continue to build on our partnership. You can select "New Question" from the top menu to add a new post and we can then discuss and collaborate from there. Ensure you select "Avineon" as the space you want to publish in to ensure it stays private for us. Thanks,Nick

20
N
D
darius
asked in Transformers
Cross tabulating columns

Dear all, I have some data that looks like the first table. I usually use Microsoft Access to create a cross-tabulation as in the second table. Does anyone have an idea of how I could accomplish that in FME?  Thanks!

910
ebygomm
Influencer
martinkoch
Supporter
martinkochSupporter
asked in Transformers
What commands are there to manipulate the server settings?

I have been tinkering with the /opt/fme-engine-2019/fme APPLY_SETTINGS a bit.I was wondering which other commands and options are there? How are these settings stored?Browsing the safe-documentation I only found the helpful LIST_SETTINGS and options to configure both python, R and some proxy settings.I did an upgrade (deinstall - reinstall -restore from backup) and the settings were just as they were previously.At this moment I would like to 'revert' some entries I made, but DELETE_SETTINGS is not an option apparently. Neither is PURGE_SETTINGS to restore them to the install-default.Thanks for taking notice..Martin

240
martinkoch
Supporter
S
sigmadon_max
asked in Transformers
Test Filter Date Calculation

When using Test filter, how do I capture todays date -65?SQL Statement would read "Field_1" >=(GetDate()-65)

1251
chrisatsafe
Contributor
B
bugmesh
asked in Transformers
Can I use FME to create a form to interactively update rows in a SQL Server 2016 database

I am looking for a way to update/load data into a SQL Server database by using FME as an input form

50
david_r
Celebrity
djmcdermott
Contributor
djmcdermottContributor
asked in Transformers
Group n points by proximity

Hi FME'ers,I have a dataset containing points. I would like to group them so that there is n points per group by proximity. Imagine a voroni diagram but instead of 1 point, its n. For Example, I have 30 points I have want to group them into 3's. This would give me 10 groups with three points each and they would be the nearest points to each other.Thanks,David

440
davideagle
Contributor
bartm
Contributor
bartmContributor
asked in Transformers
Chartgenerator: plotting attributefields with missing values

I'm trying to create a bunch of graphs where data comes from different data sources. As a consequence the length of the attributefields differ (i.e. some fields are missing when constructing fields af the same length). What I would like to plot is x against y and x against y_incomplete in 1 graph:x y y_incomplete 1 1 <missing> 2 3 3 3 6 7 4 9 <missing> 5 12 4 6 15 8  However, this raises the error:ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericChartGenerator_2(PythonFactory): PythonFactory failed to close properlyChartGenerator_2(PythonFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details It would be nice if the chartgenerator could handle missing data or in the settings you could set a no data value. Or am I missing something and is the chartgenerat

150
jdh
Contributor
S
shivanisingh
asked in Transformers
How to transpose excel data?

 I am trying to transpose the data from rows to columns. I have attached the example of the final output and my template as well. It would be great if anyone could help me with a solution. 

200
jdh
Contributor
M
miob
asked in Transformers
Assign unique values to multiple inputs

FME-newby question: I selected multiple files (.dwg) and dragged them into my workbench. IFME now sees it as 1 input, so when I extract the points I need I get one output, but I want 1 output per file. How do I assign unique values to each file/layer? In short: i have surface profiles as .dwg and i want to turn every single file into a profile in excel. 

80
erik_jan
Contributor
E
edhere
asked in Transformers
HERE background map error in Data Inspector

Hi all,I'm getting some errors trying to display a HERE background map in the Data Inspector. I'm trying to pull up the satellite.day map Error: (log attached) Cheers, Ed 

100
E
tim_wood
Contributor
tim_woodContributor
asked in Transformers
Convert different date formats in same attribute

I'm reading in data from multiple XML files, all of which have the same date attributes (xml_char in the XML Reader). However the dates are not all the same format - some are 2018-06-22 and some are 22/06/2018. I want to write the dates to date fields in a File Geodatabase.I can have 2 DateTimeConverters (one for one date format and one for the other) based on whether the date attribute contains - or / and use a Tester or TestFilter to send the features to the appropriate converter. But is there a better way?I'm wary of using "Auto detect" in the DateTimeConverter - people have previously said it's better to specify a specific Input Format.

1440
tim_wood
Contributor
C
cheriesouthwick
asked in Transformers
Exposed Elements in NeighborFinder are Forgotten/Aren't Saved

Elements that I try to add to my list of exposed elements in NeighborFinder are not being saved after closing and reopening workbench FME Desktop 2018.1. Upon reopening the workbench, only those elements that were originally exposed are still exposed. The newly exposed elements are forgotten/no longer exposed.My workbench contains about a dozen NeighborFinder transformers, but no matter what I do, only a handful of them actually save the attributes that I expose after I save and reopen the workbench. I found an old forum post about the same issue in FME Desktop 2015 (https://knowledge.safe.com/questions/5162/attributesplitter-exposed-elements.html?childToView=91200). Is it possible that the same bug exists in 2018.1?  I’ve tried the following workarounds but none of them worked:Copy a working NeighborFinder and paste it to replace a broken NeighborFinder. Save and reopen the workbench.Create a brand new NeighborFinder, expose the elements, save and reopen the workbench.Copy the content

40
rahulsharma
Safer
F
fritspoulsen12
asked in Transformers
How to create a JSON upload body for HTTPCaller

Normally I use input from a JSON-file directly as JSON upload body for HTTPCaller. Now I need to do the same from reading an Oracle table, So how do I build the upload body, so that it looks exactly the same (in an easy way)? Have tried with no luck, so please provide an example, if possible.Example of a simple JSON structure wanted.{ "vandstiktype": { "id": 1, "description": "Byggevandsstik og måler", "explanation": null }, "maalerAnsoegning": { "antalMaalere": 0, "maalertype": { "id": 1, "description": "Vandmåler ved egen boring", "explanation": null } }, "aeldreEllerUngdomsBolig": false}

1915
F
pratap
Contributor
pratapContributor
asked in Transformers
Image as External Reference dwg file

Hi,If dwg file is attached to dwg file as external reference then we can know with attribute autocad_xref_name. Is there any possibility to know if image is attached???Pratap

910
pratap
Contributor
f.kemminje
Contributor
f.kemminjeContributor
asked in Transformers
fme fills polygons and circles

I am reading Autocad blocks and writing to PNG format(raster). In the reader itself I am dropping the blocks, and using imagerasteriser transformer and writing to png. But the problem is if the input feature contains polygons or circles , it comes as filled in png output. Actually its not filled element in Autocad?I can I overcome this? or any workaround? (intersector is very costly)

280
redgeographics
Celebrity
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
Cadastral Survey CAD validation

Hello does anyone have some experience with using FME to validate CAD data provided by cadastral surveyors?

170
deanhowell
Influencer
H
harshal.gharat
asked in Transformers
GeodatabaseDefline_.fmi Could not be opened error

Whenever I run a workbench I encounter following errorERROR |BADNEWS: File C:\\apps\\FME\\metafile\\geodatabaseDefline_.fmi could not be opened (tabrdr_classic.cpp:2756 - tabrdr::ClassicTableReader::TableReaderSource::open) - (tabrdr_classic.cpp:1743 - tabrdr::ClassicTableReader::getRow) - (tabrdr_classic.cpp:1743 - tabrdr::ClassicTableReader::getRow)I am using FME Desktop 2018.1

130
erik_jan
Contributor
robertodorazio
Participant
robertodorazioParticipant
asked in Transformers
How to correct vertex order on a line?

I have lines imported from Autocad to a GIS system, and it seems that the digitazing order of their vertex are not valid for the GIS sytem (e.g. endpoint is on a vertex in the middle of the line).I was wondering how could i correct this order? My first thought was to use a chopper with 2 vertex and then merge all the segment together (LineCombiner) but maybe a transformer does this in one shot.Any idea?

1760
erik_jan
Contributor

Badge Winners

  • Integrate Data with the FME Platform Training
    graysonhas earned the badge Integrate Data with the FME Platform Training
  • Integrate Spatial Data
    graysonhas earned the badge Integrate Spatial Data
  • Student (Grey)
    lenabaghhas earned the badge Student (Grey)
  • Welcome Back
    lenabaghhas earned the badge Welcome Back
  • Welcome Back
    dcoxhas earned the badge Welcome Back
Show all badges

Community Stats

31,808
Posts
120,815
Replies
39,431
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.