Authoring

I have a workbench that has an non-spatial oracle connection. It runs fine on my laptop A. But it does not run on another machine B (a server) as it complains about the TNS connection. So on machine B, I deleted the database connection (FMEOption -> Database Connection) , and tried to recreate it. But the connection test gave me this error: Error: COM.safe.fmeserver.api.FMEServerException: User encryption is specified but can't find key to decrypt.In fact, I can't open any of the other existing connections on Machine B in the FMEOption -> Database Connections. It gives me this error:Unable to retrieve connection "xxx", please check the log file for more detail.We had a similar issue with this Machine B a few months ago, which we fixed by reinstalling FME. But this time, reinstalling FME does not fix the issue. We are at FME Desktop 2017.1.0.Allen

Hi I have a grid index, I want to use the attribution from the index to pull various raster tiles. Currently, I have clipped the index to my area of interest. These are then feeding into my FeatureReader. I have setup the FeatureReader as seen below. Here is where I have the problem, the FeatureReader is writing out the original index and not the rasters I wanted to select (Using the SHEET_NAME from the index). What am I doing wrong? Thanks for the help. B

I have attribute zip code, where all values looks in this form 12345 how can I transform them into this form 123 45?My idea was to split it using StringReplacer where I would replace \\d{5} by \\d{3} \\s \\d{2}, however I don't know how can I create new attribute which base on the old zip code attribute (12345).Are there any other ways to do it?

I wonder what would be the best way to come up with a string of lat/long concatenated from features with a single character value. I'm not sure I described it very well but the pictures should help.The source is a PDF document.My workspacethat ended with this. I tried aggregating on Y but it did not work. I was thinking maybe an Advanced attribute Handling but I don't have a good solution yet.

I am trying to populate a new field with a value from another field. It is not a simple attribute copy. Each record is getting the value from a different field that is specified in another field.For example: I have the table below and I want to populate NEW_FIELD with one of the values of fields FIELD1 through FIELD4 based on what is provided in FIELD_TO_USE. This has to be dynamic (no hard coded TestFilter as I am doing that now).FIELD1FIELD2FIELD3FIELD4FIELD_TO_USENEW_FIELD1234FIELD115678FIELD26ABCDFIELD3CEFGHFIELD4H

How to set preference in FME workbench where one can set precedence: Step 1: (Run first) Data is downloaded successfully using HTTPFetcher, until it is complete the step 2 should not start. Step 2: (Run second) then a reader is used to read the above downloaded data. Currently having issue of step 2 start before step 1 is finished.

Hello,please, I try to find way how to add a new line to Job result data page - e.g. URL link to data download of job result - check below. Is there any possibility please?Thank You so much!Lubo

I have a number of feature classes read from a geodatabase, each FC written as a sheet in an excel spreadsheet. Using a dynamic reader/writer to do this, dynamic schema from the src geodatabase.I'd like to add long/lat fields to all of the point features and have that in the output excel. The source data schema of course doesn't have this. I've tried adding a long and lat field to the excel file sheets that are relevant, and then using the schema reader to create a schema feature to pull the orig schema + lat/long fields to pass to the dynamic writer. FME doesn't complain but I am not getting long/lot values written out in the final data.I feel like I'm missing something simple if anyone can imagine what that might be!

Hi, I'm using an Excel template file to chart some data that I write to Excel - I've attached some example data and workspace. When I populate the 'data' sheet, I want the chart to update with the latest data. I've tried to achieve this by setting the chart data source to '=data!$A:$D', so it should look at all rows in those columns), but Excel seems to default to =data!$A$1:$D$1. So when I run the workspace the chart is not updated to reflect the data in the 'data' worksheet.Does anyone have any other methods for achieving this? I want the chart data source to use dynamic references rather than fixed, so that whatever amount of data is input to the 'data' worksheet, it is plotted on the chart.Thanks for your hepMary

Hello, We are using HDFS as our file system for some of our files. Can we integrate FME solutions inside HADOOP in the Map-Reduce process? Or there is any other practice to use FME in HADOOP context? Thank you for your time,Kitty

Many of our published workspaces in FME Server share published parameters, like URLs or email addresses. If this information changes with time I have to change the value for this parameters for each and every published workspaces one by one. A way to manage this kind of information is by storing it in a table into a Resources folder and read it from my workspaces using a specific reader. This is ok but I was wondering if there is another option, like defining new FME Server parameters that would be accessed from workspaces and would work like 'global published parameters'.

If I use a BulkAttributeRenamer to remove a prefix on a number of attributes, and the resulting attribute names match some preexisting attributes going through the transformer, which attribute values are kept? Are the preexisting attribute values maintained, or are they overwritten with the values from the renamed attribute?

