FME Form

I am asking this question on behalf of my colleagues. My colleagues are facing a problem that they are running a .fmw script at different times of the day. Sometimes this script takes 1 hr and another time this same script takes 2-3 hours. Other applications are also quite slow, so it's probably wise to look at connectivity/databases issues and the likelihood that the problem lies on FME Desktop is probably to a lesser extent or nonexistant. However it could still be a combination of different factors that influence the different runtimes in FME Desktop. So I would like to get a rough idea if there are maybe some issues in FME Desktop that might influence the different runtimes. I was thus wondering if others face different runtimes in FME Desktop as well and might have some ideas about the reasons. One colleague opted some ideas that might impact the different runtimes and I was wondering whether you could stand behind those ideas. Query in SQL databasesTransformers in FME Desktop

Hello, Could someone tell me how, from a PythonCaller calling a dropdown list via the PyQt5 module, to use the selected string (in the example below, the "select" variable) in the list to fill in a feature attribute and then leave the dialog box once the choice is made?# coding: utf-8from PyQt5.QtWidgets import QApplication, QWidget , QComboBoximport sys     def actionSelect():    select = qcombo.currentText()    print("Selected street : " + select)    app = QApplication(sys.argv)root = QWidget()root.setWindowTitle("Street Selected")root.setGeometry(100 , 100 , 500 , 300) # création de la liste QComboboxqcombo = QComboBox(root)qcombo.setGeometry(100 , 10 , 150 , 30)qcombo.activated.connect(actionSelect)# création de la liste des itemsL = ["Street A, City A" , "Street B, City B" , "Street C, City C"]# ajout des items à la liste QComboboxqcombo.addItems(["Street A, City A" , "Street B, City B" , "Street C, City C"])root.show()sys.exit(app.exec_())For example, in the example below:Give th

Hi, I have some field (ID), but the values sometimes have one, two, three...digits. There is one attribute with number of the digits that previous may have. For example the value (ID) is 10 and the number of digits may have 5, so the value is 00010. If the value (ID) is 1555, the value become 01555. How to put 0 in the left to complete the digits of fields? How do that? Thank´s 

Hello everyone I have coordinate values in xml data. I want to generate points from these values. I tried some methods but failed. Can you help me?

i have two input tables and i am trying to find all matches that start with attribute 'partial' from the first inputin the attribute 'TAG_ID' from the second inputso i converted all 'TAG_ID' to a list 'tag_list{}.TAG_ID' but when i tried to iterate to do so the error'NoneType' object is not iterableappear to mehere's my code        s = str(feature.getAttribute('partial'))        d =feature.getAttribute('tag_list{}.TAG_ID')        matches = [i for i in d if s in i]  

Hello , i would like to use Regex to find three cases :1.the string that starts with one letter then numbers as example a73939 or s9392.and also to find string like S2820_hjd(one letter then few numbers then underscore then numbers or letters )3.and any string that start with one letter then underscore as O_Sjdld i tried using string searcher transformer but I am not sure which regex should I type ? fme 2021 thanks for help  

Hello , is there a way to find the layers name that has only attribute names but all attributes name has completely no data inside it source data :oracle non spatial FME 2021 Thanks in advance

Hi. I have a change detector. If the folder have some change i have a system Caller to open a txt files. But the system caller open 13 times. I want the system caller opening only one time. Can you help me. Thank

I have a CAD file that I want to convert to CityGML LOD2 with Xlink using a provided template. To automatically generate unique surface IDs using SurfID_@UUID(), I need to first deagregate the CAD file into individual surfaces. If I don't do this, I get errors about non-unique IDs. However, separating the surfaces in this way causes the roof, walls, and ground surfaces of the building to be split into multiple surfaces and IDs. I would prefer to have each incoming surface represented by a single GML ID, but I've tried several options and haven't been successful. I'm not sure if I'm missing something or if there's another approach I could try. Could anyone please be so kind take a look to the tample and smaple CAD file.

I have a list of files name and i'd like to use files from folder to generate DEM.

I'm using template file (geopackage) from one feature of the dataset to set the datastructure in FeatureWriter. FeatureWriter zips geopackages in dataset parameter like this: $(FME_SHAREDRESOURCE_TEMP)/Folder/FeatureTypeName_@Value(attribute).zip/FeatureTypeName_@Value(attribute).gpkg. Zip-files are then uploaded to S3 bucket using S3Connector. It's working great but it seems that the extent of the template file is used for all geopackage/zip-files. Is there a way to not get the extent from template file but rather from actual features to get correct extent for each geopackage? I noticed the error when usign "zoom to extent" in QGIS. And if not, is there way to update the extents of geopackage/zip -files already in S3 bucket, preferably by not dowloading all of them locally first.

