Authoring

I am writing to a file gdb, I will need to run my workbench to update this file gdb each month. The schema of my incoming tables may change so I have used a schema scanner with a dynamic writer.I want to use drop and create for table handling but it is not behaving as expected. Instead of dropping the existing feature class it just appends the entries to the existing table.I am not sure why this is happening. Of note, my feature classes are also within feature datasets. See attached screenshot of writer settings.  

Error: “the number of points is less than required for feature”,  We are extracting data from CAD files. The destination is layers stored in ESRI file Geodatabase. Copying the features from the generated layers to other enterprise geodatabse layers result in the error below:  CAD file: http://www.mediafire.com/download/ii2dszjoo4zoij4/AsSamou_Hebron_MasterPlan_05_X_03.dwg    Workbench   Extracting the Roads polygon (Roads = Boundary – Landuses)    

I have a large number of points, which I would like to join by simple lines (point-to-point), minimizing the overall summed length of the generated lines. There's no preferred path, but all points must be connected to each other by a single network of lines.My output just needs to be a set of simple lines.Do anyone have an idea on how to accomplish that, other than grinding it out in a PythonCaller ?CheersLars I

Hello, we have inherited a range of very large workbenches and was wondering if there is a way to get a summary report of the major components like parameters, database connections,  inputs,  outputs and names of bookmarks. 

I had a pair of coordinates stored in a single column named "geometry." I used the Attribute Splitter to separate these coordinates and then exploded the list. Now, I have each latitude and longitude in the same column. Is there a way to copy these latitude and longitude values into separate columns labeled "Latitude" and "Longitude" while maintaining the same order?

Using the Httpcaller i can successfully make a rest api call to retrieve a token for an ArcGIS Portal Featureservice. A proxy server is set up but is not used for this url so the call bypasses the proxy. However, I can only set up and use an ArcGIS Portal Feature Service connection if there is no proxy set up at all. If the proxy is enabled, the connection tries to use the proxy even though the base url is on the exception list.

I have ArcGIS 10.8 with 64bit Background processing installed and am using the latest version of FME Form (FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64))I want to read data from an ESRI File Geodatabase with the Esri Geodatabase reader and writer and am having sporadic compatabilty problems. At the moment I cannot read from the geodatabase but I can write to it. Other times, I can’t write to it either.I have set the translation parameter to ESRI ArcMAP.I have also reinstalled ArcGIS 10.8 and this morning I updated FME Form.I have also realised, that after the problem arises, if I restart FME I can write to the File Geodatabase again.Why am I still having problems?

Hi there - I have produced a table in a word document using the MSWordStyler and word writer. However I would now like to add a title to the word document above the table and I’m not sure how I do this. I would be grateful for some advice please. Thanks Ruth

Hi FME ninjas.I'm trying to replicate this end result:These are city streets, they started as line objects and have been converted into polygons.I'm guessing the workflow is as follows:- Convert street lines with a buffer into a polygon- Inflate those polygons until they touch an adjacent polygon- ???- Proft! 😀But I don't have a clue how to do this or what transformers I need.Who can help me out creating this workflow?​​​​​​​Thanks.   

I would assume (dangerous in this case), that a Terminator would halt processing completely.I have a workspace, that imports from a WFS. It errs because the provider made a breaking change by removing a column in the read dataset. This issues a rejected feature, which triggers a Terminator.But even then, the postprocess action of my SQL writer is triggered.Why does this happen ?If a terminator is called, it indicates that the workspace has failed. And then triggering postprocessing is a dangerous action, as this usually requires the writing to have been completed without errors.Is this not a bug ?Using FME 2022.2.6 on FME Server/Flow.Cheers

Whenever we cancel a running job (in our case: using the REST API), the job is cancelled successfully on the FME Server core (the job reports itself as aborted when we fetch the status), but the engine on which the job is running (on a different physical machine than the Server core) just keeps on going: the job simply runs until the end of the translation. This is not what I expected, but since I don't see any errors in the server logs e.g. about communication issues with the engine, I started to wonder.Is this intended behaviour? If so, are there ways to actually stop the job process on the engine as well? If not, any suggestions on how to fix this?

In the olden days, you could mark your own reply as best answer, if you figured it out yourself.This is no longer possible.Why ?

Hello everyone,I'm working on a project in FME and need to filter date values from a CSV file. I have the following requirements:The date should be between 01.01.2021 00:00 and 22.07.2021 23:59. The date column is in the CSV file and is formatted as dd.MM.yyyy HH:mm.I've tried using the DateTimeConverter and Tester transformers, but I'm not sure if I've configured everything correctly. Does anyone have tips or examples on how to implement this?Thank you in advance!

Bonjour la communauté. Je cherche à créer un tableau avec mes données d’entrée et par la suite insérer ce tableau dans un pdf.Pour insérer ce tableau, je devrais sûrement utiliser le pdfpageformater, mais quel transformer va me permettre de créer mon tableau comme je le souhaite. Merci d’avance pour vos réponses.

Hello FME Community,I have point data with attributes for the X and Y coordinates of the top-right and bottom-left corners (e.g., X_TopRight, Y_TopRight, X_BottomLeft, Y_BottomLeft). I would like to create a rectangle based on these two corner points.Could anyone suggest the best approach or transformers to use in FME to accomplish this?Thanks for your help!

Hello,We are using FTPCaller to connect to our SFTP Server via OpenSSH Agent as per the instructions in this article:https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems The authentication is not a problem and we are able to log into the SFTP server, but we are having problems downloading files with spaces in their names, we are trying to download a file named:LB Daily Course Raitings_202409130404.csv the URL set up in the FTPCaller is:sftp://sftpip:2222/Test_Folder/LB Daily Course Raitings_202409130404.csvWe keep getting the error t

