Transformers

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 adjust

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? 

I am using FME(R) 2022.1.3.0 (20220928 - Build 22630)I noticed while working with ArcGIS Data (FileGeodatabase), that when I usethe “DatabaseJoiner” Transformer to join attributes with curly brackets inside its values, the curly brackets are gone after joining. e.g. Original Attribute value: {12C300A2-64C3-4494-A1E2-430CC5C5C7A9}joined value by DatabaseJoiner: 12C300A2-64C3-4494-A1E2-430CC5C5C7A9It this a known behaviour? Why would it get rid of the curly brackets? Anything to do against it?

Hi All,I’m working on a workflow to project a DWG from one coordinate system to another. The workflow works fine but am having issues to write autocad_oriented_arc into the DWG final output. I did some test to write it to GIS format and those autocad_oriented_arc write ok but for some reason can’t get them to work in DWG format,I’m sure that am missing some settings in the writer because the visual preview shows those arc fine, see below: I’m using the following:FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64)Writer Autodesk AutoCAD DWG/DXF parameters as follows: Thanks!

Five months ago, I created a small FME application that would login to a state controlled secured FTP server and download a file to a local drive.  Putty was used and files were generated for local use and for the state. That application was working fine, however, the agency that made the request was not able to approve the process in the interim.Now, five months later, when I run the application in FME, the login is rejected.If I use the exact same parameters to manually download the file with WINSCP I am able to login and download the file without a problem. Nothing has changed in the setup of the FME.In the attached image, I show the three transformers and their parameters that I used to download the file.  Five months ago it worked.  Now it does not.  Manually, it works.  Via FME it does not.I am not sure if this is problem in the FME, an issue with my local network security or an issue at the State ftp site.The error message is a

I’m trying to repeat the same process on each group of features that represent each door (every door consists of many features having the same value of door_id) . on the other hand , the process that i want to create is detecting that line on green for each door and drawing it using the LineBuilder  .So for exemple ,if in my input i have : 200 features , every 30 or 40 features share the same door_id value (so there are say 6 doors in total )my output : 6 features (each feature is that green line , with the attribute door_id) 

Hi All, Is there any writer for AutoCAD Civils 3D (.dwg)?There’s definitely an AutoCAD Civils 3D and Autodesk AutoCAD Map 3D Object Data Readers but can’t find the same writers?

Hi All, I’m trying to read an Autodesk Civil 3D file in FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64) but gives me the following error, see below:AutoCAD Reader: An error occurred for dataset 'filename.dwg', in function C3DReader::processAeccAlignmentEntity. Exception thrown: 'Invalid input' (Invalid input) I have left the default setting to read Autocad Civil Files, see below: 

Hi, we have tiff files with rgb values. Is there an easy way to transform this tiff file in hsv color space?Something like inside the transformer “rasterexpressionevaluator”? thanks in advance 

 Hi, I have a table with many points, with an ID and two attributs, like this :I need to “dissolve” the points and get just one point by ID and in attributes get “Yes” if at least one of the original points had “Yes” as value, like this: Is that possible with some transformer? Thanks

Hi, Is there a way to change the color of the font for the part of the text that matches regex? In the scenario below I would like to put in red only the double spaces in Excell At the moment is highlighting the whole text in excel 

Hi, I would like to create a FME app that will allow users to check the gdb for wrong attributes. Each time the attributes in the gdb will change hence I need to find out how to do it automatically/dynamically.   

I’m dealing with a rather large JSON file. The issue I have is that some element values contain literal quotes and double quotes, and these are causing Rejections in the JSONExtractor. The quotes/double quotes are not escaped in the original source. Is there a way to escape these automatically with other FME JSON transformers?My efforts to fix thus far using the StringReplacers have resulted in errors throughout the entire JSON string, since quotes/double quotes are native to JSON formatting.

Hello, We have been troubleshooting this FME translation for a while and can’t figure out a solution.  The Inserted, Deleted features of the ChangeDetector write reasonably quickly but the Update features are writing so slow it will be unusable, GIF for reference.  Things we’ve tried without any differences:Indexing all fields in ArcCatalogIndexing Just the Match Column fields (3 Fields to make a Unique ID)Indexing and using a CRCCalculator field for the Match ColumnsAdding a FeatureHolder after the ChangeDetectorAdding a AttributeManager after the ChangeDetector removing unused fieldsWriting to a File Geodatabase (SDE is ultimately the goal and being used in the gif below)Not Checking the Geometry in the ChangeDetectorChanging Transaction types in the WriterChanging and testing various other settings in the transformers and writers  

Hi there,I have following input:a list with unknown/varying keys and valuesWhat I need:the name of the keys as attribute valuesExamplesWhat I already tried:ListHistogrammer This has no effect. Is it because it’s a “nested list”? Cheers,Maria

Parcels are created, removed or changed in GIS,  but we also have a CAD Map3d basemap that we also maintain.  One of these basemaps contains a text layer that has the address number for each parcel, what I am trying to do is compare the parcel address number from the GIS against the cad basemap find out which ones have changed, removed or inserted then make the changes to the cad file.I have already setup readers for the GIS and CAD parcel polygons and using a change detector I know what is different compared to the polygon basemap, but now I need to take that result and check it against the text in the cad basemap and update it. for some reason the number of changes don’t seem to match when I compre the text.  how would you suggest I attempt to do this, is there something I am missing.

Hi, I am using FME to write tables into SQL Server, is there any setting for collation i can add Latin1_General_CI_AI Any suggestion is greatly appreciated. Thanks,Jay 

hola necesito encontrar en mi base de datos si tengo alguna geometría duplicada.Alguien sabe de algún transformador? 

Hello there,i have a big Problem. My FME-Desktop-Application crashes while loading the main window. If i start FME the littel loading window appears. But when the main window is loading the launcher crashes without any errormessage.Reinstalling the software didnt solve the problem.Have anyone a idea what i can do? Thanks 🙂

Lines/polygons contain ordered data of every vertice that they are made up of. Is there an easy way to extract ALL these positions as points? (preferably while retaining attributes) 

I’ve read this article : https://support.safe.com/s/article/autocad-to-ifc-conversion-example that converts a DWG plan consisting of a 3 storey layer , and all the object have a HEIGHT attribute that is used to extrude the 3D geometry from the 2D input , then the ifc file is created with all the infos in a single ifcSpace . But my need is different ,in the input , my autocad file has attributes of HEIGHT , as well as TYPE ,which would contain the type of each object (WALL , DOOR , WINDOW , Stairs , etc ).and so i want the output ifc file to be a rich file with multiple types of objects : ifcDoor , ifcWindow , ifcWall ,.. . instead of just a 3D model in an ifcSpace .

When using the SQLITE3 Reader, unchecked attributes from the User Attributes tab are not exposed downstream to any transformer like AttributeManager, -Remover, -Keeper. This behavior is as expected.However when using the FeatureType downstream on the Requestor side of a FetureMerger and the conflict resolution is set to ‘Use Requestor’ , the unchecked attribute is still active behind the scene and take precedence over the attribute of the same name coming from the Supplier.It turned out that I need to keep the unwanted attribute ‘checked’ and remove it actively with an AttributeRemover to avoid the unexpected usage in the FeatureMerger.I also tried to force it by changing the workspace option Reader/Writer Options > Allow Reader Feature Type Editing, but it made no difference.Question: is this a bug or dangerously intended? Setup: FME Forms 2023.2 for win 64