Best Answers

Am creating three sets of numbers from one source file. Each set has a different attribute structure. I want to fan these out into separate tabs of an Excel spreadsheet, using a created attribute that is common to the three streams, but has a different value for each. Have tried every permutation of setting I can think of in the Writer/dynamic schema defn, and cannot get it to respect the three different attribute schemas. Feels like this should be easy, but…..🤔

I am using FME Form 2021. I have a table with vehicles listed by department.  Vehicle 1234 Department 1Vehicle 4532 Department 1Vehicle 5645 Department 2Vehicle 8472 Department 3 When a new record (example: a vehicle) is added to the table, I want an email to be sent only if the new vehicle is associated with a specific department. For example, Vehicle 6577 is added to the table and is associated with Department 3; thus, an email would be sent notifying the recipient that a new vehicle has been added. However, if the vehicle is associated with Department 1, then no email would be sent.  What Transformer(s) that would trigger the email do you recommend I use to achieve this? It sounds like ChangeDetector could be an option, but I am only using a single table.

Hi, I have a time format like below (hh:mm:ss) and I want to round seconds as below. What is the best option to achieve this? 00:00:22.464 > 00:00:2200:01:22.825 >   00:01:23Thanks in advance for your feedback. 

Hi folks!I am torn as to what workflow to use between FME and python. I am more comfortable with FME so hopefully FME would be the winner here.The workflow I am trying to achieve for the business user is to have a GIS editable feature layer containing field summaries translate into a docx with a table template (ideally with the same attributes as the GIS feature layer).A sample of the table template in the docx is below:Any time a new field summary project gets entered into the GIS editable feature layer, ideally, a net new Word document with a separate table with populated values from the GIS editable feature layer will populate in the corresponding values in the table within the docx. Any updates that are made to existing field work project records within the GIS editable feature layer would have the updated records/values also translate into the associated Word Document with table template values as well.So in the above, the values from the project name, date, crew, permits, divisio

Hi,When I run a workspace via an App I get the following error:Microsoft Azure SQL Database Non-Spatial Writer: A suitable Microsoft SQL Server OLE Driver is not found. Install Microsoft OLE DB Driver for SQL Server from http://www.microsoft.com/en-ca/download/details.aspx?id=56730 I can see from earlier on in the logs that it failed to connect :Microsoft Azure SQL Database Non-Spatial Writer: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error ''. When I run the same workspace from “Run workspace” it connects and runs fine:Microsoft Azure SQL Database Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server…Microsoft Azure SQL Database Non-Spatial Writer: Starting execution of BEGIN_SQL commands I tried deleting the app and creating it again but that didn’t seem to work. TIA

Before I updated to Form 2024.1.2.0, when I added a writer it would automatically name the Feature/Table and assign the geometry type. Also, if there were multiple readers in the workspace the add writer function would prompt to select individual or all feature/table names associated with the readers. Now the writers have to be individually added, named, and assigned a geometry type. This can be very tedious and time prohibitive in many cases (which goes against all things FME). Is there a default setting that I’m missing?

I am using FME Form 2021.In the Emailer Transformer Message - Body (Text Editor), Can someone tell me the proper HTML syntax to make text bold?<b>Total Number of Vehicles:<b><br><br>Number of Vehicles by Division- Using the above syntax, the email sent shows all the text is bold, including “Number of Vehicles by Division-”. I only need “Total Number of Vehicles:” to be bold. 

Firstly I combined my building objs by Aggregator, then I separated them by Deaggregator, finally to b3dm. I have coordinates of those building objs but All building overlapped in Cesium, How can i locate the buildings according to coordinates.

 Hi, I am retrieving data through an API using an HTTP caller. The data consists of points and lines. My plan is to pull this data, perform some attribute mapping, and then POST it to a website. However, I'm having trouble extracting geometry after flattening the JSON data. I used a Geometry Replacer, but it fails every time I run it. The error message says:INVALID_PARAMETER_GEOMETRY_SOURCEI would appreciate any assistance with this!

