Best Answers

Hi,I have a parameter that I have set in an FME Server/Flow app that is conditional on another parameter. I.e. The first is set by the user in an app. If there is a certain value, then it would require you two set a secondary variable.I used to have this set as a simple ‘dropdown’ choice, which then would require a simple text input (if needed). I tried to change the original parameter to a ‘choice list’ instead, to make it easier to follow, but this is causing me issues.When I preview how this looks in FME Form it works exactly how I want to. Though when I try to on Flow it doesn’t show/require the secondary parameter. Is this a bug? Or something I can fix? I am constrained to version 2023.2.1.0 (23774) for at least the foreseeable futureAny advice would be appreciated, I can’t seem to get it to work no matter what I try

I have an excel file that has a list of addresses, and their associated license number.I want to join this to a geodatabase file to output any parcels that have any of the addresses in the excel file.  I can’t seem to make that work.  Can anybody point me in the right direction?  I’ve tried FeatureJoiner and FeatureMerger and can’t seem to get any output without failure.

I’m using the Data Interoperability extension in ArcGIS Pro.  I can’t seem to get a excel reader to add in.  I’ll set the parameters, it’s not open anywhere else, it’s not password protected or anything like that, and it’s on my local system.   When I click ok to add it, fme acts like it’s trying to add it, but then just sits there and spins until it eventually times out.   What am I doing wrong?  I haven’t used FME in about 7 years or so, but I used it extensively prior to that and never had this sort of issue.

 Hello Forum, I’ve set up a simple workspace to convert a csv with eastings and northings (EPSG:27700) to a csv with long lat (EPSG:4326). This is working OK. The workspace is something I’m going to use quite often, so I’m keen to automate it as much as possible. Is it possible to automatically make the ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) the same as the input csv name. For example, if my input csv is called ‘Properties030225.csv’, then when this reaches the FeatureWriter the default ‘CSV File Name’ value in in the FeatureWriter (Parameters tab) is ‘Reprojected’. Instead, I would want that default csv file name to be the name of the input .csv. In this case, Properties030225.csv. Yes, of course, I could type in Properties030225.csv in, but I don’t want to do that every time. Instead, I want it to automatically pick up on the input file name. How can I do this? Thanks,Stuart 

Hi,I am having trouble reading the names of the groups with which the layer is shared in Esri Enterprise. I am using an HTTPCaller with the following settings, but the Share info does not appear in the JSON response.The only information I get is:   "access": "shared". Could you please advise on how to retrieve this information?

Hi there,I recently installed ArcPro 3.2 on my machine with the data interoperability extension. Looking under the hood, the data interoperability extension uses this FME version, FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64). When I use the WorkspaceRunner transformer to run a simple workspace (read a text file and view in inspector), the transformer fails to read the published parameter, is says "Specified workspace has no parameters or could not be read". If you run the workspace using the workspacerunner, it gives you an error, "2023-08-03 14:20:14|  2.3| 0.0|ERROR |WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner_df4bad67_c886_4b16_8145_a18050c02ff01_runner {} {F:\\ETL\\TEST\\Workbench\\TESTING/workspace1.fmw}' -- unexpected token "END" at position 0; expecting VALUE". Is this an

I am using a WorkspaceRunner so that I can run multiple times the same FME workbench on different DNG separately. Just to be clear I will call the WorkspaceRunner to the workbench that runs the “child” workbench, and i will just call Workbench to the child workbench. I was all working fine the first times and now I find that some User Parameter (in my case “DNG”) I was “sending” from the WorkspaceRunner to the Workbench is not working anymore (I didn’t change the parameter in the WorkspaceRunner but maybe i used it in more places inside my Workbench). When I run it directly inside my Workbench it makes no problem. But when I run it from the workspacerunner the following error appears:  ERROR : Undefined macro `DGN' dereferenced in file `G:\Buzon\Miguel\CQ_topologia_copia\wb-xlate-1738321227449_8672'I think the wb-xlate is a temporary file of some sort. I have a wb-xlate in the root of the project but not the name does not match the one appearing here. That wb-xlate actually contains th

HiQuick question before I fall back on trial and error, because my dataset is quite big, but does anyone know if changing the partitioning attribute order on a partitioned parquet writer determines the partition folder hierarchy?  The doc says its the schema order which determines the partition hierarchy, I’m hoping to override the reader’s attribute order.  I’m hoping manually editing the writer attribute order will determine partition hierarchy.  Thanks.

Hello FME Community users, I am trying to upgrade FME FLow from 2024.0.3 to 2024.2.1. I looked into this article https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Upgrade-in-Place-Same-Machine.htmJust wondering if there is a better compared to install/uninstall as mentioned above. Such as done on ESRI side.

Quick and easy question I hope: does FME 2024.2 support the new ArcGIS Online data types (Date Only, Time Only, Timestap Offset and Big Integer) as described here: https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/time-is-on-your-side-with-new-field-types-in-arcgis-online/

Hi All, I am trying to gather information on upgradeable transformers and see that current version is available as part of fmw file extension. I want to know where does it get the information on latest version, Is this information saved somewhere. In this example, AttributeManager is currently at ver 2 but latest version is ver 4. I am not sure where this version information stored. Thanks   

