Automation

Hi All, I have a workbench built in FME Desktop 2019.1 which I am planning on deploying to FME Server 2019.1. This workbench does incremental updates to records in a SQL Server database on the basis of updates delivered in XML payloads. The workbench consists of an XML reader, various transformers to transform XML data into the required format, and a SQLExecutor to run an 'upsert' in SQL Server (we elected not to use a SQL Server Writer). XML payloads are delivered to a directory on a file share of some kind (probably FTP, maybe SMB - this is an implementation detail, I can map the directory as a network drive of some kind if required). We do not need to handle any kind of geospatial data. What I am trying to do is determine a way to trigger the workbench in FME Server by a file being dropped into a directory, and then, once the workbench has run, move the file to another archive directory. I can see that triggering an Automation in FME Server on the basis of a change in a directory is

I have successfully used FME Data Express with csv files being uploaded directly from the users iOS mobile device. However I now need to have the users upload a .htm file instead of csv for the same type of workflow. It works fine on the browser using a FME Server app to upload a htm, however when using a htm table reader in the FME Data Express app, where the green + sign should be to add a file, I get [Unsupported] Source Dataset. I would like to know what file formats are supported for direct mobile device upload on iOS for FME Data Express, so I can try to develop some sort of workaround.

x = [‘ab’, ‘cd’] print(len(list(map(list, x)))) Source: Python programming tutorial

I would like to know how to set an emailer to a workspace from FME Workbench to send emails to a group of recipients once there is a status change.

The error is 'Unauthorized request by user due to lack of proper permissions' All other API-request seems to work fine. I checked all the permissions, and i have all permissions. Anyone an idea why this is not working. Screenshot Using FME Server build 20787)

Hi FME team, I have a workflow on FME Server scheduled every day @ 8am. The workflow reads a HTML Table which is updated every day @ 7am. I am using a simple HTML Table reader, where the URL is always the same, as is the 'Tables/Lists to read'. If I run the workspace with FME Desktop, it runs fine. If I then publish this workspace to FME Server and trigger it to run, it runs fine. However, if I set the workspace to run on a schedule, i.e the next day, the workspace fails and I get the following error message (I have removed the actual URL for sensitivity): 185 HTML Table Reader: Could not open HTML file 'https://exampleURL/Example.php' for reading. '<class 'OSError'>': 'Invalid argument'. Notes: my organisation requires each URL called by FME Server to be 'whitelisted'. The URL in question has been whitelisted and I can access it via the browser from the server on which it runs. The previous data source was a CSV download link and this returned the same error message when following the

I am having issues with a Directory Watcher UNC Path. I was able to get it running in our Test environment. However, in the Production environment, I keep getting this error in the Automation Log: 801013 : Could not retrieve file listing. I've checked the following during my troubleshooting: Confirmed domain account has 'log-on as service' rights Confirmed domain account is running the FME Server services Confirmed domain account as full access to the UNC path Confirmed that I can connect and add UNC path and was able to add it as a resource to FME server and that I see files showing up in FME Server UI. (Resources>Directory) I'm running FME Server 2020.0.1 (Build 20218 - win64). I am able to validate the directory when I configure the 'Directory Watch' trigger in the Automation. I am just trying to read a UNC path with simple .txt files. Am I missing something in my troubleshooting? Thanks in advance. -Mark

We have installed both 32 and 64 bit version of fme on same machine. We are running a bat file that has the following struncture: fme python script.py which runs fine and is using the fme 64bit version(that was the first one installed on the computer). Afterwards we have installed the 32 bit version on same machine and we are tring to use a bat file that has the same structure as the one mentioned above but running the 32 bit fme version. Has anyone an ideea about how can this be done? Thanks :)

Hello I'm hoping that someone could shed some lights on this issue which I'm experiencing and not related specifically to FME 2020.2 So basically if I make a change in a Reader / Writer, i.e. changing the path of the destination then (Re)/Publish the workspace, I can see the changes made in FME Web UI but in Automations, the settings remain unchanged. That is problematic. I changed the DFS path from "MVGIS02-Data" to "GIS-Data". FME Server WebUI Automations Log Similar behaviour occurs when a Writer's connection is changed in Desktop then Published, FME Server does not pick up the change. So I'm having to replace the existing Writer for it to work. Thanks Sameer

