FME Form

How to convert all the attribute names of all the feature classes within a File Geodatabase, to uppercase?

Hi team,I've seen this at multiple locations, where Sophos will prevent FME from installing custom transformers from the Hub (i.e. Emailer) and display a Lockdown alert, Sophos believes it to be malicious behavior. Has anyone else experienced this? Is it possible for Safe to reach out to Sophos to see if this can be looked at, as the only way to get around this, is to allow exceptions per Transformer on the Sophos side and we have to re-do this each time we upgrade FME Desktop.

Attemping to connect to a hosted mongodb I get this error message:MONGODB3 reader: Server at xxxx:yy reports wire version 5, but this version of libmongoc requires at least 6 (MongoDB 3.6): generic server error I can see FME's reader doesn't like some app version on my db server. Is this something I can resolve in FME, or does the server require updating to allow FME to connect to it? Thanks,Clay

Hello everyone, I am trying to use a SQLExecutor with embedded connection parameters provided by some published user parameters. Here's an exemple:After saving the SQLExecutor parameters and reopening it, it seems that the last parameter (password param, i.e DB_PASSWORD) is not being persisted:At first i thought that it would not affect the connection parameters (i.e. maybe an small UI bug), but that's not the case since the SQLExecutor did not use the provided $(DB_PASSWORD): This is a local test, but i have similar results when targeting prod servers.Interestingly, this happens on

I have an API Key from MaintainX but I'm trying to get pass the first stage of Authentication with Bearer Tokenhttps://api.getmaintainx.com/v1/docs

I have a string column containing lake names in the format ''Blue, Lake'' and I would like to reverse the format to ''Lake Blue''. I somehow can't find a way to reverse a string at the comma.  Is there an easy way to accomplish this using string functions in FME ?

I am wanting my StringReplacer to search for values which start with a certain string, and replace the ENTIRE value with a new string (not just the start). I have table with a list of values starting with "Sh 1" and "Sh 77", and they all have following text after Sh 1 and Sh 77. I would like to replace the entire value, e.g. "Sh 1 Rs 401 Rakaia to Chertsey" should be replaced with "State Highway 1".  I have tried a few expressions, but currently I am only able to replace the "Sh 1" part of the string, not the following text.  How do I change my expression so the entire value is replaced?   

I have a large set of featureclasses that need to be run into a workspace, one at a time because loading the dataset all at once will make my FME workspace terminate because the memory is full. I have used workspacerunner on a folder with multiple csv files, which solves the memory problem. But I can't figure out how to do a simular thing with multiple featureclasses. I wouldnt mind if the featureclasses need to merged into one and the input the first xx number of features into the workspacerunner. If that is even possible.

Hi there, Until a few days ago we had a working SharePointOnline Connector in FME which uploaded a .dwg file every day. After updating to FME Workbench 2022.2 that stopped working. A saw in the webservices options that the Tenant-ID was replaced with the string 'common' so I reverted this to our setttings. I used this YouTube-video for implementing the right settings inside FME. I can test the webconnection which is succesfull. But encounter a number of error messages. See below. I've also been troubleshooting together with IT to make sure that all proxy/FireWall settings are correct but nothing has changed there.Thusfar I've encountered the following error-messages: 

The writer stops working after I added a geolocation field to the sharepoint list. Even without writing anything to the geolocation field, the writer still gives me this error. Could anyone help me? Kind regards.  https://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_ReadersWriters/sharepoint/sharepoint-user-attr.htm

Hello, I managed, with a PythonCaller, to create a dialog box with a dropdown list of choices, a button opening a url link depending on the selection. I would like now that:1) the choice list be taken from an FME list  (code line 38 below)2) once the coordinate is chosen, by clicking on "button2" ("OK..."), the FME attribute "Choix_adr" takes this coordinate and the FME script continues.  (code line 88 below) I have the following code that works at the list level (but without taking a FME list or defining the "Choix_adr" attribute once chosen) and the hyperlink button:from PyQt5.QtWidgets import *from PyQt5 import QtCore, QtGuifrom PyQt5.QtGui import *from PyQt5.QtCore import *import sysimport webbrowserimport fmeimport fmeobjects class Window(QMainWindow):     # Initialisation de la commande    def __init__(self):

Hi there. I am outputting SQL data into a CSV into well known text. Some of these features are polygons and others are multipolygons. I am finding in the output some multipolygon WKT strings are spilling over into other fields which throws everything out. I'm not sure the field length is exceeding the maximum length for a CSV but is there anything I can do to keep it all on one line or is this a problem with multipolygons? I'm using a GeometryExtractor to convert to WTK, then a couple of StringReplacers to remove Z and change the SRID from 0 to 3857 so the csv can be brought into Power BI. Most are appearing fine. Regards, Josh

Hi, I'm looking for a way to generate a random 6 character alpha code. SequenceGenerator looks like it would work but it only uses numeric values.

