Integration

I have been trying to automate uploading/deleting from a Google Drive Shared file using a GoogleDriveConnector, which I thought was recently changed to support shared drives. The first issue is that the files do no automatically overwrite if they have the same name, they create duplicates, whereas if you upload manually the files will become versioned. To get around this, I assumed I would be able to identify and delete the older file first before uploading the new file, however when trying to delete the older file I get:"2021-10-20 15:19:39| 21.6| 0.0|INFORM|Delete_existing_file: Object with id "File ID" does not exist on Google Drive. Nothing to delete". (I have removed the ID for this post). I have permissions to delete from the drive, and I have created the shareable link manually as a check to confirm that the file ID is correct and exists. I can successfully upload new files to the said folder,

Hi All, I would like to know thatis there any possible way to trigger mail while running my workbench in FME Desktop/ Forms if it is facing a error?.FYI : I am using FME Desktop 2020.1.1 version. Thanks in advance!

HiI am using the HTTPCaller to get the information from Issues page in Autodesk Construction Cloud (ACC).The AuthorizationToken has been created and looks good but once I am using HTTPCaller to get information form issues page,  the result created in “_response_body” is not in the json format so consequently I am not able to use JSON extractor Is there any step that I am missing?P.S:In “HTTPCaller4”in requested URL I used “https://developer.api.autodesk.com/docs/issues/projects/$(PID)/issues”*I have predefined $(PID) in User Parameter. In Header I used “Authorization Token” created in 1st stepThanks

The completions API models were deprecated at the beginning of 2024. The current version of the transformer does not have model options like gpt-3.5-turbo. Will there be more options for models in the near future from FME's side?   

Hello allI’m trying to achieve the above, so far I’m struggling on how to find out the KML reader ‘placemark name’ property, to write it as a DWG layer name.Could anyone point me out on how to do that? Thanks

Unable to connect to ArcGIS Online services through FME Form. This issue began at approximately 4pm AEST on 5th June 24. No connection issues were apparent earlier in the day. Can anyone suggest a solution to this? I’m unable to add a new connection or use an existing.Wondering if this is an FME or ESRI issue?Updating access token for 'BCT Enterprise'JSON Error: Access to this application has been blocked. Please contact your administrator to allow access to this app.Unable to update access token for 'BCT Enterprise'Python Exception <FMEWSException>: Type: 4, Number: 1, Message: Failed to get authorization query string.An error has occurred. Check the logfile above for detailsMany thanksFME version 2023.2.2.0

hello i am trying to write something in excel format but the result are like in the picture, how to write the data from the start of each rowplease suggest 

Dear all,I need to add multiple REVIT/IFC files into an ArcGIS WebScene. I am trying to determine the most efficient way to achieve this.From my understanding, the process should involve the following steps:Read multiple REVIT/IFC files from a given folder. Transform these files into Multipatch and save them into a Geodatabase. Publish the layers.Do you think it is feasible to obtain such a result?Many thanks.  PS: I found this post which contains a similar request: 

***UPDATE - PROBLEM RESOLVED***This is a strange one!For this example, I have 2 features. I put a counter to get 0 and 1 for the value. Then I’m updating my JSON with the _count value. The output from the JSONUpdater has SERIALNUM = 1 for both features. If I change the sort, it will set both to 0. I’m passing in the same feature in the Document and Update input ports. I’m not sure the distinction between the two input ports.  

Hi, I am trying to add Inspection attachments to the Inspections using FME Form.I have excel spreadsheet that have EntityUID, InspectionTemplateId, Observations Questions and Answers, and image links1 - to image link4(attachments)Each Inspection must have entity attach to it based on the EntityUID. Image as JPG extension located on the repository an each image have EntityUID in the image name.How can I attach image to the Inspection- that is first questionSecond question is that some Entities have up to 4 images related to them, that reference based on the different parameter (Image_link1, image_link2,image_link3, and image_link4)  It is easy to create inspection, add entity, and populate Observations questions and answers but I am struggling to attach the images. 

I have Here Maps Data in XML format. I want to extract the data to CSV in FME. If I am directly adding XML there are issues in reading the file. Currently I am using an XML Flattener tool built using python. Is there any option in FME to do this?

I'm trying to write new (Insert) features to a Utility Network feature service using the Portal writer and it doesn't appear to be preserving global ids despite my parameter setting to do so. The issue appears to exist on all layers in the service. I've tried connecting to Portal via 'Web Connection' and with 'Generate Token' parameters and see the same result. I am connecting to a branch version and not DEFAULT. I can confirm that Globals are not coming over as expected on the version.I've got some Fiddler screengrabs as well if that's helpful.Thanks all.

Hi All, https://support.safe.com/hc/en-us/articles/25407773286157-FME-CIM-XML-for-Electric-Utilities The link mentioned above offers valuable insights about the process of transferring data into XML format specifically designed for CIM electric utilities.  Upon constant verification, "61970cim18v02_61968cim14v00" is mentioned in cim.xsd file. This seem to indicate that the CIM version is of version 14 (version 0)? I am seeking assistance to determine the specific CIM version associated with the link provided. Understanding the appropriate CIM version is crucial for ensuring compatibility and seamless integration within the current system. Your guidance on this matter would be greatly appreciated, as it will streamline the process of identifying and implementing the correct CIM version, thereby enhancing the overall functionality and efficiency of the system. Thank you in advance for your support and assistance in

Hello all, I am trying to use “reader” AGO data to provide a “Writer” GDB which contain the attachment photos I have been advised to use this process:In the “reader” I set up o include attachment:and selected the attributes: Set up “AttributExposer” In “RasterReplacer” I am not usre what should be done: 

