Transformers

I am trying to use attribute, which reprsents search path, to fill in the XML Path in Update section as shown in the screenshot below. But the update is failed. The original value for the element is gone.  From the translation log, I can see the following warnings. But I cannot figure out why it says about “end of file”.  Please can someone shine a light on the issue?Thanks.

I have been trying to create 4 feature datasets inside 1 file geodatabase using FME, but it looks like in FME there is no option to create an Esri feature dataset. When I have opened the feature writer, I don’t see an option to select feature dataset.I have a lot of shapefiles that I want to organize by province represented by the Esri Feature datasets and inside each feature dataset there will be points, lines, and polygons (it is not just one type of geometry).Do you know if that’s even possible in FME?

Hi, I wanted to very simply use a tester to select all records that had a date in the past week. I have tried everything but it does not seem to work.I have a date field in the correct format, I have also tried other formats via the date/time converter but it does not work. @DateTimeNow()-7 does not work.Anyone have any other suggestions? ThxNathalie

The WSG transformer gets following error when I try to upload files to Projectwise: ProjectWiseWSGConnector: Uploading file "testfile.shp" to Bentley ProjectWisePython Exception <AttributeError>: 'NoneType' object has no attribute 'encode'Traceback (most recent call last):  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 227, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 1129, in _handleException  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 200, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 467, in _doUpload  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 511, in _uploadFile  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 320, in uploadData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 282, in _uploadNewData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 233, in _upl

FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2023.2.1.0' HelloFeatureHolder is suppose to wait for all feature to arrive then process then further but as shown below it’s not working.I’m basically re-adjusting the first part of my FME App.Get Path location / file extension Hold Features Check if file is correct then proceed further File is correct then check is .SHP file extension existsWhen I run my workspace, it stops here:  Not sure what’s going on or if I misunderstood the process.Thanks

Hi,I’ve got a strange issue.I am using a FeatureMerger to match values from a lookup table.Then I use a DuplicateFilter to check that all the terms from the lookup table are used. And strangely, with certain non ASCII caracters, there are duplicates coming out the Unique port ! Another strange thing is that these duplicates in Unique port dont appear when I check for duplicates immediately on the lookup table.So what happens in the FeatureMerger that makes the DuplicateFilter dysfunction ? Here’s what the Excel lookup table looks like. When I replace the non ASCII caracter, the problem doesn’t appear.What to do ? 

Hi Guys..I need your Guidance to accomplish above scenario..I was able read a GDB and Excel as source from Feature Reader and also able to do required Results Now , At attribute Manager , I want to add around 52 new field names along with field alias from importing it throughexcel and this would be new field and then i want to write a GDB , so All field along with other New fields which has alias name to be written to GDB.. How can i do this ? Anyone , Kindly Guide..Thanks

Hello ,  any idea , how could I get benefit of using transformer chat gpt to improve my workbench for GIS data ? Why are using chat gpt transformer ?Fme 2021thanks in advance.

I am trying to insert a new item/child into an existing XML element. I want to add: <keyword>USA</keyword> to either the top of this list of keywords (Note this is part of a larger XML document.) I’ve tried to use the XMLUpdater to no avail after a substantial Forum search. Here’s where I am at with the XMLUpdater:I assume my XML/XQuery expression is the issue. Any help would be appreciated. Thanks in advance!Version: FME 2022.2.0.0 (Build22765)

 Hello,  I am updating an existing AGOL Hosted Feature Service with changes in a File Geodatabase. The workbench in the screenshot is what I am using. The Feature Service updates no issues, and it does update the feature service. But I have a question:When I add 1 new feature in the file gdb (Updated FGDB Feature Class Bookmark in screenshot), I run the workbench and in the ChangeDetector it shows 1 record Inserted and 238 records updated for a total of 239 records; The only change I made was to add 1 new feature (which I expect to be in Inserted), but why would there be 238 records in Updated in the ChangeDetector when I only Inserted a single record and Updated zero records, should these 238 “Updated” records be in Unchanged?I then reran the workbench it showed 239 records in Updated (which includes the one I added in the 1st run), but I Updated zero records so I would assume these 239 records should be in Unchanged?  The ChangeDetector Parameters I am using is in the screenshot. 

Greets,  Any idea to cut the polygons in the layer 2 based on the polygons in layer 1 in the same shape and close or same ratio of cutting , please note that there is a shifting between tow layers.or move the polygons in layer 1 to match the location of polygons (based on corners) in layer2    

Hi all!I have a polygon where every vertex/point (don’t know the correct termonology) has a xyz coordinate. I would like to create a buffer where the buffer size depends on the z-coordinate. Couldn’t figure it out how to do it. Anyone who can help me figure this out?

Hi,I have some texts and want to export them as IFC along with the other geometries.Can anyone help me please?

Hi.I have millions of XYZ points (as an Space Delimited XYZ file read) and want to build a triangular mesh out of them.Which transformer(s) should I use? Thanks in advance.

