General

Hello everyone, I have an Excel list with many first and last names. For the next process step I need the gender of the person. My idea here was to establish a new attribute (salutation) and fill it with the appropriate form of salutation (Sir or madam). Is this possible with FME? Thank you very much for your support.

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

Hi everyone,I'm new to Smallworld and FME working together. The only thing I'd like to achieve to update one attribute, not the geometry. I set fme_db_operation = UPDATE and I didn't give any geometry information. After running workspace i could see a few records being updated but translation failed with this message: Number of Features: 1Connecting to Smallworld on localhost:30000 using service FMENOFACTORYTable: 'gis.point_of_interest'NumberOfAttributes: 16Processing a pointError running translation. Do you have any idea why this happens? Many thanks

Hello, Does anyone know of a way to use the HTTP Caller or another Reader/Transformer to download the entire contents of a Google Drive folder? There is a Drive folder (not owned by me) that hosts folders of shapefile data (link below). Does anyone know how to possibly download these folders in zip format so I can then process them as shapefiles in FME? I can download the whole folder directly in Google Drive, but I'd like to have this done automatically so I can schedule this workflow to run once a month. Any help is greatly appreciated. https://drive.google.com/drive/folders/1KLb-8DcrXkVFW8b2OmbOnEEueQNSUS5Y

I have an attribute (ID) contains ID 183849fjlr-kfklf373789-hdlldfo398383-jjdfj087734 and sort attribute contains sort 0-1-2-3 I would like to convert them to be  Target ID. Target sort 183849fjlr 0kfklf373789 1hdlldfo398383 2jjdfj087734 3 fme 2021 thanks in advance          

Hi, I am a master scholar conducting a study on BIM and GIS. I am also new to using FME and don't have a background in computer science. My question is, what is the difference between the attributes in a table and the hidden attributes in properties? Why are they hidden, and why is it necessary to expose them using the Transform Attribute Exposer (not Automatic Exposer)? Additionally, what are trails? I'm somewhat confused about understanding these terms.Another question regarding geometry, from my readings, geometry can be created through BREP, Extruded, and Sweep methods. How is this determined in FME, as I only see IFMEMesh, IFMEFace, and so on?

I want to set the vector tolerance value in the Matcher with a dynamic value. Currently, I can use a parameter value only. Is it possible to use an attribute value for this, or how can I set this value more dynamically? I have been trying also to create a custom transformer with the matcher in it. However, I got the same issue.

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

Hello , i would like to design pdf that contains many tables look like excel file and these tables will filled in with some attribute names and some values  Fme 2021     

In the Feature Inspector, you can see the Geometry and the Contents. The Contents section includes the Property and Data Type columns. Where is Values column? How do get I the Property values to display?

I'm testing Geocoder transoform. It works well with ArcGIS Online. With OSM I have this error: Geocoder_2_CALLER: HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Max retries exceeded with url: /?format=json&q=Strada+Villa+17%2C+37010+Cavaion+Veronese%2C+Italy (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTI... I use FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64) for ArcGIS (Data Interoperability extension).

Using FME workbench 2023.0, I am trying to make updates to some rows in a PostgreSQL table by using the FeatureWriter transformer that takes a csv as the updated dataset as input. However, I am unable to fully run the workbench as it takes an incredible amount of time to run, with the warning message: "POSTGRES Writer: Bulk Insert is set to Yes, but a conflicting Feature Operation has been detected. Feature type 'ela_master.lim_watr_chem_anal_arbi' has a Feature Operation of 'Update'. Bulk Insert is now being set to No, which can cause insert operations to be much slower" I have made updates to the exact same table using the exact same FeatureWriter transformer parameters before with no problem... and this is a new issue I'm encountering, and quite frankly I have no idea how to solve it. Can someone please tell me how I can fix this? Thanks.

In a way through shell script I should be able to dynamically send the criteria that we apply in tester transformer for filtering the input data. How to do it.

I am trying to get all the unique values from each field in a dataset. I would like to be able to expose the field name into each record, so I have an output table that looks like this:  I can run a statistics calculator to get the unique values, but the only way I have managed to expose the field name is by using an attribute exploder. This seems a bit messy because it outputs a whole bunch of combinations I am not interested in.  In the attribute manager, using @Value(fieldName) will return the actual value rather than the field name itself - are there any tricks using string expressions etc. to expose the actual field name? Seems like a simple thing to do but may be better handled in python. Just wanting to know if it's possible in FME! Would be really handy.

Hello i would like to use the output from one workspace as input in other workspace .the first workspace has 5 output that I would like to use them as input at second workspace. How could I achieve it ? thanks in advance FME 2021

Hi, Is there a way that I can read only point layer type from gdb without reading the full content first and then making selection? Read particular geometry type form gdb

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. 

uninstalling prevous version is not going, does anyone have a solution?

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 

Trying to convert data to XLS where each layer is a separate sheet. I was able to do this in FME desktop but unable as FME Form. Is there something special I need to do with FME Form?

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!

Hi All, I have put a workbench together to populate some GIS metadata but I need to have the <CreateTime> automatically populate every time I run the workbench, below an example of the XMLTemplater transformer settings:Currently the time if fixed as 00:00:000, How can I set it as variable parameter ? I have tried the ROOT Template Functions but didn't work. Any advise more than welcome :)Thanks 

Hi, I would like to read all the layers published to Esri Portal/Enterprise that are shared with particular group. I use Esri ArcGIS Portal Feature ServiceIn the Parameters I would like to change the Feature Service so instead of reading one layer will read all layers from that group; A9 WTC in this case

I have created a workspace which takes multiple zipfiles as a user parameter and reads them with a FeatureReader containing an Directory and File Pathnames Format. If I run this workspace in FME Desktop 2021.2 it works fine.My next step is publishing it to FME Server 2021.2 and starting it there.I add the same files to the user parameter and request the workspace to run.It starts like it should and gets the filenames as parameters but then it gets weird. FME Server seems not able to process the parameter it created itself.On the FeatureReader it gives an error which tells me the FeatureReader (QueryFactory): The clause '@EvaluateExpression(... is in correct.I asked several colleagues and searched the internet on this specific error but  I can't find anything that looks like this. So did anyone ever run into this error and does one know how to fix it? The complete error (without the file paths which are formatted like "D:/ProgramData/Safe Software/FME Server///resources/system/temp/uplo

Hello,Can I use the same FeatureWriter transformer to write lines and polygons into the same GDB? I know how to do it in a normal writer but can't get it to work with the FeatureWriter. Below an example of the workbench which filter the geometry by areas and lines and then go into two different ports in the transformer Below an example of the FeatureWriter settings where I have included two feature types (polygon and lines)  Do I need to set a Dynamic Schema Definition? I have tried that option with 'Schema From Schema Feature' option but failed, Any idea more than welcome, thanks! :)