Transformers

Hi all,  I'm having issues merging two Excel files - I have tried FeatureMerger but I'm not getting any results.  I have a "main file" that contains a feature "POI_SHORT_NAME".  I also have an "abbreviations" file containing the same feature "POI_SHORT_NAME"  What I'm trying to do: When the postalcodes in both files match then the POI_SHORT_NAME from the abbreviations file should be written to the main file.  Cheers,Ed

Hello,Is there a way to extract the schema automatically from an Excel file when FME Server runs the scheduled workbench?People who drops the Excel files doesn't change the fields though, only the sheet name.Thanks.

Has anyone used FME for Outfall analysis?I have a series of points which represent outfall locations and I need to use the points to follow elevation/DEM to the lowest point on the DEM. Using the path will help me determine what named water body the outfall is effecting.Using esri tools I have to build the dem with contours or lidar points and then use the hydrology tools to figure out the path of each outfall. I think this is doable in FME, but I am not sure I am using the right terminolgy when googleing this so I thought I would ask the community. Thanks,Guido

Hi I would like to know if there's a way to select all the property boundary that do not have public access to the backyard of a house. For example, the properties circled in the screenshot have to be selected because their backyard is directly adjacent to the backyard of the neighbouring house. The properties on the Northwest corner however have a back alley which allow public access therefore won't be part of the desired selection. Any sort of help would be greatly appreciated. Thanks!

https://pubs.usgs.gov/of/2004/1258/Data/grid_facts.txtThe magnetic and gravity grids are available in the following formats: 1. Geosoft OasisMontaj (*.grd, *.grd.gi) binary format 2. Grid Exchange Format (.gxf) (an ascii grid transfer format) 3. ESRI Spatial Analyst (.flt, .hdr) binary format

I’m trying to use FME to transfer attribute data (elevations) from points to the vertices of a Z enabled polyline. I am using an Attribute Keeper so the elevations don’t get dropped, Chopper to break up the lines, SpatialRelator to relate the points and vertices, and rebuilding the lines using the Linejoiner. The Eastings and Northings are transferring over but not the elevations. Any suggesting’s to what the issue could be? Is there an alternative solution?

