FME Form

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

I have a point array of addresses, and a line geometry layer of streets, and I need to be able to get the ID of the nearest line to the point that also has a couple matching attributes. What are the best options to consider?

I am using the feature writer to write new column into a geopackage database. Instead of using the default geom I need to change the name to Geometry, but the writer does not seem to accept the spatial column to have uppercase characters?When I specify the spatial column to be called Geometry it is being writter as geometry in the table. Any ideas how it can be solved? 

What, if any, are people's experiences using FME with python v3.12? any new foot guns or tar pits?

I want to move files from one folder to another. I have added the FileCopy Writer to my workbench and set the parameter to Move, not Copy. I am using FME Desktop 2021.  I think I am missing something because when I run the workbench it runs successfully but no file gets moved. I have included screenshots of my workbench.

Although my Sharepoint admin team has already given me the permission for Sharepoint Online Connector, I keep getting the "Unverified" warning.

I have about 1,000 KMLs in a folder, all with the same schema and only one feature each (line features). I want to bring in each KML into a single feature class in a file geodatabase in ArcGIS Pro and populate a field in that feature class with the unique name of each KML. Is there a way to even do this in FME? Thanks!

Hi, everyone, I need to create a lot of feature classes in an Esri File Geodatabase. Creating them one by one in ArcCatalog takes too much time, I'm sure that there must be a fast way by using FME, I just don't know how, can someone help me out or give me some hints? Thanks very much.Here's the attribute description table:

I like to use bookmarks in my workspaces, both to hide stuff, to navigate and to run specific parts. If I collapse/un-collapse a bookmark my organized workspace ends up as below. Anyone recognize this issue? 

id,v1,v2,v3,v4,v522,hi,hi,1,2,322,hi,hi,1,2,322,,,,,33,hi,hi,2,3,433,hi,hi,2,3,433,hi,hi,2,3,433,,,,,44,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,,,,,

Hi everybody! I have tried to remove collinear points without sucess. For example, a square(polygon) but between two vertex I have one or more collinear point's. So how to remove this???