FME Form

Hello all,I would like to know about the difference between the count of values of one column initially while reading and count of values of the same column after filtering. If difference between the count of values is same then ​we will send an email. so how can we achieve this in fme

Hi, trying to manipulate points components in a points Cloud with PythonCaller to make some calculation but can't find any method to reach components like classification or user_components. Is there any way to make it? Thx Nicolas

Hello, I would like to transform LAS files to LTF files using FME. I read that LTF format isnt supported in FME unless i install Leica Geosystems TPS Reader extension. Can someone tell me how to do that? thanks

Some features got invalid when using FME File Geodb Opeam API to import to PostGIS, while they are valid using the GDAL OpenFileGDB.  These features are arc circles. When using FME File Geodb Opeam API, these features become NAN, eg with some coordinates being null. Is there any way to fix this issue when using the ME File Geodb Opeam API to import to PostGIS?  

If I use a PostGIS Reader, to inspector, on a table, it shows the geometry. If I use a SQLCreator using POSTGIS format, doing a select * from same table, it shows fme no geom, is that normal for a SQL to not show the geometry ?

Hi,I´ve created a point-based dataset which includes an attribut (value, distance in meter from the point to a school using OSM routecalculation). I now want to create lines between the points with the highest value (if that makes any sense) adding up to some kind of "service area" to the school (how much area does the school cover if the distance is max 2500 meter). Is that possible and if so, how can it be done? Regards Christian

In SQL, it's possible to select all your data starting with "2023" like this : -------------------------------------SELECT *FROM mydataWHERE date LIKE "2023%"--------------------------------------Is there a way to do it with FME? I have already apply a "DateTimeConverter" to convert my data in FME format (20230223). I see on FME Workbanch that there is a "SQLCreator", but I need to import my data from a url and not from an DataBase like PostGIS

Dear members of the FME community, I am currently facing an issue with my FME workbench 2020, which is running on FME Server 2020. The workbench includes an Excel Writer (latest version) that fans out data into multiple sheets within a single Excel file. This process has been functioning well on a weekly basis for the past two years on FME Server 2020. However, when I attempted to run the same workbench on FME Server 2022, the output was split into two Excel files instead of one, with the data divided between them. Additionally, the file naming convention in FME Server 2022 has changed, with the file name split into two halves, one for each file. For example, in FME Server 2020, the correct file name for the output would be "20230101_filename.xlsx." However, on FME Server 2022, the file name has been split into two parts, resulting in two separate files named "20230101_.xlsx" and "20230101_filename.xlsx." I would greatly appreciate any suggestions or poten

I had a solution to this problem using a FeatureJoiner and a Test Filter that worked for smaller data sets (previous solution below). But my datasets have grown and this process is too slow now. I tried InlineQuerier but couldn't achieve success. I suggestion was to write a python program to do this but I am not experienced enough with python.  Is the a way to join to tables as described in the title of the message?  https://community.safe.com/s/question/0D5Dm000006cuXDKAY/categorizing-data-based-on-external-table-with-unique-lookup-minmax-values

Please can someone help me to group points and assign a unique ID to each cluster? I have a large feature containing several groups of points taken from a line (see attachment) but I would like to rebuild the line and make sure they don't all join up together.So far, I am using a vertex extractor to break the line into points. I have played around with neighbourhood finder and it's telling me the distances between points in proximity, but I need to group them to result in something like the attached image.Thanks in advance

I'm working with American Community Survey (ACS) data and would like to rename the attributes in a demographic table with the corresponding values in the metadata table but I'm at a loss. This seems like something that should be less complicated than I'm making it so I'm looking for any thoughts or guidance. 

