General

Hello Forum, I’ve read in a points dataset (properties) and a estates dataset (polygons). I need to do two things: 1)add an area calculation in a new field to the estates polys. This has been achieved with an AreaCalculator. 2) add a count of the amount of properties (points) falling within each estate polygon using an PointOnAreaOverlayer.  See workspace image attached. I’m finding that the output is counting some estates (polys) two or three times. However when looking at the source data these features are there only once, which is correct. See Inspectors image attached. I’ve played around with GroupProcessing and some other settings, but couldn’t get it right. Can you advise, please. Thanks,Stuart 

How can I efficiently integrate the results from a previous transformer into a tester, especially when the results may vary with each analysis, without the need for manual updates every time?

We are seeing an intermittent issues with connecting to database from FME workbenches ( That runs on FME server ) though the database is healthy FME Server 2021.2.6Build 21821 - win64 The error message is "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[HY109:[Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor position No extended error.]}" Any ideas on how to investigate this further ?? Thanks

SystemCaller command 'query user' works perfectly well on Windows CMD command prompt but throw an error on workbench:SystemCaller: Failed to Execute `query user'There is something wrong with my syntax or this is just a bug?I am running FME 2022.1 by the way.

I’ve got an interesting problem with a land (polygon) and matching coastline (polyline) data. For cartographic styling reasons (using offsets), it’s important that the coastline is always traversing with the land on a consistent side (say, on the right). Where it’s not, I’d like to reverse the polyline coordinates. Fortunately, the polylines are simple with only one segment, i.e. not multipolyline. Logically, I could buffer each section of coastline on one side (or offset the polyline) and detect a material overlap with the land. If no overlap, reverse the polyline. Has anyone done anything like this before or have any suggestions on the best way to implement it in Form? Many thanks. /Warren

Hello ,i Would like to create a connection between FME and Microsoft azure storage .i am looking for a method without using account name and key .I would like to use only token Generation rest api and avoid using account name and key .but I did not find a good documentation to create the connection .could someone explain the method ,if it is possible ?FME 2021

I wonder if it is possible to fill in the properties of an image when uploading this with the SharePointOnlineConnector.I tried setting up an AttributeCreator setting "Inspection Title" etc. but it didn't do anything with the created attributes.

I'm using FME Desktop (2022.1.3.0) to run an AreaonAreaOverlayer on two very large Geopackage files. It's been running for 4 days and currently on "Preparing spatial indices for intersection phase# 2... 11.91% done". My PC has 128Gb of RAM and 40% of that is free, yet FME is only using 7Gb and thrashing my pagefile.sys. Does anyone know how I can force FME to use more physical RAM please? ThanksRob 

I am unable to connect to my organizations enterprise portal.  I have a web service connection that works for other members of my organization, but whenever I attempt to connect I get the error: "Type: 4, Number: 1, Message: Failed to get authorization query string." I have tried everything that I, my boss, and my IT department can think of, but still no luck.  Any advice would be appreciated, Cheers.

I have multiple SQL stored procedures that provide both subtotal and summary information. Goal is have all the stored procedure result sets writing to the same Excel worksheet in specified locations. The nearest I've gotten is correct locations but SEPARATE worksheets of the same Excel spreadsheet. Close, but that means I have the same problem I started with, having to copy/paste data to get the correctly formatted results. Is this possible? 

Hello , i am using two feature reader one for oracle non-spatial and other feature reader for an Arcsde geodatabase I would like to write the output in geodatabase including Feature dataset ,to use it later as input for ArcGis pro .how could I achieve it ?Fme 2021 thanks in advance

If a column contains the string "Insert," I want to change all the values in that column to "Insert." If the column does not contain "Insert," we want to leave the values in that column unchanged. Is there a method or approach available that would allow me to accomplish this objective?

Hello, I have a rather simple request for which I am not finding a solution. I have a Geopackage (multi-polygon geometry with table) already populated with data, let's call it "version 1". This Geopackage is copied and a manual update of some values contained in only 3 columns (out of the total 20) is performed, at attribute level only, let's call it "version 2". My request with FME is to copy the table values that have only been updated in the 3 columns from the 'version 2' geopackage to the original 'version 1' geopackage.  Thanks to "ChangeDetector" we were able to compare and isolate these cases, but we cannot "write the update" in the "version 1" geopackage. But, an additional condition to be introduced would be that to "write" the value to the "version 1" table, the field there before the change must be "null&q

I am new to FMe, and I am struggling with the Test filter. Here is what I'm trying to achieve:If 'No_Feature' has both 'Insert' and 'Un' values, then it should pass.If it only has 'Insert,' then it should pass.If it only has 'Unchanged,' then it should fail.I have tried everything, but I haven't been successful. Is there anyone here who can help me out?I am attaching the workspace for your reference.

How can we handle Symbology (or preserve Symbology) in FME while reading data from ArcGIS online feature layer?

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 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?

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 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'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.

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 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

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