Transformers

I have a road allowance that I have divided into multiple sections. I need to number these polygons from one end of the road, to the other, in sequence. When I use the counter and group by road_id, it seems to move from top to bottom in numbering, so if a road curves or is circular, the polygons get numbered out of sequence through the curved area. Is there a way to keep these polygons numbered in sequence even through a highway ramp or a curved street? Any suggestions as to how I can assign numbers to these polygons and keep them in order from start of road to end of road?

Hi,I have a 2015 FME Server that I am preparing to upgrade to 2017.We found out last week that 3 of the 50 legacy jobs do send emails and are in daily use by our DMS team.The email part of the workspaces consists of a FMEServerEmailGenerator transformer and FMEServerNotifier transformer that connects to the topic Email.However there are no Subscriptions configured on the 2015 FME Server.So I'm wondering how is it working so I can port the configuration to FME Sever 2017 and test these important jobs? Every article I read about configuring sending Email refers to a Subscription.I have made a sample workspace and send an email by using the 2 transformers above connecting to the topic, so it is working.I've checked \\Utilities\\smtprelay\\james\\apps\\james\\SAR-INF\\config.xml on the 2015 server but don't see anything specific. I know the SMTP relay service is part of the FME Core in 2017. Any tips would be appreciated.Thanks,Annette

Hi all,  I have to bulk update a whole bunch of phone numbers. The current format is ten digits, starting with a 0. I need to convert these numbers to area code + local number.The area code is either three or four digits followed by a dash (-).  The area codes are stored in enclosed file "PhoneUpdating" The input and output phone numbers are in "PhoneOutput"  What I'd like FME to do:When the first three or four digits in the "Phone" column match with the thee or four digits found in AreaCode: then replace these with the data found in AreaCodeUpdated. (output examples in green)  Example files:Thanks again, Ed

I have the problem that some areas don't become polygon. Don't know why. I tried using snapper and line closer but that did not work. The polylines need to remain as they are in the dwg file. I have sent you a zip file with workbench and dwg file.This is the result I get. Almost correct. You can see in this picture that some lines are missing. Anyone have any ideas how to solve this?

Hello,I'm new to FME and trying to find my way around and could use a little help. I'm trying to subtract one attribute from another and test that it is above one value and below another. My thought was to use the arithmetic editor in the Tester translator, however, the items that pass are not correct. Below is a screenshot of what I'm trying to do but the results appear to be the opposite and have a result value greater than 1000. What am I doing wrong?Thanks!

So I am trying to create a workbench that will take a 3D Polyline and drape the vertices based on the USGS 10m NED data. I would like for the data to be queried based on the 3D Polyline which will be projected into a UTM Zone based on US Survey Feet. The thought of using an HTTPCaller has been suggested, however I am not quite sure on the steps to take to ensure the query is accurate. Has anyone achieved this?

As already discussed here ESRI shape file FME writer issue Shape format does not support arcs.In the linked article it says, that therefore arcs are automatically stroked before writing them to shape.As I had to learn recently this does not work if the arc went through a SurfaceDraper before and turned into a kind of 3D arc (whatever this might be).In that case the Shape Writer raises some weird error message about "extra measures which do not fit to coordinate count ..." - or something like this - and translation stops with ERROR.Solution (as you might guess by now): Use ArcStroker before SurfaceDraper and everything is fine.P.S.: I thought it maybe helpful to post this here ...

Hello,Let's say that I have one big polygon A and two smaller polygons B and C.One small polygon B is fully inside the big polygon A and the other one C is on the border of polygon A. I need to clip them B and C from the big polygon A. I use donutBuilder and for one small polygon which is fully inside, I get a good result (big polygon A with a hole B).The other polygon C which intersects the border of big polygon A is clipped from the big polygon but the part which was outside the big polygon remains as an object. How to get clean cut on the border?

Hi All,I have a data in GDB with some field ID and i want to generate UUID for this in specific format.for this i have used UUID generator but results are not as per my retirements.i.e 32 digit with dash in between eg.I want Entity_ID in such format : 000000000-0000-0000-0000-000000000012.last digit should be from Field ID field.I am not sure which transformer i can use to do this can some body guide me on this ?

!HiI am trying to use this python script which would be very helpful for me. I have a huge amount of data from a WFS which needs to be tiled in a good way. @takashi had a very good code, but I can’t get it to work in 2017.10.154 edition (the version I have).I have a test file with more than 2000 points and I want tiles with 230 points each.I have python installed on my computer and I am using the python caller.I get error messages:” FME Configuration: No destination coordinate system setPythonFactory failed to load python symbol `FeatureProcessor'Factory proxy not initialized f_4(PythonFactory): PythonFactory failed to process feature”Why is that?Any suggestions?/Regards, Tobias

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?