Transformers

Hello everyone,This question has been asked before, but for some reason using the following transformers mentioned in the following post  (Geometrypartextractor > GeometryFilter > Chopper) didn't help me to split certain shapes into lines and arcs respectively. The situation is as follows for me: I read a dgn file (thus a CAD format) in FME in which I have exploded cells. Then I do some transforming on the data in fme before writing to a table in a database. The final step is that I use GeoServer to look on the table i which I have created in order to create a WMS. However in Geoserver, I get the following error: “ORA-13346: the coordinates defining an arc are collinear.".In my dgn, I have the following kind of shapes and I think these shapes are the causes of this error. So, I am now trying to split  s

Hi All,I'm experiencing a bug in the Excel writer in the new FME 2024.0. I've made a script that outputs multiple data categories I need to process in a particular order to ensure my calculations are fed as desired. The bug causes the attribute names to not be written in the first row in Excel; it just starts with the data in the second row. Whenever I open the exact same script in FME 2023.2, the writer does write the field row names, without me changing anything in the writer settings.For now, my solution is to not use FME 2024, but since my customer does use 2024, it's not desirable. Does anyone have any ideas?Here is a preview of Excel. I can't scroll up to the first row, the data is not hidden, and the navigator also won't allow me to go to row 1. 

Hello ,i would like to insert some new points into ArcSDE, where each point will be positioned on and connected to various lines.How can I establish a relationship between each point and its corresponding connecting lines?Is it possible to set up this relationship in FME, so I can view the relationship class later in ArcMap?there is already a relationship exist between feature class lines and feature class points.But what  about the new points from FME?Could anyone advise me on a solution?Thanks in advance .FME 2023

I have a pair of longitude latitude coordinates that I’m trying to measure the distance between in KMIf I cross-reference this “distance” result in ArcGIS Pro, I get approximately 1.44kmThis is also roughly the same result if I use a online calculator;My question, is how does the result 0.01630799258600798 translate to 1.44km? is there something I’m missing??

I have an FMW that writes a CSV file and then uploads that CSV to Azure BLOB. The CSV that's created on the server's disk is okay. It has 201 records as expected and opens up just fine. That CSV--after FME uploads it to Azure BLOB via AzureBlobStorageConnector has about 25 less records--seemingly randomly removed. To rule out Azure BLOB itself as the problem, I used Microsoft Azure Storage Explorer to upload the CSV--when I do that, all records are in the CSV file when downloaded back down from Azure. I have experimented w/ a folder upload (upload the file w/ a containing folder) vs. a file upload--no luck w/ that, same result. What really bothers me about this is how it makes no sense. The CSV that gets uploaded should be the CSV that's on disk. It's a file and file-upload process. What could possibly be removing certain lines/records from the file?

I have an aggregated line, containing three parts. Every 50 meters I need to have a point/vertex/measure and using the MeasureGenerator in conjunction with the MeasureExtractor works in principle fine.The MeasureGenerator will only work if I ‘Deaggregate’ the parts and then every part gets a list of measures, starting from zero (as defined in the MeasureGenerator).My challenge is, that the next part of the line should actually not start from zero, but should set the first measure with regards to the remainder from the part before, where there might be the last measure at e.g. 250 m, but there is a remaining piece of 2.2 m.These 2.2 m should basically subtracted from the start value when creating measures for the next part.Is there a way to achieve that?

Hopefully easy question: what is the easiest way for me to check if a workbench is running on FME Form or on FME Flow?On Form, when testing, I want to read the source data from my C-drive. But when on Flow, I want to read the official data uploaded on the server.

Hello,How can I use the values from two fields to match against another dataset? image 1, filtered portI have a test filter, which filters out all items that contain ‘FeatureWriter’ in the transformer_parameter_value field, I now want to take the items from the unfiltered port,Image 2, Unfiltered port.and match these against the initiator_workspaceId AND transfomer_id items from the filtered port (image 1). I do not want to do a row by row comparison, I want to match all items that exist in the filtered output (image 1) against all items in the unfiltered port (image 2). If they have

Build 24627Hello, I am having issues reading a single Feature Type while using the Constraints in the FeatureReader transformer with both the File Geodb and the File Geodb API formats. Each of the Feature Types are visible when clicking on the ellipses; however, after you select one or multiples, the transformer updates and the only outputs are Schema, Generic, and Initiator.There is a workaround, to not select a Feature Type to Read, however, this will then read all of the feature classes in the File Geodatabase.Thanks,Justin

Hi FMErs,I have 3 rasters of equal extents and cell size (clipped to the same 2D polygon)a) representing the floor elevation of a sub-surface stratab) representing the thickness of the same sub-surface stratac) representing the roof elevation of he same sub-surface strataLooking for tips on the best / most efficient way to create a 3D polygon in FME similar to ESRI extrude between, and assuming other strata sections are available in the same raster form , iterate through each strata section to create a 3D subsurface model.Thanks in advance

