Using transformers to modify data.
Recently active
Hello,Created a nice workbench with FMe. However, there are also many individual points in the data, which are poorly visible.Which transformer can you use to replace a point in the data with a symbol (e.g., a circle with a specific diameter)?This improves clarity and better visualization in the final result.
Hi I am uploading data to S3 using the S3 connector. However, empty folders are not being uploaded, even though I have selected “Contents only” as No. I need to upload some projects that contain empty folders and subfolders as well.!--startfragment> Many thanksNasir
I’m running FME 2024 soon to be 2025.My workflow is reading tables from SQL Server and writing them to Snowflake.Can someone please advise if it is possible to have the workflow automatically handle new columns being created on the source table?I don’t want to have to publish a new version of a workflow just because a source table has a new column added to it.Thanks in advance.
Hi,I have 3 raster’s that I wish to merge into one. Two of the 3 are of the exact same extent, cell size and CRS. The third has a larger extent (but overlapping the first two) and a smaller cell size. The issue I am having is that once I have resampled and clipped the 3rd raster to the extent of the other two they are mis-aligned, and I can’t figure out how to fix it. I need them to be exactly aligned so I can merge them. So far this is my method:Read in all 3 raster’s and ensure their CRS is the same (Using ... Resample the 3rd raster to the cell spacing of the other two (5000 x 5000) Raster 1Raster 2Resampled Raster 3Clip the 3rd raster to the extent of the other two:I use RasterExtentsCoercer for one of the first two raster’s (as they have identical extents). Set extents type to ‘Data Extents’. As I want the data extent clipping not the outer extent rectangle. Then using clipper with the output of RasterExtentsCoercer as ‘Clipper’ and resampled 3rd raster as the ‘Candidate’. It is t
I'm running into a small issue in the canvas. When I start typing "AS" in the transformer search bar, I expect AttributeSplitter to pop up, but it doesn't show in the suggestions.
Hello, I use FME Forms 2024 and I have a very basic workbench just to test the emailer transformer and the configuration of our email system.The Emailer is the following version When I run I have this error and it fails: <class 'socket.gaierror'>: [Errno 11001] getaddrinfo failed Any Idea ?Is it a probleme of mail smtp mail server accessibility. What is the configuration to adapt ?RegardsFred
Do you know the best way to convert a Raster.gdb (with 31 records and no Length or Area fields) to Vector .gdb (would have probably around 5 million records) in FME ? The only unique field is OBJECTIDI used RasterToPolygonCoercer but it is not bringing any of the attributes from the Raster dataset to the vector dataset- everything is blank Also I want the new vector data to be smoothed if possible.
Hi!I’m using FME Workbench 2022.I’m trying to insert some data in a table in PostgreSQL. The table has a composite key, like this: (id, feed_id, env_id). The table, obviously, has the constraint: CONSTRAINT agency_pkey PRIMARY KEY (id, feed_id, env_id).In FME, I’m reading from a GTFS file, doing some transformations, and then, trying to write into the DB with a FeatureWriter using PostgreSQL as Format. I have all the configurations right. I checked it so many times, and before posting this question, I talked to some experienced mates.The problem I have is, in runtime, the FeatureWriter is not adding the attribute called “id” to the insert, so the database is sending the error “null value in column id violates not null constraint”. It happens with and without bulk mode.Now I’ll provide some images for visual context and information.Flux:Data in logger:FeatureWriter Parameters:FeatureWriter User Attributes:I added the Debug to the log to see what is happening in the FeatureWriter. This i
I'm trying to reproject a DWG file from AGD 1966 ISG 56 (EPSG:102077) to GDA2020 Zone 56 (EPSG:7856). I'm using the original DWG as a template to preserve layers, colours, line styles, etc.I've set up a workbench to handle the reprojection and all the data looks good and in the correct location when viewed at the final step in the inspector:However, when I open the output DWG, most of the data is correctly reprojected (matching what I see in the Inspector) but some features remain in the original coordinate system, thus showing up in Antarctica:Zoomed in at the portion in Antarctica:I've tried several troubleshooting steps:A simple read/write workbench Writing to DXF instead of DWG Using the RealDWG reader/writer Using default DWG reader settings (no customisation)I saw this question is similar to mine, but I didn’t have any luck writing to dxf instead:None of these things have fixed the issue. It seems to mostly affect text features, although some text is reprojected correctly, so I'm
Anyone having this issue ? Even if everything is fine with the parameters in the transformer, I see the red arrows. When I zoom in / out everything is ok. Kind of annoying. I’m using 2025.1.3.
I feel like everytime I try the PythonCaller I really struggle with the scripting and usually switch to a start up script to avoid it. Can anyone help me figure out why I don’t have any outputs when I run this in my PythonCaller. import fmeimport fmeobjectsimport reclass FeatureProcessor: def __init__(self): pass def input(self, feature): """ Processes a feature to extract and set address components. Args: feature (fmeobjects.FMEFeature): The feature containing the address attribute. """ # Retrieve the address attribute from the feature address = feature.getAttribute('ADDRESS') # If the address is missing, set all related attributes to empty strings if not address: for attr in ['Suite', 'AddressNumber', 'StreetName', 'StreetType', 'Direction', 'Street']: feature.setAttribute(attr, '') return # Split the address into suite and core address parts parts = [p.
Hi,I created a parameter in my custom transformer of the following form:PARAMETER_NAME: LRF_FILEPARAMETER_TYPE: OPTIONAL FILE_OR_ATTR LRF(*.lrf)|*.lrfPARAMETER_PROMPT: Label Rule File:PARAMETER_DEFAULT: $(FME_MF_DIR)No matter what value I enter for the Parameter_Default, the file box on the transformer GUI always initially shows up empty in Form. Can someone suggest what I’m doing wrong?Thanks,Martin
Started this this help article which is written for V8i and not CONNECT but believe I've added the line styles to the seed. Drew lines set to the appropriate layer and the line styles are correct. Seed is in a ProjectWise workspace and exported for use with FME:Workbench clip:DGN Styler configuration:DGN writer:Translated DGN shows the correct line style in properties but not in the display:Re-importing line styles warns of duplicates:But afterwards the line style is correct:
Hello, the workspace is close to “Creating CityGML Solitary Vegetation Object | Community” but without the issues. I would like to randomly rotate the instances along the Z axis. Dimensions are set as in the first matrix shown below. When I use the last row to rotate, as shown in the second matrix below, the rotation is ignored and dimensions change. I tried the rotators, and the 3D affiner after defining the matrix to no good results. It seems that CityGML only looks at the transformation matrix. Any advise or workaround to force instance’s rotation is appreciated. I have a random rotation value stored in an attribute brought as an attribute of the location point. +++++ Matrix withOUT rotation +++++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.00.0 0.0 0.0 1.0+++++ Matrix “WITH” rotation? +++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.00.0 0.0 0.0 @Value(rotation)
Hello, new to FME here and am looking for some advice on which transformers might work for a workbench that I am trying to create. I have 2 road line feature classes stored in an SDE geodatabase. The lines store similar information but are created and maintained by two different departments (they have different road name standards and the geometry does not match). I would like to compare the lines and identify which ones from Roads_A are missing from Roads_B. My main concern at this point is identifying missing subdivisions like the one in the screen capture below.
I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes.I can read the full table with no problem using the ArcGIS Portal Feature Service reader. How can I get the FeatureReader to run and read the required features?
Hallo , How to Color the first column at table in PDF ?I used the PDFPageFormatter but I faced a problem that i want to color the first column at table in PDF output, which contains the attribute names,that i have created a table by pdf page formatterCould someone advise me on how to color the first column? FME 2021
Hello,I’m converting DWG to DWG using FME and I’m wondering if it’s possible to style the XREF data within the DWG. Specifically, I’d like to set it to True Colors with certain grey values.Any guidance on how to achieve this would be greatly appreciated.Thank you in advance!
I was hoping someone who understands how FeatureHolder works can let me know if I can use it successfully to help with an issue I am having. I have some workspaces on flow that had been working as expected for well over a year but recently I have had two separate ones glitch on me in the span of a few weeks.I am not 100% sure what went wrong but from looking at the log, the portal feature service reader did not read in all of the records from the table. Looking through the log, I see a line that indicates the metadata fme is accessing lists the correct number of records in the table. However, the summary shows that for that run, it actually read in less than that number.I have not yet identified what caused the reader to behave this way in these two instances. My question is:If I put a feature holder right after the reader, will that solve this problem? Will it make the workspace wait until all of the records are read in? (i.e. the number read in matches the number it was given by the
I have a transformer that pulls data and returns something like this:All values in the _count column should be the same. How would I go about determining if there is more than one unique value?
I’m using an HTTPCaller to applyEdits using ESRI’s REST API. It includes sending along some JSON to add to a table in a feature service. The workspace runs successfully testing with 1 or 2 records in the JSON parameter, which is all sent with a single HTTP call, but fails when testing with 10 records. It looks like FME is truncating the HTTP string, which causes the request to fail. That’s what it looks like in the FME log anyway; the query string appears on two lines (see attached screenshot). If I try applyEdits in a web browser at the REST endpoint and paste the JSON in manually, I can add the data without issue. Is there a parameter or formatting change I need to make to keep FME from truncating the HTTP call? (FME Desktop/Form 2023.2.2.0, build 23764)
ArcSDE Writer is very slow, taking 1 hour to write approx 60000 records. The operations is set as UPDATE and the feature classes has index on the matching column. How do I improve the speed? The Simplify geometry and validate spatial index options are set as NO
I might be missing something really obvious, but is the version of the package installed displayed anywhere?I expected it to be listed here, but that’s displaying the latest package not what is installed
I have a folder of old aerial imagery tiles with .txg georeference file. Inside .txg file, there are coordinates of the four corner. I can manually copy those corner coordinates into the RasterGeoreferencer transformer, but is there any way to automate this process and mosaic all tiles into one raster?
This is the source table. The verblijfsbagid is a unique number of a building. Where the colum leegstand = J, i want a value in the colum leegstaand_maanden. The first empty row is 1 then 2 then 3 etc. I used diffrent transformers, like neigborfinder but it didnt work.Here under is the output that i want to see (red numbers):