Transformers

The issue I am seeing is geometry/spatial distortion between two different formats, .shp and .tab when converting from a spatial oracle table.I am currently using FME 2015.The spatial metadata for oracle has set bounds and the same spatial extent was set for min/max x/y for the .tab writer. Below, the distortion is quite evident.Red: .tab with no spatial bounds Green: .tab with same spatial bounds as oracle spatial metadata Blue: ShapefileI have tried to restrict the spatial extent to a smaller area in the .tab format but the distortion is still evident (see below). The distortion improved but it is not consistent.Black: .tab output with original spatial extent, same as oracle spatial metadata. Blue: .tab with spatial extent changed to another smaller area. Green: Shapefile output with original spatial extent, same as oracle spatial metadata Red: .tab with spatial extent changed to the smallest area possible.Is there a way to minimise or if possible, remove the distortion?

I am sure this is a really simple action, but I don't seem to be able to sort it out. I'm needing to filter off the top result out of a sorter in an attempt to make my workbench generic. I've run the data through a sorter, and the details I need are showing in line #1.  Cheers for any assistance provided.  

Useing FME desktop Can i read and write "HKEY_CURRENT_USER" data ?I need Created the key at run time and set the value according i will read the parameter values.

I am reading from one Excel file and writing to another.I have an attribute named "timestamp2" which contains datetime-formatted values from 6/15/17 00:00 to 8/1/18 23:45 (I do realize I'm looking into the future).  They are in 15 minute intervals.FME recognizes that  this attribute is datetime and sets the reader accordingly.  However, when writing, a number of the values (about 2,300 of them) between 06/15/17 01:00 and 07/09/2017 21:45 get written with the same value.Furthermore, when I view the data in the Inspector, the FME datevalue appears incorrect.  For example, a date of "06/15/2017 02:15" is being represented as 20170615021460 instead of 20170615021500.  FME appears to be taking one minute and replacing it with 60 seconds instead.I was trying to test this further to find the source of the error and I added a DateTimeConverter.  It yielded the following error:DateTimeConverter: '60' is out of range for 'seconds'. Range of 'seconds' is from '0' to '59.999999999'DateTimeConverte

Hello kind people,    I am beginner with FME. I am working with data which were combined based on the similarity of the records. However, this matching is not perfect and manual review has to be done. I want to automate the review and I have question concerning comparing two records.I would like to ask if there is any function which is able to compare two attributes for the same record e.gNAME 1: KROGER STORE 456  NAME 2: KROGER FUEL CENTERIt would pass the test, where one word from the NAME 1 (Kroger) is dectected and included into NAME 2. Or word from NAME 2 is detected into NAME 1.It should base on extracting every single word/number from NAME 1/NAME2 and comparing with every single word/number from NAME2/NAME1. I will be grateful for help.

Hi,I'm trying to use a workflow with dynamic output schemas, and uses fme_feature_type to fan out my datasets. Embedded in this workflow is a SpatialRelator.However, it seems like this transformer propagates the feature type of the "supplier" even though the attributes are set to "merge supplier" with "use requestor" in case of conflict. Apparently the feature type is not in conflict ??Is this a known problem, or is it WAD ?I'm using a workaround to save the "requestor" feature type into a separate attribute, but it would be nice if the transformer worked better.Cheers

Ok folks this might be an interesting one.I have data that is tagged with two character ID AA with all variations through to ZZ. That's 678 combinations. I need to act on each combination individually.Initially I thought of using a attribute filter and importing the 678 combinations which worked bu the down stream handling is a killer. Not to mention making the workspace bloated.I then thought of making a first character filter an then passing that to second character filter. However that the same problem in two dimensions.1 first character filter each passing to a second filter for the second character however the net result is the same number of individual output ports.Each letter represents a coodinate in essence in a 26 x 26 grid.The final goal is to get the X and Y coordinate pair. AA = 1,1 ZZ = 26,26.These X and Y coordinates would be used as Offseter parameters for object placement.Anybody got any clever ideas how I might handle this?Thanks folks.

I would like to use either xfMap or the XMLFragmenter on the attached complex xml file. I need the attributes as columns for each "area type". So for each area type the attributes would be: "area type", "description", "forecast-periods","flood status","warning prediction", "obs_site_description",etc.. This seems to be really difficult with the XMLFragmenter and I not proficient enough with xfMap either. If anyone has some example Workspaces I could use that would be great?

Hello,I'd like to be able to change, for example a -544.43 meter Z value to 544.43. The z values were generated by a bathymetric software package, so positive Z is down. I realize this is a simple multiply by -1, but I can't get it to work on a .LAS file using the "Offsetter" or coordinate tools. I suspect this should be an easy fix, so any help would be appreciated.

I'm having some trouble assembling a record set in the way I want to assemble it. I currently have features structured like the followingAttribute AAttribute BAttribute CGroupValue1KeyValueGroupValue1Key2ValueGroupValue1Key3ValueGroupValue2KeyValueGroupValue2Key2ValueGroupValue2Key3ValueWhere each row is a feature (except the first in this case, which are attribute names). What I would like is to create a new feature grouping on Attribute A, with Attribute B holding attribute names for this new feature and Attribute C holding the value of those attributes. I've looked into attribute pivoter and aggregator to accomplish this; but I can't seem to figure out how to pull this off. Any ideas on what I'm missing? In my data, I can guarantee the uniqueness of Attribute B across unique values of Attribute A.Maybe what I'm asking for isn't possible. I'm not sure.

I have two polygon files. One is the original file and the other is an update of the original containing edits. I would like to filter out the polygons that have been updated spatially from the polygons that are unchanged. I have tried using Spatial Filter with 'Test to Perform' set to Equals but it seems not to be able to identify the matching polygons. I have tested the original against itself and the equals filter worked perfectly. Tested against the updated file (where I can see there are many unchanged polygons) and it doesn't work.

I attempted to read a Civil 3D drawing to extract the pipe network, but I get this error:  AutoCAD Reader: Entity type of 'AeccDbSurfaceTin' not supported. Perhaps try a different Civil Schema Mode. Skipping entity Error running translation.  I did try the other Civil Schema Mode and got the same error.  Can FME 2014 SP3 read these pipe networks and write out to shape file?

I'm trying to use the Directory and File Pathnames reader. FME 2013 sp3.  I have the Source Directory parameter set to a directory name, e.g. "C:\\temp"  I have the Path Filter set to "**/*.xlsx"  In theory, this should find all xlsx files in the current directory and recurse down through sub-directories.  2 issues:  1. if I follow the Reader documentation, I should be able to use "**\\*.xlsx" but it doesn't find any files, so I need to use a forward slash "/" instead of a backslash "\\". (I'm on a Windows system, so you'd think a backslash would be better.)  2. using the above path filter it successfully recurses into sub-directories and finds xlsx files but it does not find any files in the top level directory.  Anyone have any idea why it's behaving like this?  Using the same glob pattern (either forward- or back-slash, doesn't matter) with the Excel Reader works as expected and successfully picks up all xlsx

