Creating and organizing workspaces. How to use Workbench.
Recently active
I have 4 files I need to rename. To rename them I need to add the values of an attribute in a table to each of their names; please refer to the screenshot for this example:SS000001.PNGwould be renamed 18085SS000001.PNG by adding the value from the STCLID Attribute in the table in the screenshot to the filename. Seems as a first step would be “move” the values in the STCLID attribute to the <missing> rows? What is the best way to go about this?
Hi there, I have a mapinfo table and I would like to split the table into multiple tables - one for each object. Also one for particular attribute related to the object - eg libary and community centre. And then write these out and save as multiple tables. I would be grateful for some advice. Many thanks
Hi Community, I am developing a workbench which is reading and writing data to ArcSDE Geodatabase. As per the information which is available in the Knowledge base I need to have ArcGIS Enterprise(Server) Software to be installed and Licensed in the same machine of FME Flow installation. Here my question is: If I have the ArcGIS Server License which is installed in some other machine, can I assign the License with the FME Flow machine?
Hi I have an address that I would like to access with login (username/password) using HTTP Caller but I am not able to pass the username/pwd forward using POST.Webaddress is php, any ideas?
Hello!I need help with this process:The process was getting dwf file, download it and signed manually on it. We want to automate the process, by approving and adding notes in the crm system we have developed for him, and by clicking(and sending fme form's webhook), fme will get the notes and write them on top of the new dwf. I run into several issues:irst: Write directly into the new file, The new file goes completely wrong.And second, the _Markup is not written correctly as well.The fmwt is here.I would really appreciate help with that!Thanks!
I’m looking to determine the number of line segments (green) to the end of a network branch (road network) from a given point in the network (red dot).Ultimately, I want to do this to be able to determine if a network branch is a dead-end up to a certain threshold of number of road segments (i.e. 30 segments, but would not consider 5000 to be a dead-end...threshold to be determined)I feel like using the StreamOrderCalculator to determine the Strahler Order is almost what I want except that loops may be present (as shown in teal) which removes that option.I’ve tried various things with the Stream and Network transformers, but can’t seem to figure it out.I’ve also tried with a PythonCaller, but I really struggle to translate a Python solution on dummy values to one that actually uses features and their geometry. I feel like I spend hours fiddling with syntax.Any ideas would be greatly appreciated. Thanks.
I have a project to automate creating an OWX file to import into IHS Kingdom Geoscience project. I can manually download an OWX well header file from Enverus Prism. This file is in ascii format and can be viewed in Notepad ++ . I do not see a transformer the can read or write the wellheader.asc file. My guess is I would need to create a custom transformer and then parse the data. Landmark may be the original vendor to use this OWX file format.
My dwg writer is saving as type ‘file’ with no dwg association. How do I write as dwg and can someone explain what causes this?Thanks!
File "C:\Program Files\FME\python\requests\adapters.py", line 348, in get_connection raise InvalidProxyURL(requests.exceptions.InvalidProxyURL: Please check proxy URL. It is malformed and could be missing the host.2024-04-02 08:44:16| 0.1| 0.0|ERROR |Error encountered while calling method `input'2024-04-02 08:44:16| 0.1| 0.0|FATAL |SalesforceConnector_CALLER (PythonFactory): PythonFactory failed to process feature2024-04-02 08:44:16| 0.1| 0.0|WARN |An error has occurred. Check the logfile above for details2024-04-02 08:44:16| 0.1| 0.0|INFORM|Translation FAILED with 4 error(s) and 1 warning(s) (0 feature(s) output)2024-04-02 08:44:16| 0.1| 0.0|INFORM|FME Session Duration: 4.2 seconds. (CPU: 0.0s user, 0.1s system)2024-04-02 08:44:16| 0.1| 0.0|INFORM|END - ProcessID: 16004, peak process memory usage: 80016 kB, current process memory usage: 80008 kB
I have many workbenchs and some of them are quite complicated. I would like to write a description of all the steps. Are the workspace parameters the best place to write the description and the steps? Thanks :)
I would like to split a polygon into it’s segments, so that the result is seperate segment-features (lines). Does anybody has an idea for this?
I have 3 published parameters where the user inputs values for buffers. All three were created as Numeric parameters, with numeric precision set to Integer. I would like to extract the largest buffer value in a python scripted parameter. This is the code I’m using in FME 2023 (build 23332)buffer_list = [FME_MacroValues['BUFFER1'],FME_MacroValues['BUFFER2'],FME_MacroValues['BUFFER3']]buffer_list.sort(reverse = True)return buffer_list[0]What I’ve discovered is that if the 3 buffers are the same number of digits, the script will return the correct value. If the number of digits is different, it will not. Some examples:10, 40, 50 = 50 (correct)120, 60, 70 = 70 (incorrect)120, 180, 70 = 70 (incorrect)120, 200, 300 = 300 (correct)It doesn’t matter which order the values are input, nor does it matter how the parameters are sorted in the parameter list.Is this a bug, or am I missing something?
Hi!I want to add an attribute to geometry - is this done with the geometrypropertysetter?For instance, add ‘water asset’ to a cylinder but not as a layer name rather as an data tag / table.I ultimately want to be able to bulk add them however am starting with a simple test case.Thanks.
I am comparing records from two sources. I want to sync the records from one source to the other source. I am using ChangeDetector to do this (Workbench 2023.1). Output wise, what is the difference between these two workbench configurations? (one with the FeatureJoiner and one without the FeatureJoiner). When I look in the output database, as far as I can tell, I am getting my desired outcome without needing the FeatureJoiner but I want to make sure I am not overlooking something.Is it necessary to use FeatureJoiner on the records coming out of the “updated” port of the ChangeDetector before pushing the records to the ESRI Portal Feature Service writer? The examples I am coming across are using a FeatureJoiner after the ChangeDetector for the updated records e.g.:https://support.safe.com/s/article/how-do-i-write-updates-to-an-existing-arcgis-onlin
Hi,I’m trying to apply a schema from excel to 2D utility lines so that it applies the schema to the lines and creates 3D pipes of the same size, also adding the metadata.I have an idea of how to put this together, however am struggling to select the right information from the excel and make it dynamic.Example: If find ‘water’ in dwg, then apply a 200mm pipe to the center and add ‘water’, metadata1, metadata2 as attributes to the line. Thanks in advance!
There was a discussion from a year ago that suggested that the Esri Portal Feature Service Reader was updated in FME 2023 build 23210 to resolve domain values when the domain is applied at the subtype level of the featureclass, as it is in the Esri Utility Network.Esri Utility network reader subtype layer | Community (safe.com)I am still having trouble getting a domain resolved that is at the subtype level. Maybe I’m doing something wrong? FME2023.1 (build 23619)Using the Feature Reader transformer: Portal Feature Service of my UN data, layer is PipelineLineLooking at the attribute material:In the schema result from the reader I see attribute name: materialattribute name: material_resolved But in the data result I only seematerial: Mand no material_resolved attribute that I can find. But I can see that other domains resolved, like manufacturecomponent
Hi,I am a very basic Flow/Server user, but handy enough at Form/Desktop. My company recently upgraded from 2022 to 2023. I have noticed after the change a few of my workspaces no longer have their description appearing online and I can’t work out why this wouldn’t.For example, in the workspace description I would usually put a basic description or some instructions. I then publish it to Flow, and it used to be that the description would be in the online interface. Does anyone know what’s going on and how I can make this reappear?It used to appear here:The workspace does have a description:
Hello everyone,Is it possible to extrude a surface through its normal instead of the vertical?Thank you:)
This may end up as an Idea, but wanted to ask the community first: I have been trying to find some way to generate pdfs of floor plans that will contain annotation objects at specific coordinates, labeling things in the floor plan where the annotation can then be edited/appended. Also, I want to ‘embed’ a GUID in each annotation that can be used to link back to other systems. Use Case:Taking a pdf of floor plans onto a construction site, making comments on the provided annotations that can later be loaded into a Revit model by leveraging the GUIDs that came from Revit objects. The pdf could be generated directly from a Revit model, or coordinate and GUID data could be extracted separately and added as a layer. You can imagine most buildings contain hundreds if not thousands of components that need to be maintained and tracked. This is a universal problem for building owners and maintenance personnel. As far as I can tell, there is no way to create these objects, only tooltips
I am running a workbench that uses dates as parameters. If I run the command in a windows cmd window without admin privilege's, the date parameters are not passed into the workbench. When I run the cmd window with admin privilege's it work as expected. I am fairly new to FME and I am not sure what I am missing. Any insights are appreciated. string passed to the cmd window:"C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\fme.exe" \\myserver\myworkbench.fmw --SourceDataset" --SourceDataset" --SourceDataset" --DestDataset_CSV2" \\myserver\myfolder\mycsv" --odbc2_where_clause "(reptd >= '2024-2-1 00:00:00' AND reptd < '2024-3-1 00:00:00 00:00:00')" --FME_LAUNCH_VIEWER_APP" YES"
Is there a setting to disable the translation log window from automatically popping up when running a workspace? I’ve disabled all logging and hidden the window, but it pops up as soon as I run. I’m trying to record the execution of the workspace for a presentation, and the window keeps getting in the way.
When using the Transaction Type: Versioned Edit session in an ArcSDE geodatabase writer, all edits will be rolled back in the event of a translation failure. The geodatabase writer is set to Insert records in my workspace and I noticed numerous duplicate records after the translation failed due to conflicts identified during reconciliation. Do we need to modify anything in the writer? Thank you!
I’m a newbie using FME although I have also experience with SQL and GIS. I recently started working on a transformer using the AttributeManager. This contains ~ 40 attributes and the goal is to convert part of those attributes based on different conditions, and others attributes based on a same expression: @double(@CurrentAttribute())I was wondering if there was a method to apply the same attribute expression on several input attributes at once while keeping everything in one transformer.Thank you in advance!
I have a column of data with a 10-digit alphanumeric value. I need to keep those values and in a new column return just the last 5 characters of that columnI thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost. I use this exact same string function in MapInfo all the time and it works like a charm. But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.What am I doing wrong?results inThanks in advance
Hi Community, I am working on developing a workbench which is basically reading Data from ESRI Enterprise Database and Writing to another DB. I am using ArcGIS Pro Version 3, FME Desktop Version 2022 and FME Flow Version 2023. I am able to connect and read data using FME Desktop But the published workspace while reading the data it is showing error “779 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 780 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 781 2024-3-19 11:07:16 | Performing query against GEODATABASE_SDE dataset `' 782 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 783 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 784 2024-3-19 11:07:16 | Opening the Esri Geodatabase reader 785 2024-3-19 11:07:16 | An ArcGIS license is already checked out. The product checked out is 'Advanced' 786 2024-3-19 11:07:16 | Ins