Transformers

Hi All,I’m having some issues to filter raster pixels by the band expression using the RasterExpressionEvaluator tranformer,What the expression to select the pixels with the following band combination B(0)=64; B(1)=128;B(2)=104? I have used the following settings but hasn’t worked: Any ideas please? :)

I’m wondering if there is a way to add vertexes (point) to polylines at a certain distance. Lets say I have a .shp layer with several polylines. I also have a table with “errors” that have occurred somewhere on these polylines. The table have the following attributes:Column 1: Line name (containing the names of the polylines in my .shp layer)Column 2: Distance measured from XXXX (containing names of stations that connect to the polylines, this is where the distance is measured from)Column 3: Distance (km) So basically i know the exact point from where the distance is measured from, I know which polyline the error has effected, and I know the distance. Can I automatically map this out? 

Hello, I want to know how to use PointOnAreaOverlayer for a layer with more than 1 polygon.I have a polygon shapefile for Canadian provinces and a point shapefile for Canadian addresses. Both have the Province name attribute.I want to check if all points that fall in a polygon have the same name as a polygon. For example, I want to check that all points in Alberta have the province name, Alberta. I used the Grouped By Province name, but it did not work.I appreciate your assistance with this transformer or any suggestion for this test. 

Here’s the process I’m trying to implement:I have a scheduled job that backs up a SQL database weekly. I’m using FME form/desktop to drop that .bak file into an FTP. I want the file I upload to have a dynamic date (date when the job runs and drops the file). I’m not sure how to go about this step.  

I am basically doing AttributeValidation but am looking to find values that are blank or empty. Looks like I can't look for blanks or empty's within the AttributeValidation transformer. So, right now I have a testFilter that is checking each field if it is blank or empty. I am using a TestFilter because then I can specify each of the fields that I want to be checked. The problem is that if one record goes through the tester and on the first test we find out that field is blank, then I believe that same record will not go through the rest of the tests. I need to know each field is blank, not just the first one. I am looking for a suggestions on how to do this efficiently. I am basically running a QC process on a large dataset. We have a bunch of business rules that need to be followed. So I am setting FME up to check all those rules. If a rule is broken, then an email will be sent to the person that introduced the error and then they can go back and fix the error. So this one st

I would like to count the rows in a (Oracle) database table and then write that row count to the Translation log.This is so that I can quickly compare the row counts of two tables against each other (as a quick way to determine if an update has occurred)I can use SQLCreator to count the rows of the tableSelect count(*) as COUNT from TABLEThis places the count as a value in a column that is output from the Result of the SQLCreatorMy question is, how can I write this value to the Translation Log?I assume I use the Shutdown Python script. But how does the script read that attribute value?

As I am newbie in FME software I’m looking for a help.I have two sources with lines and I have to point the places where lines are not connected.Is that possible using some transformers? Please look at screenshots and data I’ve attached.   

HiI am currently looking to create a CityGML model of the buildings in a specific area using various spatial data. I have followed this tutorial Point Cloud to 3D Terrain Model with Buildings and obtained an Adobe 3D PDF model of the buildingsBut I now want to convert this model into a CityGML LOD2 model. Is this possible?Since I have just started using FME and am not very familiar with the software, what should my next steps be? Could you provide some useful references? Thanks for your advice😊

I have a segmented column (basically stacked barrels of varying height) and 3D points “floating” within that column. How can I join the points to their containing segments? I made a few attempts but the results suggest FME only checks for X/Y and not Z.By join I mean the solids acquiring their corresponding points’ attributes, looks like the weird “x-on-x-overlayer”, etc, transformer names unfortunately survived the overhaul 😒 (unrelated: signing up with a too long username gives a wrong “not allowed characters” error in the sign up form)