Is there anything I can do to prevent FME Workbench from consuming CPU when being idle? On my new Core i7 with Windows 7 FME Workbench 2015.1 consumes about 10% CPU after opening an empty workspace and minimizing the application. It's enough to make my laptop fan spin up noticeably and battery drains very quickly. If I run a workspace and FME inspector is left open CPU will go up to 15-20%. After a short while or so the fan speeds up and the sound becomes really annoying. I never experienced this with previous versions of FME.

I have a fairly large workbench that uses quite a bit of processing muscle, so I am limiting which features are processed at one time by using an attribute value (a line reference) exposed as a published parameter i.e each time I run the workspace, I enter a new line reference to be processed. I have about 1500 different line references to process. How can I automate this so that I don't have to manually enter each new line reference?

I seem to have broken the way FileGDB ArcObjects can handle dynamic schemas and I'm not sure what went wrong. If I switch to a FileGDB API, it works.I have the following:PostGIS reader that can pull in more than one feature type at a time. Ex. Powerline, RailwayFileGDB ArcObject writers with a template file that define fields, domain-coded values, subtypes, etc. It also uses fanout to produce the right folder structure. Ex: Transportation/Access.gdb/RailwayUtility Communication/Utility.gdb/PowerlineThe error I'm getting is:ERROR |Unable to find the schema definition 'Railway' for feature with feature type name 'Railway'. Ensure the feature type name is correct and that its schema definition exists in the schema sourceThings I've tried:When I use the FileGDB API writer with as much of the same parameters as the ArcObjects writer, I can get the expected output, but I'll need the coded values, subtypes, etc.Use SchemaMapper to map the feature_type_name from

Hello, I have two set of data (Points and lines).  They have a common attribute X Some of points have a common attribute value (X) with lines How do i can extract those lines ? I tried the feature merger but the translation fails  Thank you.

Hi,I have a polygon layer with x,y,z coordinates.For each polygon, I would like to calculate the mean z-value. For this I use the ListStatisticsCalculator, which works perfectly.The problem is, that some polygons consists of one or more useless z-value (-999, -9999 etc.). I would like to filter out these values (or delete them) before running it through the ListStatisticsCalculator.I have tried the ListElementFilter with Filter Type Numeric Range, but I can't get it to work properly.Any thoughts?Thanks,Stig

Hey,I'm unable to parse a single year value. It says it needs a month and day value. Is there a way to get past this? @TimeZoneSet(@DateTimeParse(@Value(Year),%Y),local)

Hi,Is it possible to sort features by attrbute name? Say I have Excel table with 10 columns, and I need three of them to go to first transformer, and the rest to go to another transformer. Column names are not constant. Or say they named by some order, like Group1tag, Group1kind and so on, how could I filter attributes by a mask 'Group1*'? Thanks,

I have to regularly import a bigger number (200+) of CSV-files into postgis, and obviously dynamic reading of those files is the way to go.Before coming to FME I did this with the help of ogr2ogr Version 2.xx, which honors the presence of a CSVT-File that contains in one line the data types of the CSV-File, separated with commas. (see http://www.gdal.org/drv_csv.html)What I am now trying to do is to dynamically create the table structure with FME means by reading* the first line of the csv-file (), which gives me the column names, and* the one and only line in the csvt-file ( - the suffix is .csvt, but the uploader complained), which gives me the data types in the same sequence as the table names are.My first draft looks like this:I guess that a ListCreator and a SchemaSetter should accomplish this task.Alternatively, I could imagine to write the structure creator in python, but have no idea how the structure data has to be formatted.Goal is to run this workspace in FME-Server and subm

Hello,I am trying for the first time to upload a custom transformer to FME Hub. I have uploaded a test workbench with it, but it produces an error saying:The custom transformer 'Geocoder.Mapbox' referenced by this workspace was found, but could not be loaded.  The custom transformer was created with a newer version of FME WorkbenchIs there anything I can do to resolve this? I couldn't find anybody else on the forum with this problem. Locally, it runs fine. I am using FME 2018.0.Best regards, Pijke

Hello,Any idea why when I am trying to use the search enveloppe option to filter only geometry features within a specified box (see file attached) I always got: Error running translation.  Otherwise without enabling the search envelop option my workflow works fine.Thank you in advance.

Hi,I have a client that uses to work with both Linux and Windows. He asked me if there are efficiency differences between Linux & Windows for FME Server. Have you got experience with this?

I need to concatonate a user Parameter with a value from each feature that passes thru.But it seems with each feature that passes thru, my parameter is starting fresh with original value.I need something like the "counter" transformer which remembers the count for the life of the workspace.Is there a global variable that I can update and append to and change and it is retained for the life of the workspace without delving into python?Perhaps user Parameters is the wrong vehicle?Thank you

how can I add the"Group By "parameter to my custom transformer? where can I set the parameter ?