Authoring

Since the upgrade to FME 2019.0 we're unable to run any workbench. All our workbenches make use of connections saved in a public or private key store file. But FME can't seem to find these files anymore. I checked the location of the files and they are still present. Also the rights on these folders seem to be ok.  

Hi All,I have a Feature Reader, using an excel file, it work perfect, but when i enable feature caching it fails on the feature readeri don't know if this is a bug?

Hi guys,I have created an FME workbench that runs an output. This I have then automated by adding it into a batch file and run via a scheduler. I have an issue where a certain attribute I have to manually change in the attribute manager due to its revision.I was thinking of using the counter and also read this article https://knowledge.safe.com/articles/33899/change-detection-2.html but not sure how exactly the workbench wil detect the change of the new revision. The other option maybe having a popup box similar to counter that suggests you need to add the revision but unsure if this can be picked up in the .bat or via another method.Example - Currently it is, for example, it is: DG01 and then next weeks run it will be DG02 but that will have to be manually changed.    

I am wanting to publish around 60 workbenches to FME Server 2019 to run sequentially as a single scheduled task, however cannot find any configuration in the interface which would allow me to do this.Ideally, I would want to be able to select the repository I publish the workbenches to and configure to run on one of our two engines of FME Server. This would save a lot of configuration time instead of having to create a unique schedule for every workbench.Can anyone suggest a solution or advise if this is possible? (Maybe an idea for a future release of server?)Thanks

I have line like Road and points are like housesi have fields like side and ID_T in picture highlighted blue apts having same ID_T because hooking same named edgeside field , if it hook right get R or else get L In above wrong is only single edge that highlighted red circle aptsI need to select which apts are hooking only one side

Hi, FME noob here (worked with FME 10yrs ago). I've noted before that I've inherited the project that includes administration of aroun 30 FME workbenches, that are scheduled to run using the Jenkins tasking server.  I understand the reasoning to create a workbench for each feature class (esri) to be synced to AGOL, but I'm thinking of combining into one or few workbenches. The issue is, once one transformer fails, the rest is not executed. So I'm thinking if there is any 'transformer', or perhaps a wrapper that would allow me to catch the errors but still continue the workbench execution?  Thank you

Hi there.The Geometry Replacer transformer in this workspace have the correct attributes (end_GRID_ID and start_GRID_ID), but FME is not transferring these over to the writer! Any tips? 

I'm building a workflow that has error handling system in it. The idea is to send a message to the client about some specific error. To do that I've created a Custom Transformer that sends message. It would be very handy to extract the Transformer Name and send it as a Error Code. In that way I can avoid typing an Error Code as a parameter value.  On the attached image you can see an example where ER000n are instances of the same Custom Transformer. I wonder is it possible to extract whatever was used as a Name of the transformer (ERR0006, ERR0007, etc.) form inside transformer? Extracted name will be a part of the Error Message that I'm sending to user.  Thanks  

Hi, we are seeing some odd behaviour in our FME Server 2015.1 instanceWe are running a 'runner' workbench, that uses 3 chained fmeserverjobsubmitter transfomers to call 3 'workers' and all are configured in 'sync' mode (i.e. wait for the job to finish)Occasionally the first worker (which can take just over an hour to run) is submitted twice. The timing of the second submission appears to be random and between 10-50 minutes.the driver workbench log shows no record of triggering this second job and appears to fail with the error(ServerJobSubmissionFactory): A connection error occurred with server "http://fme-server.prod/fmeserver"both the workers appear to complete successfully sometime after the runner has failed.Does anyone know what conditions might be causing this automatic resubmission of a job and, ideally, how to prevent it?I suspect that some component of FME Server is losing connectivity with the initial job, assuming failure, trying again and losing connectivity with the second

