Best Answers

I have asked this on GIS SE but seem to have had little interest. I imagine it would be more suitable to post here.How can i prevent sloped buildings when I extrude building footprints over sloped terrain? I am using FME to drape 2D features over terrain (SurfaceDraper), then using the Extruder transformer to create 3D buildings from OS Building Heights. Unfortunately the height value seems to apply itself to each vertex, which creates sloped building tops (roof geom is not relevant here) - example below: Is there an extrusion method that uses a single vertex, or is there another method entirely?

Hello, I have measured some points on some piles of dirt that I need to calculate the volumes of. I have got some points by the foot of the piles and some on top of them to define their geometries. Now is the question how to use this data to get the volumes? I have managed to get a TIN surface from the TIN Generator but I cannot calculate the volume unless it is a solid, right? Any ideas..?

I have an example of something I can do in Excel but looking to do in FME. Please refer to the PDF attachment....The first image shows a snapshot of a fictional table of data. Each employee has a unique "EmployeeNumber" and also a unique "CardNumber". The field called "Event" shows a record of every instance over a week, where an employee has either "swiped in" their card to enter an office building, or has "swiped out" to leave. So for example, Hannah has used her card 5 times in the week to either enter (swipe in) or leave (swipe out) the office.The second image shows a pivot table in Excel, which sums the number of times an employee has either swiped in or swiped out. I have then added the field called "Difference" as I simply wish to compare the number of times an employee has swiped in compared to when they have swiped out. And I am especially interested where the difference is 1 or more.My query is this ; can FME replica

Howdy y’all!XML newbie here and I have to build a workspace to parse a xml file. I’ve been messing around with the xml reader a bit this morning and cannot seem to get any results. One of the things I noticed immediately is that the field names seem to be only contained in the metadata. Can someone out there maybe show me how to parse these data and write them to something more favorable (excel, shapefile, geodatabase etc)?Here’s a link to the xml file I’m trying to translate - https://drive.google.com/open?id=0B52_Im1hHfSbOWM2cnA0NDAxdGcThanks in advance for any/all help.

Hello everybody, i have mapped my sql server table to an xml schema and final output we are getting metadata of tables. To input related Foreignkey information inside metadata we have a field and we mapped it, problem is for many rows we dont have values, we have NULL. From current mapping values are coming and NULL values are creating empty elements in final xml file. Please see the screenshort. We want to delete the total bnr:foreignkey element for NULL values. Please correct my code if someone can help me. Thanks a lot. Looking forward.

Hi everyone,I am using a ChangeDetector, only on one attribute "parcelle", to compare differences between polygon layers, but there is a problem because all of the polygons are detected as "changed" (then they should not, because values of "parcelle" attributes are the same in the two layers) :Port 1 (Added) :Port 2 (Deleted) :I thought that the problem was because of the encoding of these attributes. So I have tried to use the AttributeEncoder Transformer, but it changes nothing :I also have tried a FeatureMerger on these attributes and it works.Thank you.Aurélien

Hello,please, I wanna solve one problem with line elevation on wastewater network. I have really big network of lines in 2D, but every line has 2 attributes (BOTTOM_ELEVATION_FIRST - elevation of first line vertex and BOTTOM_ELEVATION_LAST - elevation of last line vertex). Unfortunately, values of these 2 attributes are not filled for all features. So, I have situation when some features have both values, some features have just one value and some features have none values. :-/ What I need is to join lines according to fact if the attribute of elevation is filled or not - the goal is getting lines which have filled both attribute values.Do you have any idea, how to figure out this issue, please?Thank You so much!Lubo

Is it possible to use a negative list index in the AttributeCreator? If not possible, why not? Any technical reason or just not implemented? Should I create an Idea for it?Workaround is to use the ListIndexer, and AttributeRenamer but this is not really intuitive nor quick. Unlike most things in FME.

Hi,I'm trying to export my data to excel. My workbench was working fine and suddenly I can't even run it.I'm having the following error and I don't know what could be the issue.I restart my computer and I close all the excel files on my computer but the issue persists.XLSX Writer: Saving changes to dataset 'folder_name'XLSX Writer: Failed to save changes to the spreadsheet 'folder_name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Note that folder_name is the localisation path where I want to export the data.Thanks

Hi guys,I have data which look like this:|ID|Number||1|1||1|3||2|1||3|1||3|2||3|3|I need to group them by ID and pick up only rows with highest Number value. To get such data:|ID|Number||1|3||2|1||3|3|Any idea how to accomplish this?Thanks

I've added 7 individual Feature Types to my Workspace and want to expose fme_basename and mapinfo_type for each of them. Is there a quick way of doing this that will save me from having to edit the properties of each Feature Type one by one?

