Authoring

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)

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

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?

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?

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

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

​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

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

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. 

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 !

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 !

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.

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

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

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 !

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  

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 

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. 

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. 

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

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

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? 

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

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.

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