FME Form

Hi Community, I have created an FME workflow to complete a RAG analysis (Red, Amber, Green) and need help to automate the very last step of the workbench which uses a ExpressionEvaluator transformer. For now I have included 14 different ExpressionEvaluator transformer to calculate the average value of the 14 RAG guidelines, here is an screenshot of the 14 transformers: ...but what I want to improve is the way of each of these 14 guidelines are being calculated as the ExpressionEvaluator transofrmer uses an expression that manually needs to be updated each time a new dataset is added into the analysis, here is an example of the expression:  If an additional dataset needs to be included then I manual

Currently I have few AttributeCreator to do the following: Insert numbers into table if no matches found (Attribute Value=INSERT) Replace number into table if matches found (Attribute Value=UPSERT)However there's a need to add numbers to existing values. Do not see any APPEND or ADD attribute value from the dropdown.  Any help would be appreciated!

I don't want to use the drop&create option on the table, this is too dangerous. My goal is to read the collection, rewrite some rows using JSON transformers and update them thanks to their mongodbId.

I am trying to publish a new Web Connection to FME Hub that uses OAuth 2.0 Authorization Code Flow. My test workspace fails when FME Hub tries to run the test workspace. I suspect it is because the Authorization Code flow requires user interaction. Is there any way to successfully test this workspace that calls the Web Connection I am trying to test?

In the same manner as I can get the name of the workspace via the $(WORKSPACE_NAME) Trying to make it easier to bugfix scripts if they fail or get terminated by a terminator transformer. The message is then sent to a teams-channel.

To get the number of features from a FeatureClass in a File Geodatabase you can use arcpy's GetCount.arcpy.management.GetCount(<featureclasspath>)So I tried and got this working.import fmeimport fmeobjectsimport arcpy class FeatureProcessor(object):     def __init__(self):        pass     def input(self, feature):        arcpy.env.workspace = feature.getAttribute('path_windows')         feature_classes = arcpy.ListFeatureClasses()                fc_list = []         for fc in feature_classes:            count = arcpy.GetCount_management(fc)            fc_list.append((fc, int(count[0])))            print(fc_list)         self.pyoutput(feature)    def close(self):        pass     def process_group(self):        passBut no matter what I tried, I could not get the li

I read files from Sharepoint. Sometimes I can read all the files but other times (no obvious pattern) I get this error msg when reading the exact same files again:`fme_rejection_message' has value `SharepointOnlineConnector: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='graph.microsoft.com', port=443): Read timed out. (read timeout=60)''Can I somehow easily adjust the read timeout?

I have a File geodatabase with field aliases that are in the correct case that I wish to preserve, however, I need the field names to be in uppercase.  I have tried to do this using the AttributeExposer, followed by a Tester:with the values that end with _alias being passed directly to the writer while the values that fail i pass to a BulkAttributeRenamer to convert them to uppercase before passing them to the writer.  - but i don't think the aliases are being passed to the writer properly because everything ends up in uppercase. How can i correct this, preferably while still using the Tester transformer?

Hello, I have the following problem. I have a file with a lot of rings, which all have a unique ID. On the other side I have a lot of raster files which also have this ID as file name. Now I want to crop each one of the raster files to the corresponding outline with the same ID. These cropped individual raster files are then to be saved individually. How can I tell the Clipper Transformer to "blend" the ID of the ring with the ID of the raster file ? Maybe someone can give me a hint. Many thanks and best regardsMaisels

how to do it such that upon getting the value of ward_no it should run the model for the data pertaining to the ward and how to pass the parameter value (in this case ward_no) to fme workbench reader to make the process dynamic.

Newb here, I'm using FME a lot for simple GIS feature class extraction, from source DB to a target DB, pretty straight forward. After many of these I'm thinking there must be a simpler way to map the source and targets.Per image below, reader layers on the left and writer layers on the right, then I manually connect them. The writers are identical, no changes or alterations required, surely there is a way around the manual connecting of source/target.

Hello,I'm relatively new to using FME and have been tasked with synchronizing a local folder and it's subfolders with Sharepoint. I have installed and configured the FME SharepointOnlineConnector and it is successfully synchronizing the contents of the folder and it's subfolders to Sharepoint in its default configuration. The only issue I'm having is there are some .xml files that are present in these folders that I do not want to synchronize. Does the connector provide any means of white or blacklisting specific file types from being uploaded? If not, does anyone have any suggestions on how this would be best accomplished? The section titled "Clean up your SharePoint Documents" in the following link would allow me to delete the unneeded files after the load, however this is not ideal as it would mean the files are unnecessarily created and deleted on every load.

when Reading feature class Unable to read from the table/feature class 'schemaName.table'. If 'schemaName.table' contains a class extension, make sure it is registered on this computer. The sde backend is Oracle and SDE 10.8.1

In FME flow if I had a process which downloaded physical files to resources folder but as part of the data workflow, these files will need be deleted once files are utilised, what is the best way to go?

Hi, I have a table with 10 points. I convert these points into a squares of 100 by 100 meters. Then I cut another table on these squares with the clipper. Next I want to make a PDF file of each square separately with a map of the 100 by 100 area. So it should be 10 separate pdf files. How can you best handle that? Currently the squares are put in 1 pdf instead of 1 pdf per squares. I've tried looping the PDFPageformatter, but it's not allowed. 

Hi, I have las files to process and update the SDE as contours. One of the attributes which I need to include is a creation date. Unfortunately, when I try to use Attribute Manager to create the new column 'DATE' the value based on 'las_file_creation_date' is added as a new row and doesn't update the whole column as the attached print screen. Does anyone come across similar problem? Thanks

Table 1 Table 2

I am snapping points to line based on unique id (using group by). I tried using both vertex snapping or segment snapping. In both of these case, the points are being snapped to endpoints in some cases ( as per screenshot). I don't want to snap the point to endpoint at all, but it can be anywhere on the line. How to achieve snapping the point on the line other than endpoint of the line? Thank you

I would like to try the Visvalingam-Wyatt algoritm in one of my projects since the results look promising and it can be run on polygons.  Thing is that I have never used PythonCaller, or coded in python. Before I dive in I have a few questions: Has anyone got this simplification algoritm up and running in FME using one of the code samples of github? Was there a way to retain the borders between areas? That would be a must have for me.  

I'm trying to solve how I can get the properties for a Excel worksheet. I have over 5000 Excel files trying to parse. These files fall into 6 different formats for data extraction. However all the files are created from an Excel template which starts with all the worksheets for all the different formats. Depending on the user's initial selection using a VBA marco in Excel certain worksheets will be visible or not.  I'd really like to test if certain worksheets are visible and then take actions accordingly in FME.  Also important is all these files are formatted as XLS (older Excel) and not XLSX .

The file with the error is not the one listed here, and I don't know where the translation is getting the parameter that has the error.

Hi, I would like to merge the two lines below into a single line, since they have the same ID field number, and the other information is the same, except VARIED, which can be any value, either BBC2 or BBC4. How can I do that? Thank´s 

Hi, Attached I have two sets of data with several polygons. The two are almost identical, but one has different polygons or more polygons than the other. How can I do it using FME? I already used the Spatial Relator transformer and change detector transformer but the results were not good. I want to know the difference between the two, that is what appeared in one and what disappeared in the other. can anybody help me? Thanks