FME Form

I need help to make like something called monitoring directory.I have folder, its network based folder, and using FME form or FME Flow or both, i need to make next: Users will add CSV files in that folder, then that file or files will be add in postgreSql database.When users change file, it need to be changed in database too.When users add file , if the file with that name already exists in database  , it needs to be replaced with new one  

Hello, i am working on project and i need help.I want to copy multiple csv files from my pc, to postgreSql database.I have a folder on my computer and i want all files from that folder just to copy on postgre.I dont know how many files will be in  folder on pc, so i cannot predict, but they all have some column names sames, some diferent, and some of them even have diferent  number of columns  So basically, i have set up a reader in  FME workbench, in reader i selected which folder i want to read all csv files from, then reader is connected to schemaValidator , and that is connected on writer,  that wrriter should write in postgresqlMy problem is that, when i run that workspace , in my postgre database writer writes right names in right schema  with right data, but with columns from all files I need help, what can i do that if its exactly 5 files in folder that i read , that all 5 files in exactly how they are in folder to be copied on postgresql ? I have been try transformer FileCopy,

Hi all,I hope to get a few hints in the following issue.Issue - Unable to reproject the dataset into GDA2020 zone 56Dataset URL - The dataset is displayed in the form of WFSDataset Coordinate system - LL-GDA94Dataset EPSG - 4293I have used different transformers to place the dataset in the right location with no success.I think the issue lies in using the right transformers so any hints would be greatly appreciated.Thank you very much in advance,Sebastian.  

Hello Everyone, I wonder if folks might be able to help with troubleshooting ideas for a Scripted Selection that I am trying to put together. I am trying to dynamically read a SharePoint List using a web connection. When the sharepoint is read users get to choose from the list of records. I can get his working in Form but when published to Flow I do not get a dropdown[v] or list selector [...]. Am I missing a trigger or something? Thanks a bunch for reading.  

Hi all, Last year, I received my FME Certified Professional certificate.An achievement that I am proud of. I want to check if I am still the only FME Certified Professional at my place of work. The problem is: I can't find the Wall of Fame any more since the Safe Software rebranding. Does anyone know if the Wall of Fame still exists? Regards, Martin

I have a workbench that creates output for bentley Microstation. While trying to debug an issue of cells not appearing in the output, I found the VertexCreator deleting an attribute igds_type (microstation format attribute) in the processed features. Pictured is a basic configuration for reproducing the conditions.The version used is 2022.2. I have a simple workaround, but it did take a while to figure out what was going on.I wouldn’t have expected this transformer to touch the attributes at all. Is there a reason for this and does it affect any other attributes? 

Hello,I have GML file with polygons. Polygons are defined by coordinates inside LinearRing attribute. There are some other attributes, one of which is an ID of a polygon.I want to transform that GML to DXF format (only polygons and IDs (as texts) which have to be placed inside the polygons) and I have managed to do so, but I have a problem with some funny shaped polygons for which ID falls outside the polygon.What do I have to do to make sure those texts (IDs) in DXF are put inside corresponding polygons?Thanks in advance for any suggestions.Best regards! 

I'm looking for support with Navisworks (AutoDesk) BIM data (.nwd .nwf .nwc). I need to extract the full 6D information from the model and output it to other formats but also update the 6D information back to the model. Navisworks imports IFC but does not seem to export it. DWF, which can be written with Navisworks, does not hold the 6D information.Any help would be appreciated.

I'm having trouble writing sharepoint users to a sharepoint list. It does not seem to matter how I'm formatting the user string attribute - it just wont accept it. The writer is configured as uploaded workspace. The sharepoint list adds a new, empty row.   HOW do I configure the writer, and what is supposed to be the correct attribute value? To my understanding, the attribute value is to be formatted asi:0#.f|membership|name.name@domain.se

Hello,i have a citygml-dataset and try to convert it to cesium tiles. In a citygml-dataset, a building consists of different parts like roof, wall, …Within the conversion to cesium tiles, i want to “combine” the parts to one building, so that the building is clicklable as one unit in my cesium. Additionally, I want to extract parts of the adress out of citygml to user attributes, which are displayed in cesium with a click on the building.In FME, I already can merge all parts of a building to one set using a FeatureMerger in combination with the gml_parent_id. At the moment, I stuck in extracting the adress-information out of the xml-part of citygml_adress.Has anyone an idea how to manage this? Thanks in advance!Best regards.

Hello,Newbie to FME here, trying to create a simple script to move multiple pdf files all located in one folder to multiple folders which match the name of the folder. Tried using File Copy Writer but had no luck.

Hi ​@safe I attended the webinar yesterday and wanted to dive a little bit deeper in the AI Agents/transformers. Unfortunately you shared only the video and the slides to the webinar yesterday. Is it possible to get the workbenches and data as well?That would be a great help for a (AI-) beginner like me. Thanks in advance.Tom

Hi,I'm using the FTP trigger in FME server with a FTPES site but it doesn't work. It does work in a FTPCaller Transformer.  the logs in FME UI are not very useful (the logs here are shown in reversed timestamps): In the logs here : tail -f /opt/fmeserver/resources/logs/core/current/publishers/ftpwatch.logthere are some clues but I can't figure out why this is happening on server and not in the transformer : it.sauronsoftware.ftp4j.FTPException [code=503, message= SECURITY_FTPES cannot be applied: the server refused both AUTH TLS and AUTH SSL commands]    at it.sauronsoftware.ftp4j.FTPClient.login(FTPClient.java:1229)    at it.sauronsoftware.ftp4j.FTPClient.login(FTPClient.java:1186)    at COM.safe.fmeserver.relay.plugin.ftpwatch.FTPWatchPollingThread.loginToFTPServer(FTPWatchPollingThread.java:454)    at COM.safe.fmeserver.relay.plugin.ftpwatch.FTPWatchPollingThread.poll(FTPWatchPollingThread.java:139)    at COM.safe.fmeserver.relay.plugin.ftpwatch.FTPWatchPollingThread.run(FTPWatchPol

