A space to discuss FME Flow
Recently active
I'v been succesfull in loading additional python site-packages on FME flow hosted.Now I have a site-package that needs a newer verion of numpy then the one that's allready in the standard installation.Can I upgrade numpy on the FME Flow hosted environment?
I have a service that runs on a schedule that regularly fails to connect to a hosted ArcGIS Online service. If I manually resubmit the same failed service it succeeds. I have other scheduled services that use the same AGOL connection without any problems. I have tried recreating the scheduled task, republishing the service, and re-authenticating the connection. Does anyone have any ideas why this scheduled service is failing but succeeds when manually running and other scheduled services using the same AGOL connection succeed?
Hello all, I have had an automation running for the better part of a year and I set it up to send me emails (post topic on failure). I needed to revise this and set up 2 separate automations to separate the types of jobs, daily vs every 30 minutes. Prior to setting up the new automations, I stopped the original and deleted it. It is still sending me emails now. I also made sure I replaced every instance where it was tied to a schedule, and I deleted the topic itself, and I am still getting emails. It has been stopped and deleted for over a month now and I am searching for a solution to end the emails. Any help or suggestion would be appreciated. Example below, it is sending failure notifications from over a month ago:{"automation.id":"cac0de02-77e3-4c13-b330-dba1175dfaf7","workspace":"CMPT CG Future Allocation VW.fmw","timeRequested":"Wed-31-May-2023 05:00:00 PM","requestKeyword":"SERVER_SCHEDULER","ti
Error executing SQL command ('TRUNCATE TABLE "quali"."wa_hydrant"'): 'ERROR: permission denied for table wa_hydrant'Error truncating table 'quali.wa_hydrant'. Assuming table exists and attempting to appendError executing SQL command ('COPY "quali"."wa_hydrant" ("gis_id", "gesellschaft_bd", "gemeinde", "standortwerk", "_rbe", "_fehler_nr", "_fehler", "_pruefdatum", "_fme_prozess", "_temptext1", "_temptext2", "_temptext3", "_temptext4", "_temptext5", "_temptext6", "_temp_num1", "_temp_num2", "_temp_num3", "_temp_num4", "_temp_num5", "_temp_num6", "fstatus_id", "geom_pt") FROM STDIN USING DELIMITERS ':' WITH NULL AS 'NULL''): 'ERROR: current transaction is aborted, command
We (rarely) get a glut of job submissions to some of our FME Server queues (Running on FME Cloud). These glut of jobs usually come from someone who has automated a bunch of submissions (we're totally fine with that). We want these jobs to be processed, but at the same time we still want to be able to handle other user requests in a timely manner. I created an idea over here which would help me: https://community.safe.com/s/bridea/a0rDm000001Sf7kIAC/option-to-move-submitted-queued-jobs-to-new-queue It outlines the scenario in more details. Just looking for tips or idea on how to work around this. The service in question is essentially just a clip and snip but depending on what the user wants the request can take anywhere between 10 seconds and an hour or so to process.
I'm just wondering if there's an impact on performance having multiple automations running constantly. They are triggered by a schedule within the automation to run once per day.
Hi All We've recently deployed FME 2021.2.0.1 Desktop (64-bit) to a new server environment shared by many users.After some time we realized that this installation has somehow changed File association for JPG to associate with FME Data Inspector. This is unintended and very undesirable. What's the best way to reset the JPG File association to whichever program it was prior to the FME Desktop install? If I change this setting manually through Windows options (assuming I get local administrator rights), does this get propagated to all user profiles? Also we are running a Citrix server environment. Any help is much appreciatedThanks!
When I install a new version of Desktop on my (Windows) machine, all my file extension defaults are reset. (I have to choose which software I want to open a .xlsx file when selected in File Explorer, again.) I think this is recent behavior? Do I miss a setting during installation? Can it be made undone?
Hi, I have a spreadsheet in sharepoint where one of the sheets needs to be updated weekly, from another sheet that is in another file in sharepoint. I tried using the sharepoint connector but it makes me lose cell color, formulas and other formatting. The ideal would be just to delete a sheet inside a sharepoint file and insert a new sheet, without harming the other sheets. How can FME help me with this?
I created an FME Server role that provides read-only access to view FME workspaces published there (i.e. - Workspace Viewer). I would also like to add read-only access to view items under Schedules but only see options for Full Access or None for a role's permisssions. is there a way to provide read-only acccess to Schedules? We are currrently running FME Server 2020.1.2.1 (Build 20624).
I have a flow source Movie Role ActorM1 R1 A1,A2M1 R2 A1,A3M2 R1 A2 and I need to switch to the vue Movie R1 R2M1 A1,A2 A1,A3M2 A2how is it possible, I tried AttributePivoter but didn't find a way to switch rows to columns. The Roles list is not known before, so it should take all unique roles as columns.
Hello, Currently, I'm having a delay and I don't know how to fix. The FME server time is not the current time, instead it is the time UTC that is displayed. How can I change it?
Trying to install on my mac, silicon version. Have uninstalled one version completely. New version still has the same bug. When loading a package, going to database connections etc: Failed to install web service '/Users/xxx/Library/Caches/Safe Software/FME/Packages/23319-macosx-aarch64/PackageFiles/safe-lab.genai/web_services/OpenAI.xml'. Reason: Unable to read from file '/Users/xxx/Library/Caches/Safe Software/FME/fme_publicKey.fmeks', No such file or directory (Code 2) I checked for the folder and it doesnt exist.
fme server 2022.2 login page not loading properly on web browser.I have included a couple of attachments for more clarity.I have followed the online suggestions and no luck.Any ideas/suggestions welcome.thanks.
Hello - I have an FME automation, that downloads the attachments from an email trigger using SMTP protocol. There is slight issue, each time when the job is triggered via received email, FME Server is creating a folder under my desired location, instead of overwriting the file with the same name email attachment. any thoughts or suggestions ? I have attached screenshot of the automation configuration and also target location where FME Server is creating multiple folders. The file name EPS_DATA.csv
Brand new to FME server, and i've only really worked with outgoing REST API calls before in general. What i have is a workspace that is parsing emails and picking out specific data that is then packaged based on conditions and sends out an REST POST request to another platform. The packaged data going out becomes an actionable item in the other platform, and i want to have users be able to click a button to respond to the action item and have that come back to FME Server (i assume it'd be a post request) where i can write to a table some related data. i'm not sure how to "listen" for incoming REST requests? i've read through the v3 documentation and it is pretty likely that i missed it, but i'd love it if someone could help me out?
To provide high availability of data, client is having two data servers. We need to check for existing database connection failure in FME Work flow and pull data from backup data server. If there is no failure at 1st connection, then no need to proceed for backup server. Is there any possibility for this king of approach in FME?
I am having problems trying to do the above. Documentation for the token request is here: https://bitbucket.org/ikegps/office-api/src/master/ It is requiring a application/x-www-form-urlencoded content-type. I have setup the HTTPCaller like this: The 'mulitpart' upload also includes the additional fields from their doc for 'audience', 'username' and 'password'. I used the example Curl command in Windows list on their docs and was able to get a token. I am getting a '401 error' running this in a workspace. Any help on this or suggestions would be greatly appreciated. I have been fighting with it for a while, and have searched for examples/help here, but haven't gotten it to work.
Good afternoon i am new to FME at this sort of level and interested in digitizing a number of pdf site plans to shp format. I have read a few i must say articles here in the forum, referencing various transformers and i am bit confused i must say. Ideally i would want to georeference the plans and then have them digitised. Is there a way that this could be streamlined by FME?Thank you in advance for your help
Hi guys. I have an issue with FME Form Licensing Assistant. It looks all weird. It started with the Betas of FME Form 2023. FME 2022 works as it should. I am using Windows 11 in Dark Mode if that might be an issue. Thanks a ton for any help or suggestions.
Hello "Safers" Actually the graph.microsoft.com API seems "broken" (SSL Issue).I can re-authenticate all of my current Web Connections as well as successfully testing the "Managed Services"Not sure what has changed here.FME Server has been configured to use HTTPS, as usual, making use of our enterprise cert. The certificate is fine.Everything was working as intended prior to the upgrade. Error message:`SharepointOnlineConnector: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/sites/molevalleydc.sharepoint.com,3824d824-4277-4293-8bf0-37e0242f40e6,6473e0ea-d0df-4cb7-8269-1cbb5e31d620 (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1002)')))'' ThanksS
Hello, I need to migrate roles and the users linked to it.Does FME Flow automaticaly include the users if I add the role or do I have to import them seperately?
Hi I am trying to add a engine via a remote engine service FME Flow 23 but the credentials always seem to be rejected, tried with superadmin etc no luck. Any ideas? Many ThanksOliver
Hey everyone, I have an API that hold historical data. I would need to retrieve all the data for the past year. I am using a HTTP Caller to retrieve data. The API only allows for 30 days for one location to be retrieved at once.I have 36 locations, and about 15 months worth of data to retrieve. I already have workbench that retrieve one month for one location worth of data.How can I create a loop that would go through all these locations and date list automatically?
I've built an generic automation that encompasses some business logic. I've isolated the variable input as global parameters, and duplicating the automation and only changing the global parameters to adopt them for another dataset. Is there a way to initiate an automation and setting these parameters ? The automation server app does not provide for this as-is (2022.2.2), so I'm curious as to whether there are other ways to accomplish it ?Cheers.