FME Form

Hi guys a silly question here, is there a way i can expose the attributes before use dynamic schema to write them out? I'm using feature reader to read a list of sde feature class from csv file but hope i can expose their attributes for further processing before write to the destination.. Thanks!

Hello, Does anyone know of a way to use the HTTP Caller or another Reader/Transformer to download the entire contents of a Google Drive folder? There is a Drive folder (not owned by me) that hosts folders of shapefile data (link below). Does anyone know how to possibly download these folders in zip format so I can then process them as shapefiles in FME? I can download the whole folder directly in Google Drive, but I'd like to have this done automatically so I can schedule this workflow to run once a month. Any help is greatly appreciated. https://drive.google.com/drive/folders/1KLb-8DcrXkVFW8b2OmbOnEEueQNSUS5Y

I have an attribute (ID) contains ID 183849fjlr-kfklf373789-hdlldfo398383-jjdfj087734 and sort attribute contains sort 0-1-2-3 I would like to convert them to be  Target ID. Target sort 183849fjlr 0kfklf373789 1hdlldfo398383 2jjdfj087734 3 fme 2021 thanks in advance          

Looking to create a csv output as a 'dat' file for import to another system. basically rows of text with the fields essentially defined by the number of characters they occupy in the row, padded as necessary. So, i need the output row length to be fixed for each field, and yet I only have the otpion of vchar.In online documentation I can see reference to a datatype of char, but this is not exposed in the fme writer.Why is it missing? / Why have I missed it?Help appreciated.Using FME Desktop 2022.1.2.0

Hi, I am a master scholar conducting a study on BIM and GIS. I am also new to using FME and don't have a background in computer science. My question is, what is the difference between the attributes in a table and the hidden attributes in properties? Why are they hidden, and why is it necessary to expose them using the Transform Attribute Exposer (not Automatic Exposer)? Additionally, what are trails? I'm somewhat confused about understanding these terms.Another question regarding geometry, from my readings, geometry can be created through BREP, Extruded, and Sweep methods. How is this determined in FME, as I only see IFMEMesh, IFMEFace, and so on?

We have an authenticated WFS from Drone Deploy that has an API key. ArcGIS Online and ArcGIS Pro both have the ability to include the api_key in the request. Is it possible to include the custom request in the WFS Reader?  

I am trying to tint some terrain shadows (raster) with overlaying polygons of different colours (RGB). Thing is that the polygons are larger than the shadings so VectorOnRasterOverlayer colours a larger area than I wish. I only want to tint the "black/greys" in the raster, not the white areas. I have tried to filter out the unwanted areas using a RasterExpressionEvaluator, setting everything beyond break point to white. Unfortunately I have not been able to figure out a syntax that does not also change the hues. Any ideas on how to approach this? Looking at the example below I would like to keep the darker/shaded areas and shift the flat ones to white.  

Hi,When i insert with the jsontemplater a date in the mongodb writer the type of date is always string even i choose isodate, fmedate......etc. Can i have a type date in mongodb via the jsontemplater ? Thanks a lot

When I specify an HTTPCaller with a defined header, then everything works as desired. However, as soon as I want to enter a conditional value (the same values that work alone), I get an error message: This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins. Unfortunately it's the same behavior when I define conditional User Parameters and use them as HTTPCaller headers. Is there a way you can use conditional "header" values in a HTTPCaller or is this a bug? Best regards

I want to set the vector tolerance value in the Matcher with a dynamic value. Currently, I can use a parameter value only. Is it possible to use an attribute value for this, or how can I set this value more dynamically? I have been trying also to create a custom transformer with the matcher in it. However, I got the same issue.

Is there a method in FME, similar to ArcGIS Pro, for exporting a model to a Python file?

Hi, I am struggling to put a simple Python script in gdb Reader/Scripted Parameter Value that will allow me to read only polyline. Could someone please push me in the right direction?

I have a dataset of curves (lines) automatically generated from the DTM. I have some topological issues that I want to detect automatically ( photo). I used the geometryvalidator transformer, but I can't seem to detect them. How should I proceed? Thank you for your help

Hello , i would like to design pdf that contains many tables look like excel file and these tables will filled in with some attribute names and some values  Fme 2021     

In the Feature Inspector, you can see the Geometry and the Contents. The Contents section includes the Property and Data Type columns. Where is Values column? How do get I the Property values to display?