I have several custom transformers which perform different QA checks. They are designed to read in any data set with any number of tables and columns per table and perform checks for each table.  Within this custom transformer, I run the data through an AttributeExploder and have the following: attr_name | attr_value.  I do a few tricks to attach fme format attributes to each value | name pair to get the following:  DatasetName | DatasetType | TableName | RecordName | RecordValue Below is a screenshot of an example of some data for just two tables: So what I want to do is split out the data into their original tables, pivot, and perform analysis on each one - simply find any rows with repeating data - ALL WITHIN THE CURRENT CUSTOM TRANSFORMER - without having to write to file and read in again etc.. For Example:  TableNameMATRIX_IDMATRIX_DESCRIPTIONdbo.MATRIX6SPMDdbo.MATRIX4UNKNOWNdbo.MATRIX3BIOLOGICALdbo.MATRIX2SEDIMENTdbo.MATRIX1WATER Using a couple of Aggregators, I was able to get

I have a chain of WorkspaceRunners that I need to bring to FMEServer, but it should still be possible to run them in Workbench as well. So, I created a TestFilter where '$FME_JOB_ID' NOT has a value. If it does not have a value, a WorkspaceRunner is triggered. It fails with the message:Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'An error occurred during the batch file execution, 1 translation failed. The following error message was raised: #2 : Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'The parameterFetcher in the 'ReferencedWorkspace.fmw' causes this error.  The Workaround I made was to put a value 'N/A' in the 'FME_JOB_ID' of the ReferencedWorkspace (which also contains a TestFilter but with '$FME_JOB_ID'  NOT has a value or = 'N/A'). So two questions:why do I get the Error message in the first place? The Main procedure does not require the 'N/A' value for the FME_JOB_ID. It seems that the WorkspaceRunner does not resolve

I have a workspace that runs using FME Desktop and the windows task scheduler. I would like it to send out an email notification upon successful completion that includes a total record count, a list of ID of all the records, and a timestamp.In my specific instances, I'm using a FeatureWriter to write lines of text to a number of text files that are named using fanout and a unique ID field. What I've come up with works but it feels clumsy. The screenshot below leaves out the actual FMW processing and starts with the Writer (bottom left) and another branch feeding in records.Maybe you agree - there has got to be a better (more out of the box) way to do this, right? If so, I'm all ears.Footnote: Most of my stuff runs in FME Server which utilizes notifications there (although not with the above type of summary), so I have never had to dig into bolting on things after your writer finishes up, 

I have created an attribute from a database table for planning applications and this ultimately will populate an excel spreadsheet.My question is in the excel spreadsheet it is coming though with the code of the different application types and for the audience that the spreadsheet is intended for it would make more sense to have the description pulled through.i.e in the spreadsheet it is showing as ADV and i would like to convert this to advertisement consent

I am working in FME2017. I have a parent workspace that calls on a child workspace via the WorkspaceRunner. Initially, both workspaces are stored in the same directory. If I move the parent workspace to a different location, the directory specified in the WorkspaceRunner automatically updates to the location I move the parent into. Since the WorkspaceRunner can no longer find the child workspace in the location being called, all the parameters are now cleared, and the WorkspaceRunner is flagged as an incomplete transformer.I can work around this....But, is this expected, or is this a bug?

I've uploaded a workspace to FME server which runs on Desktop but errors out there:All the parameters are completed, but when I try to run the workspace FME Server returns this error: When I click on the View Details button I get this:  Does anyone have an idea what I am doing wrong? I've attached the workspace.ThanksNeil

I'm trying to understand Fanout better. I ran a test with a planning appeals points dataset where I set the output to split the source data into subset .tab files based on a the 'decision' field. This worked and created 19 tab files as there are 19 possible decision values in the source data. However there are two issues:  1 The process places the outputs into their own folders (e.g.: the process creates a folder called Split decision which then contains the tab file showing just the split decision valued records. (It’s doing this because of the issue raised in point two below)  Is it possible to places all 19 output .tabs into the same directory folder?  2 The output tab files are all called the same name as the source file. The source file is called ‘LBS Planning - Decided appeals’ and all 19 output files are also called ‘LBS Planning - Decided appeals’. Can FME rename the output files along the lines of the value it is sub-setting? So, for example, I’d want one of the 19

