FME Form

Hi everyone,I'm new to Smallworld and FME working together. The only thing I'd like to achieve to update one attribute, not the geometry. I set fme_db_operation = UPDATE and I didn't give any geometry information. After running workspace i could see a few records being updated but translation failed with this message: Number of Features: 1Connecting to Smallworld on localhost:30000 using service FMENOFACTORYTable: 'gis.point_of_interest'NumberOfAttributes: 16Processing a pointError running translation. Do you have any idea why this happens? Many thanks

Here is my scenario: I need to very roughly georeference thousands of scanned air photos that are tracked in a file geodatabase. Oversimplifying things considerably, my fields look like: Filename (which contains location of the raster tif on disk)Center_X (map coordinate)Center_Y Rotation (always zero for my simple exercise)ground_resolution (in map coordinate units) I want to feed each "filename" to the rastergeoreferencer, using Center_X, Center_Y, rotation, and ground resolution. But I'm conceptually stuck... rastergeoreferencer obviously wants input from a raster reader, not a text string with the path to the raster. See the rub? Can somebody give me a push in the right direction? Thanks!!

I have been getting this error a lot: Excel Writer: Failed to open the dataset 'FILEPATH\\FILENAME.xlsx'. Error message was 'No such file or directory.'XLSXW writer: An error has occurred. Check the logfile above for detailsExcel Writer: Dataset 'FILEPATH\\FILENAME.xlsx' contains no data and is therefore not a valid Excel file. No file will be createdXLSXW writer: An error has occurred. Check the logfile above for details It will happen a few times and then the workspace will run as normal. This occurs in any Workspace I use that has an Excel Writer. In the Task Manager, if there was a process I could end, I would do that. It still happens.  Any Ideas?Thanks,-Loren  

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 sam

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.