FME Form

I have a text field (attribute) in a table that is 2048 characters in length. I want to change it to 50. What Transformer do I use in FME to achieve this? I am using FME Form 2021.

I have spatial (ESRI FGDB data) that I want to make into a non-spatial table. Regardless of what I try (e.g. deleting the ‘Shape’ field) the data is still spatial.

Hi! I am transforming data from different sources. The data travels at different speeds through their own workflows and end up at my Excel Writer at different points in time. This in itself is not the problem. It’s because I have specified a Fanout function in the name of the file all the data/features are being written to that the problem appears. The Fanout contains hours and minutes, the name of the file begins with: “@Timestamp(^Y).@Timestamp(^m).@Timestamp(^d)_kl.@Timestamp(^H).@Timestamp(^M)...“ Since the data gets to the Writer roughly a minute a part I end up with two written files with only part of the results in them. The two files get different names with only a digit’s difference. For example: File 1: “2024.05.30_kl.12:55...” File 2: “2024.05.30_kl.12:56...” I can obviously solve the problem by removing the hour and minutes from the Fanout in the file’s name. But I would really prefer to keep it. I have been looking for something to pause and sync the data before putting it

I have one shapefilter consisting of agricultural land and some gps points in csv. how can I filter these gps points which fall in the agricultural land? I have already tried Spatial Filter but it doesn´t work all the time it fails. Would be really nice if anyone could help me with this problem. :)

Hi, Is there any way to prevent FME Desktop from converting dates to its internal format? For example, if you get '2024-05-30' I want it to remain '2024-05-30' and not '20240530'. I understand that it can be useful in some cases but there are others that this automatic conversion becomes a headache. Thank you! Regards.

Hi, I hope someone can help me with the following. I have a workspace app, lets call it "app1", which uses the file/URL parameter and the "User can Upload" setting in the Edit workspace apps enviroment to upload data. When I test the workspace, it correctly shows that the file is processed and ready for use. I have also have another workspace, let's call it "app2", which uses the exact same setting as app1 for the file/URL parameter and the workspace app. However, when testing the workspace app, it does not register the file upload Pressing upload file does not process or show a filename or percentages of completion. Browse resources and "drag and drop" produce the same result: no file upload. The tool behind the workspace app works, but will not do the designed tasks which need this parameter. I find it strange that the same setting work in one workspace app but not the other. Any experiences with such issues? Thanks in advance!

I have a close polyline in dwg and some lines inside this polyline. the polyline contains arcs too. with these 2 I create small areas in fme. now the problem: when i create these areas the boundary where the arc part of exterior polyline is different from the boundary of smaller areas. is this a bug in fme? cause it doesn’t make sense to create parts of the same arc that are not colinear with the arc that the part was extracted. or is there a setting that i have to set? ive notice that the arcs has different description in inspector window for the new created areas it says “IFMEArc: Arc By Center Point With Ends” and the other shape it says IFMEArc: Arc By Bulge. example: Pink area was generated and overlaps the exterior boundary (blue line) area. that should not happen

Hi, everyone. I have two datasets. I need to find polygons that do not overlap, even if they have different shapes. I'm using a spatial filter, and I've tried others too, without success. When analyzing the failed ports, some polygons appear as 'NO INTERSECT', but in ArcGIS, it's possible to see that the polygons are overlapping others. I've tested this and I think the intersection analysis in ArcGIS is better than the spatial transformers in FME. How can I perform this validation correctly in FME? I'm worried that my results are not reliable when using FME for detecting overlaps. Could it be that my configuration in the transformers is incorrect? Which transformer or configuration is equivalent to the intersects operation in ArcGIS?

Hello everyone, please, I try to solve one issue, that Im not clear, if FME is able to do that. Is there any way how to migrate data from VPTK (ESRI´s vector tile package) to PBF file? Thanks a lot! Lubo

Hi all, I’m trying to create a simple script which reads a csv and writes to a point gdb. The CSV files I am trying to read are hosted publicly online but they are failing to open in FME workbench. I’m using a Feature reader to do this (for CSV format, and with the csv URL below), but I keep getting the following error: I am fairly new to FME so I’m not sure if there’s an obvious setting in my workbench that I’m missing here. Thanks!

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. Regards Fred Regards Fred

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 step is lo

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 table Select count(*) as COUNT from TABLE This places the count as a value in a column that is output from the Result of the SQLCreator My 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