FME Form

I tried pasting my SQL command in the feature reader, but it keeps bringing in everything from that database or schema.

Hi All, I have a record with these attributes: ID, Condition1, Condition2, Conditon3. Condition values are integers. I want to write to an new attribute the name of the Condition attribute with the highest Condition value. IE if records is ID =Bob, Condition1 =20, Condition2=0, Condition3=80 then write out 'Condition3' to my attribute.  I have created a list, sorted the list then used listindex set to 0 which returns highest value but not the attribute name from where it came from. Any help appreciated @takashi Thanks Steve

I'm able to create a point shapefile successfully.

What happens when you score a 78 in the proofessional certification exam

Due to certain circumstances, primarily due to a limitation within ESRI, I find myself in the situation where I must retrieve data from my database not directly via the sde reader, but rather indirectly through the postGIS reader. Despite encountering various challenges along the way, I managed to surmount these obstacles. However, the primary issue I currently face involves the resolution of domains in my output. Naturally, the postGIS reader does not offer an immediate solution for this matter. My consideration was to take an alternate route, yet I am encountering difficulties here as well. My proposed approach involves extracting information from the domain tables and subsequently configuring it using AttributeManager. Regrettably, I am unable to locate the domain tables within postGIS. I hold the belief that these tables must exist within the postGIS setup, albeit their exact location eludes me. Any form of assistance in this matter would be greatly appreciated. Thank you for your

import os def get_excel_file_paths(folder_path):  excel_file_paths = []     for root, dirs, files in os.walk(folder_path):    for file in files:      if file.endswith(".xlsx"):        excel_file_paths.append(os.path.join(root, file))           return excel_file_paths folder_path = "/path/to/my/folder" ----I have a list of folders in a csv file which i read into the workspace so i plan to use that attribute hereexcel_paths = get_excel_file_paths(folder_path) for path in excel_paths:  print(path) Having troubles converting this to run in fme Thanks!

Getting this error message : "Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details FME version installed : 2021.2.6ArcGIS Pro installed 2.9.0 Triggering using the command as shown in the screenshot, but it fails with above error message. Any ideas pls? 

I have an Excel spreadsheet that contains 2 columns, 1st column is called Terms, 2nd column is called Definitions.  What I want to do is convert each flashcard pair (4 rows) into multiple choice questions via GPT3.5Turbo. The problem I'm running into is that while OpenAIChatGPTConnector  takes in the data just fine, it is only outputting 1 pair (The last row). How can I work around this? 

I have used FME 2022.2.5 to write datetimes with millisecond accuracy to a Geopackage. But when I try to use the same FME and a FeatureReader to read the datetimes from the Geopackage I get truncated datetimes with second accuracy.  When I use the SQLite format in the FeatureReader when reading the features, the datetimes include millisecond accuracy.  I have inspected the Geopackage using DBeaver and there I can see the datetimes with milliseconds and the type is DATETIME. I would expect FME to be able to read DATETIME's from a Geopackage file with millisecond accuracy, but that might not be the case? Regards, Casper  

I have an AutoCAD DWT template file and I would like to extract all of the layer definitions (e.g. line style, weight, colour, etc.). The DWT file does not contain any objects (i.e. no lines, points, blocks, etc.), so FME does not have any features to process. Is there any way that I can extract the layer definitions?I've tried using the schema reader and I can use that to get all the layer names, but not the associated linestyles, etc.My end goal is that I need to validate supplied CAD files against the standard layer definitions defined in the template file and I was hoping to extract the template layer definitions into a spreadsheet or database so that I could use that to do the validation. Perhaps I'm going about this the wrong way? Is there a way that I can use FME to validate that a DWG matches a template DWT definition?

So, in the "List" table, I have, as far as I've seen, some duplicate entries. For example, in this image, rows with ID 2404 and 2405 are duplicates of IDs 1 and 2. I believe I have duplicate entries for all lists like that. Could someone help with how to solve this, or rather, how to delete duplicate entries?In the "RecordBoundaries" table, I must not have records with the same ID. I should do the following only for duplicate IDs because they belong to the same document: for example, let ID_Record 357 be one record, and the "creation date" is always an older date (January 1, 1861), while for the "confirmation date," the attribute from the duplicate record should be used (January 1, 1863). So, the process should be done only for duplicate IDs because there must be one record each for themselves.P.S. I have attached both files, "Popis" and "ZapisnikOmedjivanja," so you can immediately try with them and send back the edited f

Hello, I need to update the location of a point in an SDE database from UTM's. Is there a way to write an updated location to the Shape* field? Thank you.

I am working as a consultant for Consortech Solutions and I have a client who is trying to make his G3 Smallworld connection work in FME using the SBS Plugin for Smallworld. Unfortunately, the reader in FME doesn't work all the time. When it fails to show the table to choose from for reading data using the SBS plugin for Smallworld reader, the error message returned is "Bad or Invalid License for feature: spatialbiz_read [-12]". What's weird is that sometimes he is able to read his data in FME using that same reader but sometimes it fails to read the data.  Is that something people have experienced in the past and if so, is there a way to solve this issue?

I have 200+ shapefiles I would like to read in and merge into a single fgdb feature class. Some of the shapefiles have slightly varying schemas. Is there an efficient way to read them all in at once and validate if the schema is the correct format I would like? Rather than going through them one-by-one?

