FME Form

Hello, quite difficult to find the right section for my question, so moderators, please move it in a more suitable one if it is necessary.  I create a FGDB with a feature class and a table. The table shall use the OBJECTID of the feature class, so this one shall be created first to be able to use the OBJECTID in the table. Is there a way to create the FGDB in one wb? Thank you, Corina

good week everyone There is a yield in point format. I want to produce a line from these points. There is a method I used before, but I did not get very good results. As an attribute, each point has a shooting time. Can I create a line using this shooting time?

Is it possible to search for multiple file extensions in the one directory and file pathnames reader simultaneously?Path Filter:* - returns all files*.dgn - returns all dgn files*.dgn,*.shp - returns 0 resultsCan someone please help me with the correct syntax for multiple file extensions in Path Filter?

Background: We have an almost complete library of Vietnam-war era topographic maps in CADRG format. There are some "holes" in the coverage that I am trying to fill. We use these maps as a background for creating tactical overlays of battlefield information, unit locations, prominent terrain features, etc. I am a Vietnam Vet (USMC), and these maps/overlays/annotation are provided to other vets and researchers at no cost. Up until now, I've use an assortment of other programs to covert both geo and non-geo map imagery into CADRG files (gdal, QGIS, GeoRect, CadrgConvertor, Open Map, Gimp, etc), and as "viewers" and overlay editors of the CADRG use primarily FalconView and Open Map. I'd like to learn how to use FME to do this end-to-end if possible. I've tried a few basic conversions in Workbench with varying degrees of success...mostly trying learn by and adapt work by other users. I'm a very basic user. 

Dear FME Community, I am facing a challenge while using the SharePointOnline Connector in FME to load a CSV file directly as an attribute. My objective is to avoid storing this CSV file on any network drive, local drive, or an M365 named account OneDrive folder. Instead, I'd like to process it immediately within the FME workflow. Goal:My end goal is to convert this attribute—which contains the entire table from the CSV file in text form—into a temporary table or a temporary CSV within FME for further transformation. Version:I am currently using FME version [2022.2.0.0 (20221103 - Build 22765 - WIN64) ]. Problem:I can successfully load the CSV file as an attribute (see picture), but I am struggling to convert this attribute to a format (temporary table or temporary CSV) that I can then transform further.

I have used the FeatureWriter to save a csv with a dynamic filename of "Name_@Left(@DateTimeNow(),8)" before passing on the features to be used by the Emailer transformer. However I only get a result from the Summary port and nothing in the output port.  If I change the file name so that it doesn't include functions and uses an attribute instead (creating a new attribute to handle the date function before the featurewriter) then I see features in the output port.

Hi, I am trying to run the attached fme workspace in fme server as datastreaming service. The workspace works fine in FME Workbench and while running in FME server web interface as datastreaming service. However, I am trying to access this service from my web app. Below is how I am forming the request : var httpRequest = new XMLHttpRequest();httpRequest.open("POST", url, true);httpRequest.setRequestHeader("Authorization","fmetoken token=*********")httpRequest.setRequestHeader("Access-Control-Allow-Origin", "http://localhost:8080");httpRequest.setRequestHeader("Accept","application/json;charset=UTF-8");httpRequest.setRequestHeader("content-Type","application/x-www-form-urlencoded"); httpRequest.onreadystatechange = function() { if (httpRequest.read

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?