FME Form

Hi,I have a kml file that is created from a MapInfo Tab file that has 9 polygons, the polygons are all the one colour and will change to another colour if you hover over it. Now I want to remove the old outline colour and assign a different colour to each polygon using the Asset_Mgr_Region field to filter by, but still retain the highlight on hover. I am not sure where to place the Attribute Filter to achieve what I want, how do I use this? I have attached my workspace. Thanks

HI guys, I have a question. How can I generalize points in FME Desktop?I have like 10 points, each point is very clos to other and I want to make from them like less number of points like 3-4 maybe. I've tried with generalizer but it's not working, any suggestions?Screenshot below.TIA

Hi,I need to denormalize rows into repetitive numbered columns. Here's an example.Here is the normal version as it is in the relational db. Note that the three rows all have the same value in ID_DETAIL field.Here is the desired result. Note that for this one DETAIL, we end up with three groups of columns (ID_MENTION, MENTION, PRECISION).How would one do this in FME ?The number of repetitive groups of columns would be defined by the detail in the dataset having the most mentions (in my example it was 3).I was thinking of some kind of grouping on ID_DETAIL and some kind of "for-each-loop". But any better suggestion appreciated !

I have thousands of photos, under multiple sub folders, which i have been attempting to extract the photo date. I have used the jpeg reader together with option to search sub folders, however, none of the exif options allow me to append the original file details. I'm new to fme so it's probably something simple as if i pick a single file then the filepathextractor works a treat. 

I need help to figure out how to reorder the field "Shape". I tryed multiple things has these three options and also tryed to use the Attribute Menager transformer :But has soon as I play workspace, the "shape" field always appear at the end of the table. The problem is that it has to ben at the second place like on the image below.Thanks a lot in advance :) 

I am trying to view the DXF file using cesium, for now, I succeeded to convert the DXF (2D) file to MVT/GeoJson ( a format that can be viewed using the cesium), but the MVT does not contain style (colors, hatch, line type/width, dashed, font.... ), all the style of the DXF is missing, any suggestion/ideas to view the DXF including the style using the cesiumJS?

Using the circle below as an example. I would like to close the gap, doesn't really matter if it is by snapping or adding a vertice. I have tried both Snapper and LineCloser, but they don't seem to work when there is only one geometry.  How can I connect the start and end points in the example below? I would rather not use the LineCloser of fear of self intersections (real world features are more complex than my example), and the HullReplacer is to slow.   

I have a python script that reads a set of values that we want to expose out of PythonCaller as a list; however, after several attempts, we are having issues outputting the list out of the Transformer. Running the script works outside of workbench, but having issues incorporating the script with FME. Debugging the script and writing to the log, we know the code is calculating the values for the list consisting a several attributes. And, the thinking is we are not formatting the list correctly or defining it. I have attached a simple workbench that contains a slimmed down script that we are trying to utilize to determine how to output a list at all. Any help in this regard is much appreciated. Here is a part of the slimmed down script listing the nested loop we want to use and the List name we want to output:   def input(self,feature):         npts = 3         # do a bunch of stuff with other input attributes to populate D     C = ['X','Y']    D = {'X':[230875

