FME Form

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

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:

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 warnin

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 "Co

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?

I'm working with some large DTM datasets and am killing my machine with the clients requested settings. I wanted to see if this "Surface Model" file could somehow help me process the data in batch. The documentation looks promising, however, I've not really had much luck when testing it and there are no examples anywhere I can find of how to actually use it properly.

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

Hello everyone, I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. Can you help?

I am trying to read in two separate .dwg files, make changes, assign layer names with Feature Writer inputs, and then output to a single .dwg file. But, the data is not combined and it outputs two files from their respective reader instead.My hunch is that the Feature Writer is seeing different schemas coming in, but I can't figure out how to combine. This is one of those "seems easy, what am I missing" issues..I guess?

Hi,I read an Oracle Database with "esri SDE" connection file. I need to update the reader. We now have a new Oracle table that contain a new column and the datatype of that column is "xmltype". With a Oracle Reader or SQLExecutor, I can read the "xmltype" data. But if I read the data with "SDE", the column is not there. Like SDE don't understand "xmltype". Any idea ?