Every single time I try to log into the FME server I get a failed login. The second time it succeeds. Every time. Unless i leave chrome open. Then I can log out and log back in without a problem. Using LDAP. No other issues with LDAP anywhere. This is always the message: "LDAPException(resultCode=85 (timeout), errorMessage='A client-side timeout was encountered while waiting 10002ms for a response to simple bind request with message ID 2 ....." A time out message and authentication failed. I did a little reading on it and found a bunch of inconsistent java mumbo jumbo. Anyone have ideas on how to fix this? Its super annoying. Thanks!!

To start out, I am new to FME and to webhooks (or web mapping/web development in general). I am trying to set up a webhook to send an email when a user updates or creates a feature in an ArcGIS Online feature service. I have been able to successfully set up webhooks with Survey123 using the process in this article. Webhooks seem to be a relatively new feature in AGOL. I have only found this Esri article, and it was just from August of this year. The problem I'm having is that I am able to send the webhook to webhook.site and Integromat (as is described in the Esri article linked above), but when I the webhook sends the payload to the webhook trigger in FME server, the log file doesn't give me the JSON that I get from webhook.site and Integromat, I get the following string of characters: cGF5bG9hZD1bDQogIHsNCiAgICAibmFtZSIgOiAiU3VydmV5MTIzVGVzdFdlYmhvb2siLCANCiAgICAibGF5ZXJJZCIgOiAwLCANCiAgICAib3JnSWQiIDogInBBMm5FVm5CNnRxdXhnT1ciLCANCiAgICAic2VydmljZU5hbWUiIDogInN1cnZleTEyM19mZTBiNjk1Yz

We are trying to use FME Server/Desktop to achieve the following: 1. Intercept Survey123 submissions using webhooks - this works well. 2. Conditionally send an email containing submitted data - this works as well. 3. Include any photos attached to the survey submission - this part we can't get to work. Most submissions do not include photos. We are novices with FME. Surely someone has had this requirement before. If so, can you please share your solution?

Why can a workspace started in automation not find a path, when the workspace itself run by hand works fine. I have a workspace that is working fine and runs data from a certain path as shown. So the reader is configured correctly. And when starting the workflow the file path is correct. Now when the same workspace is triggered by the automation flow it can't find the file anymore, because a backslash has been dropped from the path? And this continues for all the readers? How is this possible? I tried to change the monitored path of the automation flow but the end result is the same? The path is highlighted in yellow, and after this a backslash should be present but now it inserts the filename directly. When I open the workspace mentioned in the automation, the path is the one with thhe missing backslash at the end of the path name. When I repelace all the entrys here with the correct path with backslash it is working. So when changing a workspace, should you remove all workspaces in a

I have a workspace that takes one published parameter to run through. I want to set up a FME server weekly automation, and each weekly run includes running the workspace multiple times, each with a different parameter value. The parameter values are stored in a text file. Seems to be simple? But I can't think of a good way to do this. Still new to the FME server automation. I am using FME 2019.2.1, both desktop and server.

Hello, I've tried to set up everything that FME Knowledge offers. Still I can't seem to configure my gmail account to trigger an automation on incoming mail. I've tried configuring 2-step verification and/or sign in from less secure app. Message in log of automation is: Failed to connect to email server. Please check IMAP settings and insure IMAP is enabled for the email account. Error message: null IMAP settings are good and IMAP is enabled for my account. Has anyone had a similar problem that you managed to solve? I'm using FME Server 2019.

Hello FME Community! In my company, we have several workspaces which run on a regular interval. Some are simple schedules and most are inside automations also triggered by schedules. The goal is to inform specific people inside my company via email if a workspace failes to run on the server. Up to now, we have implemented topics and subscriptions to those topics that people get emails. However, since the email, triggered from a topic, does not contain any information about the workspace which failed inside the automation, I am not sure if this is the way to go. I also thought about sending emails directly from the automations. But since it does not offer any templates, I have to fill the email content manually (considering that multiple people receive the email, it requires quite some manual effort). Could you offer me some guidance, or best practice how to implement a notification service that is suitable for our need? Thanks, Johanna

