Transformers

Hello! I currently have a stored procedure in MSSQL that takes in some parameters and inserts into or updates a SQL view. I’m using a SQLExecutor transformer to run that stored procedure, passing in the feature attributes from FME as parameters for the procedure. The code in the transformer looks something like this:EXECUTE [schema_name].[procedure_name]   @id = '@Value(id)'  , @name = '@Value(name)'  , @description = '@Value(description)'And the stored procedure looks like this:ALTER PROCEDURE [schema_name].[procedure_name] @id nvarchar(100), @name nvarchar(250), @description nvarchar(250)ASBEGIN IF ((select count(*) from [schema_name].[view_name] where id=@id) =1) BEGIN UPDATE [schema_name].[view_name] SET name = @name, description = @description WHERE id = @id END ELSE

Can i get the Publish parameter as Parameter input of the transformer?I want to customize this parameter in order to display or hide ports of Customer Transfomer.   

Hi All,I’m working on a workbench to help my team with some geoprocessing. The plan is to upload the workbench to FME Flow therefore my team can run it on demand. I have included a FeatureReader at the start of the workflow to select a GDB containing Polygon data then I was able customise the tool to with a User parameter read the GDB and give the user the option to select the feature layer. That works fine.The challenge now is that I would need to provide the user with the option to select the relevant fields based on the Generic port, How can I set up the User Parameters to allow the user to select the relevant fields to include in the analysis? Here are some screenshots of the feature reader as well as the Parameter Preview: 

Hi,I am trying to use FME 2023 version to convert OBJ into Cesium 3DTiles.While the conversion is successful, I notice that it causes our application to becomes sluggish, and it also consumes alot more resources. The application I am using is Luciad (https://dev.luciad.com/) and the software vendor has given the following feedback after investigating the Cesium 3D Tiles data:1. The number of .b3dm tiles generated are too few, resulting in each .b3dm being to "heavy" for loading & rendering.2. No sufficient number of "level of details" To demostrate that, I created a small sample and uploaded to https://drive.google.com/file/d/1FYMHx977zB_NAJa74nqMfmLvlMqWKPog/view?usp=sharing.1. Large .b3dm files    a. The .obj that I convert to Cesium 3D Tiles has 330K triangles.    b. Only 2 .b3dm files were created. But it should have at least 33 .b3dm files (330K/10000) since I am using 10000 for Maximum Number of Triangle Faces Per Tile (se

Hello, the problem is the following. I have a duplicateFilter attached to 2 different featuresTypes, which have an attribute in common. I would like, however, that when there are duplicates, the features of a certain type remain in the unique port. In other words: when there are duplicates, I always want the pair of the copy that goes to unique to be of a certain feature type, always the same, and to be able to control it. Any ideas? Thanks, Pol

Hello,I’ve researched this a bit now, and most folks point to the Generalizer, maybe Thin No Point.  However, I’m not concerned about distance away from other vertices (parameters of Thin No Point), rather I’m only concerned with removing vertices that fall in a straight line under the original line.  In other words, remove vertices that don’t change the shape.  These vertices could be 1 foot away from an adjacent vertex or 1000’ feet, doesn’t matter. I’m more or less looking for a algorithm that checks whether each vertex is on-line between it’s neighbor to the left and neighbor to the right.  If it is on-line, then remove, if not, keep.  I realize that there would need to be some tolerance parameter (angle or distance offline) due to rounding, but can accept that fact. Any ideas what transformer or Generalizer parameters to choose to best achieve this?Thank you,Tyler

I need some help with this problem below. As seen below the lines have diffrent attribute ID’s 1,2 and 3. The lines 1 and 3 are moving correctely as a offet 10 meter from their first location, as seen in the picture to the left. But line number 2 are not moving as an offset, as it is an exit ramp with different attributes than line 1 and 3. I want line number 2 to move with line 1 and 3, so they are connected in the same way as the right picture, meaning same direction and shape. I already have a dataset as the right version and my first thought is to create a point layer with start- and endpoints of each line and make them always connected as line 1 and 3 are moving. How should I solve this problem as easy as possible. I have a large roadmap of these lines and problems, so this is just an example.  

Attached are simple FME-Workspaces from version 2017 and FME-Form with GeometryPropertySetters and Aggregators and the xml outputs. The 2 workspaces are exactly the same.FME 2017 writes the aixm Marking Element Geometry as expected, but FME-Form does not - the MarkingElement Geometry Feature is missing (Workaround is to use XML-Templater).Any idea, is this a bug?

Hi All,I’m getting the following error in the FeatureWriter transformer:A field type of 'number(20,version;1;cell_border_formatting;NO;text_alignment;NO;cell_protection;NO)' was specified, which is not valid. Please check the documentation on the Reader/Writer for information on valid field types...the normal GDB writer works perfectly fine with the same data...I had a look into the field types but couldn’t find the error,Any ideas?

I wish to extract a sample from a table where each attribute from some field should be represented x times. For example see below where x is 1, and the fields I want to sample from are House, Priority and Injury. Input:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand3        Ron      Gryffindor  Low        Head4        Cedric  Hufflepuff  High       Chest Output:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand4        Cedric  Hufflepuff  High       Chest

Hey.I need to count the number of characters in all text fields of my dataset.Any simple way to do this to avoid using multiple StringLengthCalculator ?

Searched for possible solutions here, but nothing yet. Have : col0 col1 col2 col3 col4 Region A BU02851 BU02852 BU02853 BU02854 Region Value A 50 55 40 10 Region Value B 7 11 4 15 Region Value C 60 70 10 25  Need : Region A Region Value C       BU02851 60       BU02852 70       BU02853 10       BU02854 25

Hello,I have two questions about the HorizontalAngleCalculator transformer. 1) I simply need the AutoCAD Angle property of a line as shown below. Is HorizontalAngleCalculator the best transformer to use?  Or, better yet...is there a way to expose this property in the reader?2)  The install message for the HorizontalAngleCalculator says it’s not not created by Safe Software, but rather by “safe-lab” implying Safe Software Lab which is kind of confusing. Can someone clarify what this means and whether the transformer is trust worthy?Thank you,Tyler

