Integration

I'm migrating records from one Salesforce org to another org using FME Form. But during the translation, some of my records are passed and some are failed. Though some of the records are failed to migrate, it shows a successful translation message in translation log window. I know the number of records that are passed and failed. But the problem I'm dealing is occurring while sending email. I want to send the number of total records, passed records, failed records and along with the failed records it should also show the error that why those records failed to migrate. How can I show this information in email?

Hi allDoes anyone have experience in using Google Earth Engine (GEE) in FME Desktop (I work with FME 2023.2)? I would like to access some remote sensing data in FME, process it and combine it with other data.I found out that the transformer “PythonCaller” could be used to integrate some Python code in FME. GEE advice to use the package ee/geemap for formulating requests to the engine. Accessing the GEE via Jupyter Notebook does work, but I’d rather integrate the processing in FME.Thanks for any help/advices.

 I have a workflow that takes a file in input , does a conversion , then outputs the converted file.I published this workflow to fme flow . and i want to use it to in my simple node js project : simply : the user clicks on “Choose an input File” , and chooses the file he wants to convert ; and after clicking on “Convert and download result!” , his file should get uploaded to my fme server , the workflow gets applied on it , and the resulted file gets downloaded to the users computer.  And I don’t know how to apply the workflow on the file that the user chooses , because the filepath of the reader dataset is static , and can be changed only manually in the fme flow web

Hi,I have to carry out a project to produce and publish an interactive web map to disseminate data on traffic osbstructions and works in progress in Montreal.However, the data used can be downloaded in CSV format from the City of Montreal's open data portal, but also accessible via the API provided by the City's open data team, the link is as follows:https://donnees.montreal.ca/dataset/info-travaux/resource/cc41b532-f12d-40fb-9f55-eb58c9a2b12bWhat is the complete workflow process to retrieve data from CKAN Web Service API using FME Form?Attached is my incomplete workbench of my workflow that I tested using HttpCaller Transformer to test connection.Please provide me with some possible solutions.Regards, 

Hi, I've been working with a web connection to Sharepoint Online, created with help from this article:How to Create a SharePoint Web Connection for FME Form [Single Tenant]For SharepointOnlineConnector. It works for a time, but after a day or two there is a problem with refreshing my access token. This was the error message today:Updating access token for 'Microsoft SharePoint Online'Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad RequestPython Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.If I reauthenticate my web connection It works again for a time.Any ideas what the problem may be?

Hi FME-community,I want to use the HTTPCaller to upload two JSON-files in one multipart PUT request. Just using two HTTPCallers separately works fine with Headers defining content-type application/json and Upload Data to Specify Upload Body with the JSON-content in the Upload Body. However, in future it will be convenient to also add different file-types in one PUT. Therefore I have the following Multipart PUT request:As you can see in the example I leave the Content Type blank, because there's no option "multipart/mixed", but consequently it interprets the upload body as plain text resulting in a binary file uploaded. Without success I also tried to set Upload data to multipart/form data with two separate String Uploads which results in the following error: "This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you

Adding an ArcSDE Geodb reader, FME Workbench 2019.1 throws: "GEODATABASE_SDE reader: An unknown exception occurred" followed by "Workspace generation failed. Parameter file was C:\\Users\\marsale\\AppData\\Local\\Temp\\FME_1700594969892_10740." It worked a couple months ago and my oracle account is fine (i can see and select the tables in Oracle, the error occurs when its trying to create the workspace).

Is there a way to setup a trigger in FME to send an email anytime a new record is added to the Feature Layer. I have an AGOL hosted Public Facing Application where the residents can add points and fill out some information. I would like to get an email every time a new record is added by the user. 

I have a workspace that uploads zipped folder to a Dropbox folder. I have established the Dropbox web connection, token is also retrieved and authenticated. When I run - I get translation is successful with no errors. But I dont see the folder on my Dropbox account. What am I missing ? Any suggestion is highly appreciated. Thank you so much

Hi,  I am attempting to ingest Microsoft Project Online data into our on-prem MMSQL Warehouse. I have found that the only (?) way to get the api is via SharePoint: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData The URL Above lists endpoints for all the sub-components ie: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData/[en-US]/Projects I am after recommendations for "simple" one-to-one replication of this data structure in SQL via FME.  The SharpointOnline component allows access to the document as an HTML file which I would have to manually parse and furthermore the site (via FME) only lists 5 Items in a document library

How should we use existing database connections inside of an FME Package?Will the python api have functions which will enable the use of these connections? I was working on something where I wanted to connect to a database and I realised that it’s not possible to use the existing database connection - this is probably a good thing but kind of killed my project. Then it got me wondering if this will/should ever be a possibility? seems like exposing that kind of access to third parties poses a pretty big security risk. You could pretty well hide some malicious code which just scrapes all the host, username and password data and post it to some server. I guess direct database access via a package might never be allowed - at least not until there is the same kind of security which Oauth offers for authentication. 

Is it possible to access GEE API from FME (and for example run a script using Sentinel data to extract vector data for edge of recently burnt area)Does anyone have experience in doing this?Thanks.

Hello everyone,Is it possible to connect to a cloud (PIX4Dcloud) where point clouds are stored, so we can download for exemple files automaticly with FME ? Thank you

I have the following scenario.We use FME Form to gather public data. The data gathered should be written into a MSSQL database. Since we mainly work with ArcGIS Pro, and other ESRI products our MSSQL  server has an SDE extension on it.As long as I work in Form I can easily use sde connection files to access the databases. However, publishing a workspace utilizing an sde connection will result in errors since we do not have an ArcGIS Pro running on the same machine as our FME Server.Until now I was using the reader and writer ‘ESRI ArcGIS Portal Feature Service’ but this isslow, and requires published feature services in the ArcGIS Enterprise portal.I got our IT to open the firewall for direct access of FME Server to the MSSQL server and installed the latest msoledb drivers after getting the following error:Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provide

