FME Flow

Hi,I attempting to write to an existing table which contains polygons based in Postgres database. I have selected truncate existing table. I get following error:Error was 'ERROR: null value in column "objectid" violates not-null constraint The object ID seems to be an issue only when attempting remove existing data and add new data. When creating a new table, this is not a issue.  

I am wanting to automate PDF's to be downloaded on a weekly or fortnightly basis. The url changes slightly each week/fortnight: 'https://www.admiralty.co.uk/WeeklyNMs/Year%20-%202021/05wknm21_week05_2021.pdf " for example the '05wknm21_week05_2021' would change to '06wknm21_week06_2021' and so on. There is usually only 1 or 2 numbers in the urls that will change each week going up by a factor of 1. Is there a way I can automate these changes? Note I had a different example here but that link had a redirect URL which solved the problem for that particular URL but unfortunately it was not the same for the link above. Thanks in advance for any help.

Hello everybody... I'm trying to find a way to delimit a preservation area within the parcels of my allotment. The area to be preserved has always to be 30% of the parcels area, also it has to be on the bottom side of the parcel. I tryied to had draw it on the pic above. Is there any transformer that could fill a the polygon within a given percentage, or create another polygon wich the área corresponds to the a percentage of the lot?

Hi all, Hope you are well. I have recently created a FME workbench which gathers all the information and updates every 15 minutes via FME Server. This then writes directly to a PostGres Database. I have got this part working and have successfully published the data to ArcGIS enterprise. The issue I am facing is how does ArcGIS enterprise update the data every 15 minutes when the Postgres database gets updated without me having to publish it manually every time? Is there a possibility for FME to do this?  The output currently is in a map service.    

At this moment we have a working arcgis pro python environment working on FME Server (2020.2) and Desktop on a Virtual Machine. We've setup the python interpreter using the command prompt lines specified at https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Using-Python-with-FME_Server.htm and set the PYTHONHOME variable with he custom python environement.  However, when using FME desktop on the VM and changing the python interpreter to a different python environment (mainly for testing), the FME server also seems to change its custom python interpreter to the one used within the desktop application.  When researching the information on python interpreters ( https://community.safe.com/s/article/choosing-a-different-python-interpreter-installati ), for FME Desktop there is the the following note: "NOTE: This option controls FME as a whole, and not just the current workspace. Therefore, all FME processes will use this alternative version of Python, until you reve

Our Gallery Apps on FME Server don't show a custom image as icon, but leave the space blank instead. In previous versions of FME Server this was not the case. Our installation is FME Server 2020.2, build 20787, win64.Any ideas on how to solve this issue?

I am attempting to hide external user content in FME server (FME Server 2020.0.2.1, Build 20238 - linux-x64) deployed to Openshift using the safe provided helm charts and docker images (With some minor modifications).  I have updated the docker images to apply the same change as described in the linked article by updating the relevent confd template. I have verified the file `/usr/local/tomcat/webapps/fmeserver/WEB-INF/conf$ file propertiesFile.properties` in the web container of the core pod is updated./usr/local/tomcat/webapps/fmeserver/WEB-INF/conf$ grep EXTERNAL_CONTENT propertiesFile.properties  # HIDE_EXTERNAL_CONTENT - Disable all external content from being displayed in the WebUI HIDE_EXTERNAL_CONTENT=trueThis appears to be the correct file based on the document and I cannot find any other references to this term but I am not seeing any change to the WebUI and the links to safe.com are still available. Does anyone have any idea what the issue might be? 

I have set up a sensor to send UDP messages to FME Cloud via a GSM modem and it works great as a trigger, but the message that arrives is nonsense.  I believe everything is sent as bytes through the serial port so I have no idea whether its possible to format it before sending or the problem is how FME Cloud is receiving the data. 

The default and non-overwritable company proxy setting on our FME server machines has not been working consistently against external data services in our 2019.2.1 FME server. I was glad it started to work consistently 4 weeks ago with our FME server 2020.1.3 upgrade in which we explicitly set the Proxy to a proxy IP address/Port inside the FME server. However, it stopped working since a week ago. The FME server error message shows the server is using the default company proxy setting again. Should the FME server proxy setting overwrite the server machine's proxy setting?

