Transformers

At this moment I received a DWG drawing with both Extended and Object data. To convert this data I first have to read with:Autodesk AutoCAD Civil 3Dthen read withAutodesk AutoCAD Map 3D Object Dataand merge all features on the autocad_entity_handle Am I doing something wrong or is this the only way to get both attributes?Is it possible build a transformer that uses both reading engines because I think that would make the reader faster than current.

Hi all,I am trying to show all tables with contents in a database. I have a database with over 800 tables. Some tables are empty, some are not.  Im using this query in a sql client:SELECT SCHEMA_NAME(t.[schema_id]) AS [table_schema]          ,OBJECT_NAME(p.[object_id]) AS [table_name]          ,SUM(p.[rows]) AS [row_count]    FROM [sys].[partitions] p    INNER JOIN [sys].[tables] t ON p.[object_id] = t.[object_id]    WHERE p.[index_id] < 2    GROUP BY p.[object_id]        ,t.[schema_id]    ORDER BY row_count desc  If i am using a Sql Executor with this sql statement i have a return value of more than 300 tables wich is correct. In the preview of the feature window i see more than 300 lines. But i dont see any attributes like a table name or the number of records. Do you know how i can expose these attributes?

Hello everyone,I am trying to write data into an SQL Database which contains multiple geometries (This is borehole location data containing the originaly measured location (point), a corrected location (point) an a borehole path (linestring)). After creating the geometries from fields and using a GeometryPropertySetter for each of these geometries I am using an Aggregator followed by a MultipleGeometrySetter-Transformer. This is working more or less as in 3 Geometries are in fact written into the database which then also contains 3 fields with SQL geometries as set by the 3 GeometryPropertySetters. But there seems to be a problem. Between setting the individual geometries and aggregation, all info on the previously set projections seems to be lost. Upon inspecting each individual GeometryPropertySetter all points are where they should be. Inspecting the following aggregator shows all points off bounds somewhere. It is my understanding that the aggregator should simply collect the input

I would like to create 5 cm buffer around 3 Cube without having rounded corners or edges.  Exactly the same as its original with 5cm buffer ?  thank you in advance  

I want to set up an FME workflow which I can reuse for projects, in which input data differs. For this, I want to load different shape files into FME using a parameter (the shapefilename). These shape files have different attribute names, so I wanted to use the schema mapper to map these different attributes.The problem is that I cannot get a dynamic reader to work properly (I used feature merge). When I load in the first shapefile for the first project, the reader sets the user attributes to the attribute names of the first shapefile . If I restart and load in the second shapefile , it won’t expose the attributes from the second shapefile (the attributes from the first shapefile remain!). How can I set up the reader to be able to handle different input schemes and change the exposed attributes dynamically, based on the input files?

Hi,In case I select ISO format in TimeStamper, does it assume that it is UTC or not nesessarily?How to set it to UTC?  

Hello,In FME 2023 , in the AreaOnAreaOverlayer transformer the tolérance = “None” parameter has been removed. There only option of “Automatic” or “Custom value”.Question : if there was Tolerance = “none” in pre FME 2023 .fmw scripts, should we use Custom Value = 0 to have the same result as tolérance = none  or “Automatic”?Thanks

Hei, er det noen som kan hjelpe meg med å lage en fme-modell som konverterer 2.5D bygninger i sosi/quadri til 3D-bygninger ? Det er høyde på alle objekter, men høydene ligger ikke som  egenskaper.Ønsker et filformat som kan brukes i qgis for å bygge 3D-modeller.

We generate certain types of transformers (mostly HTTPCaller) with some attributes prefilled and want our users to be able to copy the content from a file or web source and paste it directly into FME Workbench, or use drag and drop, if possible. We don’t want to use custom transformers, which works, but the overhead would be overkill. The problem is that the paste does not work, CTRL+V does nothing and the paste menu option is greyed out. I tried with a direct clone of a working transformer so the format is correct. If I copy a transformer, paste it into an editor, copy the editors content and try to paste it back to Workbench it won’t work. I don’t know why this does not work but I persume it might have something to do with encoding. Does anyone have a clue how to overcome this issue, or maybe a workaround? Thanks in advance.

Hi everyone, I have an object like the one in the screenshot which is read from an IFC file. And I have some 3D points in a GeoJSON file. I want to copy the object on each point coming from my GeoJSON file.And also, I want to rotate them in their place.  What can be the optimum solution?Thanks! 

I created this line from a set of (X;Y) values of points : I’m trying to turn the lines straight and then buffer them to have a result like this: Is that even possible ? i tried using Bufferer directly then Generalizer , but the result is not good : Any Insight is much appreciated !

When I try and run the dashboard workspaces they fail with statusMessage File Dashboards/JobHistoryStatisticsGathering/JobHistoryStatisticsGathering.fmw could not be openedWhen I look around the FME Server files I cant find any of the dashboard workspaces. Where did they go? Where can I get them?

