Automation

 I want to instantly receive a notification email when a new record has been added to a table that is in Oracle

Can I send by email the new record added to a table that is in a database? and each time there is a new record send me an email

Bonjour à tous,  Dans une gdb Arcmap 10.2.2, contenant plusieurs classe d'entité (canalisations, coffrets,...), je souhaiterai corriger la topologie entre les canalisations (polyligne). Ils doivent être impérativement attachés et sans discontinuité. J'ai tenté un anchored snapper mais sans succès. Je dois avoir un problème dans le paramétrage.  J'en appel donc à votre aide.  Merci d'avance.

Hi, I am trying to send an email using an email subscriber, which in some cases seem to work successfully. However, not all attempts to send mail are succesfull, sometimes the workspace job succeeds and the topic fires that should trigger the email subscriber, however, no mail is sent and not even the logfile email.log gets written. Anybody any clues? Is there no flushing mechanism on the email.log? The subscriber.log only states that there is a new client accepted on port 7072.

Hello There I did set the publication, email SMTP , its working when we do the test Topic button but when we send email to user@{hostname}.com , the topic monitoring show nothing https://qsnapnet.com/snaps/tn8ozd3p1bj 

Hi, I would like to ask you some tools and techniques for automation and visualization of transport services rotation (eg. Bus,train, flight connection ) , implement some kind of tool which converts the data into graphs automatically .The initial data is available in excel format and the final output will be expected in graphics(JPG,PNG.....) with map in the background .Pleas anyone to suggest me some techniques Thanks

Hello,I have just installed a new FME server on a new VM. I am able to send out emails using telnet on the VM using SMTP. However when I try from the FME server software I am getting errors in the log file about the local email address -Mon-16-Sep-2019 12:45:47.877 PM ERROR pool-2-thread-5 801027 : An exception occurred. can't determine local email address Mon-16-Sep-2019 12:45:47.877 PM ERROR pool-2-thread-5 801009 : Failed to send email. javax.mail.MessagingException: can't determine local email address  at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1154)  at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:735)  at javax.mail.Transport.send0(Transport.java:191)  at javax.mail.Transport.send(Transport.java:120)  at COM.safe.fmeserver.notification.plugin.FMESubscriberEmailNotifier.get(FMESubscriberEmailNotifier.java:39)  at COM.safe.fmeserver.notification.p

I have I directory watch on FME Server that triggers a workspace to move a file that inserts into the directory watch-folder, to the FME-server with a SystemCaller transformer.It works fine when using a file that dosen´t cointain any special characters, however when I have a file with å, ä or ö the SystemCaller fails according to the log-file. In the log file, a file that spells "åäö.pdf" have the name "åäö.pdf" in the log file.However the path to the file also contain å, ä and ö, but spells correctly in the logfile. I´ve tried and wright the filename-attribute that generates from the JSONFlattener to a txt-file from the same workspace, and it also spells correctly.I´ve tried to add "@echo off && chcp 1252 &&" infront och the copy-command in the SystemCaller, but it dosen´t seem to work for the filename. So what must be the problem is that when the SystemCaller runs on FME Server and try to find &quo

Is there any way to configure automations or publications such that a workspace can be triggered via email from one of several senders? Both publications and automations can filter by email subject, and the Filter action in automations can then filter emails based on one sender, but there appears to be no way to filter based on a list of senders ("from either Person A or Person B"). Is this in fact the case?Details, if they help: we'd like to enable a certain work group of five people to be able to trigger a specific workspace via email. While they can and will also use a specific subject line, I'd like to be able to ensure that no one outside the work group can trigger that same workspace even if they know the "key" subject line.Is there a way to achieve this, short of using five separate Filter actions per automation? Which appears work, but isn't very elegant, and will get hard to maintain as/if a given work group develops more worksp

I am using a Survey123 survey to trigger a topic on server when a new survey submission is received. The topic, in turn, triggers a workspace which takes in the subscriber_content (containing the survey submission content) and parses it out via some JSON extractors to grab specific survey fields and process them a particular way. What I want is for the same topic to trigger an email in server, sending along the processed subscriber_content. Currently, I am not able to use an emailer inside the workspace to do this -- needs to be a part of the automation itself. How can I make this happen?Example/detail: The workspace processes the subscriber_content to extract attributes of buildingID, floorName, and roomName. I want the automation to also send an email containing the buildingID, floorName, and roomName in a readable format -- ie, not the raw JSON subscriber_content

Hi everbody, Following this tutorial I've set up everything in FME Server to receive and process certain emails, and everthing works really fine. The only missing detail is to save the received and processed email to the file system (*.msg preferred). Is there any possibility to do this? By the way, I have to use IMAP, and for the next few days (or weeks?) we'll still be using FME 2017.1 before updating to FME 2019.1Any hint is appreciated ;-)

Hi Team,I used fmeservernotifier transformerMy content of the email looks something like this... region1 : 100 featuresregion2 : 200 featuresregion3 : 300 features All the features counts are in attributes. And email should be formatted like above.if all text strings are in one row/line it comes out good. But I need multi line texts.I mean each line shows region and its count. But when I pass this to "subscriber_content", error happens and all my email subject line and content becomes bla bla....if it is simple one line text string, then it comes out good. And if i try to insert newline char[\\n] like below...(region 1 : @Value(count1) \\n region 2 : @Value(count2) \\n region 3 : @Value(count3) \\n ) My email structure collapses. How can I achieve multi line text email message. Thanks  below string

Hi, I have a Condition Statement within AttributeManager that splits coordinate values. The value for seconds (_lat{2} and _long{2}) have different length e.g. 23° 05' 30.95420" N or 23° 06' 47.954" N  When I use the above it always returns the value but with E or N. Any thoughts on how can I get only coordinates seconds?  Regards

Hey there - I've inherited a bunch of FME Server workspaces that utilize topics ad subscriptions. But I'm still a bit hazy on how topics and subscriptions are set up. I've updated the list of email address under "Edit Subscription/Protocol Settings" but the emails still go to a different group of people? Is there some admin email group that gets all notifications and where the emails in my case might be coming from?

Hello, I noticed that notifications (emails) from the Community site have stopped since some point within past few days. Can you receive notifications according to the settings on your preference?

Hello,  If there is a FmeServerJobSubmitter transformer with options:Wait for Job to Complete = true Will it keep http connection untill job is done? 

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 inUtilities\\tomcat\\webapps\\fmeserver\\WEB-INF\\conf\\propertiesFile.propertiesThe 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 usin

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 servic

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'sI 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