Authoring

Hi,I have a set of workspaces that must write either in a production database or in a development database.So, I use a published parameter for the "connection" parameter which seems to work well.  But despite that it works properly, when I edit the connection parameters, the dialog box shows a database connection from the dropdown list instead of my published parameter.It's very disturbing because there is always a doubt that I haven't well configured the writer with my published parameter.And I can't afford to send data to the wrong connection...Is this a bug of FME or did I miss something ?I use the same setting for my SQLExecutor and SQLCreator transformers and I have not this problem with these transformers.The problem occurs only with writers and readers. I tried with FME 2018.1.2.0 and FME 2018.1.1.2

I have a few workbenches that are executed from a batch file nightly that are being used with a "SYSTEM" login (instead of a user like me) and I was seeing if there is a way to have a script or tool that once those workbenches are done that it returns the floating license for us users during the day. We only have 2 floating licenses.

Hi All,I have just started working on FME Server.Is there any way to execute workspaces in series i.e. executing workbench-2.fmw after completion of workbench-1.fmwPratap

Hello,As a hobby i'm a cyclist and i was wondering how to set up a workspace which can calculate how much percent of the time the wind is in favor of the cyclist.If the wind is blowing from the north west (arrow) i would like to know how much percent of the time i have the wind in my back en i have the wind against me. What would be the transformer to get the wind direction into my route data?

I have a Python Script Tool already created that creates a custom staged Project Folder containing all of the AutoCAD Drawings (.dwg) and a File Geodatabase (.gdb) with the correct naming conventions based on our submittal requirements. I also have a FME Workspace created that can read a specified .dwg and then create/write features to a .gdb.I would like to maybe execute the Python Script Tool as a Startup Python Script to build the Project Folder and then pass the .dwg and .gdb stored in the created folder as the src/dst or read/write in the FME Workspace. I am sure this or something that will accomplish the same end goal is possible. I have found similar questions in reverse (passing parameters from FME to a Python Script). I just have not found the correct documentation for it in my searches thus far.Thanks for any help in advance.

