Creating and organizing workspaces. How to use Workbench.
Recently active
Hi, I have published a workspace on FME Cloud (2019) where the user can submit parameters such as name, date of birth and comments (using this tutorial below adjusted this slightly to incorporate the new advanced 'webhooks' functionality) and a prettier html form. https://knowledge.safe.com/articles/1295/send-source-data-to-fme-server-with-http-post.htmlThe target URL is as follows: https://<fmeServerInstance>/fmedatastreaming/test/test.fmw?username=bruce&dob=20190101&comments=playstation<&tokenid>Based upon the sensitivity of the information being passed (username, date of birth, status), is it possible to customise the response to omit out any sensitive information after the target URL post to FME Server?New target URL response:https://<fmeServerInstance>/fmedatastreaming/test/test.fmw?submitted_successfullyReason for this requirement: it would be ideal for the user not to copy and paste the target URL response and send it to another user.I have
I have a ListBasedFeatureMerger to merge requestors that have IDs that potentially match the ID of the supplier features.I understand that a list can be generated if there is no complete match with all IDs of the requestor list.In my case, the generated list "_all_matches" appears in the result on the UnmergedRequestor port (see screenshot 2, it has two entries).However, I cannot access these attributes with any transformer.How can I get access to them?
For some reason the default text size for annotations in any FME workbench has changed, and I can't find a way to adjust it back. Based on this link it should be under Tools>FME Options>Appearance, but not on 2018.0, it seems... Currently the text is huge (up five notches from the default size):
Is there a best way to automate what a MySQL Reader and Writer should use based on a specific file name? For example if file name = foo.txtUse the reader/writer DB connection for fooDB.If file name = fooBar.txtUse the reader/writer DB connection for fooBarDB I know that User Params along with a Filter in the automation may make this possible, but I don't know if that's the best route to go. I would also like to refrain from having multiples of the same workflow for thier respective DB connections. Thanks in advanced!
Hi, From a running workspace i would like to write the userid,starttime, endtime, and the filename of the workspace into a metadatafile. Starttime an Endtime is possible with datetimstamper but it is not accurate. Does someone know the solution?Kind regard Kees
I've started have a problem where my transformers jump around in the work space. They seem to be snapping to the upper right corner. This tends to happen when I connect it to the output port of another transformer or to an existing connection line. Occasionally it will happen after I hit OK after updating the transformer parameters. I have verified that the grid and guides are both unchecked. I'm on 2016.1. Has anyone else seen this and found a setting to prevent it from happening? I can be very inconvenient when working with a large workspace.
How can I define a for loop, that count the average one after an other point. I sorted the point list, so now they are in ascending numeric order, and I want to calculate get a values that comes from the average of the points . For example: the fifth elements average is counted from the first five data, the sixth is from the 1,2,3,4,5,6th element?
Hi Partners,A new article has been published which provides a workaround for a known issue with upgrading FME Server 2016.x or older to 2017.x or newer.Known Issue: Error when FME Server role contains "quotes"
I'm using WorkspaceRunner to run several workspaces. Then a FeatureReader reads a folder where the output of those workspaces would go. I need to list the output in the email and also attach them to the email. If I just attach the featureReader to the Emailer, I get multiple emails. If I aggregate the files as a concatenated list, the emailer doesn't know how to parse the string to attach the files. I need some help.
I need to read a GeoJson from an URL. One of the attributes of the call is the current time that I could get using the "Date/Time Functions" on Text Editor, however those functions are note available in the reader. I tried to use a FeatureReader where I can set the current time properly but then I don't have the "Network Authentication" options under parameters. Any clue on how to set the reader source GeoJSON URL dynamicaly?
Hi I have a number of features, each with a list of dates which I obtained using PointOnAreaOverlay.I would like to order the dates within the list. I am using PythonCaller to process the list and write to a separate table. Any suggestions?
Hello community,I have a folder with all .mdb files that I want to process independently. Therefore I am using a 'directory and file pathnames' reader together with a workspace runner. So every file is send to another workbench, where it will be processed.In this 'other' workbench I have a 'Microsoft Access' reader, with the 'Single Merged Feature Type' box switched on. When I select the table name myself it works all perfectly. However, here comes the trick. The table names that I am using are different for each incoming file. For example the table name for file 1 could be trees_abc, for file 2 monumental_trees_abc and for file 3 tree_export_abc.The table names have one thing in common. They contain the word tree and always end with _abc. This regular expression should catch all the possibilities: ^(\\w+|)tree\\w+_abc (so it has the word tree somewhere and always ends on _abc). Now I was wondering if I could implement this regular expression somewhere i
Hello Safe, i have one published parameter name "FEATURE_TYPES" and it basically defines data from a ESRI geodatabse. The download process works good with this parameter. Problem is happing when I change the name into "nm_FEATURE_TYPES". The data download process stopped and giving the error: statusMessageParameter 'nm_FEATURE_TYPES' must be given a value. statusFME_FAILURE This there any solution for me thus i can use the name nm_ for my Published parameter? With kind regardsMuqit Zoarder
Hello FME friends, I have a question about system path variables and how that translates to FME server.I downloaded the Google cloud Storage connector from FME HUB. I'm using a Google service account along with a service account, JSON key file. Part of the configuration is to set the windows environment variable GOOGLE_APPLICATION_CREDENTIALS to a JSON key file I downloaded from Google Cloud Console.The package works flawlessly in FME workbench on my workstation. I would like to now publish a workflow to FME server, but am scratching my head trying to figure out how to deal with the environment variable GOOGLE_APPLICATION_CREDENTIALS and how that translates to FME server. I assume the .JSON key file for this Google service account needs to be on FME server somewhere, but how do I tell FME server that the environment variable points to the .JSON file on an FME server resource folder? Thank you!
I've got some features and one of their attribute is a sequence of number or number with letter such as A001, A002... Now some of numbers are miss from sequence due to editting was performed. Is there a way to find out miss numbers and asign them to newly created feature from North to South, West to East?
I would like to create new attributes for all features with a value of null. The tricky part is that the number of these attributes and their names is not known before running the workflow. The names have to be equal to the feature values provided by some part of the workflow. I attach an image of what I am trying to do: I am feeding the AttributeCreator with the main table (the one where I want to have new attributes --or columns -- with null values) and with the UnmergedRequestor of the Feature Merger. The feature values of SimWaterBodies_FN (the output of the UnmergedRequestor) are supposed to be the names of the new attributes (2 in this case) of the table. I have tried by setting @Value(SimWaterBodies_FN) as the New Attribute and null as the Attribute Value of the Attribute Creator, but this doesn't create the 2 columns with same length of the main Table. Here is a simple example of what I am trying to do: Let's say this is the main Table initially: When I run my workflow
HiI'm using FME 2018.1.1.2 18586 and having weird crash errors. The app crashes apparently at random, I have taken a blank workspace and added a MapInfo file as a reader and the workbench app crashed. this happened several times. I left Workbench open for a while (maybe an hour - working on other things!) and tried again and it added successfully this timeThe odd crashes have been going on all through the 2018 releases. I only have this release installed on my machine. It seems to like to crash when using Feature Caching mode more than any other time or when using HTMLReportGenerator (which is quite annoying because this transformer is a gem)Is there any advice that anyone can give me to stop this please? FME used to be rock solid on my machine and recently it has become very buggy, to the point where it is becoming quite unusable.I've reinstalled previous versions to try and combat this issue and I am using a build that is only a few weeks old nowThanks in advanceAdrian
I have a problem with one of my workbenches. A few actually, but the most important one: It skips a part of the workbench and I have no clue as to why. After this, it continues, but no suprise: Point on area overlay does not work without points. Problem 2: Featuremerger does not work. It simply refuses to merge 2 identical columns. The weird thing; If I use chashing and run from the featuremerge onwards it will merge and it won't skip. And then the second feuturemerger refuses to merge only a few (+/1 100 out of 3000) feutures. I get no error messages at all. I am at a total loss as to what is happening and I am getting a bit frustrated.
Hi,I am creating a dynamic schema from a list, however when I am trying to create a GUID in an Esri File Geodatabase it is showing the field as text (using both writers and changing the format_short_name). What's more annoying is this same example is shown in this article: https://knowledge.safe.com/articles/1051/index.htmlDoes this no longer work, or can you see an issue in this example??Guid.fmw
Dear community,I don't find a solution to my problem and hope someone can help. To automatically create XML documents for a metadata catalog, I created a generic FME workspace. An SQL Creator serves as an initiator to a FeatureReader and all features and feature classes are received through the <Generic> Port of the FeatureReader.Because I tend to create a document for each feature class (POSTGIS table) rather than for an individual feature, I use an Aggregator to only have one feature per feature class. Important here seems to be that I use the Group By setting which groups all features by feature class (attribute fme_feature_type).After having gathered all necessary information for each deature class (like bounding box and description/title) with various transformers, the processing chain comes to the XML templater which creates the XML file document.The problem is that I have no idea how to deal with the keywords that are saved in a list attribute (array). I have a root templ
I'm currently trying to create a script to run a workspace, and test the output against an expected result. However, although I can successful import fmeobjects, it seems to have no attributes?console example: in a script:AttributeError: module 'fmeobjects' has no attribute 'FMEWorkspaceRunner' I'm using fme 2018.1Any ideas?
I have a workspace that uses a feature reader to read just one table from a geodatabase. I need to batch run this workspace for every feature type in the geodatabase.I created a new workspace with a schema reader and a workspace runner to run the original workspace, with the feature type populated from the fme_feature_type_name from the schema reader. The feature reader in the child workspace fails. If I hard code the feature type in the published parameter in the workspace runner in the parent workspace, the feature reader in the child workspace runs. But as I need to batch run this doesn't solve my problem.I've made a pair of sample workspaces that replicate this issue with an Excel Spreadsheet. They're here: Is there any way to do a batch run with a feature type as a parameter that can be varied to cover the whole schema?
I am looking to make lists based off of attributes that have i currently have. For example (photo below), I am looking to build a list between Field1 and Field2.For example in the first row _list{0} = 40, _list{1} = 41, _list{2} = 42, ... _list{10} = 50.
Hello All,I have an excel file wherein i have two header rows, first one with a main heading like 2019 and the second one below it having sub-categories like Furniture, Music, Fun and then the data from third row. Is there a way to write the data to an excel file in the same manner of first row showing the merged cell and the second row showing all showing all separate values?Thanks
FME Server 2017.0 Does anyone have insight on what permissions are required for the FMEServerJobWaiter to work? I have tested with other admin level users and there are no issues using this transformer. FMEServerJobWaiter(ServerFactory): <servername> - Waiting for job #384798 to start; polling every 10 second(s)...FMEServerJobWaiter(ServerFactory): <servername> - Failed to wait for job #384798FMEServerJobWaiter(ServerFactory): Reason - user '<username>' is not authorized to perform this action