Hello everybody I want to know is there a way to convert my 3D shapefile to a 3d tiles cesium ( I don't know if I should transformt it to citygml then 3d tiles cesium) and if there is a way is there a workspace to do so. Here is my shapefile

When I add a shapefile reader or DWG reader in the same manner, it takes very little time to navigate my way to the shapefile location. I do not understand the difference. If they all took the same amount of time I might conclude it had something to do with my directory structure.

Hi,We have noticed a difference of behaviour in the GeometryValidator transformer in FME 2020.1 and 2021.2 without upgrading the transformer. A sample geometry in WKT : LINESTRING (45.02687462450092 0.06721615791320801,45.025979838437365 0.06841778755187988,45.02593434046724 0.06878256797790527,45.02601017039738 0.06899714469909668,45.02638931854123 0.06853580474853515,45.02621491070693 0.06806373596191406,45.02639690147848 0.0685572624206543,45.02660922331399 0.0685572624206543,45.02700353320486 0.06818175315856933) The transformer is configured as such :And we have the following results in FME 2020.1/2021.2 :In FME 2021.2, the geometry fails OGC Simple while it doesn't in FME 2020.1. One of the issue with that, is that the geometry is being repaired in FME 2020.1 but not in FME 2021.2. I have noticed that version 8 of the transformer made the OGC checks stricter, but the transformer was not upgraded and is still at version 4. Is there any way to restore the old behaviour?

I have two shapefile data, and one label which I created through MapTextLabeller. I have then in DataInspector the view with these 2 shapefiles and text above them. The question is can i generate raster tiles from it, and store it as GeoTIFF?

I have a workbench script that makes multiple ggplots (graphs) for end-user reports. The Rcaller works great in FME Server without error, but it will not export the plots. The output excel files export, but not the plots.

I would like to combine 2 datasets: one containing about 500 monument_id's and one with about 20 types with scores and remark fields that should be added to this monument_ids (to create a list of about 10.000 items).  As there is no attribute value to match (so FeatureJoiner or ReatureMerger doesn't work); can these somehow be combined based on predefined matching attribute names? Or what would be a good idea in this case? Thanks in advance!

Hello there are vertex at equal distance (0.100) but these are unnecessary, only one vertex in 1m is enough. How can I remove the vertex in between, I looked for vertex remover, but I think I am doing something wrong, can you help me please? Additional information: There are always 10 vertexes in 1m.

Hello, couldn't really describe the problem in the Question field but to sum it up, I have a table of X/Y/Z that represent contours (see on photo)Meaning that between the "*" there is an independent contour, first one having 5 vertices, next one having 7 and so forth. Now I want to enter these vertices into a contour generator, but in the way that that Transformer creates separate contours from the "*" grouping, instead of a whole binge of criss-cross connected lines. Probably best way to do this would to give each vertex group a common ID and then run contour generator with Group by "ID". But how on earth do I group based on the logic:if X is within two * then it belong to the same group, then after the latter * there is a new group with a seperate ID and so forth? -Please send help :D

I have been asked to convert network vector data to raster tiles using the MBTiles writer. For my specified dataset zoom levels 5 - 10 have been requestedProducing this hasn't been an issue but the problem is that the requestor wants a single MBTiles file and my workspace outputs 313, the number of rasters generated.How can output a single MBTiles file that still contains all the zoom_level, tile_column and tile_row attribution required to use the raster files in a leaflet map?   

I try to use the new CSW Reader.  At the moment i only get the summary version of the metadata. I´m looking for a way to set the get-Parameters, so i can specify:&resultType=results&outputFormat=application/xml&outputSchema=http://www.isotc211.org/2005/gmd&typeNames=csw:RecordMaybe some of you has an idea. best regardsandylicht

We are currently using FME to run the process to convert GDA94 Zone 55 ( EPSG : 28355) ECW file into GDA2020 Zone 55 ( EPSG : 7855) , the output ECW was projected to the right location, but the CRS was not recognized by QGIS or other GIS platform. I have the FME bench as attached for your reference, could you please let me know if I missed any configuration settings or should use different transformer?

I'm trying to run a python shutdown script and get this error - "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9', which requires an appropriate version of ArcGIS Pro or ArcGIS Server" I've also tried calling the script from cmd line and get this in the engine log - "Thu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6   File "createaprx.py", line 9, in <module>Thu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6    import arcpyThu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6   File "C:\\Program Files\\ArcGIS\\Pro\\Resources\\ArcPy\\arcpy\\__init__.py", line 77, in <module>Thu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6    from arcpy.geoprocessing import gpThu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6   File "C:\\Program Files\\ArcGIS\\Pro\\Resources\\ArcPy\\arcpy\\geoprocessing\\__init__.py", line 14,

I am trying to project a .ecw file from LL WGS84 to a custom local coordinate system. Using the ESRI reprojector I am able to select the custom output coordinate system (it is Nad27 UTM feet) and the proper geographic transformation. The log file of the result seems to indicate that the process is using the correct parameters, however the resulting dataset is UTM meters and has an EPSG 26717 code (even though I explicitly set the parameter to 'Never use EPSG code' for the projection). It seems to always revert to ecw format of 2 so I'm not sure if this has anything to do with it. Many thanks for any assistance.

Is there a way to convert an fgdb point file with attachments to sqlserver? Should the photo attachments be stored outside of sqlserver in a separate file? I can convert the point file but how to handle the associated attachments is the problem. thanks