A space to discuss FME Form
Recently active
I'm fairly new to IFC and the PythonCaller transformer.I have an IFCReader and want to use PythonCaller to convert an IFC file into an Esri file geodatabase using arcpy, allowing me to upload a scene layer package. Any tips on how to get started?
how can i turn this in FME???? login and get cookie: curl -k -i -X POST -d j_username=xxx -d j_password=xx -c cookies.txt https://<host>/Webcontrols/xmlsql login with cookie: curl -k -i -X POST -d j_username=xxx -d j_password=xx -b cookies.txt https://<host>/Webcontrols/j_security_check echo "Get data from iprotect"query results to get data:curl -k -X POST -d @$base_dir/sql/acceskey.xml -b cookies.txt https://<host>/Webcontrols/xmlsql --output acceskey_iprotect.xmlin the acceskey.xml is an xml format query select * from <table>output gives the data in xml format
Hi,Could anyone please guide me on how to preserve the domain as it is when a feature class with domain for multiple fields is read using SDE reader, and then when it is written to a SDE Writer.When i look at the fields of the output feature class, the domain is empty. How can i overcome this?
Hello, I use a custom transformation in the ArcGIS platform. It is a two step projection which uses the Ontario NAD83 grid file to project to NAD83 CSRS and then the second step is projecting from NAD83 CSRS to WGS84 geographic (LL). The two tranformations are:ON_NAD83_NAD83CSRS_CustomTranf, (custom transformation set up in ESRI)NAD_1983_CSRS_To_WGS_1984_2 (chosen ESRI transformation).This two step process was recommended by ESRI Canada to import data into their ArcGIS Online format. I have seen various articles for parts of this process in the FME Community but I guess I am looking for a stepwise list (e.g. obtain grid shift file from authority, create custom transformation in ESRI, etc.) to get the pieces of the puzzle in the right location to use in an FME workflow.Thanks
Hi. I’ve built a data cleaning workspace that performs a number of different tests, creating or retaining different attributes for each. I’ve created an ‘error type’ attribute to fan out by, have added schema scanners and have followed the gist of this. However, I cannot seem to get the writer to respect the varying schemas for each tab. Set up like this: Pointers appreciated. Many thanks
Hi everyone,I am working with a large dataset (over 500,000 records) stored in PostGIS, which I am reading into FME and writing to ArcGIS Online (AGOL). My goal is to automate this process by publishing the FME Workbench to FME Flow, so the AGOL feature service updates every few hours.When I overwrite the data, the Workbench runs without any issues. However, I want to truncate the existing data instead of overwriting it. When I attempt to do this, I encounter the following error:413 Client Error: Request Entity Too LargeOccasionally, I receive other request size-related errors as well. I tried adjusting the Features Per Request parameter to 500, but the issue persists.I’d like to ask if anyone has experienced this issue before and what possible solutions or workarounds exist to efficiently truncate and update the AGOL feature service without running into request size limitations.Any insights or recommendations would be greatly appreciated!Thanks in advance.
Hello,So I have been trying to INSERT a ‘0’ value date using a FeatureWriter with MariaDB/MySQL compatible format into our MySQL DB, but I can’t seem to be able to do it. I keep getting the message the row is skipped because an “Invalid date/time value”.I have tried using many different values for the ‘0’ date like ‘0000-00-00’ , ‘00000000’ with and without the single quotes but I keep getting the same behavior. I’ve also tried using different types of fields (varchar, date, datetime) in FME (but always keeping datetime in the DB) and still the same.I tried using 00010101 and that one was accepted and it did actually loaded into the DB without problems. In the DB the field is Nullable and also accepts cero values, but I can’t seem to get it to work from FME.Any ideas?.Thanks in advance.RZ.-
Hi All,I am attempting to walk an FME script (using desktop 32 bit) over a large folder of specialised access databases called gINT files (.gpj) and move the data to various CSVs. However it will terminate after several hours with "MDB_ADO reader: An unknown exception occurred", and only write several of the CSVs for the files it has read. It works for smaller sample sets, so I don't believe it is a flaw in the script.I have a copy of the log, unfortunately it is a bit large to attach. Any help appreciated.Thanks-Jack Collins
Hello, I have seen similar threads but i cannot seem to get what i need to work. New to FME and I have a .img file with 1440 bands. Trying to rename the bands to dates as each band is a dataset a month apart. I have an excel spreadsheet with the original band names and the new names i want but after a lot of trying have not been successful. Please could I have some help with this. thank you
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???