Transformers

Dear, I want to merge two different datasets. One data set has road segments with a maximum speed and the other is bike segments. For each bike segment I want to know what the maximum speed is on the nearby road segment. Now I want to merge for each bike segment the road segments that are near (next to each other) I have tried anchored snapper but that does not work 100procent. Do you have some ideas on how I could take this problem on?Thank you in advance  (purple the road segments, pink? the bike segments) Only the segments that are parallel to each other should be combined 

Hi All, I have FME Form 2023.2.I am trying to make a REST API call using HTTPCaller. I got this error below,{    "code": "data_validation_error",    "message": "Invalid request values. Unexpected character ('_' (code 95)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')",    "status": 400,    "traceId": "240425163408767-2c15ec9a"}However, the same request works just fine on Postman. Not sure what exactly the error means here. Can anyone help me on this?Here is the HTTPCaller screenshot.Here is the request body, Here is the error messages from the Translation log.##########...UpdateRecordCustomTablesHTTPCaller (HTTPFactory): An error occurred while accessing the URL 'https://apis.accela.com/v4/records/PINELLAS-24CAP-00000-0004H/customTables'The below feature caused the translation to be terminatedStoring feature(s) to FME feature store file `C:\FME\Funeral Home\FuneralHomeBillingInterfacefmw_log.ffs'++++++++++++++++++++++++++++++++++++++++++++++++++++++

Hi, I’m having an issue with the StasticsCalculator returning some nulls for min and max. And also some unexpected rounded max values. Input data I’m calculating statistics on avg_dur field and grouping by SEG_ID. Unexpected results highlighted. The avg_dur field is data type real32. For some reason changing the data type to real64 results in the stats being calculated as expected.The ave_dur field was originally imported from an esri shapefile with data type . 

HiCurrently I am converting a DWG file to GDB (file) / SHP,The DWG file itself has line and polygon and they have color based on their different layer name.Once I read the file, it showed only FME feature name, I used AttributeExposer to add autocad color column and a few more useful information, then I used DWGStyler and FeatureColorSetter but once I write the file to GDB or SHP and bring the data to ArcGISPro, the layer has only one single color. (Please see the attachments) Can someone give me a clue how to solve it? 

Hi All,I’m trying to improve the performance of my workbench by reducing the number of transformers. I was able to use AttributeManager to calculate the length of lines with the expression @Length() but I can’t work out how to round up the value up to 3 decimal places,Is that doable using the arithmetic expression instead of AttributeRounder transformer? 

Hello,I am trying to convert data from shapefile to DWG.To do that, I am using the DWGStyler to assign the correct setting to each object.Reading the post in the community, I am able to use the DWGStyler using a template and the right color is assigned to each object in CAD so, I see the match between the color in the canvas and the color in the Layer’s list. But, in some cases, I don’t have the template and when I open the file in autocad I can see the right color in the canvas assigned by the DWGStyler but in the Autocad list layer I see all layers in “red”, I attached an example. How can I resolve this situation to have the perfect match for the layer’s colors to avoid a manual rework without using the template? Thanks Max  

Problem in short:I have a lot of points which some has identical coordinates. PointOnPointOverlayer does this for me and store the “twins” in a list name. Now I want to use a Pythoncaller to loop through the list of each feature and figure out if some or none of the twin attributes has a value that should update the the major feature. The problem is that I cant seem to reach the list variable created in PointOnPointOverlayer from the Pythoncaller. It seems to be exposed when running with feature cache and checking output from PointOnPointOverlayer. What’s the magic for reading the list, looping throug it and check the attribute values? Tried this example code from the PythonCaller just to see if I could reach the list but can’t see anything:  

Hey! I have an 50 diffrent  MXD and I need to retive the map extent from start  in every mxd. There is an option to igonore map extents.But is there an an way to extract the start extent? 

