FME Form

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

I'm trying to replicate an analysis in FME that we have done both Esri and GDAL Zonal Stats tools. It is pretty basic. I have a single band raster layer of percent tree cover spanning the contiguous US. I need to summarize that data at the tract level. I.e. what is the mean tree cover for each tract within the US. I get identical results when doing the analysis with Zonal Statistics in Esri and GDAL. When I conduct a similar analysis in FME by clipping the raster to the tracts (merging attributes) and then use the RasterStatisticsCalculator on the result, I get a completely different answer. 

is there a way I can only display "Translation parameter values" window when I run a process via quick translator ? The background window "FME Quick Translator" somehow is redundand I think since I dont need it.   

Hi, I have installed FME desktop and server, my organization has a license server that i was able to define for the desktop client, but, i am unsure how to configure the FME server instance to that license server?  Is it not meant to work that way? Thanks, Jared

Used arcmap to import xml of data schema only from arcsde into a file geodatabase. Using esri geodatabase (ArcSDE Geodb) reader to esri geodatabase (file geodb). receiving error message:An error occurred while attempting to open an insert cursor on the table 'Beacons'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [Beacons]}  

The data needs to output from Row 5 cell A to U. I can see you can use the start position of 5 which works but everything above get's wiped out so I loose the headers. How to I stop loosing the titles and headers from the output in Excel in FME?

I have tried to convert an IFC file to Cesium 3D Tiles with the Cesium 3D Tiles writer.This results in one JSON file and one or more B3DM files (depending on the IFC file structure).When I try to add the JSON and B3DM file(s) to Cesium ion, the model does not appear. How can I fix this?Is there another method to convert IFC files to 3D Tiles with FME?

Hi everyone,I'm trying to restore a arcgis polygon feature layer (feature 1) (that someone accidently ran a simplify geometry tool on) with the geometry of a backup feature layer (feature 2) from a older copy of the dataset. Problem is that I ONLY want to replace the geometry of feature1 and keep the attributes. The workbench that I build (see picture below) will replace both the geometry and the feature values/attributes of feature 1 Any tips on ONLY replacing the geometry? thanks in advance. 

Attribute Splitter and List Exploder? or is there a better way?

Hello,I'd like to use feature attribute in another function. something likeclass FeatureProcessor:  def __init__(self):    pass  def input(self, feature):    col1 = feature.getAttribute('col1')    col2 = feature.getAttribute('col2')    self.pyoutput(feature)  def close(self):    passdef myFunction(col1,col2) another code etc.  I do not know how I can get attributes col1 and col2 to use it in another function.. (first time using python caller) .. thanks for help.