Hi,  When creating offsets from a line in DWG - is it possible to use an excel table for the offset distances?  Excel table is 2 columns (“offset #” and “offset distance”) and 100+ rows (offset-1, offset-2...) containing negative and positive numbers. I looked up offset related posts but couldn’t figure out how I could make excel work. I am using 2023.2 version and the offsetcurvegenerator has left/right inputs. Do I read the excel, then split it into positive and negative, then connect them to left / right each?    

Hello, I have a master survey layer on ArcGIS online that will be continuously updated during the summer field season. I also have a master environmental layer that on AGOL that needs to be updated daily from the master survey layer. I know the steps to do this (attribute manager, change detection, etc) but I am running into problems when trying to ensure the attachments from the survey are included when appended to the master layer. The attachments do not transfer and we need those pictures in the master layer. How can I use FME to set this up?Thank you. 

Hi folks,I have the following error when I run my Workbench project : 2020-04-17 08:05:41| 785.3| 0.0|ERROR |SpatialRelator_15_Output Feature Recorder -1 2147615062(RecorderFactory): File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR |File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR | I've read some other articles about similar posts here, but I did what was suggested (FME Options > Translation > Log Message Filter and unchecked "log Debug") I'm using an FME Professional Suite (FME 2018.1.1.1, build 18578 - 32 bits). Even in a 64 bits version, the error message is still there. You can see that it begins to write datas, but then stop.The log file is attached and the error messages are line 9611 and after thank you for any help ! Patrick  

I am trying to to transfer records with jpg file attachments between two seperate AGOL hosted feature services. The source has also has point geometry which is stripped out prior to passing into the target table. I've been able to create the target table by using the AGOL feature writer, but I'm unable to access the attachments - even though I've exposed the attachment attributes and ticked the "include attachments" parameter in the feature reader.Does anyone have a working example of this transformation?Thanks in advance,Brett

Hi,I have multiple features, for each I need use an Oracle sequence to get the ID of the feature.Then I need to write the feature to the database. The ID must be unique.I have used a SQLExecutor to obtain the sequence next value. I am struggling when there are multiple features to write. FME is executing the SQLExecutor multiple times before getting single value for the ID. I need to process each feature at a time i.e. run through SQLExecutor, get the feature ID and write feature to database, then proceed to next feature. Any suggestions ?  

 I want all columns from the excel sheet in the table, not selecting them one by one in the column settings, is that possible?

Enverus’s Developer API has a custom header option to change the location of next link from the header to the body. When I put X-Omit-Header-Next-Links in the header of Postman I get the expected response: Results from Postman​​​​​putting X-Omit-Header-Next-Links in the header of HTTPCaller seems to be ignored as no next link is in the response body and the link remains in the response headers.HTTP Caller with X-Omit-Header-Next-LinksBottom of response body in FormReturned API header attributes in Form​​​​​Am I doing something wrong or has anyone experienced this behavior?Thanks in advance,Randy

Another one from my daily work:Is there any chance to find “spikes” in elevation to avoid situations like this in 3d view? I already found that there is spike remover but my job is to only find them.Red lines are bridges and they should look like a little bit smoother :)Attribute which they are based on is “F_ELEV” and “T_ELEV” Please help me with identifying such situation using FME.Shapefile with this situation: 

Hello everyone,Based on the following video I was delving a bit into the Classifier transformer in combination with the FeatureColorSetter and I was quite pleased with the possibility of coloring polygons based on a class.I assume making maps such as traditionally done in arcgis pro, is currently not possible in FME.However, since it's now possible to create chloropeth maps or give classes random colors now based on classes generated by the Classifier Transformer, I  was thinking it might be a nice step in the direction of being able to create maps in FME. My wish would be as follows:You could for example use the classes id (generated by the Classifier transformer) and a label for the classes id to create the legend for the map.A title can then be filled in by the user and maybe a scale bar can automatically be generated based on the extent/coordinates of the data. Moreover the user can move where the following objects should be placed on a landscape/portrait on some kind of preview sc

I have a dgn Model and it’s meshed there are some mesh elements in the model but FME is not recognizing them. AppearanceRemover is rejecting them, Geometry FIlter is returning them as null geometry. These elements are visible in microstation and looking absolutely fine. MISSING_GEOMETRY_APPEARANCE  This the rejection code from APpearnce Remover and if I skip Appearnce Remover and pass it to geometry filter it returns the featurs as Null.

Hello everyone.. i am trying to use the GIS functionality of Union 3d in the FME. can you please advise which transformer can support this , since the normal union and joins  for features and data will join data level. below is the Union 3D functionality of GIS ESRI.https://pro.arcgis.com/en/pro-app/latest/tool-reference/3d-analyst/union-3d.htmthank you in advance. 

Hello guys,Has anyone ever encountered the following problem: I need to find such situations in my data. It’s not a typical gap between polygons and that is a problem for me. Let’s call it “partial gap”. Maybe someone already had similar problem and found a solution?Thanks in advance!Shapefile with this case: 

Trying to extract data via a CRM API. Stuck (401 errors for authentication in the FME logs) on our internal CRM api with FME. I can query the API using a web browser after authentication. I've also tried without success to authenticate with FME's ODATA reader with a similar authentication issue.the URL example is:https://MYSITE/api/data/v8.1/TABLE?When login works in a web browser there is a redirect (an active directory account is used) i believe this is using OAuth2 authentication.Any advice or hints would be appreciated. I have reviewed other posts on this form but have not been able to find a solution. thanks for the help!

Hey,Is there is no transformer for Geocode in Transformer gallery rather than take it from hub 

I’m looking at a workflow wherein the start point is this: Underwater photo manually copied into Powerpoint Measurement grid overlaid Percentage cover of different plant species estimated by eye Results copied to ExcelI haven’t dabbled in CV at all within FME, just read this blog - and this may be jumping in the deep end - but am wondering if this scenario might be a candidate? 

Hello,  I am struggling to read a very simple table from a PDF, I just want to have something in the output. I have turn on only the "Read Tagged Tables" in the Reader's parameters, but nothing is coming out from it. The reader is not being created in my window. I have created a special table from excel in PDF to be sure that the table was fine. It looks simple in the FME presentation... https://www.safe.com/convert/geospatial-pdf/excel/ Could someone git me a hint about what am I doing wrong?  Thanks! My simple PDF with its readable table: My Reading parameters: