Automation

Hello All, I am trying to import an external module named openpyxl in FME but unfortunately isn't able to setup the environment. Can anyone please help me with identifying what all is required to setup the module in FME? Every time i try to run it inside the python shutdown script it throws the error as module doesn't exist.

Hello, I'm running FME 2019 server. In workspace I have ServerJobSubmitter with parameters like that (I updated to newest version of this transformer): My expectation was that test.fmw will be executed on the same engine but it was executed on another engine (which is installed on the same engine server). Why is it like that? Is it possible to have that job executed on the same engine like it was in previous versions?

I'm testing out the new automations in FME Server 2019 and I am needing to chain workspaces together while passing parameters (file outputs) between them. I am not finding a way to do so without using the FME Server Job Submitter transformer that I have used in the past. Is there a way to pass parameters between chained workspaces in the automations rather than using the job submitter transformer? I've gone through the tutorials here: https://knowledge.safe.com/articles/87453/getting-started-with-automations.html , but haven't been able to figure that out.

Hi, if I click on "Topic monitoring" in the fme server portal I get the error: "There was an error connecting to monitoring service" The port 7078 is open and if I request http://fmedev-test.de:7078/, I get the answer "not a WebSocket handshake request: missing upgrade". So the firewall rules should be right and a telnet command to fme server via 7078 also works. I've also set WEB_SOCKET_SERVER_NAME in Utilities\\tomcat\\webapps\\fmeserver\\WEB-INF\\conf\\propertiesFile.properties The logs from websocket.log in publishers and subscribers are: Opening log file using character encoding UTF8 Tue-13-Feb-2018 02:45:58.721 PM INFORM main 801001 : Publisher "websocket" is starting up ... Tue-13-Feb-2018 02:45:58.721 PM INFORM main 801002 : Publisher "websocket" is updating configurations ...Opening log file using character encoding UTF8 Tue-13-Feb-2018 02:45:52.909 PM INFORM main 803001 : Subscriber "websocket" is starting up ... Tue-13-Feb-2018 02:45:52.909 PM INFORM main 803002 : Subscriber

I'm using directory watch with FME server 2019 to trigger a workspace when a file is updated. the Directory watch is set to watch the directory every days. For now, when there is an update, It run the workspace at noon, and i wish to wait till midnight before the workspace start. Is there a way to add a time option for when the directory watch start ? or a waiting time before the workspace start ? Thank's

I'm working with FME Server 2019 and was wondering if/how it is possible to use the automations functionality as followed: So, i start a Data Download Service workflow with REST. This workflow performs its arts and then sends a mail if valid with the results if available or no mail when no new results are the (but the workflow still did the job). And failed if there is a bug/rejected stuff. Is there a way to check/test the {downloadUrl} that is used in the Subscription before sending the link? Sending format C is easy because that is just one topic and subscription connected to the failed results. But when the job is successful and the URL in {downloadUrl} is valid it should sends the mail in format A and if the URL in {downloadUrl} is _undefined_ it sends the mail in format B. I was wondering if there is a way to keep the Data Download service as-is but test the content of the {downloadUrl} for further actions regarding the formatting of mail mail.

