Authoring

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

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

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 ?

Quick Translator to Workbench File

I have flow data series in excel for every 10 secs for 5 years data, and i wish to convert that data into 1 hour data . can any one suggest what is best way to do in FME or any excel - without skewing my original data and output should make sense

Hi,I need to convert multiple numeric codes in multiple tables into meaningful texts via a suitable "lookup table" (actually a view on SQL Server, but that's not important). Since I need to do this multiple (10+) times, I want to create a custom transformer with published parameters for input and output variables.How do I do this ?My attempts sofar has only resulted in an error: Undefined macro 'VAR_NAME' dereferenced in file ...CheersLars I

Hi,I've made an embedded transformer to reproject an alphanumeric coordinate set, controlled by a published parameter set. It reads the "old" coordinates from two given attributes, and returns the reprojected coordinates values into the same attributes.This works well enough, except when I have a dataset with two pairs of coordinates. It reprojects the first set fine, but completely ignores the latter, leaving them only partially processed.I've tried to insert a FeatureHolder between them, but it looks like the two transformers in the same workflow interferes with each other ?I've swapped the two transformers, and right enough, now the other set gets reprojected, while the former doesn't. So it's at least consistent.Has anyone encountered something similar before ?Cheers

I am trying to bring a workbench to FME Server that has been used on FME Desktop until now. This workbench uses a shutdown python script. The special thing about it is that this workbench uses a custom python interpreter and not FME's Python.The FME server has been installed on a completely other computer than FME Desktop. So first Python and a few packages had to be installed on this computer. Also I edited the FME server settings in the cmd as it is written in the following article unter "Using a Custom Python Interpreter" in "Windows": https://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/Using-Python-with-FME_Server.htm In cmd Python and the import of the new packages work fine but when I run the workbench on FME Server the translation fails. It says not more than "FME_END_PYTHON fai

Anyone know of a good way to analyze attribute values, and determine if a given value is a word in English?Or maybe even check it against a custom dictionary of names? I'm trying to clean up a bunch of values that have spaces from when the PDFs were output to data via OCR, so it looks like this: Attribute ValueWhat I want attribute to be corrected toThi s is a sent e nc e.This is a sentence.

I noticed that the FMEServerJobSubmitter transformer dialog is missing a button on it, the Refresh Parameters button, which used to be directly under the parameters list in 2017 version (if my memory serves me correctly).The documentation even refers to it:As a workspace evolves over time, parameters are added/removed/renamed, therefor this is crucial functionality that needs to come back. My current workaround is to delete the FMEServerJobSubmitter transformer and add it in again (with the added hassle of re-specifying all the settings).If there's a different way of refreshing the parameters, I would love to know how.

Hi guys,can someone please confirm if there is a character limit to the FME_SERVER_REQUEST_URI in FME Server 2017.1? It seems to be 195 characters.  For example, I have a schedule that is calling a workspace :  https://myservername.com/fmejobsubmitter/a_long_repository_name/and_a_really_long_workspace_name.fmw   If that string is over 195 characters then the scheduler reports that the workspace cannot be found. It works fine if I reduce the length of the repository name or the workspace filename.CheersBatesy

In a workbench I write some Swiss-Interlis-files which have to be uploaded to an FTP-server afterwards. I'm not sure whether I can use the new FTPCaller for that...? How would I do that? Here my questions: - in the FTPCaller I fill in the         - URL         - "Upload from a File"         - File to upload: Path to my files         - connection parameters >> so the FTPCaller doesn't have to be connected neither to a reader nor to a writer at all? - Thus I cannot use it in the workbench, where I write the files but in a seperate one? - If so, I guess it would make more sense to run my workbench and afterwards an FTP-job from a batchfile...?  Thanks in advance Vera 

Hi, I have a following table and I want read rows between start and stop. Is there anyway I achieve this in FME? any help will be highly appreciated.Thanks you IDDESC1 rest2start3run4rest5aaa6 stop7rest8run9start10bbb11run12stop13aaa

When trying to add an RData reader (.RData or .Rda), FME is unable to open the file and gives the error below: Workspace generation failed.

HiI am writing attributes to a shapefile, but the attribute names are being shortened to 10 Characters. Is there a way to stop this?Thanks in advanceMartin

I seem to recall that I was able to sort my display lists for Schedules, jobs, etc in the previous version of FME Server. I see a "sort" order button on schedules, but I cannot apply it to any other columns. Am I missing something?