General

My project covers the whole state of NSW, and the workspace has many many transformers. What I want to know is how to lock the bounding box of the map in the Graphics View. If I'm debugging one particular area of interest, the map jumps to some sort of saved view for each and every transformer. I spend the day zooming and panning the map to get back to my area of interest. I click another transformer to see what the data was doing at that point. then have to zoom and pan again to get back to my area of interest. What I want to do is lock the Graphics View to my area of interest. I can see the hover for "2D" button is "Lock the current view in 2D", but it doesn't lock anything consistently. Sometimes it even centres the map on another state where there is no data. Other times it drops me in the ocean and I have to zoom out until I see land, pan, and zoom in again. Is it possible to keep the bounding b

I have excel file where i need to separate all columns please help me out

I have read many posts and articles about FME and geodatabase domains, and nowhere can I find any mention of reading the domain name. I can resolve the domain code for any given feature, getting the <attribute>_resolved value. I am pretty clear on how I have to go about extracting all of the domains in a geodatabase. Given a full domain definition, I can create the coded_value(...)-formatted native_data_type value for a schema feature; however, I can find no reference to how to extract the associated domain name for a feature class in an existing geodatabase, at least with pure FME. This seems nuts, and I feel I must be missing something fundamental. Anyone have any pointers here? Any help is much appreciated.

We have a workspace on FME server (2021.2.6) with a published parameter ProjectName.We're submitting jobs through the REST enpoint, using json for the parameters.Now we have a project name with an single quote (apostrophe), like:A'damThis results in a code 400 - bad request. So, what is the correct way to send this string in the json? What we have tried:A%27damThis works, but then we need to decode the string in workbench.A\'damThis works, but server interprets this as as a double quote.A"damWe also tried to replicate this in submitting a job from the fme server interface but then the parameters are sent as form data, not as json...

My workspace isn't complex yet if I make a small change inside and AttributeManager, FME Desktop hangs for a good minute. The CPU does spike while it hangs.Has anyone else run into this issue before? This is a clean install on a beast of a machine so I shouldn't think its resource related.

I have a large XML (4GB+) I have trouwble to read. I need all elements, however: pand_bagpandid (2) only becomes a feature when it's the only element selected. If I check 1, I get alle elements execpt pand_bagpandid, when I select individual elements (3) I still get all elements except pand_bagpandid, if I only select pand_bagpandid I do get it, but I don't get any of the other elements. I am inexperienced with xml and have ben struggeling with this for quite a bit now. The xml fragements show the same behavior. Flattening, fragmenting or exposing attributes didn't work for me either

Hello FMEers,Here's your weekly dose of news from the world of FME. Scavenger Hunt ResultsThe Scavenger Hunt just finished and the results could not have been closer:  Team Nordend won from Team Zipster by just 65 points. And it wasn't just close in points, it was also close in time. Team Nordend made the winning submission just seconds from the game closing. I thought that was a deliberate tactic, but it appears that they really did get the winning solution at the last second:  So congratulations to them, Team Zipster, and Team Transformer - in fact, to anyone who participated. And thank you all for taking part. The whole idea was to learn a little about FME wh

Hallo FME community,I want to know how to overwrite existing shapefile file and FGDB. With CSV it's clear but with shapefile and FGDB I can't find an option to overwrite.  

This is likely a simple question: I have a workspace set up to read, sample, clip, sort and combine Sentinel-2 data into a single raster with 9 bands. It works fine. The default band numbers generated by RasterBandCombiner are 1-9, but I'd like to name the bands based on the original Sentinel-9 band numbers as displayed in the original rasters. Is there a simple way to designate the raster band names using something like the fme_basename?

An error occurred while attempting to insert a row into the table 'UNSARE' using a cursor. The error number from ArcObjects is: '-2147216063'. The error message from ArcObjects is: {Spatial index grid is too small [HARBOUR.UNSARE]}

Hello,I am trying to read multiple excel files that unfortunately don't come very clean, meaning that the headers are starting on the third row while the first two rows are mainly blank. So I used the "Directory and File Pathnames" reader to pull all the excel files that I need and then connected it to the Feature Reader but the "Attributes to Expose" doesn't work as I don't have headers on the first row. I attached a snip of how the .xls files look. Basically I would need to somehow skip/delete the first two rows and read from there. Not sure.  Can anyone advise on this one? Many thanks!

