Data

Hello,I have a Microstation drawing with dimensions. However, a part of the dimensions is being converted to a weird output when inspecting it with FME and also when writing it to a PostGIS database.Below is a screenshot of the issue. Does anyone have an idea what is causing this and more importantly, how to fix it? As you can see, only a part of the dimension is displayed in strange characters.The source file does not have these weird characters.If anyone has any idea's or tips, please let me know!Thanks in advance!

Hello,Does anyone know if FME is able to connect directly to an Analysis Services (SSAS) Tabular model. I know it can connect to SQL Server. I also know I can read an excel sheet that is connected to the tabular model, but I would like to connect directly to a tabular model.Thanks,David

I can't seem to write IFC objects that consist of multiple geometries as Multipatch - every time I try, the log says it wrote the correct number of features, but the shp file is empty. The only way I can get the geometries at all is by using the GeometryPartExtractor with Geometry Name = Body; however this separates the grouped items. When I try to use the Aggregator (with unique ID), it joins the parts together, but then I can't write them again! Is this simply not possible?See Screenshot below, I want to write a Multipatch that's grouped like the selection - right now it consists of a separate cylinder and two blocks.

Hi group! I tried to find a way to filter out point cloud points, if they have too big Z difference compared to neighbor points. I couldn't find any transformer, which would do it. I could try using buffering a point, then find the points inside the buffer, then compare the Z with the buffered point and the inside points, but with 70GB of LAS files, I think it's too heavy. Are there any PointCloud related transformers, which could do that? Basically I'm filtering out noise and clouds or errors in Z.

Hi allI've got a simple workspace that's using a generic reader to read an input shapefile or csv file. I've added a csv reader as a workspace resource so that I can set the csv reader parameters and apply them to the generic reader when the input file is csv. Works fine when tested in Desktop. The column names come through as attributes as expected. When I publish the workspace to Cloud and run using the same data, it looks like the workspace resource is ignored, the csv reader parameter settings are not applied and the attribute names come through as col0, col1, col2, etc.My FME versions are:Desktop: FME(R) 2016.1.0.0 (20160419 - Byuild 16492 - WIN32)Cloud: FME Server 2017.0.1.1 - Build 17291 - linux-x64I've attached my test workspace and data.Hopefully someone can test it to either confirm the issue or let me know if I'm doing something wrong.CheersRob

Dear all, I did convert Shape file to citygml but i need to apply the textures to the surface any one help me how to apply the textures.

Hi all, I have a points dataset of planning applications. I also have a large number of environmental datsets as polygons. I have a spreadsheet(excel) with a list of all the polygons. Each layer will recieve a "tick" depending on whetether the point falls within the polygon, ie.yes/no boolean query. Any suggestions much appreciated.

Can I execute a MongoDB Aggregate query? Can I populate a parameter based on such a query?Thanks,

Hi I'm using FME Desktop version 2017.1. I'm trying to obtain all schema from a postgis database name here sgl. With the schema reader I obtain only one result which is the public schema. And I need to obtain all my schema : How to set my reader in ordert o get all schema ? best regards

Hi FME'ers,I am currently trying to write OS Mastermap (gml) to an Esri Geodatabase (File Geodb ArcObjects). I get so far before it through's up the error "ArcObjects Error -2147467259 Whitespace is not allowed at this location.The problem is the log file doesn't tell me where the offending whitespace is...So I look through the erroneous record to try find it but I can't see (by eye) what the problem is. Is this an ESRI issue or an FME issue? Thanks,David McDermott 

I have a workbench to translate a shapefile to Microstation DGN. In the workbench I have a parameter to let the user specify on with attribute of the shapefile the layernames in the DGN should be based. When I run the workbench in FME Workbench everything works fine and the layers in the DGN are named by the content of the attribute. But when I run the workbench in FME QuickTranslator, the layer in the DGN is named by the attribute itself.Is this a bug?

Hi,I am trying to version control the database connections that we have on our FME implementation, I have a docker setup. Unfortunately I can't find the files where these are stored, the host OS is centOS. Any chance you can point me towards the correct path where these are stored? (I use the default mounts that come with the compose file)Thanks!Regards,Miguel

Hi everyone.If I make an export to dxf from my 3D database (CityGRID) with their tools and inspect the result in Microstation my buildings look as expected:As soon as I touch the buildings with FME for further processing, even if it is just read and write to dxf again, tho whole thing is "polygonized":Even though the building is still "correct" the result looks to nervous to me (and to our customers as well).Is there a way to tell FME not to polygonize areas with the same normal? Or at least a switch that tells the CAD-Software not to show these polygons?Thank you very much for any hints.Simon

