Using readers and writers to extract and load data.
Recently active
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 application schema if possible as this seems a w
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 -- Coordinate Dimension: 2(158575.379167511,211074.867855639)(158588.771742026,211098.641083634)(158597.934106561,211114.905244107)(158599.225499418,211118.054957503)(158612.218427047,211140.966125445)(158625.409716029,211171.
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 additional configuration required to make it work? Maybe something is looking in Program Files instead of Program Files (x86).
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?
I am having an issue adding a writer from ArcSDE. I am looking to write to Relationship within Oracle SDE, it is 1-many. On creating the Writer I get the following, The table name 'SMU_SPATIAL.Report_PhotoRepeat' could not be found in the Geodatabase as either a feature class or a table. This may be because the current user does not have permission to see 'SMU_SPATIAL.Report_PhotoRepeat' However when I add the Writer I am using exactly that user SMU_SPATIAL. Has anyone ran into this, any help would be appreciated. Thank you
Hello FME User,Does any one having experience to process LIDAR or Point Cloud data collected by Car mounted device.I need to classify the data in to Road Surface , Building , Tree trunks, electricity pole along with RoadThe bad news is in point cloud we don’t have any calcification values it’s “Zero” everywhere.Can any one please guides me. Unfortunately data can not be share.
Hello!I have setup a workspace where I compare an Minecraft world with several other versions of that same world.I use the PointCloudMerger to give only the changes between the original and the new world.Because Minecraft reader is always a Level.dat I use the FilenameExtractor to extract the folder name (dirname) for that Level.dat file.The output is writen away as a *.csv with X,Y,Z,blockId,blockData and named after the folder name.Running this process inside the workspace for one world works perfectly, however, when I use batch deployment something goes wrong.It always uses the folder name of the first level.dat file, while it parses through all the others.This results in the same output name for all *.csv files.What am I doing wrong?
I am interested in using FME to process a folder of Medical DICOM images in 6 different angles and segment sizes into a point cloud or 3d mesh. Anyone have any workspaces they can share to do this? Thanks
IS FME able to read checkboxes in excel?
Hi, is it possible to secure FME Server using Azure Active Directory? Thanks in advance, Clare
Hi All,I am importing data from Smallworld VMDS to ESRI GBD format. We are having 2 crore records in smallworld Database. We are trying to extracting all the records into ESRI GDB format.We are facing a issues while inserting records. If we got any issues in middle the transaction get stopped and again it is started from first.How can I import all the data into single or multiple ESRI GDB format from Smallworld.If we got any error in middle how to avoid that issue record and continue with next one. Is there any way to process the records in bulk? Please tell me the possible solutions.
Hi all,I'm using the Generic Reader to read incoming data that can be one of several data formats, including GeoJSON. The problem I'm having is it seems the Generic Reader defaults to Esri JSON for files with a .json extension. This causes the workspace to fail because the GeoJSON data structure coming in is different from what is expected by the Esri JSON reader used by the Generic Reader for .json files. Is there a way I can change the defaults on the Generic Reader or do I have to modify the extension of the incoming file to .geojson?ThanksRob
Hi all,I am reading an MongoDB collection and write it to GeoJSON. It is generally working fine however it writes some backslashes out of some reason. As you can see in the images, for conditions value, I am getting this "\\". Any idea how can I get rid of them?