Transformers

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:

I have a collection of photos and a point layer in SHP (Shapefile) format. I aim to replicate the functionality of 'Enable Attachments' from ArcGIS Pro. Specifically, I want to associate each photo with its corresponding point on the map based on matching the photo file names with a column in the point layer. Is that possible? What transformers should I use?

Am sure am missing out some step or obtain right setting. I am trying to extract points that fall inside or intersect 3D Cube .  I am also getting points as an output that are not within 3D Cube .     Please note: 3D is cube is multi-surface with different shapes and its IFC file.  I shall be highly obliged with FME Community expert to help me with their know-how and expertise to bridge that missing part / thank you for support and time.  

I am new to JSON, I’ve read the guides on here and have tried several ways to sort this without success.I’m using a JSON Reader to read from a file.The table has just three columns: OBJ; TIMESTAMP; and PK1.However, there are 114 attributes I can see in the Feature Information window which I need to bring into the table. (I am hoping ultimately that I won’t need 114 attributes!) As you can see I have tried the 4 transformers listed but without success. The answer might be to configure one of them correctly or link one to the next… but over to you clever folks to see if anyone can come up with the answer.Thanks in advance for any words of wisdom. :-)  

Hello every one i have excel file saved in microsoft sharepoint, i need to read this file and update some attrbute without dowloading this file to my pc and update and upload again, i need to read and update directly in the file Thanks

HiWhile converting an existing chain of workspaces from 2022.1 to 2024.0 version i ran into this issue:The current FME process locale has been changed from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to call 'setlocale()' in plugin code and doing so may cause unexpected errors..Python version 3.12 loaded successfullyPython: There is a known Windows bug that may cause instability when using Python in the current locale. Please update to Windows 10 version 2004 and greater, or to Windows Server 2022. See http://fme.ly/nw5 for more detailsC:\Users\%username%\AppData\Roaming\Safe Software\FME\Packages\24187-win64\python\safe.azurestorage\azure\storage\blob\_deserialization.py:657: SyntaxWarning: "is" with 'int' literal. Did you mean "=="?  elif num_empty_lines is 2:Message Type: fme::internal::_v0::py::ExceptionPython Exception <Error>: unsupported locale settingPythonFactory failed to load python symb

Good morning all - hoping that you can help me; I’ve got a fairly lengthy workbench which we run daily updating our internal data warehouse from a variety of sources. due to the complexisty, there are several no features testers included in the workbench which continue the translation when no data feeds in at certain points. However, there are certain instances where we would want the translation to stop (no new source file available, source system not ready for update etc.). We currently use terminators in order to stop the subsequent no features testers from triggering - however it would make it easier for us to keep on top of our monitoring if this didn’t then appear as a failed job in our server log - is there any alternative way of stopping the translation without it appearing as a fail? 

I'm building a data validation tool and utilising the AttributeValidator heavily as part of the process. There are a couple of attributes that are "optional" but have an associated list of valid values (field validation/domain). This means they are allowed to be null, but if they have a value, it must be one of the pre-defined valid values.  I'm hoping to use the Conditional Value option for Rule Configuration as below:  However, upon running the workbench, FME terminates and the translation fails immediately due to "unbalanced quotation marks on line XXXX of file <workbench directory>\\wb-xlate-1700200438336_13788". Is this a bug or is my conditional value rule configuration just incorrect?

In my scenario, I have an FME script that performs data validation. If the data is valid, it updates the database. However, if any records contain errors, I want to capture those records in an Excel file for users to review before uploading the data. In this error case, no data will be updated to database. So, the logic I'm aiming for is as follows:Validate the data. After validating all data, capture all invalid records to an Excel file. Then, terminate the FME script without uploading the data to the database. If all data is valid, proceed to upload it to the database.I've attempted to create a flow with a terminator, but the Excel writer doesn't have a connector. Connecting the terminator to the output port of the TestFilter after validation would terminate the writing of the error Excel file as well.Can anyone provide suggestions to solve this issue?

I have two point files and need to identify the nearest point in file A to the nearest point in file B, however the matching must be unique. Meaning once a point in file B is matched to a point in file A it cannot be matched to any other point in file A.I can match them using nearest neighbor but don't see a way to restrict to eliminate duplicate matching, so I end up with the same point in file B matched to multiple points in file A.

Hi All,I’m having a bit of headache to read all the SHP included within a ZIP through the FeatureReader transformer, I’m getting the following error Shapefile and cannot be read for some reason. I can reader it with the normal SHP reader but can’t get it to work on FeatureReader, here is a screenshot of the settings: What am I doing wrong? 

Hi all,I have a 15 minute timestep data which has random missing values (expected). I’ve managed to track where the data has gaps, but in order to calculate a consistent rolling 24 average of the value I need to fill these missing gaps with a timestep but null value (so i can calculate an average from the preceding X values)Does anyone have any suggestions on how to fill these data gaps automatically? Or better still calculate a 24 hour rolling average using specific timesteps rather than just number of rows? Thanks 

I have a SHP file with geometry. It has an attribute called 'id_alt.' I would like to extract only the values of this attribute. Is there any way to convert these values into variables that I can use the value use with TESTER after UUIDGenerator to filter my data? Alternatively, what is the most efficient method to achieve this with FME  

I have an attribute containing String values such asGladstone RegionalSouthern Downs Regional, Goondiwindi RegionalMoreton Bay City, Noosa Shire, Somerset Regional, Sunshine Coast RegionalI want to replace the last comma with “ &” so that the output will look like thisGladstone RegionalSouthern Downs Regional & Goondiwindi RegionalMoreton Bay City, Noosa Shire, Somerset Regional & Sunshine Coast RegionalIs there a way to use a Regular Expression inside the StringReplacer transformer to accomplish this?