Hello, I would like to run a workbench via Python. The workflow within the script is always the same. Only the input and output directories change. For this purpose I have written a function and call it accordingly. def fme_workbench(workbench, argument): FME_command = '"C:\Program Files\\FME\\fme.exe" ' + workbench + ' ' + argument result = subprocess.Popen(FME_command) result.wait() argument = '--Name_Veg4m_umhuellend "' + str(kachelnummer) + '_veg4m_hull" --Name_Veg4m_Loecher "' + str(kachelnummer) + '_veg4m_holes" --SourceDataset_ESRISHAPE_5 "' + os.path.join(output_dir, str(Mission), 'Lidar_RAW', str(kachelnummer), 'Output\\*.shp') + '" --FEATURE_TYPES "" DestDataset_ESRISHAPE "' + os.path.join(output_dir, str(Mission), 'Lidar_RAW', str(kachelnummer), 'Output') + '"' fme_workbench(os.path.join(script_dir, 'EB_0_Aufbereitung_klassierte_Vegetation.fmw'), argument) the following variables are dynamic and can change: kachelnummer Mission calling the Workbench from Python works without

Hello, FME Server 2019.2 build 19801 running with FME Cloud I think that these two settings for a Trigger in an Automation configuration should be equivalent, but the left setting - Schedule Type "Basic" didn't trigger any action actually, whereas the right setting - "Repeat On Interval" is working as expected. Am I missing something? Or it was a defect on the "Basic" type and has been fixed already in a newer version?

Hi, I have troubles setting up an Emailer in FME Desktop 2019. For testing purposes I set up a simple workspace with just a creator linked to an Emailer to send a test mail from my email account to my other email account. I tried different settings for the Encryption and the port number, as documented on my mail providers site but the workspace always produces a fatal error. I'm guessing it is because I'm running the ws inside my companies VPN which would be a problem as my floating FME license only works inside the VPN. In my logfile I get following error messages: The below feature caused the translation to be terminated Emailer_<Rejected> (TeeFactory): Emailer_<Rejected>: Termination Message: 'Emailer output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' Emailer_<Rejected>: Termination Message: 'Emailer output a <Rejected> feature. To continue translation w

Hi Everyone, I have a Json file that i want to join to a shapefile. The json file has one row of data and i want this to be added to every row in the shapefile (the shapefile has other fields that will be updated by another shapefile). The fields I want from the JSON file are already in this shapefile. Thanks in advance and hope that makes sense to you all

We have to access .jxl files from trimble connect, Till now we are using FTPCaller in the reader dataset where .jxl were stored in the FTP site now we have to access these files direcly from trible connect cloud. Could somebody provide your views to resolve this issue.

I'm new to FME. And I have a shapefile. The *.shp is footprint of a building. I want to give an extrusion value to it manually. And then write it as a CityGML file(*.gml). So, briefly, I want to make a very simple prism with an extruded shapefile. Could you please give me an information about this?

Hi, I have a problem to trigger a command via System Caller on the FME Server. In the log appears the following: It triggers an .exe with Parameters, which are reference to FME-Server Resource Directory. If we start the process local via FME Workbench, it works without troubles and do the job. If we trigger the same directly on the Server via cmd.exe or batch-file it works as well without problems. For any kind of help I would be grateful

So imap is not available on the company email. SMTP is also not allowed. I thought an FME Server app would work, but the company phone does not have VPN. So what can I do to kick off the workflow? Because it expects some values which needs to be provided by the user. Would appreciate any ideas.

This has me stumped. I have a Workflow that has a Parameter --SourceDataset_FFS, which has got 3 Filename Path strings in it corresponding to 3 input FFS files. The Parameter itself is of a Type: "Filename (Multiple)" with a Default value: "C:\\ArcGIS\\Water Script Working\\DEMFFS\\ELEV_DEM_1.ffs","C:\\ArcGIS\\Water Script Working\\DEMFFS\\ELEV_DEM_2.ffs","C:\\ArcGIS\\Water Script Working\\DEMFFS\\ELEV_DEM_3.ffs" Now, running the FMW in WorkBench runs fine, and it passes to FME.exe the Parameter properly formatted by splitting the file names up at the comma delimiter by adding enclosing "" and adding spaces as such: --SourceDataset_FFS """"""C:\\ArcGIS\\Water Script Working\\DEMFFS\\ELEV_DEM_1.ffs"" ""C:\\ArcGIS\\Water Script Working\\DEMFFS\\ELEV_DEM_2.ffs"" ""C:\\ArcGIS\\Water Script Working\\DEMFFS\\ELEV_DEM_3.ffs"""""" However, when I Batch this in another Workflow using WorkspaceRunner, it fails to run the same FMW because it complains that the file paths in --SourceDataset_FFS do