FME Form

Hey hey ... I'm successfully writing feature classes from ArcGIS Map Server layers to GDB. My writer names and schema are defined dynamically because I'm iterating over many service layers (with a feature reader, driven by CSV rows).  I was able to name my feature classes based on a field (readable layer_name) other than the fme_feature_type, but rightly the writer strips s p a c e s and ( parentheses ).  I'd like to use the unmodified layer name as the geodb_feature_class_alias by setting a format attribute (which is exposed and connected), but it doesn't seem to ever take.  Advice on how to set this up is much appreciated. Thanks in advance.  

I want to log some workbench results directly to a database. As a template to start from I followed this example https://community.safe.com/s/article/shutdown-python-scripts-in-fme#ex3Works greeat, only issue is fme.totalFeaturesRead and fme.totalFeaturesWritten evaluates to 0 when there are 10'' objekts in my workbench which is dynamic. How would one go about to get the totalFeaturesRead and written for a dynamic workbench? fme.totalFeaturesRead i evaluated if a regular reader is used. But i am using FeatureReader / Writer - in that case it is not reported. But why not?

Hello,I have a SalesForce account that is working but for somehow I'm not able to read data with FME.When setting my account, it was first asking me my username and my password   After fixing this, now I'm not being able to create the web coinnection for Saleforces. I'm only receiving the following error message . I went to manage web connection and tried to test the web service for Saleforces but still the same error.Any ideas?

Hello, I have a workspace that is attempting to look for substantial changes to the schema/attributes of client data by comparing a past dataset to a new dataset. It does its job well, except for when it freezes. Irregularly, when processing one of its featurereader transformers, FME freezes completely. When it does freeze, the FME process is hung and will not stop/free the license until the machine is rebooted.  I am running this workspace via the CLI, but the freezes have happened running from the GUI as well. When it freezes, the log file appears to be attempting to either find a plugin to use for the file, or merging the schemas (based on the last thing written/what would be written next). The freezes sometimes happen on the first featurereader, sometimes on the second. I have grabbed the last lines of the log file below from a recent freeze. This workspace normally takes ~90 seconds to complete, and is still running 16 hours later. I've waited over 4

Hi,I have a process where I have identified the closest two points to each point (using the NeighborFinder), then created polylines from the source point to each of the closest points, using the VertexCreator (Add Point, closest candidate x, closest candidate y). The process runs and seemingly creates the lines (attribute table shows the features), but the lines aren't visible in the inspector nor when I write them to a .gdb. When I click in the area where I know there is a line on the inspector, the attribute table selects the record - but the line isn't visible? Has anyone experienced this before?

I've tried following the steps here: Article Detail (safe.com) but my kmz folder name doesn't appear in the "Select Feature Types" dialog

Hey Safers ... Long time listener, first time caller. Go easy!  See below, I'm iterating over rows in a CSV, using these to build ArcGIS Map Server URLs, pulling features from the services, and writing them out to GDB (eventually SDE) feature classes.  I use the Map Server layer numbers to build my URLs, in turn these layer numbers are assigned to my schema and feature_types, and eventually become the feature class names in my GDB.  Has anyone got any pointers on how I can use the more friendly layer_name values to name my feature classes? Thanks in advance! Sam  

Calling all FME Community Members! With the official release of FME 2023.1 comes a brand new AI-powered tool: AI Assist. This new AI feature can be found as a component of our Regex, SQL, and Python editors, which accompany a variety of our transformers and formats. AI Assist is ready and available to help you generate code for your queries or custom functionality in FME. 

Feature cache works great as a method to inspect all transformers after a workbench has ran, but causes a few issues for me.it hurts performance to cache each and every transformerI lose all the cached data if FME crashes or I close the workbench.I am looking for advice on ways to cache or otherwise save output from only a few transformers. My only idea is to write features out to a file, and later bring back in with a writer. are there other transformers I may not be aware of that can save/recall data after restarting the workbench? 

Is it possible to restore the cached data from a ran workbench that has been closed or crashed? I am running a heavy dataset (10s of millions of features) and it takes several hours to run. As I troubleshoot the workbench after, I am bouncing around between the cached inspectors for each transformer. My workbench has been crashing often in this process, and I wish I could re-open it and get back to the full cached state without having to re-run it.

I would like to write features to a local file to read back in later and looking for the best file type for performance.My local machine does not have any DBs to use for this purpose (Oracle, SQL, etc)so I am limited to files I can save to a PC folder.Does FME have it's own DB file type that I could be utilizing? I tried FME Feature Store (FFS) but it has limited functionality, such as not being able to set truncate or table drop on runs. And it's main purpose is to add encryption which I don't need and seems like it hurts performance.I have read on here that CSV is very high performance but I don't want to lose metadata such as data type, len, etc.Excel has a feature limit that does not work for me. 

I've PostGIS table with two geometry types - Point & Polygon. When I read table, I'm only able to see Polygons. But point geometry column is only shown in table and unable to visualize. Is there any way to visualize point geometry instead? How do we explicitly mention for which geometry columns to be visualized? Thanks!

Hi there,we have a workspace where we check with a HTTPCaller, if an URL has data to download. This workspace works perfectly in FME Form.  If we notice, that there are no data available, we want to become an E-Mail in order to react on time. We have created an automation in FME Flow with an E-Mail-block.  Now we do not know how can we make the match: No data to download (FME Form) -> Action failed way in FME Flow in order to send the mailData to download (FME Form) -> Action successful in FME in order to log a message how can we make it? Thanks a lot in advance

