FME Form

I have a very long list of attributes that I have typed into an AttributeValueMapper transformer. I now want to share this mapping with someone (not an FME user), so I would like to export the source and destination values to excel. I see that there is a button to import to this transformer, but not one to export. Is there a way around this, or doing I have a lot of typing to do?

Hi All,I’m new to process LiDAR data using FME and just received a bunch of LAS files that need to process as DEM (output). I was doing some reading and users sue the _classifciation to classify the data but have just realised that my data isn’t classify as my classification filed is 0? Screenshot below: I’ve also tried to use the PointCloudLASClassifier but the classification is 0 so doesn’t work. Any trick to classify the data and be able to export the DEM?

Hi,I am extracting GIS layers into a DWG file using FME 2017.0.1.1I would like to define the color of Autocad block attributes using Red Green Blue (RGB) codes (autocad true color) instead of autocad color values.The RGB values are defined in an Excel settings file that I call up in the transformer “AttributeCreator” :However in the output DWG file, the color is defined by an autocad_color value (very close to the RGB value but not quiet the same), but it doesn’t write the RGB values in an autocad_true_color attributes.I also tried to create an autocad_true_color attributes defined by the RGB codes of my Excel file but it doesn’t work neither (same output).Is there a known limitation in FME working with autocad block attributes with autocad_true_color? And is there a known workaround?Thanks in advance for your support.Aude 

Hi there, I am trying to create a 3D photo mesh using LiDAR and aerial imagery, but find using the TIN Surface produces a more jagged output, even with a higher tolerance. I was wondering if it’s possible to do this using a DEM and if this would produce a neater result. I am using Surface Modeller to convert the LIDAR to TIN Surface. I then remove existing appearance and hook up the result along with the aerial image to the appearance setter transformer.What should I be using to get a neater output or is TIN the only way to go?Regards, Josh

Message: ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'LAYER NAME'. The error code from the server was '1000' and the message was: 'Arithmetic overflow error converting expression to data type nvarchar.

Hello everyoneI am currently working on a project where i have to create an ifc file from a CAD floor plan.in fact in order to do that i have some issues to solve, one of them is that i have to create gaps in walls for doors and windows, for that i thought of extruding the walls and doors twice using two extruders  to create solids and use CSGbuilder to create the gaps but it rejects them , so i thought of extruding the walls and doors only once to create surfaces and use the clipper , however the doors surfaces happen to fall next to the walls , and not precisely on them which lets the clipper fail at calculating the intersection , so i am wondering if there is a way to somehow project the surfaces (for example the doors on the walls) before using the clipper or maybe you have an entirely different idea for handling this problemThank you in advance.​​​

Hi allI need support please I’m not expert in sqlite db and I understood that there is a column called rowid I create a sqlite db but when I open this db in sqlreader I see that the values present in the rowid column start from 1 my reques is I need that the values present in the rowid colums must be equal to the values present in the Id column. thx for support  

Hi,I am trying to copy files within a work flow using the feature writer transformer. i dont want to use the writer as i want to carry on processing down stream of this action.in the filecopy writer i can set the destination folder as below. however i cant see out to populate the parameter's in the feature writer, or its not clear. Anyone else managed to get this working?Thanks,Andy  

Hi All,What the best way of reading multiple ArcPro GDBs saved within multiple subfolders? I have looked into the Creator + FeatureReader transformers but can’t get it to work, folder structure as follows:  I would like to read the multiple GDBs form the DATA level and force FME to go through the subfolders. 

Hi, I am trying to simplify .stl file that is a fme_surface.I am trying to get from this to this I have tried MeshSimpifier and Triangulator+MeshSimplifier but it failed 

I have used the 'filecopy' writer. The workbench works fine within FME desktop but when I run as a 'data stream' within FME server I get a message saying 'There was an Error'. See attached screenshot. I guess the question is, is it possible to 'data stream' a PDF. And if it is, should I be using a PDF writer?

Hi FME Community,I’ve been testing out an old script with FME Form 2023.0.0.1 and noticed one workspace with NeighbourFinder transformer has come to a halt with no clear message of warning or error. The same workspace works well with older FME Desktop Workbench 2022.1. Data size is around 50K rows, however it’s unclear at what progress/rows the halt would happened.I was suggested to upgrade to newer version, anyone encounter similar experience?Cheers,Noe

hello ,i have detected self intersection with geometry validator does it possible to convert the line that detected to straight line ? I do not need the triangle at image (I have detected the issue location with geometry validator ,but how could I remove the part unwanted that occurs it ) .thanks in advance Fme 2021

So I’ve worked with JSON in fme quite a lot, and I’ve even used the JSON syntax highlighting when trying to delve into it. What I did NOT realise though was that the JSON Syntax will automatically format the JSON for you - no need to use a JSONFormatter to help you read it.Probably this was know to others already but for me this was a nice surprise

I am trying to use attribute, which reprsents search path, to fill in the XML Path in Update section as shown in the screenshot below. But the update is failed. The original value for the element is gone.  From the translation log, I can see the following warnings. But I cannot figure out why it says about “end of file”.  Please can someone shine a light on the issue?Thanks.

