Creating and organizing workspaces. How to use Workbench.
Recently active
Hi,after saving in the History panel (Workspace Parameters Description), the columns are resorted and the row content moved up. (Version: FME 2019.1)Befor saving:After saving:Can you help me please? Thanks.Marleen
Hello, I have a problem with my FME script.My goal is to create a custom transformer that does the same thing as AttributeValueMapper but by using a dynamic list off matching value.Why ? Because I have a file witch contain data that I need to clean :File "data"field_test_1 field_2 field_test_2 xxx Good morning ab xxx Hello ac xxx Salut ab zzz Bonjour ab yyy Konishiwa ac To do this, I have a file which contain all my matching values like this :File "code_list"code value CODE_A_01 value xxx CODE_A_02 value yyy CODE_A_03 value zzz CODE_B_01 value ab CODE_B_02 value ac CODE_C_01 value xxx My goal is to replace value in "field_test_1" and "field_test_2" from the file "data" by codes listed in the file "code list".Little things to keed in mind : codes need to be filtered as values from differents fields can be the same but not corresponding to the same code (has you can see lines 1 and 6 from file "code_list"). First tr
Hi all,We are running a license server (v11.15) with 10 floating licenses ESRI Edition.The number of users using FME Desktop are growing fast, even faster then the budget :-)Among the users there are different profiles.So we want to set up a pool of licenses per AD user group. For example:- primarly we want to create a pool of floating licenses professional edition that only members of specific Active Directory group can use- beside that we want to create a pool of floating licenses ESRI edition preserved for members of an other active directory group Is this possible? If yes, what's the configuration? Thanks for sharing the knowledge,Kind regards,Francis
I have an FME workspace "A" using a CAT reader that works well.I have another workspace calling it with a WorkspaceRunner, which goes through a bunch of files using a "Directory and File pathnames" reader.In the workspaceRunner Parameters of workspace "A" and can't select "attribute value" from the "Directory and File pathnames" reader :/I changed my workspace "A" for a plain text reader and now I can select "attribute value -> path_filename". There seems to be a bug with the CAT reader inside a WorkspaceRunner :/Am I doing something wrong?
I'm trying to read the data from an Oracle Locator database into FME. When reading data through both the Oracle Spatial Object reader and the Oracle Non-Spatial reader everything goes fine.However, with the Oracle Spatial Relational reader, I get the following errors when trying to get the table list (see image 1): The log file says the following (see image 2) Am I getting this error because I "only" have the Oracle Locator database, and not a full Oracle Spatial database? Or is the error due to missing parameter settings? To be clear, I'm using the same database connection.
Hi, I downloaded a workbench which was on FME Server to a FME 2019.1 desktop workspace but I can't get it to run due to an issue with Emailer and Python as per the message below. The workbench was previously a FME 2017.1 workbench when it was first uploaded to FME Server. 2019-09-20 12:04:19| 17.1| 0.0|ERROR |Python Exception <ImportError>: bad magic number in 'Emailer': b'\\x17\\r\\r\\n' 2019-09-20 12:04:19| 17.1| 0.0|FATAL |PythonFactory failed to load python symbol `Emailer.Emailer' 2019-09-20 12:04:19| 17.1| 0.0|FATAL |Emailer_2_CALLER (PythonFactory): PythonFactory failed to close properly 2019-09-20 12:04:19| 17.1| 0.0|ERROR |Emailer_2_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for details I have tried upgrading the Emailer transformer to the most recent version but this didn't make a difference. I have also tried changing the Python Compatibility from Python 3.5+ to Python 2.7 but then the workbench fa
Hi, I'm using the BulkAttributeRenamer to get rid of special characters in multiple attributes using regular expression. My expression looks something like this and initially I had no problems. <|/|\.|>|\*|ä|ö|å|\+ Suddenly my workflow didn't run anymore and I received the following errors. An error occurred. FME will attempt to provide more information on the error, but this may cause the translation to be terminatedinvalid vector<T> subscript It seems that the problem is the symbols <, >, * and I have tried to escape them but without luck. I also find it extremely weird that it worked one moment and didn't the next. Does anyone know of a workaround so I can get rid of these characters and symbols. Thanks! /Jacob
I am trying to run a workspace from a python script. I need to pass the portal as a parameter for the workspace. The workspace reads the new portal and then saves a copy to a gdb. I can not find any documentation or examples on how to write the syntax or what syntax is needed to get the workspace to recognize the portal. If anyone knows how to do this, it would be a huge relief. # ============================================================================ # # Name : RunWorkspace.py # # Purpose : FMEPedia Sample of FMEWorkspaceRunner # # Author Date Changes made # ------------------ ------------ ------------------------------- # Ken Bragg July 15th, 2014 Original Definition # Note: # The path to fmeobjects must by in your python path so you may need something like this: import sys sys.path.append(r"C:\Program Files\FME\fmeobjects\python27") import fmeobjects import arcpyimport traceback try: # initiate FMEWorkspaceRunner Class runner = fmeo
i have two to FME Workflow process step-1 and step-2 Concept: after completion of step-1 there is a some manual actions required so then run step-2step-1 outputs may get max four shape filesif nothing or one shape-file will export output of step-1 then auto-call for step-2 is there any possibilities plz suggest..... !
I need to find the best way to change the name of a table that is referenced in some sql transformers
Hello,The screenshot below illustrates my solution for this question.Compare two columns (Category and Class) and detect if the Class entered is in the right Category I thought that this works fine, but found a wrong result when the comparison mode for the IN operator was set to Automatic.The result will be correct shown as following If you set Case Sensitive or Case Insensitive to the Comparison Mode, but I believe that Automatic mode must return the correct result as well.I suspect there could be a potential bug here. Could you please take a closer look at this? (FME 2019.1.2 build 19630)
Hi, I have a list of fmw files like this one:That I want to use to go through and extract some data or each fmw using the FME Workspace (FMW) reader.To do this, I have created a workbench “FileProperties.fmw” that takes the feature type FileProperties of a workbench using FME Workspace (FMW) reader and puts data to a csv.Then, because I want to apply this process to multiple workbenches and not just one, I have created a separate workbench "RunWorkbench.fmw" which uses a WorkspaceRunner that runs FileProperties.fmw workbench for each of the files of the list. Each line of the list is used as a variable, so FileProperties workbench analyses each fmw file in the list and extracts the data into csv.In the WorkspaceRunner configuration I run fmw_properties.fmw. WorkspaceRunner knows which workbenches to analyze each time because in fmw_properties.fmw I created create a published parameter that will pass the workbench to be analysed. This is how I setup the published parameter in
Hi FME Server users!I've been recently playing with the FME Server API, and I've found something that I didn't expected, at least following the specs from the API technical doc: (https://docs.safe.com/fme/html/FME_REST/apidoc/v3/index.html#), from GET : Transformations/jobs/completed section. I tried the GET capability to gather all the information regarding a specific Workspace which is run under FME Server 2016.The request states as follow:XXXX:YYYY/fmerest/v3/transformations/jobs/completed?completedState=success&limit=-1&offset=-1&repository=Built-Up%20Areas &workspace=Unnamed_Multinaming_UpdateLayerLoop_FME2016.fmw&userName=janera&fmetoken=00000000000 As you can see I opted to fill that "WORKSPACE" and "REPOSITORY" parameters, which I assumed to get information back related only to that workspace.Unfortunately, I'm getting also info from another Workspace which runs periodically from same repository. My Q. here is: Am I as
Hey folks,After some hours of Googling and of searches on this forum, I'm writing here to solve my problem. I've built a huge FME Batch to do some stuff on IFC files with some Excel readers, ACAD readers, and CommandLine. But here isn't the problem, that Batch works properly when I run it 'alone'. Here a quick overview of that Batch : Everything is ok with that Batch, but then I would like to work with a PathReader and a WorkspaceRunner in order to work with all the IFC files of a folder. So, I've set up that Batch which is really simple : With these following parameters : When I run the batch with a Pathreader and a Workspacerunner it seems to run properly too, but nothing happens then (i-e any files are created at the end of the Writers).Does anyone already had those type of problems ? Do I need to set up something specific in the 'child' batch in order to run it with a folder reader ? Thanks to everyone for your future answers,Best.Clem
Hi all, I'm currently putting together what will become a generic set of workspaces to use on various different projects within my company.The workspaces will be contained within a set folder structure of Inputs/Processes/Outputs that can be copied to project folders as and when they are needed.I want to be able to define the writers to always write the outputs to the 'Output' folder, for when someone copies them for use on another project and the output destination path changes.I have created an attribute (Writer_Path), derived from fme_dataset of the inputs, to write to this Output folder, but i cant seem to set the writer path to this attribute.I feel like i might be missing something obvious in a fanout or something, but any help would be greatly appreciated! Thanks!Jack
I have a pretty simple FME program with a reader from an ESRI geodatabase, attribute manager and writer to the same geodatabase. If I'm adding user parameters for certain attributes, the dialog box will start taking several minutes to appear, and then to edit parameters, it can take even longer. On new parameters I add, it tries to pull up lookup tables as I enter a value, but it won't do that on my other parameters. Does anyone why the user parameter dialog box would take a log time to open? Thanks.
About a week ago, FeatureWriter (Version 0, there doesn't appear to be a newer version available) in an existing workbench, no longer creates new Esri File Geodatabases on network drives/shares. The bench had not been changed between the previous run when it worked and the subsequent run when it did not.It will NOT create new GDBs on any network location, on any server, using either mapped drive letter path or full UNC path.It WILL truncate, drop/create tables in an existing GDB in the desired network location.It WILL create new ESRI SHP files or AutoCAD DWG files in the desired network location.It WILL create new GDB on a local (C:) drive.I have verified that I have create, modify, read, delete permissions to all of the tested network locations.Updated to a clean install of the newest version of FME Workbench (19.1), no change in behavior.Tried creating a brand new, empty workbench, inserting a brand new FeatureWriter to rule out some altered setting or parameter being the culprit
FME 2019.1.2 build 19630The Max Features to Log parameter (Workspace parameters or FME Options) doesn't seem to work. The number of logged features is always 20, regardless of setting in the parameter.
Transformers such as the matcher appear to use hidden attributes to match on when the attribute matching strategy is set to match all attributes. Is it possible to remove hidden attributes without exposing them first?
HI.I'm tasked with switching Python version for a service user without login.The setting under "FME Options" / "Translation" / "Preferred Python Interpreter" is therefore not immidiatedly available to me for this user. I have ascertained, that this setting is both version and user dependant (but not 32/64 bit). But I've looked all over the registry for it without success. Can anyone help with this ?Cheers.Lars
i have to select based on positionselect based on positions like first position Alpha and second position numeric or first two alphabets and last numeric HSNAFD151212114A15A10ABBAC501D1D2D5D is there any possibility to select yellow highlighted vales based on above parameters Thanks in advance
I am using FME 2014 SP4 and I see that the behavior of Custom Transformer Inputs differs from previous versions of FME. I have 3 transformer inputs which all show the same attributes- however each of these input lines should have different attributes. When I Edit Transformer Input to expose Attributes, the checked attributes get applied to all 3 Transformer Inputs. If I uncheck Publish on Transformer Input- I loose all attributes. What can I do to expose attributes on only the Transformer Input for which they pertain? I am more concerned with keeping the inbound attributes straight per feature pipeline, than using published parameters. Thanks!
I have set up a complex workbench, which 8 of the 10 times runs fine without trouble. However, twice it has fallen over now, because my input data provider has been using lowercase for an attribute name when he normally uses uppercase. I can't change it in the transformer (AttributeRangeMapper), because it only 'sees' the uppercase attribute name from the reader (with wildcard). Given that this is such a basic issue, I hope that there is a very basic solution as well. Is there? At the moment, my solution is to have a second identical workspace, but with the offending attribute names set to lowercase. Not ideal...
Hi FME'rs! Recently an FME user ran into an issue with the ListIndexer where it did not return the desired output. The user initially generated a list from the Format Attribute, fme_feature_type and so appropriately gave the list the same name, fme_feature_type_list{}. However because the list name began with fme_ it is not processed. This is because _fme is a reserved word in FME used by Format Attributes and as a result, some transformers are unable to correctly handle User Attributes/Lists that contain this prefix.In general we would recommend the fme_ prefix should be reserved for use by format attributes only and I have filed TECHPUBS-6273 to ensure this is highlighted in our documentation. However it would also be great to compile a list of known transformers that can have trouble handling the fme_ prefix on user attributes, and this is where the Community can help!Please comment below to share your experiences if you have encountered anything that sounds similar to the scena
I need to make the error messages of logfiles output on fmeserver (after running a workbench) more "readable/helpful/shorter" and finally return it to an email sender.As far as I see, there are the following options:a) I could use the usual logfile (like on fme Workbench) and parse it somehow within a shutdown script of the workspace, handing the result over to the emailer (or trigger a notfication) - don't know the exact workflow on fmeserver, yet.b) if I don't want to write python or tcl, I could probably use a job chain: running another workspace interpreting the logfile and sending out another email with interpretational text. This should be possible to be used directly by the emailer (within the workbench), right?c) I could go for an automation on fmeserver and use those logfile-options there (don't find good hints on how to produce a good output, there).Any hints what to go for? Are there any best practice examples available ?Thanks for your help, Marion