Hi everyone,I’m hopeful somebody here will have seen this behaviour before and can help me to understand what’s going on. I’m getting an error when trying to decode some Base64 documents that have been read out of a system but I’m not sure why and I’m not sure I can easily create a sample workflow to demonstrate it, as I’ll explain.The task is to extract specific documents form an API connected to a document management system. I’ve been able to create a workflow that will identify the required document IDs and then extract the documents into feature attributes for me.The document data that is returned to me is in Base64 format. When I post the output data into an online conversion as a test, it is converted into a usable image (in the case that I tried). From this I assume that all other documents will work similarly.When I pipe that output into a BinaryDecoder and ask it to decode the Base64 attribute, it throws an error complaining about the input.When I copy the Base64 code and add

Hello. I have three line vectors in SHP format (Red, Yellow, and Green). All of them are 100% overlapping in plan, but some are shorter than the others.Which transformer should I use to remove the overlapping area from the Green line that intersects with the Yellow line, and from the Yellow line to remove the overlapping area with the Red line? Please refer to the sketch below.I tried with Clipper but it didn’t work. Thanks in advice! 

As per my knowledge, FME does not supports reading Multi-part Annotation features from Geodatabases (File or Enterprise).Is there a way or workaround to handle reading and writing Multi-part Annotation features?

Hi All, I have a list of data features like thisName   Phone Number   CitySmith   123-456-7890     New YorkBob      987-654-3210     HustonIn addition, I have a single lookup feature like thisCompany   Idxyz             123I would like to merge the lookup feature into the list of data features like thisName   Phone Number   City             Company   IdSmith   123-456-7890     New York    xyz             123Bob      987-654-3210     Huston       xyz              123 I thought I can use transformers FeatureMerger or FeatureJoiner to do this. However, since I don’t have a common attribute to compare, neither of them works. Can anyone help me on this issue here? Thanks,-John

Hi All,I’m working on a workbench to help my team with some geo-processing. The plan is to upload the workbench to FME Flow therefore my team can run it on demand.I have included a FeatureReader transformer at the beginning of the workflow to read a GDB containing cadastral polygon data. This is an User Parameter in the workbench therefore the user will be including the input.The GDB should always have the same fields/order, any variation in the scheme...the tool will fail,How can I check and inform the user at the beginning of the process that the scheme doesn’t follow the standard GIS schema?I was think about the SchemeScanner or ChangeDetector...but open to suggestionsHere is a very basic screenshot that shows two FeatureReaders → Features To Read (Only Schema), 

Hello everyone ,i am currently working on Lidar data , i am reading a set of points from a json file and creating vertices based on the coordinates.here is how the json file containing the Lidar data looks like :  (a bunch of (x,y) set of points)in order to make use of FME point cloud specific transformers i need to convert these points from point geometry to Point cloud geometry , any idea on how i could do that ?Thanks in advance

Hi, I‘m stuck at a simple point. I want to make the AttributeKeeper filter from @Value or a User Parameter which is created by the AttributeCreator. Is it possible? I don't find a solution.The goal is to get more attributes late in a row: test_2,test_4,_test_x in the AttributeKeeper from the AttributeCreator/User Parameter.  

Hello, I have these dataArea Category Date A  Medium  202301 A High 202305 B Medium High 202306 B Medium High 202305 B Medium High 202304 B Medium High 202303 B Medium High 202302 B Medium High 202301 C Low 202306 C Low 202305 C Medium 202304 C Low 202303 D High 202306 D Low 202305 D Low 202304 D Low 202303 E High 202306 E High 202305 E High 202304 E Medium High 202303 E Medium High 202302 E Medium High 202301 I want to count the categories that occurred 3 or more times consecutively per area. So something like these Area Category Count Same category consecutively >3 A    0 B Medium High 6 C   0 D Low 3 E High 3 E Medium High 3  I am not sure how to do it in FME. Thank you!

Hello, I have an issue with trying to use the Microsoft Word Writer. As far as I understand, I can build my Word document using multiple MSWordStyler transformers, and depending on the order of these, the document will be built differently. For example, if the “heading” goes in first, it will be at the start of the document, but if it goes in last, it will be last in the document. I have 2 MSWordStyler transformers, one table and one paragraph. I want the table to be first and the paragraph last. I got my desired result, but when I later saved my workspace my paragraph now ends up first and the table last. The order of which FME is reading the transformers has also changed. If I understand correctly FME runs the transformers in the order they appear in the Navigator, and you’re supposed to be able to change the order. I can’t do this though? I don’t get the option to move transformers up or down. I’m also supposed to be able to get the option to “Set connection runtime order” when I ri

When i use the python caller i get a translation successful, but it gives no output.I'm not very good at python, so do any of you have an idea what i did wrong? 

I am creating a geodatabase where I have buildings and all the corresponding rooms; however, when I import it into arcGIS pro, I am unable to select based on floor level. I checked the written data in fme, and all the rooms and floor levels are in the attribute table, but are merged onto one “layer”. Is there a transformer I could use that can make each floor level seperate from one another in the geodatabase? I tried using attributesplitter, attributefilter, etc. Thank you in advance!

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 BEGIN INSERT INTO [schema_name].[view_name] VALUES (@id, @name, @description) END Generally this works, but some of my attribute values (eg name and description) are long blocks of text with various s

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.