FME Form

When ‘Remove Output Attribute’ is selected for ‘If Input Attribute is Missing’  The missing attributes (the attributes with no data) are still present in the output.  Any clues? 

I’m currently dynamically reading web feature service layers by using a feature reader and trying to write them up to AGOL. I have no issues dynamically writing to a File GDB, but if I attempt to write to AGOL, I only get a Python KeyError, which isn’t telling me anything. Message Type: fme::internal::_v0::py::ExceptionPython Exception <KeyError>: 'Cadastre_Address_LGATE002'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for detailsThis only occurs when I want to write dynamically to AGOL, if I just write the exposed attributes it functions. Is there any way around this? I’m aiming to use one workspace to read in the features based on parameters, and write it out using parameters, as a way of creating and updating feature services.I should note that it seems to be half creating the feature service itself, but when it comes to write any features to the newly made feature service, the error appears.Thanks

Anyone ever developed a VS Code “language” for FME logs files? Years ago somone -  I wish I could remember who _ did this for NotePad++ and it was awesome.The defaul VS Code log view is actually not bad so this is really a - “would be nice”

Is there a way to specify that the email needs is high priority ?

The scenario is   The ask how can i eliminate to read from row 1. The attributes that I intend to process is No, Name and ID

Hi there, I got a weird error when I attempted to use featurewriter transformer to write feature into SDE dynamically (see the error screenshot below). Could someone please explain what is the error is talking about? Is there any solution?Thanks in advance for your answerAlan

I am trying to use a template file in an excel writer for my data. The data is collected from a number of sites, so I was aiming to use the site id attribute as the sheet name to export a new sheet per site. Unfortunately the template is only being used for the first site which passes through my writer, and the other sheets are unformatted. Has anyone encountered this and found a solution to apply the template to all sheets if multiple are being written in the same feature writer? 

I’m using an FME FeatureReader to read a content of an Excel file containing various values, including decimal numbers, some of them small with more then 5 decimal zeroes.The FME, apparently, handles these small numbers using scientific e notation.After processing the data, I write it into a CSV file using a FeatureWriter. The problem is, that the small numbers are written in their scientific notation form, and not as real decimal numbers. This is causing an issue further down the line.I tried various things to force the FME to write the numbers as decimals:forcing datatype of the affected attributes in the FeatureWriter to Decimal or Real using AttributeManager to change the datatype of the affected attributes to Real, Decimal and even String forcing the datatype of the affected attributes in the FeatureWriter to String changing the datatype of the affected cells in the Excel file to TextNothing helped.I tried to find a String or Math function that would achieve that, but I’m not sure

Hello! I’m trying to figure out the best way to aggregate values by the most common words. I’ve found a few threads and documents but not quite what I was looking for.For example, I have a list of building names and numbers where each entry can have a of variation of a building name and number: “1000 The Coolest Building Ever”“1000 Coolest Building”“Coolest Building”“100 Coolest Building Dr.” I would like the output to be “Coolest Building”, as it has common base words across all features. Is this possible? Bonus point if a variation of “Bldg.” “Bldg” can be included. Any advice/guidance is appreciated! 

Hi FME enthusiast,               I am trying to read a large size of shape file using fme form (formerly desktop) where the file size 2GB. when I select the file in the esri shape file reader and try to add in workspace I am get the error like image attached below.The server have enough space to perform but I am receive error attached. Did anyone have face this issue earlier?. If anyone have any suggestions, all would welcome. Thanks in advance.!Notes: These shape files are exported from Smallworld using FME only.  I am using FME Desktop 2020.1.1.1 32 bit version.   

Hello,unfortunately I do not know how to solve the following problem. I have many points and lines and would like to create a connection to the line layer for the points. The lines should not be drawn directly to the starting lines as in the second case, but an iteration should take place. Here is the process as I would describe it:1. a point is taken and the closest point to the line layer is determined and this line is also created2. the new line is added to the existing line layer3. the next point is taken and the closest point to the line layer is determined. The new line layer may result in a shorter route than the original layer.4. the new line is added back to the original data set, etc.So far I have tried various workflows with a loop, but unfortunately I have not gotten very far. I would be very grateful for any ideas and suggestions.

 How to apply geoid when converting ifc to cesium 3d tilesHello, I am converting ifc to cesium 3d tiles. The photos below are the photos that were converted. If I do not apply geoid, the conversion is done well, but if I apply geoid, the following error occurs. In the Vertical option, Geoid Height Grid, .gdc, .gtx, etc., the same error occurs no matter what file I put in. Is there any solution? The operating system is mac, and the corresponding fme version is 2023.2.  

Likely known by many here, however, I can’t see it documented officially so I’m going to spell it out.If you have created a CustomTranformer or are working with one you need to be very careful how you use/reference parameters.There are many gotchas when working with CustomTransformers but this is the one that trips me up the most. If you define a parameter in a Custom Transform with an attribute value this will not always be treated as a Global Parameter inside the transformer. I.e., depending on what happens in the Transformer the value will not always be accessible.I saw a great comment by ​@ctredinnick in this thread from a couple of years ago: where they mention that Parameter Values defined by an attribute value will be treated in a similar way to unexposed attributes.I had always assumed that Parameter values were somehow ‘locked in’ of defined for every feature when they went in but that’s not true. Anytime the parameter is referenced inside a CustomTransformer it will just reso

I would like to publish the app so that the end user can optionally select a variety of filters including:date ranges static attribute fields (A or T) dynamic input fields (for example if a new business code is added to the source data)I have been able to publish the user parameters in the app but the data does not filter from the results set.  

I built a dynamic workflow to change a attribute for CSV file. It turns out that the attribute name is changed but without value in the output CSV file. Please could you help solve the issue?The input CSV file and workbench has been attached with the post.

