- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,686 Posts
50,750 Replies

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

12686 Posts

lifalin2016Contributor

asked in Transformers

FME Server and tranformers from Shared FME Folders ?

Hi list.I have built a number of custom transformers, using FMX and Python, and storing them in the shared folders structure. This works (apart from some kinks) well in Desktop.Now I've built a workspace with such a transformers, published the workspace to an FME Server, and tried to run the workspace as a job.And it fails with: Python Exception <ModuleNotFoundError>: No module named 'Xxxxx' How do I tell FME Server to look for the custom transformers in my shared folders. They're located on a network drive, so it has access.Cheers

3719

4 years ago

jeppenbe

asked in Transformers

Compare Spatial two FeatureClasses

Hi, following situation: we have a SDE-FeatureClass with parcel(plot)-data. Every week we got new data in a FGDB with the same datamodel from another source. Now we want to process of compare the two Featureclass, if there are now spatial difference and then update the sde Featureclass with the new Information of the FGDB Featureclass. If we make a spatial selection via ArcMap we got 50 difference between the data. We try the same in FME via SpatialFilter and other transformerprocess, but we got always 0 difference. Is there a better workaround?

560

4 years ago

chris_mParticipant

asked in Transformers

Update SDE Geodatabase from Access DB

I have a SDE table in Postgres that was created from data in a Hosted feature layer and MS Access table. Since it was created new records have been added to the the MS Access table. I am looking for the best way to update the SDE table with only the new records from the MS Access table.

4 years ago

fme_hansContributor

asked in Transformers

Start workspace on fme server with a batch file

Hi,i have a workspace on fme server and i want to start it from a python script. This scripts is not located on the fme server. Can this be done? greetings, Hans

4 years ago

tjeerd

asked in Transformers

Change position from srsDimension in XML

Hello, I have a question about a XML. My XML has this result: <gml:Point gml:id="id-5d1fd60a-2737-40c8-bc59-06e25609b350-0" srsName="EPSG:28992" srsDimension="3"><gml:pos>But i need <gml:Point gml:id="id-ebfadba2-47a2-4027-b901-86ccacbb1004-0" srsName="EPSG:28992"><gml:pos srsDimension="3">How can i fix this? My workbench use the _geometry function to give this result, is it possible to change the position from de gml: pos?

4 years ago

wjloy

asked in Transformers

Stringreplacer for changing M/F to MALE/FEMALE?

I am working with crime data and need to change some fields to full names, M/F to Male/Female. Is the stringreplacer a good candidate for this? I have been using the FeatureMerger and definition tables in .csv format. Just seeing if there is a better way to do this. Thanks!!

4 years ago

mario_bla

asked in Transformers

Help with understanding difference between missing and empty

Hello,I'm reading a shapefile created by ArcGis and I noticed something strange (or not?).In ArcGis, if I create a new attribute (for example text attribute) but don't enter any value, when I read it with FME, such field is interpreted as empty field in visual preview table of the reader (there is nothing in that field). But if I enter some value in ArcGis, store it, than delete this value and store it again, than when I read it with FME it is interpreted as <missing>. Why? Why not empty again? Is this correct interpretation by the FME?From help:Empty – The attribute exists and has an empty string as its value.Null – The attribute exists and has a value of null.Missing (Selected Attributes Only) – The attribute does not exist.

2490

4 years ago

mario_bla

asked in Transformers

Intersecting overlapping polygons

Hello,I'm intersecting two layers of data (polygon.shp and plygon2.shp). One of them (polygon2.shp) has two completely overlapping polygons. I'm getting this:How to get this:Here is the sample data: .

540

4 years ago

terezia86

asked in Transformers

Filter group attributes

Hello, I need to filter the Attribute values into separate groups. See the image.The values are always variable/different so I cannot use an AttributeFilter.Any Idea?Thanks

1640

4 years ago

mackenziebudda

asked in Transformers

Using system caller to change a folder name

I'm trying to change the name of a folder when running a workspace. I would like it to update the folder name from [job name_YYYYMMDD] to put in the date of when the workspace is run. I tried using system caller however it doesn't seem to work: below is a screenshot of my command line:I know @DateTimeNow() doesn't have the date format I'm looking for, does anybody know how I can update that as well?

220

4 years ago

hein_veenhof

asked in Transformers

Unit testing framework

