FME Form

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 

FME Form 2023.0 I have four datasets, three line datasets which I add an attribute to distinguish it from the others, this attribute is called MaxLength. The forth dataset is a point dataset. The three lines datasets are run together and then run I a pointonline with a groupby using the MaxLength attribute in the line datasets but I get no matches. If I remove the groupby then I get results.  Is the above possible with the group by or do I just need to run the pointonline with each line dataset separately?  

Hi, I am trying to automate creation of template file from different forms into Excel spread sheet. There are many forms to extract information from. I am trying to first create a template of the column headers for each form into separate excel spread sheet.​I managed to get all the column headers as a feature within each form_id as seen below.As you can see there can be many forms (form_id is unique for each form) and within each form_id i have column headers (label). how can I transpose these labels as column headers in excel (1 excel template for each form) and write them out in excel? I have seen e.g. transposing columns into headers, but I'm not sure what I can do when I have dynamic number of forms and each form can have dynamic number of columns. Any help is much appreciated!

I would like to integrate and automatize Primavera data in FME.I don't see any reader that accept primavera.How should I proceed to reach my goal?

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

For eksample: Features with the same UUID shall be used later in the workflow. But I don't know what UUIDs will be in the Input data. I can geneate a list of unique UUIDs at runtime and would like to use this list in the AttributeFilter, defining the AttibuteFilter-ports. Would // How would this be possible?Thank you.

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" Thank you

This is a simple one but I'm new to this, I just want to output a CSV of the feature data as shown in the image one, in the other image (CSV writer) there is only three showing up. How do I get all to show up so I can export all of them? Can someone please explain what I'm doing wrong here?Thanks!

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.

Can we write Arcgis Pro file formats ( aprx) with the help of FME.

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 manually need to change the expression from 5 to 6 as divider...and trying to avoid this. Is there any way I can tell FME to update the divider if new dataset is added? Ultimately I want to make the average calculation as a Custom transformer.   

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 list to the feature. I expected it to be something like:feature.setAttribute("fc_list",fc_list)The log keeps reporting the error:Python Exception <TypeError>: Could not convert attribute value to a supported attribute

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