Hi, I have many polygons with height attribute. I need to dissolve the adjacent polygons and keep the max and min height of polygons dissolved. The problems it’s the quantity of polygones that are dissolved it’s random, can be 2, 5, 50, 100 or more. I made a dissolve with generate list, then a ListSorter but then I don’t know how to get automatically the min and max. I think to use attributeCreator with Arithmetic Editor after the ListSorter but I don’t know how to set it to get systematically the min and max of entities dissolved Thanks

Hi, I tried it with a mod counter,  Inputs seem to work but no output at all comes out of the custom transformer. I am passing all attributes (not many anyway) into the custom transformer. It makes no difference  I am trying to add a Z value to each point (frorm vertices). With the TIN I get a much cleaner result than with a raster, but it slows down the entire process x4. Thanks in advance for any suggestion.

is it possible to  Exporting OLE Civil 3D Objects From Drawings to excel 

Hello,So I am having the time of my life with Italian WMS’s 👌 and some of them even have some table data queries connected to them. I would however like to get the table information for more than one feature at at time, instead of opening in PRO and click each polygon and collect. Knowing that FME does not support standard GetFeatureInfo yet then I’m speculating if someone has created some artful way of achieving this anyway (sure there are plenty of those).So far my idea is to fetch a center point for each of my respective polygons, do coordinate extraction and then add those values to a standard HTTP based GetFeatureInfo request with some FME string gymnastics. The WMS in question is this here:https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php? The layer being:CP.CadastralParcel And the information being fetched from the query being:InspireID LocalID InspireId_namespace Label NationalCadastralReference All suggestions what would be the best way to achieve this in re

I have a dataset of around 200,000 records (point geometry with approximately 10 attributes).I am using the Change detector transformer to update only those records that are updated and to add new records or to mark some as deleted records.I am using the Feature Writer transformer to write the data into an ESRI Enterprise geodatabase in MS SQL in Azure Cloud. Source data resides in the same geodatabase in Azure Cloud.!!! FME Server is installed on premise, not in Azure !!!When initializing the ETL by truncating the destination table and initial loading of the data, the 200,000 records are written in about 7 minutes.!!! There is an index on the attribute that is used as Primary Key and that attribute is indicated After the initialization, the time to perform the ETL is still low (5-8 minutes) if there are no updates on data, or if there are few updates.However, if there are many updates (i.e. 100,000 updated records) the time increase dramatically to 4 hours.Data is written in 3 tables:

Translating using 2014 igds_text sixe 8 translates to Height and width 0.08 however translating using 2021 using the same parameters it translates to 0.00 and if it is a multi line text with 3 lines of text it translates to 0.03.  I did try other scaling sizes even up to 20 and the results were the same. Please advise  Since I need to do an upgrade and don't want to have to redo all of my text items I installed and tested FME 2017, 2018, 2019, and 2020.. It appears that the text change happened in release 2020. I can use the same FMW file that I created using 2014 and it works fine for 2017, and 2018.. I did have a glitch using 2019 but once it ran the data was correct. Starting in 2020 the text sizes were all messed up. I am hoping someone can advise me on what may have happened.

As the title says, I have two different point feature classes, and then a table in the geodatabase.  Point A has a unique field value that matches from the point to a record in the table and then, that record in the table has a unique value that matches to Point B. I want to use this “connection” and the vertexcreator transformer to create a line from Point A to Point B, for situations where they match, but I am stuck at the moment and can’t seem to connect the dots. Pun intended. 

I have been tasked with connecting to an FTP site, retrieving a csv file, parsing that file into multiple Excel worksheets within one workbook and then FTPing the Excel spreadsheet back to another FTP site.I have all the component pieces working, in 6 different workbenches, the download of the original csv file, the parsing and writing of the data for each Excel sheet and creation of the four individual worksheets and the upload to the destination FTP site.  However, I have been advised by the local FME Admin that the process should be housed in one FME workbench.  And in order to achieve that, instead of downloading a physical csv file, I should be downloading the data as an attribute so that all of the subsequent processes could be housed within one FME workbench and the attribute data shared by each subsequent process, leaving no artifacts at the conclusion of processing.I have created one FME workbench and copied all of the processes into it and made all the adjustments to User Par

Hi I’m trying to combine some linear events with a routes geometry. The segmentation works fine. The only problem I have is that the from-to values are no longer correct in the new geometry. How can I update them?  

I am using SQL Executer but in the output port I am not getting the attribute exposed automatically. My SQL expression I am only counting the inputs so I cannot expose the attribute using “Populate Attribute from SQL”. I cannot use Attribute exposer every time I am using the SQL. Is there any other way to do this.

I have about 20,000 adresses and 10 locations of the same sort of destination (eg. a doctor). I have already a network.I'd like to calculate the shortest path between each adress and the nearest doctor over the network.Is there a way to utilize the shortestpathfinder for this?I tried the fromToBuilder to create from-to-lines. However, the fromToBuilder requires a join field for each from and to location. Which I would then have to create manually for each adress (and so create 200,000 paths; 20,000 * 10). The shortest path could then be recalculated after the shortestpathfinder to get the closest doctor for each house.Is there perhaps a more efficient way to do this?