I have a workspace that is calculating the shortest path across a network for a dataset of start and end points (joined as lines). The length of time it is taking to process the data through the ShortestPathFinder transformer is a lot and it sits as follows for hours on end:  Is there a way to speed this up at all? I know I’m trying to process a large amount of data which could be the primary reason but I am curious if there are ways to perfect this process to enable it to complete much faster.

In the change detector is there any way of transferring an attribute value from the original feature to the updated feature when it's not either a Key Attribute or one of the attributes listed in the matching strategye.g. 

Hello,I am attempting to use the FeatureWriter to update a spreadsheet. From the screenshot you can see I have Addresses Input into which is pushed 3 updates and 95,393 from the original spreadsheet. The Output port, Addresses adds the 3 records to the original spreadsheet making for 95,396 records. Is there a way to get FeatureWriter to update the spreadsheet so the output is 95,393 with the 3 records in 95,393 updated not added to the output? The FeatureWriter is writing to the same spreadsheet in the Addresses Reader.  

What modules are available in the PythonCaller transformer in FME Server?I am interested in these modules;urlliburllib2requests 

I am clipping a raster and then running RasterStatisticsCalculator. The results are completely wrong to what I get in ESRI using  zonal statistics and the only stat that is correct is the max value.FME Results: When I export the raster and bring it into ESRI, cell values are different and zonal stats are different Zonal stats results from ESRI:  I would appreciate some help in how best to run zonal stats in FME. Thanks,K

I have a SPATIAL table with the following columns: X_coord, Y_coord and a SPATIAL column GEOMETRYThe X and Y coordinates are adjusted. With which attribute can I adjust the GEOMETRY columns?It has data_type SDO_GEOMETRY (Oracle). Contents of a record:MDSYS.SDO_GEOMETRY(2001, 28992, MDSYS.SDO_POINT_TYPE(201234.5678, 47123.4567, NULL), NULL, NULL)  

I used Workbench 2022 to clip buildings (composite surfaces) onto an area with the clipper transformer. The buildings at the clipper boundary however are open geometries (refer to screenshot). How can I insert closure surfaces to each boundary building to create closed volumes?I tried to coerce the composite surfaces to a solid and coerce them back to surfaces after the clipping, but the method is not reliable, because most of the solids become faulty. Is there another solution? Best regardsAlex

Title says it all, Basically I have a workflow:Adding a prefix to the new attribute results in the new attribute not to have any values.Running with prefix:Running without prefix:  Also if I add a prefix, for example _, and have a new field I wish to extract, i.e. “ID” which should result in a new column “_ID” with values, it instead replaces the original id field with the new values, totally ignoring the requested “_” prefix. Workaround is to rename the original values with a prefix before extracting second set of values from nested json.

I have a workbench where I am reading data from a SDE looking for rows updated in the last 7 days then exporting to an excel file. That is working well. I’m also using mapnikrasteriser to create a map and export a tiff image however the new records have no geometry defined so won't show up on my map.  What would be the best option to calculate geometry for those new records?

I’ve successfully exposed a dozen attributes (see green check marks).  Then something changes in the source JSON not allowing me to pull “records.number” and others below “records”.  What’s different? Thank you!! 

Hi all,I have created a custom coordinate system and placed it in the FME documents directory but I can’t access that in CSMapReprojector transformer. Has anyone dealt with this issue? Looking forward to your responses. Thanks

I am working with a table from a GeoPackage in FME, reading it and clipping based on intersections between categories. When writing the output, the unclipped parts are successfully written to Writer 1 without any issues in the output GeoPackage. However, the clipped parts are written without geometry, even though I can see the attributes correctly in the visual preview on the attribute expose just before writting. I'm confident that I’ve set the geometry type correctly in the writer. What could I be missing here?    

Hi Community,I have FeatureWriters creating log text files for me depending on various conditions.If the conditions are not fulfilled the files are still generated but empty and emailer still sends those empty files as attachment.How can i stop this from happening, so that only the log files with any values are sent as attachments with email.Thank you

Hi,I use a CSV list with standard ArcGIS server queries + HTTP Caller to get geojsons. a CSV list contains also layer names etc. I use the File option when saving a response because I need a separate geojson file for every query. Everything goes great, however response files look like "http_download_153028689823_5840.json" which is hard to deal with. Actually I can create a folder with a layer name but I would like to have an option to save a response file itself with a meaningful name and keep granular file structure. Ideally I see it as follows: I run a query within my CSV then get some attributes from the same CSV and supply a response filename from HTTP Caller with these attributes on the fly.There is a way to deal with a new Workspace and rename all the files using filecopy (upd - today I have finally managed with DatabaseJoiner for this purpose), but I am interested in a more integrated solution. Thank you in advance!Evgeny

Bonjour,J’ai une table avec plusieurs colonnes (23) chaque colonne à la valeur 0, 1, 2 ou 3 dedans. J’aimerais savoir une façon de calculer le nombre de fois dans une ligne que l’on peut retrouver la valeur 1, 2  ou 3 et mettre ce résultat dans 3 colonnes distinctes (une pour le 1, le 2 et le 3) voici l’exemple du résultat :Merci pour votre aide!