Hi,I'm looking for a unit testing framework for FME workbenches. See link below for a lot of example frameworks for various programming languages.. Is FME running behind on this topic ?? https://en.wikipedia.org/wiki/List_of_unit_testing_frameworks#References This page is a list of tables of code-driven unit testing frameworks for various programming languages.

360

4 years ago

deanhowellEnthusiast

asked in Transformers

Block List from DWG Template

Is there a way to get a list of the blocks contained in an AutoCAD DWG Template?I can see in the DWGStyler that FME is able to read the list of blocks from the template, so was wanting to see if that same list can be extracted in other ways?

360

4 years ago

pascalfilippi

asked in Transformers

What is the best way to clip a lot of data ?

Hello guys,I have a files in a Esri geodatabase with the county of New York and an other files with "the constraint" its an huge group off small polygon (8 millions) who represent a mix between the slope + forest +swamp, what ever. I would like to clip the county by the constraint and get the outside flow, it will form at the end the polygon of the county with some holes where was the constraints. So i use the clipper with this two files i think as many of you know it take long time and at the end fme say that i didn't have enough place (i had 20 gb free). After that i try to create different workbench with 1 million feature to run in each workspace (workspace 1 = 0 to 1 million , workspace 2 = 1 to 2 million, workspace 3 = 2 to 3 million, etc), but im not sur its work to so. So well my question is for you what is the best way ?

1830

4 years ago

ppp19

asked in Transformers

converting excel file into XSD fomat?

Hi,I am looking for learning the way we can convert excel files into XSD format. Any basic tutorials/videos that can help me to learn this quickly?Regards,Purvi

2200

4 years ago

michaelqatcord

asked in Transformers

With the latest upgrade to the AttributeExposer I'm no longer able to retrieve the fme_basename, which I need for further processing. Does anyone have a work-around for this?

asked in Transformers

How to write line with measure to Postgis?

Hi,I'm creating line with measure on vertex and write it to postgis. When I read the same line from postgis, there is no measure. Is-it possible to write and read measure from Postgis?Thanks

220

4 years ago

mattebridges

asked in Transformers

AreaOnAreaOverlayer ignoring some input polygons

Hello - I have a dataset of polygons (some of which are donut polygons). Some of these polygons contain multiple parts (i.e. more than one polygon per record). When I run this dataset through an AreaOnAreaOverlayer it seems that some of the multiple polygon parts are lost. This is shown in a comparison of 'DataExtent.png' with 'AonA_Output_Extent.png'. I have tried running the polygon dataset through a Deaggregator thinking this would split records with multiple geometries in to multiple records (in case multiple polygons per record was causing an issue for the AreaOnAreaOverlayer). However the output from the Deaggregator is untouched regardless of the settings in the transformer (so perhaps these are not aggregates). Ultimately I need to run these polygons through the AreaOnAreaOverlayer but need all parts to be considered. The data was initially stored in an Esri file geodatabase and I've also tried as a Mapinfo .TAB but am getting the same results. I have also

230

4 years ago

supaustinContributor

asked in Transformers

My coordinate system names are corrupted and causing problems

I am unable to write features to a feature class, because FME doesn't recognize the coordinate system. This data is a feature class from a FIleGDB, in LL-WGS84. I didn't originally set the coordinate system, and it seem to read and position the features appropriately, but inspecting the features coming out of the reader, coordinate system is defined like this, with extra characters. When I try to write the features to a new feature class, this message comes up. Feature Caching is ONThe workspace may run slower because features are being recorded on all output ports.Coordinate system named _LL-WGS84_0 does not exist. The workbench appears to run successfully, but the feature class does not open and if I view written data in FME, the map opens up somewhere in Asia. I had added a custom transformer a couple of weeks ago, so I thought that might be causing the issue. I removed it from the documents folder and restarted FME, but it didn't seem to fix the problem. Has anyone

490

4 years ago

moraalejandra93Participant

asked in Transformers

SQL To Run after Wrtite -Incorrect Syntax - Provider error `(-2147217900). Adding a named constraint primary key

Hi guys, I'm trying to add a named constraint primary key into a large number of SQL Server tables joined in one reader with this code in the 'SQL to Run after Write' part: FME_SQL_DELIMITER ;ALTER TABLE @Value(fme_basename)ADD CONSTRAINT PK_@Value(fme_basename) PRIMARY KEY (id1)But I got this error:Microsoft SQL Server Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `ALTER TABLE @Value(fme_basename)ADD CONSTRAINT PK_@Value(fme_basename) PRIMARY KEY (Id1)'. Provider error `(-2147217900) Incorrect syntax near '@Value'.' Does anyone know what is the error? Or how can add a Primary Key for a large number of tables joined in one reader? Thanks a lot

