General

Hi, I'm trying to make an html report using the awesome HTMLReportGenerator transformer, I've been able to do some customizations for better results, but when it comes to the charts that the report creates, I'm still not sure how to increase the width it occupies, to get a graphic distributed over the entire page space. I've been reading the documentation for chart.js a bit, which is the js library that this transformer uses to generate the charts, but still haven't found the answer, does anyone know how I can get a larger chart? I have attached an image of the current report that I can generate and as you should see it would look much better if the chart took up all the space, I already moved the legend to the bottom so I have room on that side. Thanks!

Is there any tool to calculate real surface from DEM which similar to this tool from SAGA http://www.saga-gis.org/saga_tool_doc/2.1.3/ta_morphometry_6.html? It mainly takes into account the slope while calculating the surface area! Thanks in advance

Hi, I have a NetCDF file, exported from flood modelling software, that has the timesteps stored as seconds since the flood event started. I am wanting to read and use a timeslider in ArcGIS, but it seems that I require a valid StdTime format for the timesteps. In FME I am attempting to add a 'fake' date on to the start of the seconds value and convert the timestep format to make this work.The timestep is located in a matrix(?), i.e. as netcdf{}.coordinate_variable{} Anyway I think I have to explode the netcdf list so I can add on the date to the coordinate_variable list. This is fortunately always {0}. After changing this value I then rebuild the list and join it back to the original features (after removing the list attribute from the original feature).However I am getting the following error when trying to write to the output NetCDF file.NetCDF writer: Multiple bands have the same permutation of dimension values. Please ensure tuple of values specified in the netcdf_band{}.c

Hey guys, I have an CSV file where I have 4 different columns with values (column1 till column4). I'am creating in the attribute manager a new columns (column5) where I connect all the values of the first four columns with a point in between.   For example  ```column1, column2, column3, column4, column51, 2, 3, 4, 1.2.3.4```  `column2` has the special that there are numbers from `1` til `99`. I want to put infront all values of `column2` which are from `1` til `9` a `0`, so that it looks like the example. But already two digits numbers should not get a `0`.   For example  ```column1, column2, column3, column4, column51, 02, 3, 4, 1.02.3.4 3, 65, 5, 9, 3.65.5.9``` How can I manage this? Has anybody a clue? Or could somebody help me please? Thanks in advance! Have a good day! Cheers, Fabian

Dear FME community, I have attributes which contain numbers with several integers like 5800386.006999999 as values. I would like to round these values in steps of 500. So the number above becomes 5800500. If the value is closer to e.g. 5801000 then it should be rounded to that number. If it is closer to 5800000 then it should be rounded to that. The values can have a lot of decimal places or none. This means the solution should be able to handle any given number.  I am very thankful for any help. Thank you so much in advance!

I have a 2D point dataset with elevation information. They are not evenly distributed on the field. However, I would like to create a DEM based on the information I have. Which steps should I follow? My final goal is to calculate the Surface Volume. Therefore I need to generate a DEM. Thanks in advance.

Hi, I have a map with different territorial (regional) authorities and heaps of points (around 2000 points) representing each of those territorial authority. Question: My idea is to use the FME to reduce the number of points (or smooth the geometry) of each territorial authority. The reason behind doing this is.....I want to use that map in another geospatial software .....where with current number of geometry points it's hard to zoom in or zoom out the individual territorial authority (it takes long time to look into individual territory). I don't know which transformers in FME should I use to do this process...any suggestions on this will be really helpful.

Hi,I want to group materials and pipe length according to different age barckets (of say 2 or 5 or 10 years)...how could i do in FME?Please see my sample data: 

I am using AttributeCreator to add a new date attribute, and this is what I have in the attribute value:@DateTimeFormat(@round(@DateTimeNow(localUnzoned),0),%Y-%m-%d %H:%M:%S) I am getting an warning and null value in my output: I have tried using DataTimeConverter, DatetimeCalculator, and DateTImeStamper. All works, but it doesnt give me the output I want.  Example: 2021-07-21 10:30:40 Any suggestion?   

Welcome to What’s Up Wednesday, your weekly source of FME and Safe Software news! Known IssueDue to Google Sheets changing our app verification status, you may encounter an Authorization Error 401: disabled_client when using 2FA. To resolve this, please update the Google Sheets package or create your own app, see Known Issue: Google Sheets (v4) - Authorisation Error 401: disabled_client for more information.  FME TrainingIf you’re reading this early on the 21st, there is still time to sign up for today’s Integrate Data with the FME Platform training course which starts at 9am PDT. We also have other free live online courses you can sign up for, or check out the new FME Academy, it’s Free!  WebinarsWe haven’t added any new webinars this week, but our Partners have! So be sure to check those out.  Knowledge BaseHow to Read XSD-Driven XML: This new article walks you through how to read XSD Features and the difference between reading XSD and Feature Paths. Local Government Citizen Services

I am trying to extract All the parameters along with values from Revit to MS Excel using FME Desktop. I tried to extract but i could only get very few parameters and those are instance parameters. I need to Extract All the Instance and Type parameters.

