Transformers

Is there a straightforward FME way to set all attributes exiting the failed port of an AttributeValidator and listed in the validation message list to null? I have a very straightforward bit of python to do it, but my brain is failing me this afternoon on an FME methoddef FeatureProcessor(feature):    for i in feature.getAttribute('_fme_validation_message_list{}'):        attrname = re.search(r"(?<=Attribute \')\w+",i)        feature.setAttributeNullWithType(attrname.group(0),fmeobjects.FME_ATTR_UNDEFINED) 

The number always begins in the PDF file with "Registratienummer: the number I want to copy"

Hi there Just as the title says. I know how to do this with a shapefile within the writer but I cant see the same options within the sharepoint list writer Thanks in advance-Ed

For example, projectname: X has a MethodType:Vegetation. When one chooses Project name X, MethodType:vegetation should autopopulate. This ensures correct method type gets picked up without spending time to identify the methodtype for that projectname especially if there are many methodtypes.

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!

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.

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.

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.

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?

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.

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

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. 

Table 1 Table 2

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

I have created a custom transformer and exposed all external attributes from the input port. I have two attributes, they are called Attribute1 and Attribute2. On the output port, I have set Attribute To Output to Specified Attributes Only. Now I can select/unselect attributes from the list. I have unselected Attribute2 and pressed Ok but the settings don't work. Both attributes are still present outside of the custom transformer on its output port. When I reopen the properties of the output port, both attributes are still selected. But now I cannot unselect them anymore. They are greyed out although Specified Attributes Only is still selected. It doesn't help to change Attribute To Output to All Attributes and back to Specified Attributes Only. When I restart FME, the attributes are not greyed out anymore, but it doesn't matter if I unselect attributes on the output port. The settings take no effect when I press Ok.

I've been trying to find a solution to change the start /end vertex of a closed polyline. I have a point where i want the polygon to start, how can I easily reorder all the vertices?

Hello,  I am a GIS Database Analyst at the Province of Nova Scotia’s Nova Scotia Geomatics Centre working along side John Power. We have recently encountered a possible issue with FME in a workbench we have created that reads in CARIS files and coverts them to ESRI file format data where topological errors sometimes appear to be occurring during the conversion. We are trying to create a process that converts our Nova Scotia property records database’s management units (MU’s) from CARIS to ESRI format filetypes and also build polygons from the existing linework.  Our FME Version being used is FME Desktop 2022.2, I have also attached a copy of our current workbench and one of our zipped CARIS MU Units as an example.  The issue we appear to be encountering is that our FME converted lines sometimes appear to have an extra vertex added that is causing topology errors that don’t allow certain polygons to be successfully built. The ex