Skip to main content
  • EN

FME Form

A space to discuss FME Form

27720 Posts
alexandreaalves
alexandreaalves
asked in Transformers
How can I regroup existing several LiDAR classes into the only 4 classes the client needs?

Morning,I have a group of LiDAR point clouds which were classified in several classes.Unfortunately the client only wants the point clouds classified into 4 groups.How can I regroup several classes into the 4 classes I need? Example (class 1-2-3-4-5 to become class 1, class 6-7-8 to become class 2, 9-10-11 to become 3 etc etc)

70
milo89
Enthusiast
2 years ago
Z
zhangjinzhou
asked in General
FME Objects API for Python 2.7

Is there still fmeobjects package supporting python 2.7 in FME 2022.2?I need to run an FME workspace in ArcMap, which uses python 2.7 and realized there is no fmeobjects for Python 2 in the FME installation folder. Is there an alternative way to do the job?

153
boydfme
Contributor
2 years ago
emeka_domingo
Contributor
emeka_domingoContributor
asked in Transformers
FME 2022: Error in Translation after a successful translation process

FME 2022 Workbench is showing 'Error in Translation' after a successful Translation (See Screenshot). The Data Inspector window doesn't open after the translation. Is there a bug in FME 2022 causing this?What can I do to work around this issue?The log file is available on request.

960
gis_midwest
Contributor
2 years ago
S
sofia8989
asked in Transformers
Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement.

Hi,  I am new to FME. I am having below error with one our jobs. I am not sure what is causing the issue because it is intermittent.Today it will throw an error the next day it is okay. *I have remove the structure of my table* 7239 Processing attribute 2 for LEAN or LEAN_AND_MEAN usage7240 Processed 2 elements with mode CLASSIC7241 Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE Projects.[Assets] Provider error `(-2147217900) CREATE TABLE permission denied in database 'TT'.'7242 Microsoft SQL Server Non-Spatial Writer: Failed to create the destination table for feature type `Projects.Assets'7243 A fatal error has occurred. Check the logfile above for details7244 ... Last line repeated 2 times ...7245 2022-12-09 05:03:02| 7.6| 0.0|ERROR |7246 A fatal error has occurred. Check the logfile above for details7247 2022-12-09 05:03:02| 7.6| 0.0|ERROR |

1470
david_r
Evangelist
2 years ago
P
paulbrandtkcs
asked in Transformers
LRS Translation of Events from one measure system to another

I have two separate Route Feature Types and a bunch of Point and Line events. The Route features share a common alignment (on top of each other), but they have different measure values. For illustration purposes, think of them sort of like different units stored in the geometry measures, but without any sort of equation to be able to easily convert between the units. My plan was to overlay the Route sources to get a more granular set of lines with nodes wherever a node exists in either source, and with multiple measures named by the source it came from. Once I have that combined geometry, the event translation should be as simple as generating the dynamic segments based on the first route, dissolve the lines and read the second route measures from the feature, to get my translated event. In the example below, I rename the measures for each source before sending them in to the LineOnLineOverlayer but the output lines only have 1 of the 2 source measures. I also tried Intersector, but th

90
M
2 years ago
nz
nz
asked in Transformers
FME Conversion from MBTiles (Raster) to ESRI FIle GeoDatabase Raster.

Hi Community,I'm trying to convert MBTiles Raster format SQLite into ESRI File Geodatabase Raster. I have run the FME workbench from the above formats (default values) and it has created an output correctly, However the MBTiles contains much greater coverage that the resulting ESRI File. Am I missing some sort of parameter to ensure that all coverage is created rather than just a section of it? RegardsNZ

1110
kailinatsafe
Safer
2 years ago
F
firsttube
asked in General
Read/Update Enterprise Geodatabase Metadata for Each Table in Database

I've created a workbench in FME Database Edition 2022.1.3 that reads the existing metadata of a feature class in an ArcGIS Enterprise Geodatabase (SQL Server), and updates certain components of the metadata based on a table in another database where the feature class name matches the "Name" field in that table. This works for one feature class in the GDB at a time. Is there a way to iterate over all feature classes in the GDB and run the workbench against each one, one at a time? I've tried adding multiple feature classes as a Single merged feature type, and as individual feature types, and it is not updating the metadata as expected. It seems to update the metadata to the same values for all feature classes. thanks

1730
F
2 years ago
jer
Contributor
jerContributor
asked in Transformers
AreaOnAreaOverlayer moves feature border more than tolerance distance

I want to make sure objects resulting from the AreaOnAreaOverlayer are wider than 5 cm. For this I use a Tolerance value of 5 cm. In some situations however, it moves the border of objects more than that value (around 20 cm) where I would expect it would just create an object of 20 cm wide. I'm using FME 2021.1 build 21619. See the attached template for the data, the situation occurs near the red arrow:

