Transformers

I'm trying to reproject rasters from WGS84.PlateCarree to LambertAzimuthalEqualAreaSouthPole using a Reprojector Transformer,they have varying extent/ Resolution and Spacing. It often fails, my suspicion is that it has a lot to do with the extents of the input raster, particular when those extents are approaching linear unit values that represent the dateline and 90 / -90 latitude receptively . Sometimes the transformer runs successfully but just produces a very narrow vertical strip other times it fails and leaves translation log outputs like this(You can see the extents of the input raster here i was using). Are there any set rules that i should be following to guarantee success?I can give more details and examples if necessary.  Many thanksDavid

Hello,I have a 10 digit phone number in an attribute (e.g. 0123456789).However, I want to output it formatted to a string like this: 012-345-6789.How would I go about doing this?Any help would be much appreciated.Thanks

Hello,I'm currently working on a road network of ~3000 miles and some roads can go for 100 miles+ I'm looking to assign a value if the roadname is the same and the accumulative distance is 15 miles at most. So 1 road for example can be shown by 6 segments 0-33-1010-1414-2020-2828-35In the scenario above I would like 0-14 in 1 group as it is below 15 miles, then 14-28 in the second group and 28-35 in the next group. Currently a part of the workbench that works on assigning this is:However the issue I'm coming across is after 15 since the accumulative number is beyond 15 but the sum of 2 segments may still be below 15 miles. I'm not sure how to reset it as a reset would assign the whole road the same value. I'm a little stuck here and could really use some help

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

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?

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.

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

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?

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!!

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.

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

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.  So well my question is for you what is the best way ?

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 as a Mapinfo .TAB but am getting the same results. I have also

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

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 '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

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.