Data

Hi all,I have a LAS file containing duplicated points (same time, same X, same Y, same Z...). I want to remove duplicates and keep only one point.What is the best way to do this?Thanks

I'm writing a custom format reader to read our custom point cloud format. The sdk is not clear on how to add points to a point cloud. I only have 4 components x, y, z & intensity.

Hello!TLDR; My ESRISHAPE readers don't fetch schemas from all my source tables.I have a workspace with multiple ESRISHAPE readers, each of which are reading its own separate ZIP archive.The readers are using Merge Feature Type (*) to allow all Shape files in each archive to be read.I'm writing all these Shape files to a dynamic MSSQL_SPATIAL writer using "fme_feature_type" as Schema Definition Name. Most Shape files have copies (containing data from separate geographic regions) in each source archive. Their region suffix is ignored so they can be written to the same destination tables.It goes something like this:Reader1 The archive contains the tables: Table_A_1Table_B_1Table_C_1The reader fetches the schemas of all the tables in the first archive, logging: "Reader `ESRISHAPE_1' of type `ESRISHAPE' provided schema for types: Table_A_1,Table_B_1,T

Hello,  I'm attempting to geotag photos with FME Desktop by writing coordinates to the jpgs with an AttributeCreator.  The following headers have been attempted with no luck: jpeg_exif_gpslatitude jpeg_exif_gpslatitude jpeg_exif_gpsmapdatum etc... which is how the data appears in the data inspector with a properly geotagged photo. The tag names from http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html were also attempted with no luck.  The proper data types were also considered.  Any idea of how to write gps EXIF data to jpg?  I know its possible with the exiftool and other third party apps but I'd like to keep it all within one workbench, without calling any other applications.  Thanks,  John 

Hi,  I have this workspace to add a geotag to a jpeg, based on a GARMIN glo GPS logger. I merge the GPS data with the jpeg by the date. When I take a look at the inspector merging seems to go well. But there is no exif information in the created jpeg (no original exif info and no latitude, longitude and altitude info). Anyone can help? I am new to FME.  Best, J. 

Dear users, I need to convert polygons from an ESRI filebased geodatabase to AutoCAD DWG. Unfortunately FME creates blocks for all polygons that have holes. My question is: can I prevent FME from doing this or is this absolutely necessary when using the AutoCAD file Format? Thank you very much in advance.

HiI'm currently transforming Oracle Spatial data to AutoCAD DWG format, i'm reading nearly 30-32 Electrical assets and writing them into AutoCAD DWG writer, while viewing the .DWG Output files in AutoCAD software, i would like specific features like ROUTE Layer to be pushed back.I can do it manually in AutoCAD by going into the layers properties and selecting the specific Layers and sending it to back. But, I'm looking for an option in FME where i can send specific layers to back before writing onto AutoCAD DWG writer.So when view from AutoCAD software, we no need to perform the manual activity of pushing the specific layers to back on each and every DWG tiles. Any help would be appreciated.Regards, Anil

I have a database of hundreds of assessment results for utilities. In FME, I have taken the utility coordinates from the database, joined into lines, sorted into 'pass' or 'fail' and organised by utility owner. This all works. I have done a microstation DGN writer for each e.g. electric 'pass', electric 'fail', gas 'pass' etc etc. I have also tried putting all outputs into one DGN writer. Neither gave me what I needed which is to have individual layers for each result and utility type, which can be switched on and off. I can't do a fanout (I dont think) because I need to fanout by an attribute and I dont have the results as attributes, but rather as sorted/styled data. Would I need to use an AttributeCreator, or is there a way in the DGN writer to get multiple layers in the DGN based on my sorted data? Thanks.

Hello, I have result from FME, one shape file with many attributes that need to be written in one DB in Oracle that I have access to. I don't know how to connect that DB in FME and how to export attributes from this shp to that data base. Is there any way to do it?

Hello,  I am trying to do a rasterization of one DWG. After I run MapnikRasterizer, I get good results for most of the parameters but TEXT is problematic. In AutoCAD my text looks like this:But when I get a result text looks like this:I have tried setting almost all options in MapnikRasterizer. I have turned on in writers attributes "autocad_text_rotation" and tried to enable it in Mapnik, but I get an error. Does anybody have an idea how to preserve text same as in CAD?   Thank You in advance!

The 32-bit installer for beta build 18254 is not working, see this question. Could somebody from Safe look into this?

Hi Team,Can you please let me know if FME can write data into SDE geodatabase or not.I need to automate spatial data creation process.My sde geodatabase is in Oracle. SDE/ESRI version is 9.3.1, Geometry storage is SDE binary (BLOB) and feature dataset has geometric network.Please share your expert views and any details which you can provide.Many ThanksManoj

Hi, I am currently using the AzureBlobUploader to try and uploading it to Microsoft Azure blob storage. At first, my workbench was working fine (it uploaded the files to blob storage) but after a few successful attempts, it no longer works? I now get an error [Errno 2] No such file or directory: u'C:\\\\Users\\\\aileen\\\\AppData\\\\Roaming\\\\Safe Software\\\\FME\\\\FME Store\\\\Transformers/New\\\\Missing_BT_links.csv' Any ideas on how to rectify this would be greatly appreciated. Thank you, Aileen