Hello,I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database.I have tried to find an example online doing something similar but I had no luck.I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.

I have an FME workspace that sends me an email during certain error conditions. This works great on my remote laptop, but fails on my onsite desktop machine. The FME workspace needs to be run nightly on my desktop machine. This means that I won’t get the email (and won’t be notified of the error conditions). On my desktop machine, I get this error message: ERROR_DURING_PROCESSING<class 'requests.exceptions.SSLError'>: HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/me/sendMail (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)'))) The only difference I can think of is that my laptop use a VPN connection and my desktop machine is on the company network. I contacted someone in our IT department and they want to know the name of the certificate which I don’t know.Does anyone have ideas on how to r

Hi Community,I have a workspace with some python in to create a container within a blob storage account (something the blob storage connector was not able to do). The problem i’m having is that as soon as i use the blob storage connector in my workspace the package is installed in C:\Users\%username%\AppData\Roaming\Safe Software\FME. This then seems to force FME to use this directory in my python caller. The problem is i’m using newer python packages where BlockBlobService no longer exists and is replaced by BlobServiceClient so they stop working despite being installed as per the instructions for installing python libraries. Does anyone have any suggestions? 

Hi,I am trying to use the RasterObjectDetector for an object detection task using FME Form 2024, but translation fails and I get following error messages:-Library 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library.-Could not load module 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' : 'The specified module could not be found'-Module 'opencv/rasterobjectdetectfactory' is unavailable for use with this FME editionI downloaded OpenCV 3.4.9 and added the installation location to the system path, as specified in the documentation of the transformer, but it is still not working. Does anyone know how to solve this?Thanks!

I'm using the ESRIReprojector transformer. When converting between NAD83 and NAD27, I get one option for Geographic Transformer. In ArcGIS, I get several options for Geographic Transformer. Is there any way to get the same multiple options in FME without recreating them? Thanks.

In my workbench I download ffs file from azure storage and assign the path in attribute _download_path then try to read the file from the same path using FFS reader but it’s not recognizing the path and in the error even showing wrong name like it’s replacing some characters like it’s considering the wrod gelöst as gelo?st. This word is in my filename.

Hi all, I am trying to convert a AGS File to a standard format to view such as Excel or Shape. I seen something like this online using leapfrog https://www.youtube.com/watch?v=OtyrYsx9teE but struggling to find a simple solution in doing this with FME. Any useful tips would be great.

Hi All,I have created a workflow that reads a few large GIS datasets in vector format across different areas. To avoid reading all the records in the dataset and reduce time I have used the FeatureReader transformer which is connected to the layers and an Area of Interest. The Spatial Filter option is ‘turned on’ as Boundary Boxes OGC-Intersect to read only those records within the Area of Interest. The problem is still takes ages to read,I have got a few FeatureReaders within the workflow and I was thinking to use only one FeatureReader (as all the data comes form the same GDB) to improve the performance, Any ideas to improve the performance of the workflow?

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work?  FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_

How to calculate the IRI between two points in FME if we know the distance and the slope?Thank you.

In FME 2018, I want to use a custom python interpreter, and a specific python virtual environment (conda environments).How can I do this?

Hi!  I am trying to convert an excel spread sheet (no spatial data involved, just plain data) into a pdf file with pagination based on a field in the spread sheet. Can somebody help me through the steps of this conversion? I have seen posts about using table adder, text adder, pdf styler, pdf page formatter etc. but I am trying to understand the high-level steps to start developing this process.I was hoping SAFE would have some webinar or tutorial on simple excel to pdf conversion, all I can find is extracting data from pdf and converting to excel.Any help is much appreciated.Thank you,LSugumar.