I hope somebody can help with following: I have a list (text file) with similar urls stock data. The only difference is the ticker code in the name (e.g. "https://www.barchart.com/stocks/quotes/AAP/performance" and "https://www.barchart.com/stocks/quotes/BA/performance are some of them). I read the whole list with reader "Text_line". After that I made a reader for one of these urls in order to know what I will scrape. This is Table1. For so far everything goes well. But after this I want to merge or combine these two so that for all the urls in the Text_line Table1 will be extracted and I will get one file containing on each row: used url, performance 5-Day, performance 1-Month, performance 3-Month, performance 6-Month, performance YTD, performance 52-Week, performance 2-Year, etc.

Hi FMEr's I am using FME server to build relationships in an access database-- in tFNE server data folder--via an SQLExecutor, so no writers on the workbench. My issue is that I cant download the access database from the shared folder. Any thoughts on how to accomplish this?

Has anyone come across an email address validator using FME? I want to use an API, ideally, to check email addresses for my contacts are valid. Any assistance or workspaces would be appreciated. Thanks

With the "IMDFToArcGISIndoors.fmwt", I was not to able to find the source IMDF dataset "NoError.zip". Is there a place where I can download this data?

Within an automation I want to trigger a workspace with a previous result. In this case, as shown in the picture, I only want to process a submitted file if the validation is valid. Most desirable is that I can set a certain parameter within the createValidationStatus workspace and be able to filter on that in the automation filter. Unfortunately I haven't figured out how to do it this way. I did find a work around by adding a terminator to the workspace when a submission isn't valid. This wil result in an "action failed". But still this isn't desirable because submitter and administrator messages got mixed up. Failure doesn't necessarily mean workspace failure. Question: What is the best way to pass results from an upstream workspace within an automation?

Hi, I'm trying to send an email (to myself) after a succesful translation. I implemented the steps mentioned in the link (with the featurewriter, sampler etc) by @aaronkoning : https://knowledge.safe.com/questions/4963/sending-mail-in-fme-desktop.html However, eventhough the translation itself is succesful, the email apparently gets rejected (see image), and in the inspector 17, I see the following error: Fme_rejection_code: ERROR_DURING_PROCESSING (don't mind the lack of output from the featurewriter, I was playing around with it just before screenshotting. It generates input just fine). What am I doing wrong? I'm using FME Desktop version 2018.1.0.1.

I have a number of workbench that do some things. Each workbench made specific work and each workbench is independent. When I published my workspaces I set notifications on my topic in the jobsubmitter service. If I run each workspaces alone on the server, notifications are fired and all is ok. Now, I have created a workspace that call my workspaces with FMEServerJobSubmitter. It's like an "Automation" but made with a workbench (we use fme version 2018). I published my workbench that run my workspaces and I've scheduled it to run in the night. I expect that each single workspace fire my notifications when is executed but this didn't happen. I read in documentation that I have to register notifications for the scheduled task. I've set the notifications in the scheduled task but only the notification of the scheduled task is fired. Other notifications of the single workspaces executed by the main workspace aren't fired. How can I fire each signle notifications in the scheduled job? Thank

Hi all, Is there a way to export an automation, i.e. port it -in my case- from a Development Server setup to a UAT setup? Thanks, Klaas

Hello Partners, We have new articles utilizing the new automations functionality in FME Server. There is still more content that is being created. Additionally, automations will be included in the FME Server Authoring 2019 training course, which will be happening June 3rd. Stay tuned! Run a Workspace in Response to Incoming Email Run a Workspace When Data Arrives in a Directory Job Orchestration with Automations

Hello all. I require some guidance and clarification. I need to develop an application that would automatically translate input data to another output format, e.g., test.dgn into test.shp I have installed FMEServer and uploaded my workspace which does the work. I have managed to upload an input file from my pc to my uploaded workspace in the FMEServer by using your javascript demo application. However, my issue is that in reality my input files will be located in the Microsoft Azure Storage, and the workspace in FMEServer should be automatically triggered to run the process when it gets a call from my application with input link or when it sees that a new file where uploaded in Azure storage. I have tested my workspace by manualy pasting in the file shared access link (URL link) from Azure blob container as an input value, and the workspace ran successfully. I have read a bunch of articles about directories watch, and HTTPCaller, and as I am very new in the field, I got very confused.

Hi, I am working in a production environment with FME Desktop and server of 2016 build 16717. And I have a problem receiving the Topic message on the production server. If I use a parameterFetcher I try to dereference the FME_TOPIC_MESSAGE, I get an error: undefined macro "FME_TOPIC_MESSAGE" dereferenced in file. When I do the same on my test machine everything works. I if I log every parameter on the Server I see no FME_TOPIC* parameters in my log. I have created a directory watch pubisher which publishes topic to this "example_topic", and a subscription workspace to run when this topic is triggered. When I test the topic either by placing a file on the watched directory, or "TOPICS/test topic" the workspace fires, but it does not receive a FME_TOPIC_MESSAGE. Anyone who knows what I'm doing wrong?