I'm testing my current workspaces in FME 2018 Beta and i'm getting a new warning from an Excel Writer. WARN |Excel Writer: Attribute xlsx_row_formatting is empty, no row formatting applied  It doesn't seem like this warning is anything to be concerned about but i'd like to make any changes possible to prevent it from showing up as many times as it does while running. I can't seem to locate the much documentation on the xlsx_row_formatting attribute, so i'm wondering, is there any way to populate it to prevent the warning? Thanks! 

I have a kml with the attributes 'kml_additional_files{0}.href' and 'kml_additional_files{0}.path' filled with filenames and -paths. I want to place the locations (points) as objects in a local database with the filename(s) in an attribute to these locations. But I can't find how to do this.I'm using FME desktop 2017.1

I am working on AIXM 5.1 task. the task is to convert and map a GIS data to AIXM format for eToD.I have mapped the feature but I have an issue with message metadata and feature metadata like EX_Extent,nameofmeasure and dataStamp .Any idea how to map it .

We are running FME desktop 2017 and are struggling to do a custom number format that will show the 'pound' symbol when writing to a new Excel sheet. shows a '?' symbol instead. the doller '$' works fine. We have changed the font to Arial and checked the character encode and it still wont display the £.

Hi,I want to read the following attributes related to symbology from a CAD file and want to store it in Single Attribute by using Json Packer and want to store it into File Geodatabase. Color: Color Template: Template File Source Blocks–> Block Name, Block Rotation, Block Size By, X, Y, Z Lines–> Line Type, Line Type Generation, Line weight, Line Scale, Line Elevation, Area–> Area Entity Type, Fill Pattern Name (if Gradient), Pattern Scale, Gradient Name, Gradient Fill Color 1, Fill Color 2, Fill angle, Fill Origin x, Fill Origin Y. Text–>Text Entity Type, True Type Font Name, Text Shape Name, Text Justification, Text Size, Text Rotation, Text.I also want to use these attributes by unpacking it in DWG Styler in some another workflow.Can help in this?Thanks in advance. Appreciate your quick support.

I have a set of nodes on this format:<node lat="56.07686365" lon="12.11483240" id="800000002" changeset="1" timestamp="2017-09-10T20:50:35.826Z" version="1">  <tag k="ActiveFrom" v="1900-01-01T02:00:00.000000000Z"/>  <tag k="ActiveTo" v="3000-01-01T01:59:59.000000000Z"/>  <tag k="ProductionPointCategory" v="4"/></node>When I read them in to the OSM reader as basic nodes, I get a list of tag{}.k and tag{}.v. I want to do some light filtering on this data, mainly checking if they exist in another dataset.Thereafter, I want to write them back to the same format that they came from. However, if I just connect the reader straight to the writer, it doesn't write out any of the content of the tag-list. I have to expose all the attributes that I want to be written, which seems like a backwards idea since the information is already there in the key-part of the tag-list.Is there a way to g

I am Testing for matches json.ID against SDE db sde.ID. The problem is no matches yet there are 26 matches in the test case. I think I have a data typing error. The sde.ID is VARCHAR2 (30 Byte) and I assume the json.ID is data source json. ANyway to covert to get a matchup??

Since I am new to FME I have no idea if this is even possible. I have an Access database that contains projects that are related to specific AutoCAD drawing located in the project folder. I want to create a KML file showing not only place markers (with attribute table in it) for each project but also DWG route. Place markers are easy to do, already done it but I am having trouble figuring out how to implement AutoCAD drawings. Is it possible to do it through Access database , or I have to use separate Reader for DWG files.Thank you

Hi There!We are having issues with the Google Sheets Writer timing out and failing. I worked with someone in Support & they were really helpful - but we didn't solve it. My boss was wondering - could it be a firewall issue on our side, and if so what ports need to be opened up to communicate? Thanks so much! Christen

Hi, I'm new to FME and I'm wondering if FME supports connections to Civil 3D survey databases? This would be helpful for syncing attributes in a projects survey database with other databases. More specifically point data in survey databases for my needs.I know Autodesk added a survey api in 2017 and they've upgraded the file type of the survey database in 2018. Project survey databases reside in the project folder and use data shortcuts in Civil 3D to connect the database to the projects drawings. The database is a Microsoft® SQL Server® Compact 3.5 database. New and converted survey database files for 2018 have the file extensions SDBX and SDXX.

I have a 3D gis file need to be converted to IFC format to analyse in Ansys. I had tried with FME, however the output files always has no geometry in it. How can I make it? Thank you

Hi,I have an FME Workbench that is writing to a dynamic schema.I have set the fme_feature_type and fme_feature_type_name explicitly using an AttributeCreator, but I keep getting this error when trying to write to an Excel spreadsheet:XLSX Writer: No DEF line could be found for feature type Does anyone have any ideas as to what this error means and how to solve it?I also get the following warning prior to the error, if this helps:Cannot define schema for 'RP_100CC' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration. I am using FME Desktop 2017.1 64 Bit.Thanks