Best Answers

Hi everyone, I am relatively new to FME and am seeking assistance for a minor issue I am having. As part of a project I need to create an excel table that contains 9999 from various attributes and from multiple SDE feature classes. My excel table works but I want to include an attribute that indicates which feature class the record is from. I exposed the fme_feature_type attribute but am not table to get it to export out into the Excel table. What might I be missing? Please see the below screenshot. Thanks in advance for your advice and suggestions!

I'm attempting to use the following email template with FME Server 2015.1.3.2 :<fmeblock>This notification e-mail was generated automatically from FME Server (PROD). Please contact your system administrator or submit a service ticket for support. Do not reply to this e-mail. FME transformation job {id} has FAILED. Workspace: {workspace} Repository: {repository} Status: {StatusMessage} Submitted: {timeRequested} Job Start: {timeStarted} Job End: {timeFinished} Logfile: {logFullPath} </fmeblock>{workspace} & {repository} are both returning "_undefined_". All the other macros seem to work fine. Any suggestions?

Hello, my input csv is as follows (it was output from a 3 point shapefile using CoordinateExtractor):A,1,2B,3,4C,5,6I would like to output csv as follows (which will ultimately be used to generate a 3 line shapefile from LineBuilder):A_B,1,2A_B,3,4A_C,1,2A_C,5,6B_C,3,4B_C,5,6I'm trying to use various list transformers but I can't get there. Any ideas would be much appreciated!

I am moving data from MySQL to Oracle 12c. There is a datatype called bit on MySQL side that is not recognized by MariaDB connection. The values used in the column active are true and false.  The reader completes successfully but results show <missing>.

Hello,  I have i Workspace where i want to output some basic DGN surfaces. When the i look at the data that goes in to DGN writer they are of the type "fme_surface". But when i open the new its the same shape but build of a lot of fme_lines.  Before Writer: After writer: Is there some setting in the writer that i might have missed that can cause this problem?

So I'm trying to get the max and min of a row of data across all attributes (all number attributes).I used the list builder and got all the attributes into a list, except it is like this _list{}.col1, _list{}.col2, etcThere are 54 attributes so I'm not sure how to combine all the parts together to get the min and max. I can't use listSorter as it is asking me to pick _list{}.col1..._list{}.col55 when I want to sort _list{}. Is this a nested list? is there to flatten it it maybe?Maybe there's a better way to go? Would appreciate some help. Thanks

I have run into the strangest problem using the Intersector. Source A is a dataset of overlaying polylines containing attributes I want transferred to the polylines in source C. B is a polygon I use to reduce the amount of data whilst building the workspace, B is to be deleted in the final version. As long as the data passes the clipper the output is as expected, ie features are cut and attributes are merged. But when I bypass the clipper (and turn it off) the data gets cut but attributes are not merged.What on earth is going on here? I can't make sense of this.

Hello,Is there a way to create sampling hexagon using fme (and python caller) that would cover a study area?Basically, the idea is to create a mesh of sample hexagons and ensure that that all regions within the study area are represented by the sampling results as you can see in this post?Thanks

Hello,I am new to JSON formatted strings and have spent a few hours trying to split out some content with JSON Extractors and Fragmenters with no luck. I have an array of 10 "items" which I need splitting into separate features. What I need to pull from each item is the publishedParameters list (as a split list) and WorkspacePath. So they resulting objects should be formatted as such:Item# ¦ WorkspacePath ¦ publishedParameters0 ¦ "APIrepository_prod....." ¦ "name": "user_email", raw: "Glenn.sayers@halliburton.com"0 ¦ "APIrepository_prod....." ¦ "name": "cell_size", raw: ""0 etc.1 ¦ "APIrepository_prod....." ¦ "name": "_layers_other", raw: ""1 ¦ "APIrepository_prod....." ¦ "name": "_layers_gde", raw: "present_nonclipp

The USGS have deprecated their earthquake feed in GeoRSS and replaced it with a GeoJSON. No problem I thought, in fact better - but wait.  The timestamp of the earthquake is now provided as a long integer in milliseconds from the Epoch. Milliseconds? I can see the intent, but the usual standard is whole seconds, and only whole seconds are  supported in the DateFormatter.  The trouble is that I cannot divide the time by 1000 for the DateFormatter because it is a 64 bit long and it seems that 32bit FME cannot handle it.  I have tried to treat it as a string, but that does not work either. Maybe a PythonCaller, but can I pass it across?  Here is the feed URI http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_month.geojson

Hi everyone,I have a very basic (I guess) issue that I can't deal with nor find an appropriate tutorial or answer on the web... I have a 1 band Geotiff that comes from a substraction between two Digital Elevation Models (bathymetric survey). I manage to give a value to nodata (RasterBandNodataSetter) and remove the nodata identifier (RasterBandNodataRemover). So the Geotiff I'm working with as no nodata.I want to associate color (chosen or by default) to different ranges of value, just for visualization of the result. I can do it with any GIS software (like ArcGIS) but couldn't manage to do it with FME. I tried to connect a RasterPaletteGenerator to the Geotiff Reader but I get a translation terminated with the rejection code 'INVALID_RASTER_BAND'. As I have no idea of the problem and where to start to manipulate palette and raster band, any help or links to tutorial or web pages would be greatly appreciated.Please find attached the Geotiff I'm talking about.Tha

