Authoring

Since I am at a customer, not being able to connect the our license server via vpn, I installed a temporary fixed license. This is installed without issues using the license manager, however, my FME slows down terribly! And with that I mean everything: opening FME Desktop, opening FME Inspector, loading data, running a model, ... I am really not able to work like this. Anyone an idea what is going on here?

Problem Summary: Fme engine installed on another server can't read from the FME_SHAREDRESOURCE_DATA location since it is the local path of the fme server and not the UNC path. Problem long description: I have an FME Server automation that gets triggered by an email, and has a workbench that reads the contents of the email and writes it to a csv which is stored in a sub-folder in the $FME_SHAREDRESOURCE_DATA directory of the fme server. This then passes the full local path location of the csv in $FME_SHAREDRESOURCE_DATA to another workbench. The problem is this workbench is run on an engine this installed on another server which then attempts to find this file locally but it doesn't exist since the $FME_SHAREDRESOURCE_DATA full path location is only on the fme server and not the UNC path.Question: Is it possible to get the UNC path of the $FME_SHAREDRESOURCE_DATA so a an fme engine installed another machine can access this location when trying t

I can see another question about this. However if my understanding is correct. The where clause is not working for me at any level.I am using the blm national dataset which has a large number of records for all states. I only need to utilize 1-3 states at this time in my workbench. I have attempted a where clause on the reader , an SQL before read (which seems like the most efficient) and a where clause on the table. However the sql before will not run at all.When running the where clause SECDIVID LIKE 'MN% it runs but in the test filter directly after the reader i begin getting unfiltered records. This should

I am trying to pass a string as parameter the string has "\\n" as new line character. When I use fmeobjects.workspaceRunner.runWithParameters to pass the string the string is cutoff at the first line. I tried to escape the backslash but I got mixed results. The entire string was passed but the string contained the actual "\\n" in it. I need the new line character like this

This is the final step to some complicated data sorting - so as an example lets say I have the following data: indexequipmentNamesequenceequipCount1a102b103c204b215c316d307d418b429b5310e5011b6412e6113b7514f70 The goal is to get data ordered like this: abbccdd... etc. This works by sorting the sequence column ascending and the equipCount column (unique counter of equipment name) descending. The problem is that if there is a sequence pair that does not contain a zero (both pieces of equipment have appeared before) then its no longer beneficial to sort equipCount descending, instead it needs to be sorted ascending(see index 7 and 8 sequence pair 4, they should not reverse order 2 to 1; and index 11 and 12 sequence pair 6, they should reverse order to be 1 to 4). Again this is all to get the final order to be abbccddbbeebbf. My solution to this was to check if each equipCount value in a sequence pair was not zero, and then to make even numbers = 0, bec

I installed FME 2020.0.2 (build 20232 -win64) on a Windows Server 2012 R2 Standard 64-bit (6.3, Build 9600) machine.It works fine but throws an error message on exit and I'm concerned it may hide some important unwanted functioning I haven't found out so far. Before installing FME Desktop on our production server we want to make sure everything works as expected, so I can't overlook this apparently minor thing. Any idea of what is it about?A repair install did not solve the problem. See error details below: Application Name: fmeworkbench.exe Application Version: 2020.7.39.20232 Application Timestamp: 5eab95e4 Fault Module Name: Qt5Core_fme.dll Fault Module Version: 5.12.3.0 Fault Module Timestamp: 5cffcf60 Exception Offset: 0000000000028658

I have a dataset where want to write separate files based on multiple attributes. From the example below I would like to write a file with all the Jones, another with all the Smith, a third with all the Farmer and a fourth with any Kim. Fanout does not handle multiple attributes and in this case the StringConcatenator trick wont help, since most of the rows would be contributing to separate files. Any ideas on how I can achieve this? A B C D Jones  Farmer Kim Jones Smith   Jones Smith Farmer  

i would like to create the readers in workspace and output of the first workspace as input for the second workspace . i tried workspace runner but i did not get it to work and i am not sure where can i find some articles about transponder sender and reciver if that what should i useFme 2018 any help plz and thanks  

Hi,I've been looking for some documentation on FME Data Express with no luck. Specifically I'm looking for what published parameters are supported by Data Express.Some of my published parameters in a workspace has the label [unsupported] added to them when I open the workspace in Data Express.It would be great help to know which types of published parameters are supported.

Hello,I want to create a unique numeric ID in a new attribute field from a two-letters string attribute, this way:feature - IDAA - 1AB - 2AC - 3BA - 1BB - 2CA - 1CB - 2 CC - 3 CD - 4etc... I guess I need to count how many times a letter is listed and then create IDS for every count and repeat but I don't know how to do this. Many thanks, Max

I want to set the value of an attribute, depending on the environment, where my workbench is running (desktop, server dev, server prd),. I could do this with an parameterFetcher and get e.g. FME_SERVER_HOST. But I don't want to do this for each feature, but just once at the beginning.What's the best way to do this?I tried it with a scripted parameter, but I get an error, for FME_SERVER_HOST is not know when I run the workbench on desktop.Then I tried it with a startup-script. Here I don't get an error, but how can I set a parameter here, that I can use in the workbench?Thanks, Vera  

Hello,FME 2020.0The screenshots below describe the question.

