FME Form

Hi, I am using the attribute creator to populate a new field. I want to fill in the blank rows with the previous master property number from the master prop no field. I have enabled the adjacent features but no matter what I try it still only populates just the 1 record after a value and not all the blanks. I thought I would only need 1 based on what I’ve found on the forums.What am I doing wrong here?I also tried to do that same thing via the attribute manager but get the same result.The end result would also have row 3 (FME row id not the xlsx one) with ‘932590’ and row 6 with ‘933123’ and rows 9-11 with ‘933796’ etc with the number of blank rows varying from 1 to potentially hundreds.The settings I have for the transformers are below.I am using FME 2022.2. Thank you! Belinda

Hey all,My FME workbench stopped working and then crashed. Is there a way to recover my unsaved work? Thanks, David

Hi All,I have set up my tool tip to tell me the version number of a particular Transformer in my workbench.Is there a way of relating the version number of a Transformer to the version number of my software?Can I find out which version of the software that a particular Transformer has an upgrade?For any particular software version, is there a list of the version numbers of the Transformers?Thanks,Nick

Hi everyone, I have a question: how can I use FME to create a series of equally spaced points along a 3D polyline provided as input from a DXF file?

I am trying to fill in the rows of my table with the previous values. I saw this thread and I am following the instructions but for some reason I am only getting the first empty row to be filled but not any subsequent rows.  I tried to change the Subsequent Features to another value other than 0 and even tried to change the number of Prior Features but I always get the same results.I am on FME Form 2024.2.0.0 if that helps. Any suggestions as to what I am doing wrong?  

I don’t have an programming background, so please bear with me. I need to find out the circular standard deviation of the rotation attributes from a set of features in degrees.The built in AI in the PythonCaller has taken me as far as the code below. I have tried many different prompts, they use somewhat different methods to do the calculations, but all throw errors about missing methods or incorrect classes. It seems that the AI is unable to initialize the script “The FME way”, or I have not figured out the correct prompt.What do I need to ad to the script in order to get the below working? My desired output is the circular_standard_deviation as a new attribute.Another nooby question, what should I write in the box: Class to process features? import mathimport numpy as np# Function to calculate circular standard deviationdef circular_standard_deviation(angles_deg): angles_rad = np.deg2rad(angles_deg) sin_sum = np.sum(np.sin(angles_rad)) cos_sum = np.sum(np.cos(angles_rad))

Have a DTM. Am creating contour lines. Are there any tools in FME that can be used to identify any Depression Contours in the data?

Hello, so we have now switched from Server to Flow and all is good and great except from one bit, and that is there have been made some changes between these versions that have made my emailer workarounds from Server useless.So what we did before is that we just set up the Emailer in the workspaces and sent automatic answers in the ‘Body’ section of the Emailer such as:p>Hello Colleague</p><p>Here is your GeoJson to DWG/Shapefile datapackage:<a href="$(FME_SERVER_DEST_DIR)">Click me to download</a></p>Where the ‘$(FME_SERVER_DEST_DIR)’ was the download link for the result and it worked very well.But now on Flow it doesnt work, the email sends and all but there is no value being fed into the ‘a href’ so now download hyperlink for the message.What has changed here, is it only the value for the URL and if so what value should I be referring to now to get the result data on flow downloadable?If this has now been made very different then what should I be doi

Hi All,How can I add a conditional parameter (visibility) in FME 2022? I know it’s possible for 2023 but can’t find it for 2022.I have created a workflow that allows the user to export data into different formats (E57, CAD, LAS, XYZ) and I want to offer the option to export the data as DWG or DXF if the user picks CAD, some images below: ...then the user only has the ‘Choose the output CAD format’ enable if CAD was chosen in the first parameter. I’m on FME(R) 2022.2.5.0 (20230329 - Build 22795 - WIN64)

Hi, I am trying to replicate the V-Lookup formulas in FME that I currently have in my excel. Also the current excel formulas refers to a different sheet named Limits and I am looking to create the same sheet in the FME and finally when the writer generates the output the file should have 2 sheets - 1st one where the data is written and the 2nd will be Limits. Writing to the existing template is not an option due to complexities involved  

Hello,I am using LineOnLineOverlay to detect intersections within a polyline dataset. I am only interested in intersection points that involve more than one feature, and would therefore like to exclude any intersection points where a feature is intersecting against itself.Using the attached image as an example; I wish to ignore the intersection where line A is intersecting itself, but need to record where lines A and B intersect, and where line C crosses over line B.TIA,RB 

Hallo there,I have a big collection of 3D-lines and a big collection of 3D-Triangles/Surfaces that I need to intersect with each other (I only need to know whether there is an intersection not length, position or number of intersections). Performance is somewhat important due to the size of the dataset.I tried extruding the triangles to a short height to get a solid and this works but is super slow.  Surely there must be a better/more efficient way to calculate the intersection between a 3D-line and a 3D-triangle? Many thanks in advance. 

