Best Answers

This must be very basic but I discover FME and I couldn’t find how to do yet. I would like to find the value from the next row in the table to use in a transformer later.  For example: I would like to fill in the column C with just the informations from the column B. Can I do that in the TextEditor by saying something like “colB” +1 or “colB” NextValue?  

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

Is it possible to change the timestamp information that is included in the log file to UTC? I have been looking for a setting, but have yet to find one. This would be for the log files created in Form/Workbench, which currently log the time as local computer time.

I am clipping a raster by a polygon, but it sometimes seems to skip parts, I have the clipper set to Candidates on clipper boundary set to Output as Inside.  I know this poly crosses 4 cells, so this is what I was thinking would come out of the clipper Inside port  But instead I get this Any thoughts why it is skipping that one cell?  This is a single band raster and all these cells have data 

Hello FME enthousiasts, I've been building a simple workspace for a collegue to get some parcel data from a public WFS. When I run the process it all seems to work (i get the desired parcel written to a File Geodatabase). But it keeps giving a single WFS error in the log, but the error apparently doesn't stop it from running:<WFS> GetFeature URL: `https://service.pdok.nl:443/kadaster/kadastralekaart/wfs/v5_0?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&TYPENAMES=kadastralekaart%3APerceel&FILTER=%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3EAKRKadastraleGemeenteCodeWaarde%3C%2FPropertyName%3E%3CLiteral%3ERNN01%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esectie%3C%2FPropertyName%3E%3CLiteral%3EK%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Eperceelnummer%3C%2FPropertyName%3E%3CLiteral%3E36%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FAnd%3E%3C%2FFilter%3E&OUTPUTFORMAT=app

Hello,In FME 2023 , in the AreaOnAreaOverlayer transformer the tolérance = “None” parameter has been removed. There only option of “Automatic” or “Custom value”.Question : if there was Tolerance = “none” in pre FME 2023 .fmw scripts, should we use Custom Value = 0 to have the same result as tolérance = none  or “Automatic”?Thanks

We generate certain types of transformers (mostly HTTPCaller) with some attributes prefilled and want our users to be able to copy the content from a file or web source and paste it directly into FME Workbench, or use drag and drop, if possible. We don’t want to use custom transformers, which works, but the overhead would be overkill. The problem is that the paste does not work, CTRL+V does nothing and the paste menu option is greyed out. I tried with a direct clone of a working transformer so the format is correct. If I copy a transformer, paste it into an editor, copy the editors content and try to paste it back to Workbench it won’t work. I don’t know why this does not work but I persume it might have something to do with encoding. Does anyone have a clue how to overcome this issue, or maybe a workaround? Thanks in advance.

Hi, I have this dynamic setup where a postgres FeatureReader reads the schema and the results are written to another database using this schema information to create the new tables. However, a table having colums of type unqualified varchar will be regenerated with varchar(80) and if records are loaded having length >80 the workspace will crash, saying: Error was 'ERROR:  value too long for type character varying(80)I attached the workspace. Is this a bug in FME or am I doing something unbelieveable silly?😕 I'm using FME(R) 2020.2.3.0 (20210129 - Build 20820 - WIN64) on a postgres 12.9 (Ubuntu 12.9-1.pgdg18.04+1). 

Hello yet again 😅I’m GET-calling a an online database through HTTPCaller which responds with giving me a feature in WKB code (in _response_body), then I run the respective code through GeometryReplacer and tried different WKB Encodings in attempts to get a geometry out of it (this should be a polygon), but no luck.The following encodings give me this:Hex Encoded FME Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) OGC Well Known Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) Hex Encoded OGC Well Known Binary: Ends up in Output and thus not in the rejected port but it does not create any geometry feature that can be inspected.The code is following, so if anyone has seen this before or is enthusiastic to figure this out with me then feel free to investigate:0010300002084080000010000000E000000931E86C64699244192E9D0891B741D41DBF97EF242992441C3F0110102741D41F4A963551A99244180F3E2341E741D41F4531C970F9924415EBBB401E0731D41AED4B380CF982441BF9A03840B741D41001E5119CB982441BB0A294FED73

Hi.I have another string replacer question.I have a file of text strings (appellation) similar to LOT 1/2 DP 17528 LOT 1/2 DP 13552 RS 16932 18812 19986/7 PT 18813 20862  BLK IV KAPUNATIKI SDI have split the LOT 1/2 DP 17528 & LOT 1/2 DP 13552 into 4 separate rowsTemp, _result, appellationLOT 1/2 DP 17528, LOT 1 DP 17528, appellationLOT 1/2 DP 17528, LOT 2 DP 17528, appellationLOT 1/2 DP 13552, LOT 1 DP 13552, appellationLOT 1/2 DP 13552, LOT 2 DP 13552, appellation What I want to be able to do is remove the temp part from appellation  The resultant appellation in this example would be: RS 16932 18812 19986/7 PT 18813 20862  BLK IV KAPUNATIKI SDI have tried doing this but only ended up removing one part from each instead of both Temp parts. I would be very grateful for any help with this.Regards, Paul

Wondering if anyone can tell me how to clean up the recent files list on the fme form start page,Any clues appreciated, I have a long list of old files I was sorting out, now would like to clean up the recent files list on the start page.

Hi everyone,I’m hopeful somebody here will have seen this behaviour before and can help me to understand what’s going on. I’m getting an error when trying to decode some Base64 documents that have been read out of a system but I’m not sure why and I’m not sure I can easily create a sample workflow to demonstrate it, as I’ll explain.The task is to extract specific documents form an API connected to a document management system. I’ve been able to create a workflow that will identify the required document IDs and then extract the documents into feature attributes for me.The document data that is returned to me is in Base64 format. When I post the output data into an online conversion as a test, it is converted into a usable image (in the case that I tried). From this I assume that all other documents will work similarly.When I pipe that output into a BinaryDecoder and ask it to decode the Base64 attribute, it throws an error complaining about the input.When I copy the Base64 code and add

Hello FME community,I would like to write the values ​​of a list into a column. I would separate them with a minus. It may be that the list of a data set has 1 or 2 or three values.If a list of a data record has no value, no minus was written to separate it. I am attaching 2 pictures to understand it better.  

I am creating a series of small jpeg files using a feature writer with each jpeg getting it's name from a unique value (myRLU_@Value(RLUOID)). I recently upgraded to 2022.1.1 from 2021.2 - things were working until I upgraded. I have 20 records coming into the FeatureWriter and 20 showing in the Summary port but no records passing through the output port.The FeatureWriter creates the jpgs but does not pass through the records to the testfilter transformer? Has anyone else had issues with this in 2022.1.1? Any ideas how to get this running again? Could this be helpful in diagnosing the issue: FeatureWriter_5: Bulk features are not supported because the expression contains a function call After playing around some more - looks like the issue is the FeatureWriter using an attribute as the output filename. When I change it to a "hard-coded" value, the records are available in the output port.

Hi All, I have a list of data features like thisName   Phone Number   CitySmith   123-456-7890     New YorkBob      987-654-3210     HustonIn addition, I have a single lookup feature like thisCompany   Idxyz             123I would like to merge the lookup feature into the list of data features like thisName   Phone Number   City             Company   IdSmith   123-456-7890     New York    xyz             123Bob      987-654-3210     Huston       xyz              123 I thought I can use transformers FeatureMerger or FeatureJoiner to do this. However, since I don’t have a common attribute to compare, neither of them works. Can anyone help me on this issue here? Thanks,-John

Hello everyone ,i am currently working on Lidar data , i am reading a set of points from a json file and creating vertices based on the coordinates.here is how the json file containing the Lidar data looks like :  (a bunch of (x,y) set of points)in order to make use of FME point cloud specific transformers i need to convert these points from point geometry to Point cloud geometry , any idea on how i could do that ?Thanks in advance

Hello Forum, I have an externally supplied dataset which includes a street name. Some of the street name entries are all in lower case (e.g.: royal road) where it should be Royal Road. However some entries are fine.This is part of a larger regular data process, so I’d like to build in a process that fixes street names to proper upper/lower case (e.g.: royal road would become Royal Road). Is this possible in FME Form?  Thanks,Stuart 

Hi, I‘m stuck at a simple point. I want to make the AttributeKeeper filter from @Value or a User Parameter which is created by the AttributeCreator. Is it possible? I don't find a solution.The goal is to get more attributes late in a row: test_2,test_4,_test_x in the AttributeKeeper from the AttributeCreator/User Parameter.  

I would like to visualise data on the inspector data or in the graphic view after I reprojected it. That would be in the middle of a workspace before using other transformers and just to locate some features. I know it’s possible to write the data in a shape and check the features on another software like QGIS or ArcGIS but I would prefer to do that in FME directly if that’s possible, when I’m building my workspace. Can I do that?

Hello, I have these dataArea Category Date A  Medium  202301 A High 202305 B Medium High 202306 B Medium High 202305 B Medium High 202304 B Medium High 202303 B Medium High 202302 B Medium High 202301 C Low 202306 C Low 202305 C Medium 202304 C Low 202303 D High 202306 D Low 202305 D Low 202304 D Low 202303 E High 202306 E High 202305 E High 202304 E Medium High 202303 E Medium High 202302 E Medium High 202301 I want to count the categories that occurred 3 or more times consecutively per area. So something like these Area Category Count Same category consecutively >3 A    0 B Medium High 6 C   0 D Low 3 E High 3 E Medium High 3  I am not sure how to do it in FME. Thank you!

I want to allow selection of multiple records from database in user parameters.For example, I have records a,b,c etc  in a list and I want to select records a and b to be used in FME  workflow. How can I allow user to choose records a and b? 

In a FME Flow Workspace App can users log in.How can I get the username as a variable in my workspace. Each user shall read and edit diffrent datasetts.  

Hello, I am using a "Directory and File Pathnames" reader to pull shapefiles from a folder. I then walk them through a tester to filter out the files that I do not need. All good and working up to this point. The goal is to work on those shapefiles and have a processed shapefile as an output, in the end.  After the tester, I send the "passed" ones to a "FileReader" that outputs the desired features under the <Generic> port.  My question is: how can I write those out and keep the geometry + attributes of the shapefiles for future processing?   I can see them in the Inspector but I cannot figure out how to move on to the next step as the only attributes I see imported to any transformer I add, are the ones from the "Directory and File Pathnames" reader, not the shapefiles themselves.Long story-short, I want to use the shapefiles that passed the "Tester" as readers. 

Hello! I currently have a stored procedure in MSSQL that takes in some parameters and inserts into or updates a SQL view. I’m using a SQLExecutor transformer to run that stored procedure, passing in the feature attributes from FME as parameters for the procedure. The code in the transformer looks something like this:EXECUTE [schema_name].[procedure_name]   @id = '@Value(id)'  , @name = '@Value(name)'  , @description = '@Value(description)'And the stored procedure looks like this:ALTER PROCEDURE [schema_name].[procedure_name] @id nvarchar(100), @name nvarchar(250), @description nvarchar(250)ASBEGIN IF ((select count(*) from [schema_name].[view_name] where id=@id) =1) BEGIN UPDATE [schema_name].[view_name] SET name = @name, description = @description WHERE id = @id END ELSE BEGIN INSERT INTO [schema_name].[view_name] VALUES (@id, @name, @description) END Generally this works, but some of my attribute values (eg name and description) are long blocks of text with various s

I have a process which creates 4 asc files, and then sends them to a zipped file. At the end of this process, this file is to be emailed. I have an attribute creator which creates the file name as ‘attachment’, as it does contain dynamic elements, before using that attribute as the attachment field in the emailer. When i run it on my local computer, it works perfectly fine, and I get an email with all four files zipped. However, when i run it on FME server, the zip file only contains 1 of the four. Regardless if the files have content or not, they should all write to the folder, and then do, i can see in the fmeserver directory, that all 4 files have been zipped up, but when it is emailed, it just seems to delete three of them. The sampler is there so it only sends one email, but the attribute creator refers to the zipped file, which is created in the system caller, so all four should be sent.