Creating and organizing workspaces. How to use Workbench.
Recently active
Looking at the regular Sample\\austinDownload.fmw.When running this through the GUI with an actual email in Email result to field. The workspace will run, create a datadownload url and notify the topics DATADOWNLOAD_ASYNC_JOB_FAILURE or DATADOWNLOAD_ASYNC_JOB_SUCCESS and send e-mail. That is nice When I DONT write an e-mail. It will NOT notify the topics and it will not send an e-mail. So far so good. However how to replicate this through the REST-API of FME Server? I found the 8 year old thread regarding this: Using REST API submit, how to send email (safe.com) However have there been some changes on the REST API the last 8 years to better handle this?
I would like to be able to read other tab in ACC. Right now the AutodeskBIM360DocsConnector transformer returns only the list of files within a project which correspond to the first tab. I can't read the other tabs such as reviews or Issues @david_r , @andreaatsafe , @Takashi Iijima and others , any ideas?
When I update the writer and uncheck "Lower Case Attribute Names" under Table Creation it automatically rechecks it after I close the window. I just want to retain the same field name format from the table I'm reading from.
To create a web service for CKAN connecting to the Open Canada server, I have tried various permutations around https://open.canada.ca/data/en but no luck. Thanks!
Hi there,I have a process in which separate gdb are written and indices are created on specific attributes. The next step of the process merges these separate gdb into one using dynamic writingWhat I want to know is do these settings (creating the indices) are carried over when writing dynamically and if not is it possible to index the specific attributes after the writing? (some python voodoo magic….) Thanks,Itay
I need to connect to SQL Server database hosted on Azure cloud. It is currently blocked within LAN network and we are looking at option to connect to database over SSH or HTTPS. Is it possible to connect to SQL Server database over SSH using FME?
I'm using a schema mapper to update a number of attributes that have string values to a corresponding code. I'd like to catch features where one or more of the attributes to be mapped have a value that isn't in the schema mapping table. There doesn't appear to be an easy way to do this, since some of the attributes on the feature are mapped, the feature exits the mapped port. Has anyone come up with a good solution for this?
I was following to do a tutorial on "Extracting Data within a Clipping Polygon using FeatureReader" but I do not know how to create published parameters from the Navigator. I am knwe to FME. Can you please help.Regards
I have been tasked with sorting out 100s of workbenches. In the majority of them the names of the transformers have been customised and should be in annotations rather than the actual transformer name, for easier readability. E.g. SQLExecutor is actually named Table_xxx or FeatureWriter is Named xxx_Output. I'd like to know if there is an easy way to just revert the names back to the original transformers names. I can't find a way myself, other than manually going through each one and changing it myself. EDIT: This is on FME Desktop 2022.1 Thanks!
Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!
Hallo! I have a general question about the dll's on fmeserver. There seem to be a lot of people having problem with this, but I cannot really find a good solution for it. In my company we have many scripts running on the server (2017.1.2.1 build 1775.) In my case I have made sure to use the same version when I develop in fme workbench.Often we have .dll's that can be found but not loaded, and the script doesn't do its job. This causes frustration for our customers. (An interesting perspective is that we didn't have any problems in our test-server, but they started right away on the production-server). We have tried to analyse if there is any systematics in this (specific scripts running just before, changes in python-version, engine-specific etc., but with no good results).Is there a way to get by with this problem? /Anne
Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc. Database Error Message: [Cloudera][ImpalaODBC] (370) Query analysis error occurred during query execution: [HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'. Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'
I am writing a WS which is reading an Excel sheet for two Writers which are supposed to write in two different environments (DEV and TEST) As you can see since the source data is same I am using only one stream workflow instead of duplicating the transformers for each writer (DEV and TEST) I have created a User Parameter like this Now, can someone please let me know where and how should I assign this into the workflow to select the endpoint (Which Writer to be used)? Thanks
How does one pass a user parameter to a pythonCaller that's inside a customTransformerimport fmeimport fmeobjects def processFeature(feature): p = FME_MacroValues['SomeUserParameter'] print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. "I tried then doing this below but still does not work.import fme import fmeobjects def processFeature(feature): p = FME_MacroValues['{customTransformerName}_SomeUserParameter'] print p What am I doing wrong?
AllI am having trouble automating some workspaces as the data and folders that I receive are containing dates in the format MMMYYYY as shown below...\\\\server\\FMEData\\DataDownloads\\Supplier\\Data\\Data\\Name_Mar2020 The files are supplied as shapefiles and they are also named Name_Mar2020.shp etcHow can I automate the running of these workspaces for when the folder or file name changes to the next month?? I have tried using the * in various places, but to no avail and don't want to have to run these manuallyI know this is something obvious, but just cant figure it out... Regards
I've created a custom transformer which I think can be of use to other FME enthousiasts. I want to upload it to FME Hub as described here Publishing an Item to the FME Hub (safe.com). It states that it is best practice to upload an test workspace as well, but the information provided on how to do that is minimal. Is there somewhere a template available?
Nel livello in cui devo selezionare i dati, devo applicare l'espressione Area >1
Hi when I run the exercise-workspace-prototyping.fmw I received this error can you help ? thx Francesco
Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.
Does the FeatureMerger actually work as a blocking transformer when no features reach the Requestor port? I mean, for example in the workblow below, I assume the Creator transformer will go first but after that, will it read the json file, wait to see if any feature enters the Requestor port and then go on through the rest of the flow? I'm reading and writing the same json file so it's critical to know. It works as expected so far but if anyone knowing for sure could confirm I would appreciate.
I'm trying to do a spatial join between two AGOL layers, one is a strip map and the other is parcel data with owner info. I want to merge the two and create a table with the owner information and its respective page number. I have been using the SpatialRelator tool; the parcel data are Requestors, the strip map pages are Suppliers, Spatial Predicates are intersects/touches/within, and merge attributes are checked with Merge Supplier as the Accumulation Mode and Supplier as Conflict Resolution. The SpatialRelator will create a table with all attributes merged but all of the supplier data is shown as "<missing>" (and it's definitely not missing in the AGOL layer). I have tried a few different combinations of this but I just can't seem to populate the entire table. Has anyone ever encountered this problem?/Does anyone have any ideas on a fix?
Hi, after following the OpenAI GPT-3 webinar I would like to ask if is it possible to create a process to detetc/extract the traffic sign from images using OpenAI GPT-3 in FME thx Francesco
Hi All I have a URL in the format http://blah.com/images/{index] where the maximum index value will be the total number of records minus 1. So for three images the indexes would be 0, 1, 2 What is the best way to take the attribute imagecount and loop to the URL for the correct number of times starting at zero??? Just getting a bit confused now....Regards
Hi,Is there any way to read an image from a excel sheet or expose the hidden attribute/row that contains it?Thanks