I am in the process of working on an integration between Cityworks and ArcGIS Urban. While I am well-versed in using the HTTPCaller transformer for REST APIs in FME Desktop, after s few hours of working with an HTTPCaller, the only way I was able to make a GraphQL API call was using a PythonCaller with some custom code using the requests library. For now, the PythonCaller route will work well enough, but I would rather lean on the HTTPCaller for when others have to take over this integration who are not Pythonistas.

Hi,I have a file of points which correspond to buildings. Each point or building has a number of apartments (total 9000). from this layer, I would like to create zones for every 500 apartments, without intersection. I tried the neighbor finder with sorter assending on the distance then range mapper attributes but the result is not good because I should not have any intersection between the polygons. Help please :) Thanks a lot   

Hi.I’ve just upgraded my local FME Flow from 2024.0.1 to 2024.2.1 using an engine only upgrade.I.e. install FME parallel to the previous engine, and change the configured template path.The interface is thus still 2024.0.1.The FME Flow interface starts, but the engine never shows up in its list.I’ve tried to run the new fme.exe directly, and it seems to be running.What unforeseen pitfall have I stumbled into ?Cheers.

Hi folks, I had some urgent need at my workplace, as the GIS database administrator working in a electricity distribution company, I was required to draft out various district data to be used by another department which will require me to decode and clean the data to enable them understand the data format based on their needs. I tried using manual method of copy and past after extracting this data from the database but it was time consuming.I tried FME and I was able to create a workflow using two transformers FeatureJoiner and Matcher and I am happy how this workflow was able to query the two excel files added to the left and right part of the FeatureJoiner transformer thereby giving me the output based on joined attributes file, one is coming as a number and varchar.  Feel free to connect with me on linkedin https://www.linkedin.com/in/anthony-ezema/ 

Hello,  I am using a no-fault FME Flow architecture: 2 engines. Should the engines be restarted regularly, for example, each month? What does Safe Software recommend?How often do you restart the engines? When do you restart the engines?

I am looking to extract data from AGOL to store in a separate table and filter the data by its date field. Essentially I will schedule this every evening to collate all the data with todays date, or run this early morning and filter on ‘Yesterdays’ date. How do I configure the tester transformer to reflect what I need.  Any help is greatly appreciated,

Hello,I am experiencing some odd behaviour with the FeatureReader when trying to read in a schema from a Feature Class in a FGDB. I am using the “path_windows” attribute that contains the location of the gdb. When run like this, I often get a rejected message (see Caption 2). When I add in the hard coded full path into the Dataset field of the FeatureReader, the data gets read correctly. What is strange is that this has been working fine in the previous weeks when I had developed it. It only appears to be an issue since today. It also seems to read successfully when I run the workbench with caching to the Aggregator before the Feature Reader, then running again from the aggregator (no settings have been changed). I have tried using the path_unix field instead, but get the same error. I have also tried other datasets, but get the same issue.Has anyone experienced similar behaviour when using the FeatureReader with a GDB?… and any ideas to help with the stability of the run? The workbenc

I am researching options for a GIS data catalog and data lineage system. There are some GIS data catalog tools out there (Ex. Voyager) but they lack a method to store the ETL lineage information. For example, I'd want to map that the Streets feature class in my Oracle geodatabase is sync'd to an AGOL feature layer named "City Streets" every night at 3AM.  Some of the data lineage tools on the market can connect to ETL applications (Informatica, Azure Data Factory, etc.) and scan them to get source/target information from all the tasks configured in the system. I haven't seen Safe/FME show up as being supported by any of these products. So I'm curious if anyone's come across a product that can scan for this stuff. Alternatively there's always manually populating these systems by reviewing all the FME Server job logs and investigating source/targets in the workspaces.

