FME Form

Hello, I'm trying to extract a number out of my comments column. I'm not sure how to write the expression? or if I'm using the right transformer? I'm still new with FME. The number I am trying to extract is 8 digits and is put in comment field with this format "/ 12345678 /" an example of the format is below. VB BLVD / 59208085 / L06-514 / ATT 8547 Is there a way to extract this number?  Thank you!

How in FME would you check that two floats are "close", given testing floats for equality can be a challenge? e.g. "-23.123" as listed in an XLS compared to "-23.12300005" stored in a point feature class? In Python I use the math.isClose() or assertAlmostEqual() Thanks 

Has anyone experienced SMTP email simply not being sent using either the Emailer Transformer or the FME Server Automation Email External Action? I've had each of these things happen to me once, but the same Workspace or Automation run in most instances does send the email. The log file from a sent and not-sent email looks almost identical to me, I've attached both. These are workspace runs with the Emailer Transformer sending the email. I've asked our IT department if they can look into anything, but they can't say much since SMTP is just a relay. Also the fact that it works correctly most of the time makes it difficult to troubleshoot much further.Any thoughts or things to look into would be helpful.Thanks!

I have a SDE feature class that has a date field and another table that contains only 1 record with a date. I would like to query out the records from the feature class where the dates are greater than the date in the other table. The dates in the feature class and in the other table will change. I do not have a way to join the 1 record to the feature class records but I want to use the same 1 date to filter all records. The table with the 1 record could be text file or most other formats.Thanks, David

How to add points with numbers (1,2,3,4,......) over each point in pdf file .i have 20 points and i would like to write in pdf file but i have to count points and add the counting over each point .and what is the best method to resize the point ?How could i achieve that ? Thanks for helpFme 2018  

I am using Teradata JDBC4 Jar file placed in folder path of FME, when provided JDBC connection String like "jdbc:teradata://servername/DATABASE=DB_NAME"the libraries are getting loaded correctly but unable to establish connection. Attached error screen snippets

I convert input features to XML using XMLTemplater. Everything is fine as long it is done through the same sub-template. When I try to process some attributes (coordinates reading) by calling another sub-template it fails. This sub-template works properly **OBJECT Sub-Template**{<object  id="{fme:get-attribute("id")}"  visible="{fme:get-attribute("visible")}"  lon="{geom:get-y-coord()}"   lat="{geom:get-x-coord()}" ></object>} This one, calling another sub-template, doesn't work.**OBJECT Sub-Template**{<object  id="{fme:get-attribute("id")}"  visible="{fme:get-attribute("visible")}"  {fme:process-template("XY")} > Here is the syntax error: unexpected character "{" near line 4, column 5 .</object>} **XY Sub-Template**{ lon="{geom:get-y-coord()}"   lat="{geom:get-x-coord()}" } I did try a lot of things but I still don'

Hi, I would like to ask, does anyone know how to divide data into individual sets based on the same ID? For example, the result will be 5 groups of attributes with the same XOBJECTID.Thank you!!!

Hi everyone,  I have a simple workbench where I added a reader that reads 20+ featureclasses from a nationwide dataset from a file geodatabase.From there the workbench selects 11 featureclasses and uses the clip transform (clip polygon is a province) to clip out a certain area and saves it to a new file geodatabase. Problem with the workbench is that it has milions of features, and the machine I run it on will run out of memory after 5+ hours of processing.  Is there a way to split up the workbench so it will read/transform/write the workbench in 1 to 3 feature classes and waits till the memory is free again before starten the next 1-3 features classes? (maybe with embedding multiple workbenches?) thanks in advance! 

Hi FME colleagues,Neighbor finder transformer finds the nearest neighbor and allotting the same candidate to multiple bases. In my requirement, I need to pair the points from two set of data, but one base one candidate, that means one candidate should not be paired with more than one base.for ex : I have two sets of data, one is Blue and the other is REd. Now, first, the blue base comes and finding its closest candidate (good). Now the second base comes in and finds the same candidate which is already paired with the first blue base. this should not happen in my case, if it's already paired(i mean the closest candidate to some other base) then remove it from the candidate set. the candidate set should go smaller and smaller through the fme process. now what our neighbor finder does is matching with all bases to first(1) candidates. many to one. can we achieve this using any transformer? or any workaround within FME using python caller?

Hello!I'm trying to create a point layer from a set of photos in .heic format. I can see in the photo metadata via Windows 10 file explorer that the photos were taken with GPS on and the coordinates are stored in the EXIF data.I'm wondering how I can use FME in order to create a point layer (and save as a .shp for example) using the coordinates found in the photos, and then attach the photo to each point in the point layer.From what I can see, there is a transformer that can create such a point layer from .jpeg photos but there doesn't seem to be a similar one for .heic.Does anyone have any advice?Thanks!

I have multiple lines and corresponding two point for each line. I want to trim those lines by keeping segment between two points. I have tried pointOverLine which does segment the line but I am having difficulty eliminating remnant.

