Automation

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? Edit: Using FME Server 2022.1.1 - Build 22623-win64

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?

I'm looking to make a query which uses the spatial data in the planning brief to search cadastre, duct, duct_route and SL layers. So that I can change each planning layer can become searchable and have an output. We are currently working with MapInfo.

I have a workspace published on FME Server that works lika a self-service where users can upload a shapefile, upload a pdf file and give information via user parameters.The Esri Shapefile reader has workflow option "Single Merged Feature Type"Running the workspace on FME Server works fine. I have created a server app for users to run the workspace and running the server app does not work. Does anyone know what could be causing this? Thanks in advance! This worked without a problem on FME Server 2021.1Now we use: FME Server 2022.1.2 Build 22627

I am writing file geodatabases using templates. this causes all fc in the template to be written wheter there are features in the workbench or not. If i am writing the gdb in an automation the only method i can think of is to have a second wb that opens the gdb that was just written and test for features in each fc. but then there is the problem of delteing the entire talbe. the database deleter will only delete rows. the database updater works on features also (not tables)Any Ideas how to accomplish this?I guess i will have to go with the read the schema method. this machine is used for fme server as well as desktop and as such i do not have a single use license for arcpro. so i have no way of using arcpy that i can find. as for the reading the schema solution. @ebygomm​  i guess just using a gdb reader and connecting each fc to it's output? but what about domains?

It's been a while since I last used FME and now it's time to start working with automations  seriously. I need some help to get a quite simple one working though. I'm attempting to do the following: whenever an email from a certain email address and with a certain concept in the subject is received, the email subject and body must be checked and parsed to write a temporary json file that will be uploaded to a server via sftp overwriting the existing file. I already have: An email trigger with a Subject filter. A 'Sent from Address' filter action. A workspace action: AttributeManager and JSONTemplater transformers and a JSON writer get the important information from the subject and content of the email into a json file that is written to FME Server temp directory. An SFTP Directory external action: reads the json file from FME Server temp directory and writes it to a server. The problem is that we are waiting for imap access to be enabled on the email account so I cannot test the email 

I would like an email notification every time a completed workspacehad an error within the log. Is this possible and how do I set this up within our FME Server.

Can I read FFS file by python?

Hello, I created a dynamic workflow to load geopackages into as many tables of a PostGIS database From a SchemaScanner, I retrieve the source schemas then I build the names of the destination tables and I make some modifications to the data types. For example, boolean attributes are not recognized by FME because the values ​​are not conforming. So I would like to replace all non conforming values ​​of these attributes. In the schema part of the processing, I retrieved all the boolean attributes (in a list or a concatenated string). I would now like to use this as a parameter to define in the features part of the processing the attributes whose boolean values ​​must be corrected (StringReplacer for example). I could manually select these attributes but I would lose the interest of the dynamic workflow. I don't know how to do it automatically. Does anyone know how to do this?

I need to run rather extensive workspace to update database tables from an XML file. The update files can generated every day and are avaible for two months to past. When processing the worskpace I download these update XML and write them them. So far no problem.During the execution I need to check the continuity against a table in the database. So I would need to load up to 60 files read the header with date (1) and previous file information pass it to tester, process first file with all writes (2), write a row to database table with a header information about file processed (3) and take the next files to process from failed tester (4) and fetch them again to SQL executor.I'm not sure about the loop part as it seems there can´t be writers inside and I also miss attributes passed from feature reader. Not sure how to correctly arrange it. An idea is to pass it later to FME server and run every day, so no or just one file would be processed. But the workspace needs to be able to proc

I'm having an issue regarding the FME Automation triggering the automation when a new file is added to an FTP Directory and running a workspace that needs a parameter of a CAD File or Rivet File, but the Cad/Rivet Reader is showing an error which fails the workspace, I am using the file path in the FTP directory to read it as a parameter.

We have a simple automation that checks an S3 bucket every 30 seconds and triggers a workbench when a file is added to the bucket. It all seems to work fine, except I noticed today that although the automation was still running it was not triggering the workbench when new files were added to the bucket. Looking at the automation log I see...  Service Unavailable (Service: Amazon S3; Status Code: 503; Error Code: 503 Service Unavailable; Request ID: 4F1445BF8D4DF69F; S3 Extended Request ID: bNSlvkHBzAjPZYX7hSRdG86fwpdaYqp2WrrGNa0IpPm4Qk4XeLb9qRXDdUk5EkWY/NdK1PcNYahUZduRItZf4t9NeiHv1+A8juV+dCYgLfc=) It appears that there was an intermittent issue that caused the 503 error. When this happened the automation continued to run, but no longer worked correctly (new files were added to the S3 bucket, but the automation did not trigger the workbench). I added a notifier to the S3 Trigger in the automation so I can be notified of future failures, but wondering if there is another solution to reso

Hello,  I have a FME Server Automation with a Manual Trigger. This FME Server Automation is triggered via the FME Server REST API in a HTTP Caller. I would like to know if it is possible to set the Output key values (Manual or otherwise) of the Manual Trigger via the body parameter of the HTTP Caller.And if it is possible, what kind of body should you send?  I did find out you can set these in FME Server when you trigger the Automation in the Web UI(Start Automation -> Trigger) when the Manual Trigger parameter of the automation "Prompt for JSON on Trigger" is checked. Then you can set the values for the (Manual) Output Keys. This however can't be used in my process.  Thanks in advance,

Is there any way of returning information about all the workspaces that have been actioned when running a Dynamic Workspace within an automation?

Hello!I have workspace which takes shp files and write it down to dwg.So far so good, FME 101.The autocad contains manholes blocks with attributes, And in crowded places, where there are many manholes, everything is a terrible mess:Is there a way to do a visual arrangement using FME?Where the table of attributes hides another table, or is on a sewer line, move it to another nearby place.I have quite a bit of experience with work intergate Cad & FME,And here I don't even know how to begin to address it.I would love ideas for those who have!Thanks!I am attaching an example file.