Hi all!I am relatively new to FME but I work with ArcGis Pro since a while now.I am trying to add an “Esri ArcGIS Server Feature Service” reader, which actually contains multiple map servers hosted online on the open government website (public data). When I try to add the reader in FME, I get absolutely no visual preview of the data, it does not open in my window and therefore cannot interact with the data. Even though I get multiple warning messages, my translation log seems to indicate that mapping file generation was successful…Can anyone help me? Has anyone already dealt with that kind of issue? Is it an issue with authentification and authorization?Do you have pertinent resources concerning ArcGis features services as reader in FME? Thank you!

 j'ai un fichier dgn contenant les câbles de type polyligne avec leurs extrémités. -je veux extraire les câbles et les convertire en shapefile (.shp) avec les noms des extrémités.??? 

In a file geodatabase, I have created over 400 feature classes. To each feature class, attributes will be added. Therefore I have created a workbench in which several tables are joined. An intermediate result is a table which contains a field called ‘Attribuut’. This column contains the names of all the target attributes, each row one attribute. This intermediate table also contains a field (‘Gegevenstype’) which describes how the future attribute is defined (field type). A simple ‘Attribute creator’ transformer does not do the job. I have read and tried several possible solutions on the FME-forum, but unfortunately without result. To understand how the process works, a tester is added to create a table for one specific feature class. When the process functions properly, a loop will be added to perform the job for all objecttypes.Can anyone help???

Using Data Interoperability in ArcGIS Pro - Is there a way to pass attribution from selected features in a map/table to the ETL tool?Edit--Use Scenario: A data editor using a map in ArcGIS PRO selects a feature or multiple features. The globalids of the selected features are then passed onto the ETL toolbox and subsequently, the FME workspace performs a translation with just the selected features.  

I am creating an AGOL to KML converter. I want all labels to be off when viewing in google earth, but I can not find how to disable point feature labels. These points are represented by icons. I have set the opacity to 0 using the KMLStyler and the setting for “Create Labels on Lines” is set to No (which successfully disables line labels), but the labels for point features still appear. There also appears to be no option to remove labels in the KMLPropertySetter.

I'm trying to extract DWG properties into FME, the equivalent of the DWGPROPS command in AutoCAD. I have added an example screenshot below. The aim is to use this information wthin a workbench on FME Server. I couldn't identify anything in the AutoCAD reader that shows these properties. Does anyone have any solutions that would expose these DWG properties in FME? Any help would be greatly appreciated!

Hi All,I wanted to dissolve (or merge) little slivers with the biggest adjacent polygon to harmonise my data, an example below where you can see the little slivers (selected): How can I achieve this with FME?Thanks :)

Hi,I have a workspace transforming data to write it in INSPIRE GML format (theme Hydrography). Earlier this year, some of the INSPIRE application schemas (XSDs) where upgraded to a new version Include changes from 2024.1 schema release · Issue #1027 · INSPIRE-MIF/helpdesk-validator, including the hy-p one that I’m using here (v4.0 to v5.0).Therefore I changed my INSPIRE GML writer to point to the new XSD URI and adapted the xsi:schemaLocation parameter consequently. However, when indicating the v5.0 the output GML is not written correctly: there are remnants of the v4.0 in it.First in the imports, see xmlns:hy-p4 and xmlns:hy4:<gml:FeatureCollection xmlns:omor="http://inspire.ec.europa.eu/schemas/omor/3.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sr="http://inspire.ec.europa.eu/schemas/sr/4.0" xmlns:base="http://inspire.ec.europa.eu/schemas/base/4.0" xmlns:gts="http://www.isotc211.org/2005/gts" xmlns:hy-n="http://inspire.ec.europa.eu/schemas/hy-n/4.0" xmlns:omop="

Hi,I read sdo_geometry and make a cutout of a small area. I want to save this cutout as a jpf file. Is that possible?I do see jpg writers, but I suspect that some preparation needs to be done before you can save geometry data as jpg.

As per ChatGPT, FME supports Draco compression and FME has a plugin 'Draco 3D Mesh Encoder/Decoder' in tools->plugins & transformers->dialogbox-> choose download tab->scroll down and will get the plugin. But even I am not able to see the option plugins & transformers in tools.So can anyone make me clear where to find it in FME Desktop, I am using latest version of FME. ThanksBasant Lal

Hi all - fairly new to FME here.I am trying to do a calculation using the ExpressionEvaluator to calculate tree protection zone (TPZ) estimate, and round to 2 decimal places. The formula I’m using is @round(@Value(average_dbh_value) * 0.12, 2) I also need to incorporate min and max values into the output. Min is 2 and Max is 15. This is where I’m getting stuck. Would someone be able to provide a suggestion on how I can possibly achieve this? ThanksLeanne

Hi all,I am using the Overwrite Existing Geodatabase/Template Geodatabase functionality:This creates a new copy of my gdb with a “_yyyymmdd” suffix. However, if my users run this multiple times a day, they have to delete the output of the previous run.I would prefer there to be a “_yyyymmdd_N” suffix, with N being incremented for every time the workspace has finished running that day.What is the sleekest way to implement this? I now have built something with a Path FeatureReader and a combination of Testers and StringConcatenators to filter out and manipulate the different filenames with either no suffix, a date suffix or a date+N suffix. Then FeatureJoiners to join the different path features into one:It works but its bulky and it feels overengineered.Any inputs? Kind regards,Joep