Best Answers

Hi All,I am new to the FME Software and have a small question related to NeighborFinder.We have points and contour tables in Arcsde Geodatabase. We are finding points near contour by providing specific distance say 20 in neighborfinder In actual case distance is varies  like in some cases nearest contour is at 30 , some contours at 40 etc. How do I tell to neighborfinder that select a point which is near by contour having distance in between 10 to 40 ?. In SQL if we use between operator then we are getting values so similar I want to use this for neighborfinder Below is the screenshot :    What I tried so far : Creating Custom parameter  On Web found below useful posthttps://www.baooytra.com/knowledge/questions/52143/using-neighbor-finder-with-condition-neighbors-att.html?smartspace=automations-fme-serverAny inputs/suggestion on above would be great !!thanks in advance !! 

I am using customer transformers in a work space, but they are converting a string value to integerThe values are 002 and 003, they need to stay this way for the http calls inside the custom transformer but are getting converted to 2 and 3 (without the 00)As read from dbAfter entry into the custom transformer​​​​Any thought on how to prevent this?I would like to have to avoid having do something in each custom transformer to revert the values back to the strings 

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

Hi All,First, I am an ArcGIS Pro/Enterprise user with the “Data Interoperability Extension” for both Pro and Enterprise.  I do not believe that I have access to FME Flow (Server).My installs on the server are ArcGIS Portal/Server and Data Interoperability at v11.3 - which installs FME…Edition: Data Interoperability, Fixed OEM LicenseVersion: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)I want to automate a Spatial ETL tool that reads GeoJSON from a URL and ends up writing the results to an ArcGIS Online Feature Service.  I thought, why not just do it on the server and skip the exporting/importing the Web Connection from my laptop to the server? (from reading Schedule Spatial ETL tools on a server—ArcGIS Data Interoperability | Documentation for ArcGIS Enterprise)  When I created the workspace on the server with FME Workbench, everything seemed fine.  I could insert an Esri ArcGIS Online (AGOL) Feature Service writer and connect to the feature service that I wanted to write to.But

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.

Hi,I am trying to add a timestamp to a file, which is being written using feature writer. The workbench is on a shared data directory with a Flow Environment.I have seen other options of using fanout option but seems like they are limited to writers only.I just need a simple timestamp on my text-file when its written so that I can keep records of what is being written.I also have made a timestamp attribute using DateTimeStamper and DateTimeConvertor but don't know how to add that to the file name.Any pointers will be appreciated.Thank you

Hey everyone, On FME Server (2021.2.6) I have resources that I want to make available on an HTML page. I want users to be able click on the link and immediately download the data that's in the resource folder: https://fmeserver.EXAMPLE.com/fmeserver/#/resources/browse/FME_SHAREDRESOURCE_DATA/EXAMPLE?name=Data Seems like a pretty standard deal.

How to assign RED colour to this cell in final output of EXCEL file. Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file,     this is default OUTPUT  This is how I WANT 

Hello,I am trying to write several files in NetCDF format with FeatureWritter; but after writing the first one it gives me this error: NetCDF writer: Failed to define variable. The error was 'NetCDF: String match to name in use' If anyone has experienced this and can help me First of all, Thanks

Hello,I’m trying to connect hundrets of feature types to different transformers (see screenshot). Connecting them via “Feature Type Connections” window only works if you have a clear mapping/names for your input ports. Connecting them by hand is way to slow and error-prone.I’m sure there must be a better way. Many thanks in advance.

Hi,Just a quick question about this scenario:we are going to send an Email from an Automation in the case that a translation fails. To populate the body of this Email we can use several parameters (workspace name, automation name, repository name, job id, start and end time of the job, etc.). Now we would also like to add the URL of the FME Flow server to the Email body.Why? Two reasons:We have got 4 different FME Flow environments - D, T, A & Production - and we want the server who sends the email to identify itself It would be cool to add a hyperlink to the job log to the Email body and with the URL and the Job ID we would be able to compile such a linkSo, the question is: would this be possible? Where and how could we retrieve this URL? It is not a parameter in the list provided, as far as I know.Any ideas would be greatly appreciated.TIA,Egge-Jan

Hi,I have a table (that started life as a JSON table, lists exposed etc) containing multiple attribute fields and rows. One of the fields contains CLOB data, like this:<cmAstLocSpId>148606829</cmAstLocSpId><criticalityDetails><criticalityReasons><criticalityReasonsList><criticalityReason>CMEH</criticalityReason></criticalityReasonsList></criticalityReasons></criticalityDetails><cmOsgridref>NZ30272359</cmOsgridref><cmOsnorthing>523598</cmOsnorthing><cmOseasting>430279</cmOseasting><cmRegion>TEESSIDE</cmRegion><cmRepairRegion>TEESSIDE</cmRepairRegion><cmDnoArea>NP (NE)</cmDnoArea><cmCreatedByUser>DAVID</cmCreatedByUser><cmCreationDate>2023-11-23</cmCreationDate> I want to turn the normal text into column / field headings, and those highlighted in bold into values in the relevant column. eg the first column will be “cmAstLocSpld” and t

hello experts,I am trying something that to some of you may be quite simple so I hope one of you is able to help me out.All i am trying to do is to append/add the value cnt from the inlinequerier to the existing excel file.I am trying to write the cnt value into the count_of_errors value where the incoming feeder name is the same as the destination one (in excel file).thank you,fb

