Best Answers

I am trying to create a boundary from contour data to define three different areas. I split the areas using test filter and tried AreaBuilder. It created polygons for closed lines. But It doesn't create outline boundary.

Asking on behalf of a client: they're writing to Oracle and getting an error regarding an UTF-8 string that can't be converted to Windows-1252. I can't seem to find a way to set the encoding on the Oracle writer, is this handled in the database definition itself (i.e. outside of FME)?

Picture of my workbench attached. Can someone advise me on how to write out each feature to a separate excel sheet, and include only the attachments for the specific feature? Thank You

I have a Custom Transformer with a loop in it. It contains Blocking Transformers, so it is linked. I would like to pass the number of iterations to the main Workspace, but I do not find how to expose the Attribute that I have set in the Advanced properties of the Custom Transformer:the only reference that I found is: https://knowledge.safe.com/questions/4722/accessing-iteration-coutn-parameter-is-it-possible.html of @gio. Do you remember how you solved it in the end? Thanks in advance.

Hi There, I'm having some trouble of figuring out an approach to detect features that have "regressed".My data looks something like this:<Fruit> <Batch>Orange, 1Apple, 1Pear, 1Orange, 2Apple, 2Pear, 2Orange, 3Pear, 3 So look at this as Batch 1 had all three fruit, batch 2 had all three fruit, but in batch 3, Apple is missing.What I am interested in is knowing when a fruit went missing, specifically in a sequential view. Meaning, I don't really care about the relationship between batch 1 and 3, but I want to know that between batch 2 and 3, Apple went missing. So even if I have 10 batches, I only really care if I have "pineapple" in batch 8, but missing in 9. I hope my obscure example makes sense and please let me know in case any additional information is needed. Thanks a lot! 

I have a csv of locations points tracking a utility vehicle. Each point is denoted by the "POSITION" number, and they are grouped by a "TRIP" attribute. The LineBuilder transformer will either A) Make a single line connected all points or B) if I group by Position it will leave as points.  I've done this in Python by using a combination iteration, to use a for loop to connect each point to the one in front of it, but I am unsure what transformers I would use in FME. Additionally, I have yet to figure out how to access and output my features using the PythonCaller.  How would I go about connecting each point to the next individually?

Hello, I am trying to connect to our Enterprise Geodatabase. This used to work for quite a long time using FME 32 bit (several older FME versions). Using FME 64 bit (on the same machine) produced an error like this:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {Keine No SDEHOME-Umgebungsvariable festgelegt} Please ensure the connection parameters are correct (server=`sde', instance=`....', user=`....', password=`***', database=`', version=`SDE.DEFAULT') Now we have FME 2020.2 64 bit and I don't have the 32 bit version anymore.I created a database connection file (*.sde) using ArcCatalog on my machine. There, I can see the database and connect to it. I can also open the connection in ArcCatalog directly using my sde file. But I can't use the same connection file to connect a reader (Format: Esri Geodatabase (ArcSDE Geodb Raster Dataset)) in FME. Three colleagues

Hi I have a shape file with points and a shape file with polygons.I want per point a csv file with all the polygons containing that point.  It looks like this: 1,photo31,photo41,photo71,photo9.... My workbench works, until a point that lays in 2 polygons. The polygon will only be added in the first csv file and not in both. I tried group by name and group by fotonamen, but that doesn't work.

Hi All, I am trying to merge several raster tiles into a single one using RasterMosaicker. Unfortunately, in the output raster you are able to see horizontal and vertical white lines as well as a horizontal black line at the bottom. Please note these are not present after georeferencing the tiles and is only after the used of the RasterMosaicker transformer that they appears.  Is there a transformer I need to use prior this or are the parameters within the RasterMosaicker the ones need altering?  Any ideas welcome! Thanks,Ana

