General

Hello,We are currently using FME and are quite satisfied with its performance. We are in the process of upgrading our SAP R/3 to an On-Premise S/4 HANA system. My question is whether I require an SAP HANA Runtime license or an Enterprise license to access the tables in my database. Has anyone encountered this issue before? SAP's communication on this matter seems somewhat ambiguous.

Hello - I would like to use the attribute creator in FME to generate a StartDate and EndDate. The EndDate should calculate the last date of the previous month and the StartDate should generate the first date of the previous month. There is no data to refence so I would like to identify todays data and then use the logic to get the Start and EndDate.  The idea would be to use these dates as parameters when calling an API. Does anyone have any suggestions on how I can implement this. many thanks 

Hello - I have several fields in hh:mm:ss format and I want to sum the total number of seconds from all parts all the field. For example:01: 10: 30 would total 4230 seconds  Does anyone know the best way to achieve this? I am brining the data in from an API and have used the JSONFragmenter to tabularise the data.  I assume the current data type for the fields is string as that's the default for FME?

Reading las/laz from network drive suddenly throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it. Other filetypes works fine eg. JSON. Also, if I move the las/laz files and read the from my local machine it works fine.Any ideas why this happens? (My user have full priveliges on the folders and it's content also I have tried setting full access for anyone on the folders.) Thanks

I FME workspace that creates Autocad to my local drive. How do I create the files in my SharePoint document folder?

I want to pass a feature class name into a workspace and have the workspace tell me if the feature class exists in my SQL enterprise geodatabase. The purpose is if the Feature Class exists I want to backup the existing feature class, then truncate its data and append new data into it. If the Feature Class doesn't exist I want to create it. I've tried the Schema (any format) method with no luck (when you pick ESRI geodatabase SDE if requires you to select the table you want to check against manually and I want to pass in a parameter). I really thought there would just be an "Exists" transformer, but sadly I can't find one. Any suggestions would be greatly appreciated.

I am relatively new to FME and have been attempting to process data which I would typically do with MapBasic. I have gotten so far but have gotten stuck at the point where I would typically run a loop in MapBasic When it gets to the point marked ‘ok to here’ The data is sorted and grouped by asset  1.     What I’m attempting to do is loop for every asset group i.e. asset 12 in the example below and then for RTC, FCD and NoPumps sum the number in the group2.     Update the row where the count = 1 i.e. RTC = 0 FCD=0 NoPUMPs=2 3.     Then discard the remaining lines i.e. 2-7 in the example   i.e.  After repeating for every Asset Group I should then end up with a single line, 10,929, for each Asset, containing the number of Pumps, FCD’s etc         In MapBasic I would simply do this with a few lines of code but can’ replicate with FME. Select

Orientation of a line

Hi, In the workspace below, search the website and return many rows.It´s possible to see in the Translation log, but in the result, only the last row is shown. How can I receive all rows in the result? Thank´s

I have a large DEM (DEM1) and a clipped one(DEM2), I want to replace a specific area of the large DEM with the )clipped one (see image below)

I completed all lessons of Connect to Data, yet my status didn't change to Completed. Also, I attended the FME Accelerator live webinar, yet my status hasn't been updated either. What am I missing?

I have created a workspace to push files into Sharepoint.I've created a web connection via FME Options into Sharepoint. I've signed in and tested this connection. When I bring in the SharepointOnlineConnector transformer, I can find the Authentication account. It's when I got to the "..."s to the right of Site and click on that that I get this warning.I am connected to the internet. I don't think I have firewall issues. I am signed into Sharepoint in my web browser too to this specific account. I do work with multiple Sharepoint/Microsoft accounts though on this laptop if that makes a difference? I was unable to get Sharepoint to work in the workspace, however I have a col

Hi all, I wish to be able to read the LAS/LAZ header information in FME. Does anyone know how to do this? The information is not any of the attributes I can expose. I only need the header information and not the actual point cloud if possible. This screenshot is an example of the information I am looking for using another program lasinfoI'm guessing if this is possible then python will be needed. I do not know any python Any answers would be appreciated  

Hi, I am running FME from the command line. I was wondering, because I've never been able to work it out, is there a way to make it so that FME does not report anything to the console window so there isn't as much text? Or at least less text? For example I don't want to report all this progress text  The way I am calling FME is like this:fme WORKSPACE.fmw ^ --PARAM_1 ABC ^ --PARAM_2 123 Any help would be appreciated thanks

