Transformers

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="http://www.siri.org.uk/siri">   <soapenv:Header/>   <soapenv:Body>      <siri:GetStopMonitoring>         <ServiceRequestInfo>            <!--Optional:-->            <siri:ServiceRequestContext>               <!--Optional:-->               <siri:CheckStatusAddress>?</siri:CheckStatusAddress>               <!--Optional:-->               <siri:SubscribeAddress>?</siri:SubscribeAddress>               <!--Optional:-->               <siri:ManageSubscriptionAddress>?</siri:ManageSubscript

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 2Line 3Line 4Line 5Line 6Line 7Line 8Parcel 2Line 1Line 2Line 3Line 4Line 5Line 6Line 7Line 8Line 5Line 6Line 7Line 8 Point 1Point 2...Point n I have tried grouping but that then seems to have affects on other features.Attached is my X

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!Kind Regards,,, 

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 course, I want

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

I'm given a location of files. I'm using the directory and files reader to get all the files in that directory. I then use the featureReader to get only the csv files. There are 181 attributes so instead of exposing them, I'm specifying a feature type to read. The csv files all have the same attributes, just in different orders. For instance one file could have attribute1,attribute2,attribute3 and another file would have attribute2,attribute1,attribute3. I'm using attributeManager to calculate some values and because all the files have the same attributes, I just used the order of the first csv so the order of the attributes leaving attributeManager is always attribute2,attribute1,attribute3.I am writing out csv based on the name from the path_rootname (to a different folder). The issue is that I need the output files to retain the same attribute order as the input csv. Because all features enter the AttributeManager, they all come out with the order from that transform

I have an issue where I am trying to create a PDF output but the data is not filling the objects defined. The data object is defined to fill the majority of the page but as seen below the output only fills a portion of the page.  Is there a way to force the data to fill the area defined? Here is the workspace that I am using -

I am trying to use SQLExecutor to either insert or update a record in a table stored in Oracle - please see sql below. It gave me the following error. any ideas why? declare counts int; begin select count(*) into counts FROM employee where emp_id = '@Value(empid)'; case when counts = 0 then INSERT INTO employee VALUES ('@Value(empid)','@Value(firstname)'); when counts = 1 then UPDATE employee SET firstname = '@Value(firstname)' WHERE emp_id = '@Value(empid)'; end case; end; An error occurred while accessing a table result for feature type `'; message was `Execution of statement '......did not succeed; error was `ORA-06550: line 7, column 14:PL/SQL: ORA-00933: SQL command not properly endedORA-06550: line 6, column 30:PL/SQL: SQL Statement ignoredORA-06550: line 9, column 4:PLS-00103: Encountered the symbol ";" when expecting one of the following:

I'm using a Clipper with a polygon feature to clip for features in a DGN file within a project boundary. For some reason it rejects the Clippee features. After looking at the Clippee features I'm seeing that there are NULL geometries in the file.Can anyone explain how the NULL causes the Clipper to fall over?Is Clipper the best way to clip for objects within a boundary? Workbench is attached without the geometry filter to filter out the NULL geometries.  

Hey,  <-- I saved the template with source data here I am currently using a trial licence to see if FME is what my organisation is looking for, so please bare with me as I am very new to FME and the terminology.The first task I am trying to achieve is converting a large CAD document for use in our GIS System (I see this is very common, and I have watched several youtube tutorials and a few Safe videos, so I understand the basic concept). I have created my first Project, it works for 90% of my data, its the last 10% I am stuck and needing advice on. As you can see i have my CAD input on the left, a few filters and the likes, and it outputs to my GIS tables on the right. It is the 'Annotation4_History' that is causing me grief, and I am unable to decipher the error message. I am sure it is telling me what is wrong, I just dont understand how to fix it.The input parameters on the cad document are (note: used Group By Geometry):If I disable the writer 'Annotation4_History&#3

gps coordinates and time stamps from aerial images

I have a parent workspace that successfully launches child workspaces via FMEServerJobSubmitter.These launch successfully and complete but then the parent workspace does not release the features to the next transformer.It's running on FME Server 2018.1.2 - Build 18590 - win64I have it to submit jobs in parallel and to wait for jobs to complete which are the settings required but it isn't releasing the features once the child workspace completes.Log file just hangs with the following lineFMEServerJobSubmitter_2(ServerFactory): http://******** - Running workspace '*******_Child.fmw' in repository '******** Child' in parallel...Names redacted for security reasons.As mentioned, child workspaces run successfully.Nothing in the log files or monitor log files to suggest anything strange is happening and this processed has run successfully before.Any thoughts? 

HiWhen I created my Reader, I can read all my data and especially my geometry column but this column doesn't display . I try different coordinate system but it does not match. Same issue.What's wrong with this Reader ?Thanks

I am trying to find duplicates in my xml data and from that I would like to apply condition.  here is my xml doc  <results>    <book>        <id>1</id> <status> published</status>    </book>    <book>        <id>1</id> <status> not published</status>    </book>    <book>        <id>2</id> <status> sold</status>    </book></results>From the above xml, I want to find book id where id's are repeated and the status is published then return .<book>  <id>1</id> <status> published</status> </book>using XQuery  . Could you please help me on this. Thanks in advance.