Best Answers

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

I have a text field (attribute) in a table that is 2048 characters in length. I want to change it to 50. What Transformer do I use in FME to achieve this? I am using FME Form 2021. 

We use the SDK in C++. When migrating our code to FME 2024, I realized that several files related to pointcloud cannot be found in the new SDK any more.The only file I can find for pointclouds is pointcloud_fwd.h. But when using an IFMEPointCloud pointer, the declaration cannot be found. The files that I used in earlier versions of FME do not exist any more (ipointcloud.h, ipointcloudblock.h, ...)Where can I find these declarations now? Is there an example for C++, how the point data of a pointcloud feature can be extracted with the SDK of FME 2024? 

I have got an excel sheet and there are some cells with just colour and i don’t wish to include them for analysis purpose / output . Without any edits in Excel sheet (eg. add some kind of numeric or standard text for colour cell etc.) i wish to remove or exclude. I also don’t wish to depend on any other column or cell value to filter rows with ORANGE colour cell  I WANT to remove / exclude entire ROW that has yellow colour in cell in Column NCR Ref   

I have spatial (ESRI FGDB data) that I want to make into a non-spatial table.  Regardless of what I try (e.g. deleting the ‘Shape’ field) the data is still spatial.