General

I have two layers point and a polygon, I wanted to have the aggregate of a column name "Progress" with its respective polygon name and polygon id. The progress field in the point layer has the values namely 1, 2, 3, 4, 5 . The count is the total number of points inside the polygon.  The result should be like this   I have currently done this process in FME The result is How to change the workbench to attain the desired result. Any leads will be helpful. Thank you. 

Is there a way of validating that the data contained in an attribute is valid based on a table of values?I know I can use a CSV list in a tester with 'in'. But my table of preset values is 4-500 entries long, and has the possibility of change, is there a way of comparing directly to this table, or using the table to populate the CSV value (maybe through a parameter?) automatically?

I'm trying to clip out 'curves' from a polyline. I have a 2 layers, a polyline layer and a point layer. The point layer has a "point type" attribute that states if the point is "Tangent-to-Curve", i.e. the beginning of the curve, or "Curve-to-Tangent", i.e. the end of the curve. There is a one-to-one relationship between "Tangent-to-Curve" and "Curve-to-Tangent" points.  The issue is that the "Tangent-to-curve" and "curve-to-tangent" points don't have a shared id to link them.  My polyline layer does have measure values, which might be of use.

Hi,I have been asked if FME can retrieve signal data from a site with no API. I have credentials to get into the site, and once in I can pass a list of site ids to a url to retrieve a csv file of the data.I'm having issues passing my credentials in the header of the HTTPCaller as UserName and Password to get past the login page. Any idea if this is possible? This is the site in question:https://www.detecdatapro2.com/login

Hello ,i have some points at the same line each two point has the same attribute .i would like to connect each point that has same id together So I think I can use line builder with group by id .how but how to connect each two point without the line intersect with other points ? as my phone , point 1 and point 4 has the same id but if I connect 1 and 4 together so it will create line intersect or overlap on other line between 2 and 3 2 ,3 has same id 1,4 has same id what should I do to create line between 1,4 and other between 2,3 ? The line should cross but not intersect because I would like to use network topology calculator later . fme 2021  

Hello - I have been able to use the HTTP caller to get data from an API. However there seems to be a 50,000 record limit. I have created a StartDate and EndDate fields using an attribute manager formatted as yyyy-mm-dd. I was wondering how I can use these fields as parameters to get data from (and including on) those two dates? P.S I have a field that is called OrderDate from the data the API gets and was going to use the dates to filter on that. However this field is formatted as date and time. Any advice would be greatly appreciated. Thanks,  

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 max(asset) from Data into iA    Fetch first from iA      iAssets = iA.Col1         Close Table iA  For iLoop1=1 to iAssets   Select asset, _count, Co

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 colleague who can write into this Sharepoint account using my Sharepoint login/password (he writes through FME Server) and write into Sharepoint successfully. As a result he exported a .xml for me and told me to import it. I have tried that, but am still getting this warning. I notice in the las

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 Microsoft Windows 10 Enterprise Version 10.0.19045 Build 19045 System Manufactu