72
jer
Contributor
2 years ago
F
frank_herbert
asked in Transformers
QR Code Generator - batch production

I'd like to create a WB that is capable of QR code batch production to a PDF suitable for printing. The input would be a spreadsheet containing the QR codes (text) in a column. I have the QR Code Generator but not sure how to enable it to write multiple codes. Does anyone have experience with this or recommend a B build?

1020
jhawks
Contributor
2 years ago
toin
Contributor
toinContributor
asked in Data
Microsoft SQL Server Non-Spatial Writer: Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. '

I have a workbench that reads features from a table from Microsoft SQL Server Non-Spatial and writes (Feature Operation: Update) into the same table. I have read and write permissions, reading is working fine but writing gets the following error message:Microsoft SQL Server Non-Spatial Writer: Connection failed. <connectionstring>. Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. ' Failed to open writer Failed to open writer f_22(CreationFactory): Failed to open writer I've tried several things, but none of them is working. I've read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and this https://knowledge.safe.com/questions/39002/connection-issues-to-ms-sql.html Our settings in SQL Server: 'Named Pipes' is Disabled and 'TCP/IP' is Enabled. We can enable 'Named Pipes', but the server service then needs a restart (we don't want to restart

1510
jatoxa
Contributor
2 years ago
timnil00
Contributor
timnil00Contributor
asked in Transformers
Unique values in AttributeFilter end up as one value.

We have a unique number 0 and 00 to identify paying customer.I set (0 and 00) in the AttributeFilter but both values end up on either 0 or 00 depending on wich one in the list comes first.What am i missing here? or should i set up a tester instead for each number or text value? /Tim

80
timnil00
Contributor
2 years ago
C
corrag_oslo
asked in Transformers
GeometryReplacer results in linestring WKT geometries becoming points

Hello! I am using GeometryReplacer to convert a CSV file with a column containing WKT geometry. The column in question has the name "GEOMETRI, LINJE" and contains a linestring. When using GeometryReplacer, the result is a point with a point that seems to be the centre point of the coordinates of the linestring. As an example, the string LINESTRING (280696.375713613 6653063.17617913, 280698.536236071 6653059.93539544, 280707.427616957 6653067.91270913, 280704.353027305 6653070.5718137, 280696.12642256 6653063.17617913) converts to a point with coordinates 280701.671, 6653065.356, neither of which appears in the original linestring string. The coordinate system used is ETRS89.UTM-33N, which I set using a CoordinateSystemSetter before the GeometryReplacer. All of the LINESTRING () WKT-geometries become points. Does anyone have any insight as to why this happens and what I can do to make sure that GeometryReplacer produces the expected linestring instead of a point? Thanks!

1210
C
2 years ago
R
rimberd
asked in Transformers
Hello! I am new to FME and hope you can help me. I was trying to translate from citygml to .imx format and received an error. How can I solve it? check details. Thank you

 IMX Writer: Detected in invalid table names 'RoofSurface'. This writer expects only specific table names. Please add a new IMX writer to see the valid table names I guess it has something to do with the original tables from my citygml. but how to tackle this issue? 

150
F
2 years ago
aron
Contributor
aronContributor
asked in Transformers
Workaround to run LineCombiner in Group mode? (OR condition)

I would like to combine lines on the attributes in column A OR B OR C and so on. The "combine on attributes" is an AND condition. What would be the cleanest workaround to achieve this?

90
M
2 years ago
K
ktmoynahan
asked in Transformers
I want to create slope from DEM using Raster Slope Calculator, the transformer won't give me the new "band 0" values.

When I run the tool the "Band 0" values are staying the same after the reprojection transformer is run, any tips to get the new values for "Band 0"?

100
kailinatsafe
Safer
2 years ago
lau
lau
asked in Data
Oracle Spatial Reader : All spatial filters failed... FME 2022.2.

Hello,After migrating to FME 2022.2 (desktop and server), I get errors on each workspace that uses Oracle Spatial FeatureReader with a spatial filter:I tried these workspaces on FME 2022.0 and everything works fine...I don't really feel like reinstalling another version of FME Server, so any solutions/workarounds are welcome :)(Using spatial SQL queries instead of FeatureReader is not an option)

170
lau
2 years ago
dbryantgeo
Contributor
dbryantgeoContributor
asked in General
FME Server does not think the source file for FileCopy Writer is a file

I have a workbench that uses the FileCopy writer to move and rename an uploaded excel sheet, this works well when testing through desktop but when run via FME Server (the file is uploaded into a parameter) the following Warning is thrown and the file doesn't get moved; 2022-12-8 13:48:54 | File Copy Writer: Ignoring the destination filename 'DummyFile.xlsx' because the source dataset '""C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\upload\\Data Updates\\Geo-CustomerServices-TradeEffluentImportToSQL.fmw\\dbryant\\DummyFile.xlsx""' was not a file. Destination file names are only used when the source dataset is a file Is this a known limitation of FileCopy? I could use a SystemCaller and/or Python to get the same result but equally feel that this should work.