We have been asked to audit all of our systems to confirm whether JAVA is being used. We want to confirm that we are compliant in licensing regarding anything Java. Thanks!

Quick a simple question but one that has stumped me.I am trying to remove all of the data that has been pulled into FME from a shpfile on AGOL. The aim is to later replace this removed data with new data in same shpfile before reuploading this to AGOL. So I was wondering whether there was a tool that was able to be used just to remove the data while leaving the columns itself.

I'm trying to extract data from the website https://www.tax.service.gov.uk/check-council-tax-band/search. After submitting a postcode (e.g. LS26 0AG) it returns a coded URL with results, which I want to extract. I've got the last part (extracting the results) working well but I can't figure out how to use HTTPCaller to submit a postcode and get the URL that is returned. The form name is "postcode" but when I set it up and run I get a "HTTP/1.1 400 Bad Request" error. Can anyone help please?

I'm buffering a points shapefile, then using the resulting square polygons to clip a raster (vrt OS backdrop). The clipped rasters are then passed to a PDF PageFormatter to produce location maps for each point. My problem is the raster outputs once written to PDF seem to move - placed in relation to the location of the point. how can I force the rasters to be drawn in the same place on the page everytime?

Hello everyone, I have a shapefile with polygons (neighborhoods) and a shapefile with lines (waterways). Each polygon has a specific code attached to it. I want to provide each line with the code of the polygon it runs through. When the line runs through several polygons, it must get the code of the polygon through which the line runs the longest.  Does anyone know how I can best handle this? Regards Bas 

We have a large GeoJSON file, we need to "cut" it in multiple geojson files equal in "size", like each resulting file would be of 1200 meters X 1200 meters and named in a X,Y manner, like "1.5.geojson" and "2.7.GeoJSON". Is there'S a way to do this with FME ?

Hello,I am struggling with what I am sure is a very simple thing but one that I cannot sort out. I am using Path to search for specific files in a directory which I then read with the Feature Reader. Thing is, I need part of the path_rootname as an attribute to use forward but I cannot seem to be able and extract it. I created "Year" as per the snips but I don't know how to use it forward. I only get the values from the Generic port but for "Year" I get <missing> for each row. I can see the "Year" attribute in the <Schema> port (and it shows up correctly) but I do not know how to pass it on to the next transformers. I tried connecting the <schema> port along with the <generic> one but it doesn't work. I also tried attribute exposer, attribute creator but no luck. Any ideas on why this isn't working? thank you!

I am generating a weekly Excel report and I wish to dynamically add a new column every week containing last week's data. Also, I need the column name to include today's date, for example - 'Outstanding work 04/10/22'. Is there a way to achieve this?

I have one table where id already there now what I want is when I push the new data it will generate an automatic id  for example the Table ID is 47 and when I push new data then that table insert from 48 in ID columns I use a counter to generate the ID from new data and then I use the static calculator from Table so it gives me a max number of 47 and when running that wS then it's not generate the ids

Hi! Is it possible to slice 3D objects at a specific height?  For example, I have a 3D model from a building, and I'd like to know what the exact outer bounds of the house are at +2m above ground level.  Thanks,Mark  

I am using Treesize to search company folders for GeoTiffs and want to add to a map to view coverage. I need to have a function to add these Geotiffs from the file path outputted by Treesize. 

I trying to insert the record on the Exiting table but it's giving me null values with successfully

I have a folder with multiple text files.I need every file to be read and parsed, then I need them to be put into an excel file. for every file there needs to be a sheet. Noteworthy is that I need to be able to do this in different folders. I don't always know how many files there is but it can be everything from 1-1000 (very unlikely that it is 1000 though).  I can't seem to find a good way to do this. I think its best if I just show you an example of the text file, images below. FME might not be well suited for this, I know I can do this in VBA in Excel, But I really want to do this in FME because it is way easier to share it with colleagues and more reusable.  This is what I have, this is how one text file looks like:1: I need the file name to be the sheet name.2: This is meta data, I need this to also be in th