Transformers

I am using FTPCaller. If I add the Emailer to the rejected port will it send me an email if the output gets kicked to the rejected port? I would have the Emailer already configured to send me an email. I want to double check with the Community since my workbench will stop running if the FTPCaller output is rejected. Here is a screenshot of a mock up workspace (note I have not set up the transformer parameters yet hence you see the red gear icons.) Not shown below, I know it will send me an email if the FTPCaller output is sent to Output.  

I want to write lines into an existing PostGIS table, which has default values for most of the columns. With FME PostGIS Writer, when executing the process, I have errors returning (in french):Bulk copy failed on table 'XXX' using delimiter ':'. Error was 'ERREUR:  une valeur NULL viole la contrainte NOT NULL de la colonne « YYY» dans la relation « XXX » I would like to use the Postgres default values for these NOT NULL columns, but I cannot find the way to do it.I use FME Form 2023.2

I'm trying to read a (big?) ecw file (EPSG 28992, 173 Mb) using FME 2020.1.0.1.This is very slow (> 10 minutes), QGIS displays the same file in a matter of seconds. I'm wondering if I'm missing some reader parameters that might speed up the process. I do need best resolution though...

Dear all, I’m fairly new to FME but currently I’m quite impressed by the software :). My question is rather simple: is there an equivalent in FME of the Tabulate Areas function of ArcGIS Pro: Tabulate Area (Spatial Analyst)—ArcGIS Pro | DocumentationI have two datasets:The cadastral parcels of Wallonia in polygon format ; A land cover classification (TIFF raster) with 20+ classes.I would like to calculate for each polygonal entity the proportion of land cover classes.The result should look like this:ID | LC1 | LC2 | LC3 | … | LC201 | 10% | 0 | 0 |25 | … | 02 | …3 | … Many thanks in advance for your feedback :)

When I simply add the PDF reader and convert to the TIFF writer, alle Images are exported separately into rows, meaning that for each individual PDF-File I get 100+ TIFFs. How can convert PDF to TIFF without this happening?

Hi ,Is there any way to use an ifc file containing ifc objects, extract a specific object , then put it in precise locations in another ifc file that I am creating in the workflow?for exemple if I am interested in using this ifcDoor object that is inside a file1.ifc file : and the positions where i want to put this ifcDoor are where the 2d doors (the red lines) of my input file are located (my input is a dwg file containg 2D doors):All I can do now is just extrude those 2d doors , add ifc attributes to them , and them write them to ifcDoor writer .  but they don't even look like doors :i want the doors to look like the ones in my file1.ifc file (their color , geometry , texture )I'm searching for a way to do it , but I am afraid that it is impossible .

I am getting features in through a WFS and pump the resulting XML structures through an XMLFlattener.The Elements to Match are ‘grouped’ by an attribute value and thereby dynamic.What I cannot make dynamic are the Attributes to Expose. I can either write them myself, or import them, but how can I get e.g. a list to work there, or the value of an attribute?Best thing would be the option of a conditional value… 😉

I need to upload new csv file each day with there is date on file each day

xcopy "$(TEMP_FOLDER)\$(FME_JOB_ID)\Temp"  "$(TEMP_FOLDER)\$(FME_JOB_ID)\Results" /I /E /Y /TFrom the command line I use xcopy /I /E /Y /T and if the directory does not exist it creates it but within a SystemCaller it does not work and does not give an error message.I need Help 

Is there a way to check if a directory exists?I create a directory B using the mkdir command within one SystemCaller and in another SystemCaller it copies file from directory A to B and it works.But the process must copy copy new files that are created in directory A and the mkdir gives an error because the directory already exists.

Since eternity and up to FME 2022 we placed our DLLs for self implemented transformers in FME_HOME directory.In FME 2024 it seems they need to be placed in FME_HOME\plugins directory ?!Since when is this requirement in effect ?Is there a way to influence where transformer DLLs are searched by FME ?

I’m using FME Workbench 2023.1.  I have an excel file with a Payment Type attribute field.  There are 4 types:Cash Check Credit Card Money OrderNot all payment types will be present in the excel file each time this is run, but I need it to still have an output for that payment type.  I’m fairly new to FME and used an Attribute Filter transformer to filter for each Payment Type, but when there are no rows in my excel file with a particular Payment Type, I will not get any kind of output. See below image for example of one of the areas in my script where I use this filter.  I think I need to create a domain of values for the the Payment Type field, before this is run and maybe get a count?  In the end what I need is if there are no payments of that type in the Payment Type field, then when I sum the payment amounts for each Payment Type, that particular Payment Type would need to be given an output sum of, 0.  If you look in my below image, the only Payment Type that has an output is Cre

Hi,I have data from the WFS address, for parcels of land. I need to perform an additional check in which it will be checked if some of parcels are not duplicated. That is, I need to detect if there are two polygons, one on top of the other, in my layer in WFS in one place. Please give me some suggestions.

I have two Excel Files. You can see from the screenshot, in the Visual Preview, I need to compare 95137 and 95138 in a Tester. Before I can do this, I need to “move” 95137 to row 1 (highlighted in yellow in the screenshot below) and have only one row in the table not two, what is the best way to make this happen?   

