FME Form

Has anyone worked with spatial indexing using GDB/SDE as output format? The spatial indexing function only appears for SQL Spatial formats. Any response is very much appreciated. Thank you!

I tried to create a global temp table in an SQL database to bypass limited database privs. Here is my FeatureWriter setting:No errors were given, but the temp table was not created on the SQL server tempdb. I tried using the fully qualified name tempdb.dbo.##MyTempTable for example to no avail. Appreciate any suggestions! 

I have an FME workspace in which input from an DWG file is read and exported into an FGBD file. I am using a dynamic FeatureWriter. For the layers, this has the following result: If there is a layer named 'xyz', and this layer contains e.g. text, line, and point features, the FGDB writer will create three layers 'xyz_text', 'xyz_line', and 'xyz_point' for the features. Is there any possibility to tell the FGDB writer to group the layers such that in e.g. ArcGIS Pro, all the layers 'xyz_text', 'xyz_line', and 'xyz_point' are already grouped below a parent layer/group layer 'xyz'? Or is this something which necessarily has to be achieved by another tool, e.g. using ArcPy?

hello, I'm having several java.lang.NumberFormatException: warning when writing to MS Azure SQL database. It does not prvent the workspace to run properly however, it create a very long log file with hundreds of thousands of warnings. Is there a way to correct that so that I won't have such warning anymore? Thanks

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 I have no idea ,how to build pdf as data model to make it easy to show all tables connected together fme 2021  

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

Unable to use Windows/IWA to login to FME Server Web Interface. Have followed all the steps, ensured the SPN is correct, ensured the service account is set correctly, done all the browser checks, and confirmed the Tomcat properties are right.Going to the URL <server name>/fmetoken/sso/generate throws a 403-Forbidden with a description "The Server Understood the request but refuses to authorize it". Going to the URL <server name>/fmetoken allows me to generate a token by using userid only. Adding the domain to the front of the username causes the token generation to fail. So it appears that it's something tied to the domain and how the users credentials are being passed but that leaves me unsure of how/where I missed a configuration that strips the domain during passing of the credentials in order to get a good token returned.Here is the message that appears when attempting to login:Here is the message from the sso generation

I get status 502 when trying to publish a workspace to FME-server. The script works perfectly fine when running it locally on my computer. Have tried searching but can't seem to find any helpful information. What could be the problem?

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 !

Hi, If using the ESRI ArcGIS Portal (web connection using single sign on) reader. If your password changes on your account does this mean the reader will fail unless you re-authenticate or will no action be required?

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 warning- Skipped 2864 features that w

i am currently working on a task, extracting geometry from IFC file and point cloud and building solid meshes and compare them getting the differences. but as I use generated point cloud solid meshes and IFC solid meshes from IFCwall IFCdoor IFCwindows and IFC Column. but the geometry is always invalid when i put them in to CSG builder. how can i compare difference of two big geometry and what kind of geometry accept CSG builder ?

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

I try to make a custom transformer to do linear referencing of point features to a maximum of 10 polylines. Inputs are point features and polyline features with or without measurements. The custom transformer would output a list with the combination _kp{0}.KP, _kp{0}.DCC, _kp{0}.selectedRoute. The KP is the distance along the polyline, DCC is the perpendicular distance to the polyline (negative values on LEFT side of the polyline, positive on the RIGHT side), and selectedRoute name is the name of each polyline. At the end of the custom transformer FME shows the list being created for each feature, but it can not be used in the attributemanager following the custom transformer.

I am feeding all feature services in an ArcGIS Online group into a FeatureReader. I don't know the services or their attributes ahead of time. I can read all the records from these feature services but how do I dynamically expose their attributes? I can see them in an Inspector so they are there. I want to compare each feature service and its attributes with a corresponding feature class and its attributes in an SDE geodatabase.

Hello ,i am struggling with get the relationship between classes .i have Exported xml from arc catalog and I would like to find the relationship between classes .I have used the workspace here https://community.safe.com/s/article/geodatabase-xml-workspace-document-schema-readerlist exploder for data element ,I have chosen relationclasses but it seems for me , it does don’t show all relationship classes with others ( some are missing ) My target to find name of feature class and the feature classes related to it FME 2021 please if someone has sample workspace ,I will be appreciated .Thanks in advance

I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly:  But when I connect the joined output to the geodatabase writer no records are written to the feature class in the file gdb and I get an error saying "Cannot write a non-area feature to an area feature class": I have tried both Drop and Create and Truncate Existing for Table Handling.  Any suggestions are greatly appreciated.

Hello, I'm trying to convert datetime format with SchemaScanner dynamically but I haven't been able to. I have Oracle tables (thousands) and am trying to migrate the data to Google BigQuery.Since it's nearly impossible to create an individual reader for each table and the corresponding writers, I'm using a dynamic Oracle reader and a dynamic BigQuery writer.In the data migration process, I need to convert datatime from Oracle to a different format so that BigQuery can ingest the data. When I was researching for an automated way to convert the datetime data, I came across the SchemaScanner transformer which in theory can detect datetime columns and convert the format dynamically. I've tried to place a SchemaScanner between a dynamic reader and a dynamic writer but it doesn't seem to do anything.In the "Date Handling" section of the SchemaScanner Parameters, I chose "Convert Input Date Format to FME Date" and I chose "Yes" for "

The ESPG library contains some reprojection methods. Is there an easy way to import a reprojection method from the ESPG library? For example, can you copy the text from https://epsg.io/8450 to create a new reprojection method in FME?