Transformers

Is it possible to get label without point? My final format is .kml  Thanks

polygon overlaping

Hi, how do I keep adding records (In red) until I hit 2025 - 12 - 12?Thanks in advance!

I am trying to extract text from a table in a PDF image using the TesseractCaller. But only part of the table values are being returned. The text for the document is the same font and size and the contrast is the same for the entire document. Does anyone have any hints or tricks to get tesseract to return the complete table?

Hi All, We are trying to transpose some data and have run into a little issueWhen we go to aggregate the data back, we get almost the correct data but we are aggregating by time so we get hourly data in columns broken down by hour in the following require format: Times  Mon 01/01Tue 02/01Mon 08/0101:00-02:0043302:00-03:00333 The data is coming out exactly how we want however if we have duplicate days and we are using a group by on aggregation by time, it is missing where we have duplicate days like the above two Mondays in the concatenation on _attr_value as we cannot separate the times on the two Mondays.We just end up with 5 comma separated values instead of 6 in the concatenation.We followed this guide to transpose our row data to column data - https://knowledge.safe.com/articles/31701/trans

HelloI have point layer and related table in ESRI SQL data base. I need to bring it into FME to do some calculations and reporting.But once i bring both of them in FME feature Merger is not working for me. I am using ESRI GlobalID field. I am not sure if that is causing any issues? I don't have any other unique id in both tables. Please let me know if anybody used global id for feature merger or feature joiner? Or any other ideas?any help is welcome!ThanksNikki

Hi FMEers~ Curious around FME's capability of enabling image classification with trained samples, just like the way that ArcGIS/Erdas Imagine do. Having discussed with the Safe technical professional, there is no such transformer developed (yet).Just wondering if any professional has come across a great workaround of doing it in FME. CheersDavid

HiI am a GIS Manager working in a police force in the UK. Our crime analysts use ArcMap and use the "directional distribution" spatial statistics tool (toolbox) to look at directional distribution of crime.see link: http://desktop.arcgis.com/en/arcmap/10.3/tools/spatial-statistics-toolbox/directional-distribution.htm We would like to create those as an output of a workflow which would be automated on a large scale and on a regular basis - however i can't find anything about that kind of spatial statistics tool in FME on the web.At the moment we have an alternative using HullAccumulator to create a area shape from key locations eliminating outliers... but we would like something a little bit more ellispoidal.Apologies but i can not send sample data etc. as senstitive information. Just wanted to kn

Hi everyone, the following screenshot is my custom Python Interpreter:This command is what I used to use to install external packages for Python 2.7: python -m pip install <package_name> --target C:\\Users\\tngo\\Documents\\FME\\Plugins\\Python But it doesn't seem to work anymore. I also get this error when running PythonCaller: The User-specified library C:\\Users\\tngo\\AppData\\Local\\Programs\\Python\\Python37-32\\python37.dll could not be loaded Thanks for helping in advance.

I have a dataset where features contain two attributes - Month and Provider. What I want to do is create a table wherein the Months of Feb to Aug inclusive run along one axis, Provider along the other and the cell contents are a count of occurrences of features per Provider in each month. I've achieved this using a fairly roundabout method - which was ok given that the range of variables was fairly small; however, I can't help but feel that there is a simpler way, presumably using StatisticsCalculator or AttributePivoter...? 

I read this https://knowledge.safe.com/articles/45314/working-with-soap-services.html  to try to wrap my head around SOAP (yes, its a horrible technology!)I`m testing against: https://www.atb.no/sanntid/#collapse-article_2 And the stopmonitoring: http://st.atb.no:90/SMWS/SMService.svc?wsdl I use the SoapUI to generate the request: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:siri="

I am trying to find the elevation of the most prominent "peaks" in an area, but am stuck.  I have used a number of polygons to Clip a selection of mountains. These are in a raster DEM format. Now I want to find the highest point on each mountain, along with it's position. This will later be saved as a point feature.  Using the RasterCellCoercer results in an insane amount of data. I have tried to filter out the highest values before I proceed, but have not yet figured out how to do so.  The RasterBandMinMaxExtractor with a ListExploder gives me the highest value for each raster area, but I also need the position of this pixel.  Any suggestions on how to proceed? How can I get both the highest value, and it's location , without turning my computer into a toaster?

I have prepared a mosaic data-set that was created from a previously downloaded set of images. I would like to clip this mosaic data-set with a CAD file polygon to select a small section.I've tried using Clipped but it seems like the mosaic data-set has NULL geometries, so it fails.Is there a way to clip the data so I end up with only a small section? I've attached the mosaic data-set, the CAD boundary and the Workbench for your consideration.    

When reading data from an Oracle database where the table holds timestamp information then I am getting the errorError converting from OCI datetime to C character string : `ORA-01805: possible error in date/time operation' (serverType=`ORACLE8i', serverName=`***', userName=`***', password=`***', dbname=`')In FME Desktop 2018.1.0.2 can I reproduce the error in OracleSpatialObject reader and in SQLExecutor. The error does not occur in FME Desktop 2017.1.2.1, neither does e.g. DBeaver has a problem to read and show the timestamps.I checked in FME Desktop and in DBeaver with select * from v$timezone_file what timezone_file is used, and in both cases it is timezlrg_18.dat