My python code is working fine outside of FME but it fails inside of a PythonCaller. The documentation doesn't give any information about the scope or execution context in which the code inside a PythonCaller is run. What are the restrictions when running python code inside a PythonCaller? Why does it not run the same code that you can run outside of FME? (while using the same installation of python in FME and on the command line)I'm trying to use concurrent.futures.ProcessPoolExecutor for parallel processing in Python inside a PythonCaller but I'm getting this error:from concurrent.futures import ProcessPoolExecutordef test(x): return xwith ProcessPoolExecutor(16) as executor: result = executor.map(test, range(0,10)) next(result)Python Exception <PicklingError>: Can't pickle <functio

I am creating the desktop version first but it will eventually be published to FME Server so the specific file choice would need to be done using a user parameter.Ideally, I would like the generic reader to be able to accept any of the following file formats: feature class, shapefile, GeoJSON and CSV. I have created a published user parameter for File/URL which would allow the user to locate the file they wanted to run through the workbench.Currently, when I try to add this user parameter in as the Dataset for a generic reader, I get the following error:Workspace generation failed. Parameter file was C:\\Users\\********\\AppData\\Local\\Temp\\FME_1697209596703_9204. I have also set up a workbench where I tried filtering to feature readers for specific formats e.g. feature class would have it's own Feature Reader where the Format is: Esri Geodatabase(File Geodb) and the Dataset is still my user parameter. However, in

Hello everyone, is there any way how to generate next letter of alphabet? E.g I have feature with value "A" and I wanna generate next letter in alphabet, so letter "B". Is there any function for that? Thanks a lot! Lubo

I've followed this article https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0Initially I was able to read features. I've come back into the workspace after a week and I'm getting this error Type: 4, Number: 1, Message: Failed to get authorization query string.Updating access token for 'WebServiceSanDiego'JSON Error: refresh_token expiredUnable to update access token for 'WebServiceSanDiego'I've re-tested by webservice by going to preferences, manage service and test (requires you to login), but it's still not working. I would assume I'd only have to set this up once and it would refresh itself going forward, or is this something configuration wise on the portal end? Note, this is somethi

Does any one know how to read the latest file from a One Drive folder. I'm able to select a file from the One Drive folder using a Microsoft OneDrive (Graph) web connection, but I can't find a way to read all the files in the folder and then find the latest. I have read the question regarding reading the newest file for a folder https://knowledge.safe.com/questions/65203/read-only-the-newest-file-from-a-directory.html. It's very helpful condeptually. I would appreciate an thoughts or insight. Thanks,Frank

Hi, Is it possible to upload an entire folder from a local PC to Flow Shared resources, via server/automation app? I know that single files are able to be uploaded, but I was hoping my workflow would go like this: User uploads file via web app. It is stored in Shared resourcesSeparate workbench uses a Path reader on the file, gets all .shp files and performs ETLI can't see any other way to do it, other than the user having to upload 20 different shape files via the app interface. I get this warning when using FME copy writer, with s published parameter of 'filecopy_source_dataset':File Copy Writer: Feature contains an invalid source dataset 'C:\\Users\\myuser\\Documents\\Development\\FME\\UPLOADFOLDER'. No file operations will be performed for this feature Many thanks, Sam

Hello everyone,Is there a way to drap a 2d surface or polygone into a 3d surface (like in the picture joined). If there is in which format do we need the surface and polygone to be? Thank you in advance

I am using a SchemaScanner to prepare a dataset for dynamic writing to a PostGISWriter. How do I write to the columns for PrimaryKey and Geometry in an dynamic environment?

I haven't been able to figure out a way of disabling the Startup and Shutdown Python scripts I have setup in my workspace. When running my workspace for testing, I don't want the Startup or Shutdown scripts to run since they relate to moving and renaming files and folders that just fail when I'm running tests. Does anyone know if this is possible? Thanks!

I want to turn my vector layer into a raster layer and then back into a vector layer to simplify it. When I used NumericRasterizer, I grouped my layer by category, but when I convert it back to a vector layer, it's not working. When I tried to rasterize it without grouping it, it worked fine, but I lost the attribute I was interested in.

Hi there,We have an excel file with an easy table. Just 2 columns: Position and Id. The file has about 100 lines.We want to read the file and process each line. We have tried with a custom transformer but we are not able to process the lines individually. If we read the Excelfile we get the 100 lines and all lines will be process at the same time. If we convert the lines into a List, we get the error "Transformer/Factory test_loop_2_ListBuilder is blocking and cannot be used in a loop, but was found between 'Loop to test_loop_2_Looper1697190238 Input Splitter' and 'test_loop_2_Looper1697190238 Input Splitter'".  Has anyone an idea to make it?I have found this link (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/transformers_custom_looping.htm) but it helps me only

UPDATE: Managed to figure out what went wrong in my comment below the main post (TLDR: Used the wrong transformer and field value from my dataset) Hi, so I'm trying to convert my annotation layer in my GDB files along side the point, polygon and line layers into DWG. In my screenshot of my ArcGIS Pro instance, you can see the various labels above my polygons.But it looks like only 2 of them passed through to DWG when converted through Workbench.In my current worksp