FME Form

Is it possible to, if I have two point datasets that both intersect a polygon dataset, filter out the points that both intersect the same polygons ? I was using spatialrelator but it only takes one point dataset at a time; i want to see which polygons are intersected by both point sets at once. Hope that makes sense. Please helpme out, thank you!

Hi everyone,i try to import an Auxiliary trail created in Smallworld to FME for further intersections with different smallworld objects (using the SBS Plugin). Unfortunately it seems that FME cannot read the XML file correctly as i cant see any geometries. I used the XML (Extensible Markup Language) reader but maybe another reader might be better? or might a writer be useful to extract the geometries? I attached the XML file an hope that somebody has an idea what to do. Thank you!  

Hi All,I’m having some issues to filter raster pixels by the band expression using the RasterExpressionEvaluator tranformer,What the expression to select the pixels with the following band combination B(0)=64; B(1)=128;B(2)=104? I have used the following settings but hasn’t worked: Any ideas please? :)

When I query the schedules using the REST API (...fmerest/v3/schedules?...) The json returned gives the specified user I changed it to but the userName value is the previous owner. Does this indicate that the job is running under the account of the previous owner? How can I make the userName show the new owner account?

Hey Everyone!its just a curious doubt…Can we solve snapping errors on Fme form?

I’m wondering if there is a way to add vertexes (point) to polylines at a certain distance. Lets say I have a .shp layer with several polylines. I also have a table with “errors” that have occurred somewhere on these polylines. The table have the following attributes:Column 1: Line name (containing the names of the polylines in my .shp layer)Column 2: Distance measured from XXXX (containing names of stations that connect to the polylines, this is where the distance is measured from)Column 3: Distance (km) So basically i know the exact point from where the distance is measured from, I know which polyline the error has effected, and I know the distance. Can I automatically map this out? 

Hi.I have a problem where I have a local counter (_count) that adds a counter to each feature that passes through. I also have a list of numbers I want the counter to ignore. Eg 1 to 10,000 but ignore the 244 numbers in my _ignoreList, which is dynamically created. 1,2,3...39,40,42 (ignore 41 because its in my list)Any ideas on how I would go about this?All help is greatly appreciated.Regards, Paul

Hello, I want to know how to use PointOnAreaOverlayer for a layer with more than 1 polygon.I have a polygon shapefile for Canadian provinces and a point shapefile for Canadian addresses. Both have the Province name attribute.I want to check if all points that fall in a polygon have the same name as a polygon. For example, I want to check that all points in Alberta have the province name, Alberta. I used the Grouped By Province name, but it did not work.I appreciate your assistance with this transformer or any suggestion for this test. 

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 achieve it ? FME 2021 

Here’s the process I’m trying to implement:I have a scheduled job that backs up a SQL database weekly. I’m using FME form/desktop to drop that .bak file into an FTP. I want the file I upload to have a dynamic date (date when the job runs and drops the file). I’m not sure how to go about this step.  

Hi Everyone I see that there is a .bcf writer available in fme:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/bcf/bcf.htm The documentation mentions that .png "snapshots" should be created for the writer. To my knowledge I have not seen any way to take images from fmes workbench viewer or inspector, therefore I assume you will have to create your own pngs for this.. Has anyone had a go at trying to write .bcfs in FME? I would love to see some best practices or how tos for this writer. RegardsFred RegardsFred

I just upgraded my FME from 2021.2.4 to 2023.2 today. My emailer transformers are working fine on my workbench that were previously there. I went to add a new emailer to my upgraded workbench, but I cannot set the parameters, it's stuck at Generic SMTP and no connection settings are anywhere to be found, so no host/port/encryption settings. I removed all the emailers from my workbench, then removed the emailer transformer from my PC, then redownloaded it from FME hub, and still no dice. Any advice? Build is 23764

I am basically doing AttributeValidation but am looking to find values that are blank or empty. Looks like I can't look for blanks or empty's within the AttributeValidation transformer. So, right now I have a testFilter that is checking each field if it is blank or empty. I am using a TestFilter because then I can specify each of the fields that I want to be checked. The problem is that if one record goes through the tester and on the first test we find out that field is blank, then I believe that same record will not go through the rest of the tests. I need to know each field is blank, not just the first one. I am looking for a suggestions on how to do this efficiently. I am basically running a QC process on a large dataset. We have a bunch of business rules that need to be followed. So I am setting FME up to check all those rules. If a rule is broken, then an email will be sent to the person that introduced the error and then they can go back and fix the error. So this one st

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 @Evaluate("$(WHOLE_DAY)==YES ? {date_trunc('day', period_start_time, 'America/Toronto') as period_start_day,} : {}") @Evaluate("$(COMPUTE_HOURLY)==YES ? {date_trunc('hour', peri

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.0066705398    parameter 2  = 1.0000000000    parameter 3  = 0.0000000000    parameter 4  = -1.1972600222    parameter 5  = 50.61770629