I have to write multiple consecutive datasets (adjacent tiles) to Aircom Enterprise files.Is there any possibility to merge new data of adjacent tiles to the existing clutter file in the folder instead of overwriting it?

Hello FME Support, I am running FME Desktop Version 2019.1 and have found that the user attribute settings are not holding after being changed in the FeatureWriter.I have an attribute called "category" which was using the conditional option to set one of two options.  I wanted to add another option that had multiple parts First thing was that I had to type the 'AND' as it wouldn't select from the list and secondly it did not save once I pressed OK.

Hi all, I'm FME newbie, though I kind of know what this thing does. I've inherited around 30 fme workbenches I need to update, as a developer I'd like to get things in the config files for different environments so I'm externalizing the props (parameters) via the Private Parameters (scripted). As I have to do this for all 30 workbenches, is there a way I can add my own custom params directly into FME that would become available as FME Parameters? Thank you

Hello everybody, I hope somebody can help me with the following challenge:I have 2 datasets/dataflows in a workbench:-1. MeldingData: One set contains registered data like roadnumber, type of animal, status, etc-2. FormData: The other set contains the pulldown menu options from the iASSET application database where the value is shown in the first dataset. The set MeldingData has colomn names like data.100003, data.100004, data.100024, etc. The number of the colomn from MeldingData matches the colomn id from FormData. I want to replace the code in MeldingData with the matching value/label from FormData, so it makes the dataset more readable.An example: the first row of MeldingData has value 05 in colomn data.100004. This means that this notification/call is made on roadnumber N373. Al the other colomns need to be processed simmilar. I attatched the workbench and an excelfile with the MeldingData and FormData. I hope you understand my explanation. If you need more information, please let

I want to modify the attribute in the second position of an excel. I can get the schema of it and the attribute{1}.name is the actual name of the attribute. But now how do I put in a new value because attributeManager, or tester expects you to know the attribute name and I wont have that.

Hello there Is there a way we could apply the change detection but reading dynamically each orgine and revised input , because we have a large number of table to check  Thanks

Hi,I need to merge data from two tables and create third table that groups features by year (see picture below). Is there any easy way to do the task? I am stuck with this and tried FeatureMerger but no luck so far...

I'm reading in a single Access database with multiple tables that contain a common attribute, then outputting multiple Access databases via a fanout on that common attribute. It's quite a simple translation. However, I have an isolated, unrelated table that does not have this common attribute field, but I would like this table to be written (in its entirety) to each fanned out Access database. To illustrate this I'll provide an example:Input DBtable name: StateStateAreaPopulationAZ14AK25CA36 table name: RoadsStateRoad_nameLengthAZa7AKb8CAc9 table name: ContractsContract_nameDescriptionthisetcthatetc Output DBs - Fanned out by "State", but I want the Contracts table to be written in it's entirety to each.AZ.mdb - contains the "State" & "Roads" tables (with just "AZ" records), and the "Contracts" table in it's entirety.AK.mdb - contains the "State" & "Roads" tables (with just "AK"

I am trying to configure a Hadoop data connection in FME Desktop 2018.1. I have installed the JDBC driver supplied by iut IT team so I no longer get a driver error bit I now get the error below. We use Kerberos security but it's not clear to me if this is supported in FME Desktop for this connection type. Is it? I use the same connection parameters as used in Oracle SQLDeveloper, which works there.The error seems very generic but any help is appreciated.Error Log:java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://ourServer.com:10000: Peer indicated failure: Unsupported mechanism type PLAINat org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:222)at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:467)at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:187)at COM.safe.fme.jdbc.JdbcReader.open(JdbcReader.java:157)Caused by: org.apache.hive.org.apache.thri