It seems straightforward enough using the PointOnRasterValueExtractor. The problem is it is only grabbing one value and putting that in all the points. I am guessing that the secondary files with the tiff may hold that 'value,' but I am unsure. The last screenshot shows the data doing it the slow way through ESRI's geoprocessing tools. Any help would be appreciated.

I need to create one list of user names that are in multiple attribute fields.

As the title says, is it possible to creating multiple 2D Min/Max boxes with one creator? Or do I need to have multiple creators, one for each box/ string of coordinates?

Dear FME community, Within a workspace that uses a specific view for reading a revit file, we have found that not all feature types that are present within the specified view are read by FME server. On desktop (using the same version and same workspace) it does automatically read all feature types.  At first we tried leaving the 'feature types to read' option empty, which made this difference visible within the log and output files. Secondly we tried adding all possible feature types to read to the reader, however this also did not fix the issue. Does anyone else have a similar problem and a possible solution? Maybe the cache is used differently on desktop vs server?  Added some log images of the feature types read by desktop (6 feature types read) and server (stops at 3th feature type read). server: desktop: Edit: After adding a featureholder after the readers, all feature types are read by both desktop and server.

Hi All, I'd like to split our entire road network into 5 groups. Each group would cover approximately the same total length i.e. (Total length of all roads)/5The roads in each group would be spatially clustered/grouped togetherIdeally i would not be snipping any road segments I've tried to accomplish this by using the PointClusterer and feeding in the roads center points or 10m interval points but when merging the cluster points back to roads, the grouped distances are too varying.  Is there a better approach to this? Thanks

I have created a 3D model which shows a 'radiation zone' I created this from REVIT > FBX which will ultimately become a KML/KMZ. I have looked at Styling the edges within the Authoring software ie Revit, but that's a non starter.  Is there any way that FME can 'style' the edges of this 3D model on writing to KML ?  Many Thanks, please see my other question regarding the rotation of this object.  

Hi AllI Have the following datasets, DTM, DSM and Colour Infared, and am trying to extract trees over 3 metres in height from the data.I know that i can subtract the DTM from the DSM to give me the height difference but can not see how to have only the raster cells over 3m, nor can i see how to extract the polygons from the imagery.If anyone has any suggestions on how to do this then please comment.  

I have 1 dataset with many overlapping features. These overlaps tend to have a different feature name. I have been given a list that tells me which name takes priority over the other. I want to find the overlaps and then just carry through the areas that take priority. For instance ancient woodland trumps everything. Building footprints trump everything else. Wetlands and pumping stations trump grassed areas.  I have started with an AreaOnAreaOverlayer, generating a list (OverlapAttributes), AreaCalculator, Counter and Tester, where the _overlaps > 1. I've then added a ListExploder.  Where the '_area', '_count' and '_overlaps' are the same, I want to only take the feature with the highest priority name. Am I going about this the right way?I'm a lost as to where to go from here! Attached is some test data and my workbench so far. Thank you!

Hello All, very new to FME, at this moment, I'm generating some nice 3D models converting FBX to KML. The purpose of these is effectively creating a 'radiation' zone. Are there any clever tricks in FME for creating some sort of line/boundary/something when the edges of that KML intersects with a 3D Building in Google Earth? I think this is one of these things where someone says 'absolutely' or 'actually, that's a really good idea! '  Thoughts very much appreciated! TIA  Colin....

I'm having a hard time using the WFS XML filter. I surely built a working workbench before so I am sure this worked. The only thing I want is adding a boundingbox in the WFS (2.0.0) request. I open the XML Filter setting and entered:  bbox=48187,407743,148934,408593 The workbench fails. Log:  <ows:ExceptionReport version="2.0.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://geodata.nationaalgeoregister.nl/schemas/ows/1.1.0/owsAll.xsd"><ows:Exception exceptionCode="XML getFeature request SAX parsing error" locator="org.vfny.geoserver.util.requests.readers.XmlRequestReader"><ows:ExceptionText>org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. Content is not allowed in prolog.</ows:ExceptionText></ows:Exception></ows:ExceptionReport> I look up the URL in the log and there it is: FME prefixed my filter with "FILTER="  FILTER=bbox=48187,407743,148934,408593 When I copy paste the url from the log to

I have a dataset with attachments using ArcGIS online and would like to download the pictures associated to a certain Field in the spatial dataset. Each attribute(row) usually comes with 1 or 2 pictures and the bulk download in ArcGIS has meaningless filename for the pictures.I would to use one of the attribute field names for the photo filenames. E.g. UNITID_0001_photo1UNITID_0001_photo2UNITID_0002_photo1UNITID_0003_photo1

I am new to FME and this is my first post. I am trying to create a workbench that will search through hundreds of windows folders and convert pdf to tiff images. I have tried the ImageRasterizer with no luck. Is this even possible? Thank You

Hi. I'm trying to get a single output from these two sources:County Assessor Parcel BoundariesSurveyed Parcel Boundaries The goal is that, if the parcel is in the Surveyed Parcel Boundaries layer, we use its shape. If not, we keep the County Assessor layer shape. Only some of our records are in both sources. Some are in one and not the other. Which transformer would be best for this scenario, and how would I go about setting it up? Thanks!