Skip to main content
  • EN

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,282 Posts
  • 13,458 Replies
3282 Posts
bhk
Contributor
bhkContributor
asked in Authoring
FME SQLExecutor Returns only an Empty Column

Using FME 2021, and 2023 SQLExecutor, I am running a simple query to return data from a non spatial table in SQL Server, but I am getting an empty column in return The number of rows are exactly 145 and SQLExecutor result is showing that but the visual Preview just showing an empty column (again with correct 145 rows) I even added a AttributeManager to script but same result is happening Can you please let me know what I am doing wrong here?

481
ctredinnick
Supporter
james_c_452
Enthusiast
james_c_452Enthusiast
asked in Authoring
Write DWG with US Survey Feet units

Hi,I am trying to write a DWG file with the units set to US survey feet. I can’t get it to work, its is in completely the wrong spot. I’m not entirely sure you can, but I’m not enough of and expert with FME (or US survey feet).Looking at the help file for my FME version (2023.2) it doesn’t have us survey feet as a possible unit to set the insertion units to.I have the unit set in a template file and that doesn’t help when the help says it should use this when I don’t explicitly set it.I am writing to a 2018 DWG (as that is the newest). I know for older versions of DWG you could not set US survey feetDoes anyone have any ideas? Surely US survey feet is a more common unit than the parsec for a DWGThanks

241
james_c_452
Enthusiast
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Python in fme packages for other custom transformers?

I have a number of CustomTransformers which contain some python - this python may or may not include some third parts python dependencies. It’s not only python, they also use regular old FME transformers as well.I’ve been playing around with the package development guide and doing some testing. I can see how to import third party modules for just normal CustomTransformers. I’d really like to be able to use the package manager tools here to help with dependencies, however, it seems like from my experimenting that fme based custom transformers can not benefit from these tools.Does any one know anything or have any comments on this?

312
virtualcitymatt
Celebrity
jp12212
Contributor
jp12212Contributor
asked in Authoring
Two dynamic surfaces find volume cut fill calculation

Hi, I was hoping to create a workbench that has a base surface and a target surface and finds the volume between the two, is there any way to do that with the below transformer ie. make the base a surface with elevation differentials?Any suggestions appreciated!Thank you.  

620
jp12212
Contributor
sammy
Supporter
sammySupporter
asked in Authoring
Traditional Versioning & GlobalIDs with Esri ArcGIS Portal Feature Service Writer

I know in the Esri ArcGIS Portal Feature Service writer there are parameters to control writing out with branch versioning.Is there similar functionality for traditional versioning?If yes, is there a way to have traditional versioning and preserve Global IDs using the Esri ArcGIS Portal Feature Service writer?

1242
saraatsafe
Safer
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
To and From attributes in Line Feature

Hi, I'm trying to populate the "To" and "From" attributes in the Line feature. I have points snapped to the line feature, causing the line to split at the point. I need to fill out the "To" and "From" attributes. I tried a certain approach, but it didn't work:I buffered the point feature and used LineOnAreaOverlayer, and then the Coordinate extractor to find the start and end points of the line.If there is any other way I can use to accomplish this task, please advise.Thanks!

211
liamfez
Influencer
antheatung
Contributor
antheatungContributor
asked in Authoring
ArcGIS Feature Service Reader - how to auto renew token in workbench

Hello, Using FME Workbench 2022.2 and am able to connect to ArcGIS Feature Service (10.9.1) via the reader with a supplied token (manually). Is there a way in FME workbench to automatically regenerates the ArcGIS token everytime the workbench is run? ThanksAnthea

2015
nielsgerrits
VIP
armando_amador
Contributor
armando_amadorContributor
asked in Authoring
Building Areas bounding endpoint vertex from lines

Hi all,I have a set of input street lines with certain attribute (POSTAL CODES), and I would like to create area polygons from unique values of such postal code attribute. Street Lines with postal code attributeI have utilized AreaBuilder for such purposes and this is an example of the output: Inner polygons created by AreaBuilderThis is the params I have for such transformation:What I would like to have as an output is the area covered by all the street lines with unique postal codes, something more like this: Desirable Polygon from street linesIs there any other param customization I have missed or something else to do about? Regards.

351
liamfez
Influencer
bhk
Contributor
bhkContributor
asked in Authoring
How to Call a SystemCaller based on Selected User Parameters

I have a script that is supposed to run some .bat files base on calling defined SystemCallers. I have 3 System caller as each for DEV, HUB, and PROD environments. and I want to control which to run with User Parameters as belowCan you please let me know how I can control which SystemCaller to run based on user selection (For example: if user select the DEV then only the SystemCaller-DEV)

941
nielsgerrits
VIP
lifalin2016
Supporter
lifalin2016Supporter
asked in Authoring
Hacking schema features for dynamic output ?

