FME Form

I would like to count the rows in a (Oracle) database table and then write that row count to the Translation log.This is so that I can quickly compare the row counts of two tables against each other (as a quick way to determine if an update has occurred)I can use SQLCreator to count the rows of the tableSelect count(*) as COUNT from TABLEThis places the count as a value in a column that is output from the Result of the SQLCreatorMy question is, how can I write this value to the Translation Log?I assume I use the Shutdown Python script. But how does the script read that attribute value?

Hello ,I am checking duplicate consecutive points It is clear that issue locations port show one vertex of duplicate point with coordinates (x,y).i would like to know the two vertex that duplicated then  I choose one of them to cancel .but it show me only one vertex .How could I show the two vertex ? FME 2021 

Hello,I generate a data pool from various data sources with identical attributes, which I filter and sort using various criteria. From these results I create several lists (Top50), which I output in an Excel table with the XLS writer. In principle, this works well, but I would like to insert a blank line between the output lists or output the lists from a certain line in the Excel sheet.I tried to integrate this blank line into the list using a new entry, but only managed to do this using the Python caller, which I wanted to avoid. If the list did not contain 50 elements, I did not manage to output the second list in a specific line again.My question now is, how can I start the output of the N.th list on the 55th line (without using the Pythoncaller. Furthermore, I have not found a way to output a list in the 55th row in column K. Is there a possibility for this in FME?Thank you very muchTranslated with DeepL.com (free version)

As I am newbie in FME software I’m looking for a help.I have two sources with lines and I have to point the places where lines are not connected.Is that possible using some transformers? Please look at screenshots and data I’ve attached.   

Hello everybody :-) we have a QGIS Project (.qgz) with 2 Layers, which we want as GeoJsons export. If possible uploading them into a FTP Server.Can we do this using FME? I have searched a bit and I do not find any Readers for QGIS… Thanks in advance! 

I have a flow based around a main SQLExecutor that runs of different levels of aggregation depending on the input parameters, and the most conveinient and efficient way of doing that is to add or remove parts from my SQL query based on said parameters. While the problem looks simple on its face, I have not been able to find a good solution for that.As evidenced by the following thread, FME doesn’t have a function for this kind of conditional string substitution. The best it has is the ternary operator.However, said ternary operator is only supported in the Math Editor, not the Text Editor that SQLExecutor uses. The next best thing I have found is to use the @Evaluate function to give me access to Tcl’s ternary operator, provided I can express these sections of my query in a way that is valid in TCL.select @Ev

HiI am currently looking to create a CityGML model of the buildings in a specific area using various spatial data. I have followed this tutorial Point Cloud to 3D Terrain Model with Buildings and obtained an Adobe 3D PDF model of the buildingsBut I now want to convert this model into a CityGML LOD2 model. Is this possible?Since I have just started using FME and am not very familiar with the software, what should my next steps be? Could you provide some useful references? Thanks for your advice😊

I have a segmented column (basically stacked barrels of varying height) and 3D points “floating” within that column. How can I join the points to their containing segments? I made a few attempts but the results suggest FME only checks for X/Y and not Z.By join I mean the solids acquiring their corresponding points’ attributes, looks like the weird “x-on-x-overlayer”, etc, transformer names unfortunately survived the overhaul 😒 (unrelated: signing up with a too long username gives a wrong “not allowed characters” error in the sign up form)

We have a SQL .bak file which serves as a template for a database schema. Normally this .bak is restored manually via MSSQL, where the name of the database is specified.The goal is to be able to dynamically create a database on a known server, where the name of the database is derived from processing within the FME workspace.Is there a script that can be run from a SQLExecutor in FME to make this possible?