Hello all,I am trying to create an XML file that has a structure where there is a single plan, non-spatial, that has one or more polygon features(parcels). Each polygon feature is made up of multiple line which in turn is made up of multiple points. The plan is a database table without any geometry so I have done a feature merge using the bounding box of the parcels. I then chop the parcels into points and lines and feed the three outputs into the XML templater, using the plan as the root feature.What I am trying to acheive is the following PlanParcel 1Line 1Line 2Line 3Line 4Parcel 2Line 5Line 6Line 7Line 8 Point 1Point 2...Point n but what is coming out is a list of all lines rather than just the lines for the individual parcel. PlanParcel 1Line 1Line 2

On FME server i have a job that has a User parameter. Is it possible for someone else in our organisation, whithout any rights, to run this job and browse to his data (user parameter) and the job continues . In FME server there are url`s to share the job, but the user must have rights to use/access FME server.

Hi guys,I have 02 shapefiles (point and line), I want to find the nearest line for each point [relation 1 (line) to many (point)] inside a diameter of 15m and to find the relative position of those points. Thanks for help

Hi,I have a series of regular expression and new string pairs.If the regular expression gets a match I don't just want to replace the characters that match I want to replace the whole matched string with the new string.As an example;If the old string is - CAROLA 1.6ABCThe regex is - C[AO]?[CR]R?O?O?L?L?L?LI?A?The new string needs to be - COROLLATo make matters more difficult, there are about 400+ unique pairings. Thanks in advance

Hello,   I am reading in 2 feature classes into a Spatial Realtor transformer. I need to be able to automatically determine which feature class has the higher number of records/features and which has the lower. This will then determine the Requestor (feature class with higher number), and Supplier (feature class with lower number of records) for the Spatial Relator.   More like an if statement, if feature class A is 10 and feature class B is 5, then connect A to the Spatial Relator requestor, and B to Spatial Relator supplier. I don't want a new attribute to be created within feature class A or B.  How can I do this?

I have a geometric network of connected wells, pipelines and facilities. The wells act as the source nodes, the pipelines act as the links and the facilities act as the sink nodes. I also have a point feature class at every pipeline junction section already created from a different script. What I'm trying to do is use FME to create a new point feature class (call it Attribute_Flagger) at any pipeline junction for the pipelines that connect at a junction but have a mismatch in the MOP (Max Operating Pressure) or H2S fields. Below is a diagram I created to understand this relationship better.  Does anyone have an FME solution to this problem?

Hi,@takashi I have a list of data as the attached xls sheet. I need to extract specific attributes which come many times in the list. The list contains attributes with the value [name:(different names)] and under this one there are attributes start with the value (string:......). I need to loop through this list and extract the attribute which has the value (name:USED_DATA) with all attributes underneath it which start with (string:.....). The rest I don't need it. The list contains information about many objects. Each object has index starts with 0. So, each object has attributes which I need to extract. Unfortunately, the attribute with the value (name:USED_DATA) comes with different index (so not regular) and this is why I can't use an existing transformer in FME to do what I need or at least to my knowledge. Could you please guys help me with it. Maybe there is a trick to do so which I couldn't find. Looking forward to hear from you

Hello all,I've come up with a difference between Regex editor and workspace run result.As you can see below I'm expecting to get 28 matches for the feature which has the value written in Test String box in its pdf_page_text attribute. However, the string searcher transformer returns none.Does anyone know what causes this situation?

Hi,    I have an XML document containing coordinate values having 3 decimal places: e.g. <X>259.042</X><Y>1521.734</Y>. My workspace transforms (X, Y) values to point geometries with 2DPointReplacer and writes those into a File Geodatabase with FILEGDB writer. Translation finished successfully, but when I confirmed the GDB with the Inspector, I noticed that the precision of coordinate values has been changed like this: Source XML: (259.042, 1521.734) Destination GDB: (259.0419921875,1521.73400878906)   In addition "XY Tolerence" parameter of the FILEGDB writer is set to default (i.e. blank), and the environment is: FME 2013 SP2 Build 13499 Win32.   When I wrote the same data into a shape file via the same workspace for comparison, such a change has not been occurred in the shape file. So I guess the FILEGDB writer caused the change. I can modify the precision using the CoordinateRounder after reading GDB, but ideally, of c

I have and ESRI Geodatabase line feature containing a mixture of arcs and normal lines. I tried extracting the arcs using GeometryFilter but this doesn't work because although FME recognises that the segment is an arc, the geometry type is "line".How can I filter these arcs?

Hi, I have been successfully using the AGOL reader to download attachments, but would now like to use the FeatureReader transformer instead so I can feed in an SQL query (created earlier in the workbench) into the WHERE Clause, so it only reads new attachments. But there doesn't appear to be an 'include attachments' option like an a normal reader?Any ideas if it is possible to get attachments when using a FeatureReader transformer?Thanks