- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,046 Posts
12,621 Replies

When you subscribe we will email you when there is a new topic in this category

3046 Posts

alc33Contributor

Problem with "collapsed parameter/option" in the windows

Hi! Sorry for my english. I have a problem with "collapsed parameter/option" on the “user parameters manager” or “FME options” for exemple. All the options that can be collapsed doesn’t display very well and sometime I don’t see there are a suite. For exemple, if I don’t scroll, I don’t see that “Number configuration” had an option “Numeric precision”. Is it possible to had something like a button or an other way to open an other windows?Thanks !

6 months ago

andrewj74Supporter

asked in Authoring

Feature Reader Excel

Hi i am trying to read lots of excel using the feature reader transformer, passing in the locations form a directory path reader. all the excel have different tab names but the data always start on row 10. As the dataset is a file path the option for telling it to start on row 10 are blanked out. anyone know how i get around this?Many thanks,Andy

729

6 months ago

kwellerContributor

asked in Authoring

ACAD writer ignoring viewport center attributes

So I have a workspace that reads a DWG, and writes another one after setting viewport attributes according to this article: https://support.safe.com/hc/en-us/articles/25407658483341-Working-with-AutoCAD-LayoutsHowever, even though I’ve set autocad_viewport_view_center_x, autocad_viewport_view_center_y, autocad_viewport_center_point_x and autocad_viewport_center_point_y to display the view at the center of the page, I keep getting the viewport centered at 0, 0 in paper space, so my viewport content is centered close to the lower left corner of the page on output. I have quintuple-checked that all the required viewport attributes are set correctly. It seems like the writer is simply ignoring my viewport center settings.I’ve been banging on this for more than a day now, and have made no headway against it. Hopefully some kind soul out there will have an idea of what could be going wrong.The layout pageThe viewport, 1st page of attributesThe viewport, 2nd papge of attributes + geometry

241

6 months ago

achambersContributor

asked in Authoring

Geodatabase SDE connection not working in FME, fine in ArcPro

I have an SDE file I created in ArcPro that works in ArcPro, but whenever I try to add it as a reader in FME (Data Interoperability, ArcPro version 3.2.1) I get a simple error of “MULTI_READER reader: GEODATABASE_SDE reader: An unknown expectation occurred.I tested other SDE connections and they work fine in FME and ArcPro. I have tried generating a new SDE file and connecting with an embedded connection and an database connection in FME. Any other ideas on how to get this connection working? Also, it was working until this past weekend. This is a new issue we have not had before.

522

6 months ago

chaitanyamallaContributor

asked in Authoring

.jpg .jgw with different coordinate system to Geotiff

Hallo FME community, I am new to this FME software and got a task. I have 100 city folders with single .jpg and .jgw file inside each folders. .jgw has x and y coordinates of a reference system. Can anyone tell me workflow with necessary transformers to select each jpg with their .jgw and create their own destination folder and save the Geotiffs in individual folders.

1434

6 months ago

larueContributor

asked in Authoring

Dwg file Errors using RealDWG Reader, but not AutoCad Dwg/Dxf Reader

I am working on a process to read in dwg files, parse the text and assign metadata attributes. I have one file that I am using that had missing xrefs. Using RealDwg Reader, it worked fine. But, when I bound the xrefs, it gave me the following error after reading in most of the file: AutoCAD Reader: An error occurred for dataset '<filepath>\FIRESPRINKLER.dwg', in function RealDWGReader::processDimBlockCommon: 'eNullObjectId' I purged and also made a .dxf file, but still got the error. I am using FME 2023.2.4Using the regular AutoCAD dwg/dxf Reader, it worked no problem. I suspect there is some entity in the CAD file that the RealDwg Reader did not like, but after multiple purges and audits, I can’t find anything to delete. If I am going to publish this Workspace, I need to know if there are things to look for that would help choose the correct reader. The file is in AutoCAD version 2018.Questions: Is this error related to a specific function in RealDwg Reader, or is it just

1073

6 months ago

stuarmitagehomeContributor

asked in Authoring

Is there a better way than using a ridiculous number of Feature Joiners?

