FME Form

Hi, everyone I'm new to FME, I had some difficulty in getting the geometry shape of walls converted from CityGML to IFC. The details are as follows:I can get the Guid of each wall, but there is no geometry information, could you give me some help? Thank you very much. Best regards Ying

I have attached a screenshot of the start of the proces without the loop. I want the loop to continue until there are no failed output in the tester. Any ideas on what I can do? Thanks!

Hello all,I am reading a scanned PDF image of a county and I would like it to read as a single file. It appears to be reading it as 7 different files, which will output into 7 different TIFFs. Does anyone know how to fix this problem and make it read as a single PDF image?

I need to find distance between many lines, any suggestion? I tried NeighborFinder, but not helping.

Hello Forum, I looking into using FME Desktop to connet to an API using the HTTPCaller.  HTTPCaller requires a selected authentication method. The options are: Basic, Digest, NTLM, Web Connection, Single Sign-On. However the API owner has said that their authentication method is "Bearer Token (with an API key provided)". Is this compatible with any other the existing authentication methods available in HTTPcaller? Thanks,Stuart  

Is there a way to get the field name aliases from an ArcGIS Feature Service instead of just the field names?

Hello ,How to convert multi line strings in cell into one line at the same cell ?I have many cells that include the strings in two lines at specific cell includes building CR LFone side i want to change the two lines into one line to be building one side in one line at the same cell CR LF : created from Fme ,I am not sure what does it mean ?fme 2021  

Hello how to find which value closet to another value ? i have 4 id id -value 1 - 152 - 403 - 704 10how could I find which value of id closet to another value of another id more than others .As example , my target to know that id 1 and id 4 are close to each other and id 2 and id 3 ,close to each other fme 2021

Hello everyone I have street numbers. I have the first and last number of each street. I would like to know witch are missing from my database. My idea is I set the min number ect 1 and the max 60 and creat a list or array to this street has theses numbers. A di could compare it with my database and find with is missing.Thanks advice

Hello I have several point data sets (different Excel files) that I would like to clean up. I would like to delete points with the same position (X,Y) and only keep the point with the highest height (Z).I am currently deleting points with the same position with the Matcher Transformer. This works wonderfully. Now I have not yet found a way to say that the highest point at the location cannot be deleted. Is there a way in FME to influence the selection of the points to be deleted when cleaning different data sets? The height of the objects is available both as attributes and as 3D coordinates.Thanks a lot

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 a

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.

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!