FME Form

 I have a workspace that reads AutoCAD Map 3D drawings, updates Link Template Keys and writes to a new AutoCAD drawing. The issue I have is twofold and listed below: Block Attribute data The Attribute data is converted to text and placed at the insert point of the blockThe default Attribute data appears in additionObject Data is simply gone in the output dwg file.  Object Data Tables remain, but data in them is removed

Hi all, Is there any transformer to reduce the no of vertex in line feature?I am using autocad data dwg format. there is large no of vertex in a line feature which you can able to see below image. Is it possible to reduce the number of vertex? and I tried with line combiner Its not reducing no of vertex.thanks ,saravanakumar.

A while ago I followed the article How to create a Sharepoint Web Connection and successfully created a web connection using the "Connecting to Sharepoint with your own Client ID [Multitenant]" steps. Now a coworker needs to use SharePoint in FME as well, so I exported the Web Service from my machine, imported it in the other machine and created a Web Connection based on this. Creating a web connection with the other user fails, after the username is entered. The error message is: Administrator approval requiredunauthenticatedneeds access to resources in your organization.This access can only be made by an administrator. You must ask an administrator to grant this app permission before you can use the app.Do you have an administrator account? Sign in with that account When I use my login, it just works. So the Web Service seems to be fine. Did I forget a step? Or did IT tighten the app aproval process in the meantime?

The GUI (icons, buttons, menus, text, etc.) in FME workbench isn't scaling/rendering correctly on my PC. Some elements are relatively large while others are very small. Is there a way to fix this?

I am looking for Inside workspace table feature count is there any way to get information 

I'm using a Geometry filter split out points, lines, polygons and tables (<unfiltered>). With the tables, I'd like to filter them further to split up the tables that begin with the prefix "Insp_" or "Maint_", because I want to exclude those from the rest of the script. I can only seem to figure out how to filter based on Attribute, but I can't figure out how to filter based on table name. Any suggestions would be greatly appreciated. Thanks!

Hi there, I have used a statistics calculator to group and count Shops on a streets by use - eg vacant, retail, leisure, financial etc. This gives me a table with the street name with different rows for the use and count of shops with that use on that street. Ultimately I would like to create a table with the uses as field names and the count of the use below with just the streets for rows. So for example - Converting the table in grey to the table format below that. I am sure there is an easy way to do this! If anyone can help I would be very grateful.Thanks Ruth

I'm trying to make some pretty histogram reports of some error differences and I'm having trouble getting the chart generator to actually show the trend line. I want to show it because my data should be close to normally distributed.I have tried to use the trend line in the scatterplot option but that does not work also.Does anyone know what I'm doing wrong? I should have enough data to get a trend (60+ data points)

Hi I need to remove new line in the result of my HTML extraction S.P. n. 1, S.P. n. 30, S.P. n. 245 the result must be S.P. n. 1, S.P. n. 30, S.P. n. 245 thx Francesco

I'm attempting to write data into a PostgreSQL database using the PostGIS writer. The issue I'm having is that the geometry is not being 'drawn' in ArcPro. When selecting the record in the attribute table, the geometry highlights but is not visible. When creating a feature from scratch in ArcPro, it draws as expected. This makes me believe it's a configuration issue within FME. I have verified the Shape Column is 'shape' (as defined in the database), and that the SRID matches that which is specified as a constraint in the database (3857). The coordinate system I'm using on the writer is EPSG:3857. I'm converting from DGN, if that is relevant. When reading the data back in with FME, all geometry appears normal and in the correct location. What could be the issue?  

Hello Group, I have a polygon dataset of LSOA boundaries read into FME. It contains a field called ‘LSOA21 2021 name’. The values in that field are entries like 'Southwark e09', 'Lambeth e08' and 'Lewisham e13'.  I want to filter out only those records where the value begins with the word ‘Southwark’. I’ve added a TestFilter with an If Test Condition of @Value(LSOA21 2021 name) CONTAINS_REGEX Southwark. But that is maintaining the entries where LSOA21 2021 name equals, for example, Lambeth e08. I’ve been looking through https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/!Transformer_Parameters/StringFunctions.htm, but couldn’t work out exactly what string I need. Any ideas, please? Thanks,

Hi, i Would like to have the road map geometry as input from Google maps or any other app.and use it as input data to FME to define which cable located at this road and so on .FME 2021