Hello,I just started learning FME. I have a data set with different surfaces (roof surfaces), which differ in one attribute, among other things. Two of the areas (left and right roof area) always belong together. Based on the size of the difference, I want to classify the roof accordingly into a roof shape. The areas that belong together always have a common ID (roof ID) and the number of areas (=roof areas) that belong to this ID (=roof). The partially differing attribute is the pitch of the roof.In my opinion, one possibility would be to round the values to full 5° and then compare them. Since the value for each roof can still be different, I would have to iteratively query each degree number afterwards, which would not really be efficient. Is there another more efficient way to do this comparison and perform a roof classification?For example, I could imagine that I subtract the one roof pitch on the left from the one on the right. If the value is in the range

Is there an easy way to extract a subset of values from a list attribute. For example if the list attribute contains: 1,3,5,6,8,10,5 etc up to hundreds of values, how can I extract the first 10 values as a list also?

Hi, I have a lot of datasets (gpkg) that I want to transform to gdb, in batch. But first I need to check data integrity of the date-fields. I have a schema of all the datasets. So my idea is to select all the date-fields (1), put them in a list (2) and feed the list to a Tester (3) to check the data and a StringReplacer (3) to repair some flaws in the data. But… I can’t seem to use the selected fields (the list (2)) in either the tester or the StringReplacer.  Does anybody have a solution? 

I need to export the database connections from an FME Server instance or somehow get them to be available to a single FME Desktop instance without making them available to the entire organization through sharing. How do i do this?

I have a dataset containing 100000 points, for these points I've calulated 700 neighborhood. Now I want to calculate the z score for every point in each individual neighborhood.  My question is: is there an easier way to do it, than 700 conditional values ? I've tried with a custom transformer in which I can loop, but I cannot get my head around how to do it.   Please help :) Thanks in advance.

I have an OracleDB table with the following varchar type column.This looks like json but is recognized by fme as string type by default.  I want to enter this column in mongodb in nested json format.I want it to be entered in the format below.Can the fme workbench do this?

I would like to search a string for the text (example HIGHWAY1 & HIGHWAY6 or HIGHWAY11 and replace it with 1 HWY & 6 HWY or 11 HWY)

So in the hopes of better managing the scheduling of FME jobs and while dreaming of creating a dataflow diagram for all my FME pipes, I've started mapping out all data sources and data targets across all my workspaces. I had high hopes for the Workspace Reader because it offers a ton of meta data. But even after trimming down and flattening some of the data to get only Source, Target, Workbench Name, Dataset etc., I realize this only documents proper readers and writers and NOT any SQL Creators/Executors... or am I missing something?On another note, has anyone, has Safe, built something usable that does this? A workbench I can point at a collection of workbenches to parse out ALL source/target databases ? Any suggestions or redirects appreciated.

I'm running into issues with ageing workbenches that are running as workspaces on FME Server. Most of these I did not build, many I've never published, some I've had to republish to make minor configuration changes. But I've not made any effort of somehow bringing them all up to the same "standard". Currently, I'm also still on server/Desktop 2018.I'm familiar with the ability to upgrade readers/writers in place when upgrades are available. But is there any guidance for keeping a clean house with regard to your portfolio of workspaces? I'd like to avoid having various workspaces of different vintage, i.e. created in different versions of FME. But I'm reluctant to just update every reader/writer and republish out of fear I will break too many things.Any guidance, or list of caveats for said approach would be helpful. - THANKS.

Hi Guys,any easy one for you i thinkI have an ACAD template dwg file, but i don't Need Always all layers in the Output (only those which come from the Reader)is there a possibility to handle that ?this template file has also Layouts included….can i also decide if the Output should Keep them or not? Thank you and greetz and stay safe!! (isnt that a cool statement anyway)Franco 

I have added a user parameter type "Choice with Alias (Multiple)" to my workspace that I ultimately want to be used for exporting selected GIS layer within an area, out to a CAD file. I was able to create the parameter and when I trigger the workspace, it asks me what layers I want to export, which is all great; however, any time I select more than one layer, and try to run the workspace, I get an error as follows:An error occurred while attempting to open the table, feature class or relationship class 'GIS_SDE.RoadArt GIS_SDE.RoadCol GIS_SDE.RoadHwy GIS_SDE.RoadOthr'. The error number from ArcObjects is: '-2147216057'. The error message from ArcObjects is: {Invalid parameter value passed to function}It appears that it'

I think we're pretty much 97% through an installation of FME Server in production, but we can't seem to login. When we checked the log files, it seemed to point to the Job Queue not starting up properly. There's also a redis process that seems to be running that shouldn't be? Any help on this would be greatly appreciated, Thanks,Van

Hi there! I have an FME Workspace with two dynamic readers for two data sources with different schema names (or no schema name at all). As the content of both data sources use a very similar data model, with only the schema name different, it would be user friendly to select the feature types only once using one Published Parameter called "FEATURE_TYPES" and not to have (as I have now) two Published Parameters called "FEATURE_TYPES_1" and "FEATURE_TYPES_2" For example: in the File Geodatabase the fme_feature_type has the value "pGreen". In PostGIS the fme_feature_type has the value "Name_schema"."pGreen". Now I select twice the same objects using two separate Published Parameters . Is it somehow possible, within one FME Workspace, to use a single Published Parameter "FEATURE_TYPES" to read both "pGreen" and "Name_sch