Hey Everyone, I hope this message finds you well. I'm currently working on a project involving data center integration, and I've run into a bit of a snag. I'm using FME to handle spatial data transformations, and I'm encountering challenges in seamlessly integrating data from various sources within our data center. Specifically, I'm dealing with issues related to data format conversions, data quality assurance, and ensuring smooth interoperability between different systems within the data center. I believe some of you may have experience with similar scenarios or could provide valuable insights. Here are a few points I'm struggling with:Data Format Conversions: How do you efficiently handle conversions between different data formats within the context of a data center using FME?Quality Assurance: What are your best practices for ensuring data quality as it moves through various stages of th

I have an error connecting to older version of ArcGIS Portal (10.9.1) from latest version of FME Form/Flow (2023.2.1 b23774). Does anyone know how to resolve this issue? 2024-01-23 20:15:03|  0.5| 0.1|ERROR |Python Exception <SSLError>: HTTPSConnectionPool(host='<portalURL>', port=443): Max retries exceeded with url: /portal/sharing/rest/generateToken (Caused by SSLError(SSLError(1, '[SSL: UNSAFE_LEGACY_RENEGOTIATION_DISABLED] unsafe legacy renegotiation disabled (_ssl.c:1006)')))2024-01-23 20:15:03|  0.5| 0.0|ERROR |An error has occurred. Check the logfile above for details

To previously set up our license server we followed the majority of info in this link:https://community.safe.com/s/article/create-fme-license-server The documentation show that the redhat-lsb-core package is required for the license server. The problem is the new Linux 2023 is based on Fedora and CentOS, whereas the previous Linux 2 box was based off the REHL 7, so it's now unavailable. Curious what others who may be required to upgrade their machines to Linux 2023 may have done or are planning on doing?

I'm using the FTP Caller Transformer to download a file geodatabase from an sFTP site. I feel like I've tweaked every possible parameter. My data keeps ending up rejected with an "Error in the SSH Layer." Any ideas?

Sorry, this isn't FME-related, but given the experience here, it would be dumb not to ask. Our team currently employs VertiGIS Studio (formerly Latitude Geographics) Geocortex Essentials as our corporate web GIS viewer. We utilize this to configure project-specific web GIS viewers via a user interface, requiring no coding. It consumes our web services from Portal for ArcGIS, with authorization managed using groups in Portal. Additionally, we can leverage workflows, custom-made user interfaces used in combination with FME Server. The problem is that the product is being discontinued. VertiGIS Studio offers a new web viewer built from scratch, based on ESRI web maps instead of web services. Our issue with web maps is that they are difficult to maintain. Adding layers to viewers during project work is challenging, and there's no option for grouping layers in a folder structure. So we are seeking alternatives. I'm curious to know wha

I have a workbench I'm updating from 2021.2 to 2022.1. It reads in features and then following the general flow from this article (https://community.safe.com/s/article/how-do-i-write-updates-to-an-existing-arcgis-onlin) does the change detection and then updates the portal service. In 2022.1 I'm running into an error though where when it starts writing the updates I get" ArcGIS Portal Feature Service Writer: Could not find a layer/table matching feature type 'ParcelTest_DBO_DelTest'". I've used the GUI to select the item from the portal, the only difference I can see is the '_' instead of the '.' in the service name. I can't change this though. In 2021.2 the writer has the '.' in the name. I can click on the url of the ArcGIS Portal Feature Service Writer: Requesting metadata for Feature Service at '

I don't have experience in Bentley or AutoCAD. We aren't an engineering company, so we won't be using much of the 3D capabilities. I think for most jobs, we use CAD to generate reports, and plats, mostly 2D drawing. So, I would like to ask for some guru advice. 1) What do you like and not like about each software when it comes to integration with FME. 2) If you have to pick one, what would you choose and why? Thank you!

Hi,I wonder if it's possible to download all the tiles from a WMS web server. I would like to cache them as a Geopackage Tiles for exemple or XYZ Tile layers.  Do you know if this is possible ? Thanks,Arnaud

Hallo, I am looking for a way to access Sharpoint list attachments in FME.I have tried using FME Reader Microsoft SharePoint List or Transformer SharePoint Online Connector, but the attachments are not retrievable.Are there any plans for FME to add support for attachments?Can anyone suggest another way to download attachments in FME? I would be very grateful for any help with this task.

I am working on a project to get my home city into Minecraft (Harrisburg, PA - pop. 50,000). I have a QGIS file of about 40 layers consisting of:2D shapefiles (polylines & polygons - to describe materials or edges)2D shapefile of buildings (heights based on a BLDGHEIGHT value in the attribute table)3D DEM (using this for the Ground Level of the Minecraft World) I have seen what could be done in converting GIS to Minecraft from some of the how-to links. I have two concerns, what data cleanup should I be concerned with and would there be anyone out there who might be able to help guide me through the process this next month? This project started in 2013 as an idea to take a 2D image and "loft" a Minecraft world from the pixels (World Painter). This worked well and created a flat creative world. Unfortunately the area was only one neighborhood in the city, approximately an 1/8 of the city. The image allo

I want to upload a file to sftp location and we have only private key for connecting. I tried using system caller by keeping this command inside that :sftp -i <private_key_path> -b - user@hostname <<< 'put <path_file_to_upload> <path_remotepath_where_to_upload>'and also tried with this command also:sftp -o -i <privatekey_path> user@hostname but none of the commands worked in fme server, it is showing as failed to execute the command, Am I giving the correct commands or could anyone help me out on how to connect to sftp using private key in fme server configured on linux env.