Hi all, we have just updated from FME Desktop 2021 to FME Form 2023.1.1.2. I want to create a mapping file .fme, but the option .fme is missing in the Save As- dropdown menu. Has this option been removed by Safe Software? Or has this functionality been transferred to another menu? Does a workaround exist? Thanks for your help!

I've seen lots of people over the community asking how to read AGOL attachments, but I'm curious to find out what FME users are doing with them once they've been read using FME.

In the atrributes below I want to specifiy the usage of each building, for example building (_gebaeude) 504. Is there a way to do this in FME using the createAtrribute Transformer? There are over 40 buildings each with a specific usage and name

Hi All, I'm working on a workflow to bring the information from 3 separate layers into my analysis output. SpatialRelator would do the work but also want to create the lists in order to concatenate values into the same cell. I need to concatenate different fields but ListConcatenator only allows one at time, Screenshot below shows the fields I want to concatenate with the following structure: ListConcatenation A = GM_SiteRef + GM_TypeListConcatenation B = LandOwner + LandOwnership_Status + LandOwnership_TITLE_NOListConcatenation C = LEP_Site How can I make it to work and have multiple ListConcatenators? I'm trying to avoid any filter or tester as won't work.... PD: I would also need to add a ListDuplicateRemover before the concatenator to avoid duplicates in the same cell. Thanks in advanced 🙂

I'm testing Geocoder transoform. It works well with ArcGIS Online. With OSM I have this error: Geocoder_2_CALLER: HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Max retries exceeded with url: /?format=json&q=Strada+Villa+17%2C+37010+Cavaion+Veronese%2C+Italy (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTI... I use FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64) for ArcGIS (Data Interoperability extension).

Using FME workbench 2023.0, I am trying to make updates to some rows in a PostgreSQL table by using the FeatureWriter transformer that takes a csv as the updated dataset as input. However, I am unable to fully run the workbench as it takes an incredible amount of time to run, with the warning message: "POSTGRES Writer: Bulk Insert is set to Yes, but a conflicting Feature Operation has been detected. Feature type 'ela_master.lim_watr_chem_anal_arbi' has a Feature Operation of 'Update'. Bulk Insert is now being set to No, which can cause insert operations to be much slower" I have made updates to the exact same table using the exact same FeatureWriter transformer parameters before with no problem... and this is a new issue I'm encountering, and quite frankly I have no idea how to solve it. Can someone please tell me how I can fix this? Thanks.

Hi there, I have a workspace that fills out an excel spreadsheet and then pushes this into Sharepoint. I want to hide the first five columns in the spreadsheet (so I can unhide them when I need to check, but the user doesn't have to see it). How do I do that? I tried hiding them in the spreadsheet in Microsoft 365/Excel Online, but they revert to showing every time the process runs. I tried in the FeatureWriter Paramaters> Edit Column Formatting> Cell Protection> Hidden in the first five columns, but that didn't work.Thanks in advance for any guidance you can provide.

Referring to this: https://openai.com/blog/introducing-gpts I'd love to see a GPT fed with FME's documentation - also the Python API It's be great to have FME's built in AI tools use something like that to give more FME specific answers? Just an idea 

A workflow we use at work is as follows: Geometry data is stored in SQL Database (attached screenshot - SQL Geometry.png). It is a multi-part polygon and looks to be correct.I use a SQL Creator in an FME job to get the data from the SQL Database. We call a stored procedure to get this data but no transformations are performed in this GET.I use a Geometry Replacer in the FME job with the following settings:Geometry Encoding: Microsoft SQL Server BinaryMS SQL Server Format: GeometryAfter this Geometry Replacer the shape looks correct in FME Inspector, but the Type looks incorrect (attached screenshot FME Data Inspector.png)The shape looks rightIt is classed at the top level as an IFMEMultiArea type of 1 part which is not right. It seems to have classed it as a shape with 1 part (a donut) with an outer boundary and 2 inner boundaries.I'm pretty sure the data conversion into the SQL format is correct but I can't get access to that right now to double check.Has anybody got any ad

I want to create a PDF report like this , where i have HEADER and the value below   In this yellow boxes 'PDMS' column could go in this attribute values  this is my FME workflow to insert HEADER but , the values / attributes are coming from Excel output , so i need to insert them in this boxes like sum / average , total count etc.