When I update one of my destination folders for my writers, all of the writers are updated to run to the same folder. I don’t know why this is happening.When I try and run the workbench, it runs like normal but then as it’s writing it comes with an error: “CSV writer: Failed to open file 'C:\D_xxxxxxxx.csv' for writing.  Please ensure that you have sufficient privileges to write this file.  If the file already exists, please ensure it is not open in another application” after it has written the first file to the folder.This has only been happening since I upgraded my ArcGIS Pro to a newer version that isn’t supported by my current version of FME (which I need to maintain to match the clients version).Any help would be greatly appreciated. 

I simply want to create a .CSV reader that should read the following dataset: $(FME_MF_DIR)DIDOK\didok.csv My workbench is on a network disk P: let’s say P:/myworkbench.fmw so I expected that $(FME_MF_DIR) will be P:/. But instead $(FME_MF_DIR) is resolved to C:\Users\MyUsername\AppData\Local\Temp. So I guess that FME temporarily copy the workbench into C:\Users\MyUsername\AppData\Local\Temp ? How to prevent this behaviour ?

I have a workflow involving three readers (Reader 1, Reader 2, and Reader 3), and I need help setting up conditional logic based on feature counts for a given ID.Here's what I'm trying to achieve: All three readers are filtered by the same ID. Condition 1: If both Reader 1 and Reader 2 have at least one feature for the given ID, then do nothing—no features should be written to the writer. Condition 2: If Reader 1 has at least one feature, but Reader 2 has zero features for the given ID, then: Write the feature from Reader 3 that matches the given ID to the writer. I'm looking for the best way to implement this logic in FME.  Thanks for any advice or examples!

Hello,I am struggling with a similar problem as this post (I think?).  One of my attributes in the Workspace contains a 0 or 1 that is used as a Boolean.  The value has been assigned the datatype ‘buffer’ in AttributeCreator and ‘string’ in the FeatureWriter, which outputs an Excel file.  I am using a template, where the cell format is set to ‘General’.For some reason, the Excel file that is generated will give me inconsistent formatting of the attribute value:  What is going on here??? As you can see, even though they all should be interpreted as strings, some of the values become numbers.  The formula bar do

Hello, All my data is in Excel spreadsheets. All the schemas are the same.I have two readers:The Updates Reader includes the 3 records that have been changed. These 3 records already exist in the Address Reader spreadsheet.The Address Reader is the original spreadsheet that includes these 3 records before they were updated. I would like these updates written to the Addresses Writer which creates a new excel spreadsheet with the 3 records updated but no new records added. In my workbench here, I run it, and the results are the 3 records are added to the 95,393 thus the new spreadsheet has 95,396 records in it. Having the 3 records added results in having 6 duplicate records whereas previously there were no duplicate records. I need the Addresses output to be 95,393 records with the 3 records I mention previously updated. I have tried changing all the parameters in the Writer with no success. The results are always the same, 95,396.

Hi there I would like to scrape the data from this page. So want the lat/longs of the pins on the map and the background water outage data. I can't find an easy way to scrape the data and am just going around in circles trying to extract the data. https://www.ccc.govt.nz/services/water-and-drainage/water-supply/maintenance-and-repairs/water-status-map/#12  

Hello, I’m trying to dynamically add a suffix to selected attributes using BulkAttributeRenamer.  I want the suffix to be the day the script is run and expressed in YearMonthDay.Example: the attribute is “addresses_count_“ and using the BulkAttributeRenamer and running the script on the 24.10.2024 I want it to be “addresses_count_20241024”.I tried using UserParameters. The first parameter I made was a Text Type Parameter where before the script is run the User needs to input by hand the Date. It has a few flaws. For example, the user may enter the wrong date, the date is not entered automatically by the script and will not always be processed correctly by BulkAttributeRenamer.The second UserParameters I made and think it is the right way to do it is a Scripted Type Parameter. Below you can see what I made.I have no

Hey Folks.I’m trying to move files from one folder to another after execution but it’s not working properly.I have tried using filecopy writer by selecting move option, but copy is working properly but its not move.I have also created attributes - filecopy_source_dataset, filecopy_dest_dataset, filecopy_dest_filename. But I’m not getting what value should i give into these attributes.Kindly help. Thanks in advance

I need to connect to an api that requires a bearer token in the header for authentication.This token should be generated with a jwk. Example to request a token (there are public available examples from the service, so no secrets from my side):POST /op/v1/token HTTP/1.1Host: authenticatie.vlaanderen.beContent-Type: application/x-www-form-urlencoded grant_type=client_credentials& audience=8ed36a78-8443-11ec-b334-83e86b606670& audience=9e6a512c-8443-11ec-ae2c-8700eb2a0cde& scope=org_api_appread%20org_api_appwrite& client_assertion_type=urn%3Aietf%3Aparams%3Aoauth%3Aclient-assertion-type%3Ajwt-bearer& client_assertion=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiIyODM1ODgxNC01YzIwLTRjMTMtYmJmZi1kYjVkZDhjNGFlOTMiLCJzdWIiOiIyODM1ODgxNC01YzIwLTRjMTMtYmJmZi1kYjVkZDhjNGFlOTMiLCJhdWQiOiJodHRwczovL2F1dGhlbnRpY2F0aWUudmxhYW5kZXJlbi5iZS9vcCIsImV4cCI6MTU5MjIwODA2MCwianRpIjoiRGt6bm