Hi all, I have a current workspace that calculates a single least cost route using the ShortestPathFinder to minimise an attribute on a network. I came across this article on ArcGIS online (https://www.esri.com/arcgis-blog/products/arcgis-pro/analytics/create-a-wildlife-corridor-with-the-new-least-cost-corridor-tool-in-arcgis-pro/), and i feel it would be a great addition to my workspace. Is there any way I could re-create this type of output in FME? Thanks,Jack

I want to run multiple workbenches in a sequential order based on the success and failure of previous workbenches. I only have access to FME Desktop (No server) so I used 'WorkspaceRunner'. I created 3 workbenches (all three with basic tasks to open an excel workbook and Add/Subtract/Multiply values in column A with values in column B then add the results into a new sheet of the same workbook). Only issue is the flow runs through until the end and gives me 'Translation was SUCCESSFUL' even though one of the them fails to run, I tried using 'Tester' with different values but nothing useful. Thanks in advance for any suggestions.

I have created an FME job and I want to run it from task scheduler. So I created the .BAT file (and .TCL file) by running the Run Batch Deploy process. Once the .BAT file is created I test it by double clicking it. The .BAT seems to start up fine (I check the log file and see it is running). So then I try and use task scheduler to run the same .bat and get an error from FME saying : ERROR |Unable to perform any licensing related tasks. This 64-bit version of FME requires 64-bit Background Geoprocessing, ArcGIS ProArcGIS Pro is installed and I am able to run the job fine if I manually click on the .BAT or if I run the FME job from the workbench. The Task, within Task Scheduler, is set to run with a headless account (the same account I use to log into this machine). Within the task security properties I have set the job to Run whether user is logged on or not and the password is saved as a part of the task. So, how do I get task scheduler to know that ArcGIS Pro is installed when the FME

Hi, How can I check if two equal or similar geometries are displacement in some way when they overlap? I don't want to validate when they are not related in any way, but only if they are with some kind of displacement. Thanks

I have an DWG file which I convert into an FGDB file by using an FGDB writer with a Dynamic Schema Definition:The DWG file contains different types of geometries on single layers, e.g. polygons, lines, and points. In combination with the dynamic feature writing to FGDB, this results in that after the run, I have more layers/feature classes in my FGDB than in the original DWG file. For example, if I had a layer "XYZ" in the DWG file which contained polygons, lines, and points, in the resulting FGDB file, there are the feature classes "XYZ_polygons", "XYZ_lines", and "XYZ_points". So far so good, this is expected and totally fine. My problem is the following: How can I preserve the stylings of the features? For example, in the DWG file, there are some green areas:In the DWG, the green fill color is defined on layer level.During the translation, FME correctly picks up the color and also recognizes it has been defined on layer level:However, when I i

It is taking a considerable amount of time to run the workspace with a million row CSV as a reader. Please suggest how to reduce the run time

I want to perform an operation where I want to add a new attribute which will have value of next 23rd feature from existing attribute. Is there any quicker way to do this without enabling "Adjacent features Attributes"?

HelloI try to set up a processing chain to compare provider shape files and those of my database to integrate them into postgres database.however I am not sure to use the right transform to detect errors in data. I’m an idea taker if you have any =)thank you

I am using FME 2022. When I tried to publish data to ArcGIS Porta, I had the error message as below: ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '409' and the message was: 'Item 'tmps4rtbkh5.zip' already exists.'. Details: '' Translation Failed.I checked my portal site and found FGDB named 'tmps4rtbkh5.zip' has been published but the feature service hasn't been created, but I can download 'tmps4rtbkh5.zip' file to my local drive. Seems FME already publish the data into portal but failed to generate the feature service from the data. Does anyone have any ideas about this?I used FME2019 to publish data to ArcGIS Portal, never had this problem before.Thanks 

I am trying to come up with a way to use FME Desktop to process files that will be automatically exported from a system and will likely be named with a timestamp (eg filename20230512132945.xlsx). The goal is to create an automated process to handle these files as the appear. I already run FME Desktop from the command line (via windows Task Scheduler), but I am wondering if there is a way to do it and also specify the name of the file I want to have read as a parameter? Something like C:\\fme.exe workbench.fmw inputFile.xlsx I don't think I am going to be able to count on these files having the same name every time, otherwise I could just run the workbench (c:\\fme.exe workbench.fmw) I'd be grateful for any suggestions. I would happily try to do this with FME Server but it is not currently available to me. Thanks, Mike

I am trying to add an extra label for each point of the point cloud based on whether or not they were located inside or outside the gml building model.  When I clipped a model with my point cloud data with "Clipper", it only identified that point cloud was outside and that point cloud data was identified as 1 feature own on its.  How do I label/mark each point in the point cloud whether they clipped with the model or not and then save it as an extra information/variable in a new las file.

I am trying to create a workbench to extract wms features into vector https://data.gns.cri.nz/tsunami/wms.html. I am wanting to extract out points and associated attribute data that is relating to each tsunami event

We have been using ArcGIS 10.8.1 (32bit) with arcFM solution and FME 2020.2 (Desktop and Server) (32bit). We use FME to read and write to the esri geodatabase (ArcSDE Geodb). I am trying to update FME to the newest version 2022.2.5 (64bit).I read that it should be possible to have 32bit ArcGIS and 64bit FME after installing background geoprocessing.  However when I am starting the workspace with python startup script for fetching the licenses for ArcGIS and ArcFM I get error: "Python Exception <com_error>: (-2147221164, 'Class not registered', None, None)". This error comes up using fmepython310 + pywin32 library installed. Pywin32 also includes the pythoncom and it is installed the same way than in the previous version.I have also tried to use the 32bit fmepython37 from the older FME version, but FME 2022 is not recognizing it and automatically switches back to python 3.10.

Is it possible to use Web Connection authentication in the HTTPCaller transformer to access ArcGIS Online REST APIs without additional steps to obtain a token?