I am trying to make a spatial query with SQLExecutor and having some issues. My filter is some point buffer features in a ESRI geodatabase and the feature points I want to filter are in an Oracle database. I am extracting the geometry and using SDO_RELATE as shown bellow. Using FME 2016.My SQL query:select * from gds.emb a  where a.DATAHORA >=to_date('01/01/2017 00:00:00', 'DD/MM/YYYY HH24:MI:SS') and a.DATAHORA <to_date('01/02/2017 00:00:00', 'DD/MM/YYYY HH24:MI:SS') and sdo_RELATE(a.GEOM,@Value(_geometry),'mask=anyinteract')='TRUE'

When setting up FME Server and configuring for Fault Tolerance, it's recommended that a fault tolerant file system is set up for storing the FME Server system share folders. For anyone who has set this up before, do you have any recommendations for how to create/set up the fault tolerant file system?

I want to snip the first and the last meter of a line (which is 10 meters). I therefore take a Snipper, set at "Distance (Value)" with Starting Location = 1 and Ending Location = -1. The Snipper only cuts off the first meter as a remnant, but leaves the last meter untouched. Am I doing something wrong here, or is the Snipper not working as it should?PS: FME 2016.1

Hi all,I seem not able to rotate text objects written to a png file.They are rotated, rotationfield has correct value when arriving at the writer.Even using gif_text_rotation or fme_rotation...nothing seems to make the png have the text rotated .Anyone know this issue and maybe what I'm missing here? (please answer in relation to png writer if possible...;))

Hello,In the Text_File writer I cannot select an attribute I've just created How can I solve that?Best,Harmen

I have a known structure of an XML file/feed and am using an xfmap file to map attributes. The XML feed doesn't always have all of the fields in their feed. Is there a way to populate a reader attributes from an xfmap file?

I am using an AutoDesk Revit Reader to transfer an RVZ file to a Feature Class in an ESRI GEoDatabase (ArcObjects). When using the 2DForcer to transform the 3D RVZ data to 2D data the translation fails and there error I get is 'Cannot write a non-area feature to an area feature class.' I am using a Geometry Filter which has the solid and area options checked, followed by a GeometryValidator with all options checked. and the output feature class type is set to polygon.

Hi,I'm doing a transformation from a gdb to a CAD that was already setup (with block name, color ect, for each layers). I'm working with the DWGStyler and its working fine. The only problem that I find is that I'm not able to put each color "By Layer". It's possible in the Linetype checkbox to select ByLayer, ByBlock or others lines types but not in Blocks... It is possible to set up the color ByLayer in that type of transformation? Or I have to specific the color for each layers?Thanks!

Hi, I have dataflow where I filter my data by an attribute. This results in 100+ output ports. After that I will perform the exact same transformation for every output port and write the data in a separate file. (Yes, I do need to filter first.) Of course, I can create a custom transformer for my transformation that follows (see screenshot) but I'm wondering if there's a way so I don't need to add the transformer and a writer to my workspace 100 times?Any suggestions?I'm using fme desktop 2016

Hi,In my FME Server, I published a "master" workspace with an admin user called psl. This master process basically invokes another FME workspaces through a FMEJobsubmitter.When I run this process on the FME Server, the username is logged correctly only for the master process, but for the child process the username that is logged is psl.How can I do that it logs the correct user for the child processes too?

Hi,In FME Desktop I can add a Header to know the time spent on each transformers.FME_PROFILE_RESULT_CSV "filepath".How can I do this on a FME Server?

To get an xml file automatically we are currently storing all attribute table of sql server DB into a enterprise GDB in sql server, which is creating a trouble that everytime it is taking the primary key field as OBJECTID and changing the name of the field. So we want now to have the attribute table as it is in a non-spatial database, and want to read it's table name, field names and datatype into an xml file. But I cannot read the field names and data type as a list thus I can use it inside our own schema. Can anyone please guide me.?

I have a Geotiff file where the colour (a real number) represents the elevation. I wish to generate contours form this data and can not see how to get the data into the contour generator in an appropriate way. What other transformers do I need and how do i use them?

I am using TweetSearcher on FME Desktop 2016 to find tweets with a keyword and within a bounding box. I used my Twitter login details and it was working absolutely fine earlier.However, since a few days, I am not able to use the same workbench and it returns an errorReceived HTTP response header: 'HTTP/1.1 403 Forbidden' from 'https://api.twitter.com/oauth/access_token'Could you suggest how can this issue be resolved. I can not find parameters in TweetSearcher to provide any access token. Thanks in advance!