FME Form

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

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 b

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

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

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 ar

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

I have some datasets with unpredictable white spaces in the attribute (column) names. Is there a way to automatically trim these? The trimming tools I found all seem to be dealing with strings.

Hi all, I have two geopackage files in QGIS: One of them a multipolygon with coverage tree and the second one a multipolygon with the plots. Im looking to calculate the afforestation rate by plots, that's means the percent of total plot surface that's covered by the tree layer and add this afforestation rate as a attribute in plot layer As you see in the image below, in green I have the coverage tree and the lines show the plots limits Thanks you allPablo

There are 95207 features within the Anchors layer and 82716 features within the Candidate layer. All Candidates are exporting through the Untouched Port and nothing is coming out of the Snapped port. I have attached the workspace. Our data is projected to GDA2020 MGAZ55. Any help would be greatly appreciated. Yours sincerely. James Blythe.

Hi i have feature with 2 vertex (represent pipe line). How to built line from this 2vertex?

Please take a look on the attached files and update my workspace. It would be great if anyone highlight the process which I am missing in the simple conversion?Thanks in advance.

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  

When attempting to read features from Salesforce via FME Server (2021.2) the job fails after warning:WARN |MULTI_READER(MULTI_READER): Skipping to next ReaderERROR |A fatal error has occurred. Check the logfile above for details The workspace runs to completion on FME Desktop (2021.2) and reads data successfully. Troubleshooting hasn't provided any further information or progress. Is there a reason that the skipping occurs on FME Server?

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

Hello,  it is possible to see a FME workspace CPU usage at the end of a job in the logging. However, when you activate a stream it will occupy an Engine and it will not give CPU usage in the logging. Is there a way to find or register the CPU usage of a stream that runs 24/7?