Transformers

 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

Hi,I am converting a Civil 3D DWG file to GDB. However, once I read the DWG file, the colors appear to be changed to black and white. I attempted to use DWGStyler, but the colors are still not reverting to their original state. I've checked the Reader Parameters to ensure that "Resolve Entity Color" is selected. Could someone please assist me?1 more thing that I found is that, once I use autocad_color or fme_color in DWGStyler the values disappear.  Thanks in advance

Hello, Is the result of the function @uuid() the same as the transformer UniqueIdentifierGenerator ?I would like to create directly an UUID in an attribute creator instead of using 2 transformers (UniqueIdentifierGenerator and AttributeCreator). Thanks.  

I am trying to pass custom Python Interpreter and Python Home to a batch script. The batch script then triggers a FME workbench script. Here’s the commands I am using in the batch script: set NEW_TIME=%TIME: =0%set LOG_DATE=%DATE:~4,2%_%DATE:~7,2%_%DATE:~10,4%_%NEW_TIME:~0,2%_%NEW_TIME:~3,2%SET path=<path to log directory>SET filename=%path%batch_log%LOG_DATE%.txtecho ************* Started FME Update ********** > %filename%echo.>> %filename%echo.>> %filename%echo Time Stamp: %DATE% %TIME% >> %filename%:: activating clone python env which contains all the dependencies for the PythonCaller referenced in the Workbench scriptcall "C:\Program Files\ArcGIS\Pro\bin\Python\Scripts\activate.bat" arcgispro-py3-clone >> %filename%:: Use custom Python set to true"C:\Program Files\FME\fme.exe" APPLY_SETTINGS SYSTEM "Python/Use Custom Pyth

Hi all, I have a layer with multiple polygons sharing a specific attribute (Area_ID), and they are spread with no geometry among them. Multipart polygons sharing same attribute value.Then, I would like to know the way to identify the area that could be filled considering the vertex points that can make up a border.Area between multipart polygons that need to be filled.Finally, the need is to merge all of the multipart polygons into one, without moving those multipart from the coordinates they are now, just filling the space between the polygons with the same attribute in common.

I would like to create an Excel list from our GetCapabilities document, where all our wms services are listed.Some of our services are grouped together and I don't want to list these group layers, just the lowest level of layers.The list should include name, title, abstract and metadata link (xlink:href).I have searched the community for examples, and although there are many questions about XML, I have not been able to apply these solutions to my problem and thus create a list.I probably have to use the XQueryExtractor to find the desired layer elements, but I am not able to insert the XQuery expression (Layer[child::CRS]).URL: https://map.geo.sz.ch/mapserv_proxy?SERVICE=WMS&REQUEST=GetCapabilities&lang=deAny help will be appreciated!Thanks in advanceVera

Hi,we connected from FME Desktop 2022.2.5 successfully to a Azure Synapse SQL Pool using the "Microsoft Azure SQL Database (JDBC)" connection. I can use the Reader without any problems and query data from the tables. However I need to use SQLExecutor Transformer as the queries need to be dynamically created. But this gives me the following error:com.microsoft.sqlserver.jdbc.SQLServerException:  '@@TRANCOUNT' is not supported.Seems like the SQLExecutor performs additional statements in the background which are not supported by Synapse. Are there any workarounds to avoid this issue or to force SQLExecutor not to use additional statements?Thx for your help! 

Cache problem?At writing a dbf-file happens errror "DBASE writer: 'unknown' is not recognized as a valid encoding name". FME(R) 2023.2.0.0 (20231201 - Build 23764 - WIN64) Error happens since today Feature Caching set off Result files: .cpg, .dbf, ‘.dbt’ Each process creates 51 files of altogether 283 --> maybe a caching problem? Same error happens also with DBASE writer -> character encoding 'utf-8'Reader file:xlsx-file (MS Office 2016)Writer dBase (DBF) with character encoding Latin-1 Western European (iso8859-1)Parameter tab --> Name-table "JPB_NR" (format: number(3,0) all together 283 lines of dataDBASE writer:Writing files using character encoding 'iso-8859-1' OS Locale Encoding : windows-1252 Process Encoding   : UTF-8Test files are in attachments.Can anybody help?Regards,

I have created a geojson file from nine features drawn from a postgis database. I have tried all the examples from the community pages with no success. Can anybody point me in the right direction?

Need to filter out the large list of Attribute values(Around random 10000 values) to be processed. Currently it is tedious using 'AttributeFilter' transformer as it needs all 10000 output ports to be connected to next transformer for further processing.There should be other transformers for sure which I don't remember any. Please help.-Thanks

Hi everyone,I need to convert multiple 3D .dwg files to feature class gdb. that can be readable and presentable in ArcGIS Pro, or Enterprise.The manual process in ArcGIS pro include these 3 steps Step 1. Bring in MultiPatch feature to ArcProStep 2. Select the original MultiPatch feature class and export data to geodatabaseStep 3. Use the new exported data feature class and input it into the colour model builderbut it is time consuming and I am receiving 25 file each day.Do you know which transformers can be used?here are a few important notes:the color for the component in GIS must be same as original dwg file  The workspace need to be dynamic, which means every day the files need to be read from online datasets, from different locations. (I think I need to start with “Creator” ) The files are 3D in dwg and I need to have them 3D as well the dwg files are in NAD 1983 CSRS MTM 10 and

@ReplaceRegularExpression(@Value(DETAILS),<.+?>,,caseSensitive=FALSE), @ReplaceString(@Value(DETAILS),&qout;,",caseSensitive=TRUE) The first expression replaces any text in details attribute that is bracketed with <> to be deleted.the second expression replaces any instance where &qout; appears with “.These work fine as separate transformations, however when trying to lump them into a single statement in attribute manager’s text editor the transform fails.I’ve tried comma separating, spacing, and barring the functions, but have had no luck. Any suggestions on how to get this to run? Thanks!

Hi. I run the workspace runner with the file path in user parameter. If there is a space (“ “) in the path, the parameter is loaded in a weird way: --DestDataset_ACAD {${=I:<backslash>Data<backslash>CAH<backslash>GAK<backslash>Data<backslash>GAK<backslash>FME-WorkSpace<backslash>09-Export<space>ZML<solidus>_final…But it works fine if I run original workspace. Is there some bug with Workspace runner?