Best Answers

Hi ,Is there any way to use an ifc file containing ifc objects, extract a specific object , then put it in precise locations in another ifc file that I am creating in the workflow?for exemple if I am interested in using this ifcDoor object that is inside a file1.ifc file : and the positions where i want to put this ifcDoor are where the 2d doors (the red lines) of my input file are located (my input is a dwg file containg 2D doors):All I can do now is just extrude those 2d doors , add ifc attributes to them , and them write them to ifcDoor writer .  but they don't even look like doors :i want the doors to look like the ones in my file1.ifc file (their color , geometry , texture )I'm searching for a way to do it , but I am afraid that it is impossible .

Hi AllI am trying to set up a workspace to react when a change is made to an ESRI Enterprise Geodatabase table but cant figure out how to watch for changes on the table.I could set up a scheduled task to read all of the data and then a change detector to update a further table but that doesn't seem a wise use of resources, particular if there are no changes.SO any ideas how to watch this database table for changes efficiently??Regards   

Are there any free options out there to use an instance of FME Server (Flow) to be used only for Safe Software’s tutorials or training?

Our FME License server run on LMTools by Flexera doesn't read the option file safe.opt.The safe .log file gives the following log:xx:xx:xx (safe) CANNOT OPEN options file "="The safe.opt file is at the same location as the license safe.lic file. Rereading the license file doesn’t seem to work.I don’t see anywhere else in LMTools where you can configure this. Is their a command line tool with lmutil or lmgrd that adds the option file to the license server config?  

Hello FME community, I have a workspace which I always run with quick translator. Since my user parameters are never going to be changed, is there a way that I can simply double-click on this file and it runs with quick translator without the need to click OK or press Enter to confirm the user parameters? 

Hi,I have data from the WFS address, for parcels of land. I need to perform an additional check in which it will be checked if some of parcels are not duplicated. That is, I need to detect if there are two polygons, one on top of the other, in my layer in WFS in one place. Please give me some suggestions.

I have two Excel Files. You can see from the screenshot, in the Visual Preview, I need to compare 95137 and 95138 in a Tester. Before I can do this, I need to “move” 95137 to row 1 (highlighted in yellow in the screenshot below) and have only one row in the table not two, what is the best way to make this happen?   

Hello!Here is my problem:I have a SDE db (let’s call it T1) with field “date_change” (type: date). I also have a table (let’s call it T2) that has a filed “sync_date” (type: date).I am trying to make a query where I select all features from T1 where “date_change” is equal or greater than T2 “sync_date”. I am using a FeatureReader and trying to apply it on the where clause. However, my query keeps coming blank. I think the syntax is wrong (WHERE clause: “date_change” >= “sync_date”). Anyone has any suggestions?Thank you in advance!

Hello all,I am trying to build a PythonCaller that replicates the Windows command of “Send to Compressed (zipped) folder”The goal is to prepare a fileGDB dataset for transfer by ftp by zipping itI want to give the PythonCaller a filePath such as D:\2024\03\project\data.gdbWhich then creates a zip file D:\2024\03\project\data.gdb.zip (that is, the zip file is sitting in the same folder as the data.gdb)And, when the end user opens the zip file they see the folder data.gdb which they can then extractI am trying using this code    def input(self, feature):        import os, shutil        folder = feature.getAttribute('folder')        fileGDB = feature.getAttribute('fileGDB')        zip_file = feature.getAttribute('zip_file')        if os.path.exists(fileGDB):            print('fileGDB exists')            if os.path.exists(zip_file):                os.remove(zip_file)            else:                print('zip file DOES NOT exist')            shutil.make_archive(fileGDB, 'zip', folder)     

Good morning,  I'm currently facing a really weird issue. In my workbench I have a Reader that is loading a quite large Excel file, containing multiple tabs. I decided to remove all the unwanted data from the Excel sheet and keep only the tab I really need.  When I try to update the Reader feature types the Excel tabs that I just removed keep showing! I have tried adding this Excel sheet to a new workbench; same result.  What I've tried so far: - Adding the Reader to a new workbench in 2018.1 and 2019 beta. - Purged temporary files in FME. - Restarting FME / computer - Ran Windows disk cleanupNothing helped, I'm still seeing the tabs I deleted.   Cheers, Ed