I have notifications set up. When a user gets a notification email it has a url link to view/download the job log. The user is presented with a login screen. They login, but the download results for the log are empty. What permissions are needed to actually download the log file?

Thanks everyone in advance about helping me sort this out. I have a topic set up on FME server and have an outside system posting a simple JSON to it. I then have a subscription that is subscribed to that topic with a workspace associated to it. I can see that it is receiving the JSON in: Resources>System>Temp>Subscriptions When I published this workspace to the server, I subscribed it to the topic and set: Parameter to Get Topic Message: "Source JSON (JavaScript Object Notation) File or URL. I used the JSON downloaded from the temp folder to create the workspace. At this point I can see the job starting each time the JSON is posted to the topic, but it is not getting the data to the writer. Am I missing a parameter that needs to push the JSON from the topic to the reader correctly?

Howdy, In FME Server I have a Notification Subscription that send an email on job failure, I am wondering if there is a simple way to have the emial include the following: Insert text with the name of the schedule that initiated the job Attach the translation log to the email notification or even better would be to just insert the text of any error messages. From searching the resources I found good info on the Email Subscriber and email keywords but nothing specifically addressing my questions. I did find a solution attaching a log file with a datadownload job but no info related to subscription email. Thank you for the assistance! Currently my email message template looks like this: FME transformation job {id} failed. Workspace: {workspace} Repository: {repository} Request Keyword: {requestKeyword} Time Requested: {timeRequested} Time Started: {timeStarted} Time Finished: {timeFinished} Click here for more details: http://fme:8080/fmeserver/#/job/{id}/summary Log URL: {logUrl} Log Fu

Hi FME's World! I'm trying to read emails from Outlook or GMail with my FME Desktop. I found out that it would be possible in Python, would you sugegest to use the PythonCaller or PythonCreator? I found some Python code but FME runs indefinitly at "Emptying factory pipeline". import email, getpass, imaplib, os detach_dir = '.' # directory where to save attachments (default: current) user = raw_input("email") pwd = getpass.getpass("pwd") # connecting to the gmail imap server m = imaplib.IMAP4_SSL("imap.gmail.com") m.login(user,pwd) m.select("[Gmail]/All Mail") # here you a can choose a mail box like INBOX instead # use m.list() to get all the mailboxes resp, items = m.search(None, "ALL") # you could filter using the IMAP rules here (check http://www.example-code.com/csharp/imap-search-critera.asp) items = items[0].split() # getting the mails id for emailid in items: resp, data = m.fetch(emailid, "(RFC822)") # fetching the mail, "`(RFC822)`" means "get the whole stuff", but you can ask f

I have a schedule that runs fine using a wildcard to find the source files. Rather than running the workspace every 10 minutes I would like to set up a directory watch (or similar) to trigger the workspace to run. When creating the subscription I get this error: Unexpected value "$(a)/ServiceOrders/FME/NotificationDefectsExport*.csv" for parameter "value," expected list The issue appears to be using a wildcard in the source file of a subscription. I have tried with both UNC source path and by setting up a resource in FME Server. Permissions are not an issue as the workspace runs fine on a schedule.

I have an email in Outlook (Exchange) and hope that it is possible to read the emails with FME Desktop. Does anyone now how to do that? Regards, Morten Friis

Hi, I have a workspace that performs a few tasks and then sends myself an email reporting the results. One email goes to my internal (corporate) email and it's cc'd to an external one (garbage yahoo account) I use for testing. I recently added another stream to the workspace and also want an email report for that one. However, I can't get it to send the external message. The second Emailer is duplicated from the original with only a change to the body text. Emailer 1 still sends both. Emailer 2 sends the internal version but not the external. How can it work in one case and not the other from the same workspace? Thanks Notes: I have also tried using a non duplicated Emailer and swapping the To: with the CC.

Hi there! When I update a Destination File Copy Folder from a Workbench and I publish it to FME Server, the changes aren't made into the Notifications/Subscriptions. (green arrow) Is it normal? Is it just me? In any case, it's anoying, I've got to do it manually. I have FME Server 2017.1 Thanks