Authoring

I have written a Python code to retrieve a list of  unique values from several rows with several attributes (in the example below, there are 5 attributes). The problem with this code is that the output field has only the result for the first row. It copies it to the rest of the fields. Here is the code:  import fmeimport fmeobjectsindex =  0list_yes = []# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameterdef compare_attributes(feature):    global list_yes    global index        s1=feature.getAttribute('Att_1')    s2=feature.getAttribute('Att_2')    s3=feature.getAttribute('Att_3')    s4=feature.getAttribute('Att_4')    s5=feature.getAttribute('Att_5')    myList_1 = [s1,s2,s3,s4,s5]    for i in myList_1:        myList_2 = myList_1

Hello, I've studies lookup solutions but Iit still does not work.I have 2 ora-tables. - a lookup table KALENDER with DATE_START and DATE_END and a corresponding number ie  DATE_IN DATE_OUT PERIOD  20181101 20181124 10  20181125 20181212 11  20181213 20181215 12  20181216 20190114 13  20190115 20190125 1  20190126 20190228 2  20190301 20190310 4  20190311 20190322 5 - a table with a dossiernumber and a DATE_INVOICE.  DOSSNR DD_INVOICE  D099 20181120  D099 20190305  D125 20190127  D125 20190315  D127 20190306There are more invoices per DOSSNR / YEAR. The output should be like:DOSSNR YEAR_2017

I am trying to run a workbench from a batch file. The workbench is found in a shared drive (with access permissions), while FME is installed in the C: drive. According to what I've seen in the forums it is a simple command line. However, when running from a batch file, the following error arises: "The specified path is invalid".The batch file is stored in the same shared drive. I have tried the following options, using two path formats "\\\\shareddrive\\maps\\" and "Y:\\":Option one:"C:\\Program Files\\FME\\fme.exe" "\\\\shareddrive\\maps\\FME\\AddressGaz.fmw"Option two:"C:\\Program Files\\FME\\fme.exe" "Y:\\FME\\AddressGaz.fmw" In theory "\\\\shareddrive\\maps\\" and "Y:\\" are equivalent. I don't know what I am doing wrong. Does anybody have a clue?Thanks

Hi,I have a core workbench that is called from a fmeserverjobsubmitter with several parameters from the submitter workbench.Now in the core workbench I added a new parameter. If I don't refresh the fmemserverjobsubmitter in the submitter workbench, the behaviour is what I expected: new runs of the submitter workbench works with the default value set in the new parameter.If I refresh the fmeserverjobsubmitter the new parameter is present in the list of my parameters. Now I'm forced to set a value in the parameter box. If I leave the value empty, the jobsumbitter send an empty value to the core workbench. I've tried to switch to private parameter and set the default value but I have to maintain the value in the private parameter.How I can force the core workbench to use the default parameter set in it? I'd like that the behavoiur in this case is the same as the programming language. For example:def myProcedure(param1, param2 = False):

After processing I would like to fanout my data based on a created attribute (dataset) and fme_feature_type (10 tables) and write it to an Esri geodatabase with a FeatureWriter. In the created attribute are 4 categories, so basically I need a FGDB with 4 datasets and 10 featuretypes each. So I used the parameter 'Feature Class or Table name' to specify the <variable dataset>/<variable feature type>. It works but the Workbench only creates the first dataset and drops all feature classes and all records in it... What do I miss? Is there a way to let the FeatureWriter create more datasets? 

For example, if the shapefile contain an attribute filed called 'CONTACT' and need to populate its rows with following URLs embedded to display as text strings (display text) instead of actual URL vales as follows. CONTACTSafeEsri

Hi FME Experts, I am trying to use the "WorkspaceRunner" transformer to run workbench based on the other one. in the first workbench I used the creator transformer the WorkspaceRunner, it gives me it is run successfully but it the caching is still updating at the same time also (snapshot).Anyone can help me with that?

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

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

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 requir

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 Cla