Hi all,I'm new to AIXM data but I'm facing the challenge of converting GIS data to AIXM 5.1. I am beginning to understand the structure and complexities of the model and I also went through the article and FME template that is online here. I can write out the desired structures but I can't write geometry. It seems it expects an attribute called part{} for the geometry. I have tried different variations of renaming and extracting the geometry.  Edit:Theres's an example of writing to FILEGDB to AIXM and back in this webinar, but the workspace itself isn't available anywhere. https://www.youtube.com/watch?v=3KW0Bj01Wj0&t=960s&ab_channel=FMEChannelWould it be possible to share this AustriaObstacles filegdb to aixm workspace? Any pointers would be greatly appreciated!Thanks!

Recently I tried to write a few million non-spatial features to a Hyper writer. At some point (around 11.000 features) in committing the features to the file (create if needed on a new non-existent file) it errors. With the debugging option in the log I was able to figure out that a 'COPY-IN' statement is executed I think.When I look at the documentation https://tableau.github.io/hyper-db/docs/sql/command/ no such statement is supported. Am I correct here?  Features per transaction is set at 1000. Bulk insert: Yes. Changing these makes no difference.  When limiting the features that pass to the writer it will write the file correctly. Like say about 50.000 no problem. I am using FME(R) 2022.2.2.0 (20230106 - Build 22782 - WIN64) Is this a bug? Should I upgrade to a newer version? RAM is not a problem, disk space isn't either.

I encountered something a bit weird. In a bit larger workspace I wanted to apply parallel processing for part of the workspace, so I embedded that part of the workspace (which already contained some custom transformers) in a new custom transformer. Then however I obtained some issues with the parameters, it seemed that they were not passed on correctly. Attached is a workspace where I replicated the issue. It's just a dummy workspace that connects to an Oracle DB, and (aims to) return the static result; 'Greeting' = 'Hello'. Main;CT_0;CT_1;If I run the workspace with a database connection named 'My_DB_Schema (1-O) @ dev', I obtain an error;Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`<serverType>', serverName=`My_DB_Schema', userName=`', password=`***', dbname=`') Although this issue occurs with a Database connection parameter, in my main works

Hello, I am using the sqlexecutor and I am populating the attributes to expose from sql query. It correctly displays them but there is a (ok) button missing to add them successfully. When I close the window (x), they won't be added.

Hey FME Users, There is a lot of information in and around OSM on the forum, but can we add OSM as the background map in Data Inspector?

Hello , How to solve self intersection ( p-case ) ?i would like identify which lines has p-Case and solve this problem ?as example I have a line with specific id starts at point and closed back at the same point .Will be possible to let the line to cross this point and no intersection at start point ,if it is possible .Thanks in advance .FME 2021

I have been tasked to set up an automation that will FTP a file from a State-supported site to our network.I have been advised to use the FTPCaller transformation to achieve this. I have the specifics to the State-supported site and, using WINSCP, can manually download the file. In order to do this, In WinSCP, I supply the host name, the port, and a username supplied by the State. Additionally, I have to click on the Advanced button, then under SSH click on the Authentication text, click on the ellipsis (...) under Private Key File I enter the name of a Putty file (that was given to me by the FME Administrator) The file is sent by FTP using this manual method. At this point I am trying to automate the process so that the FME, using FTPCaller as advised, will achieve the same transfer. However, I am not clear how-to setup the FTPCaller to incorporate all of the parameters (host name, port, username, Putty file) that I have been given for the manual transfer. Can I get some advice on

I have a workspace app that accepts a kmz dropped on it. The result is a postgres/postgis spatial overlay with the kmz. When there is no resulting feature I need to send a message to the app instead of the resulting data. I have added NoFeature testers into my workspace to capture any streams that do not have output. Just not sure how to generate a report and get that to the app when the workspace completes. I am thinking now it would be nice to have a count from each of the input data streams whether there is a spatial relate or not.Thanks for any direction.

I have a file geodatabase where backups are stored with a date in the name that gives the backupdate, BU_20230724, BU_20230731 etc. How can I select that only the latest will be read for further analysis? Normally, a feature class is selected under Constraints > Tables and you can select the one you need but, the latest Backup will not stay the same during the year. In a automated proces I would like to select the one with the latest date without changing it manually.

Greetings,I used FeatureJoiner to merge a Spatial and non-spatial records using a common value (grid_id).  I use a Tester to select a scenario ie date is 2000, 2030, 2040, etc.I then use a StringConcaternator to add a value to a cell (overwrite cell value), the cell for 2000 will be 0 -5. I also have a Tester for 2030 (2C), 2030 (4C), 2040 (2C), 2040 (4C), etc. The records in the FeatureHolder, should all be written to a single row.Instead I have a row per date/scenario?? For 2000 I have the following data. The output is written over n rows, not a single row?? How do I append records into a single row??Any suggestions are appreciated. ThanksClive

HI. Do I still have to manually input using the AttributeExposer transformer, like the answer to the question below? https://community.safe.com/s/question/0D54Q000080hcshSAA/problem-ifc-reading-user-attributes What should I do when a user-defined property exists for each IFC file in the way that the fmw file runs FME Application in the shell and operates? please answer about my question. Regards,Bongsup Kim​