Hi there.I am needing to pull data directly from a SQL Server Analysis Services data cube. Can FME connect to the cube?   

Hello!Here is my problem:I have a SDE db (let’s call it T1) with field “date_change” (type: date). I also have a table (let’s call it T2) that has a filed “sync_date” (type: date).I am trying to make a query where I select all features from T1 where “date_change” is equal or greater than T2 “sync_date”. I am using a FeatureReader and trying to apply it on the where clause. However, my query keeps coming blank. I think the syntax is wrong (WHERE clause: “date_change” >= “sync_date”). Anyone has any suggestions?Thank you in advance!

I’m running a FME script that reads feature classes from a GDB, performs a handful of transformations followed by one inspector, then writes to a new GDB.  After running the entire workspace, it says the translation was successful.  But that message is followed by: Failed to initialize the reader in the temporary rendering process.  I’m still new to FME, so I don’t understand this error, or what needs to be fixed.  Can anyone provide any insight on this, or how I can troubleshoot this further?   FYI I’m using FME 2023.1.1.1  

Hello everyone,I am converting several SDE geod to respective CAD files. All CADs need to be written in the same folder (with suffix of the currentdate). I  created this folder in Python Caller. How can I now route CADs to this folder?

Can the OGC GeoPackage Writer write metadata to the gpkg file?Particularly metadata that conforms to the ISO 19139 standardThe geopackage file would be holding a vector dataset, like roads or parcel boundaries

Hello all,I am trying to build a PythonCaller that replicates the Windows command of “Send to Compressed (zipped) folder”The goal is to prepare a fileGDB dataset for transfer by ftp by zipping itI want to give the PythonCaller a filePath such as D:\2024\03\project\data.gdbWhich then creates a zip file D:\2024\03\project\data.gdb.zip (that is, the zip file is sitting in the same folder as the data.gdb)And, when the end user opens the zip file they see the folder data.gdb which they can then extractI am trying using this code    def input(self, feature):        import os, shutil        folder = feature.getAttribute('folder')        fileGDB = feature.getAttribute('fileGDB')        zip_file = feature.getAttribute('zip_file')        if os.path.exists(fileGDB):            print('fileGDB exists')            if os.path.exists(zip_file):                os.remove(zip_file)            else:                print('zip file DOES NOT exist')            shutil.make_archive(fileGDB, 'zip', folder)     

Hi, thanks for your help in advance, I am writing out to PostGIS, inside the attributes I have a UniqueID and a date timestamp field which have default values set in Postgres. When I come to populate the table in FME, I do not include these fields in the writer but when I use bulk insert set to yes, the records are added and the fields are not populated. When I have bulk insert set to no the workbench fails and the insert statement had the attribute fields in the insert statement.How can I get round this - I just want FME to be blissfully unaware of these attributes so that postgres can handle the population of these attribute fields.Any help on this would be great.Many Thanks,Oliver

I thought I knew how to do this but it broke for some reason. My workspace has a GDB that contains a feature dataset that has domains assigned to a few of the feature classes and it also has topology. I set up a simple transformer to sort and do an area calc. Then, I need to write back to that same GDB while keeping the domains. I recently lost the domains assignment and when I tried to update the workbench now it fails to write anything. I've tried multiple methods and each has a failure like 'cannot delete layer that has topology' or 'cannot make edits out of an edit session'. How should I set up my writer? I'm not sure I want to overwrite existing if I can help it.

Hello. The WRITER called Esri ArcGIS Server Feature Service Writer does not seem to exist. The reader is there.. but not the writer This is not AGOL and not Portal - just “Esri ArcGIS Server Feature Service Writer” It’s in the documentation as existing and I do need to write out to an Esri ArcGIS Server feature service using a rest endpoint url Please point me in the right direction if I’m missing it somehow. If it’s not there, why not? The documentation is at https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/arcgisfeatures/arcgisfeatures.htmThanksJim

Hello all! Relatively newbie here.I think my question is simple but I am just struggling with finding a query for it. I have a table in an SDE. An example of the structure:object_id        job_id          update_start                               status1                     xxx              2/15/2024 13:00:00                  Success2                     xxx              2/20/2024 13:00:00                  Success3                     xxx              2/25/2024 13:00:00                  Fail I am using a FeatureReader to read this table and I need to extract the most recent succesful run from this table (i.e. in this case only row 2). I am using the where clause but it keeps returning me blank and I ran out of ideas. Any help is appreciated!Regards,

I am trying to post an AGOL attachment (i.e. an image) to a Cityworks Work order using the HTTP caller. My goal is to post a unique image to a unique work order (i.e. an image of a sidewalk crack for a sidewalk work order, a pothole image for a pothole work order etc.). The issue starts with my file. I am using AttributeFileWritter to write the file. I use a variable from the feature layer to name my output file (i.e. @Value(WorkorderID).jpeg). This writes to my output directory with no issues. When I go to try and upload this file, when I feed it the PATH + file name + file extension it results in an error “HTTP/FTP Transfer: Failed to open file for resource upload”.  When I explicitly “Select” the file it will upload without issues.  My workflow is as followsI write the image file  I make the callMy body call This body call is what throws the error. When I add the variable name with extension for the file I want it to upload, it results in the following error “HTTP/FTP Transfer: Fail