690
dbryantgeo
Contributor
2 years ago
M
mikefrommaine
asked in Transformers
How do I create geometry features from input attributes?

I see how I can create a geometry using a creator where I can specify the geometry parameters. For example, creating an Clothoid by specifying Start X, Start Y, Direction etc. But these are all values that must be hand entered. How can pass these values into an "inline" Creator to set the geometries accordingly? I see 2DArcReplacer etc but not one for Clothoids. Is there a GeometryReplacer of sorts that would let you specify the type of geometry desired and which incoming attributes to assign to the relevant Geometry Parameters?

190
david_r
Evangelist
2 years ago
S
stevensrf
asked in Transformers
I need to convert a csv file into a shapefile in a .Net 6 windows application. I am looking for some assemblies or source code that does to use in the application. Does FSE provide such assemblies or have source code that can use the does this?

I need to convert a csv file into a shapefile in a .Net 6 windows application. I am looking for some assemblies or source code that does to use in the application. Does FSE provide such assemblies or have source code that can use the does this?

60
david_r
Evangelist
2 years ago
A
aburowah
asked in General
Convert Quick Capture Latitude and Longitude

How to convert ArcGIS Online Quick Capture Latitude and Longitude coordinates to a projected X and Y coordinates?

70
egge
Contributor
2 years ago
thijsknapen
Contributor
thijsknapenContributor
asked in Transformers
Advise on efficient workaround for writing Esri ASCII GRID file with a specific decimal accuracy

Hi, This question is linked to a previous question I posted on the community, about the number accuracy of the Esri ASCII GRID writer of FME. Please see that question for more details and screenshot, but a quick recap of it; when I created a dummy raster with Real32 interpretation, in which an original pixel value would be '0.0250313',the rounded pixel value would become '0.025',but the Esri GRID File seems to convert to Real64 interpretation and stores the value as '0.02503128908574581',whereas I would like the rounded value '0.025' to be written to the file. I noticed that this could save up to 50% in the file size. I suppose that this item is related to the Floating Point Precision and String Formatting in FME. Now I have been investigating some options for an efficient workaround to this question. I.e. to be able to create Esri ASCII Grid files that don't write out pixel values with 16 decimal values. I came up with two methods, but I think they

340
thijsknapen
Contributor
2 years ago
tcronin
Contributor
tcroninContributor
asked in Transformers
In the Translation Log, it shows ArcMap 10.8.1, how do I change that to Pro 3.0.3, basically how do I move off ArcMap.

In the Translation Log, it shows ArcMap 10.8.1, how do I change that to Pro 3.0.3, basically how do I move off ArcMap.

70
egge
Contributor
2 years ago
paul_m
Contributor
paul_mContributor
asked in General
How to create a count that changes based on preceding empty values in a dataset?

I'm trying to create a count that changes whenever it sees an empty row in a dataset. For example, I have the first 3 columns and would like to create a column similar to Test2 (see image below) that has a new count whenever there is an empty value in Test in the preceding row. Any ideas would be greatly appreciated!

90
paul_m
Contributor
2 years ago
mlufkin
Contributor
mlufkinContributor
asked in Authoring
FME Server 2020.2 - Filecopy used in Data Download App not using Zip file structure as set in Desktop

I recently upgraded my FME Server (to 2020.2.4) and the unwanted file hierarchy for FileCopy output datasets in Data Download Zip files have returned! I now have an additional folder (called FILECOPY_1) in the output zip from a Data Download Service on Server. I've updated the Writers in Desktop (2020.2.4), but the edit functionality (Publish --> Edit Register Services --> More) seems to do nothing for the structure of the zip file for FileCopy outputs anymore after publishing (the old way is outlined here: https://community.safe.com/s/question/0D54Q000080hM9QSAU/how-can-i-change-the-folder-structure-returned-in-the-zip-file-from-fme-servers-data-download-service). I this a known bug, and is there a fix please? Many thanks!

7812
gis_midwest
Contributor
2 years ago
michiedem
Contributor
michiedemContributor
asked in Data
Why can't I open this Netcdf?

simple question: Why does reading this netcdf fail with any (combination of)setting(s)? It works fine in Qgis https://www.ncei.noaa.gov/data/international-comprehensive-ocean-atmosphere/v3/archive/nrt/ICOADS_R3.0.0_1750-07.nc

180
michiedem
Contributor
2 years ago

Badge winners

Show all badges
30,469
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.