General

I don't understand why I'm getting a failure to transform the projection system and save it in another format.jpeg - ecwundefined - 25830 

Is there a way to copy to excel user attributes table? I need to reproduce the table of writer attribute names, data type, width, value, precision. Figured there must be a way to extract those fast? 

Have and excel spreadsheet, roughly 90 mb, if II make a workspace that simply reads that excel file and writes it, the size of the written excel file by FME is about 179 mb. I am just using the defaults on both the reader and writer. If I open the file in excel and clear all cell formatting, and save, it drops the file size down to about 109 mb. Any Ideas why FME is writing a file that is almost double the size of the source file? and is there any way to clear out any formatting, assuming that is where the bloat is coming from ?

FME training and tutorials appear to be a 'spatial first' - ie they assume that any new user wants to work with spatial data. But FME is fabulous for non-spatial data as well and this spatial-first approach is overly complex and off-putting for new non-spatial users. Does anyone know of any introductory tutorials, videos, etc that teach new users how to use FME without dragging them through complex (and irrelevant to them) topics such as spatial formats, coordinate system, geometry processing algorithms, etc?Thanks

Greetings,My Spatial Transformer is not working, none of the records are captured.The ListExploder fails, the error message is: MISSING_PARAMETER_LISTAny advice to capture the List?? ThanksClive 

How can I calculate in FME the mean amount of a layer in a given distance (from another layer)?

Hello , i have many excel files and each excel file contains name of table and name of relationships table .some of relationship tables are common in different excel files .i would like to create pdf and draw the relationships of all tables in all excel files as example :at one excel file contains :First column table name : Product Second column contain relationships tables : table Name | relationships tables product |xx |yy |zz |kkAt Second excel file table Name | relationships tables client | cc |zz |aaAt third excel file table Name | relationships tables big |xx |bb |yy |ffmy target to create pdf and connect all table names and relationships table together

Hey there. I'm going through the FME academy course on becoming a certified desktop & server professional and I'm running into an issue with the training when I get to exercises. My organization only has FME 2019 since that's what our server is currently running in, which means that whenever I download an exercise the format is for newer versions of FME (2022+, I believe). Some transformers are preserved whenever I open the files, but others are not (AttributeManager is always incompatible, for example). Are there ways to access older modules for the same course that I can use, at least when it comes to the exercises?  Thanks!

 The  excel "xml spreadsheet 2003" based on SpreadsheetML (XML schema for Microsoft Office Excel 2003)

Source

I tried to create an Oracle DB connection under Tools>>FME Options>>Database Connections, but every time I test the connection, I get the following error that is attached. Please assist. Thank you. BTW this is using FME Desktop version 2022.2.

I have been trying to merge two PointClouds however one of them is clipped version of the building and I wish to pass a component from it to complete PointCloud dataset.  They are unable to be merge and when using only 2 coordinate system it produces DupplicateSupplier. I have tried changing them into individual points however the clipped PointCloud dataset is being <Rejected>. The clipped version of the PointCloud is also slightly shifted from original full building PointCloud. Does anyone know why its yielding DupplicateSupplier and how I can resolve this?

Hello ;I would to read the content of ddl file .hoe could I open it by FME ?please ,if there is sample workspace .i will be appreciated.Iam not good in Python to do it .i hope , if someone help me to open the file .FME 2021 thanks in advance

Hey,I'm trying to download photos from ArcGIS Portal. I enabled attachment and use the RasterReplacer. I get an error though. fme_rejection_message (string: UTF-8): @GeometryFormat: Failed to read feature.  The error was: 'An error has occurred. Check the logfile above for details' fme_rejection_code (string: UTF-8): INVALID_FEATURE_CANNOT_READ_BLOBEverything works good on ArcGIS Online. Any idea why? Thanks !

I have a workspace on FME Desktop that has a few feature writers. This workspace was built using FME 2020 but we recently upgraded to FME 2021. There weren't any issues running it until I saved the workspace with FME 2021 with no back up.  Basically, it seems that the 'User Attributes' tab disappears in FME 2021's FeatureWriter. For context, the tab is there until I specify that I want to do a filecopy. I've tried many workarounds but it seems like I can't connect the 'source dataset' to the writer no matter what I do, because the previous 'user attributes' that I've built into the workspace no longer exist. My feature reader is also reading a bunch of different attributes, and I need all of these attributes after the FeatureWriters, so using a file copy writer is not a good solution.  Has anyone encountered this problem before, and how do you get the FeatureWriter to work in this case? I keep getting the warnin

hi, how to round values, for example: 5.1 = 6, 7.8 = 8 and so on... Thank´s

