Data

Hi,I can't seem to find anywhere the sql syntax for performing a geometry filter in the where clause of the File Geodatabase - (Esri Geodatabase (File Geodb Open API) Reader). I would like to only read in geometry of a certain min x, min x, max y and max y bounding.Also, is using the 'where' clause for this the quickest way of filtering a File Geodatabase? I have millions of records so need to optimize the filtering.I am using FME2017.1Thank you in advance.

Hello - in FME Workbench 2018.1 I am adding 2 KML Readers (a point file and a polygon file) to a workspace, and just want to combine them into one KML Writer containing the points, polygons and user attributes. When I inspect the reader I can see the attribute table with all the user attributes, but when I inspect the writer there is no attribute table. The only transformer I have is KMLPropertySetter, and Include Attribute Table has "Yes" selected. What do I need to do to include the user attribute table in my resulting KML file?Thank you

Hello,I have a fairly messy IFC where I need to extract all geometry traits (Pset.Attribute) and I ran into an issue. Not sure what to do here...I'm using the GeometryPropertyExtractor to get all "Pset.Attribute" values and it gives me this:They are supposed to be the same "Pset.Attribute" (by name), but the GeometryPropertyExtractor decided to give one of them a "{0}".I think what's happening is, for some reason one of the Psets has a different ID, so technically it's correct, just not what I want? Maybe?I guess I can remove all "{0}" with the BulkAttributeRenamer and hope for the best? Or is there a way to force the GeometryPropertyExtractor to use the Pset name instead of the id?Or is there a different reason?

Hi,i have two tables, one containing a code list and the meaning of each code:Code Meaning 500 Grass 501 Tree 502 Street  The other table, coming from the land survey team, contains the coordinates and the code of the point.X Y Code 51XXXXX1 9XXXXXXX1 501 51XXXXX2 9XXXXXXX2 500 51XXXXX3 9XXXXXXX3 500  I want the meaning of each code in this table is added in a new column:X Y Code Meaning 51XXXXX1 9XXXXXXX1 501 Tree 51XXXXX2 9XXXXXXX2 500 Grass 51XXXXX3 9XXXXXXX3 500 Grass  I m new to FME, usually i would do this with a script, e.g. in QGIS. My FeatureMerge options so far look like:

