FME Form

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 ?

Some users in my organisation are getting the below error when using  using fme-form-2023.2.1-b23774-win-x64. They have already looked at editing the path in environment variables and that didn't work. Any suggestions on a solution? Python Exception <ImportError>: This package should not be accessible on Python 3. Either you are trying to run from the python-future src folder or your installation of python-future is corrupted.Failed to import `fmesite'Python Exception <ImportError>: This package should not be accessible on Python 3. Either you are trying to run from the python-future src folder or your installation of python-future is corrupted.Failed to import `fme'(PythonFactory): The Python Framework could not be started. PythonFactory could not initializeThe Python Framework could not be started. PythonFactory could not initialize

Just update eterra3.ancpi.roGeometryFetcher. Updated all transformers to 2024, created a workaround for Tiler not completing a Conditional Value for $Parameter Contains/Begins with, created a test suite, uploaded .fmx and .fmw to the Hub.This is the Test Suite Failure Log:2024-03-12 20:33:35| 0.0| 0.0|INFORM|Current FME version: FME 2023.2.2.0 (20240205 - Build 23781 - linux-x64)2024-03-12 20:33:35| 0.0| 0.0|INFORM|System Time: 20240312203336 UTC2024-03-12 20:33:35| 0.0| 0.0|WARN |Workspace was last saved in FME version: FME 2024.0.0.0 (20240304 - Build 24187 - WIN64)Can’t run 2024.0 workspace on 2023.2.2.Please fix this!By the way, in case safers missed it: Something is wrong with the Conditional Value in transformers that only have Arithmetic Editor (for transformers that have both Text and Arithmetic Editor it appears to works)

Hello, I have a problem with INSPIRE validator. I created a ETL schema in my FME Desktop environment according to INSPIRE theme of Protected Sites. So I've done it by applying all the technical guides from INSPIRE, and solved all my previous validation errors except this one: The dataset has 1 file(s) with errors for this assertion.XML document 'ProtectedSites ETRS89_jasmin.gml': The file has 1 schema validation error(s).XML document 'ProtectedSites ETRS89_jasmin.gml': 1:729: cvc-elt.1.a: Cannot find the declaration of element 'gml:FeatureCollection'.When I use the Hale studio for transformation and get my GML, validation process goes smoothly, but with FME I have a problem. During my analysis I saw that in Hale Studio GML I have a longer <gml: FeatureCollection > tag in the xxsi:schemaLocation part. Here is the Hale xsi: schemaLocation: xsi:schemaLocation="

Hi,I have a shapefile with lines, some of which show the degree of curvature...I would like to delete some lines based on the angle of curvature.How can I do that?  

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

Hello FME community, I have a workspace which I always run with quick translator. Since my user parameters are never going to be changed, is there a way that I can simply double-click on this file and it runs with quick translator without the need to click OK or press Enter to confirm the user parameters? 

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?   

Hiich would like to write an gml Class "ExistingLandUseGrid" Object from the INSPIRE Specs http://inspire.ec.europa.eu/schemas/gelu/4.0Wenn adding a INSPIRE GML writer by pointing to the cooresponding GriddedExistingLandUse.xsd, the writer does not offer a featuretype "ExistingLandUseGrid" which is what i would expect. The only featuretype in the GML writer is "SpatialDataSet".Are there any options for the writer to enable writing a featuretype "ExistingLandUseGrid"? Or an example of a working script? RegardsPeter

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

I am using Oracle DB. My sql commands are update commands. I believe it is directly sending to the oracle to execute rather than regular transformer which execute in batches. Please clarify. 

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 on 2022.2 and using a StatisticsCalculator with a Group By (based on the name of a CSV) to get statistics (min, max, mean) on a handful of attributes.  It works great for all but 1 attribute (Specific_Gravity) and I can’t figure out why.  The attribute type (64 bit real) is the same between Specific_Gravity and Temperature_F so I’m not sure why one works and the other doesn’t.  The kicker is that I can get Mean values for Specific_Gravity but not Min or Max.Do I have the transformer configured incorrectly, is it a data type issue, or something else??Screenshot of transformer with results: 

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, I have just updated FME: 2022 -> 2023 (2023.0.2 (20230727 - Build 23338 - WIN64). Checking that this upgrade doesn't cause errors when running several important processes, I see this warning message in the log of one of them: POSTGRES Writer: Renamed user attribute 'attribute{0}.fme_data_type' to 'attribute{0}_fme_data_type' based on format constraints for invalid characters, length, and casePOSTGRES Writer: Renamed user attribute 'attribute{0}.name' to 'attribute{0}_name' based on format constraints for invalid characters, length, and case This message was absent with the previous version. The transformer concerned is a FeatureWriter whose parameters are shown below. It has two upstream branches: one for table schemas, the other for features. Adding all these entries to the log file slows down processing considerably and, when many features are processed, the f

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:

Dear readers, A colleague of mine is trying to extract data from an FTP server.Using FME for this process would be beneficial to a large part of our organization, since it would enable us to create ETL processes for FTP-data. My colleague encounters the following problem:FTP/FTPS/SFTP transfer error: Timeout was reached The settings he uses are:URL: <url links correctly to a .csv on the FTP server starting with FTPS://FTP>Transfer type: Download to a File Target File: <.csv on OneDrive that does not exist yet>File Path Attribute: _downloaded_file_path Connection Mode: Passive / Active triedTransfer Mode: BinaryVerify SSL Certificates (ftps/ftpes only): Yes Authentication Type: Password < username and password correctly set> Proxy Type: Use FME Network Proxy Settings My colleague received the followin

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

Good morning,  I'm currently facing a really weird issue. In my workbench I have a Reader that is loading a quite large Excel file, containing multiple tabs. I decided to remove all the unwanted data from the Excel sheet and keep only the tab I really need.  When I try to update the Reader feature types the Excel tabs that I just removed keep showing! I have tried adding this Excel sheet to a new workbench; same result.  What I've tried so far: - Adding the Reader to a new workbench in 2018.1 and 2019 beta. - Purged temporary files in FME. - Restarting FME / computer - Ran Windows disk cleanupNothing helped, I'm still seeing the tabs I deleted.   Cheers, Ed

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