Hi,  When creating offsets from a line in DWG - is it possible to use an excel table for the offset distances?  Excel table is 2 columns (“offset #” and “offset distance”) and 100+ rows (offset-1, offset-2...) containing negative and positive numbers. I looked up offset related posts but couldn’t figure out how I could make excel work. I am using 2023.2 version and the offsetcurvegenerator has left/right inputs. Do I read the excel, then split it into positive and negative, then connect them to left / right each?    

I'm currently working on a task where I need to iterate through each CSV file found within specified folders and convert them to SHP files. My approach involves using the path to identify all files under the specified folder and then filtering them by extension using an attribute filter. However, when I use the FeatureReader to read the CSV files, it reads all the CSV files and combines them into one table.I'm looking for guidance on how to set up a loop to iterate through the files one by one, rather than reading them all at once. Additionally, I've noticed that there are no columns shown in the visual preview, and I have to manually check all the columns in the column options to visualize them in the preview.Is there a way to configure the table view/data schema in the FeatureReader to address these issues? Any advice or suggestions would be greatly appreciated. Thank you!

Can I ask a quick imagery / coordinate conversion question?I have lots of historic imagery files, the imagery are all flat tif files, not georeferenced whatsoever.  I also have the corresponding .IF files (never heard of IF files) as shown below which contain georeferencing information. If I convert the tifs to geotiffs using the extent information below they all end up in Southern Ireland instead of Nottinghamshire UK.  Any ideas what this Cassini projection is, or how to fix this….??I need to get these files into 27700 British National Grid# Extent information...extent    minx = 28967.7430000000    miny = 267567.5460000000    maxx = 31381.6970000000    maxy = 269176.9600000000end# Cassini Projection...projection    number       = 33    zone         = 32767    units        = 2    ellipsoid    = 9    parameter 0  = 6377563.3959999997    parameter 1  = 0.006670

Hello ,i would like to remove specific index of a vertex coordinates from a line .then build the line without this vertex .How could I achieve it ?  my second question :How could I find which index vertex coordinates so close to next index coordinates ? then filter it to keep only one of them.thanks in advanceFME 2021  

Hello,I’m working with the ArcGIS Open data portal and I want to publish all my layers within a geodatabase to my AGOL folder as new Feature Services. Since there are multiple items(layers), I’m looking for a batch process. I’ve came across several transformers but none of them seems like working for me. I would appreciate your suggestion on transformer selection for this.Thank you.Rajesh

Hello Forum, We will have a polygon dataset of construction sites. The dataset will be managed within QGIS collaboratively by several planning officers. When the officer adds a new polygon object they will add a end date. This is the end date of the individual construction site project. Once that end date is reached the record needs to be deleted. I could ask them to manually delete it in QGIS when the date is due. However I’d like to take that overhead off them and replace it with an automated way of deleting records. Is it possible to build in a process to consider the end date value and then filter records accordingly? One port would go to all records where the end date has not yet been breached (this will be my published layer). The second port would filter all records where the end date has been reached (this will become a ‘historics’ layer). I’m assuming the end date valu

Hello, I have a master survey layer on ArcGIS online that will be continuously updated during the summer field season. I also have a master environmental layer that on AGOL that needs to be updated daily from the master survey layer. I know the steps to do this (attribute manager, change detection, etc) but I am running into problems when trying to ensure the attachments from the survey are included when appended to the master layer. The attachments do not transfer and we need those pictures in the master layer. How can I use FME to set this up?Thank you. 

 Hi Everyone,I’m working on an integration workflow between an editable polygon feature class in an enterprise geodatabase and an asset tracking the same asset in an Asset Management System (which will be where the majority of the info is populated). We cannot write directly to the Asset Management System database, and need to write/get to it via API.The GIS feature class has a few attributes that are not in the layer in the Asset Management System and vice versa therefore it is not a straightforward cloning. That being said, I will have the attributes/fields required in the GIS Feature layer already so that new fields/attributes themselves don’t need to be created in the FC. However, we want to set up an integration as the diagram shows above.So the lifecycle of the asset will start in GIS, whereby a user will tra

Is this possible?I would like to create a self service map generator. There will be basically 2 paths that the user can go, interior or exterior maps, and features (door points, fire alarms, bike racks, etc) can be chosen to be turned on and shown in each map. This data all lives in an ever evolving SDE. And my idea is that all the parameters the user picks will be building an ArcPy script that is manipulating an ArcPro project.I’m laying out the base plan now, and would like to gather some ideas/input before starting off.Here’s an example of what I want this service to do, and my initial thoughts of going about it:Basically the user selections from the parameters will build an ArcPy scriptI will have 2 ArcPro Map projects, one for Interior, one for Exterior The user will select if they’d like to see the interior/exterior. If it’s interior; the interior ArcPro project has a map series created from every floor of every building

Hello ,Spike remover : It cleans the lines and removes spikes and fix it  but Changed port : the line geometry is changed .( I mean the position of line )i would like to fix the spike but keep the line without changing the position  of it .How could I achieve it ?my second question :how to find and define the part of line that has spike ?Spike removed  create point I would like to get also the Part of line that spiked . FME 2021 thabks in advance .

Hello,I have a situation that I cannot seem to understand.It seems that fme.exe is locking/using a file that I try to rename in the Startup Script, although that file is not used at all in the workspace (the processing where the file gets created/saved/renamed is happening in the startup script).The logs don’t mention this file/folder as being used at all.i don’t have the file open in any other app, closed everything else except FME.This is happening on windows.  Logs say:2024-05-24 11:32:20|  18.7| 18.5|INFORM|15160 fme.exe is using C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx2024-05-24 11:32:20|  19.1|  0.0|ERROR |Python Exception <PermissionError>: [WinError 32] The process cannot access the file because it is being used by another process: ‘C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx’ The interesting thig is that on another machine with the exac

Main question: how to create polygons at point locationsWithin FME 2024.0 I created a point dataset of cross sections with 866 points.At each location I want to create a square, which is sized 10 by 10 meters. The current points should be in the centre of the squares.Any suggestions how to achieve this?I tried the Bufferer but did not find the right settings yet to get a nice square at each point location. Output should be like the blue squares in this image:  

 Hi, I’m using a change detector to see if any updates has been made from the new data, to the data  on ArcGIS Online. Previously I had the error about missing ObjectID on updated records, but I fixed that using a feature joiner from this Guide: How do I write updates to an existing ArcGIS Online feature service? – FME Support Center (safe.com) I got it working on points, lines and polygons, however if I want to update tables, I get the above error. By a search I found that this error has also been found in Survey123: 

Hi folks,I have the following error when I run my Workbench project : 2020-04-17 08:05:41| 785.3| 0.0|ERROR |SpatialRelator_15_Output Feature Recorder -1 2147615062(RecorderFactory): File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR |File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR | I've read some other articles about similar posts here, but I did what was suggested (FME Options > Translation > Log Message Filter and unchecked "log Debug") I'm using an FME Professional Suite (FME 2018.1.1.1, build 18578 - 32 bits). Even in a 64 bits version, the error message is still there. You can see that it begins to write datas, but then stop.The log file is attached and the error messages are line 9611 a

Hi,I have a workspace to translate a Shapefile to DGN. The shp file has a attribute wich I can filter data to output in three different levels. In this levels, two of them, only have contour style, but the other one is full. When I write DGN file, the level with full style is on the top, so the other levels are hidden under this one. I've tried to put the level number in an attribute called idgs_level, but it doesn't work. I've also tried to put the level number in the writer parameteres, but doesn't work. The issue is, how can i control the order of the levels?Thanks 

I think I may have run into unexpected behaviour. I’m trying to pass some text in a user parameter via a workspace runner but it’s stripping out the quotes within the text when I try to retrieve it.The text I am trying to pass through to a child workspace:"Building_Use" = 'Residential'In the log of the workspace runner it gets passed along in the command line arguments as:--SQL_WHERE_Clause {${="Building_Use" = 'Residential'=}}'and the child workspace receives it correctly when initiating the workbench as:``--SQL_WHERE_Clause' `"Building_Use" = 'Residential''.But when this is retrieved via a parameter fetcher or attribute creator it drops the quotes in the child workspace:Building_Use = 'Residential'However if I run the child workspace on its own (not via the workspace runner) it retrieves the text correctly. I can workaround this by replacing “ with another character before and then replacing it within the child-