Hi All,I'm still somewhat new to FME and am hoping someone can advise me.Through another workbench I have been able to gather a a list of service URLs from an AGOL. I would now like to automate the process of creating a new item in ArcGIS Portal via the New Item > URL workflow.I have looked through the Esri ArcGIS Portal Feature Service Reader/Writer and a few other transformers but none seem to accommodate for creating a referenced item via URL. Google is leading me nowhere either.Any advice or pointers?Thanks very much for your time! 

Greetings all!I searched for similar questions but wasn’t able to find any pertaining to this, so apologies if I missed them. I’m using the NeighborFinder transformer to locate points along measure-aware polylines to acquire the Measure value of all lines within 5 meters and merging all attributes and generating a list when multiple candidates are found. When there are multiple candidates, it’s assigning the Measure value of the point from one of the lines at random (possible the closest?). However, when I use the ListExploder transformer to create features from all elements in the list, while all other attributes appear to be specific per feature, the Measure values are the same for all features spawning from the same feature. Hopefully this make sense. I assume I have a parameter set incorrectly or something, but how do I ensure each feature has the measure value specific to the line it was matched to?

I have a FME workbench that is scheduled to run late in the evening, and it is a lengthy process, so it can sometimes run over midnight.Is there a way I can capture the date of the day that the workbench started to run and to store that date in a parameter?I tried DateTimeStamper but it re-captures the date for every single feature, so if the process runs over midnight, the date changes

Hello All,  We use FME server 2021.2 as an integration platform and it is not configured for HTTPS. Organization internal systems call our FME workbenches via webhook. ArcGIS Portal Feature Service Reader fetches data from ArcGIS portal feature service. It executes successfully most of the time but fails very intermittently causing data discrepancy between different systems. The failure message is: ArcGIS Portal Feature Service Reader: SSL certificate verification failed for host 'xxxx.xxx.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: HTTPSConnectionPool(host='vgggg', port=443): Max retries exceeded with url: /portal/sharing/rest/generateToken (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')])")))2025-03-05 11:15:58|   0.1|  0.0|INFORM|ArcGIS Portal Feature Service Reader: Getting item with ID 'c505638a9b14460f8267d0a7b562ee48'2025-03-05 11:15:58|   0.1|

Hello all,At a client I often fail to connect to their ESRI Portal, due to failing to verify SSL (see loggin below) on both FME Server and desktop.Proxy settings in FME don't change the behaviour (always uses proxy). The Chrome browser thinks the certificate is o.k. I can't disable ssl-verification in the Portal Reader, as suggested in the log, like it is possible to do in the HTTPCaller.. (see my idea for that). Inspired by this reported problem I exported the certificate from Chrome, and imported it in $FME_HOME\jre\lib\security\cacerts on desktop.. (analogue to these instructions for server, section .pfx certificate, as the problematic server has a .pfx certificate).This did not resolve the problem...Does anyone have any suggestions??? Kind regards,MartinArcGIS Portal Feature Service Reader: Using proxy http://proxy.####.intern:8080/ArcGIS Portal Feature Service Reader: Using authentication type 'NTLM'ArcGIS Portal Feature Service Reader: Logging into 'https://geoportaal.####.intern

I know I can restart a map service in ArcGIS Server Manager. Is it possible to restart a map service in ArcGIS Server using FME? if yes, how is this done?

Im trying to work with the Cityworks API to create Work Orders using FME desktop.I used the http caller to create the Work order and populate the necessary fields. However, my next challenge is to upload an attachment to the Work Order that comes from the attachment in the AGOL feature Layer created from Survey123. To do that I have used another HTTP caller set to POST with the URL.../services/Ams/Attachments/AddWorkOrderAttachment? I know I have the Query string correct but I'm doing something wrong in the Multipart Upload section. Also, Do I need to use a token if I'm using a web connection for Authentication?       

I’m exporting LoD 3 models from FME to CityGML and the files blow up in size. FME writes every Appearance on each triangle and also makes a separate position list for each triangle, everything becomes separate XML elements, so the markup absolutely dominates the file. I think CityGML should be able to store things more compactly at the object level, but I don’t see a way to make FME do that automatically. Every triangle whould not need its own position list right? I have thome different thoughts on the matter: Can FME group or merge geometries/appearances to cut down the markup? Can ImplicitGeometry be used effectively without creating a complex monster workspace? Is CityJSON fundamentally a better route? (I’ve heard numbers around ≈ 1/6 of the file size.) Are there external tools that post-optimize a CityGML without losing semantics? Concrete tips, transformer setups, or example workspaces are very welcome.

Hello,I've got a really challenging question received from a customer !The domain is Heritage buildings protection.An architect/historian evaluates the value of buildings and gives them a mark.He then presents his proposal in a PowerPoint :Identification infoDescriptionMarkLabeletc. PicturesThe proposal is reviewed in several sessions, with different people. The mark may be upgraded or downgraded, the label changed, etc. Once validated, the data is to be captured in an SDE geodatabase. Presently, this is done in two different ways :ManuallyManually copying the data to Excel and it is imported in GDB with FMEBut in both cases, there is a non profit-adding step, which is to manually copy the data.Does anyone out there have an idea how to skip this step ?Could the PowerPoint presentation be structured in such a way (with keywords for instance) that could make the content recognizable and importable directly ?I have thought of different ways but I'd rather keep it open for your inp

Hi everyone,I'm working with a shapefile that contains 3D point geometries, each with several attribute fields. I would like to convert this dataset into Cesium 3D Tiles format while preserving both the 3D coordinates and the associated attributes. Has anyone successfully done this using FME? If so, could you share your workflow or recommend which transformers and settings are best suited for this task? Any tips or guidance would be greatly appreciated!