Hello  My name in Alex  I have a question  I am using FME to convert a GeoJson to Cesium 3D Tiles The conversion seems to be generated successfully. But when I try to show in Cesium, it isn't shown. I think the reason is in the coordinates, because the coordinates of the source file (GeoJson) are different than the coordinates of the final file (Cesium 3D Tiles). I choose to keep the GeoJson coordinate system, but it doesn't work  Do you know any solution?  Thanks a million  Alex

I have a feature that is a circle and stored in Oracle. When translating it to a MapInfo Tab writer, the circle does no export to a circle it is more of a 12+ sided polygon and slightly shifted.Is there a way to rectify this issue? or even assign tolerances? I have read somewhere that it relates to the number of bits - the FME version I have is 64 bit and the writer output for MapInfo TAB is 20 bit?

I would like to transform a directory with several DXF oder DWG files with a coordinate transformation and write all the DXF or DWG files into one new directory. How can I write all the files with the same schema as the input files? I need an output file per input file. I only get one merged output file from the input files. I tried to do that with dynamic reader and writer. How can I get the same amount with same schema of output files like the input files? With esri shapefile this ist easily possible with dynamic workflow.Thank you!

Hi everyone,I having trouble working with a Postgres relational database. Basically what's happening is I'm reading from one (or many) XMLs files, transforming/combining/editing data then writing to a number of different Postgres tables which all link together via a primary key in the 'master' table. When the XML file(s) get updated and a record drops off, I need to delete that record from the master table but because of the related records in the other tables, I am unable to do so. Obviously the related records in the other tables need to be deleted as well (and apparently before I can delete the 'master' record). Does anyone have some logic around how to make this work? It seems I need to find the deleted 'master' records (I'm using Update Detector at the moment), then somehow get a list of all of the related records in the other tables, delete them, then delete the 'master' record. Any tips or advice would be greatly appreciated!Nata

All, I am trying to export a surface created by TINGenerator from LAS to LandXML. Does any one knows how should I structure the output so my LandXML come out correctly (valid) ?I am using http://www.landxml.org/webapps/LandXMLValidator.aspx to validate my output. Thank you,  

Hello,How to extract a GML geometry from feature with keeping the original CircleByCenterPoint type and the UOM instead of a posList of points ?

I'm new to FME and I'm creating a workbench using two excel files. One has all the data with formulas from information column (Region, Strat, Just Code) to formulas -- simple Sum (A+B), Percentage to complex IF statements AND the second excel file contains info which helps me filter using certain categories (Just Code in this case). I used Feature Merger to merge the two excel files, then Tester and then Test Filter to help me create output based on Strat using Just Code (For eg: If Just Code (in 2nd excel) is 1 or 2, Output that as Poles). I opted for 'Keep formulas' while first creating the Reader but when I checked the output, all my excel numbers with formulas are messed up). In the excel file 'original sheet', Column G (row 10) is = F10+AI10-E10 but after the filter the output which is now in Column G (row 8) is still reading as F10+AI10-E10 disregarding the filter when it should be F8+AI8-E8. I was advised to use "Counter" and "String Repla

Hi everybody!Have you ever heard of ARCHIBUS? As far as I understand it should be a web platform for managing Real Estate, Infrastructure & Facilities assets. According to their website (https://www.archibus.com/):"ARCHIBUS reduces complexity through native business intelligence. ARCHIBUS turns BIM, GIS and Mobile into powerhouses that accelerate understanding of your real estate portfolio, workspaces, and operations, and speeds business processes" Any idea about what kind of data they use? Would it be possible to integrate that with FME?Thanks a lot in advance for any tip you can give!

Hi FME user's,My customer doens't connect the transformer S3ObjectLister. I maked the test in my machine and company and the results is OK, all files are display.I believe my customer wants to contact the IT Team to disable any port.Attached the log file.Thanks in Advance,Danilo de Lima

Why is there a 10 Character limit to V8DGN Cell Names in the V8DGN Writer when the V8DGN file format allows for a 512 character cell name? The old igds days are long gone and I don't understand why FME V8 DGN writers would not use the V8DGN file format attributes sizes? 10 Characters is not enough in the V8 DGN world for a cell name.