Transformers

ArcGIS Intersect gets the exact result I need, but this task needs to be performed in FME. I haven't been able to find the exact output result. With Spatial Filter it did not duplicate the results if the same line fell within two or more buffers, it would only grab it once. Below is an illustration of what I would like to achieve. Also, of course, I would want this to produce an excel report on which buffers intersected which lines

HiI have generated a Convex Hull table for a address table, grouping by postcode in the address table.I want to print individual maps for each of these postcode areas based on whether they would be betteroff in Portrait or Landscape Orientation.Can someone advise how i obtain the Bounding Box Ratio for each of the Hulls?I've added the Bounds Extractor transformer into my workspace, but that doesn't seem to give me the ratio.Is there a way of updating a new column (to indicate which orientation is best) using a calculation within FME?Thanks for any assistance Simon Hume 

I have two feature classes one is point data another one line data that is Road and I need to select only which points are placed in between DC road.Refer Below Image for more clarity Please suggest...

Hi All,I've got a situation where I am dynamically feature reading in any number of feature types, and exporting via the generic port. I then have a list of all possible feature types and the schema mapping required. Am I right in assuming the SchemaMapper requires attributes to be exposed to be "mapped"? I'm looking for a solution where the SchemaMapper can see the dynamic unexposed attributes and map them.

In case you missed it, Craig, the leader of our sales team, decided to launch himself off the side of a hi-rise building last week. Don't worry he was all strapped in and it was for a great cause.So I thought this picture is a great opportunity to have a caption competition here. You know, what FME-related thought might Craig have been thinking as he prepared himself for his descent?Perhaps, "I sure hope these guys used a StringLengthCalculator"?!There's no prize for guessing what Craig was really thinking, but then there are no prizes for your captions either, except for maybe some reputation points and the admiration of the FME community. So post your suggestions below. Keep it clean, please! And if you want to see more, then we have

Hello, I have a BLOB field, it is supposedly multiple points that form a polyline, but I cannot export the blob into a usable geometry. I have tried GeometryReplacer and GeometryExtractor but I have not been able to get usable results. I attached an excel file with the BLOBs

I have 2 dates and an interval.I need at least to generate a list of dates between given ones with a certain interval (step).As a maximum I need to combine list of dates with list of items.Please refer to the picture below.