It seems that StatisticsCalculator doesn´t work well when I group features by numeric (only numbers: [0-9]+) field keys. I attach a sample.

Hi,i have an issue with the statistic calculator, doing some IDW Interpolation.I use a counter (the only one within the workbench) to create an id, called "_zaehler". Later on I use this attribute as a group by attribute in the statistic calculator. The point is that, with the illustrated settings (count start=3000), I loose some points (with theses settings 530 points!). The missing points look like this:If I set the count start to, say 10.000, all points are processed! This behaviour is unclear to me!

probably a permission issue, but not sure what it is failing. I continuously get this error.2017-10-18 10:22:55 A SAFE license service was detected running on port ##### on server ABC (##.##.##.##) and offering FME licenses. Please ensure that fmelicensingassistant is configured to use it (enter either 'ABC' or 'ABC:#####' for the Server Name), and that it has sufficient licenses for you.the startup script islappend sysString $FME_MacroValues(FME_HOME_UNIX)/fme;lappend sysString {Generate};lappend sysString {GEODATABASE_FILE};lappend sysString {NULL};lappend sysString $FME_MacroValues(SRC_GDB);lappend sysString $env(TEMP)/temp.fme;lappend sysString {--RESOLVE_DOMAINS};lappend sysString {YES};lappend sysString {2>@1};eval exec $sysString;Any thoughts? I am actively working on this, so will hopefully have it resolved.

Hello, I have a point shapefile containing every aeronautical obstruction in the UK above 80ft. I am working with Largescale mapping and need to generalise the points so as not to clutter the chart. I need to merge multiple points into single points based on their proximity to each other and other attributes. Then create a new attribute stating that the new point is now a 'Multipoint'. Additionally I will need to retain the metadata of the highest obstruction of the generalised points.Thank you very much in advance for any assistance you can provide.@1spatialdave

I have a set of lines, and a set of polygons. I've used a spatial filter to check wether or not the lines intersect with the polygons. I want to filter the polygons that don't have an intersecting line. The lines were used as filter, and the polygons as candidate. That worked fine.However, I wanted to add a condition that only intersections of more than a specified number should be considered valid intersections. Seems pretty straightforward, but I don't get any output once I set a conditionThis is my workbench. Reader 1 are the lines, reader 2 the polygons. To set the condition, I select "intersect" as tests to perform in the spatial filter. After that I click the drop down menu for that tests and select/type the condition: if length <= 1I think I'm forgetting something really small, but I just can't seem to figure out what.

I have a lot of orthophotomaps in tiff format. The size of all files is about 900GB. I want to join all files to one. Next I want to change coordinate system and next I want to intersect the orthophoto using appropriate frames. I have problem because FME doesn't operate so big raster. Could You give me advice how can I do it?

Hi I have managed to create new attributes for a SchemaFeature:  And when I set the Excel Writer Schema Sources to "Schema From Schema Feature" I am outputting an excel spreadsheet with the new column headers as I require.  However, I can't work out how to populate these column headers! I tried to populate them in AttributeManager like so:  But then in the excel spreadsheet the values of the column headers replaced the column headers themselves.  I seem to be missing one vital step here but I can't work out what it is. Thanks,

Hi,I have created a series of Dictionaries in the PythonCaller and I want to output the Key and Value pairs as new attributes with values for each feature.Is there syntax using feature.setAttribute to do this?

Hello,I would like to create a personalised ID (counter personalised) with letters and number.I use 2 letters (A to Z) and 1 number (1 to 9), so I would like something like that :AA1AA2AA3...AB1AB2AB3...I don't know how to do that and I don't find the solution on the web. Maybe a python script? But I haven't no knowledge on this langage.If you have any idea...Thank you for your future answer.

I have a number of columns that contain data that can have the following values (0.25, 0.5, 0.75, 1.0, 2.0, 3.0 and 4.0) These are the only acceptable values but the leading and trailing zeros are being stripped off when the data runs through the FME script. How can I ensure that this does not happen?

I have the error: The below feature caused the translation to be terminated Storing feature(s) to FME feature store file `P:\\WELL_DATA_EXCHANGE\\PGISF_WDERPRT_JS\\log\\WellDataExchange_PopulateReport_log.ffs'I used a recorder in a TEST script now this error is showing up in all my FME scripts