I have about 3000 las/laz-files and I have to know how many points there are altogether in those files. In LAS/LAZ header there is the info, but how to read only the header info in FME? Or is there some other way to do this?

Since I upgraded to FME Form 2023.1 the transformer list options , such as "Upgradable Transformers" and "Incomplete Transformers" are missing in the Navigator, even when I have transformers in my workspace which are incomplete or can be upgraded. Is there a way to enable this option?  

Hi, I'm receiving a "Python Exception <ModuleNotFoundError>: No module named 'fmepy_autodesk_bim360docs'" error when running a workspace. I've checked the other threads relating to these errors but most are related to FME Server which I'm not using. How do I go about installing the fmepy_autodesk_bim360docs module? Thanks

I have a list {133F5222-149E-4884-A80E-4DB4B320CF44}, {60A99BDB-26C6-48DA-942E-563CD48B68C4} with various elements that have the value of an attribute of a table in an FGDB. Using the FeatureReader, I would like to load these features that have the value of the elements in the attribute [UUID]. In Python, I would simply load this list with [UUID] IN (<List>). Unfortunately, in FME I cannot manage to load these features using the FeatureReader and the Where Clause. What must the where clause in the FeatureReader look like if I want to load all features from a list whose value occurs in the [UUID] attribute? Or there are any other possibilities to manage this task?

I started building an ETL job in Form 2023.0 that only reads in about 250 PDF files containing 1-3 pages where I need to extract some text. I've recently upgraded to 2023.1 and the issue still persists. I've noticed after working on the job for a few hours the FME Form UI will randomly start to flicker as if my mouse button was stuck down and was spamming clicks every second. It doesn't trigger a click event and it only happens within FME. If you attempt to work around the issue it rapidly continues to get worse until the screen completely stops updating. The only solution I have found once this starts is to save your work and restart FME. I've attempted to attach a video of the issue. In the video, I only zoom the view once despite it looking like I'm scrolling in and out really fast and I'm only clicking on each transformer or pathway once as well. Snippet from System Info:OS Name Microso

Hi,I haven't quite been able to work this out. Is there a way to check if FME form is licensed from the command line? Before you try to open FME. I ask because I am making a batch file and I wish to check before it starts to let the user know if they need to update itAny help would be appreciatedRegards

Hello,  is it possible to read geometry from Sqlite in FME 2023? In FME 2022 I was using SQLite Spatial (GDAL) (deprecated), but I'm missing this format in the new version. Thank you.

Hello everyone -  We are migrating from on-prem to Azure. Its lift/shift approach. The machine name is not going to change, but MAC address will change. We can't really get a MAC address before we move the machine. I have below questions. Can we directly edit the current license file with the new MAC address after we have moved to new server ?Does the licencing software supports TWO Network adapters setup. ( two NICs). If its supported, then we can do the below. Is the license server smart enough to detect there are NIC#1 and NIC#2 and that the MAC address of NIC#2 is the correct old address and hence the existing license is valid? We can lift-and-shift the PRD-XXXXX-01 server with the existing license. This will create by default a NIC#1 with the new MAC address.We can then attach a second NIC, NIC#2, to this migrated VM and overwrite its MAC address with the old existing on-prem MAC address.

Here is my use case: I have created a workflow that works well and can handle multiple files. However, when I publish this workflow to FME Flow, I have the following problem when I copy and paste multiple files at once: Copy and paste two files at once.The resource or network directory sees the change and triggers the same workflow twice (see https://community.safe.com/s/article/Do-the-Directory-modified-Automation-triggers-support-single-events-for-multiple-file-datasets)The first workflow runs fine and writes all my data to a databaseThe second workflow (which is the same, just triggered a few milliseconds later) fails because

The webpage titled, "Efficiently Convert ArcSDE to GDB" doesn't provide documentation on how to do that. Is there a tutorial or documentation somewhere on how to convert ArcSDE to a File geodatabase?  

I see in the documentation that this is possible (I.E. setting a value in SchemaMapper using a built in FME function). But I sure can't figure it out. Does anyone have an example, or can they please point me in the direction of an example? Thank you.