FME Form

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

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

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.

I'm trying to update/delete from an SDE featureclass using fme_db_operation, The changes are grouped in 4 groups: 2 delete and 2 updates. The Deletes work fine, the first update group (updates both geometry and attributes) works fine.But the the last update group (updates only attributes) does not write data to DB. There is no errors, there is 5 exspected warnings (non existing keys) but for the rest of the +70.000 records there is no indication of anything is wrong - except the data is not updated.Best regards  

i need to reprojection from (wgs1984-utm-zone39n) to (KSA-GRF17 )but don't find KSA-GRF17 in coordinate system?

I want to merge small polygon (<0.01) to adjacent large polygon same the same commune. Could you tell me how to make it? Thank you

This is how I get after entering the portal in which my fme server is running.There is a 401 error initially in the console and then also 503 and 500