Transformers

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 Order Not 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 Credit

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 standard The 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 it I want to give the PythonCaller a filePath such as D:\2024\03\project\data.gdb Which 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 extract I 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) else: print('fileGDB DOES NOT exist') self.pyoutput(feature) But! the zip file contains itself! Which is wrong

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.htm Thanks Jim

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 status 1 xxx 2/15/2024 13:00:00 Success 2 xxx 2/20/2024 13:00:00 Success 3 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 follows I write the image file I make the call My 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: Faile

Hi, I have a SQLExecutor with a dynamic SQL Server query like: SELECT * FROM value(@table_name) Obviously, as it is a dynamic query I don't expose any attribute. Then, I connect the schema and generic outputs to a featureWriter (CSV). When I run the workspace, It finish suscessfully but It doesn't generate the CSV file. The same problem if I try to generate the CSV file with a dynamic writer instead of a featurWriter. However, if I replace the SQL Executor with a dynamic featureReader, the CSV is generate correctly. I need a SQL Executor because the query will be a bit more complex. I think It is something related with schema but I missing something. Could anyone help? Thank you un advance! Regards.

Hi all, I have a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB). Example: I will convert this tiff into a three channel (RGB) tiff. Is this possible with FME? thanks in advance!

Is it possible to run workspace runner with “wait for Job to compete” = YES and setting a number of the concurrent processes? It should work the same way as “wait for Job to compete” = NO with the only difference on the time of showing the success or failure of the process run.

Hello. Is there a possibility to read an ifc file, retrieve a list of all attributes (like it is present after running a workflow once and click on import from feature cache in the attributeKeeper), be able to select the ones to keep and keep only those in the writer? Or at least read a textfile with a list of attributes separated with , and use them as attributes to keep? I build a workflow to work with IFC data and at the moment I specifically create a “new” workflow for every file, manually adjust the attributeKeeper from the feature cache and run the workflow with the same file a second time. I do not know beforehand which attributes are included in the ifc file, and it can differ with each file. I already figured that the attribute keeper can’t work with user parameters. I tried using the Attribute Exposer with “Import from Dataset” or the Feature Reader Schema Output for a dynamic writer...but either I did not understand the answers given in other community questions or I did som

Hello! I have recently started working with FME Flow. I’m just testing the possibilities of writing to the Fme flow temporary resource directory, which causes the translation to fail immediatly. My script is just a reader, which in this case is reading from a shapefile, as well as a feature writer. The featurewriter is set to write to [FME_SHAREDRESOURCE_TEMP] and the response i’m getting when running the workspace is this: Has anyone encountered this before, and is there any hope for me and my workspaces in FME flow? Thanks! /Alex

Hi, I have a shape file and want to create some geometries and annotations and export them as IFC. The geometries are correctly exported. But the Annotations are really small in the exported IFC file. I used the Scaler before exporting the IFCAnnotation. But the problem is that the scaler doesn’t change the Size of the text, but also the location of it. Can anyone help me please to make the Annotations larger and also have them in their correct location?

Hello! I just got ortho images from Realworks, but I got images without coordinate system and some information in txt format. Is there any way to put this txt file as a coordinate system in FME? At last, I would like to get EPSG : 3857 geo referenced ortho images.

Hi everyone, I have some DEMs. I combined them (PointCloudCombiner) and have created surfaces on them (PointCloudSurfaceBuilder) and exported them as LandXML. The problem is with the borders of the DEMs. They are not connected. How can I solve it? Thanks!

Hi, I am having an issue with feature readers and XML. I have a process which downloads an XML file from an ftp site, and the file name changes daily. Upon download, I am trying to trigger a second process which reads the downloaded xml, so I can then split it into separate records (hence why reading in as text will not work, as I need the xml fragments). I use a path reader, to get the file name, but when I put ‘Path_Windows’ as the dataset, i get this error: error message If I choose to ignore the message, and run to the featurereader, It reads in the correct amount of records (59), but the schema is blank. Blank Schema Log Error message Now, i know for a fact that my xml does in fact, have a schema, because if I hard code the file name in the feature reader, it works perfectly fine. (see below) FeatureReader with hard coded file name Successfully read The parameters are identical on both. FeatureReader Parameters I am at a total loss as to why when I want to put in a dynamic file na

Hi All, I have created a workspace that reads all GDBs included in a folder (and subfolders) and export a few attributes to an excel file but now need to bring the GDB name (path_filename) into the final output. I tried to expose the attribute to bring it along the workflow but seems isn’t part of the unexposed attributes. I was expecting to see the GDB name as part of the Generic elements (within the unexposed attributes) but the GDB is only in the <Schema>, How can I bring the GDB name as column in the final output (excel file in this case)? <Generic> screenshot <Schema> Screenshot

Dear FME community, apologies up front for being a novice python user I am trying to use the python caller transformer to execute an external .py file. However my external .py file does not have any classes therefore I don’t know what to do with the ‘Class to process features’ parameter in the transformer. If I run the python caller regardless, it executes my .py script fine, but crashes at the end with this error message “PythonFactory failed to load python symbol `FeatureProcessor'”. This is because I’m using the default ‘FeatureProcessor’ as my parameter for the “class to process features”, which I know is wrong. My python script simply generates a JPG file and saves it to a directory. I hope someone can assist and I haven’t totally missed the point. Regards, Damian