Automation

Hi all,  I would like store the historical data in FME Server to MS SQL Server database. I have successfully store the data from FME Desktop to the SQL Server. Then I have publish the workspace to FME server to do the automation which will update the data daily at 9.00 AM.    However, I couldn't store and view the past data in the database once the data is update after the automation. Any suggestions?

We've upgraded to fme server 2021, and when we build a new automation, it's impossible to use a value from upstream and pass it to a workspace parameter when the parameter type is not plain text. Before with fme 2020, its was possible to set a choice parameter with a uptream value.   Is this a bug, or a new behavior for fme server 2021 ?

I have a set of data which contains an attribute name (header/title) which I have to use an an attribute value for a new attribute. At the moment, I am using attribute creator to create a new attribute and then attribute manager to add this to existing data. However I am unable to set the new attribute value as one of the attribute name of existing data (which I read in using reader transformer). Any help will be highly appreciated.

Has anyone configured an FME trigger webhook as an outgoing webhook in Teams? It'd be very nice to just @ an automation without leaving Teams. I've got an automation triggered by a webhook that can be triggered no problem using curl, but trying to use that webhook in Teams gets an immediate failure ("Sorry, there was a problem encountered with your request"). It looks like Teams may be expecting a particular response (https://stackoverflow.com/questions/45743782/custom-bot-always-replies-with-an-error) and I'm not sure whether FME provides that / how to troubleshoot from here.

I want to remove the FILECOPY_1 path from the data download zip file from FME Server when using the filecopy writer, and can't figure out why it isn't being removed. When I enable the Data Download service on FME Server when publishing, I make sure to set the Path in the Zip File to empty, but I still receive the data download file in the structure listed below. Current Download File FormatFME_3637254D_1587574658508_152.zip\\FILECOPY_1\\examplefile.txtFormat I Want to ReceiveFME_3637254D_1587574658508_152.zip\\examplefile.txtAny ideas as to what I can do to remove the "FILECOPY_1" from the download zip from FME Server?  Below is an image showing how I have it setup for FME Server.  FME Server 2020.0.0.1

FME server documentation states:Note: Each IMAP Publisher created on FME Server must reference a unique email account. You cannot create multiple IMAP Publishers that reference the same address.However, I have done some testing with this and I have created more than one publisher with the same IMAP email. Bother publishers work. Am I missing something? Is there going to be a future error or fault? Where is the conflict with this? Thanks.

Hello, I've made a workbench that downloads data to Shape automatically once per month from https://geodata.nationaalgeoregister.nl/hwh/eenheden/wms/v1_0?request=getcapabilities&service=wms (WMS).  This time I would like to make a workbench that compares the geometry and administrative data from the Shape files with each other (January-February, February-March and so on). I am thinking about doing this with the ChangeDetector transformer, but that's where my idea stops. Could anyone give me advice on this?  Many thanks,Claire

Hi, I've build an automation in the FME Server with Trigger type: Schedule initiated and Schedule type: Repeat on interval for 1 minutes (for testing purpose) and it works perfectly . However when I stop the automation and set the interval for 1 day at 7.00am, the automation is not working after I checked again the service the other day.   Any idea on how can I resolve the issue?

Current stepsRevit IFC readerGeometry Coercer -> FME_composite_surfaceSurface Footprint Replacer -> Overhead ShadowGeometry RefinerScalerDissolverGDB Writer Extra info: The process has been created as a result of mostly trial and error with varying IFC files, although mostly similar. For this exercise attribution can be ignored other than FME_feature_type to remove the redundant IFC components (site, project, building etc) It feels like there is a lot of 'junk' in the IFC format that is not required for geometry work. What steps are possible to clean / optimize / dissolve IFC files or their derivatives to increase workbench processing speed. I cannot supply an example IFC file due to data security.  

I am tasked to asses FME and determine if it will be a good fit for our organization as main integration platform. I have done some research on FME and have few questions (where i could not find much documentation):Does FME have any self-documentation feature or 3rd party add-on which can be used to achieve this? How does most organization maintain design documentation for workspaces?Can FME Server expose REST APIs that are created by developers or we absolutely need to get a 3rd party API Gateway (AWS, etc.) for hosting APIs, security, etc?What capabilities FME provides for monitoring (performance, errors, etc.) or all of this has to be designed by developers?What additional tools are required in the Integration Stack to support basic patterns like APIs and Messaging ? What does your implementation have.Any pointers to documentation that

HeyI recently learned through this webinar: "Creating No Code Web Apps with FME Server" how to create an app with the help of the server, and thus optimize our work.It is explicitly stated that the application can be embedded in any external site. Just copy and paste.When I tried to create the app, it would not let me access the app from an external computer. (The server is currently installed on only one computer.)What do you need to do to have outside access to these apps? Thanks  Dor

I am looking for the possibility to process the status message of a FME script (Translation SUCESSFULL / Translation FAILED) within a Python script, or to stop the script as soon as the processing was not successful.Currently I call my workbench inside a Python loop and process a (first) part of the data. Then I call the Workbench with the next part of my data and so on. Unfortunately, with my current workflow, I have no way to see when my Workbench generates an error in between and actually terminates. Within my loop, it continues and moves on to the next part.Currently I generate my argument using a function:def get_arguments(GDB, CSV, Start_Object_ID, Last_Object_ID):    arguments = []    if GDB:        arguments.append('--DestDataset_GEODATABASE_FILE "{}"'.format(GDB))    if CSV:        arguments.append('--DestDataset_CSV2 "{}"'.format(CSV))            if Start_Object_ID:        arguments.append('--Start_Obje

Hi,I want use automations to concatenate workbenchs published in FME Server. But I want use the result of the first workbench to use in second workbech as a reader data. In first workbench I use a FME Server Automation Writter, but I can't configure the Automation to get my finality. Is possible this scenario?Thanks! 

I have two tables, they have the unique ID to compare with each other. There is another column called year in both tables. I am hoping to find records in table2 with the same ID in table1 and then compare the 'year' attribute, only keep the latest one. Which transformer should I use? The feature joiner can find all records in table 2, but it can't dynamically decide which one to keep.  

I am using system caller in child workbench which trigger 3rd party service using command line and start the process e.g. abc.exe in windows. Sometimes process get stuck at their server and I am not able to get the status of the same, hence child workbench continue until any response gets from System caller. Is there any solution to kill the 3rd party process using windows process name or ID if its taking more than a particular time e.g. 1 hr?Note: I am using FME Desktop with concurrent process of 3 jobs, so it should kill only the process which are not getting finished within 1 hr.Can anyone help me on this?

Have two automations happening where one downloads files off an Azure Blob storage. The other is actively listening to the folder where the first automation downloads files too to trigger a workspace. My problem is that for some reason AzureBlobStorageConnector sometimes downloads files as 0kb. Is that cause it's trying to download files that haven't fully uploaded to that Azure Blob Storage? I.e the same thing that happens when you download something off the internet and it goes to the download folder as a temp file - until it downloads fully. CheersDan

I want to terminate child workbench automatically if its taking more than the expected time (e.g. 30 min). Also it should be treated as successful translation in the workspace runner so that next job in queue can start concurrently. Is there any solution?

I was using Httpcaller for an automation but I could not get it to work. The URL to the service I wanted to use worked fine in the browser but when my automation ran, it resulted in an error from the service saying "invalid URL". It turned out that my URL contained spaces that was encoded as %20 wich the Httpcaller encoded in turn to %2520. Replacing %20 with a space in the Httpcaller solved the problem. Is this desired behaviour? I'd excpect the Httpcaller to understand not to encode an URL that is already encoded.

Do I need to refresh the "Run Workspace" action in an Automation on FME Server when I make an expression change in an Attribute Manager in the workspace? I've published the updated workspace to FME Server already. Will the Automation run the newest version of the workspace? Or do I need to make it "see" the change somehow?

I have built a simple Automation that is set up to read in email attachments, process them in workspace 1, and then move the attachment files to another folder location in workspace 2. The trigger is an IMAP trigger, which polls every 10 min. This means that sometimes, there are two or more emails waiting to be processed when the email is polled. When this happens I would like email 1 files to be processed through both workspace 1 and 2, before moving on to email 2, but I am having trouble setting this up. Currently, my job logs show:Workspace 1Workspace 1Workspace 2Workspace 2But I would like them to process in a different order so the job logs would look like this:Workspace 1Workspace 2Workspace 1Workspace 2I had a similar Automation set up and working this

Can FME connect/read the database files of the 4D system? (extensions like: .4DD, .4DB)

I have a time series data historian that I have established an ODBC connection to successfully. I can pull tables in and have filtered the data by time to reduce the records while I am testing. The table I am attempting to bring has a field called _index. I am not sure why they used a reserved word, much less started a column name with an underscore. It is causing FME to choke every time, understandably so. Is it possible to remove or have FME ignore that field and bring the rest of the data into workbench?

ProblemThe problems are caused by the underlying functionality of how FME Core downloads the email attachment and with the default FME Server Cleanup setup One of the functionalities that will be broken with this, is, for example, Backing up the FME Server. Resulting in a `COM.safe.fmeserver.configuration.migration.FMEConfigurationException: java.io.FileNotFoundException:` for the attachment. This is reproduced with the following steps:Create an Automation Trigger of an email (SMTP)Define a custom "Download Attachments To (optional)" path. Preferable something that is not covered by the default FME Cleanup, like`$(FME_SHAREDRESOURCE_DATA)/custom/mail/received/`Make sure this is triggered and the attachm

Hi all,I have an FME Server automation that runs a number of workspaces one at a time. In the first workspace I want to apply some kind of action depending on whether there are any features on a certain transformer output port. For example, I can place a NoFeaturesTester on this port, and:If it reports no features, I would like to inform the user in some way and continue with the remaining automationIf it reports that there are features, then I would like to send the user a list of these features (via email perhaps), and also look to pause or terminate the Automation.Can anyone advise a sensible way of doing this?Thanks,RB     

Assume I have an automation that starts with a directory watch to capture an updated zip file in a folder. The zip file name is passed as a parameter (File Path) to the 1st workspace. This workspace is followed by a second workspace, which needs to use the same zip file as a parameter. I can not figure out an easy way to feed the File Path (zip file path) to the second workspace as a parameter, other than writing it to a text file and let the 2nd workspace to read from the file. Any advice to make this easier and streamline? The FME server is 2020.1.3.