Best Answers

I have 200 files. Their names have spaces. I want to replace these spaces in each file name with a dash. What is the best way to do this. I know I start with the pathnames reader. But, what is the next transformer(s) I need to add?

Hi, I need some help setting a basic test with the tester transformer. I'm trying to fail rows from a feature if they match any values in a csv file I've added as a reader. I'm having some issues getting things configured correctly. So something like NOT @Value(field) Contains <Right value>. But I can't seem to connect the right value. Connecting the csv as an input isn't what I want, but I cant figure out the syntax to use in conjunction with '$(SourceDataset_CSV2)'. Sorry for this basic question but I couldn't figure this out looking at the documentation. Thank you.

Hello, I wanted to continue my course when I realised that instead of eight completed modules there is only three. Howewer in the list of completed modules there is the correct number. It seems that there is no cenection between modules and the whole course. When I click to continue course it shows up an empty incomplete module next to the completed one.

I have a column that contains a lot of special characters. By using transformer 'StringReplacer', I can replace i.e. an '#' by an ' '; How can I replace a list of special characters of 10 or more characters. Do I need to use 10 StringReplacers?

attribute only display elevation in geometry ，who can tell me why​

Dear fellas,  Someone created an FME-workbench for me to input a DWG with lines, and output an DWG with all hatches.  However, when looking in the hatch properties in the generated DWG, this hasn't got an area. BUT, when I click once on a grabpoint, deselect, and select the hatch again, it DOES give me an area. Autocad tellls me the problem is within FME and there's no tricks in autocad to avoid this needed click. Because seems like Autocad doesn't realize the hatch exists, untill its clicked once, till then, the area is never calculated.  Any way to solve this problem? cause select something like a thousand hatches, click them, deselect, and select again takes a lot of time. generating all the boundaries at once isn't a solution because there's islands in the hatches.

How to create an exact copy of an column in FME? Which transformer?

I am trying to do vertical transformation using EsriReprojector, I have installed additional grid files from the FME downloads sections and pasted them into the installation folder. But I am not getting the desired result. Height is unaffected. I have read some other questions but not able to understand what should I provide in vertical transformation field. Right now it's set to None.

Hello – I am hoping someone can help. I asked a similar question previously and got a working solution: https://community.safe.com/s/question/0D5Dm00001GWvsMKAT/calculating-total-second-from-hhmmss-field However that solutions only works for hh:mm:ss fields that are under 24 hours as soon as that field is over the 24 hours I get a blank value. @DateTimeDiff(@Value(Duration),000000,seconds) Does anyone know of an alternative solution so it would calculate the total seconds for records under and above 24 hours? Many,Thanks

Here is my scenario: I need to very roughly georeference thousands of scanned air photos that are tracked in a file geodatabase. Oversimplifying things considerably, my fields look like: Filename (which contains location of the raster tif on disk)Center_X (map coordinate)Center_Y Rotation (always zero for my simple exercise)ground_resolution (in map coordinate units) I want to feed each "filename" to the rastergeoreferencer, using Center_X, Center_Y, rotation, and ground resolution. But I'm conceptually stuck... rastergeoreferencer obviously wants input from a raster reader, not a text string with the path to the raster. See the rub? Can somebody give me a push in the right direction? Thanks!!

Hey, so I'm looking at the download page here https://engage.safe.com/support/downloads/#official And I'm seeing tabs with "FME 2022.2" and "FME 2023.0" and "Past Versions". Is it fair to assume that FME 2023 is still in Beta? I think this page is pretty confusing now. I'm pretty sure this used to have a Beta section. Anyone visiting this page who wasn't familiar might just download FME2023 thinking it's ready for production... Checking the FME Cloud console I can see that FME 2023 is still listed as Beta anyone at Safe wanna fix the webpage? @andreaatsafe​ @nampreetatsafe​ @mark2atsafe​  

I have been getting this error a lot: Excel Writer: Failed to open the dataset 'FILEPATH\\FILENAME.xlsx'. Error message was 'No such file or directory.'XLSXW writer: An error has occurred. Check the logfile above for detailsExcel Writer: Dataset 'FILEPATH\\FILENAME.xlsx' contains no data and is therefore not a valid Excel file. No file will be createdXLSXW writer: An error has occurred. Check the logfile above for details It will happen a few times and then the workspace will run as normal. This occurs in any Workspace I use that has an Excel Writer. In the Task Manager, if there was a process I could end, I would do that. It still happens.  Any Ideas?Thanks,-Loren  

Hi guys a silly question here, is there a way i can expose the attributes before use dynamic schema to write them out? I'm using feature reader to read a list of sde feature class from csv file but hope i can expose their attributes for further processing before write to the destination.. Thanks!

Is there a method in FME, similar to ArcGIS Pro, for exporting a model to a Python file?

Hi all, we have just updated from FME Desktop 2021 to FME Form 2023.1.1.2. I want to create a mapping file .fme, but the option .fme is missing in the Save As- dropdown menu. Has this option been removed by Safe Software? Or has this functionality been transferred to another menu? Does a workaround exist? Thanks for your help!