I don't understand why I'm getting a failure to transform the projection system and save it in another format.jpeg - ecwundefined - 25830 

Is there a way to copy to excel user attributes table? I need to reproduce the table of writer attribute names, data type, width, value, precision. Figured there must be a way to extract those fast? 

Hi I'm using FME 2022.2.5 it crashes at the start and before loading the main window, sometimes it happens when I enable/disable cache. the issue with Qt6Sql_fme.dll ! appcrash event in the the log file.. anyone with helpful tips it does start after 5-6 tries. this log is from the start up crash------------------------------------------------------------------Felet uppstod i programmet med namn: fmeworkbench.exe, version 2022.7.45.22795, tidsstämpel 0x6424fcdc, felet uppstod i modulen med namn: Qt6Sql_fme.dll, version 6.2.4.0, tidsstämpel 0x6254adbaUndantagskod: 0xc0000005Felförskjutning: 0x000000000000edbfProcess-ID: 0x7968Programmets starttid: 0x01d98ca438014579Sökväg till program: C:\\Program Files\\FME\\fmeworkbench.exeSökväg till modul: C:\\Program Files\\FME\\Qt6Sql_fme.dllRapport-ID: 4320bc12-2030-4046-b3b8-63e036810fb4Fullständigt namn på felaktigt paket: Pro

Hi, i am using this structure to generate solid meshes from a LAS, extruding the point from x,y and z and then building the mesh of each small cube. But I found that the solid mesh was moved in the space (there is an offset) when I use cloud compare to viz it, and I don't know why it is occurred.Very grateful for the answer!! thanks:) ! 

Have and excel spreadsheet, roughly 90 mb, if II make a workspace that simply reads that excel file and writes it, the size of the written excel file by FME is about 179 mb. I am just using the defaults on both the reader and writer. If I open the file in excel and clear all cell formatting, and save, it drops the file size down to about 109 mb. Any Ideas why FME is writing a file that is almost double the size of the source file? and is there any way to clear out any formatting, assuming that is where the bloat is coming from ?

FME training and tutorials appear to be a 'spatial first' - ie they assume that any new user wants to work with spatial data. But FME is fabulous for non-spatial data as well and this spatial-first approach is overly complex and off-putting for new non-spatial users. Does anyone know of any introductory tutorials, videos, etc that teach new users how to use FME without dragging them through complex (and irrelevant to them) topics such as spatial formats, coordinate system, geometry processing algorithms, etc?Thanks

Has anyone tried using FME to connect CityWorks to Kronos time keeping? We'd like to have the time codes sent directly to Kronos instead of having someone manually enter them in.

Hopefully this doesn't ramble too much... I've been tasked by my Organization to standardize our development processes and implement clean, repeatable deployment processes across all of our environments. This means storing all of our integration configurations in version control (git), and being able to use pipelines to auto deploy to any environment at will. Over the last 6 months, I've built a PowerShell module that:Deploys Workspaces (if they have changed against the server version)Registers ServicesDeploys/Updates TopicsDeploys/Updates SubscribersDeploys/Updates PublishersDeploys/Updates Schedules The process is getting much better, but still has a few dependencies:A "sandbox" FME server environment, where all of our work is deployed manuallyDevelopers create a "Project" on the Sandbox FME server and adds all the dependenci

As you see, I connect separate inputs to the two duplicates of my custom transformer. But all the data goes into one of them. Why is it like this?

I'm using FME serverI got a dataset with only one feature inside.I converted it to fgdb with ignore schema selection as attached fmw.But the output is zero feature.It can be success if I duplicated the feature to make it become 2 features.The attached is dataset, log and fmwIs any other thing I can do on fmw for this situation

I want to loop number of times (22), so, created Custom transformer. Tried embedded, didn't work, so now Linked Always with fmx.1. Unable to work out whats the issue, it works if just run for only one iteration (test purpose), so, seems no issue in both main & fmx (custom). 2.But an issue to loop, or going to next iteration 3.Could not change CustomTransfomer>Transformer Pramaters>Advanced > Maximum number of iterations or Attribute to holdl iteration count !? 4.However, I have used 'LoopRecs' for iteration from main to loop transformer and added 'MyCounter' for loop test. 5.Please note, added sampler, just to run 3 times for testing, but actually wanted to loop based on 'LoopRecs' variable, which is passed thru main to custom. Whats issue here ? I have spent a lot of time figuring out . . is this a bug ? tried to get help from our FME tech support here , no response

I have a workflow that needs to run completely offline, where the customer wants to be able to navigate using a map, and then once at a given location, click on a feature on the map, and pull up a specific model in an AR environment to illustrate what the future conditions at that site would look like. The model would need to be geolocated/anchored for a simplified experience for the user.   It would be very easy to create a url within the mapping app to send to FME AR (to include the model name, even an insertion point, etc.) I am curious if FME AR supports a deep linking capability that many other mobile apps support. I cannot seem to find any documentation on this topic, so any insight is appreciated.