I have been trying to create 4 feature datasets inside 1 file geodatabase using FME, but it looks like in FME there is no option to create an Esri feature dataset. When I have opened the feature writer, I don’t see an option to select feature dataset.I have a lot of shapefiles that I want to organize by province represented by the Esri Feature datasets and inside each feature dataset there will be points, lines, and polygons (it is not just one type of geometry).Do you know if that’s even possible in FME?

Hi, I wanted to very simply use a tester to select all records that had a date in the past week. I have tried everything but it does not seem to work.I have a date field in the correct format, I have also tried other formats via the date/time converter but it does not work. @DateTimeNow()-7 does not work.Anyone have any other suggestions? ThxNathalie

I am working with a workbench that was authored close to 15 years ago. We had to change out the SDE Readers that are pulling in our GIS features. Since changing the reader the text be written to the DGN is coming out in different sizes. I have checked the output in the inspector and although the text is visually different the idgs_text_size attribute is consistent. I have tried to override this with the DGN styler but there is something else going on. Any ideas on how to either assess or fix this would be greatly appreciated. 

Dear,I have a folder with 2208 xml files, approx. 30 GB. I read these files using a File Path Reader followed by an XML reader. From these files I select some features and save them locally. However, with my 16 GB RAM I run into memory issues. I already reduced the amount of data as much as possible within my workbench but still its not enough.Is there a method I read first 10 xml files – process them – save the outcome and go to the next 10 files, like a loop? My second question is whether it will safe memory in case I use a fanout expression or just write one final dataset with the results.My version is: FME 2023.2.1

I keep finding more and more areas where AI can enhance or simplify FME workflows. Just another example - we can ask the OpenAI API to give us expressions for RasterExpressionEvaluator and with the latest beta of FME 2024.1 (sorry, not publicly available yet), we can take the expressions from attributes. We can, for example, color a DEM by elevation. Do you want to see what AI can write for us? This is one of three expressions needed for coloring of multiple elevation intervals of the DEM. Good luck finding errors 🤣:if(A[0] <= 110, if(A[0] <= 22, 0, if(A[0] <= 44, 29, if(A[0] <= 66, 58, if(A[0] <= 88, 87, 116)))), if(A[0] <= 332, if(A[0] <= 154, 144, if(A[0] <= 220, 173, if(A[0] <= 276, 202, if(A[0] <= 332, 231, 255)))), if(A[0] <= 554, if(A[0] <= 388, 238, if(A[0] <= 442, 209, if(A[0] <= 498, 180, if(A[0] <= 554, 151, 122)))), if(A[0] <= 776, if(A[0] <= 610, 255, if(A[0] <= 664, 226, if(A[0] <= 720, 197, if(A[0] <= 776, 168,

I'm migrating records from one Salesforce org to another org using FME Form. But during the translation, some of my records are passed and some are failed. Though some of the records are failed to migrate, it shows a successful translation message in translation log window. I know the number of records that are passed and failed. But the problem I'm dealing is occurring while sending email. I want to send the number of total records, passed records, failed records and along with the failed records it should also show the error that why those records failed to migrate. How can I show this information in email?

Has anyone been able to mine Oracle redo logs using logminer? I’m beginner to Oracle but it seems to me that it should be possible. I’m trying to create cdc process from Oracle to postgres and I’m able to query insert and update operations sufficiently enough from date fields that tell me when rows are updated or inserted. However, I can’t catch delete operations that way and it would be beneficial to be able to read the redo logs for the actual operations. I know I can query and compare id’s from source and target to detect deleted rows. However, this is time consuming because that would mean querying hundreds of millions of rows for the workflow.If I understood correctly, I need to setup DBMS_LOGMNR package and session for the logminer to be able to query V$LOGMNR_CONTENTS that would hold the transaction information. I guess DBMS_LOGMNR is part of Oracle database? Would that mean that I need Oracle database installed with license to be able to use logminer? The source Oracle database

Hello,I have encountered a problem, and I hope someone can provide guidance. I need to extract segments of a gable roof. I have attached a picture that illustrates my input data, which consists of polygons indicating the gable roof among other roofs in a digital orthophoto.I have utilized the CenterLineReplacer tool, which yielded satisfactory outcomes in most cases. However, I am experiencing difficulties in situations depicted in the image below (the line should be in a different direction): Does anyone have any ideas on how to solve this?Thank you in advance for your assistance.

Hi FME people,When creating a reader or writer, our typical procedure involves selecting an SDE database connection, such as SDE.EDIT.R. Following this selection, we establish a link to a deployment parameter, assigning it a local value. In this scenario, the local value corresponds to the database connection SDE.EDIT.R.    This works well, except when we try ‘view source data’ or ‘view written data.  The connection is set to the deployment parameter but the local value is not used instead.Anyone who is experiencing the same thing? We use:FME Form: 2023.2.2FME Flow: 2023.2.2Thanks a lot,Francis

The WSG transformer gets following error when I try to upload files to Projectwise: ProjectWiseWSGConnector: Uploading file "testfile.shp" to Bentley ProjectWisePython Exception <AttributeError>: 'NoneType' object has no attribute 'encode'Traceback (most recent call last):  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 227, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 1129, in _handleException  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 200, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 467, in _doUpload  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 511, in _uploadFile  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 320, in uploadData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 282, in _uploadNewData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 233, in _upl