I have updated to FME 2016 and have had a few glitches. The recent one is using a KML reader which errors when starting with the following message. |FATAL |KML: Cannot open dataset `E:\\... data\\**\\*.kmz'|FATAL |KML: Error initializing readerAny ideas what the cause could be and how to fix it.

I have a PDF file like this: No.productleaderPartnerStatus1xxxcompany O5Parner1 (5%), Parner5 (80%) Parner67 (15%)ok2yyycompany 08Parner A (50%) Parner B (25%), Parner C (25%)ok3zzzcompany07Parner I (50%) Parner II (50%)ok4bbbcompany10Parner k (100%)ok And I need to have an excell file like : No.ProductLeaderPartner%Status1xxxCompany 05Parner15%ok1xxxCompany 05Parner580%ok1xxxCompany 05Parner6715%ok2yyyCompany 08Parner A50%ok2yyyCompany 08parner B25%ok2yyyCompany 08Parner C25%ok3zzzCompany 07Parner I50%ok3zzzCompany 07Parner II50%ok4bbbcompany10Parner k100%ok

Hello,my first problem: Writing a GeoJSON in the right order. Simple example:I want a output in the order A,B,C (like I set it in the writer). But the GeoJSON file is A,C,B, because the first row in B is empty. Second Problem: When the B column is empty. Only A and C is written. How can I get an empty column in the writer? Thanks for your feedback!

Hi @mark2atsafe @andreaatsafe, I am using FME 2018.1.1.1 Build 18578.I am trying to connect to a Microsoft SharePoint list via SAML since it is a SharePoint Online instance, but am getting the following error message. It is message type '200' which apparently indicates success, but this doesn't seem to be the case here...Creating reader for format: Microsoft SharePoint List Trying to find a PYTHON plugin for reader named `SHAREPOINT'Loaded Python module `sharepoint' from file `C:\\Program Files\\FME_Desktop_2018.1.1.1\\plugins/python27\\sharepoint\\__init__.pyc'Creating reader for format: Microsoft SharePoint ListTrying to find a PYTHON plugin for reader named `SHAREPOINT'Loaded Python module `sharepoint' from file `C:\\Program Files\\FME_Desktop_2018.1.1.1\\plugins/python27\\sharepoint

Hi,In my Postgres database there is one field created directly in database called 'code'.This field is auto increment.How I inform to FME that this field exist and none value can be recorded by FME.I tried record my data without this filed in FME but the ERROR was showed for me.thank´s

Let me start off by saying I'm very new to FME. I'm trying to transform data from Excel to KML and I want the output in KML to create a folder hierarchy using some of the attributes from the data.Each record in my spreadsheet has some of the following information. Here is a small sample:DECADE: 1940sYEAR: 1946FLIGHT: 1IMAGE: 1-1-1.tif What I want to do is use this data to create the folder hierarchy in the KML file.Example of end folders in the KML:Top level=1940s (DECADE)with sub of 1946 (YEAR)with sub of 1 (FLIGHT)then my feature of 1-1-1.tif (IMAGE)How would I best accomplish this?? 

I have an issue with the coordinate system of the IFC geometries.I have to extract the reference point from IFC, that is referenced by in IFCSite.The element is IFCLOCALPLACEMENT that references the IFCAXIS2PLACEMENT3D that referencesIFCCARTESIANPOINT that has the coordinates which I need. The problem in FME is, that these coordinates are used to define the transformation matrix forall geometries, but I cannot access these coordinates directly.The similar issue was discussed in:https://knowledge.safe.com/questions/4813/extracting-transformation-matrix.htmlBut the solution is far from elegant Is there any way to obtain the IFC reference point coordinates? Thanks in advance for any help! 

 Hello,I have a question regarding the conversion of .las files into Cesium3Dtiles with FME2017. The goal is to convert .las files (EPSG: 31256) into Cesium3Dtiles (EPSG:4326) including an offset of z = 156.68 m. Furthermore, the bounding volume type of the Cesium3Dtiles should be given as a bounding region (six numbers) with coordinates in degree instead of a bounding box (12 coordinates) in radians. Converting the .las file into the cesium3Dtiles with the mentioned reprojection doesn`t seem to be the problem. However. I do not know how to convert the output, which automatically creates a bounding box with coordinates in degrees, into a bounding region in radians.

I am extracting data from a dB and writing it to a gml file with the GML writer.I am also writing the xsd schema.In my data, some dates are empty, and this is normal. However, in the XSD file writen by FME the dates are not nullable. The type of error I am getting is:_xml_error{5}.desc (string): invalid date value ''I am wondering if I am doing something wrong or if there is a problem with the xsd writter?  

Hi,I've been trying to put together a workbench to take features from a WFS and populate them to an SDE. Initially, the workspace seemed to generate without error. However various XML errors (covered in other questions) meant I changed the parameters to 'Ignore Application Schema' and use 'GML Feature Elements = ##any'. This seems to have worked for some imports. However now I am encountering further errors which seem to centre around issues with the schema.Trying to run operations on various other feature layers gives the error <ows:Exception exceptionCode="NoApplicableCode=">I am unable to repeat the operation of adding the same WFS reader to a new workspace with the same parameters previously usedIf I change the parameters to Ignore Application Schema as mentioned above, I lose the order of my feature attributes, and the reader also fails to map any empty columnsSo I'd like to avoid ignoring the

Hello I have a workspace that uses a FeatureWriter to output a series of images that are then used in a validation report.In the workspace the images are being stored on my local drive. How do I get the images to be created / stored on the Cloud Server?