Hi, i have a list and i want to access this with python using FME 2013. It seems to be that i made a stubid mistake.  List: my{0}.A = 1 my{0}.B = 0 my{1}.A = 7 my{1}.B = 2 my{2}.A = 9 my{2}.B = 5  Python Code: self.my_list = feature.getAttribute('my') dummy = len(self.my_list) print dummy  The code crashes by reading the "len" with: Python Exception <TypeError>: object of type 'NoneType' has no len() Traceback (most recent call last): File "<string>", line 9, in input TypeError: object of type 'NoneType' has no len() Error encountered while calling method `input'  I think there is something wrong with getAttribute or i can't read lists this way? I hope you can help me.  Hendrik

Hi!I'm sorry if the question seems trivial, but I didn't found a turnkey solutionI have two grids and a condition that subsequents flow of an algorithm depends on minimum value of mathematical difference between them. If it is larger than a certain value I must wright both of initial grids to defined place, if it's smaller - than do nothing.Of course, there is no problem to use tester to RasterBandMinMaxExtractor. But on the output port I will get a raster with calculated difference but not the initial rasters. I can use result as a clipper for required rasters, but maybe there is more right and elegant way to branch an algorithm?Thank you!

I am building a custom transformer that returns to the user one to many road characteristics. I have a Choice with Alias (Multiple) User Parameter that allows the user to choose 1 to Many road characteristics. My issue is that attributes from characteristics that they did not choose are showing up in the Output.I’ve tried BulkAttributeRemover with Regex. NullAttributeMapper after the custom transformer to remove the ‘missing’ attributes, but it requires the user to select each attribute to remove. I generated a List in the FeatureMerger that I am using to merge the records back together. When the data comes thru the Output the List looks correct, but when I explode the list, the extra attributes show up.I’m sure there is a more elegant way to remove these extra attributes.Thanks.

Hi everyone,I have created a custom transformer to generate points using lat/lng using the following simple script. It works totally fine. However, it loses all of the attributes coming from my input file. Is there a way to retain it dynamically?   

Hi,I am reading SHP files and writing them out into a file geodatabase, using Dynamic Schema Definition.All the features are being dropped. It seems that one SHP attribute "FAST_TRACK" (Small Integer - 0 for all features) is being read by FME as Boolean value (string: false): WARN |FileGDB Writer: The `Fast_Track' attribute could not be written. The containing feature has been dropped2019-03-19 09:58:31| 1.3| 0.0|WARN |Attribute(string) : `Fast_Track' has value `false' Can you please advise how to force FME not to read the zero value as false? Thanks, Monika

We have been using FME server 2017.1 for about one year now. Yesterday I upgraded it to 2018.1. Everything seems to work fine - workspace runs fine, scheduled jobs work fine, Active Directory users login fine et al. However, I can not publish new workspaces from desktop for both 2017.1 and 2018.1 desktop. The message is "Connecting to 'http://phoupgisapw108' (web connection, user 'admin')... Login failed (Connection Error) - Unable to connect to FME Server." I tried with using the previous connection from 2017.1 and also creating new connection in 2018.1, the same error message. I did the upgrade twice last year from 2016 to 2017.0 and from 2017.0 to 2017.1, never got this issue before. Anything about 2018.1 upgrade that is different?

In a development environment I am both using FME Desktop 2015 and 2018 in the same environment. We have several shared folders with custom transformers. We also have 2015 and 2018 versions of these custom transfoerms In order to avoid changing all the Shared Resource Directory settings every time I start a different version of Workbench I made a bat-file to start 2015 and one to start 2018:cd /d "D:\\Program files (x86)\\FME2018\\" && "D:\\Program Files (x86)\\FME2018\\fme.exe" APPLY_SETTINGS SYSTEM "Shared Resource Directory" "D:\\USER_Folders\\Bart\\FME2018\\sharedfolder" && start fmeworkbench.exeThis works for 1 folder, as per this example, but I can't find the syntax to set multiple folders. Any suggestions?

Dear FMe community.I'm trying to build a list with a SpatialFilter transformer but it doesn't works.I need to build an exhaustive transcription between lines whose intersects polygons like that :For the moment with SpatialFilter I don't find...Thanks for your help.

I am trying to leverage a Choice with Alias (multiple) User Parameter in a custom transformer. When I add the custom transformer to a new/blank workbench and connect it to an data input (CSV), all the attributes also show up for the user to choose from. Am I missing a setting/toggle somewhere? Parameter Setup: What's showing up when custom transformer is added to an empty/new workbench and connected to a CSV input: Why are these attributes from the input showing up in Choice parameter? If I select Choice with Alias without multiple choice, it works properly.FME 2018.1.1.2 (Build 18586) Thanks.

Hi all,I have a shapefile with roads and another shapefile with points that contain a field with the mileage of that roads, and I use the latter to calibrate the routes I create with the former in ArcMap.Both shapefiles are related with IDs, so there is no risk of asigning a mileage point to the wrong road if it's not snapped to it.My problem is that the mileage data of some points is out of place, for example you can find:...42 - 43 - 44 - 0 - 45 - 46 - 47...And that zero causes the calibrating tool to fail. I've tried to spot it so I can generate a new shapefile without the incorrect mileage points but it always returns me another points and I can't find a way to get it right.Here is an example: Gaps in the enumeration are not a problem, but some times there are not only one but a group of points out of place. For example :...42 - 43 - 44 - 178 - 177 - 176 - 175 - 51 - 52 - 53...In this case there would be no problem with the gap between 44 and 51. The numbers in between

I have an older script that will no longer execute importing pyfme. Any suggestions as to why? Log translation details below:FME_END_PYTHON: evaluating python script from string...Python Exception <ModuleNotFoundError>: No module named 'pyfme'Error executing string `import pyfme Shutdown Python Script details:

Hello again.I was planning on setting up a sequence of translations to run where each successive translation is run by a WorkspaceRunner transformer in the previous.The problem with this is that placing a WorkspaceRunner at the end of a translation makes it dependent on the translation succeeding, and my chain of many translations could be jeopardized by something out of my control, such as a "403 Forbidden" error in an HTTPCaller.My questions are:A) Can I run a .bat file as a Shutdown Python Script without the translation where that script resides remaining running? In other words, is there a Python version of "Wait for Job to Complete: No" ?B) If not, is there a way to place the WorkspaceRunner so that it bothDoesn't start the next translation in the sequence until most or all of the operations are complete, andIsn't dependent on any other transformers succeedingThe reason these requirements are in place is so that more than one translation isn't runni