I have a snowflake connection that works perfectly on desktop, and most of the time hangs when I push it to FME server. My connection to snowflake is a service account with a username and password. I am using the SQL executer transformer to run a query against a table of shipping data in snowflake. I have also tried the workflow with the Snowflake Non-Spatial Reader, and the feature reader.Running it on desktop is no problem. Just about any query I throw at Snowflake returns data, even up to 700k+ rows. When I publish to server, the job almost always hangs up right at the point where the query is submitted. I say almost because when I shrink the query down to just 1 or 2 records returned, the job will return that data. Based on this information, I am assuming my connection between my FME server and the Snowflake instance is good. Any thoughts as to what could be causing the jobs to hang?  FME desktop version 2022.2.1FME server version 2022.2.1

HiIn production environment i have FME Server  that has a SAML Configuration and it works fineI created an APP in FME.This app need to be under authentication and i set the users in the configuration. The problem is that this APP is included in sharepoint page using IFRAME. The users are authenticated in Sharepoint but when they  access to the page that contains the FME App, the app shows the login page. If the users click on SAML Auth button, the IFRAME try to show the provider's sign-in page that is not setted to be included in IFRAME and so it doesnt’ work.So to solve this problem, i tried to create a token and tried to call the app in IFRAME passing the token in the query string. But it doesn’t work.So the question is: there is a way to display an APP using token instead of user credential?

It is possible to the saved zipped file from the ShapeFile feature wrtiter NOT split (generate) multiple zip files. The workbence/job is running on FmeCloud.  

We use the SDK in C++. When migrating our code to FME 2024, I realized that several files related to pointcloud cannot be found in the new SDK any more.The only file I can find for pointclouds is pointcloud_fwd.h. But when using an IFMEPointCloud pointer, the declaration cannot be found. The files that I used in earlier versions of FME do not exist any more (ipointcloud.h, ipointcloudblock.h, ...)Where can I find these declarations now? Is there an example for C++, how the point data of a pointcloud feature can be extracted with the SDK of FME 2024? 

Hello,I’m working with the ArcGIS Open data portal and I want to publish all my layers within a geodatabase to my AGOL folder as new Feature Services. Since there are multiple items(layers), I’m looking for a batch process. I’ve came across several transformers but none of them seems like working for me. I would appreciate your suggestion on transformer selection for this.Thank you.Rajesh

 Hi Everyone,I’m working on an integration workflow between an editable polygon feature class in an enterprise geodatabase and an asset tracking the same asset in an Asset Management System (which will be where the majority of the info is populated). We cannot write directly to the Asset Management System database, and need to write/get to it via API.The GIS feature class has a few attributes that are not in the layer in the Asset Management System and vice versa therefore it is not a straightforward cloning. That being said, I will have the attributes/fields required in the GIS Feature layer already so that new fields/attributes themselves don’t need to be created in the FC. However, we want to set up an integration as the diagram shows above.So the lifecycle of the asset will start in GIS, whereby a user will tra

Hello,I have a situation that I cannot seem to understand.It seems that fme.exe is locking/using a file that I try to rename in the Startup Script, although that file is not used at all in the workspace (the processing where the file gets created/saved/renamed is happening in the startup script).The logs don’t mention this file/folder as being used at all.i don’t have the file open in any other app, closed everything else except FME.This is happening on windows.  Logs say:2024-05-24 11:32:20|  18.7| 18.5|INFORM|15160 fme.exe is using C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx2024-05-24 11:32:20|  19.1|  0.0|ERROR |Python Exception <PermissionError>: [WinError 32] The process cannot access the file because it is being used by another process: ‘C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx’ The interesting thig is that on another machine with the exac

 Hi, I’m using a change detector to see if any updates has been made from the new data, to the data  on ArcGIS Online. Previously I had the error about missing ObjectID on updated records, but I fixed that using a feature joiner from this Guide: How do I write updates to an existing ArcGIS Online feature service? – FME Support Center (safe.com) I got it working on points, lines and polygons, however if I want to update tables, I get the above error. By a search I found that this error has also been found in Survey123: 

I think I may have run into unexpected behaviour. I’m trying to pass some text in a user parameter via a workspace runner but it’s stripping out the quotes within the text when I try to retrieve it.The text I am trying to pass through to a child workspace:"Building_Use" = 'Residential'In the log of the workspace runner it gets passed along in the command line arguments as:--SQL_WHERE_Clause {${="Building_Use" = 'Residential'=}}'and the child workspace receives it correctly when initiating the workbench as:``--SQL_WHERE_Clause' `"Building_Use" = 'Residential''.But when this is retrieved via a parameter fetcher or attribute creator it drops the quotes in the child workspace:Building_Use = 'Residential'However if I run the child workspace on its own (not via the workspace runner) it retrieves the text correctly. I can workaround this by replacing “ with another character before and then replacing it within the child-

I would like to know the name of the localization language file for FME FORM 2024. I know that the localization language file for FME Desktop 2020 is named transformers-localized.* (for example, transformers-localized.zh). I want to know if the new version has changed the name of this file.

Hi everyone, I have an Excel file containing SQL WHERE clauses used as Definition Queries in an ArcGIS project and I want to use the same SQL WHERE clauses in my workspace to create subsets of my data. Is there a way to "convert" these SQL clauses to Tester test clauses? I managed to do a lot with some StringReplacers, to the point where regular (att1= 'this') and list clauses (att2 IN ('this', 'that')) are covered, but I also have a lot of LIKE clauses (att3 LIKE 'th%') and I can't seem to get these translated to Tester's Begins With .  I know about the capabilities of the FeatureReader's Constraints, but in my analysis I need both the entire dataset I am querying AND the SQL-clause-derived-subset. And I want to prevent reading in the data twice, since that slows down my workspace a lot. Thanks in advance everyone!