Transformers

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

I've got a duration in seconds that I want to format as hours and minutes so I thought I'd tell the DateFormatter that it was %s (seconds since the epoch) and ask for the output %k:%M.The output is an hour too long. (FME 2016.1.3.1)6861 comes out as 2:567861 comes out as 3:11That's not right, is it?

I have been struggling with this issue for two days. In summary, I am reading in some locations with the intent of creating mapping tiles only for those locations (the territory I am covering is huge, so an overall raster + raster tiler is not an option). The flow of the workspace is as follows:Read the "Sample.csv" Calculate the tile boundaries and tiles index numbers based in the PyTileMaker scriptSort the tiles so that similar tiles are grouped (in TileSorter)Generate the tiles bands, raster and points-in-tile in PyMakePointsIn the last step, I need to produce 4 bands (as in RGBA). The raster and bands are 256x256. I can generate the 4 bands if I use FME_INTERPRETATION_UINT8 for the band properties and a UInt8BandTilePopulator to generate the band. Unfortunately, the resulting raster has no idea which band is which in terms of RGB or alpha.So it seems logical that one would generate bands with the proper interpretation property, such as FME_INTERPRETATION_RED8 and a band p

I am wanting to translate a list of files in a directory from one raster format to another by calling an FME workspace using the Python fmeobjects API.import osimport syssys.path.append(r'C:\Program Files\FME\fmeobjects\python27')import fmeobjectsworkbench = r'D:\ESRIGrid2GeoTiff.fmw'directory = r'D:\Test\A Folder'raster_files = [os.path.join(directory, raster) for raster in os.listdir(directory)                if raster.endswith('.asc')]parameters = {'SourceDataset': '\"' + '\" \"'.join(raster_files) + '\"',              'DestinationFolder': directory,              'InputCoordinateSystem': 'MGA94-54'}fme_runner = fmeobjects.FMEWorkspaceRunner()fme_runner.runWithParameters(workbench, parameters)From the log file its seems the issue is that the FME reader splits the paths where there is a space in a folder/file name, even though each path should be enclosed in double quotation marks. I can run the workbench successfully from Python if I input a single file and through FME directly witho

I need to replicate the Select by Location function in ARC.The catch is that I need to be able to set a negative search distance. i.e. I need the polygons in the candidate layer to overlap the filter lay by at least 2 meters. see ARC settings belowI have tried the Spatial Filter and Spatial Relator however I cant see where you can specify a distance.The Neighbour Finder lets you specify a distance but not a negative. Please Help.

We have a locally customized projection grid in Chile, presented as (X,Y) values in an Excel spreadsheet. How can I plugin the grid into FME to be recognized?

I have a group of features that are merged together into a spatial boundary (buffer of 25 feet) and I'd like to scale each group of features (lines included) from a known center point to a scale that would make each group more readable with labels. The number of groups varies from map to map. Each group is created as an inset map to a PDF. The brown diamond is where the center point is and the anchor point for my scaler. I wonder why the scaler transformer doesn't have a group by.

Is it possible to convert a surface to 3d pts, lines or polygons background: I've been given a surface from Civil3D and wrote it to an esri filegdb multipatch feature class using workbench, however you cannot use a multipatch with the surface tools in esri (contour, difference etc.) so i am attempting to recreate the autocad surface as an esri TIN. we don't have access to the masspoints or breaklines that originally generated the civil3d surface

I have in my test spatialFilter that brings in 4 polygons Filters and 11238 Candidates, but the trans only returns Candidates for the first Filter. I get 10 records but should get 40.

For a project I’m trying to use FME to directly write XML formatted metadata, stored in an attribute, to an ArcSDE Oracle database with FME. Following these examples (1&2), It works fine with a SDE Feature Class & the Esri Geodatabase (ArcSDE Geodb) writer. However, for a SDE Raster Dataset I’m experiencing some difficulties: The Esri Geodatabase (ArcSDE Geodb) writer won’t let me write to SDE Raster Dataset The Esri Geodatabase (ArcSDE Geodb Raster Dataset) writer doesn’t have the option to set the allowed geometries to geodb_metadata.Does anybody have experience with this issue (and perhaps a solution), or am I doing something wrong?

Hi,I have a workspace with two creators which I use to create a single constant text line each. The rest of the workflow reads data and creates text lines depending on the content of the data (10 lines in this example). Now I want to write the text line of the first creator first to a text file, then the lines generated dependent on the data and the text line from creator_2 last. As Creator_2 is much faster then reading all the data in between, in the resulting text file I get the text line from Creator_1 first, then the line from Creator_2 and the lines from the data last. Is there a way to control that the line created by Creator_2 is written last?So far I can only see that the Creator order can be controlled...thanks,Ludwig

I've tried a combination of CoordinateRounder, Snapper, GeomRefiner, and GeomValidator but am getting the error message after clipping.I've mapped the coordinates from the error message and they appear where the clip has failed. Screenshot below:Green = clipping boundary Blue = needs clippingBrown = clipping failed/did not come through any of the outputs (inside, outside, rejected).Pink = mapped error points to check if they occur at the failed clips.