Hi list.I'm tasked with importing a lot of feature sets, each with its own set of fields/attributes. So I'm using dynamic output mode, utilizing the schema features read.Unfortunately the request is to add a "job ID", so I tried to append an entry to the attribute list of the schema features, but suddenly the proces fails, not recognizing the schema features anymore. And this without changing anything in the data features flow nor the writer.An example of the error message is:Microsoft SQL Server Spatial Writer: A feature has arrived with 'fme_feature_type' of DAF_DAGI.afstemningsomraade_908308, but the feature type is not recognized. Halting translationMy writer setup is shown in the attached image. Why does the writer suddenly confuse the fme_feature_type with the requested table name ?Or is the error message false/misleading ?The "fme_feature_type" of the data features are the exact same, I just manipulated the schema features in a parallel "stream".Any insights are appreciated.Chee

447
wakamput
Participant
jeroenpeters
Contributor
jeroenpetersContributor
asked in Authoring
FME 2024.0 Prompt button

A small follow-up question, the prompt button on the toolbar has vanished for me since FME 2024.0. It also disappeared from the Toolbar options. Same goes for the Stop at breakpoint button.Any ideas how to get it back?

1878
jeroenpeters
Contributor
billybob
Contributor
billybobContributor
asked in Authoring
Does FME Server recognize spaces in file paths in a published workbench?

I'm using a path in an Esri geodatabase writer that contains a space in the path name - \\\\xxxxx\\gis\\SheriffsOffice\\Camera Information\\SO_Camera_Info.gdb. The workbench completes successfully (2019.1). When the workbench is published to FME Server and run, the path is truncated at the space form '\\\\xxxxx\\gis\\SheriffsOffice\\Camera.gdb' Is there a way to fix this?

1378
luke.hicks
Safer
sbertrand
Participant
sbertrandParticipant
asked in Authoring
Automatic File Names

Hello,I am new to FME but have some overall experience with coding and I know there has to be a simple way to solve the issue of automatically creating the file name based on an attribute. I am trying to create an excel file with multiple sheets and I have tried using the fan out parameter (along with anything else I can find online) but its been making multiple files or crashing, instead of just one file with multiple sheets. I have been researching this issue for far too long with absolutely no head way so any help will be greatly appreciated. I will also need to create a kmz/kml file with the same naming parameters if that changes anything.Thank you in advance,Sam

1275
liamfez
Influencer
lorinda
Contributor
lorindaContributor
asked in Authoring
Unable to read schema from ArcGIS Online Feature Service

Hi All,Am attempting to read a feature service (actually several) that are open to the public on ArcGIS Online (AGOL).  I have created a new web connection using an existing user in AGOL for our organization (getting a token, client id, etc).The data that I am attempting to read is the ACS Census data (several different feature services).  When entering the copied URL from the AGOL website, and then attempting to select a layer from the feature service, I get the following errors.  I see that that it is looking in the content of my user, but this data is open to all.  This used to work for me before the changes in the web connections.  Where do I look from here?  I have tried this in FME 2022 and Flow 2024.Thanks,LorindaCreating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Using Python interpreter from `C:\Program Files\FME Flow\fmepython312\python312.dll' with PYTHONHOME `C:\Program Files\FME Flow\fme

2663
evilscientist
Participant
chosbacon
Contributor
chosbaconContributor
asked in Authoring
How to use values ​​in the Search Envelope through a Choice?

​Hello, Would anyone know if there is a way to use the Search Envelope by updating from a choice parameter? For example, I have these certain polygons that delimit the area I want to analyze:Every time I want to analyze an area I have to change the values ​​of the X,Y parameter (min and max):  To solve the problem, I created a choice that shows the area number on the Display but the values ​​read are the bound coordinates. And I created hidden parameters called Xmin, Xmax, Ymin, Ymax, These parameters look at this choice in the following way: @GetWord($(Choice),0)Attributes read from parameters with the expression aboveBut even if the combination is a number, FME does not accept using this value in the search envelope, as it tries to read the entire written parameter. Below is the error log: Invalid search envelope specified: GEOTIFF_1_SEARCH_ENVELOPE keyword must be followed by four numeric values (minX minY maxX maxY). Got '@GetWord(-42 -20 -40.5 -19 454,0) @GetWord(-42 -20 -40.5 -19

946
chosbacon
Contributor
boomer87
Contributor
boomer87Contributor
asked in Authoring
Change Detector Python Caller for GIS FC and API