I am running FME Desktop 2019.1 and am trying to output the results of a Feature Merger to a csv file but I want to add an additional row in the csv file before I have the column headersieI want the output to look like this:but I can only get this:in excel it would look like this: FORMAT ASSET DETAILS , STANDARD 1.0    REGNAMEASSETNBRTMPLASSNBRDESCRLONGDESCRSHORTDESCRASSETTYPEASSETSTATFLEET1000000090000000Sj300 2019 White Ls Colorado 4 X 4 DieseSj300 2019 White Ls Colorado 4 X 4 Diesel (Ranger 4) SJ300Sj300 2019 White Ls SN Is there a way to do this?Preferred output is csv but if i its do-able to excel that will suffice.Thanks in advance

In FME, I have a File Geodatabase Reader (merged feature type). I would like FME to group features by fme_feature_type and output each feature type to a port.   I have gotten close with the attribute pivoter, but haven't had any luck writing counts.    Does anyone have any suggestions? What I'd Like to accomplish: Almost got it with attribute pivoter:My settings for attribute pivoter:  Thank You

I have an xml with the following structure: <?xml version="1.0" encoding="UTF-16"?><Report> <Category> <Category Empty="10" Name="T" Type="Filter"></Category> <Category Empty="30" Name="S" Type="Filter"></Category> </Category> <Fase> <Fase Empty="1" Name="AO" Type="Filter"></Fase> <Fase Empty="2" Name="VO" Type="Filter"></Fase> <Fase Empty="3" Name="DO" Type="Filter"></Fase> <Fase Empty="4" Name="UO" Type="Filter"></Fase> </Fase> <Imago> <Imago Empty="1" Effect="Low risk" Score="1" Type="Quantifier"></Imago> <Imago Empty="2" Effect="Moderate risk" Score="2" Type="Quantifier"></Imago> <Imago Empty="3" Effect="High risk" Score="3" Type="Quantifier"></Imago> <Imago Empty="4" Effect="Extreme risk" Score="4" Type="Quantifier"></Imago> <Imago Empty="5" Effect="None" Score="0" Type="Quantifier"></Imago> <Im

I try to read an IFC with IfcReinforcingBars. All attributes etc gets read in FME correctly, however there is no visible geometry. I can not share the data, but wonder if there are certain elements/geometrire FME does not read from IFC? I tried the 3 different IFC-readers, and also different settings on the reader with no luck. Examining the features in FME Data inspector shows no geometry. But it seems to be aggregates and Geometry Instances. I also tried the GeometryInstantiator to see if I could get the geometry. https://www.safe.com/transformers/geometry-instantiator/ An image of IfcReinforcingBars can be found on this page for instance: https://github.com/xBimTeam/XbimGeometry/issues/74  

I am new to this and learning but...I have a JSON object and am trying to extract the attributes to load to PostGreSQL and I am hitting my head against a wall. The format of the JSON is generally as so: {    model: 1,    version: 2,    content: [        {            x=1,            y=2        },{            x=3,            y=4        }    ]} I want to output something along the lines of:model, version,   x,    y1,            2,                1,   21,            2,                3,   4 For the life of ne I cannot work it out, to me the documentation and step by steps are not clear. I am using a standard JSON reader. Whatever I try, flattener, fragmentation, I cannot opreate on the content.I had an instance where I managed to get all extracted using an extractor but this would populate the attributes for each item in the content array and concat together to look like this:model, version,   x,    y11,            22,          13,  24 The real JSON is a lot more complicated but at this ve

I have CSVs with over 2 million rows. For some reasons, Reader appears to be dropping some columns , and yet I know Reader recognised they existed because they are missing in the column name order. For example, when columns col3 and col6 are dropped the auto-generated attribute names are col0, col0,col1,col2,col4,col5,col7,col8,col9. I have tried various options in reader but clearly not the right one . There is plenty of RAM and disk space. In some files, the missing columns are blank but I have also seen this happen in files that do not have blanks in missing columns. Some columns have strings enclosed in double-quotes. Any pointers please

