General

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

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 be

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.  

Hi,I would like to transpose attribute where the unique values in attr_names are columns and the rows are grouped correctly. What I mean is that the values has to be attached to correct feature (see attached picture).The attributes need to be grouped in one row as presented below in the picture with the colors on the side.  FME version: 2020.1

i have more than one input ,they are connecting in seperated input ports of pdf page formatter transformer but i have only one port output .how could i rearrange layer orders for each input .if i get all of them from only one output porti would like to show some layers down and others up  FME 2018

I'm in a jam. Installed a transformer from FME hub and then after tweaking it was not able to revert back to the original. The original took on the definition(?) of the tweaked one. When I try to download it fresh, it gives me the tweaked one. I have a feeling it lives somewhere, but can't find it. How do you purge a bum transformer? I tried to delete the tweaked version and it crashed every time. No good. Any ideas? I can't be the only one. Thanks

i would like to download DigitalAtlasNord Map ,is there free version to download this map to use in FME ?or which free source map will be similar to this map to download ?another question : i have Gis application bentley microstation,how could i use the map in bentley,do we have a method for that ?My target : i want to use the map in FME to get Cartographic output behind object in pdf file FME 2018Thanks for help   

Hiya, I'm very new to FME and have only used it once or twice. I have automated a google sheet to pull in data from Google Analytics using the Google Analytics add-on rather than connecting it via the API.  I have read in the google sheet as the reader and the writer would need to be the Microsoft Excel spreadsheet however when I'm using the attribute manager to tidy up everything for some reason it won't write out to the excel spreadsheet its just blank.  Am I using the wrong transformer?

Hi, I am trying to get a hyperlink when I click on a point map created by html report generator, using esri leaflet. I attach an image of what I got if I use the same hyperlink I have used in the table (correct hyperlinks). What would be a good approach? Thanks

I have a series of records - each is then replicated multiple times by date and then have andother column with either a value or null. each also has a unidue key based on the geom.not every date has a value and thus in null.what i need to search for is for each unique geom find the record that has the latest date with a value in the extra field.needs to return one record per unique idany help appreciated

 I want to define the location of my log file, and tried to set the path together in a File/Url type user parameter. One part of the name can contain letters e.g. ø, å, æ etc and I can see in the translation log they are returned as utf8 codecs (e.g. _00f8_).In earlier versions of FME Desktop was there the possibility to specifiy the character encoding, but it seems like somebody forgot to implement this in 2021.The definition of the path should be as such: C:Temp\$(WORKSPACE_NAME)_$(b_number)_$(municipality)_$(year).log, where 'municipality' can contain special characters. The other thing is of course, that as soon as $(WORKSPACE_NAME) is in the picture i am getting 'Undefined macro `WORKSPACE_NAME' dereferenced in file'. Last problem the log file does of course not exist at the point when I start the workspace. Do I have to create the logfile manually i a startup script?

Hello, I am currently exploring the capabilities of FME Server and I am trying to do a web map application that show the latest earthquakes using the USGS API: https://earthquake.usgs.gov/fdsnws/event/1/ I have already set up a workspace that gets the information and organize it spatially, so I may think that the next step is to publish that workspace to FME Server and schedule a job every minute or something (for example)  but now to visualize that changes in a web interface I have think that I will need send a JSON using a websocket sender transformer and configure my web app to get that websocket and utilize it to display the location of the earthquake? What do you think about that workflow? Do you ever try to do something similar? Please point me out in the right direction. Thanks.

i have cut specific image with clipper but when i use clipper inside ,i found it includes my target and also black parts around the image that i need to have .how could i cancel black parts ,and keep only my target image ?