Transformers

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

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?

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.    

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?  

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. 

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

@Michael257

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

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

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 c

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

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

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 &

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.

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. 

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 bor

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? 

Hello FME users,I have two layers1. Area Polygon2. LineRequirement Polygon (Blue) need to align to the Line (Red) . Tried “AnchoredSnapper" could not work can any one help me out how can this be accomplish? 

Hi list.When setting expressions in XMLTemplater for ROOT and various sub templates, one uses fme functions like "fme:has-attribute" and fme:get-attribute".But is it possible to use string functions as well, e.g. to test the first character in a string retrieved by "fme:get-attribute" ? I can't seem to find any documentation about this with Safe.I've found some string functions documented at Microsoft, e.g. https://docs.microsoft.com/en-us/sql/xquery/functions-on-string-values-substring?view=sql-server-ver15Here a namespace of "fn" is used, but will that work in FME ?And how do I wrap multiple function within each other ?Is it { f1( f2() ) } or is it { f1( { f2() } ) } ?Any insights will be appriciated.Cheers.

Hello, I'm trying to extract a multipolygon from a JSON file with the model of this topic (https://knowledge.safe.com/questions/40791/json-multipolygon.html) but I don't achive to do it ...It's my first time working with JSON The multipolygon in the Json file is defined like this (I replace real value by x1 x2 etc in the exemple) :{ "stages": { "filters.hexbin":{"boundary": "MULTIPOLYGON (((x1 y1,x2 y2,x3 y3,.... )))I've try with : json["stages"]["filters.hexbin"]["boundary"] in JSONExtractor but it doesn't work , an I don't really know what I need to fill in "JSON Document" ... Does anyone have any idea how to

Hi,I am new to FME Desktop and I would like to get help in order to extract all the street side segments which are located within 5 meters from the standpipes. The resulting segments must also contain the attributes of the standpipes that meet the selection criteria and produce an Excel report of all the selected segments.How can I achieve this task using FME?PS. I'm using FME Desktop 2020 Thank you!

I have a shape file and i want join with xls sheet (consists of X and Y), there are no common id between them but xls feature lies inside the shape file polygons and there are multiple polygons how i will join shape file with xls?

I'm using the IterativeSnipper transformer to segment ~1000 polylines to cut each to a maximum of 5 miles however if there is a northbound polyline I want to ensure the southbound polyline is also snipped at the same location. The southbound for example is exactly overlayed across the northbound. Is there a way I can do this where if two segments fall within a 2 meter buffer they will both be snipped at the same location? Alternatively from my research I hear it is possible to do what I desire by snipping one direction, pulling the start and end gps values and then do an anchored snap method? to make sure the opposite direction is snipped at the same location? I dont know exactly how to set this up though.

Hello thereTraying to use FME to convert date formatdate : 1591982226conversion :Friday, June 12, 2020 5:17:06pmthe conversion was done using this tool ( https://www.silisoftware.com/tools/date.php?inputdate=1591982226&inputformat=unix ) is there a way we get the same result with FME transformerThanks 

Hi!I have a task for an aviation project where there are multiple 3D surfaces of runway approaches (from DWG). I need to take the multiple surfaces and create a single composite "blanket" object taking all of the lowest elevation information. This is because the client would like to know how high an obstruction can be before it intersects with any of the approach boundaries. I've seen SurfaceDissolver & SurfaceFootprintReplacer, but I'm not the best at FME so I'm unsure of a good workflow.Any help would be appreciated! Thank you.