Surely there’s a better way than this???I have a json file with lots of attributes hidden in lists. So I use 5 ListExploders to expose those attributes.The ultimate goal is to then combine all of those attribute fields into one massive table, using the unique identifier field of “NODE_ID”.As you can see in the screenshot the Node list then feeds into AttributeFilter to reduce the number of features a little.So far so good… but this is where it goes a bit mad. I then need to combine all of those 5 exposed lists into one table. FeatureJoiners are then used to try to merge the datasets together.Those in the left hand bookmark are joined using an inner join to try to get as many features with the same NODE_ID value combined into the same row in the table.Those in the right hand bookmark then use a full join to pick up any stragglers from the first bookmark.I have 200 JSON files to work on, and this example uses just one of them, so I have to try to account for all output ports, to ensure n

1219

6 months ago

narinderContributor

asked in Authoring

How do I get my FME workbench that uses 2 Readers pointing to SQL tables to be outputted to Excel template writer but the two outputs to saved to two different tab sheets.

I’ve got an FME workbench that picks up 2 seperate SQL tables in the two readers and the data is sorted and the filtered. It then needs to be output to an Excel template containing 2 tab sheets and save the data from each SQL table onto the separate sheets.Test copy of workbench looks like this:This first attempt only outputted the data from the first reader onto both tab sheets in excel.Then did this:So this did pick up both readers but instead of saving the one excel template with the data outputted to both tab sheets, it created to excel files with the data being populated on the tab sheet.Essentially I want to pick up both sql readers, sort them and filter them and then output to the excel template but the data gets saved onto sheet 1 and sheet 2 for example for each reader and then save the one excel file to the drive location!Am I missing a step or should i be using different transformations, etc?Appreciate any suggestions?

362

6 months ago

lorenrouthContributor

asked in Authoring

PythonCaller: No Geometry or original attributes are returned

This script works, but leaves out the geometry and original attributes. My hunch is there’s something wrong with the close(self) function, but I’m stumped. The code takes a feature id number and list of nearby ids from a NeighborFinder list, where it matches them up and assigns a _group_id attribute to use with the Aggregator. Really, it should be part of NeighborFinder. The way I had been grouping features is to use two or more AttributeCreators and assign a common Id from the feature and id list. It’s a hassle because you end up with duplicate features. Very inelegent. I have seen a few posts on missing attributes, but I can’t see how they apply to my code: import fmeimport fmeobjectsfrom collections import defaultdictclass FeatureProcessor(object): def __init__(self): self.og_ids = [] self.closest = [] self.lines = [] def input(self, feature: fmeobjects.FMEFeature): id_number = feature.getAttribute('_count_Glaz_H') if id_number is not

382

6 months ago

lorenrouthContributor

asked in Authoring

'Error Running Translation' immediately in version 2023.2.4. Works fine in v2023.2

I was installing a Python module and pipeline (spaCy and en_core_web_sm.whl) into FME2023.2.4. spaCy installed fine, but pip would not install the pipeline and I got this message: Since then, my FME 2023.2.4 will not work, at all. No translations will work. I made a blank Workspace with just a Creator and still immediately got: “Error running translation”.What’s going on? Did I break it? Do I need to reinstall? My FME2023.2 works fine with the same Workspace.Any help is appreciated.

492

6 months ago

joaniegeo99Contributor

asked in Authoring

Error using User Parameter for FeatureReader dataset

FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64) FME FormHello,I have a set of QAQC workspaces that I’m trying to run in sequence with workspace runners. I have a parent workspace that, using scripted parameters, generates a bunch of output file names where I’ll write the results of the various workspaces, and runs workspace 1, then workspace 2 then workspace 3. I only want to run workspace 3 if my tests ‘Pass’ in workspace 2. So I write out a CSV file called _qaqc_status.csv in workspace 2 with ‘Pass’ or ‘Fail’ as the only attribute; the file location is in with the data and is variable.The problem comes when trying to read the parameterized file name ($(QAQC_STATUS_CSV)) with a FeatureReader; I get the following error message Worker 27572 > CSV reader: Failed to open file '' for reading. Etc, etc.and my CSV doesn’t show up on the output ports. If I hard code the FeatureReader dataset to an existing csv it works fine.Any help is appreciated, or even a workaround suggestion. Th

302

6 months ago

dcoxContributor

asked in Authoring

Help using string replacer

