Transformers

Hello,I have two features: Feature_PT (point) and Feature_LN (line). They have the same attributes but I have added PT_ to the front of the Feature_PT attributes and LN_ to the front of the Feature_LN attributes so that they are distinguishable after I use the PointOnLineOverlayer (POLO). Within the POLO parameters I have enabled the lists with the following attributes:Point List Name: _pt_overlay_list   - Attributes: PT_NAMELine List Name: _ln_overlay_list.  - Attributes: LN_NAMEFor the majority of my data there is a 1-to-1 match between Feature_PT and Feature_LN. My question is regarding the output points from the POLO that overlapped more than one line. I would like to compare each PT_NAME within the POLO - POINT OUTPUT to it's associated _pt_overlay_list{}.LN_NAME to see if PT_NAME matches any of the LN_NAME within the list. I only care about the first match. So, if there is a match, I would like the attribu

Hi,I refer to the following situation in the screenshot.The red lines touch the black building outlines. The grey small arrows indicate the coordinate directionof the building outline part, where the red lines touches the building. The different colors of the building outline parts stand für the quadrant the azimuth of the lines belong to (pls. also see the small legend in the upper left corner of the screenshot). My goal is to find the positions of the yellow dots. There, I need to place text objects perpendicular to the outline. My idea:1. Determine at which build. outline part the red lines touches the building2. Determine the azimuth of this line3. Creating the dashed lines, perpendicular to the outline -> The question: I would like to have only the dashed line which is opposite the side whe the red line touches the building outline. With other words, it should lie within the building. In the sscreenshot it looks as if i

My FME Workbench consist of 5 DatabaseUpdater transformers, each one of the DatabaseUpdater transformer would may update the same row but different fields. If I enable all the DatabaseUpdater transformers, I am not getting the right result, but if I enable one DatabaseUpdater at a time, and run the workbench 5 times, I am getting the correct result. Is this because of the record locking? Any suggestions? Thx

