FME Form

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.

I have an Esri ArcGIS Binary Grid and a line shapefile. The shapefile was produced by the Surface Draper transformer, so it is 3D and has Z values at the verticies from the same Grid. The Z values that I would like to generate at a 10m interval can be output to a csv, instead of being applied to the shapefile: that is, I do not require verticies to be created in the shapefile at a 10m interval. Just need the interpolated Z values every `10m down the line. Thanks!

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?

We're trying to create a near-live view of our data, differing from the majority of content on our ArcGIS Enterprise which comes via registered Feature Services (source - Oracle database). We're unable to update the production dataset more often than the current weekly schedule due to internal constraints. We're aware that FME can update a Hosted Feature Layer but can it update a non-hosted Feature Service? I.e. one which is being referenced from a database via an SDE?

To ensure our database's data integrity, which is periodically enriched with measurement data governed by users, we use FME to create data validation reports in Excel. With these reports, users can correct their data iteratively.  To make this work, we use SQL statements stored as attributes in a table. Depending on the report to be generated, SQL statements are fed into a SQLExecutor transformer as attributes. At the time of writing, we employ close to 500 validation queries, each with their own set of columns as well as amount of columns. The picture below shows how the queries are inserted into the SQLExecutor as an attribute.  This is then routed to a dynamic Excel writer by using the SchemaSetter custom transformer. The Excel report is generated as expected, except for the column order, which is sorted alphabetically instead of the order specified by the (dynamic) SQL queries. Is there a way to preserve the column order specified by the SQL queries instead of having them sorte

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

This workspace is meant to upload salesforce data into our Snowflake account. I created a connection With Snowflake and have my account name as the parameter. When I run the workspace, it gets all the way to the end with no errors but says that the transformation failed. My coworker runs the same workspace (connected to their own Snowflake account, both are under the same company mother account) and it works and uploads the data to Snowflake. I have not found any similar issues while searching online. What could be the issue?

(Disclaimer: I have only rudimentary understandings of the inner workings of XML.)The source below is a GML file where I need to fragment/flatten the elements shown. I would like to be able to treat them as "normal" features with regular attributes. I am using the GML-reader associated with this specific data source, Norweigan SOSI, my settings are also below.  Q: What would be the best way to flatten this data?  (Or would the XMLfragmenter be a better tool? I must admit I find all this a bit confusing)    

Hi there,I'd like to add an arcgis online feature service to my Html report. When I use the Map Esri leaflet, I'm confused by the terminology of 'feature layer URL'.... Documentation/helpThis parameter allows the user to specify a list of comma delimited ArcGIS Online feature layer URLs, that will be displayed as additional layers on the map. Is this the feature service item Id URL? or do we need to be more specific and enter the REST URL of the layer in the feature service? As I understand it leaflet provides visualization capabilities for data hosted in Feature Services, Map Services & Image services. I think the documentation needs some detailed wording and/or examples. I don't seem to have much luck using this option in the html reports, but I'd very much like to!

Saya hendak menukar file IFC kepada geopackage. Semasa meletakan writer geopackage saya telah memilih table definition manual dan juga Automatic. Masalah yang saya hadapi pada writer yang disetting Automatic, tiada objek geometri dan pada writer yang disetting manual berlaku kegagalan…Hanya apabila memilih dinamik sahaja ianya ok. Maslah saya disini dalah tidak mahu menggunakan table definition secara dynamic. Mohon bantuan bagi yang mahir. Bersama ini disertakan file2 tersebut. Tqvm. 

Experiencing, Schema features output from the SQLExecutor only after the Data features. This is causing issues for dynamic workspace. Currently managing this by connecting FeatureHolder to the Result (Data features) port of SQLExecutor, to hold the Data features and let the Schema features reach dynamic writer first. From the above screenshot it can be noticed that, Schema features are started coming out only after the Data features. To address this, required either of the below for SQLExecutor.Schema features output first before Data features all the time.Required "Output Schema Before Data Features" parameter,  similar to SchemaScanner. FME version: 2022.2.2

I am trying to think through the best way to approach this in FME. I need to create polylines from a CSV file. I have two files in the following format: File1 contains one row per line, including the start and end coordinates for all lines:Line123, StartX, StartY, EndX, EndYLine456, StartX, StartY, EndX, EndY File2 may or may not have additional midpoints. Each midpoint is on a new row. So two midpoints for Line123 would look like: Line123, X1, Y1Line123, X2, Y2 I need to combine these in the correct order to rebuild the line. For each unique LineID, I need [StartXY] + [Midpoints] + [EndXY], and the midpoints need to be in the same order as originally presented.  There are likely many ways to approach this. Here is my first attempt. I know I can use LineBuilder to construct any midpoints from the second file. It's set to wait for all inputs and process at the end, grouping by LineID. I know the order of vertices depends on the input.    I want the LineBuilder to process the span S

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

Hi,My workspace worked in 2019.x, but I noticed an issue when it was migrated to 2022.2.0. I read in multiple *.TXT files from a single folder using a FeatureReader (passing the folder name with a parameter), they are actually csv files - so use that as the format. In the Parameters I set "Field Names Line" to None as there are none. I expose "col0,col1". It reads all the files and I get the correct feature count, but it reads the first file fine, but all subsequent files it uses the values from the first line as the field names - effectively ignoring the "Field Names Line" Parameter. Is this a bug? As I say, it worked before. Kind regards John

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 everyone, I am looking for the right transformer to do a simple table manipulation here. So I have T1 (a table with multiple columns) and T2 (a table with a single column representing groups). I would like to duplicate T1 n number of times (n = number of groups in T2) where each row in T1 would be copied to be represented in each group to give T3 as a result.  Thanks in advance!

Is it possible to set a style for an excel cell if setting attributes dynamically?

I have a dynamic workbench which reads KML and/or KMZ files (OGC/Google KML Reader with selected Multiple Files *.kml and *.kmz) do some translation and writes output features to Geodatabase.Workbench does all the translation and writes output Geodatabase, but when I run this workbench with only KML files (no KMZ files in input folder) I get an error message: KML: Cannot open dataset `G:\\path\\**\\*.kmz'KML: Error initializing readerWhen I run this workbench only with KMZ files (no KML files in input folder) I get an error message: KML: Cannot open dataset `G:\\path\\**\\*.kml'KML: Error initializing readerWhen I run this workbench with both KML and KMZ files in the input folder I don't get the error message. Can you give me some tips on how to work around this problem so that the error message does not show up in the log? Or can it show up as a warning rather than an error? It is confusing for the Workbench user when they get the error message, and the workbench actually

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)

Hello everybody. The problem is the following. From a httpCaller and a featureReader I open a GTFS, but some attributes (stop_sequence in stopTimes.txt and end_date in calendar.txt) appear as missing. However, if I examine the downloaded zip with a text editor, the missing attributes appear with value, but if I open the downloaded with FME with a reader it doesn't...I tried attributeExposer, but it doesn't work. Any suggestions? Thank you so much! Pol 

I have to write my results in EPSG:4099 and FME does not offer the coordinate system. I found the opportunity offered by safe to define a custom coordinate system by supplying (ESRI Projection) WKT.The resulting fme file and exception file went into my documents folder into the respective sub-directories of the FME folder.The webpage explains that by doing so every project in any installed FME version will know the coordinate system. The WKT definition for EPSG:4099 can be found here. I use the Reprojector to bring my data from EPSG:25832 to EPSG:409, write the results to file, where the writer is set to have a coordinate system of EPSG:4099. When I import the resulting dwg into QGIS the layer is recognized as EPSG:4095.When I read the resulting dwg again into FME and check the coordinate system with a CoordinateSystemExtractor then there are no information at all. Am I producing data in EPSG:4099 or not?