Transformers

I have an XML document that contains a string of coordinates that form a line. I want to create the line geometry from the list of coordinates. My first thought was to use an AttributeSplitter to separate out the coordinates then a VertexCreator and Line Builder and so on. However I'm sure there must be a less long-winded way. I've looked at using the GeometryReplacer, but haven't been able to get that working (I've tried it with various Geometry Encoding options). Any suggestions much appreciated as my knowledge with XML is very basic!<LineString xmlns="http://www.opengis.net/gml" gid="102790531.1" srsName="osgb:BNG" srsDimension="46" axisLabels="x y"><posList srsDimension="46">468763 339612 468739 339598 468712 339581 468684 339568 468647 339556 468603 339546 468562 339542 468540 339541 468530 339536 468337 339604 468335 339610 468330 339617 468322 339625 468313 339635 468307 339642 468862 339504 468856 339510 468838 339528 468823 339548 468811 339570 468800 339592 468793

Hi there,I have some geometry correction problem..maybe you have some idea to help...I have two polygon layers (blue and red). The blue layer (in this example a poylgon with 4 vertices) is the reference layer and is not allowed to be changed. The red layer (a polygon with 6 vertices) has been digitized on top of the blue layer, the vertices of the red layer have been snapped to the blue one. Unfortunately there have been added some additional unneccesary vertices in the red layer. Hmmm, how can I remove those vertices if there are within a certain distance of the underlying segment?

Hi,I would like to export images from a geodatabase attachment table to JPEGs. In the process I would love to write the geoobject feature attributes to name the jpeg.The attachments are joined to geoobject features by a Global ID. I would like to name the jpegs with attributes from "Stadsvandring" and "ID_nr" columns. I appreciate tips on what translators could be used!/Sofia

@andrewegriffin@gmail.com

I downloaded a point shapefile and want to add new attributes and update them depending on what boundary they fall within. In this case, I have a pre-existing MapInfo Table of grids in a city. I want the green points to have a new attribute with what grid they are in. So the points in the upper left would have ANSW1636 in it.Usually I would manually create the new attribute in the table within MapInfo and then update the field using their Update Column feature like below.I'm a fairly new user of FME and am not sure what an easy way to do this is. Also I am using FME 2013 so I won’t have any of the fancy new features after that version.