I have a Desktop Workbench 2019, it works perfect when ran from the desktop. However, FME Server 2019 fails to write to the SDE Geodatabase. In the FeatureWriter transformer, for the Connection File, I have the following syntax which works fine on Desktop: \\\\SERVER\\fmeservershare\\resources\\data\\Configuration\\SDE_Connection.sde Maybe the syntax to read it from FME server should be something like this??$(FME_SHAREDRESOURCE_DATA)\\Configuration\\SDE_Connection.sde I published the workbench to FME Server with the Connection file as: $(FME_SHAREDRESOURCE_DATA)\\Configuration\\SDE_Connection.sde but when I run it on FME Server, it doesn't write anything and no errors are giving in the log. It stops in line 107 and just hangs there. Is my Connection File syntax wrong? 107 Transactions are being used by the Geodatabase Writer  Thank you.

Hello, We are running FME Server 2020.1.0.1 and are trying to connect it to our AD to allow users to login and run automations. We keep getting the below error and we are not sure what to try next.Unable to establish connection to directory server (91)Port: 636Connection Type: SSLAuthentication Type: Basic

Is it possible to retrieve the advanced information from Automations (like 'Queued Job Expiry Time' and 'Running Job Expiry Time') from the FME Server API?I would like to automatically check if these options are used for all my automations.

Is it possible to format an Excel file with FME to create drop-down lists (function data validation in Excel)? I have multiple excel files that need multiple drop-down lists and a supplier excel sheet with all values. In total there are hundreds of drop-down lists that need to be created, therefore wonder if there could be some solution available with FME.

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 dire

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. 

I have set up static IP adress for the cloud instance as I assume this is necessary?

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.

I am struggling with an Express with a Distributed Engine installation, see this article: https://community.safe.com/s/article/separate-engine-installation. All steps in the documentation and this article have been followed carefully. The core machine is running as it should, and so is the FME Engine service on the distributed engine machine. Unfortunately, the Distributed Engine Host does not appear in the Hosts list under Licensing & Engines/Engines page in the WebUI. What could possibly be wrong?

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, I followed this guide: Sending email, Part 1: Setting up a topic and an email subscriber (safe.com) And we know our port is 25. I followed the guides and troubleshooting, turned the Allow Less Secure apps ON in gmail as well. But still I get stuck on the Creating the email subscription step, the validate gets this error:SSL error occurred. Ensure connection security and port are correct. Unrecognized SSL message, plaintext connection? I am on company server via VPN so I cannot access the services.msc or make changes to the firewall. Any idea if I entered something wrong? 

Hi everyone, I'm running FME Server 2020.2.1 Build 20806 on a Linux Debian 10.6 host. I need to run a workspace that writes to a sqlite database previously uploaded in the shared resource data directory, but the workspace fails complaining it can't write to a read-only database. I discovered that when I upload a file in the shared resource data directory through the Web User Interface, the owner user:group of the file is root:root and not fmeserver:fmeserver as expected. After changing the ownership of the file (the sqlite database in this case) to fmeserver:fmeserver using the shell of the operating system, the workspace runs fine. This is obviously a workaround which is not suitable for a production environment with several users. Can anyone help me solving this issue? Thanks!

I have published a workspace to FME Server enabling the Data Streaming service with parameter Include Writers in Stream set to the output from a File copy writer. This output is a PDF file and the MIME type parameter of the writer is set to application/pdf.When executing the workspace in FME Server, the PDF opens as text inside the browser. Shouldn't it open as a PDF file inside the browser or show the dialogue to save it? This is what shows in the browser:To give some context to the problem, the workspace builds an html that is transformed to PDF using the HTML2PDFConvertor. To be able to stream the HTML2PDFConvertor output (the PDF file), I've set the output PDF path to the FME Server temp directory and I've used a File copy writer to 'move' the PDF file again to FME Server temp directory. This works as a kind of hack to be able to stream the PDF. 

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

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' rightsConfirmed domain account is running the FME Server servicesConfirmed domain account as full access to the UNC pathConfirmed 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