Using transformers to modify data.
Recently active
Hi I would like to add different types of xdata for a layer from a .dwg with autocad.
Hello, I hope FME community can solve my problem. I have polygons that represent parcels, polygons that represent buildings, and points that represent parcel and building numbers. I need to add unique identifier to parcels, buildings, parcel id and building id that are on the same parcel. I have attached a picture so I could explain what I need easier (1.png).I have a parcel 2375 and I need to add to new attribute, lets say ID, value 111111 to polygon parcel with id 2375, point parcel_num with parcel_id 2375, polygons buildings 1, 2, 3, 4 and point building_num with build_num 1, 2, 3, 4. All objects in one parcel need to have same identifier in their attribute lists.I will use attributeManager to add new attribute all Features, and Counter to add unique value but I don't know how to group all objects to parcel.
Is it possible to write mixed geometries to a ESRI geodatabase? I am trying to write polygon, points and polylines out to the same gdb but only points are being fed through
Hi,I am using the Geocoder for the first time and I get lot of warnings that feature must have at least 4 coordinates and then my output file has no coordinates.I start with a shp file that has postal codes and centroid for each of the postal code and then I am doing reverse look up using the OpenCage API. I set up inside x and y as my Lat and long and and entered my API Key. Those are the only set ups I did in the Transformer.Am I missing something? Can someone please help me?
I am brand new to FME and am trying to recombine text objects that were broken up by character. I am trying to learn from the transformation documentation, but ultimately am at a disadvantage due to the new jargon. I start out with geoPDF filled with layers that are in turn filled with text and other objects (see above). I need to extract these text objects into a shapefile. The problem is that when I open the layers within FME using the Adobe Geospatial PDF Reader, it breaks up my text objects into adjacent characters. Thus 56 becomes 5 next to 6. Assuming there is nothing I can do about that, I am trying to use either the Aggregator or Neighborhoodaggregator transformers to recombine these numbers. The problem is that I do not understand how to make the Aggregator's group by to work so that by putting the text object's X and Y coordinates in there the transformation would combine them based on their proximity. Neighborhoodaggregator provides a promising method, but I seemingl
I'm reading a source file and this is the output.What I would like to have instead is only one row per Name and then have one column for each number of months (as attribute name) and its RRP (as attribute value).The columns should be the following:header/attributes:Name ; 3-Months-RRP ; 6-Months-RRP ; 9-Months-RRP ; 12-Months-RRPvalues: AR201130 ; 5.82; 11.64 ; 17.46 ; 19.40Thanks for your help.
Hello, I would like to replace the strings that only consists of number for example :11Although I have string that are for example 11 xxx which should not be replaced. In short, if the digit is followed by any word character Stringreplacer shouldn't select it but if the number is there buy itself then select it.
Hi, can't seem to get text included in my raster output png despite whichsettings I use. Point is working ok.Valid ground extents are specified.FME Desktop 2018.0.0.2
Hi,I have an issue executing my workbench (It use to work before). I have a list of url (returning OSM XML files) which I read with a FeatureReader tranformer.I set the proxy parameters of my orgnization correctly (FME options), and it seems to work fine, until the execution fails (and never at the same stage), see the log below :XML Parser error: 'Error in input dataset:'http://api.openstreetmap.org/api/0.6/map?bbox=7.1459,43.6763,7.159,43.6858' line:1 column:1 message:invalid document structure'The XML Module halted on error, see the logfile for detailsThe XML reader has encountered an error.A fatal error has occurred. Check the logfile above for detailsThe url is valid when I test it... Does anyone have any ideas to solve this problem ?Thanks in advance,Fabien
Are there any examples of the SVG write templates being used online?I want to setup a template that allows my features to have both an id and title parameter but without any prefix.So that would be:<g id={value1} title={value2}><path fme:parameters...
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?