Transformers

I have a point dataset in Oracle and want to convert it using FME to a polygon dataset.Can anyone let me know how this can be done using FME ?

Data from a 1999 project mapping arable land in northern British Columbia. These soil scientists are few and far between now, and it would be a shame to lose this data.

Hi,I think I am missing something here but I cannot seem to get this to work as I expect. I have some objects sitting on a tile index as the example below.What I am trying to get is the combination of tiles and objects. In this case five things should get passed out but using the SpatialFilter Transformer only four do. It seems that once a candidate has been picked by a filter it cannot be used by another filter. I suspect there must be some way to get around thisI want the job to run much as ArcGIS spatial join would with the one-to-many option enabled. Attached is the workspace and some test data. This is part of a much larger workflow where you have arbitrary number of objects and I want to find out what tiles does each object intersect. If tiles are not used by more than one object it works ok but this case does not so wellRegards.

I’ve spent all day searching for my answer on your FME Q&A; Forum but couldn’t find right answer for me. What I like to achieve.1. Read file names only with extension .json from specific folder 2. Get list of file names from URL using HTTPCaller 3. Check to see if each file names are contained in list 4. If file exist, - Increment counter for update5. If file does not - Increment counter for create5. Once all the records are processed, then - Create email content (2 lines)as follow: # of records updated: xxx (counter) # of records created: xxx (counter)6. Sends Email – replaced with inspector for now.    I tried adding Aggregator before I sent email but it doesn’t preserve counter information. I have attached working workbench and will also post it to FME Q&A; Forum.Thank you

Hi,I have numerous irregular polygons which comes out from a raster extents coercer.What I need is to determine the length along a certain degree heading as well as the width perpendicular to the length measurement for all of these polygons.My idea was to perhaps extract a centre point in all polygons and then draw a line forward and backwards till it reaches the polygon boundary along the desired heading. The width measurement would be similar however with a 90 degree rotation to the previous line extension.Would really appreciate if someone had some good advice on this.

Hello! I am trying to dynamically load tables from an Oracle database (both spatial and non-spatial) to an Informix database. To do this I need to change the case of all the attributes from uppercase to lowercase. When I do this using the BulkAttributeRenamer, all the feature types all become lvarchar. Is there a way to keep the type?

Good morning! I am having troubles with the HTTPCaller/HTMLExtractor. I am trying to pull the zestimate values from Zillow.com for a specific house (right now it's just some random house I picked). The HTTPCaller doesn't seem to be pulling "real" information in it's _response_body attribute field. I've been following the example here: http://docs.safe.com/fme/2018.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/htmlextractor.htm @trentatsafe suggested: "It appears that the HTTP response is looking for verification that it is not a computer. Do you have an account? If so, what is the reponse you get when using your login credentials as the authentication for the HTTPCALLER "I tried adding my login - but got the same results. It's also a bit odd that it is looking for a login, as you don't typically have to login to Zillow to see their values. Any suggestions?

Hi all,I'm having issues working with the Geocoder transformer. I'm using the HERE geocoding service to reverse geocode : e.g. 51.9237996084706, 4.486035956925605The result shown in the Data Inspector show: 51.9161, 4.4784 - which is about 1km off.How can I fix this?Thanks,Ed

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 attributes of that matching Feature_LN to be the attributes that c

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 it would always be the right side. But I want to sure that t

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 make the translation to Python in FME.I know I

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.So my question is: How do I detect this?Best regards, Pijke

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