I am using FME Form 2021. I have been running two workspaces for about a year now. These upload spreadsheets to an SFTP site. Every once in a while, I get this error message: The FTPCaller Error Message from the Rejected Port:Error in the SSH layer This error prevents the spreadsheets from being uploaded to the SFTP site. Usually, the error seems to go away after a few days with nothing done on my end, and then the workspaces run normally. There does not seem to be a pattern of when the error is received. I checked the Log Files, and they show nothing unusual. I checked with our IT Network Admins, and they say nothing is blocking files from being uploaded to the SFTP Site.  Here is a screenshot of the parameters in the FTPCaller Transformer I use:  Questions:What is the cause of this error?Could the error be on the side of the folks who manage the SFTP site? (outside my organization)Is it a bug in FME Form 2021?Is this error received when using FTPCaller Transformer in FME Form 2024?Ho

Hi, our ArcMap license will expired tomrrow and will not renew after it expired. Also, I have Arcgis pro installed on my machine and the license is valid (will not expire).Currently all of my script setting is set AUTO under the “Esri ArcGIS Compatibility” . Will the AUTO setting  pick to ArcGIS Pro license, after ArcMap license is expired? or do i have to manually set to ArcGIS Pro in each FMW script individually?“FME Workspace, go to Navigator --> Workspace Parameter --> Translation --> Esri ArcGIS Compatibility   --> AUTO”thanks,Wilson

Ultimate Goal: to use FME to test if there are ESRI annotations that fall on top of each other.  Issue being experienced: When the ESRI annotation is displayed in FME Inspector, the annotation has been shifted.  My theory is the “shift” is something to do with the annotation is left justified in ArcGIS Pro and its placement of the annotation is based on a point in the bottom left corner.  In FME the annotation point seems to be placed along the bottom centre.  Question: Is there a way to have FME place the ESRI Annotation based on the same placement point?ORHow can we shift the annotation when being viewed in FME so that it is placed half of the width of the annotations to the left along the annotation axes?   ArcGIS Pro: 3.2.3ArcGIS SDE: SQL 2022FME Form: FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64)FME Annotation Reader Format: Esri Geodatabase (ArcSDE Geodb) See attached imagery for example of annotation shift.  

I’m converting 135 Revit models to GIS but the coordinate system is not setting (location is Philidelphia but data is appearing in Ohio).  I’ve tried setting the coordinate system (NAD 83, Pennsylvania state plane south, US foot) in the writer and using CoordinateSystemSetter.  Individual models appear properly in ArcGIS Pro.  I’m really baffled by this one; probably something simple I’m missing.

Version: 2024.0.1.0 I am trying to write a new dataset to ArcGIS online, keeps getting this error code: Message Type: fme::internal::_v0::py::ExceptionPython Exception <AttributeError>: 'NoneType' object has no attribute 'get'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for details 

I have a closed polygon dataset that I need to add angle labels to the internal angle.I just wanted to see if anyone has done a similar thing or has some advice on the best way.I am using the “VertexAngleCalculator” transformer which gives me the results for the actual angles but need to figure out the before and after lines to the calculate the position and angle of the label so it is just offset from the vertex and angled midway between the before and after lines towards the interior of the polygon. 

We are trying to update our on-prem FLOW (from version 2023.2) and I have successfully created the backup but am unable to determine the location of where the file was saved to.  The FLOW interface does not provide any clues as it does not indicate the target directoy (please see attached screen grab).  And doing a seach on my C and D drives with keyword ‘.fsconfig’ yelds no results. Where does the backup file get saved to?  Thanks!

I need to generate a list between two numbers and repeat a value the number of times between the two numbers. The values need to generate the number of rows between the higher ranked value and the lower ranked value. Below is the data I have now, and the second screenshot is what I need generated. Thank you for the help.What I have now:What I need: 

An automation reads a message from a JMS queue and should trigger a workspace, the message content is passed as an automation parameter. This message is valid json, however we’ve had some cases where the message is something along the lines of{ "ID": "1234", "Notes": "Careless typing} includes a right hand curly brace"}This is valid json but the job fails with a status of FME_FAILURE and a statusMessage of  "extra characters after close-brace". How should the message be passed to the workspace if json like the above example leads to failure to submit? 

Does anyone have (or know where I can find) the workspace and sample data for the Travelling Salesman blog post from 2016 (or later)?https://fme.safe.com/blog/2016/11/fmeevangelist158/ ThanksDavid

Hello, I’m struggling with the logic/approach on this one. I have a spreadsheet of fuel filters. So in the spreadsheet, it looks kind of like this: Unit#/Fuel 1/Fuel2/Air 1/Air212/abc123/abc223/airf123/airf12413/abc123/abc212/airf123/airf124 I want to create output data that looks something like this: Unit/Filter Class/Filter Number12/Fuel Filter/abc12312/Fuel Filter/abc22312/Air Filter/airf12313/Fuel Filter/abc12313/Fuel Filter/abc212 Hopefully this makes sense.Any thoughts on an approach, or some transformers I should work with? Cheers!​​​​​

This question came up at my office today.   Can I have two FME Flow engines at different versions installed on the same Windows Server?  I’m guessing that the answer is no but I wanted to get official verification on that.

Hi,I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN.  I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?

I am struggling to save text as a hyperlink in Excel. I tried using this formula:=HYPERLINK("http://www.1spatial.com/fme","http://www.1spatial.com/fme")However, the outcome in Excel didn’t work as expected.  Does anyone have any idea why it behaves this way?