Data

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.

I am trying to convert a Google KML file to ESRI Shapefile and to include the ExtendedData as attributes.European Space Agency is publishing planned satellite observation scenario as a KML file that has several attributes in the ExtendedData tag (see ). These attributes are always the same, as here:<ExtendedData>   <Data name="SatelliteId">      <value>S1A</value>   </Data>   <Data name="DatatakeId">      <value>1C269</value>   </Data>   <Data name="Mode">      <value>EW</value>   </Data>   <Data name="Swath">      <value>NA</value>   </Data>   <Data name="Polarisation">      <value>DH</value>   </Data>   <Data name="ObservationTimeStart">      <value>2017-06-06T20:19:16</value>   </Data>   <Data name="ObservationTimeStop">      <value>2017-06-06T20:20:32</value>   </Data>   <Data name="ObservationDuration"> 

Hello,It's hard to explain. I'm french guy and new in FMEI give you a "fmw" file and try to explain my problem. I try to transform an AIXM 4.5 file to an AIXM 5.1 file. This concern the "AirportHeliport" feature. I follow different examples on the FME website and some examples in my office.I have a problem with the final schema. I try to obtain the "servedCity" structure at the end of the transformation but in the final output file (XML File) the structure "ARP" disappear ... I don't want that, but i don't understand why ...So, if i connect the bookmark "servedCity" the result with ARP disappear and if i disconnect "servedCity" the result with ARP appear.what is wrong with the "geometryPropertysetter" transformer ? I saw it's necessary to use it with the XML_Geometry type but i don't understand why the structure in the xml file disappearPlease some helpMy first Zip : airportheliport_without_se

Hi everybody!I'm facing a problem with the ocgkml Writer. When I route 3D surface geometry of building models to the writer, I'm getting flipped surfaces for my facade features. Unfortunately this behaviour doesn't remain constant for all facade triangales, some of them are oriented correctly and some are not. The input features look correct to me and exports to collada prove this to be wright.An export with FME 2015 also shows a correct export with all walls oriented correctly. So this has to be an issue with FME 2016 and 2017. Has anybody else encountered this behaviour and found some workaround for this? Find attached the sample data together with a snipped of the workspace and the exported KML filesThanks in advance to everybody who can help me!

Hi, I came across the following issue: using a directory and path reader (filtering for files only) and supplying an empty folder works fine (it doesn't produce any files, but that's just fine). However, say I want to skip any processing from this reader, as an innocent user I supply the Windows nul: device. Now my workspace crashes, how is that? Of course, there are a lot of ways around this problem, but wouldn't it be nice if the directory and path reader behaves in the same way like, say, the Windows dir command?

Hi team.I extracted json from http caller. extracted json file attached. json.txt.in this json there are array of points. the path of these points is. ucan see these points after "paths"(text string)routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{0}.array{0} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{0}.array{1} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{0}.array{2} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{1}.array{0} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{1}.array{1} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{1}.array{2} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{2}.array{0} routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{2}.array{1} routes{0}.routeOptions{

Hello everybody,I want to create an Excel file with the FeatureWriter. To get the output well formatted I created a new file before that all as a template file. Well, the FeatureWriter does something I don't want to have. It creates a copy of the template file and creates a new sheet in this copy with the output.. This sheet is exactly that what I want to have but the additional sheets of the copy are disturbing. Is it possible to remove the sheets of the template and just keep the sheet which contains the output?Best regards,Felix

I'm an entry level FME user and I'm struggling trying to transform a file geodatabase to kml. The feature class consists of 67k culvert line features with 38 attributes. Both FME and ArcGIS seem to generate the kml but Google Earth encounter an error whey trying to open it. I thought the tutorial could help me discover what I need to do to fix this.