FME Form

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

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.