Integration

Hi Team, Can we integrate FME flow and FME server with Azure Devops using pipelines?

Hello, I have been trying to figure out how to embed a website in ArcGis Online popups but could not get it to work.I have tried the method to have an attribute with the Iframe code as some suggested in earlier version it was interpreted correctly but it seems this is not the case anymore.I have found that there’s a way to embed video for example but nothing for integrating a website. So if you have any suggestion that would be great. Thanks.Thomas 

Hi,I would like to create a workbench that will allow the user to make unique slecection from Excel document by entering not only value but also the operator. Is that functionality available?Example  

Hi everyone,I have an SHP file related to some parcels. For each parcel, there is a corresponding folder and contract (with the same name). My goal is to create a workspace based on the ready SHP files (using a simple tester transformation). The SharePointOnlineConnector should then download the corresponding contract from SharePoint and place it in a local directory.My main challenge lies in how to locate each contract. Currently, I’ve set up the SharePointOnlineConnector to create a list from the directory. Then, I use another SharePointOnlineConnector to download the contracts. However, during the second SharePoint transformation, I encounter an error:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/[my_share_point_name].sharepoint.com,3a2333c0-9794-425a-9978-a2eb613fc15b,c38a05da-86b2-48bd-a5b5-e80371d96e57/drives/b!nqLU0gc2Y0OJ_TIlc0aqVX_zKy7OiIFPltGPSW8STP_RoqJOec4

Hi everyone,I'm working on a project where I need to process multiple IFC files and write the data to a PostgreSQL database using an FME workbench. I've written a Python script to automate this process, which includes getting IFC input from the user and executing the FME workbench. However, I'm encountering problems when passing multiple IFC files to the FME command line.Any ideas? Main Idea:Getting IFC Input from User: The script prompts the user to enter the path to a directory or a single IFC file. Running the FME Workbench: The script constructs and executes the FME command with the provided IFC file paths and other necessary parameters.I am using a PythonCreator at the start of my FME script to catch these arguments and read with FeatureReader. Currently, when I look at the FME log after I run the external Python script, I see that the paths are not parsed as parameters. 

I have a workbench that imports a lot of data into PostgreSQL (~90m records across 3 tables, 1 containing spatial data) and we've identified a possible need to vacuum the tables. The data is "cleansed" post-import via a SQLExecutor that deletes data, creates data if necessary. However, we're unable to vacuum analyze (Analyze is fine) the data once that occurs as it appears that the SQLExecutor wraps commands in a Transaction Block - which means we cannot Vacuum. Any ideas on how we can perform vacuum via the SQLExecutor or have another strategy we can utilise? I am unsure whether using the writer's post-write execution of SQL in a parameter is performed before or after the VacuumAnalyze option that FME provides. I've seen some information around setting Autocommit to on/off within the SQLExecutor but this does not work in the newer versions of PostgreSQL.  We are using an Azure managed database

Hello, I am a first-time poster on the FME forum. My goal is to read data stored in a plain view from a non-spatial Oracle database and then write it to an Oracle SDE geo_dbtable. The issue is that my Oracle Non-Spatial Reader slows down, taking more than 30 minutes to execute the SQL Statement when I include two comment fields that are long, 2000 characters. When I run the same query in SQL Developer, the result is back in a few seconds.   The log message that gets stuck on is:  ORACLE Reader: Executing SQL Statement `SELECT…<field names> to obtain features for feature type <Oracle View Name>If I uncheck the comment fields in the User Attributes tab the reader returns quickly, within a minute.  So I’m skeptical that it is caused by network distance.  Given these challenges, I need some guidance. I’ve tried using an Oracle NCLOB to hold the comments in the view, but the result remains sluggish. I'm eager to learn how to optimize my wo

I am trying to set up a TCPIP Receiver to read raw data from a specific port on another host machine. On the box I am authoring the workspace with I can use Windows PowerShell to ping that location and have another technician confirm with Wireshark that data is being sent through this port.  So in using the TCP\IP Receiver transformer I can ‘Successfully connect to host’ per the log but the translation immediately shuts down per the attached snip. Why is it doing this? It should be streaming data and to do so needs that transporter open. Thanks for any help.    

Hi All, I am trying to call a fmw file using bat file which will run on fme quick translator. Here for a testing i created a fmw file with “path” reader and changing the input value as user parameter which i newly added in workbench. I created a testing bat file to call that fmw file but i am facing “Undefined environment variable”.  I referred old case regarding and changed into ${variable} format but no change yet I’m facing the same. I attached workbench file and bat for your reference.I am using FME Desktop 2020.1.1.1 32bit version 

When adding a Geopackage Writer to the workspace and using the “Copy from Reader...” functionality to import a feature type definition (from a Geopackage reader), the geometry set on the Geopackage writer feature type is incorrect.Upon opening the newly added writer feature type, it doesn’t show any geometry. Opening it a second time then shows the Geometry as <All>, which is not a valid value for the Geopackage format. We’re currently investigating the issue and will be filing a bug report shortly to get this issue resolved. 

I would like to be able to update a Microsoft SharePoint term store and terms using FME. Has anyone done this using the httpcaller or any other method? Any advice would be greatly appreciated.

Hi,Is there a hidden Zoom limit which can be changed in the Geometry Parameter setings which prevents users to zoomin further than a specific level like (z21 in Google)? Or is this a “feature” of the Leaflet source code behind the this function? I can understand the limit for Google Maps but when using our own custom WMTS layer we shouuldn’t be stoped by this limit. And no  I cannot see any references to this in the online doco:  https://support.safe.com/hc/en-us/articles/25407744364941-Using-the-Geometry-ParameterCheers,Baris

I have a filegb that I want to append a value from an oracle non-spatial dataset where the address and postcode match. But keep getting the error “The SQL query contains an expression or a global parameter so cannot be evaluated without a feature. Please run translation instead.” Any ideas please how I can resolve this? 

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.