Creating and organizing workspaces. How to use Workbench.
Recently active
Trying to free up some space on our existing FME Flow server and noticed that there is a folder on the root C: named “FME” that have various FME installations folders. In each of those folders, there is .cab and other installation (.msi, .exe, .log) files. The total file size of these folders is ~50GB on the server!I cannot find any documentation that states that is okay to remove these files. Does anyone have any information about these?Thanks for any help!-Cameron
Hello, Im using FME form on macSilicon and ran into an error trying to run simple workspaces: /Library/FME/2024.1/fme is trying to execute itself. Aborting to avoid infinite loop. I managed to solve it temporarily by reinstalling the whole package, but after a while it started giving me the same error.Ive tried different workspaces from the tutorials with the same result, I imagine is something about the setup. Any suggestions can help, thanks!
Hi,I have seen a few articles about updating metadata using the ArcSDE writers, which involve writing data and adding metadata simultaneously. However, what I want to do is just add new metadata while leaving the existing data unchanged (without accidentally overwriting it with nothing). I already have my metadata and types formatted as described in the articles I’ve read.xml formatted for esri importHowever, I am struggling to determine the exact settings needed for the writer. Since we don’t have a test system, I want to ensure I’m on the right track before proceeding. That said, I can create some test tables to trial the process. This is a related article which also update the data: https://support.safe.com/hc/en-us/articles/25407507870861-Working-with-Geodatabase-Metadata-Writing-Updating-Metadata Any guidance would be appreciated. I also have an external list that matches my metadata GUIDs to the gdb tables, so my ultimate goal is to loop through all the layers and apply the metad
Hi this puzzles me: using FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64), when reading an Open File Geodatabase from a zip file, features are duplicated. I created and attached a template which demonstrates the error. The workspace uses two readers to demonstrate the phenomena, both of type File Open Geodatabase.The first reader reads from ..\test.zip\test.gdb The second reader reads from ..\test.gdbRecords on the first reader are duplicated. When reading from just test.zip the duplication does not take place. Is this behaviour as meant to be?
Hi, If I’m writing a fme-binary attribute out to jpeg using an AttributeFileWriter is there any way to publish as DataStreamer on FME Flow?
Hi,I am wondering if someone can give me some ideas on how I could pass the result of a sql query from a sql executor so that the result or specifically an ID is passed sequentially so that each is fully processed before the next one starts. So the result is as shown below. The attribute I’d like to pass one by one is either the device_id or the row_index.I have had a look at this post iterating/looping a workspace using attribute values | Community but cannot formulate the workbench to do this task.Any suggestions very welcome.Thank you.fb
Has anybody experienced an issue starting FME Form (tried from v2023.2.1 to v2024.2) when having 3 displays connected.We have 2 LG 24MP60G 1080p monitors conected to a Dell Alienware X15 R1 (Intel Core i7-11800H 4.20Ghz, nVidia GeForce RTX 3070 8GB GDDR6, 32 GB DDR4). In this setup FME opens as a blank white windows.If we disconnect any monitor FME starts as usual.Please let me know if anybody else experienced something similar or if this is a known issue.
Connection to postgres seem not to close after query execution to postgres db. We are here allowed to have 5 connections to the postgres db and with the SQLExecution for each feature entering the transformer, a connection is established but seem not to close after the the query has been executed. After 5 features have entered the sqlExecutor I receive an error message: Error connecting to PostgreSQL database.....................: 'FATAL: too many connections for role "xxxxxxx"Is there a way to close the connection after each featue that enters the SQLExceutor? We are using FME 2021.1
With a permanent licence fme desktop hit much engines do we have available ?
Hello, In the case of having a permanent FME Desktop license, can it be reused on new machines ( i want to use it only in one engine so i would like to know is it possible to use it in anothe engine), or do we need to purchase new ones?
Hello,I’m having a hard time figuring out why a json file created with a Text Writer is not accepted by the GoogleBigQueryConnector.I have an original JSON Key File downloaded from Google Cloud for the Service Account we are using to authenticate to BigQuery. This JSON file works fine and I am able to authenticate and select the Dataset I want to upload data as well as the table in that Dataset.The problem is that since I have to use a system environment variable and specify the service account key file location in that variable in order for the GoogleBigQueryConnector to be able to use Service Account instead of Web Connection, it seems the GBQC takes the project_id specified inside that json file and uses it as default project to log you in, which means that even if you have access to different projects in BigQuery you can only access 1 project per Service Account Key File.Here is an image of the error I get for when the GBQC tries to use the JSON file to authenticate into BigQuery:
Hi,I have a workspace the reads json files: I need to publish this to Flow, and configure parameters to enable the user in Flow to read files from a certain folder. This will change several times, and I do not mind this part being a manual process.I am unsure of exactly how to configure this.I have set up a Folder and Pathnames user parameter:I have configured it to select Folders, and called this “SourceDataset_PATH”. I have then configured the parameter for the json reader to point at the SourceDataset_PATH parameter. I publish to FME Server, run the workspace: I have used “Browse Resources” to find a folder “Test 1 file” and hit Run.If fails after a few seconds:54 2024-11-13 17:17:27 | The file 'C:\ProgramData\Safe Software\FME Server\resources\data\WACSTEST_1_to_5\Test 1 file' could not be opened 53 2024-11-13 17:17:27 | Opening the JSON reader with source dataset 'C:\ProgramData\Safe Software\FME Server\resources\data\WACSTEST_1_to_5\Test 1 file' 52 2024-11-
I have a series of Feature Services in ArcGIS Online. Unfortunately they contain attribute names of varied case. This is proving difficult for me when I try to create a dynamic workflow that updates the data in ArcGIS online. When the Reader reads the source data (also of varied case), it converts them all to lower case.Therefore, when my workflow tries to write to ArcGIS online, it cannot find matching attributes to write to because the case is different.It is now too late for me to change all the layers on ArcGIS online to lower case because of downstream dependencies. Will I have to write a separate workflow for each individual layer and individually do the field mapping?Or is there a way around this ?
From a csv file, I determine the target layers that I wish to update on ArcGIS online.The following 2 transformers build the source layer name deriving it from the csv data.My source data name is an attribute titled “portalservice_andfolder”This is fed to a dynamic reader that reads my enterprise portal for each layer.There’s an issue with the Reader. Refer blue summary for settings.I’m getting all the features come through but only the schema for the FIRST feature type only.Refer the below image which is the result <Generic> port from my reader. The schema port has a count of 1 when there are actually 2 source layers.The image below shows that the fme attributes are missing for the second feature type.I tried throwing in a SchemaScanner after the Reader but still only arrived at one schema. The issue appears to be in the Reader transformer.What am I missing here ?
Hi,I have a scenario where I need to recode the pixels of raster, but the values are determined at run time.I have a list of from-to values, but what is the best way to implement that?The RasterCellValueReplacer will take attributes, but not a list. Is there any way other than looping through the list and recoding the raster one value at a time? There can be anything between 1 and 300 elements in the list.
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) What might be the issue here? Thank you Best Jamal
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