I am trying to join a SharePoint table with no geometry to a set of polygons (about 2000 rows). The table has unique project titles for for each polygon that I want to use as a join field; but the polygons themselves are stored as fgdb files deeper within the SharePoint file structure and they are a non-standardized legacy dataset that I am trying to aggregate (hence why I am transferring them all over to SharePoint as the first step). When writing the fgdb’s I am also exposing the file path as the fme dataset field, so the unique project id’s in the table are a part of that file path. I am trying to use the string replacer to replace all the characters leading up to, and after, the project title with nothing so that only the project title is exposed. Sadly I can’t just count the characters as there are different folders within the file path with different names and character lengths so now I am trying to come up with a more complicated regex expression that will trim the start and th

725

6 months ago

scarterContributor

asked in Authoring

Convert datestamp values to friendly UK date format

Hi, I have a geojson including an attribute with datestamp values. An example value is 202410231836 (year, month, date, hours, minutes - yyyy mm dd hh mm). These are important as I’m running testFilters with it. However I would also like to create a parallel attribute showing an easy to read UK date value from it. So, 202410231836 would convert to ‘31/10/2024 18:36’.I’ve been looking at DateTimeConverter transformer but couldn't work out what import format to use and what output format to pick - assuing that DateTimeConverter is the one to use.Any advice would be appreciated. Thanks,Stuart

415

6 months ago

scarterContributor

asked in Authoring

Force creation of table with no records (null?)

Hello Forum, I have a workspace which reads in a tab file with a start_date attribute and end_date attribute. These are populated with datestamp values (e.g.: 202410281200). That reader flows to a TestFilter which determines if today is before the start date. If so, these records go to a new output writer for sites not yet started. If today is beyond the start date. These then go on to a second testFilter, which determines if the end date has been reached or not. If the end_date has been reached, then this goes to an output writer for historic sites If the end_date has not yet been reached, then this goes to a output writer for live sites. These test Filters are doing exactly what I want them to do. However it can be the case that sometimes there are no sites where the start_date has not yet been reached. In these cases I need the output to be an empty table. However, I’m finding that the flow is failing to overwrite any previously created tables where, for instance, at a time when it

371

6 months ago

fme_can_do_itSupporter

asked in Authoring

Lines within polygon selection using NeighborFinder

I need to select the lines that fall entirely within a specific polygon and update their data with the respective polygon name. I attempted to use a spatial filter, but it didn't work as expected. When a line intersects two polygons, the filter selects and attributes the line to only one of the polygons, which is causing issues. I also tried using the NeighborFinder without success. I've attached a screenshot to illustrate a line segment that should not be selected within this polygon.

344

6 months ago

flying_squirrelContributor

asked in Authoring

Python script with a parameter in a filename.

Hello,I have a script which is written like this:import osparent = os.path.abspath('..')file= os.path.abspath('../file_08-06-2024.xls')return fileI would like to replace the date with an attribute defined in a attributeCreator transformer which could change and i write this :file=os.path.abspath('../file_$(date).xls')When i run, it doesn't work. Can you help me ?Thank you.

james_c_452Supporter

Hi,A very random question. My son has recently started to like making mazes out of Lego for marbles. I was wondering if there was a way in FME I could perhaps randomly generate a maze?I know there are a bunch of generators on the internet, however they do not account for a cell size of 2x2, to accommodate a marble, or a wall thickness of 1. I see there is a generator on FME Hub, but it also doesn’t work because it calls a webpage that doesn’t exist anymore. So I thought perhaps I might have a go but I can’t work out a way to use any maze generation algorithms. I don’t know python, but I’m reasonably handy at desktopIf anything glaringly obvious comes to mind I’d love to hear itThanks

2475

6 months ago

vxn43Supporter

asked in Authoring

Automation Writer in FME Form does not update in FME Flow

I have a workspace in FME Form 2021. It includes a writer for Automation. This writer creates the keys in the Automation I have created in FME Flow 2021. These keys are based on 4 Attributes I created and renamed in my workspace. When I change the attribute names, run the workspace, and upload it to FME Flow, they are reflected in the writer but are not written to the Automation I created that includes this workspace in FME Flow. The Automation still includes the old key names. ...but...after I run/upload the workspace as explained in the above paragraph, then delete the writer and re-add it into the workspace then run it/upload it again, this then it updates the keys in my Automation. Has anyone else encountered a situation like this?

492

6 months ago

rzel24Contributor