Hi,  I have a list of polygon geometries in WKT format, some simple polygons and some multipolygons.All are using the MULTIPOLYGON type in the WKT, for example : MULTIPOLYGON(((1 1,1 2,2 2,3 3,3 1,1 1)))MULTIPOLYGON(((1 1,1 4,4 4,4 1,1 1)),((2 2,2 3,3 3,3 2,2 2)))MULTIPOLYGON(((1 1,1 5,5 5,5 1,1 1)),((2 2,2 3,3 2,2 2)),((3 4,4 4,4 3,3 4)))But some of them don't have the first coordinates repeated at the end, so it is not a valid WKT.If I take the same examples, it would look like : MULTIPOLYGON(((1 1,1 2,2 2,3 3,3 1)))MULTIPOLYGON(((1 1,1 4,4 4,4 1)),((2 2,2 3,3 3,3 2)))MULTIPOLYGON(((1 1,1 5,5 5,5 1)),((2 2,2 3,3 2)),((3 4,4 4,4 3)))I want to find all the features lacking the last coordinates repeated. Any idea how ? Until now, I tried building a list with all coordinates, it can work for the simple polygon but for multipolygons I don't know how to handle it.

I have an FME-workbench, and eventually I want my data to be stored in a postgreSQL database. This works perfectly fine with the PostgreSQL-writer.  However, I need to populate multiple tables which underlie several constraints. Thus, the order of when what reader is run, matters. Moreover, I would like to instantly read the written data for further manipulation (my DB automatically generates an ID (by a sequence) which I need to merge to other tables as a foreign key before writing those tables to my DB). Any help much appreciated!

i have a small cartographic map in pdf format ,i have added it in my workspace then i have clipped it ,and i tried to write it again in Adobe geospatial pdf by feature writer transformer ,i get an empty file .it does not want to open .what i did wrong ?i would like to save it again in pdf ,how could i achieve it ? is there a way to read pdf as Raster .Thanks for help Fme 2018

I have amount Shapefiles and I want calculate value of attribute as shapefile name. Who can help me? Thanks so much!

Is there an upgrade procedure to upgrade the workspace to work in the new version? Or is this a bug in 2021.1?Screenshot of attribute filter that's not working.

Do we have an In Memory Table something similar to the FeatureHolder but takes a dynamic schema? Or is there a writer that can take dynamic schema without specifying a disk destination?

i have 3 input to pdf page formatter transformer,after that i got pdf output file and it looks as i wish .but i have new idea ,that i would like to put the same output as shown in pdf ,feed into directly in Excel sheet .do we have a method to achieve that ? because at end i have to take screenshot of pdf file then add in excel sheet manually ,but if there is a method directly ,it will be better. Thanks for help FME 2018

Hello everyone!I have a sample Revit file which contains the basic elements of a Revit file.I am interested in performing certain geometric tests through the FME, for example: Are certain elements in a place where they are not supposed to be present, Is a certain element in the right room,Does the element of a toilet for example, have enough space according to the standard we will define.And so on.When I approached the task, I was sure that the FME would be able to solve it without any problem at all, and then reality hit me.Any action I try to do with the help of the transformers I know (I work mostly in the GIS world, and know it's a little different from BIM), I do not succeed.For example:I intentionally inserted a foundations between the walls, and I expected to see that when I make a clip between the wall and the foundations, one object will be inside.What am I missing here?Do I need to move the 3D objects through another process before the required actions can be performed?Or

I have a unique value logger attached to a table and a workspace runner. It took me a while to realize it, but what it does is goes through each unique value and runs the entire 'child' fme once for each unique value, but it runs all unique values each time it runs . I put a test filter on the input table in the workspace runner workspace so that it only has one unique value to 'give' the runner and that solved the problem.This seems very strange but it works. Does anyone know why this works like this and if there's a less 'hacky' way? Thank you,Randy McGregor 

Hi ! I have a folder containing about 20000 jpeg files and separately a list in csv format containing names of some jpeg files which I'll need. How can I import in FME only the jpeg files from the list and not all images in the folder ?Thank you.  

I am essentially looping through httpcaller results and need a way to pass a value from the last record returned in a loop, I dont know how many records will be returned. I was using the stats calc to get the max value but that is blocking the loop from running within the one workbench. Does anyone have any suggestions, thank you

Hi,I have a script where the user decide what file to add to one of the excel readers. The problem is that the information in the excelfile is new everytime and so are the columns as well. But the problem is that the reader wont update to new columns in the new excelfile. Somehow the first excelfile that is added to the reader is kind of "stuck" there until I remove the reader and add a new one with the new excelf file. But the problem is that this script is connected to a FME server app where the users will be choosing an excelfile in the app and not in the script. So I wont be able to re add a new excel reader everytime. Does anyone here have a solution for my problem? FME version: 2020.1

Within the two data sets there is the common field of subscriber address and address. However I believe there is an issue with the formatting as when I fuzzy matched the Subscriber address with the UPRN dataset the ratio was poor yet when manually checking the fuzzy match output they were mostly correct. Is there an extra step to reduce the issue of factors such as spacing and extra information such as "Nottinghamshire" through transformers? I hope the blurry images below help explain the formats Thank you for any help or advice!!

I have been developing a workbench to be used on different shapefiles via adding a new reader everytime, they would have slightly different attribute names beyond my control. The workbench is now ready to go, but when I have to update the right attribute in a transformer, FME seems to list ALL the attributes that have been handled with previous files with that workbench.. It's really annoying and also potentially generating failures. Is there a way to clear this? To only list the attributes within the readers? I have tried tool>purge temporary files, but it hasn't solved it.