Hello there using the parameter $(WORKSPACE_NAME) to get the workspace name not working if the works[ace is saved as template, we get a different name as an example the workspace saved as a template with the name ( cad_to_gis.fmwtwhen use the parameter $(WORKSPACE_NAME) we get getting this name ( wb-late-1653463418287_7640)Any idea Please Thanks

I have a WMS feed that I want to include in an HTML report but don't understand how to to get the HTMLReportGenerator to use it. I have a polygon layer that I group by, buffer it slightly and then user the feature reader on the WMS layer.  If I user the Map option the base map is present but no WMS. Any suggestions?

Hi,I created a FME workspace in which I connect to a web service published on AGOL. The service consists of a point feature layer (inventory layer) and a linked table (inspection table), used with the Field Maps application to perform regular inspections. The main objectives are among others:Extract the weekly inspection results in Excel formatArchive inspection data as an existing file Geodatabase, but keeping only inspection table results for all subsequent inspectionsThen truncate the inspection table in AGOL.The first goal has been successfully achieved, unfortunately I am struggling to complete the next steps of copying the data from the inspection table to the File Geodatabase and then truncating the results from the inspection table after the execution of the first step.Could someone show me how to implement the steps to copy data from inspection table to file geodatabase and delete data from table in AGOL?Thank you for your help!Regards,

I have a CityGML file with some attributes containing numbers, but also strings. But for example, the folllowing attribute is supposed to be a float or integer in the 3DTiles format, but is written as a String, no matter what I specify as datatype in the writer's user attributes. <gen:stringAttribute name="DatenquelleDachhoehe">   <gen:value>1000</gen:value></gen:stringAttribute> What could be the reason for the 3Dtiles writer ignoring the specified datatypes?

I am creating a FME server app that reads shapefiles, applies some spatial analysis and then writes the results out to shapefile and an excel. Input shapefiles however will have varying schemas/attributes. The source I have set as a user parameter, that will prompt the input shapefile path. How do I get my reader to process/read varying schemas? I have ticked 'Merge Feature Type' on the reader. I assumed this would adjust the user attributes dynamically based on the input, but the schema remains fixed to the shapefile I set the bench up with.

Hi everyone, Is there and options for i would like to download data from OSM witch based on secondary property of the lines this time show that is it a roundabout or not. Or is there any transformer witch able to find them(roundabout).  Thanks :)

Greetings- I am trying to have a FeatureReader (set to format 'Directory and File Pathnames') fetch file properties for a list of 'Dataset' paths and 'Path Filters' which are incoming Attribute Features but have been unsuccessful in getting it to recognize them as valid. . only 'fixed' values seem to work. I've been through the help and Community posts on this and haven't found anything so far. Thanks in advance for any input.

Hi all,I'm trying to merge two separate excel spreadsheets. Both worksheets have the same names and number of columns. However, they do not have a common primary key to perform a join. All I'm looking for is to append the contents of the second spreadsheet to the end of the first so that I have a single spreadsheet at the end. How can we achieve this kind of merging without using the FME transforms inheriting from the SQL language (FeatureMerger or FeatureJoiner) in FME Desktop?

Hello to everyone,i am working on my master thesis and for that project i try to bring CityGML data into Revit. In the end I want to use the data in Dynamo. Therefore I search for a workflow for CityGML to Revit integration. Unfortunalety I can find a lot of information for BIM to GIS, but not the other way round. Does anyone can help me with advices, recommendations or ideas? Kind regardsMartin

I recently had my SMTP Gmail subscription start failing over the weekend and had been wracking my brain on how to solve this and found a difference in SMTP Server Settings that Google recommends vs what is on the template. Google recommends using smtp-relay.gmail.com. The template is still using smtp.gmail.com and is failing on the connection.  This may have been fixed in a more updated version of FME Server.  Thanks 

can anyone tell me if FME can convert Revit file to IFC file?

Hello,I'm using FME SDF Writer, but I also need to write some non-spatial data to my SDF file.However in the SDF writer I seem to be forced to always specify a Geometry column name in the Format Parameters section of the writer.If I specify the default: "Geometry" Autocad still recognizes the feature as a spatial feature but without a geometry and it complains about this, if we want to edit such features.In the "Feature Type Properties" section of the Writer, I have used "fdo_null" for the geometry.The difference between an original SDF (with a non-spatial feature) and one generated by FME SDF writer can also be seen in the FME inspector.The features written by FME have an extra attribute: fme_geometry with value fme_undefinedExample of non-spatial feature generated by FME SDF writer:Can somebody tell me how, if possible to write a non-spatial feature to an SDF file?Thanks

Hallo FME Community, I have a DWG file with about 100 layers. I managed to reduce the layers to 20 layers with FME by merging layers. Blocks in my DWG result are broken up into their component parts and they aren't one block but several lines. does anyone know how blocks can remain as blocks after transformation.Thanks in advance.  

Hi, Just throwing this out there because I'm quite new to this area. Thanks for your time and help! TLDR /questionHow can I use FME to extract only the exterior / shell of a 3D model when you cannot rely on the models structure? Background, infoI'm reciving quite a bit of complex IFC models which doesn't always follow the same structure, because they are made up of different models put together, so all the windows might not be in IFCwindows for example, it's best to assume it's scrambled. I want to transform these models to GIS and use in 3D maps. (SHP, GLTF, GLB etc)When I don't need a lot of the interior details like piping, doors inside the building, chairs, some walls etc I find myself doing a lot of manual cleaning/trimming in SimpleBIM.I'm wondering if there is a more automated way to use FME to extract only the shell of a building, and perserving the outer detail ofcourse. Sort of if I could drape a plastic bag over the model and suck the air out, ma

Dear community, I need to read a txt file who have empty column names like that :How can I manage my reader for having all columns ?Thanks for your help.

ID | Mile 0 6.5 1 6.42 6.43 6.4 4 9.25 12.8etc For every object which has a Mile number that occurs more then once I need to add a number to the Mile number. So for example, ID 1 would be Mile 6.4-1, ID 2 would be Mile 6.4-2 and so on. Now I have done this using Python but I'm sure this can be done with FME also. Can anyone give me some advice? Much appreciated.

Hey guys! How can I round to two decimal places while keeping zero on the second decimal place? I would like an attribute with a single digit like 450.199 to round off to 450.20 and not 450.2. Thanks for the advice in advance