Hello All,  We have built a new server on a Windows 2008 R2 (64bit) system and and I have: 1. FME 32bit installed 2. Oracle Client 32 bit installed 3. Oracle client BIN folder in PATH 4. TNS_ADMIN environmental variable set to point to folder containing tnsnames.ora  5. ORACLE_HOME environment variable set    The issue is very similar to this    I can connect to our DB via third party and SQL*Plus. I've modified security setting to give required access. I'm running out of ideas. Any input please?    2013-11-18 11:23:15|   0.6|  0.0|INFORM|ORACLE Reader: Using Oracle 8 SC Reader Version 1.2 (Jul. 04, 2000) to read tables from database `', server type `ORACLE8i', server name `pri1', user name `fme_ro', password `***'  2013-11-18 11:23:15|   0.6|  0.0|INFORM|ORACLE Reader: Using Classic geometry.  2013-11-18 11:23:15|   0.6|  0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'  2013-11-18 11:23:15|   0.6|  0.0|ERROR |Unable to connect to Or

Hi, is it possible to change the filename in a dynamic writer? I'm trying to add a suffix to the original file name but as soon as I do any changes to the value stored in fme_feature_type the workbench fails. Is it even possible to change the filename in a schema?  

My batch print is not working properly. The workspace runs, but when I try to run batch manually it fails. Saying error determining writer (Translore). Again regular workspace runs properly. Help?

I use a SQL creator on a Oracle Spatial database extracting around 40 columns.I would want to score the fid of this extraction in order to use it in the where clause of a post-gis reader. This to avoid the post-gis reader to read all 1 000 000 records when I only need 300 of those.How can I do this ? I did some research but seems I am using the wrong key words as I can't find it.Thank you  

I have a nine element, pipe-delimited attribute. These elements can be a text string or a blank space. I want to replace duplicate text elements with a blank space and leave blank elements alone. I.e. have it come out with eight delimiters and nine elements when I put it back together.ListDuplicateRemover gets rid of the unwanted text elements, but also the blank ones.  Example: |||Carnegie Drive|Carnegie Drive||Dunfermline||Ky12 7bd when run through AttributeSplitter and ListDuplicateRemover becomes: |Carnegie Drive|Dunfermline|Ky12 7bdBut I want it to be ' ||||Carnegie Drive||Dunfermline||Ky12 7bd' (with a leading space)I.e., just remove the duplicate instance of 'Carnegie Drive' and replace it with a blank space. Thoughts? Thanks

Hi everyone,I have a workflow in which I have to change the schema dynamically. I was able to write the result I want into a CSV file by using a FeatureWriter (or a CSV writer) and setting Dynamic Schema Definition with Schema sources as "Schema From Schema Feature". The features passed in have list attributes name and fme_data_type.The table in the output CSV file is correctly formatted into the new schema. However, the data from the output port of FeatureWriter is in the same schema format as the input to it, (not in schema format written in CSV). I want to change schema in FME so that I can process it further. Is there some setting in FeatureWriter that Im missing? or any Alternative workflow to change the schema ? Thanks in advance,Ashish

Hi there,I've been trying to find answers all over the internet, but no results.In short, I'm generating a CSV output where my input is an unknown amount of entries (workbench will be run several times and input varies each time), but I want to generate a separate CSV for a maximum of 500 entries found.So as some examples, based on hypothetical inputs, this is the output I want:350 entries - 1 output sheet1700 entries - 4 sheets (3 with 500 each and one with 200)502 entries - 2 sheets (one with 500, another with 2)I'm not particularly concerned about the order of these features. I tried the ModuloCounter, but instead of splitting up my input per 500, it splits up my input into 500 equally sized groups, which won't do.Thanks in advance,

After doing a lot of search I still can't find a way of exposing attributes whose names are stored in another attribute. _count attribute values are the names of the attributes I want to expose. They exist and have values.I find the AttributeExposer transformer too simple. It won't let me set an attribute value as an attribute name to expose. So, what should I do? What's the way to go?