Hi Community,I need to extract a CSV Style content from a SQL field of an SQL table.It is stored into a single field.The content looks like this:Classification,Fonction03-1,30003-2,301AA-10,C-1000AA-12,C-1000AA-15,C-1000AA-17,C-1000AA-20,C-1000AA-22,C-1000AA-25,C-1000AA-27,C-1000AA-30,C-1000As you can see, the first line gives me the Attributes names and the following lines gives me the valuesWhat would be the best way to turn this into multiple features using the first line as the Attributes names ?Thank you

Trying to find a  way to find the maximum amount (highest density) of polygons with the rulethe polygons must be non-neighbouring. Essentially selecting a polygon and jump to the next polygon which is not neighbouring and so fort and so on until you encounter a neighbouring one.See attached picture which I hand-picked.

Hello fellow FME-ers. I'm looking for a transformer to compare two GIS datasets and what has changed compared to each other. Actually, the Symmetrical Difference tool that is present in ArcGISPro. This transformer must be there in FME. Can anyone help me with this? Thanks in advance.

I have a test looking for many possible cases. one of the cases I want to find is Any folder inside of any folder that has some specific names. (BTW I am using directory and File Pathname reader to create a list) and then a tester to get all of the special cases.)I have a test line like path_directory_windows CONTAINS *\project_data\working\**\*I don’t get any errors with this syntax but it does not find the folders. Basically i am only wanting to find folders within any project_data\working folder that contain any files.If it doesn’t contain a file I am not concerned with it.Any help with a correct regex statement that would work, or the proper syntax for the contains statement are what i am needing.I have tried this regex unssuccessfullyproject_data\/working\/[^\/]+\/[^\/]+TIA 

I’m trying to use FME to split out any “Complex” or “Multi-Part” annotations that exist in the dataset and have the “Complex” or “Multi-Part” deleted and insert the split records as new annotations.On my FeatureReader, I have both "Split Complex Annotations" and "Split Multi-Part Annotations" enabled and I am able to delete the old records and insert the new records. However, I’m running into an issue with the geometry of the newly inserted records.From another post it looks like FME splits complex annotations tries to preserve the location of the text but loses other text placement characteristics like the original complex text geometry (lines) and converts them to a point for each split text item.'Split Complex Annotations' when reading ArcGIS geodatabase annotationsIs there a way to create or preserve the complex text geometry for these split records? The converted points seem to be causing an issue in a downstream program with the following error:Error from downstream program: “Err

I’m attempting to access an AWS marketplace free resource, NOAA’s bathymetry, but with Anonymous access if I enter us-east-1 as the region I cannot manually specify noaa-bathymetry-pds as the bucket and I cannot get a picker, or not that I can see.  Is there a trick?  Thanks.

Hi there,I have an Ascii grid file.The FME can read the file I have also added a Raster Cell Coercer transformer to create a shafile this simple workbench works fine. Issue - How the raster values can be displayed in the shapefile. The shapefile has no attribute data (cell values).I need to display the raster values in the shapefile. Any hints will be greatly appreciated.Thank you very much,Sebastian Algardi-CamusWorkbench Raster image 

When I use the aggregator, the IFMELine becomes an IFMEMultiCurve.I don't want the IFMELine to become a IFMEMultiCurve. How can I prevent this?

Hi,I use FME form through ArcGIS Data interoperability workbench and I work with the national Swedish coordinate system 3006 Sweref 99 tm. I cannot display these features with the standard background maps and get: This does not happen in the regular FME Form and they display without problem there. How can I solve this in ArcGIS DI workbench?Is the standard FME Form able to do some kind of on the fly reprojection to view the features on the standard base/background maps? Best regards,Karl

I am trying to use the FilenameExtractor to get the rootname of the source file to match the new filename in a different source directory with a different format i.e. my pipeline is essentiallyMyFileName.xlsx → MyFileName.jsonCurrently if I use the source filename input paramter the behavior is like:MyFileName.xlsx → MyFileName.xlsx.json , which I don’t want.I tried using the FileNameExtractor where _rootname gets set as a user paramet but then the output is like:MyFileName.xlsx → _rootname.json The value of the user parameter does not actually extract the rootname and save its value as the user parameter dynamically. Can anyone help?edit:Scripted Python (safe.com)I used a scripted parameter at the start of the workspace but still curious as to why the filename extractor did not perform as expected?

