Creating and organizing workspaces. How to use Workbench.
Recently active
I’m trying to identify the vertex/vertices in a 3D dataset which are at the zmin.The task is very easy but I’m trying to figure out the fastest/cleanest way to do this. The dataset could be quite big and the geometry could be any type (not point cloud or raster).
Hi,I need your help.I would like to read the data from an excel file that change every week. Moreover the excelfile have a different name every week.I would like to try to automate the process and as an input i would like to have the directory instead of the file. How can I do that? Thank you for your answer.Pauline
How to modify Adjacent feature to find a value of two next cells?Thanks
Hi all,I just wanted to get an idea on how others are working with FME when it comes to inspection.I have FME configured to always open up the FME Data Inspector rather that the Visual Preview in Workbench. Mostly I do this because I like to have a larger window and I’m used to it from the pre visual inspection days.Am I missing out? Any tips on using the Visual Preview? I’m interested to hear from other on how they handle inspection
Hello , I would like to read all versions name without selecting them in feature reader arcsde esri i need to let feature reader to show me the data from all versions from users ,to know which data that users are currently working on .could someone advice me ?thanks in advance
We have hundreds of mappings we execute via command line. We have implemented standards regarding the use of source, destination, and logging user parms.We started our 2024 migration and found a bug while trying to pass in our --LOG_FILE parm from the cmnd line (fme ...fmw --LOG_FILE xxx).The workspace will not execute and throws this error:ERROR : Unable to open log file `X:\...\FME\X_\...\Log\mapping_name.log'ERROR : The preceding error has occurred during FME logfile setupFor some reason, in 2024 it is always prefixing the log location with the location of the fme workspace.The only workaround I found to get the log file to write in our desired location was to eliminate the --LOG_FILE parm and use LOG_FILENAME instead.I have opened a ticket with Safe and have not heard anything back. Having to modify hundreds of workspace executions is a show stopper.
I have a unique problem. I have a set of polygons which take the shape of numbers. In the example below, the number 1875 has been extracted from a raster. As it sits, the 4 numbers are separated but could easily be aggregated. I’m looking for a way to convert this value ‘1875’ to an integer attribute.I can’t think of a way apart from some kind of AI solution, but thought I’d ask the collective to see if anyone has any thoughts?
I want to convert a tiff to TINrelief in citygml. Is there a fmw workbench file or step by step guide for this? I’M a complete begineer to fme and citygml format.
I have an AGOL text field with a limit of 1000, but the reader appears to be cutting off the fields at 255 characters. It appears to be happening in the reader directly, not later on in the translations. Any workarounds on this other than just adding an additional text field, or is this a known issue of the AGOL Connector?
Hi,I have a parameter that I have set in an FME Server/Flow app that is conditional on another parameter. I.e. The first is set by the user in an app. If there is a certain value, then it would require you two set a secondary variable.I used to have this set as a simple ‘dropdown’ choice, which then would require a simple text input (if needed). I tried to change the original parameter to a ‘choice list’ instead, to make it easier to follow, but this is causing me issues.When I preview how this looks in FME Form it works exactly how I want to. Though when I try to on Flow it doesn’t show/require the secondary parameter. Is this a bug? Or something I can fix? I am constrained to version 2023.2.1.0 (23774) for at least the foreseeable futureAny advice would be appreciated, I can’t seem to get it to work no matter what I try
Hi,when writing using a dynamic Excel Writer (in my case there are no columns defined at design time - see attached screenshot), the font settings get lost in the output file and also in the Feature Type Writer itselfs when I double-check it.Has anyone solved this issue?Thanks!
Hello Forum, I’ve set up a simple workspace to convert a csv with eastings and northings (EPSG:27700) to a csv with long lat (EPSG:4326). This is working OK. The workspace is something I’m going to use quite often, so I’m keen to automate it as much as possible. Is it possible to automatically make the ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) the same as the input csv name. For example, if my input csv is called ‘Properties030225.csv’, then when this reaches the FeatureWriter the default ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) is ‘Reprojected’. Instead, I would want that default csv file name to be the name of the input .csv. In this case, Properties030225.csv. Yes, of course, I could type in Properties030225.csv in, but I don’t want to do that every time. Instead, I want it to automatically pick up on the input file name. How can I do this? Thanks,Stuart
HiAttached is workspace what wrong with it, as I can't write the output in to feature class inside esri gdb.
How to convert the neatest distances in neighbour finder to individual lines?
Hi there,I recently installed ArcPro 3.2 on my machine with the data interoperability extension. Looking under the hood, the data interoperability extension uses this FME version, FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64). When I use the WorkspaceRunner transformer to run a simple workspace (read a text file and view in inspector), the transformer fails to read the published parameter, is says "Specified workspace has no parameters or could not be read". If you run the workspace using the workspacerunner, it gives you an error, "2023-08-03 14:20:14| 2.3| 0.0|ERROR |WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner_df4bad67_c886_4b16_8145_a18050c02ff01_runner {} {F:\\ETL\\TEST\\Workbench\\TESTING/workspace1.fmw}' -- unexpected token "END" at position 0; expecting VALUE". Is this an
Hi everyone,I have a question about the Reprojector. In the reprojector in FME Form, my desired coordintion systems are available: But when I publish it to FME Flow, some of the coordinate systems are not available to select from: Could you please help me to solve the problem? Thanks!
I use FME Form in different environments for different purposes - on my local workstation (laptop) and also on our virtual desktop environment (VDI, Citrix, headed toward AVD). It was difficult to work across two distinct environments, first with workspaces, but further related to web and database connections.We have OneDrive on both, and while it may not be supported or advisable (but I’m interested to hear from Safe and/or from the community on this point), I have had no (known) complications due to using that for my workspaces and connections. If OneDrive is chatty, or you are concerned about locks or other issues, syncing can always be paused while working within Form.To get the connections working, in Form, I go to Tools, FME Options, Default Paths, and then update the Connection Storage with Database Accessibility: Shared, and set the Database Folder and Shared Key Folder to a location in my OneDrive folder structure. I did this in both environments. If there’s a better way to do
Hi,I need to set log file path as a parameter. So I ‘ve added User parameter LogFile and linked it to log file inNavigator-Workspace Parameters-LoggingI’m running my workflow as follows:"C:\Program Files\FME2\fme.exe" C:\FME\mz\WybranaSiecPomDgn2k.fmw --LogFile "c:\Folder1\File.log"The problem is, that “c:\Folder1” folder does not exists, and the following error appears:“Unable to open log file `c:\Folder\File.log'. The preceding error has occurred during FME logfile setupProgram Terminating”I was trying to create “c:\Folder1” folder using Scripting-Startup Python Script, but it doesn’t help, probably because FME tries to create log file before Python script execution.
I have a user parameter that I use when writing out the file in Form ("$(ProjectID) Report.xlsx"). This works as I want when running in Form, but not when I publish it to Flow. The parameter doesn’t get set a part of the filename (_Report.xlsx).Any ideas what I need to do differently to get the same filename in Flow that I get in Form?
I have a closed polygon dataset that I need to add angle labels to the internal angle.I just wanted to see if anyone has done a similar thing or has some advice on the best way.I am using the “VertexAngleCalculator” transformer which gives me the results for the actual angles but need to figure out the before and after lines to the calculate the position and angle of the label so it is just offset from the vertex and angled midway between the before and after lines towards the interior of the polygon.
Does anyone have (or know where I can find) the workspace and sample data for the Travelling Salesman blog post from 2016 (or later)?https://fme.safe.com/blog/2016/11/fmeevangelist158/ ThanksDavid
Hello, I’m struggling with the logic/approach on this one. I have a spreadsheet of fuel filters. So in the spreadsheet, it looks kind of like this: Unit#/Fuel 1/Fuel2/Air 1/Air212/abc123/abc223/airf123/airf12413/abc123/abc212/airf123/airf124 I want to create output data that looks something like this: Unit/Filter Class/Filter Number12/Fuel Filter/abc12312/Fuel Filter/abc22312/Air Filter/airf12313/Fuel Filter/abc12313/Fuel Filter/abc212 Hopefully this makes sense.Any thoughts on an approach, or some transformers I should work with? Cheers!
Overwritting .shp files gives mixed results so my workaround is to delete the .shp file(s) first and then create the new version. But I can not figure out how to do that --I read somewhere that writers have a ‘delete’ setting for the ‘fme_db_operation’ parameter but I can not locate that anywhere. Can anybody tell me if FME has the ability to delete the .shp files in a folder? Thanks! Lewis
Hi all I am trying to compare two databases which contain similar and different geometry files. I am trying to figure out which geometry's are the same and which are unique to each database. A few big issues I have is the complex of the geometry and even the SAME geometry's has been captured slightly differently; even thou it's of the same area.I also have no data to help identify which geometry's are the same.Example of 2 similar complex geometry's - zoom in to show compilation differencesI am currently struggling to figure the best solution to my problem, the geometry can be complex with donuts and multiple areas representing the “same” geometry. I can't find the sweat when I simplify the data enough to get a match and not corrupt the data too much that everything matches. I have added two SHAPE file, containing 7 Features each, with 6 that should match and 1 that should not.Any help or ideas would be appreciated
I am getting this error with the HDF connector, it seems imp was removed in 3.12 which ships with FME 2024, it seems IMP is deprecated in python 3.12 that ships with FME, would a repoint to a custom python interpreter of 3.11 fix this issue ? or any other thoughts 2025-1-21 12:20:37 | Message Type: fme::internal::_v0::py::Exception 59 2025-1-21 12:20:37 | Python Exception <ModuleNotFoundError>: No module named 'imp' 60 2025-1-21 12:20:37 | PythonFactory failed to load python symbol `hdfsconnector.hdfsConnector.HDFSConnectorFactory'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date