Transformers

Hello! I am getting errors while trying to delete records from using the Informix ODBC writers. I am putting the columns to match in the delete column row and getting an error that those columns do not exist:IBM Informix Spatial Writer: Error - No column named ltt_id found in table xxxxxA fatal error has occurred. Check the logfile above for detailsOr just that there was error:A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...and the only other thing written is a warning about assuming the geometry is 2D.Has anyone else had any trouble with this?

I've been trying to apply an image as a texture to a vertical wall (from CAD 3D solid to Geodatabase multipatch format). As a brief summary my current workflow is:1. de-aggregate CAD 3D solid and select vertical wall of interest to apply texture to2. swap coordinates Y<>Z so that the vertical wall has a top-down view3. use the AppearanceSetter transformer to apply a GeoTiff using the 'texture coordinate generation parameters' settings: 'Use Existing Texture Coordinates = Yes and 'Texture Mapping Type = Top Down Georeferenced'4. swap coordinates Y<>Z again so that the wall moves back to its vertical position5. write to an ESRI geodatabase as a multipatchThe result is that the geotiff is applied at the correct location as a texture BUT then areas of nothing (ie. area where the background colour can't be modified, but the multipatch is still there) are tiled alternately with the image across the rest of t

Hi everyone,In my organization we have some users of FME desktop and up till now I have done manual installations on every computer. But now I would like our technicians to deploy it automatically. But they are have trouble with the msi-file that can be downloaded on Customer downloads page. Is there an other msi-file that doesn´t hold 3 other msi-files or an exe-file somewhere for download? 2018 and 64-bit version is the one I´m looking for.Thanks in advanceJenny

Hello,I'm using the PointOnPoint Overlayer to find if any points overlap. When I use the transformer and let the workbench run, I get an attribute value of _overlap: 72, for each individual point. None of the points overlap (see attached picture). I thought I would get an overlap value of 1 because the points do not overlap. Is there a reason why each point is getting an overlap of 72?*the total number of points in the file is 72*Thanks! David

Hello allIm trying to Drape 2D FME points, (Which are centre points of trees extracted from LAS data) and trying to drape these points on a Surface model. At the moments all the points are level under by surface. I cant seem to be able to drapeI have tried using the SurfaceDrapper but my points stay the same level. Any ideasThanks in advance

Hello AllIm hoping someone can help me with a particular problem i am having trying to edit a Tin Suface.I have created some FBX files of ground surfaces using point cloud data. Easy However i now want to feed FME a DGN or DWG that contains outlines shapes, that i can use to cut holes in my FBX TinSurface. I feel i have tried everything :( I have tried also to remove the points from the point cloud and remake the mesh, with added holes, but the surface modeller joins the holes back up. eeerrrr!Any help would be much appricated

Can fme creat a hemisphere like this below? Thanks a lot.

Does FME support reading/writing Navigation Data Standard?

Hi guysI need to detect two parallel line within certain distance (15m) in a road network

I have 4 workspaces that follow the same process (they each just calculate different fields on different feature classes). Within these workspaces, I use a VariableSetter and a Variable Retriever. In order to get the Setter to run before the Retriever, I have Set the Connection Runtime Order (as recommended in this post), as well as adding a Sorter in front of the VariableRetriever. This has worked in 3 out of the 4 workspaces, but for some reason, is not working in the 4th. Again, these workflows have an identical setup, they each just manage different attributes in an AttributeManager (that runs after the Variable Retriever). Has anyone had experience with additional methods of getting the Retriever to run AFTER the Setter (other than Set Connection Runtime Order and adding a Sorter)? Thanks.

How can we use AttributeCreator which receives an array of data to only pull the last index of that array?

Is there any way I can pass a non numeric attribute to the RasterExpressionEvaluator?  Specifically I want to pass a conditional statement.  ex. If(A[0]==somevalue || A[0]==someothervalue,0,255)  I can't really build the statement in the expression evaluator directly because I don't know in advance how many parts the conditional will have.  I keep getting the error Expression Evaluator: Attribute '_Recode' has non-numeric value, but if I hardcode the resolved expression directly in the RasterExpressionEvaluator it works exactly as expected. 

Hi, I am carrying out data quality tests and I would like the results of failed tests in an excel doc. I would normally use the AttributeValidator and the _fme_validation_message but I need to use testers. An example of one test: if the 'type' = individual then the 'industry sector' should be null. So in the table below, I would want to see the last line in an error reportTypeIndustry sectorindividualcompanyagriculturecompanyconstructionindividualretailAny suggestions welcome.

Hello, there I am looking to extract data from a public web site, I used the HTML Table reader, but I am not getting the expected value in the table website: https://www.stats.gov.sa/en/160 

Hi Guys,I have a text file that contains both header information with necessary attribute fields and a fixed width set of sequential coordinates with bearing and distances that create the polygons of a cadastre. I need to create the polygons with the attributes attached. If I read in the file as a CAT, I can't find a way to retrieve the attribute information at the topIf I read it as a text file, then split on the ----, I can sort of retrieve the header information as attributes, but then can't figure out how to extract the fixed width stuff into lists. Also, all the the blank spaces are causing me issues in creating a set of headings, especially as the first line of the definition is blanks until you get to the radial, OR the E/N.I was going to try to read these in as a sequential list - ie, each feature is also referencing the o

Hi I have a point and polygon layer. I need to populate different counts of points in each polygon satisfying different attribute queries on the point layer.e.g count of supermarkets, sports centre in each polygons. I have 8 such queries, so would populate 8 fields in the polygon layer.I tried using TestFilter on point fc then PointOnAreaOverlay, but this doesn't work as I cannot get multiple If and If statements from TestFilter. Instead It gives me If Else If.I would like to avoid having 8 different TestFilters and PointOnAreaOverlay transformers if possible.Any ideas?

I'm using the AreaOnAreaOverlayer to intersect two large sets of polygons (Polygon 1 & Polygon 2 for clarity), one of which (Polygon 1) contains overlapping polygons which are sometimes coincident with each other, but with different attributes. The transformer is only overlaying one of several polygons from Polygon 1 with Polygon 2 and dropping the others from the output, but I need all of them to be intersected and output.What other transformers can I use to prepare the data so that all polygons are intersected?I'm using FME Workbench 2016.1, and can't currently upgrade.Thanks,Matt

Currently I use python to launch FME workspaces and return error with subprocess (below). Is it possible to also return count of the features written?CommandLine = 'FME ' +ScriptName +' -LOG_FILENAME ' +FME_LOG try:  retcode = subprocess.call(CommandLine)  if retcode == 0:  logger.info(' Complete on SABOGISP01 @@@ ')

Hi FME'ers,I am trying to update values in an XML documents but these values are conditional. For example: IF <MethodCode> like 'FF%' THEN <MethodCode> = 'PM' andIF <MethodCode> = 'FF12' AND '<ItemDesc> = 'Basket' THEN <ItemDesc> = 'Wicker Basket'. ELSEIF <MethodCode> = 'FF10' AND '<ItemDesc> = 'Basket' THEN <ItemDesc> = 'Laundry Basket'I think XQUERY will solve my issue but I don't have time to learn a new query language. Many thanks,David

I have a set of contourcurves that I want to use in order to create a printed model. In the printed model each curve should be represented by a plate, see example below. I have the contour curves as lines (with z-value) and some of them are connected at the ends with which I can create areas/polygons with the AreaBuilder transformer. Some lines however have loose ends, but I would still like to create the plate discs here. So I created a bounding box with the BoundingBoxAccumulator over the entire input dataset. My idea was then to use this box and the seperate lines (height curves) to create new areas that I then can extrude. Here is an image of my idea (orange area should also include red, blue include both orange and red):

HelloI seem to be locked with a seemingly simple problem with reading ESRI FileGDB (Geodatabase)If I specify a Search Envelope the reader refuses to read non-spatial data.Non-spatial data are only read if no Search Envelope is defined.So how do I read spatial data with search envelope and all non-spatial data ?Do I need two readers ? If yes: How do I say read only non-spatial data ?There is an option: "Spatial data only", I don't see a "non-spatial data only" option ?!Thanks for any hintsMichael

Hi Fme team,After completion of fme script, i need to run sql query for the resultant destination table. So I am running sql thru end python script. And for this sql query I need one variable(fme published parameter or fme attribute)from jest ran fme script. is there any way i can get value from fme published parameter into end python. pls help.

Hi!I am kind of new to FME so this must be a simple issue to solve for anyone in here.I have a xls-file with zip codes, 5 characters together. I want to add a blank space between the third and the fourth character. I just can´t find a simple way to do it with my limited knowledge...Thanks, Tobias

Hi there,I need to generate some raster images based on shape file data, but I'm having issues with creating a bounding box for my edges that is always square.Here's an example of some of my data:When I use the BoundingBoxAccumulator, it gives me a rectangular polygon, which is entirely expected as the above geometry frame is much higher than it is wide.Ideally, I'd like my bounding box to use the biggest one of the two for both the height and width, so that the polygon is still based on the size of the Geometry, but always perfectly square.Any suggestions on how I might achieve that?Thanks,

I have a series of polygon feature classes all in the same geodatabase. I want each feature class to do a 'area on area overlay' with land parcel polygons and create a file for each overlay. I have tried creating a custom transformer with a loop but I couldnt get it to work. Really not sure how to go about doing this.I dont want to have to pass each feature class to its own 'area on area overlay' transformer. Any help to find a better way of doing this would be appreciated.