Automation

Hello,I wrote an ETL where read an microsoft azure sql database spatial (JDBC) table using the feature writer. However, I can't update because when writing the selected format is grey.  How to fix this issue? ThanksARmel

Hello, from an aerial view, is there a solution to extract or identify the geometry of roofs, roads or any other shape.

Dear community, I found this video (https://www.youtube.com/watch?v=-dbRKOj-1zw) and this forum (https://community.safe.com/s/question/0D54Q000080h9MY/drafting-of-gmails-automatically) about the possibility to create Gmail drafts. However, I am not sure if this is still possible? Please let me know how I could achieve this.Thank you!

Is it possible to extract the following information about a workbench being run through an automation (all automations will be triggered by schedule): Workbench NameAll READER dataset namesscheduled run time & periodAll WRITER dataset type, and output filename/location I am interested in writing a workbench which will use an HTTPCaller to read all automations tagged with a specific tag, and then take each of those automations and extract those specific attributes above into a csv. 

I have been trying to get wehook trigger output keys to work, but haven't had any luck. I have an automation with  a webhook trigger, and an output key configured:The JSON I am posting to the webhook is:{    "email":"user@example.com",    "data":"this is a test"}The Log action is set to log:{webhook.email}{message}The automation log is as follows:1 2023-01-09T19:32:45Z | 410115 : (Automations) Assembling automation "test"...2 2023-01-09T19:32:45Z | 410156 : (Automations) Creating webhook trigger...3 2023-01-09T19:32:45Z | 410109 : (Automations) Creating link from trigger...4 2023-01-09T19:32:45Z | 410136 : (Automations) Updating event keys for component...5 2023-01-09T19:32:45Z | 410150 : (Automati

When running FME Desktop and set the Scripting to Esri Python 3.6+ or other Esri Python version and adding an PythonCaller or PythonCreator the workbench fails and gives an error. This bug seems to be related with Windows removing all Icons form the Start Menu. Reinstalling ArcGIS Pro seems to fix the problem.    

I need to merge individual 1km2 LIDAR tiles in .asc format to form a single layer. I have a table (.xlsx) which lists the .asc files, their folder location and the site reference they are associated to. I have read the table into FME and using a FeatureReader and can open all the .asc files and by using the RasterMosaicker, and Reprojector I can combine the the .asc files and output the merged LiDAR.  This works fine for a single site. Of course when I add further sites to the table I end up with all the LiDAR merged into a single feature. How can I set up FME to iterate through the table merging the necessary tiles and produce a single LiDAR output before repeating the process for the remaining sites?  

We've been using automations to run jobs, and then report the status back to Teams using an HTTP Request to call a Teams webhook. This was working fine in 2021.1, but since upgrading to 2022.2 the teams message now shows the job variable names, and not the values. The issue seems to occur somewhere within the Adaptive Card format - as I can use a very simple JSON object in the HTTP body of the HTTP Caller (eg. { "text": "{job.id}" } )- but it seems as soon as the variable call is enclosed in square brackets - it won't populate the value. Am I making some silly reference mistake?(Attached HTTP Caller body.)

As the title implies, I have a workspace where two different workflows have to write to the same CSV but different sheets. How do I go about doing that? I've attempted to use fme_feature_type as CSV File Name but that resulted into 2 separate CSV files as depicted by the image attached  

I create an FME workspace with ArcGis Online. I have a new project so I made a copy of FME Workspace and I want to change Feature Services to use a new project. How do I redirect or change Feature Service to new project?

Issue: During the Christmas break, one of our automations failed regularly due to an account issue. I did not get any notifications and only upon my return and a manual review did I see this issue. Question#1 : What is the correct method for tracking automation failures. Can the system send email notifications with the associated error message. If so, how do I do this ( note: my knowledge in the product are still basic ) Question#2 : We are scanning workspace logs from the logs folder , but where are the automation logs ? Many thanks in advance for any assistanceOliver @ EGW 

I want to build an app that will prompt the user to select a file.the file is on our network. I have set a resource for the root folder and set this resource as a parameter in my workbench. (It would be nice if the user could not change this) The first required prompt (parameter will allow the user to select 1 subfolder of the resource folder. Then i have specific values for 2 other subfolders that will be supplied and added to the root and the first selection. The second prompt will be a single file in the now complete folder structure. This folder will then be supplied to the output where the file will be written with the same name + datestamp.I have what i think are the parameters built in my workbench but don't get the path built correctly.I am trying to buld the path like this.$(FME_SHAREDRESOURCE_DATA)$(SELECT_PROJECT_ROOT_FOLDER)\\PROJECT_DATA\\WORKING\\$(SELECT_PROJECT_FILE)any ideas on how to accomplish this?

I am using shapefiles to create multple attributes for dwg OD table output.I have a dwg that does not have a feature for this output. (I am writing this to use in fme server). I use a tester to divert the shapefile feature out of the output stream. but the feature gets created in the dwg regardless.I tried putting a NoFeatureTester to try to keep this from happening. HOW does this feature get through the tester?in the screenshot. the feature that is in the NoFeatureTester ends up in the dwg.

Hey Community, I am trying to map generators/power plants and substations for Texas(ERCOT) region in US. I have got one datasets from HIFLD and the other that I have already(my org). I have created a workbench that preps the data and compares the two data for generators. Also, there are a lot of substations that have got 'Unknown' names and is not possible to compare the two. Is there a possibility where I can run the workbench and it compares the two datasets with satellite imagery(Bing Aerial, OSM, Earth street) and provide a validation result.

FME Server 2021.2.6 We have an automation which downloads attachments from an email to an UCN path. When the automation is triggered, it logs the following error:2022-11-28T16:43:49+01:00 | 809004 : \\uncpath\image002.png : Failed to download email attachment. Download location "{1}" is not available and could not find an appropriate alternate location.But when we look in this specific folder, we see that the attachment is downloaded successfully.Questions we have are:Do we try something which is not supported?Can we solve the error log?

How do I upload/post PDF files to Survey 123 Portal? I tried using both the put & post options in HTTPCaller transformer as well as FeatureWriter. It appears to work as I did not encounter an error message but the files don't get actually written in the portal. I guess it could be the HTTPCaller settings but I'm at a lost how to set it. Please advise what I'm doing wrong , or any sample FME script with httpcaller settings would be greatly appreciated. Thanks in heaps! Wilfredo  

Hi team,with the deprecation of Basic Authentication coming up in October later this year (Deprecation of Basic authentication in Exchange Online | Microsoft Docs),it's been suggested we move across to OAUTH for accessing emails via FME Server Automations. I'm a little stuck on how we can do this? There doesn't seem to be any OAUTHcapability within the templates? Any suggestions on how we can achieve this?

I have a workspace that needs to run when there is a new file in a SharePoint folder. Is it possible to set up an automation that would work similar to Network or Resource Directory?

Hello! I am trying to schedule a workspace to run 17 markets. Workspace is the same for all 17 markets. After the first market ends, I want it to start the second one. I know workspace runner on FME desktop that kicks off markets one by one.The scheduling of the two markets on the FME server worked well for me. Due to the fact that I have 17 markets to run, I was wondering if there was a better way to do this. I would appreciate any advice you can provide.

Hi, I have an automation workflow that is executed by dropping a file in a target directory. If the file is a ZIP archive (filter action), a hosted FME workbench should be triggered. The workbench expects a path specification (path of the ZIP file) as user parameter. However, in the configuration interface of the automation action I don't have a dropdown to access an output key of the trigger ({file.path}). Is there any configuration to be done in the workbench to handle output keys?

Hi all.2022.2 introduces triggering an automation from a webapp, in addition to triggering automations in numerous ways already defined.One such triggering is "FME Server Topic notified".Can I create a workspace, uploading it to FME Server, and have this emit such a (custom) topic, in effect triggering the automation to run ?If so, I could potentially create a webapp for such a workspace, and achieve the same functionality, couldn't I ?Alas, there are no immidiate transformers that allows such emission, but workspace FME Server Parameters include FME_TOPIC and FME_TOPIC_MESSAGE. Can they be used for this, and if so, how ?Or must I resort to using the REST interface ??

I have points and lines, I want to snap the lines to the points, both edges, ends, and sides. I tried using the snapper and also tried using the anchored snapper, but I still don't get to snap some. I have used intersection transformer, it does the major part of the snapping but creates new points at any intersection without a point. I really would love to do this snapping based on relationship (attribute)

What I've done so far ... I've selected a .fgb from a location (the location will stay the same, however, there will be multiple .gdbs that come and go over time) I added a reader, Schema (Any Format), filtered for *.gdb.I added a FeatureReader, with a WHERE clause to only look for ... @Value(fme_feature_type_name) LIKE '%M_CSCL%' ...However, the way I've set up the FeatureReader doesn't work in it's current state.Any hints/improvements/better ways to achieve this would be appreciated, see the attached workspace.thanksJeremy   

Hi, is there an alternate solution available from safe to replace the basic authentication for IMAP and SMTP? Since Microsoft will stop supporting this solution soon

We have two FME server 2021.2.6 instances running (one Test and one Production environment) and on both environments every job/workspace fails to run with the following error. A Python interpreter could not be loaded. Please ensure the workspace `Python Compatibility` is set to an available Python version On one of the environments an automation runs a workspace every 5 minutes. In the logging we can see that the jobs began failing at exactly midnight 11-25-2022. The runs before midnight logged no errors, the run at midnight and all runs after that failed. Does anybody have any suggestions what may have caused this, and how to solve this?