A direct utf-8 text file to utf-8 text file works perfectly but when I try to write to a system character encoding text file I get an error after a while.I include the log file in the workspace (https://goo.gl/DF46Yx)Any suggestions?

Hello: Has anyone attempted to use FME to capture survey responses from Survey Monkey? If so, what approach did you take? I don't have python experience but I have a survey I need to automate processing the survey responses. Any help or advice is welcomed.

Hi,  I have a dataset containing polygons with donuts. I need to remove these donuts as they are not allowed for further use of the dataset. I manage to remove all these by identifying these polygons with the donutholeextractor. Then these identified polygons are plit by an itterative proces of overlaying them with a rectangular raster with decreasing cell size. As there are big polygons with small holes this gives me a result were these polygons are cut into many many parts instead of just 3-4 parts. Is there a simpler/better way to split the donut polygons that is resulting in just a few new polygons without holes? It does not need to be the optimal solution. It is ok if a polygon is split in a few parts more than necessary. I just dont want to split it into 100+ parts to remove on donut as it is now.  Thx, Rob

Hi all,I have to extract the coordinates of some polygons' vertices from an SDE feature class and write them into a database table. The vertices have to be numbered according to their order in the polygon. I'm using the Chopper and the Geometry Extractor to get the vertices and their coordinates. However I didn't find a possibility to save a number for each vertex. For each polygon I'm transforming the numbering has to start with 1 of course. I first tried the Counter, but I can only get consecutive numbers for all vertices with it. Can I make the Counter start with 1 again when for each new Polygon or is there any other Transformer that can do the job?Thanks in advance for any hints!

Hi, I have a bunch of data in SQL with date stamps and I have had a request to convert the data into our 4 weekly cycles. eg. any dates from 7th Jan to 13th Jan 2017 are a week 1, from 14th Jan to 20th Jan 2017 are Week2 ... Week 3, Week 4 and then 4th Feb to 10th Feb being Week 1 again ongoing. The data continues to be added to and they want me to be able to continue to run this workspace into the future and keep working out on the new data which week is it falling into. Any thoughts

I use FTPCaller to download zip files from a vendor FTP site. The number and name of the zip files can vary. Each zip file has one ESRI file geodb and its name can also vary. I have no problem downloading those zip files and unzip them. I want to load all the feature classes/tables in a file geodb into ArcSDE. As the object names in the file geodatabase can vary, I tried to use one FeatureReader with "Esri Geodatabase (File Geodb Open API)" to retrieve the feature type names, and then use a second FeatureReader with "Generic (Amy Format)" to retrieve the Schema and Data Features. However, in the Data Inspector, I can see the features, but not the feature schema. If connect the 2nd FeatureReader to a dynamic file geodatabase, I will get the error like "Unable to find the schema definition 'di_LegalLease' for feature with feature type name 'di_LegalLease'. Ensure the feature type name is correct and that its schema definition exists in the schema

Hello everyone,I try to export some XML data package via XML Templater. I have many conditions in tag filling and in cases, when tag is not filled, FME left there many whitespace, even if I use XML Formatter. You can check my syntax below:The result is below of template is below:Does anybody know, how to remove empty space and put object tag to the right level please?Thank You so much!Lubo

Is there any we could use FME to compare 2 database schema, to check for any table and any attributes diffrences.

Hey folks,If anyone has a couple of minutes to spare, could you do me a favour and test this transformer on the FME hub: https://hub.safe.com/transformers/spatialsorterIt should run to completion (and not fail in a Python error) and it should return output like this: https://www.screencast.com/t/kRP9ysTq3N (I ran it on the Parks training dataset, but it should work on any dataset).Thanks. I've had problems where it works on one machine but not another. I thought I had it cracked, but the test workspace fails on the hub. I'd like to check if it's just the hub (or just linux) or if everyone has issues.Mark

I have polygons admin division and streets lines, I would like to find lines (streets) in the borders, The orange lines.Blue Squares = Polygonal Admin borderYellow, Green, Orange = Street linesTarget = Orange lines

Hi,A users' progress is being tracked being creating new rows of data, with an incrementing counter in a column like so:I want to only keep the rows with the highest counter value for each users (A, 5; B,3; etc). So only keep the highlighted rows. How can I do this in workbench? Thanks!

I build two topologies (used TopologyBilder) which have nodes on the same coordinate (red and blue nodes on the picture). Now I would like somehow "move" (or offset) one of the nodes. The problem is, the endpoints of the connected edges should follow the node. How can I solve this problem?

Hi there,I have a bunch of small polygons that each have an AREA attribute, showing their square footage. These are contained within several much larger polygons.What I need is if Large polygon A contains 3 small polygons, one 100ft, one 50ft, and one 75ft, I want to generate a new attribute in my output that says Large polygon A contains 225ft. The same happens for Large Polygon B, C, so on. My output is essentially the Large polygon layer, but with the additional new attribute.I did try a spatial relator between the small and large polygons, and then a Statistics Calculator outputting SUM and grouping by the unique ID each Large polygon has, but it seems like the output attribute is the first small polygon contained, not all of them together.Any insight in what I can do different here to get the correct results?

When using AppearanceSetter you can for instance drape an ortophoto on top of a terrain modell. However it seems the texture gets scaled down to a lower resolution. What is the maximum raster pixel*pixel allowed for a single surface? Is it possible to increas this to get a more detailed model? Are there also some limitations when writing this surface with texture to formats like Sketchup 3ds etc?

When I try to use RasterPyramider for freshly created GeoTIFF or JPG rasters - it creates separate raster files (the number of these equals the number of pyramid layers) - instead of pyramids of individual raster file. Is there anything in Parameters I am missing?

Want to write NURBS with FME. Found that IFC supports it, however I guess FME can not write it. Any other format FME can write that create NURBS? (http://www.buildingsmart-tech.org/ifc/)

Hello All,Question regarding the InlineQuerier transformer that harnesses SQL. I'm trying to select a random subset of records from a table. Here's the SQL code in MS-Access that works (different syntax).SELECT TOP 200 *FROM (SELECT Rnd(ID) AS RandomID, * FROM TableNameHere)  AS TableNameRandomSelectionORDER BY RandomID;I think the InlineQuerier uses SQLite...correct me if I'm wrong. I'm uncertain as to which random function I should use and where to implement it within the code string.RND()? RANDOM()? RAND()?And can I add an argument to this function? I need to generate a random sample of records based off the table's primary key ("ID" in this case).This code works, but it only returns the first 200 records in the table (not the random sample I'm looking for), but I feel like I'm close and just need to work a random function in there...SELECT *FROM TableNameLIMIT 200