While parsing an INSPIRE gml  via the FME 2019.0 INSPIRE GML reader,i get the following error for one of the features:xml-geometry-ref Geometry Builder: unable to adopt the below geometry because construction for its own geometry has already been finalizedStoring feature(s) to FME feature store file `C:\IMKL to DGN v2.3 - 2019 - test_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `'Attribute(string): `fme_geometry' has value `fme_line'Attribute(string): `fme_type' has value `fme_line'Coordinate System: `'Geometry Type: IFMELineName(UTF-16LE): `net4_centrelineGeometry'Number of Geometry Traits: 1GeometryTrait(encoded: UTF-16LE): `gml_id' has value `id-03d59852-793e-4725-b313-bd8840b1949f-0'Number of Coordinates: 10 -- Co

Using BinaryDecoder; Error: "BinaryDecoder (TextEncoderFactory): Invalid Base64 character 'ÿ'"  Any suggestions?  What to de instead? (using FME 2018 and 2019.2 beta)  Thanks for any help, Marion

I am using the MS_ACCESS_JDBC in FME Workbench to read an access database. One of the tables contains a "long binary data" field (blob) that I want to obtain the shape from. Then I try to write this field to a shapefile using the Esri Shapefile writer without success. I have tried using the Geometry extractor testing all types of Geometry Encoding. But this doesn't provide me with any geometry. Also, the reader specifies "oleobject" as type of this field (I can't change the field type from oleobject to blob)...not sure if this might be the problem. Any help would be appreciated. Thanks!

We are attempting to migrate a set of syncing scripts from FME version 2014 to the latest FME version 2019 at the customer's premises. In one of the first steps, FME is stopping with the message: MSSQL_SPATIAL reader: An unknown exception occurred (log in attachment ). In 32 bit version, FME Desktop goes out of memory, while using 64 bit version, the memory usage is high, but apparently still workable.

We are trying to get our FME Desktop Smallworld edition software up and working. When we do it on a 32bit Windows system, we are able to use the reader. But when we use it on a 64bit Windows system, we get the following error...Creating reader for format: Smallworld 4/5 Trying to find a BUILTIN plugin for reader named `SWORLDSWAF' Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF' This FME edition does not recognize the `SWORLDSWAF' reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required plug-insInformatio such as the Smallworld SWAF Quick Facts state 32bit Windows as a requirement. 32bit Windows is getting hard to come by these days. Is it really a requirement or is there just some additi

Currently I am busy with a 4.5 GB point cloud. I want to classify this point cloud into ground points and vegetation points.I tiled my point cloud into tiles of 500 x 500 m and assigned an unique TILE id. Now I wanted to run lasground on the separate point clouds resulting from the tiler using parallel processing. However, it seems that there is no option for this available in the lasground transformer. Is there a workaround for this?

Does anyone know where the versions of Oracle, Postgres and SQL Server are documented that the FME Server's database supports please? We're looking at a couple of standard database switch outs for customers and could do with a full list of database versions that are supported for all three standards. I thought I'd start by looking at readers and writers but there doesn't seem to be a list of versions on the readers\\writers either. Please can anyone help? All the best, Dave

Hi all, I'm working on .dgn file.And i convert the .dgn to .gml by FME.But, when i convert the gml file, character tag attributes look intAttribute in gml file.So how can i fix it? Regards

Dear all,I would like to rotate a rectangle in 3D for 30°. Background: I´ve got a PV-Panel flat on a surface and would like to rotate it in 3D facing the sun. So the lower axis is on the floor. Hope you understand :)How is that possible? Which tool would you recomend? Thank you! RegardsRaphael

Good day,I create one map per ship showing its track of the last month. The map is output as pdf (Adobe Geospatial PDF Writer). By default the page orientation is portrait. I would like to dynamically change the orientation to landscape depending of the map's bounding box (width/length). How can I do it?