(I'm using FME Server 2011)  hi FME'ers,  I have a whole bunch of points, millions, and I want to create a grid of squares/rectangles (bounding boxes) covering the points so that each grid feature contains roughly the same number of points.  I'm then going to use this grid to set of a whole load of fme server jobs to process the points - so am using the squares as a way to split up the process into managable chunks, by passing in the min/max x/y values to my 'worker' workbench.  I've split this job up so i'm dealing with 10k chunks, so want to divide this 10k square into smaller squares (or rectangles) based on the density within the square.  I also want to reduce the number of jobs I create on the server, so only want to break up the tiles when they are over a certain point count - say 5000, and group them to between 3000-8000 say.  so in the picture below, I want all the green /amber tiles grouped together (but only if they form another square or rectangle

Hello.I need to insert a dash into a phone number after first  digit. I know how to do it using attribute manager and text editor only  if the length of the number is always the same. In this case is not. Is there a code I can put instead of "X" to indicate the rest of the value? If I will put fixed number the outcome is incorrect because of mentioned before different string length.Maybe there is other way?Thanks,Cheers

I have a multi-arc feature in ArcGIS (4 parts) but FME treats it differently. Any suggestion?The personal geodatabase: Thanks in advance.

Hi  I have a 3D city model made out of individual polygons. Polygons forming one building have a common ID (also attr like Type: Wall, Roof). I need to combine/merge/aggregate together shapes beloning to each building. The output should be a shapefile or multipatch.   I tried using Aggregator in combination with Dissolver and Sorter but data looks fine only in FME viewer. I try to use it in ArcGIS Pro, CityEngine and also in Microstation but data is completely distorted.  When I load non-aggregated data in ArcGIS Pro it works fine. But the problem is it has to be combined before I can use it for my project. Any idea what could be wrong or what other ways I could use?This is my setup And this is the result when viewed in ArcGIS Pro Here's sample data, maybe sth is wrong with this data?

Hi all,I'm looking to trim a string to max. 35 characters. Actually 34 characters and ending with a "." to indicate the string has been shortened. What transformer can I use? Or does this require some RegEx?Thanks,Ed

Hi All,I am using a python caller which is reading some rasters from a folder location and writing them to a mosaic dataset for which i am using arcpy.AddRastersToMosaicDataset_management code(attached below). The error which i am getting after running the code is shown in the image attached.I tried running the code from Arc Catalog python window and it ran successfully. I am not sure what is going wrong here. I tried changing the python interpreter to Esri ArcGis Desktop Python(2.7) from Python 2.7 using Tools->Options->Translation but it didn't work out.Please help.

In my dataset, I have 2 columns, one for x and one for y. How do I create a point from these attributes in FME? How do I turn these attributes into a spatial geometry representing a point?

I created a Smallworld Reader with Alternative: |AExporting Changes from Baseline: YesBaseline Alternative: |ABaseline Checkpoint:BThe difference between the baseline and Alternative is 1 insert, 1 update and 1 delete. I added an Inspector to the reader and it only detects the 1 insert and 1 update. How can I identify the deleted object? The deleted object is native to alternative A, it was not an insert and delete type of object. In my Smallworld application, it also tells me my changes between the Alternative A and the checkpoint are the 1 insert, 1 update and 1 delete.

I mistakenly truncated the feature class with geometry for a ESRI Legacy SDE. How can I put back the geometry? I tried to do a direct copy that from a different legacy SDE source for the same feature class. However, the geometry is still not copied over (my guess is that the Geometry is disabled -- whereas compared to the normal SDE, you can indicate that it is a geom_point). In the FME Data Inspector, it is saying Geometry is not available and shows zero records (but if I query that there are records but no geometry)How can I solve this issue?

I have two datasets, 1 and 2, containing addresses. The address consist of all the 4 fields.I'm trying to compare the two datasets, to find matches between the two. I have already used a stringreplacer, to remove all the spaces in the postalcodes, and to replace all the special characters in the streetnames.In dataset 2, the addition2 field contains a lot of random information, as you can see. I need help compiling a python script (to be used in the python caller transformer or any other transformer) that's able to:- detect when there's more than one character in the addition2 field (I expect that field to contain only one character) and filter that record out;-from the filtered records, detect the first (or maybe first three?) characters in the addition2 field, and use that to recheck the address in dataset 2 with address1, to see if there's a hit. - if there's no hit, I want fme to ignore the information in the addtion2 field, see it as an empty field, and then co

Hi,I am trying to scale a number of text (containing map legends) as such ; with the number of generated x coordinates within a specified bounding area the texts will be scaled up/down relatively. For example, if I have 5 'x' coordinates generated in a map area , the scale factors in X: ang Y: will be 5. I have a atrribute where it saves the nuber of generated 'x' coordinates and i would like to read the valus from there as X: and Y: scale factor in Scaler. But when I try to read the column values in Scaler transformer, it rejects the tranlation. Any idea how to solve the problen ?

I would like to exaggerate my elevations in a xyz point cloud. Is there a transformer which would simple allow me to define a simple formula e.g "z*4"?

I have a DATETIME string of the format 20180311140001Which is YYYYMMDDHHMMSSHow can I subtract 10 hours?Note: I have FME2016, so I lack the DateTimeCalculatorOnce I have calculated the above, I still need to do more tweaking, but that is string manipulation, not a math calculation

Hi,I have a special collada file is seems. FME is able to correctly read and view the model however when it comes to textures, it's falling over.We have a .dae file that uses Instance_material to refer to a target file directory and also makes reference to an object in the same call.e.g<instance_material symbol="wall" target="../materials/wall.dae#wall" sid="wall">    <bind_vertex_input semantic="uv0" input_semantic="TEXCOORD" input_set="0"/></instance_material>I found only one reference to someone with a similar issue. I used https://www.khronos.org/files/collada_spec_1_4.pdf for referenceand https://www.khronos.org/collada/wiki/Using_URIs_in_COLLADA .In theory it should work, but perhaps this is not supported in the Collada reader? Thanks.

I have a few thousand points in an SDE layer and I need to see which points intersect or overlay a polygon layer (hundreds of polygon features). Intersecting points will get a risk value assigned to them (I was thinking through a test filter and attribute creator). Non intersecting points just won't have a risk value and all points whether intersecting or not get written to a point featureclass I already have created in SDE. I've tried PointOnOverlay, Intersector, and even SpatialFilter but I must be setting this up wrong. Any ideas? Many thanks

Trying to tile a Microstation DGN file into tiles. Used Raster tiler on an ECW and that worked fine. It appears that Tiler doesn't work the same on vector files. Why is that?

First off, is there a location where I can download the dashboard pages? Our dashboards seemed to have gone missing.Secondly, I'm looking for a way to get what is coming out of the JobHistoryReader, but including FME_SERVER_REQUEST_PARAMETERS and FME_SERVER_REQUEST_HEADERS arguments with an FME job so I can run stats and be able to filter stats based on remote address or an application ID that is passed through as a parameter. Has anyone done this or have any idea of how to do it?Thanks in advance!

I have downloaded a 3D Sketchup model from Sketchup warehouse and trying to convert it into 3D pdf ... A blank pdf file is resulted.. Execution Summery:Starting translation...FME 2017.1.0.0 (20170731 - Build 17539 - WIN64)FME_HOME is 'C:\\Program Files\\FME\\'FME Database Edition (node locked-crc)Serial Number: 0Temporary License: 30 days left.Machine host name is: Anuj-PCSTART - ProcessID: 8816, peak process memory usage: 31788 kB, current process memory usage: 31720 kBFME Configuration: Command line arguments are `C:\\Program Files\\FME\\fme.exe' `C:\\Users\\Anuj\\AppData\\Local\\Temp\\wb-xlate-1517680516554_10516' `LOG_STANDARDOUT' `YES' `LogCountServerName' `{e9a3db67-8fcd-4a27-88f3-14e3fc738201}'Shared folders for formats are : C:\\Program Files\\FME\\datasources;C:\\Users\\Anuj\\Documents\\FME\\FormatsShared folders for transformers are : C:\\Program Files\\FME\\transformers;C:\\Users\\Anuj\\Documents\\FME\\TransformersShared folders for coordinate

Feature is not a 'line (spaghetti)'. Migration to 'point' attempted for feature destined for table 'ACE.T_OH_LINE'Error while generating line shape for Table 'ACE.T_OH_LINE'. Scale Factor may be too small.:SDE_ERROR_CODE(-148) The number of points is less than required for feature