how generator snowflake id, use FME desktop,  uuid generator result is long 

Hi all. I currently have a workspace that simply downloads some data from a SQL server, puts it threw some geometry checks and then finally uploads the .gdb to an S3 bucket. I would like the final output to be a zip file rather than the .gdb but cannot get it to work. If i change the final output in the S3 connector a zip file is created but it is blank. Any help would be greatly appreciated. Here is a screenshot of my process: 

Hello fellow forum members, I am currently facing an installation issue with FME Desktop on my Intel Evo laptop [https://www.lenovo.com/ca/en/faqs/intel-evo/] running Ubuntu 20.04.1, and I am reaching out to seek your valuable insights and assistance. I have been trying to install FME Desktop, a powerful data integration and transformation tool, but I have encountered some challenges in the process. Here's a brief overview of the problem: After downloading the FME Desktop installer for Linux from the official website and following the installation instructions, I am unable to launch the application. Whenever I try to run FME Desktop, nothing happens, and there are no error messages or indications of what might be causing the issue. I have checked the system requirements and ensured that my Intel Evo laptop meets all the necessary specifications for running FME De

We have a workspace in our cloud that pulls data from our own api.We do one get call per table/api endpoint in parallel, and have about 10 httpcallers that run at once. We are finding that when we reach about 750mb of data in transfer, we get failures. The last table before failing looks like it has a very small amount of data, when in reality it has a significant amount more (see Containers in the logfile).Is there a limit on transfer size in FME? We figured we could try offsetting each call but it's strange that it just fails. I can provide more details but thought I'd start here. Message is "An error occurred while accessing the url"...Note, pulling any table individually through the api is perfectly fine...Pulling all at once through the API causes this error when we reach about 770mb + of data being transferred.... 

As the directions in this topic detail: https://community.safe.com/s/article/Using-a-private-SSH-key-with-FTPCaller-to-authenticate-an-SFTP-Connection-on-FME-Server-and-FME-Desktop I am using a SystemCaller to launch Pageant and load the private keys so the FTPCaller can successfully authenticate a SFTP connection. This is working great in FME Desktop. However, when I load the workspace to FME Server, the SystemCaller just hangs. I have gone the extra step of even loading the keys in Pageant on the server, but still didn't help. Is there something extra that I must do to get this process to work on FME Server? I am using FME Desktop and Server 2022.1 Build 22618.

I am trying to create Mbtiles Raster layers with specific coloured layers and also labels and popups. Is there any way of doing this within FME as I can't find a way to?

My question is quite simple but I am a new user in FME. Well, I am going through this process in FME workbench to find percentage of land cover classes excluding water bodies.​General process:1- Using selected land cover Shapefile and only consider Grassland (class 30) and cropland (class 40) classes​2- Using selected tiles to extract the percent of targeted vegetation (grassland+cropland) referred to the whole classes except water(class 80)​3- Select tiles having at least 1% or 0.5% of the targeted vegetation. For info, 1% corresponds to 10 000 ha​Below, you can find my fme workflow that it does not work for percentage calculation.​I thank you in advance for your guide and feedback.

I am reading several GeoTif and line features from a PostGIS table. To make life easy I added the RasterMosaicker and linked the mosaic to the PointOnRasterValueExtractor. The line features from the PostGIS table get their vertices densified, and I extract those using the PointVertexReplacer from FME Hub. Since the coordinate systems of the data do not match I use the EsriReprojector for the points to have them as well as the mosaic in EPSG: 4326.Now, when I run the PointOnRasterValueExtractor the output points do have _band{}.value and _band{}.palette{}.value. I expose _band{0}.value since the mosaic only has one band, but each and every point is missing the value. I used the Data Inspector to visualize the points on top of the mosaic, and everything lines up. Why do I not get any values from the PointOnRasterValueExtr

How to let this arcpy code in Python caller work my input type is ArcSDE Esri the target here to get the list of relationships of classes between eachother and save the output in csv  i am not familiar with Python ,what should I add and change here to let the code work in pythoncaller and write the  output in csv fileimport os, pprint all_rs = listRelationshipClasses("path/to/your/database.sde")  # see above pprint.pprint(all_rs[0]) # filter by namers = [r for r in all_rs if r["name"] == "FilterName"]rs = [r for r in all_rs if "PartOfTheName" in rs["name"]] # filter by cardinalityrs = [r for r in all_rs if r["cardinality"] == "OneToOne"] # filter by origin or destination tablers = [r for r in all_rs if "OriginTableName" in r["originClassNames"]]rs = [r for r in all_rs if "DestinationTableName" in r["destinationClassNames"]]rs = [r for r in all_rs if "Or