Hello dear communityI am a real beginner when it comes to PythonCaller. I need the syntax to create a group processing with this transformer. My problem: Persons on an address belong to a group. A new attribute should be created based on another attribute in the group.I have already generated a basic program with Copilot, but I always get an errorPython Exception <TypeError>: process_group() missing 1 required positional argument: 'group'The code reads:import fmeobjectsclass FME_PythonCaller:    def __init__(self):        self.data = []        self.log = fmeobjects.FMELogFile()        self.log.logMessageString("FME_PythonCaller initialisiert", fmeobjects.FME_INFORM)    def input(self, feature):        self.data.append(feature)        self.log.logMessageString(f"Feature eingelesen", fmeobjects.FME_INFORM)    def close(self):        try:            self.log.logMessageString("Start der close() Methode", fmeobjects.FME_INFORM)            address_groups = self.group_by_attribute(self.

Hi,I am struggling to read the content of a layer published to ESRI portal. I have a  _website_urlhttps://gis-eu.xxx.com/arcgis/rest/services/LayerTest_Pt_01/FeatureServer/0for ESRI portal layer. For example I need to get Item Id HTTP_Caller does not get this info in _response_body

Hi everyone,We have floating licenses and installed FME Form in a server, and the users will login to that server to use FME. So, my question is How many users can run the same workspace using FME Form in a same server at the same time? My user has different username and password to access the server. Please advise. Thank you.  

We are running into issues with the user parameter file inputs for Automation Apps.  In this case our end user wants to upload a new csv file every time they run the automation app, and they want to upload it from their local computer/machine.  Right now the only way to accept this user input is to have the csv file uploaded to a data store in FME Server, prior to selecting it as a user parameter, and then running the automation app.  We noticed that this problem doesn't happen for workspace applications and they can upload local files directly as the end user, with no need to upload it to the data store in fme server prior.  Is it possible to have our end user run an automation app and upload the user parameter directly from their local machine?

Hi, I have a html content in _response_body. I am struggling to get only specific text from it. I would like to get only the text highlighted in red. <b>Layers: </b><ul><li><a href="/arcgis/rest/services/Imagery_Wayback_Ardstaw/MapServer/0">2014/02/20</a> (0)</li><li><a href="/arcgis/rest/services/Imagery_Wayback_Ardstaw/MapServer/1">2016/12/07</a> (1) How can I do it? I assume I should use XTMLFragmenter but I am struggling to get the result I want

Hey everyone, I’m currently trying to get a workspace on FME Flow that makes use of the AutodeskDocsConnector. This single transformer would make my worksapace a lot smaller and easier to manage. Problem is that it just won’t work FME Flow! On Form it works without a hitch. On Flow accessing the same project and folder on Autodesk Construction Cloud also works when using the HTTPCaller. It’s only the AutodeskDocsConnector on Flow combo that seems to be failing me. This is the error message I get on Flow:  Anyone have experience with this or know how to help me out on this one?

I am new to using FME and am currently facing an issue. Here's the situation: I want to use a FeatureWriter to create a new file of type Esri Geodatabase (File Geodatabase), and I want to include the value domains of certain attributes when creating the Geodatabase. Thank you!

Recently upgraded our Dev environment to FME Flow 2024.1 (in situ)Previously we were connecting to WebMethods using Software AG(Nirvana)After installation, relevant .jar files have been added to the jms directory on the serverHowever, there is no connectivity.The error received isOM.safe.fmeserver.plugin.jms.JMSClientException: javax.naming.CommunicationException: JNDI setup failed on RNAME=nsps:REDACTED [Root exception is com.pcbsys.nirvana.client.nRealmUnreachableException: Realm is currently not reachable:Realm was still unreachable after max retry count - 0]This doesn’t appear to be hugely helpful as you get the exact same error if you use an incorrect provider URL. I can’t see anything in the logs that provides any additional informationAll evidence points to the location being reachable (testnet connection in powershell from the server) @steveatsafe - any ideas?