Transformers

I have got data as below  AssetID X Y Z A. 0 0 1B. 1 0 0C. 0 1 0D. 1 0 1E. 4 5. 6F. 9. 8. 7G. 6. 9. 5  am able to extract max of each row min of each row  how to obtain medium of each row as simple as possible ?  am using @max ( value of x , value of y, value z)@min ( value of x , value of y, value z)  medium ?????( plz note it’s not average or median of 3 value ) It’s exactly absolutely value the same as it is in excel files.   

Hi, fellow FME:ers, this is an urgent matter! We just upgraded FME Desktop and FME Server to 2022.1.2. We have 100+ solutions in our consultancy firm building on the use of excel template files - *.xlsx and *.xlsm.  After the upgrade the output becomes corrupt.  Is this a know issue? Is there anything we can try to avoid corrupt files? Or do we need to go back to previous FME versions…I attach two example template files we’re using.Any help will be appreciated!Peter

Hello,I have a point cloud and I would like to get a buffer around each point (to apply an intersection with another mesh)I have placed the following transformers: PointCloudToPointCoercer to separate each point (output geometry: individual points) and then a buffer (buffer type: solid)The workbench works fine, only in the operation, somehow, I lose the georeferencingDoes anyone have a solution? Thanks

The FME ASPRS las file format 1.4 reader seems to omit withheld points. How do i import all points (including the withheld points ) and then use classification_flag to filter the withheld points in and out? The point cloud splitter doesnt give me classification_flag as an option, and the withheld points dont import via the reader (withheld points verified by lastools), and cant see a parameter to control whether withheld points are imported. Advice welcomed. Thanks in advance.

Hi All, I am using FME Desktop 2022.1; We have some GML files that FME does not read. I don't know why. Please help me out here. File is attached.

I have a workbench that creates points from coordinates then generates lines. I am only getting three sides of the polygon and I have not found a transformer that will close the forth side. Can you suggest a solution?

Hi, I would like to do something very simple. I guess. I have one feature in Oracle spatial with differents locations. The cities have one set of the code. Example: Paris (345) with 500 features, after Mumbai (346) with 4335 features. I want basicaly no have duplicated cities by code. I need even run again with Paris and delete all features with ID 345, and put the new features. Even like this, delete all stored line and insert the new lines if the ID is equal. Thank´s  

Hi there! I have about 30 different very long workbenches that we use for one very complex process. Every time we have a change, we want to be able to search in our list of transformers from each bench. Is there a way to generate or map out or investigate workbenches and have that list of all transformers from all of those benches?  Python, xml, anything will do. Need some ideas guys please.

I am using SpatialETL Tool for ArcGIS Pro

Hello, I'm new to FME. I found how to view AIXM data but I don't see a view option for AMXM? Is it possible?

Hi there,I need to run through a large number of GIS layers to run the rubbersheeter over and was hoping to be able to iterate through a list, rather than need to add the SQL Spatial reader for each layer. Is there a way to do this? Also I will be outputting the result to another database. I imagine I just need to read the input name and save out the output feature class. Regards, Josh

 Hi folks, I'm having some issues when setting a loop. I input a TIN in loop,and then I do some processing (smoothing). At the end I've set a parameter to match; if it doesn't , then I want the TIN to be reprocessed (with a new value for refinement).  I seems like the loop is not accepting a TIN as a trigger for the next loop, or this is what i understand from the log:   Loop to testLoop_INPUT1620857756 Input Splitter (BranchingFactory): Transformer/Factory testLoop_Clipper_5_Solid is blocking and cannot be used in a loop, but was found between 'Loop to testLoop_INPUT1620857756 Input Splitter' and 'testLoop_INPUT1620857756 Input Splitter' Transformer/Factory testLoop_Clipper_5_Solid is blocking and cannot be used in a loop, but was found between 'Loop to testLoop_INPUT1620857756 Input Splitter' and 'testLoop_INPUT1620857756 Input Splitter'testLoop_VolumeCalculator_9_GQuery (GQueryFactory): A fatal error has occurred. Check the logfile above f

Using an undetermined number of records as input, I want to process 20 rows at a time with an html report generator to produce a table, and then output pages of 20 rows each. I have a process that works, but it uses a separate html report generator for each page of twenty rows. How can I create a loop that outputs sets of pages with 20 rows ?

Hi.Do the later versions of FME support writing GML 3.3 ?I've read in the "Implementation Standard Revision Notes" from OGC, that "GML 3.3 builds on GML 3.2.1" (which is supported by FME), and that "All extensions are made in seperate XML namespaces".I hope that this means, that a GML 3.2.1 file is a GML 3.3 compliant file. And so I can use 3.2.1 in place of 3.3 whenever this is required.Can anyone verify this ?Cheers.

Hello,a while ago a user suggested to implement an "Option to control default sheet on Excel writer"Does anyone know if this is now possible ? I am writing an Excel file with up to 100 sheets and I want to force Excel to open the first sheet by default. Thanks.

Hello, I am trying to load in my gml data, however all attributes are coming into FME as data type strings, when i have even set the parameter obtain data types from xsd schema. I have also tried the xml validator and this thinks that all attributes are strings. Thanks, @Takashi Iijima​ @mark2atsafe​ 

So, the workflow is as follows. I managed to download a folder from a URL-adress and to unzip it. Next step is where I got stuck. I want to remove all record in my feature class (ArcSDE-database) and then I want to append the same feature class with the records from the shapefile that I downloaded. Anyone got any tips on which transformers to use?Super thankful for your help.

I have an ArcGISOnlineConnector transformer at the beginning of my workspace (initiated by a single Creator object), and the Content Source is set by the user as a group in an ArcGIS Online (AGOL) portal. When the workspace is run, the output from the ArcGISOnlineConnector is a collection of definitions for feature services, web maps, etc. within that chosen group. Those definitions and their attributes are exactly what I need for the main operation of the workspace; however, during processing (within a PythonCaller, to be specific) I need dynamically to access the Group ID parameter that was chosen in the transformer by the user. How can I do that programmatically? In the PythonCaller, which leverages the API for Python and the REST API, I generate an Item object (Python API) for each feature service, so I could use that Item object as a starting point for finding the group id. I have used fmeobjects a lot--but my breadth of knowledge of classes, methods, etc. is rather small--so

I tried to convert an IFC to CESIUM 3D Tiles in FME 2022.The IFC has a coordinate  and a projection  .After tramsformation , When i upload in cesium the coordonate still set to (0,0).I tried it this other IFC file and i have the same issue.Can ANYONE HELP ME?Suggest me a solution ?suggest me a set workspace to solve it ?

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 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'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.