In FME Flow 2024.0, when PythonCaller hits an Exception it doesn’t specify where the exception occurred -- we only get Message Type: fme::internal::_v0::py::ExceptionPython Exception <IndexError>: list index out of rangePythonCaller (PythonFactory): Group 28 / 20195: PythonFactory failed to process group properly However, there are numerous instances of indexing lists that could be responsible for this!Am I missing something? Is there anything I can do to fix this, or does Safe Software need to fix this? (How do I ask them to fix this, besides posting here?)

Good morning,I am reading a DEM stored as a raster feature class in a gdb, clipping to an AOI and then writing to JPEG to be used in road design software.I can read and clip properly but having trouble writing to JPEG. I have gathered I need to set up bands differently but I have tried the rasterbandinterpretationcoercer and rasterbandadder and rasterinterpretationcoecer in various configurations/settings and can’t seem to get it to write a JPEG. Usual error is about the number or type of bands depending on how I set the coercers etc.DEM raster feature information Any suggestions would be welcome.Thank you so much,Corey

FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64)Hello FMEers,I have a set of Esri feature classes that we are supplying to our clients so they can submit data to us using a standard schema. On submission we want to verify they haven’t modified the data structure using the method described here. The method compares two datasets using the SchemaScanner and works well if there is at least one record in each feature type. It doesn’t work if there are no records in one of the datasets to be compared. This is expected because there are simply no features coming out of the ‘template’ feature class reader to work with.My question: is there any way to achieve the intent of the abovementioned article when one of my inputs has no records, only the table definition? The method works fine if I include a dummy record in the ‘template’ feature class, but I’d rather avoid this kludge.Thanks in advance. 

FIs this a bug on FME(R) 2023.1.1.1? I’m using FME(R) 2023.1.1.1. I’m trying to filter some data using Tester and I used IN with a parameter has 2 items both of which are present in my dataset. But the tester filters just 1 record. Why is that? 

At this moment I received a DWG drawing with both Extended and Object data. To convert this data I first have to read with:Autodesk AutoCAD Civil 3Dthen read withAutodesk AutoCAD Map 3D Object Dataand merge all features on the autocad_entity_handle Am I doing something wrong or is this the only way to get both attributes?Is it possible build a transformer that uses both reading engines because I think that would make the reader faster than current.

Hi all,I am trying to show all tables with contents in a database. I have a database with over 800 tables. Some tables are empty, some are not.  Im using this query in a sql client:SELECT SCHEMA_NAME(t.[schema_id]) AS [table_schema]          ,OBJECT_NAME(p.[object_id]) AS [table_name]          ,SUM(p.[rows]) AS [row_count]    FROM [sys].[partitions] p    INNER JOIN [sys].[tables] t ON p.[object_id] = t.[object_id]    WHERE p.[index_id] < 2    GROUP BY p.[object_id]        ,t.[schema_id]    ORDER BY row_count desc  If i am using a Sql Executor with this sql statement i have a return value of more than 300 tables wich is correct. In the preview of the feature window i see more than 300 lines. But i dont see any attributes like a table name or the number of records. Do you know how i can expose these attributes?

Hello everyone,I am trying to write data into an SQL Database which contains multiple geometries (This is borehole location data containing the originaly measured location (point), a corrected location (point) an a borehole path (linestring)). After creating the geometries from fields and using a GeometryPropertySetter for each of these geometries I am using an Aggregator followed by a MultipleGeometrySetter-Transformer. This is working more or less as in 3 Geometries are in fact written into the database which then also contains 3 fields with SQL geometries as set by the 3 GeometryPropertySetters. But there seems to be a problem. Between setting the individual geometries and aggregation, all info on the previously set projections seems to be lost. Upon inspecting each individual GeometryPropertySetter all points are where they should be. Inspecting the following aggregator shows all points off bounds somewhere. It is my understanding that the aggregator should simply collect the input