Using transformers to modify data.
Recently active
Just updated windows 10 and can no longer boot up FME 2019.2.0. Any ideas how to fix?
I'm looking for a method to "explode" single features into multiple features based on the numeric value in a given attribute field. Here is an example of what I'm working with and where I'm trying to get to, keeping in mind that there is point data attached to each record here...AnimalNumber_SeenOwl1Deer2Raccoon3 I'm looking to "explode" the features so that there is one point feature for each individual animal...AnimalNumber_SeenOwl1Deer1Deer1Raccoon1Raccoon1Raccoon1 It's worth noting that there are many features on the map for any given animal type, but the observations have been aggregated by the number of animals seen in the group at the time. An animal sighting with a "Number_Seen" = 1 does not need to be "exploded". Does anyone know a good FME workflow to do such a thing? I essentially need to de-aggregate points and replicate the spatial/attribute data so that there is a feature for each individual animal observed. Than
Hello Learned Friends,I have a Point layer where I need to convert each Point feature into a Polyline feature which traces along a set length (say 25 metres) of the nearest neighbouring polyline feature from a separate layer.In the crude example below, the BEFORE scenario details an example of my starting position, whereby I have 3x Points (in red), plus 3x Polyline reference features (in grey).The AFTER scenario details what I am attempting to achieve, and ideally the grey Polyline features (A,B, and C) will become split features along the length where the new red polyline features have been inserted.Does anyone have any ideas of how i can achieve this?Many thanks,RB
Hi,We have a problem with the DateTimeStamper in a workspace. The customer works in FME 2019.2.2 build 19817. As you can see from this screenshot it only stamps the first row with the date: I've tried to rebuild the same workspace from scratch, but I cant reproduce the error. The customer still gets the error when he is trying. These are the Parameters for the DateTimeStamper:Does anyone know where this error can come from? I've added the workspace as well as the data as attachements. Kind regards,Birk
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