I want to create a raster image with the sum of weighted input of vector polygon layers. I have many vector polygons. Each polygon should first be transformed to a raster and then given a weight/raster cell value (1-3, background value should be null or 0).

I'm trying to create a user parameter that consists of the filepath, 'Output', and filename to be used in the writer

Hi. I am asking for advice on final editing. The qus1 file is the current FME output. In the StartpointDesignator column, I need to remove duplicate values and output them to the CSV output in the format see the "vzor" file.Thank you

I have a point shp file that has an attribute with a number and I need to do a point on area overlayer, but the count in the area needs to be a sum of the attribute in the point file. I am stuck on how to do this! Hope this makes sense!

I'm trying to convert 3D models to GLTF, however, the output models tend to be a little do dark in the application we're using. I'm trying to make them brighter by setting the SpecularColor factor to white. I also want to set the shininess, but only if there is no shininess set. In addition I want to also apply a fallback appearance to the surfaces which have no appearance. The conversion needs to work for all inputs and ideally be nice and fast. I've been playing around with the SharedItem tools and have gotten very close to what I want, however, there are some edge cases where my process doesn't work.It seems like it should be really easy but I just can't get it to work. Has anyone had luck doing this?

I'm trying to pass the sql query dynamically through the webhook url and then execute the query and generate a table using the query results.I have tried using the SQLCreatorProblem is, It is not able to expose the attributes automatically from the SQL query if passed dynamically.Is there any other transformers which would help me execute this?

Hello ,i would like to extract text from DGN File , it shown on map and use this text later as attribute ,Does it possible ? i have attached screenshot of text in DGN file any help please

I have Lines (13,000 Street Centerlines) and Points (7,000 Intersections). I want to do a spatial join of the Lines and Points so that the attributes of each point is merged with the 1 to 4 lines that intersect each point.  I just started using FME, after completing the training last month. What Transformer(s) would you recommend I use for this process? My goal is to have the lines each have the CROSS_ST_NAMES field which is in the points layer be joined to each line that intersects a point. In the points layer, the CROSS_ST_NAMES field has no <null> values, when they are merged with the lines there must be no <null> values. Below is a screenshot of what I am working with. Each line is a street centerline, each point is an intersection.  

I have a Shape file contains bunch of layers including one polygon layer.So i want to split all layer's data based on the each polygon boundary and save it as new shape files individually. How can i do this in FME?

I would like to insert new z values in a polyline feature using the surfacedraper while maintaning the existing z values. A feature can have mutiple vertices with and without z values or a combination.

I have recently installed FME Desktop 2022.0 (Database edition – Build 22337 – WIN64) and want to migrate old workspaces to this latest version. I have a workspace that was written and runs in FME Desktop 2019.0 (Database edition). It reads in about 120,000 records via SQL Creator (non-spatial Microsoft SQL data format), does some transformations, and writes to a CSV file. It works perfectly in FME Desktop 2019.0. However, when I open and run the same workspace in FME Desktop 2022.0 it is not working correctly. I have tried this on Windows 10 Enterprise and Windows Server 2012 R2. I have tried with Feature Cache on and off. I have tried running as a batch process. I have tried running the workspace in 2022.0 unchanged (as a 2019.0 workspace). I have tried running the workspace in 2022.0 unchanged (as a 2022.0 workspace). I have tried running in 2022.0 with transformers upgraded to the latest 2022.0 versions. In all cases after every 10,000 records, several records are corrupted on the

An overlay analysis between some polygons and a few lines has turned into quite the ordeal.I hope the supplied workspace and data is self-explanatory.In it there is four tests that yield different results. I start with clipping the lines with the polygons followed by a spatial relator intended on creating a list of references. I would expect that relator would find a relation between all lines since they can only be INSIDE. But more than half fails. To test the reason I run it through an Intersector and measure the distance from intersection node to polygon mask. I guess that is supposed to be 0, but 3 of 20 return a value larger than 0 - meaning that the intersectionnode is not in the intersection.    

Hi,I have a workspace where I use the oracle database connections as a variable. This works fine. When a runs the workspace a published parameter determines which connection is used. But when I publish this on fme server. I get an authorisation failure: FME Server error: `Unauthorized request by user due to lack of proper permissions for connection: **@**. Please see: http://fme.ly/zn8' Connections in fme server are available as in the variable.