asked in Authoring

How To Speed UP CSV Writer

Hello,I was hoping to get your input into how to speed up the following workflow:Read an Excel File with several sheets from a Network Share → Output each sheet to a different output port → Create a CSV file for each output port in a network share.I already have the above working, the problem is that CSV writer is taking a loooong time writing the files. My connection to the network is pretty good so it is not a matter of latency between my PC and the network share (at least I don’t think so).Does anyone have any idea on how to improve the writing speed of the CSV files or what to do improve the overall time it takes for the workflow to complete?.Thanks in advance.RZ.-

knutosContributor

Hi there!I get tons of these messages from some workspaces created with FME 2020 (in Norway) and now migrated to FME 2024: The Startup Python Script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing so may cause unexpected errors. For more information, visit http://fme.ly/PythonLocaleErrorI have read the post http://fme.ly/PythonLocaleError carefully, but it does not give me anything. I have nothing such as import arcpy or locale.setlocale() in my Python-code. The example message above is particulary strange, I don’t even have a Python Startup Script. So something is absolutely confusing here.No Startup ScriptAnother example:PythonFactory script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing

1591

6 months ago

scarterContributor

asked in Authoring

Creating three output ports in one featurereader when reading in three csv files

Hi forum, I’m trying to do something I successfully used many times before. But for some reason it’s not working this time. I’ve delved into it and done research but I can’t work it out. It’s a really simple thing. I just need to read in three csv files with identical schemas into one FeatureReader. I have a Creator, connected to a FeatureReader. In the FeatureReader I’ve selected CSV as the format. In Dataset I selected the three dots (…), browsed to the data source location and then selected the three files. So, now in Dataset I have this: "E:\FME temp source data\Scratch\TestPoints\one.csv","E:\FME temp source data\Scratch\TestPoints\three.csv","E:\FME temp source data\Scratch\TestPoints\two.csv" In FeatureReader I have ‘One per feature type’ selected in Output ports. But, when this is read in, only one output port is created in the FeatureRader. That one output port is called csv and it includes all the records from the three inputs in the one output. How do I force it to create

985

6 months ago

tschoppenhofContributor

asked in Authoring

Correct Settings and Parameters for Database Connection SAP Datasphere

I’m trying to connect to our SAP Datasphere but can’t establish a working connection. The settings and parameters are similar to the ones i used with were i could get a connection. There is a Proxy Server involved.Any ideas what i have to do different to get working Database connection?Not shown in the screenshot is the parameter proxyPassword

1452

6 months ago

bgeorgesContributor

asked in Authoring

Clipping large raster incomplete result

I am trying to clip a ECW raster by a rectangle polygon but the inside output is incomplete. Only a small slice of the ECW is in the output as you can see below.Is there something I am doing wrong? FME 2023.2Thank you for your help

663

6 months ago

lorenrouthContributor

asked in Authoring

Should this be a Batch Process or...?

I have a large Workspace that processes multiple .dwg files along with a single Excel and .dbf file to generate one Excel file with multiple sheets. This works fine when I have feature caching on, but obviously takes a long time. When I try to run it without feature caching, the feature output is a fraction of what it should be, but still gets data from all the multiple dwg files selected, as opposed to grabbing from one file. The only thing that comes to mind is that without feature caching, it does not wait until all features are processed. So, what am I missing? Is there a ‘WaitUntilAllFeaturesAreProcessed’ transformer or setting? Or, should my approach be some flavor of batch processing? I haven’t seen anything in this forum that matches my situation. Any insight is appreciated. Thanks,-Loren

1084

6 months ago

bkggContributor

asked in Authoring

Utilizing Deployment Parameters in Form workspace

Hey ya'll, I've been playing around with deployment parameters in Flow and Form but I have been wondering if it's possible to use an existing deployment parameter in Form, without a database connection that has the same credentials? So for example accesing database X through deployment parameters without having database X defined in your local database connections. I've tried to but to no avail.

504

6 months ago

Page 8 / 122

Badge winners

farshidprohas earned the badge Integrate Spatial Data
gautammotvanihas earned the badge Expert (Grey)
gautammotvanihas earned the badge Teacher (Grey)
gautammotvanihas earned the badge Student (Grey)
nfrihas earned the badge FME Form Basic Training

Show all badges

30,382: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.