880

4 years ago

ahalwi_esrimsia

asked in Transformers

DWG to gdb projection problem

I'm totally new to FME and straight away having problems with conversion from DWG. The conversion is successful but when i zoomed in to the layer (in Arcgis Pro) the parcel data appears to be located somewhere in the middle of the ocean. The parcel data is in GDM2000 Malaysia RSO projection. I wanted it to be displayed in UTM WGS84 48N along with other GIS layers. I really couldn't find out what I am doing wrong here. Thanks.https://drive.google.com/file/d/13GyjeDa9lyH3T4sOUnTKcs4j4ayADFkr/view?usp=sharing

170

4 years ago

eva218

asked in Transformers

Use WMS link as shapefile within workbench

Hello,I am struggling with the use of a WMS reader within my workbench. I would like to use the outcome of the WMS reader as a shapefile and use it within a Clipper transfomer. But the outcome of the WMS reader is not (yet) suitable for shapefile purposes, as it is a raster. I tried the transformer RasterToPolygonCoercer, but it results in a lot of polygons instead of only one polygon (matching the national border of the Netherlands). Should I use another transformer? Or is it possible to read the WMS with different settings? For the WMS reader, I use the following URL: https://geodata.nationaalgeoregister.nl/bestuurlijkegrenzen/wms?request=GetCapabilitiesWithin 'Parameters...' I select under 'Layers' the layer 'landsgrens'. This is the layer where I am interested in. Furthermore, I used the default settings: Hope anyone can help me getting the national border as a shapefile. Thanks,Eva

720

4 years ago

craigParticipant

asked in Transformers

Select records from the previous 5 years based on the current date

Hi, I have a database table with a date column containing dates formatted as YYYYMMDD. I need to select all records from the table with a date ranging from the current date to 5 years previous of the current date. Any assistance appreciated.

7675

4 years ago

deanhowellEnthusiast

asked in Transformers

DWG Template Attributes

We have a DWG Template that defines layer names, and a range of attributes like colour, line type, line weight, block names, etc. In the main this template contains no features.I want to use the raw (featureless) attributes in the template to merge with an existing drawing to check if the layer names and associated attributes are matched. Is this possible?I have a table that has been created with the raw attributes and can merge that with the supplied drawing but if the template changes the table also needs to change, so was hoping I could remove the step to create the table and just read the template.

100

4 years ago

koenvdwContributor

asked in Transformers

how to go from geotif to ecw without black borders

Hi all After processing we are left with ortho tiles in GEOTIFF format. The GEOTIFFS on the edge of the process area have black borders. When we process to area's next to eachother we have an overlap with the black borders. Normally we work with jpeg2000 and I use the rasterbandnodatasetter and the rasterinterpretationcoercer to convert the nodata to an alpha band. But now our client wants the orthophoto tiled with their specifiactions and in ECW. This is my tiling workbench. Pretty easy. The rastermosaicker groups by "naam" and puts out ECW tiles. The result looks like this:As you can see there are black borders in the area's that overlap. What I understand is that ECW wont work with nodata and wont work with alpha band. How can I solve this? I could convert the original geotiff files to tiff with the nodata and rasterbandinterpretation method. Once I have them I can tile them with my workbench but use a tiff writer instead of an ECW writer.After I have my tiff t

370

4 years ago

gisrewards

asked in Transformers

Aggregator issues with ArcMap but works with FME

Hi all, I have been trying to put together some GIS data we have that was in a list format. When i use FME and check with the inspector this looks fine, data is what i am after. The same when i produce this in QGIS, looks fine. When using arcmap, i seem to see some of the shapes are not getting the same symbology and just displays the outline of the shape. Does anyone know why this might be the case and is there a solution to this issue?

4 years ago

Page 198 / 508

Badge winners

dmacleodhas earned the badge Welcome Back
rylanatsafehas earned the badge 12 Days Participant (2024)
pieter_bij_ebnhas earned the badge Welcome Back
Monaedaroushas earned the badge Welcome Back
bobbystarhas earned the badge Integrate Data with the FME Platform Training

Show all badges

30,193: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

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.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

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.