I have a set of polygons with OwnerID and a set of polygons without OwnerID. On another layer, I have connection lines. I am trying to give OwnerID attribute to linked polygons using the endpoint of lines to link them together.LineOnAreaOverlayer is good for 90% of the cases but some polygons are traversed by the lines and sould not be considered.here is sample, green polygons has an OwnerID, white polygons don'tUsually, I have only two (2) polygons to link together, but sometimes there is multiple polygons to chain link together. Any Idea ?Thank you

Hi!I have some 3D faces that have been saved out to a FFS. Now I'm trying to use a Search envelope on a FFS reader to load the model above, I want to clip the model according to the bound. It works but many(all) of the clipped faces have faulty values at Z=0. I would expect to get a nice clean cut on the 3D-faces, with correct z-height at all their indices. See this image:  I have attached the soure files for debugging. Is this a known bug? Any workaround available?

I am using AttributeExposer (AE) and need to import the values from a table. I do not know how many values there are before I run the workspace, so I need to be able to import the values from a table created by the workspace.I thought I had it all worked out and then realized that the "Import..." option might not be "live." i.e., it worked the one time and has been holding onto the values I entered, rather than repopulating with a newly created table each time.Is this true? Is this "one and done" and you need to manually reload these values if the table you loaded them from changes?I need to do this after I use AttributeCreator, because the attributes that are created are invisible. If there was way to create attributes and have them be visible, that would be wonderful.Thank you,Randy McGregor

When I'm using the Adobe Geospatial PDF reader it seems to me that the Raster Size parameters are always greyed out and can't be altered. Am I maybe overlooking something, or is this a bug?The following screenshots illustrate the issue. When the parameter 'Read Rasterized Pages' is set to 'No', the Raster Size parameters are greyed out (and also the 'Raster Size' 'group name' is greyed out.)However, when the parameter 'Read Rasterized Pages' is set to 'Yes', the Raster Size parameters are still greyed out (wheras only the 'Raster Size' 'group name' changes to an 'exposed state'.).I'm using FME Desktop Oracle Edition, FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN32).  

Hi all,  I'm facing a problem while adding an Excel Reader to my workspace: Adding Excel Reader - I'm selecting only one attribute to be exposed: When the Reader is brought into the workspace all attributes are exposed: Is this a bug or am I doing something wrong?I'm using FME(R) 2019.1.2.0 (20190829 - Build 19630 - WIN64) but I've noticed this on older versions as well. Cheers,Eduard   

Hello,what am I doing wrong? Let's say that I have some attributes whose values I want to compare with tester. Each attribute value comes into tester separately. No matter what I do, I always get "failed" result from tester (even when the values are the same). I used 3 Inspectors and I see that both values which are coming into tester are number (number 5 in this examle) but I can't figure out what's going on inside tester.I'm attaching small example file.Please help.Mario

Hi all,So, I've got this small data set of 12 locations in the Netherlands.  I would like to create a distance matrix that tells me what the distance (as the crow flies) is between each point. I figured that I could use FME for this. I think I managed to get quite far, but now I'm stuck and in need of some assistance :-(.So what did I do so far?  I first created a workspace that reads the data set and then uses the FromToBuilder transformer in combination with an AttributeManager transformer to determine distance from one manually selected point to all other points. A csv-writer writes the resulting table to a csv-file.  Secondly, I added a new published parameter in combination with the Workspace Runner transformer to run through the 12 points. So that I don't have to run the workspace 12 times and manually assign a point to the to-port of the from-to transformer.  This generates a csv-file of 12x12=144 features.   I'm no stuck figuring out how to convert the 1x144 tab

 Hi allI have a simple IFC file which has just 8 IFCWalls and 2 IFCSpaces. When I run a simple query for retrieving all records for IFCSpace elements ( select * from "public"."IfcSpace"; ) , SQLExecutor duplicates all records. For instance, I have 2 records for IFCSpace but after running the query, I'll get 4 records. How can I avoid duplication? (I use PostGIS)

I am trying to merge two lot of attributes but when using FeatureMerger, it is only picking up the requestor attributes and the Supplier attribute of 'issue' keeps repeating '36'.ThanksBill

Hello everybody,please, I met one issue with running the job on FME Server - is there any way, how to submit a job to run without authorization? How could I configure call to run like that?Now I use this API call to submit a job to run - fmerest/v3/transformations/transact/. Thank You so much!Lubo

Hello everyone,Im thinking about the best way how to check encoding of ASCII (.txt) file in FME Desktop.But, is is possible, at all?Now, I have TXT reader in my workspace nd then I use stringsearcher transformer to check unsupported letters. Im not sure if it is the best way...Thank You so much!Lubo

Hi all,  I'm using a feature reader to query a feature class stored in portal using a where clause, however i want to capture and handle the event if no records are returned. Currently fme will just stop and no longer progress if nothing is returned. Any ideas on how to resolve this?  Cheers

As shown in the figure, the arrow (the start point of the line segment points to the end point), how to calculate the coordinates at the red point?

Relatively new FME 2018 user and just trying to see if there some improvements to my use of Tester in the workspace. Now, I've been using Tester a lot to do simple things like using it like a WHERE condition, but in 2018 at least it seems to do a naive, feature-by-feature test of the Tester conditions. For example if I use Tester on a 2M feature input with a condition AttributeValue = 'A', then this takes around 2 minutes to complete.However, I've later discovered FeatureJoiner as a go-to transformer for significantly better performance as this seems to first index the Attribute(s) in question first before testing them, as well as passing out the Unjoined features without any post-processing overhead as essentially "untouched" features.If I instead use an alternative of Creator(1 feature)->AttributeCreator(Set AttributeValue='A') to make a single Test Feature, and then pass this into the RHS of a FeatureJoiner transformer to test against the 2M feat