Curious if I could pick your brains on how to achieve the workflow:I am connecting to an asset via API as well as another separate GIS Feature Class in an EGDB. The workflow will start with a user editing the GIS Feature Class. When a user updates or creates a new record in the GRI_TEST1 Feature Class, I am pulling it into the Change Detector, and wanting to write to the API table only if the assetkey does not exist in the API table. The assetkey in the GIS FC = unitid in the API Table, as the field has a different name than the same column has in the GRI_TEST1 Feature class.Would I be going the right route here in using the PythonCaller to achieve this? Right now my writer is writing to a xlsx document and not the API table yet so I could test out the logic. # Import necessary modulesfrom fmeobjects import *# Function to check if asset key exists in feature classdef assetkey exists(assetkey, feature_class):    # Implement the logic to query the GIS feature class    # Assume 'feature_c

401
evieatsafe
Safer
chelseawu
Contributor
chelseawuContributor
asked in Authoring
how to set reader to start only after precedent procedures completed?

Hello, I am working on a project which will fetch information and save to local machine, then I use xsd-driven-xml reader to read in the files to parse data down streams. I noticed that reader activate before HTTPCaller task and caused the httpcaller failed to create file in the designated location. How to specify the reader to activate only if my HTTPCaller successful? I have already have the tester set up and will be able to tell either failed or success, but xsd-driven-xml reader did not have condition parameter setting or anything for me to make sure it activate after tester passed. I can separate this into two workspace, or create custermized transformer to encapsulate some condition tester and xml reader together, but thought there might be better way and would like to ask for help here. Any information is appreciated. 

343
chelseawu
Contributor
alc33
Contributor
alc33Contributor
asked in Authoring
Problem alignment transformer

Hi !I don’t know where to post that so sorry if it’s the wrong place 😊When I use the button “alignment Middle” the alignment is vertical and when I use the button “alignment center” the alignment is horizontal. The action seems to be the opposite of the picture on the button.Do you have the same thing? On FME 2018 is the reverse and it look more logical.FME version : 2024.0.1.0Thanks !

474
alc33
Contributor
gberdoz
Participant
gberdozParticipant
asked in Authoring
NeighborFinder list of distance

Hi,I’m on the version 2024 of FME Workbench, I have to calculate a number of neighbor between points (let’s say 5) in a distance (of 20 for example).But the issue is that I don’t know how to export the 5 distances in specific attributes…If someone can help me I’d love that !

682
mark2atsafe
Safer
jamesblythe
Contributor
jamesblytheContributor
asked in Authoring
BULK CONVERSION OF GEOTIFF FILES TO JPG2000

Hi.Could I please ask for a little assistance. I have about 1700 GeoTIFF files that I need to convert to 1700 JPG2000 files. So it is a 1:1 conversion for each file.I am familiar with converting GeoTIFF to JPG2000, but how do I do this en masse?FME Workbench 2020.Yours sincerely.James Blythe.

362
jamesblythe
Contributor
bubblebeb
Contributor
bubblebebContributor
asked in Authoring
Extract nested data from JSON to attribute table

Hi. I have the JSON data below and I have managed to expose attributes from this using the JSONFragmenter but am stuck with trying the extract the thirdparty.names from this record. As there are multiple names in this nested array I need to extract them either as a comma separated attribute. i.e. Leicestershire County Council, Mr J Tomms. Or as a list that I can work from. I cant seem to expose this attribute due to it’s nesting. Any help with the correct transformer and configuration would be great. Currently using FME Form 2023.2.2 but can update to 2024 if it is easier.           {            "_index" : "xxx",            "_type" : "_doc",            "_id" : "667951b042fcaa46307d1935",            "_score" : null,            "_source" : {               "coi_num" : 68902,               "engagement" : {                  "mail" : "Bob@home.com",                  "objectguid" : "8dc75819103e4e408684a75f87fd320b",                  "dn" : "CN=Bob Smith,OU=Rural,OU=Worcester,OU=FGUsers,DC=fg

1171
danilo_fme
Evangelist
james_c_452
Enthusiast
james_c_452Enthusiast
asked in Authoring
Convert a surface to an solid / centerline of solid / diameter of solid

Hi,I have some utility pipes that have been modelled by a sub contractor. When I bring them into FME they are surfaces. This doesn’t surprise me, though they area actually shapes. Can anyone thing of a way to build these surfaces into solids? Say I have a cylinder for a pipe. It comes in as a surface but should topologically be a shape. I wish to convert itI also wish to find the centre line of these solids, and their diameters which I haven’t been able to do eitherAny help would be appreciated. I have the 2023 versionThanks

760
james_c_452
Enthusiast
alc33
Contributor
alc33Contributor
asked in Authoring
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 !

80
alc33
Contributor
andrewj74
Supporter
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  

1259
andrewj74
Supporter
kweller
Contributor
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 

281
kweller
Contributor

Badge Winners

Show all badges

Community Stats

31,758
Posts
120,640
Replies
39,382
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.