FME Form

Is it possible to delete rows in Excel based on a cell value? I am comparing a data-set in Excel to another Excel file using Feature Merger. I want to delete the rows in the data-set which match a specific field (DETECTOR) in the new file(s).I feel like this should be very basic since Power Automate can do it (And MS has a surprisingly poor integration with their own software). The closest thing I found was the Database Deleter, but it doesn't have an Excel option for format. I can add Microsoft Excel as a new custom format, but that doesn't behave the way I would expect (opens a new workspace?).

When reading a PostgreSQL table with FME Workbench (2023.1) that has been droped (or renamed) before, the error in the logfile looks like: "Error executing SQL command ('select * from "schema"."table" where false limit 0'): 'ERROR: Relation »schema.table« does not exist".Despite of this error the logfile says that the "Translation was SUCCESSFUL". (The parameter "ignore failed reader" is already set to NO.) I need to know, if a table has been deleted (or renamed). So, how can i make the translation fail on missing input PostgreSQL table instead?  

When, oh when, will the wallpapers for 2021 become available ??I have a wall to decorate ......

I've been using a couple of Affine transformer to transform data from/to a custom, local coordinate system. I just discovered the possibility of defining a custom FME coordinate system with the TMAF projection, so I'm trying to simplify my workspace using this. I put a new TMAF (based on UTM32) into MyCoordSysDefs.fme and then use it in a regular Reprojector transformer. It's my understanding that such affine transforms should be invertible, and that I should just need to change the from/to coordinate systems in the Reprojector to get the correct transform, but I can only get it to work one way? How is this supposed to work?

I would like to extract the coded domnain definition from a geodabase.There is already an article about it here. However, when dowloading the ETL extract-domains-from-geodatabase-gdb-py34.fmw, I couldn't run it with my 2021 FME version.FME_BEGIN_TCL script returned error on execution. Error message was: '                FME 2021.2.6.0 (20220727 - Build 21821 - WIN64)                        FME Database Edition (floating)                               Permanent License.                         Machine host name is: 237146PT          Operating System: Microsoft Windows 10 64-bit  (Build 19045)                 Copyright (c) 1994 - 2021, Safe Software Inc.                               Safe Software Inc.GEODATABASE_FILE reader: An unknown exception occurredProgram TerminatingTranslation FAILED.child process exited abnormally'. TCL script was: 'lappend sysString $FME_MacroValues(FME_HOME_UNIX)/fme;lappend sysString {Generate};lappend sysString {GEODATABASE_FILE};lappend sysString {NULL};lap

I have a power shell script, which retrieves data and saves it to a Jason file. I can run this with a Windows schedule task. I have successfully created a FME project which retrieves that data and populates a database table. Now we want to look at the possibility of executing the power shell script, within the FME project. I have tried this with a SystemCaller but it does not work. Therefore I tried to simplify it. I have created a batch file that appends the current date time to a text file. I have tried using this instead, but when I run the workspace, the text file is now updated scratch that is not updated.Note, I have tried it with the full path as well as just the name of the batch file. Can anyone advise? Thanks 

Hi, I have multiple gdb with feature classes. I would like to get one feature class per each gdb as a sample. The catch is that I do not want to read all data as it's massive. I would like to filter/sample it while reading something similar to SQL Creator

Hi, I have a workbench where I download data from Arcgis online.For this I use the transformer "ArcGIS_AP_FileGDBExport". This works fine with FME Form. But I will use this workbench inside fme flow and during the upload comes the following warning: If I ignore the warnings the workbench is not working! How can I set up web connections correctly in fme flow?

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. Much of the source material for the map i

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.  Questions:How can I convert an attribute (_contents) containing a full CSV text file into a temporary table or CSV within FME? Are there any transformers or specific settings that

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.readyState == 4 && httpRequest.status == 200) { console.log(httpRequest.responseText); } } // send a request so we get a reply httpRequest.send(&quot

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