I thought I knew how to do this but it broke for some reason. My workspace has a GDB that contains a feature dataset that has domains assigned to a few of the feature classes and it also has topology. I set up a simple transformer to sort and do an area calc. Then, I need to write back to that same GDB while keeping the domains. I recently lost the domains assignment and when I tried to update the workbench now it fails to write anything. I've tried multiple methods and each has a failure like 'cannot delete layer that has topology' or 'cannot make edits out of an edit session'. How should I set up my writer? I'm not sure I want to overwrite existing if I can help it.

Hello all! Relatively newbie here.I think my question is simple but I am just struggling with finding a query for it. I have a table in an SDE. An example of the structure:object_id        job_id          update_start                               status1                     xxx              2/15/2024 13:00:00                  Success2                     xxx              2/20/2024 13:00:00                  Success3                     xxx              2/25/2024 13:00:00                  Fail I am using a FeatureReader to read this table and I need to extract the most recent succesful run from this table (i.e. in this case only row 2). I am using the where clause but it keeps returning me blank and I ran out of ideas. Any help is appreciated!Regards,

I am trying to post an AGOL attachment (i.e. an image) to a Cityworks Work order using the HTTP caller. My goal is to post a unique image to a unique work order (i.e. an image of a sidewalk crack for a sidewalk work order, a pothole image for a pothole work order etc.). The issue starts with my file. I am using AttributeFileWritter to write the file. I use a variable from the feature layer to name my output file (i.e. @Value(WorkorderID).jpeg). This writes to my output directory with no issues. When I go to try and upload this file, when I feed it the PATH + file name + file extension it results in an error “HTTP/FTP Transfer: Failed to open file for resource upload”.  When I explicitly “Select” the file it will upload without issues.  My workflow is as followsI write the image file  I make the callMy body call This body call is what throws the error. When I add the variable name with extension for the file I want it to upload, it results in the following error “HTTP/FTP Transfer: Fail

Hi All,Fairly new to FME, and brand spanking new to Rest APIs.i have an API integration that i worked out in Postman, but, i’m struggling to translate that to FME workbench for use in an FME Server Automation.In postman, i have to use a GET to generate an antiforgery token, then use a POST to log in, a second GET to update the antiforgery token and then a second POST to send the actual content i want to .. uh.. send.now, in Postman, my request looks like:GET {{DeskAlertsURL}}api/xsrf/getwith the following auto generated headers:Cookie:Host:User-Agent:Accept:Accept-Encoding:Connection:and the actual request headers look like (i {{shortened}} some of them for readability):GET https://URL/DeskAlerts11/api/xsrf/getRequest HeadersUser-Agent: PostmanRuntime/7.36.0Accept: */*Postman-Token: acbb9ca8-9dc2-44b1-888e-63468a39523fHost: deskalerts.ipf.msu.eduAccept-Encoding: gzip, deflate, brConnection: keep-aliveCookie: .AspNetCore.Antiforgery.awpUR7lE5Fk={{Shortened}}; XSRF-TOKEN={{X-XSRF-TOKEN B

Hi FME community,I am currently developing a validation script to compare two datasets derived from different versions of the same model, exported as .csv files from Navisworks.The script aims to ensure that the values for Translation X, Y, Z, and Rotation Axis X, Y, Z remain consistent across each version of the model. For instance, the .dwg file "PBD-ALG-SITE-EQP-ACD.dwg" from 27/02/2024 should exhibit identical translation and rotation values when compared to the version from 06/03/2024.Upon confirming that all values are consistent across different versions, the script will assign a "Pass" status, or “Fail” if a value is inconsistent.I'm seeking guidance on the most effective method to achieve this.Cheers.  

Hi,I have a SQLExecutor with a dynamic SQL Server query like:SELECT * FROM value(@table_name)Obviously, as it is a dynamic query I don't expose any attribute.Then, I connect the schema and generic outputs to a featureWriter (CSV).When I run the workspace, It finish suscessfully but It doesn't generate the CSV file.The same problem if I try to generate the CSV file with a dynamic writer instead of a featurWriter.However, if I replace the SQL Executor with a dynamic featureReader, the CSV is generate correctly.I need a SQL Executor because the query will be a bit more complex.I think It is something related with schema but I missing something.Could anyone help? Thank you un advance! Regards. 