I have a NetCDF with below values in each band. How do I go about extracting these values to an attribute using a set of points? They don't seem to come up in attribute list only when I click on a pixel in inspector.  

I've just been thinking about required permissions for a project I've been working on.  The initial workspace is triggered via REST call (jobSubmitter). Depending on success or failure a topic gets triggered which may fire a subsequent workspace. In one of these workspaces it needs to access the FME job history data via a rest call. I've set up a web connection.  My question is, does the initial token I use for the JobSubmitter need to have access to the job table (and web connection)? or are permissions used based on the owner of the subscription workspace or the subscription itself?  Any best practices here? 

I have a SystemCaller transformer that runs a script external to FME, and this script writes out a 2gb csv file.  My aim is to use a CSV Reader and an SQL Writer together to get this in to a database.  The issue I'm facing is that the CSV Reader seems to be a starting point, and I cannot connect the output side of the SystemCaller to the input side of the CSV Reader to indicate that it should run once SystemCaller is complete. Is there a strategy that can be used to overcome this? I'd prefer to keep things in the one workflow if I can.

I have a newbie question.  Can I instruct FME that I wish it to finish all previous steps (transformers), before proceeding with the next step? By way of example I have a workbench that gets a list of files from FTP, downloads those that match a regex pattern (might be a few hundred mb), unzips them, and then needs to call a SystemCaller for some custom code to run. I need all the FTP files to be downloaded, and all the files to be unzipped before I run the next bit of code. FME wants to slide each file right the way through the workflow individual of each other. So, I might wind up collecting 10 files before I can run the SystemCaller, but I do need the 10 files present.  Something along the lines of "If there's 10 things on the input side, you need 10 things on the output side before proceeding".

We have a shared web and database connections directory, into which public FME connections go. Our service account that runs overnight tasks (via Windows Server 2016 task scheduler) has explicit permissions to this directory, but cannot see/use connections unless they are embedded in workspaces. Interactive login is disabled for this account, but I'm wondering if I might need to log in as the account and set default paths for FME so it can see the connections? Alternatively, any other ideas for why this may not be working? In the current case the connection is to ArcGIS Online and there is no apparent option to embed the connection in the workspace. The connection was made public as it was created.

I am having issues connecting to one of our elastic databases. The error I am getting is Failed to obtain any schemas from reader 'ELASTICSEARCH' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. Any ideas what how to fix.

Hello,FME Server 2019.2 build 19801 running with FME CloudI think that these two settings for a Trigger in an Automation configuration should be equivalent, but the left setting - Schedule Type "Basic" didn't trigger any action actually, whereas the right setting - "Repeat On Interval" is working as expected.Am I missing something? Or it was a defect on the "Basic" type and has been fixed already in a newer version?

Inserting a KMl into FME desktop results in a schema-less reader. Which steps do I have to take to convert its attribute (values) to e.g. shapefile or fgdb?

I'm trying to export feature layers from ArcGIS Online to Geodatabase, then upload the Geodatabase to Google Drive. I'm using a 'Choice with Alias (multiple)' user parameter to select and export one or more feature layers. If I select one feature layer my FME script works fine. If I select more than one layer then I get a geodatabase lock error while uploading the Geodatabase to Google Drive. This is the error message: PermissionError: [Errno 13] Permission denied: 'C:\\\\MyDirectory\\\\MyGeodatabase.gdb\\\\_gdb.JD2344.18360.9116.sr.lock'Error encountered while calling method `input'GoogleDrive_Geo_CALLER (PythonFactory): PythonFactory failed to process feature  I'm hoping someone can suggest a solution. My FME script is attached.Regards, Damian

Is it possible to add the coordinates from the coordinate extractor transformer to a writer? Like example from coordinate extractor column _indices{}.x (64 bit real) into a shapefile with column x. I tried changing data type from double, float, char... but the line connecting the transformer to writer simply will not connect to each other.