Authoring

I have a Shutdown Python Script published with a Workspace that when ran successfully renames the Feature Classes in the SourceDataset after the Workspace is complete. This executes successfully in Workbench. However, when I published the same Workspace to FME Server and run it, it just loops the Workspace and never executes the Shutdown Python Script.The only parameter passed is the 'SourceDataset_FILEGDB' and a single value chosen at the start of executing the Workspace.Any thoughts or suggestions would be greatly appreciated. Thank you in advance.

Hi all,I'm using the WMS Reader and I'd like to use an extra parameter in my query. As far as I can see, only the ones in the `map options` can be set (widht, height, format, srs, time, elevation).Is there a way to add an extra parameter, like concatening my KVP to the query?Thank you in advance.Rémi

I'm having a recurring issue where FME Workbench 2018 crashes after 2nd or 3rd attempt to publish to FME Server. I have a whole bunch of workspaces that needed mods and subsequently uploaded to FME Server, but workbench crashes after 2nd or 3rd upload consistently. I also observed that it doesn't matter if it's a new publish or a re-publish, it still causes workbench to crash.If you look at the log in the screenshot it reports that it published successfully, but generally I don't trust it so will re-upload the crashed one just in case the workspace on the server got corrupted.Normally this is not a biggie if doing solitary workspaces, but when you have to upload a couple dozen then it becomes a bit of a pain. I'ts been happening for us on various PCs and as far back as FME 2015 (from memory).Would love to know if others are getting this and a possible solution?Thanks!

I am using FME Desktop & server (2018 ) then I published a tool that will be consumed by a site, but the tool end up with (timeout exceeded) error Any help is appreciated Best Abdullah

Hi, I'm trying to export a tin terrain model to a fmear file. I can't find much information on how to do that and which transformers that I need to use. I have tried different input formats and the only thing that worked was a simple sylinder. That was exported from a vrml file and I could display it the apple fmear app. Is there any information on how to do it? Regards Johan

Hello,I have as an input parameter a list of ids separated by "|".For example: 1|2|4Next I have a directory with some zip files:1.zip, 2.zip, 3,zip., 4,zip, 5,zipAs a result I would like to get only files which have names that are in the input list and have it all zipped to the result.zip file:result.zip ---  |  |_1.zip |_2.zip |_4.zipI came to the point where I used attribute splitter and I have a list of those Ids but I have no idea what to do next. Can you please help me with that? Thanks!

I need to search a webpage with several links, however I need all the links that have a certain word, how can I do that?

what i'm trying to do is take an array of strings from a python startup script and access it from the rest of the workbench (specifically an sql executor and emailer). what i have so far is made a global variable like so:global users_to_fixusers_to_fix = []then i append strings into that array.and here are my tranformers:here is the PythonCaller:i have gotten this solution from https://knowledge.safe.com/questions/58082/passing-parameters-from-a-python-script-tool-to-a.htmli am getting the following error:Python Exception <TypeError>: Failure to convert list unicode values to native UTF-8 values.Error encountered while calling function `getUsersToFix'f_8(PythonFactory): PythonFactory failed to process featurei'm thinking there must be a better way to do this. because i'm not actually dealing with features, i'm dealing with a list of usernames of our AGOL database.

Hello,I need to set specific order for writers to write because tables are connected with constraints , when one finishes second one starts and after second third starts. How can I do that? And second question, how can I commit changes to Oracle DB or FME does that after writing to DB? I am using Oracle non-spatial writer.

I want to implement an iterative loop in my workbench. For this I have created a simple "While Loop" construct. The pseudo code is as below var i, maxval; i = 1; maxval = 10 while (i < maxval) {  i = i + 1;  print i; }I created a workbenchTo implement the looping, the red line should be working but FME doesn't take it.Please advise for any workarounds or what I may be missing?

I am taking data from a shapefile and mashing it with a CSV, and the attribute I am having issue with has null, numbers and non-numeric characters/alphabetic values (from the input).The target field in my output is an integer type (uint). I would like to make Null all attributes of that field that are non-numeric (some are purely alphabetic; others have characters like in a date format).I was hoping to use an AttributeManager that I was already utilizing to perform this operation, but I don't know how (or what other transformer would be best).

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?