I've seen lots of people over the community asking how to read AGOL attachments, but I'm curious to find out what FME users are doing with them once they've been read using FME.

Hi there, I have a workspace that fills out an excel spreadsheet and then pushes this into Sharepoint. I want to hide the first five columns in the spreadsheet (so I can unhide them when I need to check, but the user doesn't have to see it). How do I do that? I tried hiding them in the spreadsheet in Microsoft 365/Excel Online, but they revert to showing every time the process runs. I tried in the FeatureWriter Paramaters> Edit Column Formatting> Cell Protection> Hidden in the first five columns, but that didn't work.Thanks in advance for any guidance you can provide.

I want to create a PDF report like this , where i have HEADER and the value below   In this yellow boxes 'PDMS' column could go in this attribute values  this is my FME workflow to insert HEADER but , the values / attributes are coming from Excel output , so i need to insert them in this boxes like sum / average , total count etc. 

I need to split this polygon using as a reference the rows, how can I do this? These polygons are initially rows, which I transform into polygons using AreaBuilder. As a result it generates 2 polygons, however I need to fragment the polygon into more parts according to the rows.

I had an FME Cloud 2022.2 instance where I had uploaded a Python module and its dependencies to the python38 directory as that was the version of Python I had on local machine running FME Desktop. Everything worked as expected. When I replaced the instance with an FME Flow Hosed 2023.1.1 instance, the workspaces using the module continued working normally. However, I wanted to upgrade the module as I was using a pre-release version. My local machine is now running Python 3.10, so I uploaded the new version of the modules and its dependencies to the python310 directory on the instance and removed the files in python38. I have not been able to get the module to work in the python310. I have both removed and re-added engines and rebooted the instance. If I move the files into the python38 directory, the module is accessible. I noticed that even though the workspaces have Python capability set to 310, the workspace logs on the instance always say they are using Python 3.8. This make

Hello, I have a IFC which contains some 3D pipe (ifcFlowSegment), somehow it has about 70 face polygons, which makes it looks great but it creates some issue in the following workflow in ArcGIS Pro. I'm wondering if there's a way to generalise/ simplify pipe solid, for example by reducing the number of face polygons to half or something? Thank you. 

Hi I have upgrade FME Flow and FME Form to version 2023.1. S3 Connector v2.1.2 works fine in Form, but not on Flow.The Packages Folder was empty after new install. I ran a S3 Work Bench on the Server, it unpacked on engine, but all the folders are empty. Got the following error.59 2023-9-18 15:42:59 | Python Exception <ModuleNotFoundError>: No module named 'fmepy_amazons3'60 2023-9-18 15:42:59 | PythonFactory failed to load python symbol `fmepy_amazons3.connector.S3Connector'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date61 2023-9-18 15:42:59 | Factory proxy not initialized62 2023-9-18 15:42:59 | S3Connector_CALLER (PythonFactory): PythonFactory failed to process feature 

I am importing a project into FME Form that contains two automations, associated workspaces, and the repository for the workspaces. The repository for the workspaces already exists in the FME Form environment I'm importing into and it has other unrelated workspaces in it. The Preview Import page states that I will overwrite the exisiting repository during import. What, exactly, does "overwrite" mean? I only want to add the two new workspaces to the existing repository. Is that what happens? Or does the import process completely replace the repository, wiping out any existing workspaces and keeping just the two new ones? Something else? I'm trying to figure out if I should include the repository during import or not. I can't find any documentation that provides an answer. If anyone has one or can point me in the right direction I would greatly appreciate it!

My configuration in the JSONTemplater looks like this:  {  "type": "Feature",  "geometry": {    "type": "Point",    "coordinates": [      fme:get-attribute("X"),      fme:get-attribute("Y")    ]  },  "properties": {  "33064" : fme:get-attribute("33064"),  "33085" : fme:get-attribute("33085"),  "33103" : fme:get-attribute("33103")  }} As result I get: { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 7.61438690276304, 47.5603635244644 ] }, "properties" : { "33064" : "", "33085" : 94328460, "33103" : "2. von B Spezmast Nr.55" } } The number is not set in double quotes which results in error when I use the json string. Any ideas what could be the reason.

Hi;I created a very simplified version of my custom transformer.All it does is find the center point and define the layer name for the future dwg writer.Attached is a custom transformer and workbench example, where dwg writer creates a dwg file with point in the default layer that come from custom transformer.When I use the transformer in "linked" mode and start the entire workbench, I get an error.When I use it in "linked" mode but with the use of feature caching to the transformer, and then I only start the dwg writer with "run to this", then it's ok.When I use the transformer in "embedded" mode, everything works fine.The difference in the translation log is in line:"Using MultiWriter with keyword `PRIMARY_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')"in embedded mode and"Using MultiWriter with keyword `REDIRECTED_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')" in linked mode.Note tha