I have a dataset containing a registry of addresses,(street, number, postal code etc. , and an additional field containing information where there's input like for example 24-44 , meaning all the housenumbers from 24- 44 are also included, or - 44 etc.I need to match these addresses with another official address dataset (through the featuremerger), and I want to be able to find matches for all the numbers that are between 24 and 44.I've managed to "mine" the text in the additional field and I've created a new attribute containing the upper range number (in this case 44 )Now, I just need to have features that have the housenumbers that fall between the lower and upper range, and for this I obviously need a python script that can be used within the "pythoncaller" transformer and then run them through the feature merger.I know a little bit of Python, but the little bit that I know apparently isn't enough to m

How does one add the ngdbc.jar SAP HANA driver to FME Server and update the FME Server Config? I have tried to publish a script reading tables using both Native HANA reader and the generic JDBC reader connection and the script will not run. The error is java.sql.SQLException: No suitable driver foundI presume the ngdbc.jar file needs to be here, and FMEServer restarted? C:\\$apps\\FMEServer\\Server\\libCan someone please assist me in setting up the drivers and subsequent CommonConfig changes on FME Server?

Hello,I have published workspace from FME Desktop to FME Server. Inside this workspace, there is one reader (DGN V7) and one writer (TXT). But finally, there are 2 writers, because I use even FeatureWriter transformer for exporting data to SQLite. Unfortunately, if I run WS through FME server job and data download service, I can see only TXT file in final ZIP file. So I have question - is there any possibility to compose exported file through FeatureWriter transformer into final ZIP file?Thank You so much!Lubo

Hello, I have 4 data sets, parcels(polygon), parcel numbers(point), building(polygon) and building numbers(point). On output end i need to have 1 data set (polygon) combined from all 4 input data sets with attribute table. I assigned parcel numbers to parcels using NeighborFinder, and building numbers to building using another NeighborFinder. Now i need to combine Parcels and buildings into one data set. I have exception where building is a parcel and in this case i need to have parcel_id and building_id in attribute table, i any other case parcel have parcel_id but building_id need to be null or missing, and buildings building_id and null or missing for parcel_id. I tried FeatureMerger but i don't have any attributes to join on to. When i connect my outputs to inspector i get closely what I need, is there any transformer that do what inspector does?

Hello guys, I am a new FME Desktop user and I have a Home Edition License. I started the basic training and during the excercises I came across some issues with "Run with Feature Caching" and the "Inspector" transformer. Basically when I turn on the "Run with Feature Caching" or when I use the "Inspector" the translation fail and I get this errors:In addition, the feature "Redirect to FME Data Inspector" does nor work and the Data Inspector itself never opens. Could you please help me?Many thanks

Hi, I have a column 'Flag', where there are duplicate values seperated by '_&_' and I want to remove the duplicate values from it. I tried using the AttributeSplitter and creating Lists, but seemed to be too long. Can we do it with some other way? May be regex or list or something new?

I'm very new to FME and am trying to extract some data from a webpage. The page requires a basic login. I can use httpFetcher to connect to the page but how do I then extract the table elements from the response body?  

Hello :)Goal: My goal is to find the roofs of buildings.Data: I have 3D representations of buildings in the obj format.My idea is the following: 3D Objects to Point Cloud.Point Cloud to individual points.Find their neighbours (here is a significant problem, because as far as I know, there's no 3D neighbour finder). To do this I already tried the 3DBoundingBoxReplacer from the FME Hub, but that's not working on my points.Another idea I had, was to rasterize or rather to create cubes from my points. But I don't know how to do that in FME.Any points with no neighbours below them are considered roof points.Do you think this is a doable workflow to get to the roofs of my 3D buildings? And do you have a cool idea how to solve the problem with the 3D point neighbours?Cheers, Natalie

Hello,  I was wondering if it is possible to extract the exact coordinates from list of addresses that I have. I have no idea how to do it or even if it is possible in FME. I have just list of ~1000 addresses in Excel file and I would need to get the exact coordinates of each address. Is it possible to be done in FME?Thank you in advance!

Hi FME community.I've difficulty to mange my Bufferer transformer.In my case, I need to stop the buffer area to the Start and End point of my line, so I do this configuration (who works with 90% of my lines)But with 10% I've this result and I need to have my lines in the area :This is my test file : Thank you for your help.

Hello,I trying to convert a fme_aggregate geometry type feature to multiple polygon type features with the deaggregator but the input features remains untouched as ilustrated belowThe aggregated features comes from the "Outside" port of the Clipper with "Create aggreate" parameter set to "No" (see below)I am using FME 2017.1.Any idea why it is happening ?Thanks in advance !

Hello.I am working with a SOAP API (I know, not my choice either), which returns JSON inside an XML element. I can extract the JSON just fine, but the JSON itself has an interesting syntax.Inside the JSON is an element called "TblProjects". If there are more than 1 project, it gives them in an array. So far so good, but when only a single project is returned, it gives it as an object. For example: "tblProjects": {  "PrID": "49835",  "PrCode": "486732-14"  }and"tblProjects": {  [  "PrID": "49835",  "PrCode": "486732-14"  ], [  "PrID": "49836",  "PrCode": "486741-10"  ] }I am able to extract these without problem, but I need to detect if it's a single object or an array of objects.

I am looking for a method to create a rose diagram using FME, which is essentially a circular histogram.  It appears FME is not able to produce a feature of this nature to add to maps unfortunately.This website has examples of what I am trying to achieve.https://help.rockware.com/rockworks17/WebHelp/rose_options.htm

Hello,please, I created web application according to this manual: https://knowledge.safe.com/articles/583/data-upload-part-3-rest-api.html. Everything is ok, but I need to user to authenticate firstly before he can run the workspace. Is it possible? I dont want to user had to open FME Server web interface and authorize there, I can do it only on created web application.Thank You so much for ideas!Lubo

Hi everyone. I have 2 esri shapefile polygons. I need to do spatial join of those 2. Features that overlap should have attributes from both input layers. I tried areaonareaoverlayer but the result is not good. Can anybody help? Thanks!

Hi,I'm trying to figure out seemingly easy condition in XML Templator, but something is just not working out. What I would like to do is write out an XML element only if a feature attribute has a value. Here's an example:<OperatingTimeList> <OpeningTime>{fme:get-attribute("opening_time")}</OpeningTime> <ClosingTime>{fme:get-attribute("closing_time")}</ClosingTime> <OperatingTime dayOfweek="" note="we are open"> </OperatingTime> </OperatingTimeList>And I would like the "note" to show up in the XML only when there are some values in OpeningTimeI know I should follow if then else logic, but so far I'm only getting XMLTemplater errors.  (FME Desktop 2018) Thanks,Linda

All: Can someone give me a slight push. I modified the code provided in the TCLCaller sample (provided in the Safe knowledge base - https://knowledge.safe.com/articles/769/converting-time-and-date-fields-to-local-timezones.html) to convert UTC date to EST. I have 5 dates I need to convert to EST and wanted to store them in separate attributes. I've attempted to create an array to return the 5 dates but no luck. I feel like I'm almost there. You will see some of the lines commented because I've been doing a variety of test scenarios trying to get my results.Thanks in advance, proc formatDate {} {  # this attribute matches the FME feature attribute  set QueryDate [FME_GetAttribute QueryDate]  set MROutageDate [FME_GetAttribute MostRecentOutage.OutageDate]  #set EventRepairDate [FM

Hi All,I have upgrade my FMEServerJobSubmitter to version 3 from 2, and now some output parameters has disappeared.- i have been using the number of features output, time start and time finishversion 2 belowafter upgrade, it is no longer available, and make the attribute manager fail

I am trying to use a FileGDB template I have to look up the geometry type for each feature type inside the template. The template has no features just the feature type definitions including the geometry type.If I put an inspector on the Schema output port of my FeatureReader I can see the attribute fme_geometry{0} in the Feature Information panel in the FME Data Inspector.Using an AttributeExposer on either the value fme_geometry, fme_geometry{} or fme_geometry{0} gives me nothing. If I use a ListIndexer on fme_geometry{} or fme_geometry{0} I still come up empty handed.I can see the geometry type in the FME Data Inspector, how do I get hold of it?

Hi,this has been asked a few times, but i have tried all the suggestions with clipper and or donut builder, but cannot seems to get clean polygons, with clippers on the edge.I cannot get to cut nicely on the edges, with clipper or donut builder, the result is a polygon that SQL Spatial don't like.it would be great if we had a tolerance on the edges with clipperIs there possible other ways to get this to work?

Hi there!Is there a way to disable this message? It is very annoying when developing.Thanks

Hello community,  I have a dense hydrographic network on which I am performing topolical corrections. What I wanna do is : 1. Extract start and end node of each line (Done using coordinate extractor + vertex creator) 2. Draw a circular buffer on each extracted node (Done using the bufferrer) 3. Keep only buffers which intersect with other lines (not done yet) Is it possible to get some help doing this task ? Thank you ver much.