Best Answers

I have a very simple workspace that just tests whether a string has a “.” Or a “:’ in it and if it does then these characters are deleted. I am using the Testfilter to test for the characters, and then a stringreplacer to delete them and then I must make sure the string is all caps. Is there a way to do these three operations by using the String Functions in the Testfilter? I haven’t been able to figure out how the string functions work. Also, will using the string functions speed up the translation? I have 47 million records to test and right now it takes 4 hours to run. I am using FME2018. I have included the workspace and source CSV file. Thanks.

I have a simple PythonCaller (for now) which basically is something like thisimport fmeimport fmeobjectsimport arcpy class FeatureProcessor(object):    def __init__(self):        """Base constructor for class members."""        pass     def input(self, feature):                geom = ["Point", "Multipoint", "Polyline", "Polygon","Envelope"]        for geo in geom:          print(geo)          self.pyoutput(feature)     def close(self):        pass     def process_group(self):        passCan you please let me know 1- Pass the Result of Python  from PythonCaller to User Parameter Choices   2- How to Pass selected values from here to second PythonCaller2 to only simply print out the selected choice? I tried to make it as simple as possible and sorry for confusion! 

May I ask what is the default password for fmeserver database?

I am converting ESRI gdb tables to Josn format(text_line), but unfortunately few of attribute values are given extra/unnecessary precision?data from tables : "aos" : 105.20 ,"aos" : 293.22 output generated : "aos" : 105.20999999999999, "aos" : 293.22000000000003To avoid this I have used attribute rounder , but no use, client required only 2 digits after (it should be float) . could some one help to resolve this issue on this.I have used the below transformers gdb readerattribute manager and attribute rounderJosn templaterText file writer (text_line)Thanks in advanceChandra Sekhar Guda  

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.