See 12 day old post. I appreciate the gamification of the user base but it is not a game when I have a critical, work FMW that that isn’t working.  There has got to be something better than this support.  Am I not entitled to some level of solution based, tech support for the software fees paid?

Hi,How can I stop the translation if one Tester in my workspace pass 0 features in the ‘Passed’ port? Thank´s

I have FME v2024 with a Floating License. I have Windows 10 Enterprise installed. I am almost out of space on my disk where my "Temp" folder is located.The persistent problem I have with FME is that every time I try to open an XML file, although I do have the reader for it, I consistently get the same 6 errors. I have tried opening other files and there is no problem with those, only with XML files.[1]: HTTP transfer error: Timeout was reached[2]: Please ensure that your network connection is properly set up[3]: No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered.[4]:Failed to obtain any schemas from reader 'CITYGML' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information[5]:Workspace generation failed. Parameter file was C:\Users\User1\AppData\Local\Temp\FME_1717067304960_7084.Login

I need to create unique Ids for a point feature class. Also, when a new point is added to the class I need to the unique Id created automatically when the workspace is run. I have created a workspace that includes the File Geodatabase Point Feature Class Reader then the Counter Transformer to create a new field named _count and a new field in AttributeManager named Facility_ID.  All the unique Ids will be formatted as follows: BLDG-000000001, BLDG-000000002, etc…When a new Building Point is added to the Feature Class, the Facility_ID field will automatically be populated with a unique ID in sequence increments of 1; example if the highest unique id in the feature class is BLDG-000000109, then when a new building is added it’s unique id will be BLDG-000000110. What else do I need to do? any assistance is much appreciated.   

We have FME Flow (Windows 2024.0.1) installed in an EC2 instance in a VPC. The DynamoDB reader uses the public endpoint: dynamodb.<region>.amazonaws.com.Can this be modified to use a VPC endpoint?For example: vpce-0a06cf963f9d04a28-3wilx6xm.dynamodb.us-west-2.vpce.amazonaws.com We need to do this for all AWS endpoints, S3 and SQS.Thank you,Kathy

Anybody tell me what I'm getting wrong here? Document Link path is valid. No errors in the FME log but attachment not found in the http response? 

Hello,I have the JSON string format like this “[[{"name":"Column1","value":"Value1"},{"name":"Column2","value":"Value2"},{"name":"Column3","value":"Value3"}], [{"name":"Column1","value":"ValueA"},{"name":"Column2","value":"ValueB"},{"name":"Column3","value":"ValueC"}]]”And I would like to convert it to table like:------------------------------------------------Column1 | Column2 | Column3Value1    | Value2     | Value3ValueA    | ValueB    | ValueC Is there any transformer can help me to do so?

I’m running FME Form 2023 and creating a new script with a reader wich fails when looking up tables. Message given: Failed to retrieve feature typesCould not open the enterprise geodatabase because the local version of arcgis is not compatible with the server's SDE version.On the laptop I have both Arcmap 10.7 and ArcGIS PRO 3.1 (AGP) installed. When creating the reader I use a connection file created in AGP. I also have FME 2018 but this is 2023. The reader is defined as “Esri Geodatabase (ArcSDE Geodb) / Embed Connection Parameters” as the geometry format in the database is ST_GEOMETRY. To me it looks like files from ArcGIS 10.7 is found and used which doesn’t work. Is there any way to force FME 2023 to use “library files” from AGP 3.1 or is there another way to solve the problem?

I am joining a data table with polygons, via a FeatureJoiner using a common value between the two datasets, both data sources come from a sql database. I am outputting a spatial table (the polygons, joined with the data) to another database.I am encountering a strange issue when I try to open this data with ArcGIS Pro, I have never come across this before - The ESRI_OID does not exist. I was not aware this was required previously either.This is causing various issues with viewing the data and publishing it, or joining it within ArcPro. I am getting this error on the esri GIS server when I try to view the polygons/or view the table. here is what the output data rows look like:It is a very simple dataset with geometry. I’ve never had to make esri_oids before in any of my workbenches, does anyone have any insight to what might be going wrong?  

I’m trying to dynamically add a suffix to all attributes in two Excel files. The suffix will come from the last 10 characters of each Excel file (fme_basename), which is the date the file was produced. I have not been able get this to work using the BulkAttributeRenamer. When choosing the Action “Add String Suffix”, only constants appear to work. I’ve tried using the Text Editor to dynamically create the suffix in the String dialog. I’ve also tried creating the suffix beforehand with an AttribuiteCreator and choosing it for String. Neither work. I’m using FME Form 2023.2.0.0 (Build 23764). Any insight or advice?

Hi, I have a JSON return form a HTTPCaller with schema info. An example of the return looks like this:{  "name": "Administration",  "properties" : {    "Id" : {      "type" : "number",      "required" : true,      "description" : "The given Id for the object"    },    "GeoType" : {      "type" : "string",      "required" : true,      "description" : "The type of object"    },The json continues here with more schema info.I want to turn the information into a table like this:  I have 82 other JSON returns with the same layout but other “name” values and exposing them all takes to much time. I have tried to use JSON transfromers but so far no succes.Is there a more dynamic solution to transforming the return to my desired solution?Thanks in advance,Sander

Is it possible to construct an FME Flow/Server (I currently have Server 2022.2) process that can monitor an Esri Enterprise (10.8.1) hosted layer?  We are trying to build something that notifies particular people when changes are made. ThanksCarl