Hello Community,I am having some challenges writing multiple records into a valid json output. What I have is working using a text writer but it is missing the comma "," between the individual records. I was about to explore building a list and change my json template or do i need an aggregate? I seem to be confusing myself with this small detail.Below is an example of my current output into a text writer. I pretty much followed the Json Writer article (https://knowledge.safe.com/articles/44294/json-writing-with-jsontemplater.html ) which was a huge help but the difference here is I am fanning the output by date so multiple records will be written I just cannot figure out how to make the json valid.20190711.jsonI believe just ne

Hello,Is there a possibility to change the start/end point of closed curve? I created closed curves using the LineCombiner (for merging line segments to 1 closed track with the same start and end point). Now I have a shapefile with starting points of tracks, and I want the closed curves to start/end in their starting point instead of the random start/end that is created whith the LineCombiner. Anyone an idea how to do this?

Hi there!Does anyone know if FME can read PDF Form Fields? These are editable fields that can be set up in a PDF editing program (such as Adobe) so that they can be entered into after publishing the document. Useful for building forms. I could not find if the FME Geospatial PDF Reader can access these or not? Can someone enlighten me?Cheers.

Hello,I'm using the AreaGapAndOverlapCleaner to clean some gaps in my data. However, the transformer shrinks the edges of some narrow polygonal water streams I have. How to make the transformer operate just between features and not in the inside of the same feature ?Thank you.

Hi , I want to combine two tables into one . Someone can help me ?

 Hi allI would like to find out below the points which are X and Y, what the chainage is for each point?The line I have is the road which has a chainage to and chainage from for each section. But i want points to automatically link to line so it picks up the road chainage.What would be the easiest way to find the offset of the points to the line? I also have an option of point to point, so find nearest point that it can offset to if that option is also possible.Much appreciated

I am trying to set-up a very simple converter that takes one dwg with defined layer names and output to a new dwg that matches the layer names that we want then to be called. Unfortunately all feature_types in the output end up the same feature type.  

I have to add 2 Vertical Coordinates systems to add to FMEThese are: WKID 6647 (CGVD 2013) Orthometric WKID 5713 (CGND 1928) Normal-orthometric*I have all the required grid files in .byn format and installed, that I understand to be able to work with the CSReprojector.I'm trying to use the online Define Custom Coordinate System from FME to create a custom coordinate system for 6647 and 5713. I have the ESRI WKT info needed however I cannot submit because I need to reference a Datum. However the datum is vertical and is: Canadian_Geodetic_Vertical_Datum_of_2013 and Canadian_Geodetic_Vertical_Datum_of_1928 And does not appear in the list of Datum's.How do I do this, do I even need to or are the .byn files enough when working with the CSMapReprojector?A second further prob

How can I separate every single word from the string e.g. “GROUND ROUND STATION 49” in String Searcher by using regular expressions? I have never used regular expressions earlier. Expression \\s*(\\w+)\\s* can select first word “ground” but how to obtain 2nd word, 3rd word, n word in single separate columns? By trial-error-method I got the second word by applying this expression \\s+(\\w+)\\s+. However how to create more general expresion? 

Currently I have a schema mapping table stored on a ESRI Geodatabse table. Trying to use the SchemaMapper I found that the reader does not allow me to select the ESRI readers:I tried to create a custom reader that connect to the ESRI Geodatabase, but the SchemaMapper does not recognize my custom reader neither.what should I do in order to be able to extract the schema mapping table for the SchemaMapper from the geodatabase?, or how to enable the custom reader? thanks

is there an easy way to clip a raster based on a shape file with a feathered edge? So use the "clipper" but not just end up with a harsh cut, as I want to merge this with another raster dataset and for them to blend in. or is the "Alpha Compositing: Blending Two Raster Images" method the only realistic method?  The effect i'm looking for is similar to that of a feathered lasso in Photoshop.

I'm trying to replace the per mille sign ‰ to the other symbol with StringReplacer, but this function seems to not work for this particular character. As import file I use .txt-file. Is it a known issue? Is there a workround for this problem? I work with FME 2018.1  

I am using Kafka connector to consume data from Kafka topic.Kafka topic has 5 partitions.I want to configure FME job in such a way that Kafka connector consumes data from topic at partition level making partition as unit of parallelism for better speed. Is Kafka connector has inbuilt feature to handle partition parallelism hiding from developer. That way I can be assured of parallelism taking place with single kafka connector in the job. Please confirm.

I'm trying to call a PowerShell script using the System Caller transformer. The syntax of the system caller command line is: C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe -ExecutionPolicy Bypass -file "C:<path>powershell_script.ps1"I'm using it to access ProjectWise and run some process. I have tested it with PowerShell and it only works with Admin rights. However it does not work within FME and does not recognize the Powershell module commands for ProjectWise. The error I get is:'New-PWLogin : The term 'New-PWLogin' is not recognized as the name of a cmdlet, function, script file, or operable'I have tried running the workbench with Admin rights but it still gives the same error.

Hi I tried to install NLP Trainer on my desk but I received an error (probably python installation)  Francesco 

Hello everyone, I have a workspace that takes 2 point feature classes from a geodatabase and calculates the Root Mean Square Error (RMSE) of the x and y coordinates (i.e. sqrt( x(observed) - x(predicted))**2/n)). As part of this calculation I would have to do a truncated mean calculation where I would drop the top and bottom 10 % of records of residual X,Y values and then calculate the RMSE on the remaining 80% of the records. I understand the statistics calculation for truncated mean but I am not sure how to do this in FME workspace. Any help/suggestion is greatly appreciated. Thank you!

How do i compare data row count from two tables across two databases? Basically i am trying to load data if source has more rows than target table.

Hihow can Export right value of tester into csv file ?ThxFrancesco