Hello everyone, I hope you are well, I am new to FME, I have a .dae file (Collada) that refers to a 3D model of a tree. I also have a layer of points with coordinates in shapefile format of an inventory of trees. Is it possible to integrate the 3D geometry of the .dae file in each of the points of my inventory?. to finally export it in a 3D viewable Kml file.

Recently two independent installations of FME 2018.1.2 crashes at start. Has anybody had similar situations and may suggest how to identify the root cause?

Hi everyone,I'm working in FME Form (not FME Server), and I would like to capture any error messages that occur during translation and send them via email using the Emailer transformer.I tried using the LogMessageStreamer transformer, but it seems that it doesn't capture error messages — only warnings and general log info.Is there a way to retrieve the error messages (or even the full log) during a translation, and pass them into the Emailer transformer?I'm looking for a solution that works within FME Form. Any ideas or best practices would be greatly appreciated!Thanks in advance,Isabelle

I think this is a simple one, but for the life of me i cant seem to figure it out.     I am running a line on line overlayer and only want to compare 1 feature dataset to another (i.e. i dont want features from the same input dataset to self intersect).  Thanks in advance.  I am running FME2011.  

I am using FME Form 2021. I have a workspace that includes a Directory and File Pathnames Reader and a File/Copy Writer. The workspace moves files from the specified Folder on one server to another Folder on a different server. It moves the files and runs no issues.  But, after the files are moved to the destination folder, I need the files in the source folder deleted. Is there a way to do this with the Reader and Writer? Is there a parameter I need to change? (I know I can make a second workspace that has the FileDeleter and delete the files that way, but wondering if I there is another way) Here is a screen capture of the workspace: 

Hi,When launching a workbench using mostly SQLExecutors, with long sql statements, I can only see the first few lines for those statements on the Log file, for each SQLExecutor, but not the full SQL statement.Is this something that cannot be modified?I’d like to have all SQL lines that have been through the process.log fileworkbenchThanks,Juanma

Good morning, I'm trying to write some geodb_point features (cell) to a DGN using Bentley MicroStation Design Writer. The MicroStation cell library must be specified in the writer's parameters. The cells are placed in the DGN, but they appear incorrectly scaled compared to the cells in the cell library. If I refresh the cells in the DGN again from the cell library, they appear correctly scaled again. Unfortunately, I have to perform this step manually for each cell. I've tried adjusting various settings in the writer's advanced parameters. To no avail. Can anyone help me?

Hi everyone,I am new FME user and I will be grateful if i could get some tips what transformers should I use for such an analysis I need to do:I have two addresses’ database (one is reference), both contain addresses (points) and one contains buildings (polygones). i have to compare that dataset: if addresses are on the building or not and if not how distance is betwen address and builiding. If postalcodes are correct; for example if addresses on street x have all the same postalcode. if address is located on correct street and correct town/village.

Hello there, I’m currently working on a workflow for which I need a python package that is not preinstalled with FME.I tried installing the package according to this help page:https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/Installing-Python-Packages.htm Unfortunately I got a dependency collision with other packages that are already installed.So I tried setting up a virtual environment but FME doesn't seem to support custom venvs.https://community.safe.com/transformers-9/how-to-integrate-a-custom-python-environment-27779 My question is:Without uninstalling or up-/downgrading the already installed python packages,what is the official way to avoid such dependency issues? Many thanks in advance.

Hi all, I’d like to use FME to execute some count SQL functions on SQL server (SDE). I’m having trouble with the syntax of the SQL in FME and I’m not receiving any output from the SQL Executor. SQL I’m running:SELECT COUNT(*)from "SDE".SAMPLE;

I'm using FME to write spatial data to a SQL Server database via an SDE connection, but the table is created without the spatial data. How can I ensure the spatial data is written correctly?Error message below for refernce An error occurred while attempting to create the feature class 'EL.DATA'. The error number from ArcObjects is: '-2147216061'. The error message from ArcObjects is: {Table already exists [42S01:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]

Hello everyone,I performed a feature merger between two shapes and obtained a list from this transformer. My list is as follows:insee: 11232code: PTRSURF: 11insee: 11232code: PPHSURF: 15insee: 11232code: SPLSURF: 23insee: 15500code: PPHSURF: 2insee: 15500code: SPLSURF: 555So I want to assign the elements of the list to an attribute table (in columns). I have a maximum of 96 elements for a single code, so my resulting table will have many columns.So I want to get this: How should I do this?THANKS

HI All,I have prepared a workspace that allows the user to clip a LAS file and export it to LAS or DWG. I was thinking to use the GenericWriter to include the options for the user….but the transformer fails when trying to export as LAS. The reason for that is because I have included a PointCloudToPointCoercer right before the writer to make sure the points are written to DWG however the fme_point geometry isn’t allowed by the LAS format as requires point cloud geometry. Here is a visual screenshot of the workspace: I have included (for now) an additional LAS writer that skips the PointCloudToPointCoercer and writes the LAS file as point cloud geometry…How can I modify the User Parameters to allow the user to chose one writer (LAS) or the other (DWG)?