Hi all, I have a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB).Example: I will convert this tiff into a three channel (RGB) tiff.Is this possible with FME? thanks in advance!

Hi All, I’m struggling to explode/conver the fme_aggregate to fme_polgon. I have already used 2DForcer and GeometryCoercer already, settings in the screenshot below:This comes from a DWG file and I need to create the outline boundary as AOI,Any ideas?

I have a dataset of features that I'm trying to insert in a Postgres (pg14) database. That data has a number of text columns that together make up a "report name" plus a timestamp. The name and timestamp together make up the primary key of that dataset. There are also some more columns that contain the actual data. The table I'm inserting this in currently has 800 million rows, and I'm inserting in batches of around 50k rows about a hundred times a day, so keeping indexes small is important. Given the above situation, the text columns from the "report name" have been put into a separate "dataset_reports" table" (~60k rows); with the timestamp and actual data being stored separately (with a foreign index) in their own heavily partitionned "dataset_reports_data" (~800M rows) table. In order to insert data in that table, I need to upsert dataset_reports with all the unique report names in my feature set in a first pass, then get the FK value for all these reports and then I can insert the

Hi Community, I am using some SQLExecutors in my workbench and the this is taking so much time to execute. Is there any way I can execute it faster. Is it because the statement going from fme to outside db and execute it in batches of 1000 and commits the edits making the whole delay?. Is it possible to execute the whole sql actions using a plsql script and bind it to fme?. I may also need to have logs or exception tables for plsql script. Is it possible through fme?

Hello! I have recently started working with FME Flow. I’m just testing the possibilities of writing to the Fme flow temporary resource directory, which causes the translation to fail immediatly. My script is just a reader, which in this case is reading from a shapefile, as well as a feature writer. The featurewriter is set to write to [FME_SHAREDRESOURCE_TEMP] and the response i’m getting when running the workspace is this:  Has anyone encountered this before, and is there any hope for me and my workspaces in FME flow? Thanks!/Alex

We have FME 2022 with floating lic, with 2 editions, Database, and ESRI.   Would like to install FME Form 2024.0 along side FME 2022.  I know at some point Safe did away with Lic Editions, any idea if we can use the same  FME 2022 lic file and make it also work for FME Form 2024 ?  .

I have a workspace in FME Form 2021. It includes an Automation Writer. This writer writes keys from FME Form to my Automation in FME Flow 2021,  Given this is the 1st time I have pushed FME Attributes into an Automation as Keys, just being curious, I clicked on the “View Written Data” icon in the Automation Writer. It gave some errors and a new windows opened with red in the parameter boxes. It would seem wise to disable this icon when a Automation Writer is chosen. Are there any plans to do this? This does not impact my workspace or Automation. It just seems a bit annoying, unless I am missing something? See my screenshots for a better illustration of what I see happening:  

Hi everyone. I am reading data from an Esri Geodatabase. I have an issue with the Shape area reading as negative values. I have tried the geometry validator with Area Orientation set to “right” as with “Allow Left” and “Check doughnuts only” does not deliver any repair results. After the feometry validation, my repaired results still contain the negative area values. Negative values after geometry validatorIs there another way of solving this, I know the issue can be resolved in ArcMap wit geometry repair is there a similar way of doing this with FME?

 Hi, I am having an issue with feature readers and XML. I have a process which downloads an XML file from an ftp site, and the file name changes daily.  Upon download, I am trying to trigger a second process which reads the downloaded xml, so I can then split it into separate records (hence why reading in as text will not work, as I need the xml fragments). I use a path reader, to get the file name, but when I put ‘Path_Windows’ as the dataset, i get this error: error message  If I choose to ignore the message, and run to the featurereader, It reads in the correct amount of records (59), but the schema is blank. Blank Schema Log Error message   Now, i know for a fact that my xml does in fact, have a schema, because if I hard code the file name in the feature reader, it works perfectly fine. (see below)   FeatureReader with hard coded file nameSuccessfully read The parameters are identical on both.  FeatureReader Parameters  I am at a total loss as to why when I want to put in a dynamic