- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,779 Posts
24,922 Replies

When you subscribe we will email you when there is a new topic in this category

6779 Posts

Recently active

Most replies Most views Newest first

robertdbuckley

asked in Data

Is there anyway I can use the rasterCellcoercer to write directly into an xyz file?

I am creating xyz files from a DEM Raster using the RasterCellCoercer to create a point feature containing heights from the DEM. I am writing first into an ESRI geodatabase, and then using the coordinate extractor to write X,Y,Z fields to a CSV file then renaming it to *.xyz.Is there maybe a more straight forward way of doing this? Could I cut out the ESRI Geodatabase and write directly from the RasterCellCoercer into a xyz?

601

6 years ago

jdhContributor

asked in Data

Exclude wildcard on reader

I have two files in a common directory with the following naming scheme{Know prefix}_{variable suffix} {Know prefix}_{known infix}_{variable suffix}ex. ABC_123 ABC_XYZ_123Is there an easy way to read in only the file without the infix? The standard wildcard {prefix}* will pick up both files. Currently I'm testing the fme feature type to see whether or not it contains the infix, but ideally I would like to not even read it in.

Error Reading Attachments Using the Esri ArcGIS Portal Feature Service Reader

Hello,I am unable to read attachments from my hosted feature service on Portal, using the Esri ArcGIS Portal Feature Service Reader. If I set "Include Attachments" to no, I am able to read the hosted data without attachments, but when I set "Include Attachments" to yes, my translation fails, and I get the following error:Here are the reader parameters used when the workspace fails:Does anyone have any ideas on why this isn't working? I have attached the full log file (run with debugging turned on) in case that helps.Thank you,Courtney

Hello, I am trying to make a Shape file from my DWG. I am trying to use only one layer from DWG because that is all I need. Basically I am trying to close all the polygons in that layer, and calculate their area and to write their area in shp. I am not getting a good result and I have no idea what could be the problem.Also, I was wondering if I can get a result written in form of "P= "number" m2". Now I am getting this from screen shot.

297

6 years ago

mhabContributor

asked in Data

KML writer: How to draw wireframe of solids in different color (better display)

HelloI write solids to KML and want to give the borderlines/wireframe of the solid a different color/alpha in order to get better visibility of the solid.I try KMLStyler with Color 0,0,0 (black) and Opacity 1 and Fill Color set to red and Fill Opacity set to 0.7.I don't see any effect however. There is no wireframe visible, like I used to get it years ago with the first version of KML writer ...Any hints what maybe wrong ?Seems like I need to duplicate the wireframe as independent feature ...

Hello, I am trying to make a raster from two SHP files. It is a bit specific so I would like to ask you if maybe somebody has any good idea what is the best idea how to solve this. I am having two input Shape files that have multiple attributes. In one file, I first want to take only two classes from one attribute (ROADS: Motorway and Residential) and give them specific thickness, all the others can be normal width. (I was wondering if the best way to solve it is Tester ---> AttributeCreator).After that, I would like to prepare that for printing. Best way would probably be transforming it to raster. (MapnikRasterizer???) I would need to specify the window that I want to be printed and I know that it can be done with MapnikRasterizer. I am looking forward to all good ideas and suggestions how to solve this.Thank you all in advance!

6 years ago

peteralstorpContributor

asked in Data

Excel corrupt file resulting from using an Excel .xlsm template

Here's a tricky one. We're using an excel marcro-enabled (xlsm) file as a template and in the script we're populating it with various info from textfiles and more. When we try to open the resulting Excel file with Excel (2016) the file doesn't open. We're getting an error message saying there's something wrong with the file and would you like to try to fix the errors? The offered fix isn't good enough. I'm thinking this might have to do with the xlsm-format or maybe it's a language issue. We've had help from SAFE resaving the file and then this would sometimes remedy the situation. Anyways, this is just to check if anybody has encountered the same problem and have any ideas as to what in the excel template can cause this error. We have macros in the file and from what I can gather no other strange things.Thankful for any suggestions.

BIM to GIS Basic Tutorial

I am trying to go from an IFC fil to cityGML in accordance with the BIM to GIS (Basic) | IFC LOD 100 to LOD 2 CityGML tutorial. I am currently tying to replicate all the 4 steps within my own workspace with my own readers. However in step 3 "Set Attributes and traits" my AttributeCreator doesn't work and I find the tutorial lacking in showing how to set it up.So how do i setup my transformers in step3?Both the AttributeCreator and the GeometryPropertySetter

342

6 years ago

jorge_rosalesContributor

asked in Data

SVG Writer layer style attribute question

When I use an attribute value in SVG Writer "Feature Type Name", it seems that layer style attribute doesn´t work. The layer style custom value doesn´t appear in inner SVG <g>. Futhermore, allow an attribute value in layer style attribute would be fine (now only a text string).

6 years ago

gerryjamesContributor

asked in Data

Create AutoCAD block with Aggregator but maintain layer of individual features

I have created a workbench that transforms DGN cells to AutoCAD blocks. In this process I am trying to set a feature to the defpoints layer but when I aggregate to a block it puts all features on 0. Is there a way to keep that defpoints layer when aggregating?

Can´t read files inside subfolders

Hi!I need help. No matter how I try, it does not read the files contained inside different subfolders. I was told to set the path so in the Dataset appears like this: <pathname>\\**and replace the pathname with mine. I have 2 readers combined together, and excel sheet and the subfolders inside a main folder. I have set it so there is an error report in the end and it keeps on telling me, that the files are not inside the subfolders. The files formats are different: pdf, dwg, etc..Thanks for your help in advance!!

Error on conversion of CityGML file to IMX

When I use FME Quick Translator to convert CityGML file to IMX, I get this error. How can I fix it?

242

6 years ago

masonb12Contributor

asked in Data

Converting point clouds to GeoTiffs to compare elevations

Could someone recommend the best transformer for converting 2 point clouds to a geotiffs so that they can be compared for differences in elevations? Also what is recommended to use as a surface tolerance and output dem x and y spacings using the Rasterdemgenerator? I have two point clouds representing 2 different years. I would like to compare any differences in elevations by calculating the difference in elevations. The area is very flat and differences can be less than 1m. Any guidance appreciated. thanks

How do i extract geometry saves to a long raw column in oracle?

Hi all the data in the column looks like its in a binary format but everything i try fails, please help. Here is an example of a record. 30303130010000000700000075B5157B9CB80F4187EB51B8CEEA08414282E24755B90F41EE51B81ED9EA0841D36F5F477DB90F41EE51B81ED9EA084132772DE1C6B90F41808CB9EBD9EA084132772DE1C6B90F41F6FDD4B882EA0841E27A14AE9BB80F41AB13D0847FEA084175B5157B9CB80F4187EB51B8CEEA08410000000000

expose custom Revit attribute in IFC

hello all,i have created some customer parameters in Revit and would like to expose them in FME as attributei have tried to use the Revit read as it does expose more attributes then the IFC reader, but it still only shows the default Revit parameters, i am sure AttrivuteExposer or GeometryPropertyExtractor would do the trick, but i am really strugging to expose the data. any help with this would be greatcheers,James

I want to create LOD2 objects from LAS file. As input i only have 2D buildings as polygons, representing boundary of building, with no roof-ridges or other roof details, only polygons (without elevation)I want to create roof-ridges and roof surfaces.How do I use FME to make areas to represent roof sides? So i need the maximum and minimum elevation inside the boundary but how to do to make roof sides ?I used a clipper between las and boundary and after a pointcloudcalculator but after i use a geometryreplacer i don't understand all geometries exit rejected why ?And after it's necessary to use 3d Forcer, i need help !!Thank youNat

Exporting difference from Smallworld is not able to distinguish Insert & Update through fme_db_operations

I created a workbench to translate from Smallworld to GeoDatabase. In my Smallworld reader, I've specified to export the difference between a checkpoint (base) and an alternative. The difference between the alternative and the base (checkpoint) was 1 insert and 1 update. I used the AttributeCreator transformer to inspect the fmd_db_operation for insert, then insert the object into the GeoDatabase writer. However, it treat both records as insert and inserted both records (the insert & the update) into the GeoDatabase writer.

Using RGB-values in LAS-files

Hi all,I'm having a simple question about using the Red-Green-Blue (RGB-) values from point clouds. I have a LAS-file, which is already coloured and does display the RGB-values when I open the LAS-file in the FME Data Inspector. However, it seems impossible to use those values in any kind of calculator. I have a GIS-background, and I am used to a strict vector/raster data separation. It seems like a LAS-file is read as a raster, although it can contain multiple points per [xy]-value (e.g. walls, tree stems). I want to use the RGB-values that are already in de point properties. I see how I can keep them (e.g. PointCloudPropertyExtractor), but there seems to be no way to use these properties in any kind of calculation tool. The reason why I want to do this, is because I want to filter some points out based upon the ratio (R+G)/B.Suggestions are welcome :)Thanks in advance,Martin

1282

6 years ago

hirooimakiContributor

asked in Data

paraview vtk file and its attributes

Hi there. I have just started to use FME and am still learning this super capable software.I have a question regarding vtk (paraview data file, legacy format).I want to read vtk legacy files and convert to different 3D file format like 3D Tiles or IFC. And it is important to keep attributes when I convert vtk files. So far, I am converting vtk files to stl format using a python script but it won't keep attributes (or values). Do you think I can somehow convert vtk legacy files using FME? or Safe Software can somehow develop the reader for vtk legacy format?? I searched community postings but I couldn't find any answers.Thank you!

pratapContributor

Hi,Is there any possibility to know the version of AutoCAD dwg file in which it is saved-in...Prtap

Are there efforts underway to support fields of type 'Lookup' in Microsoft SharePoint List Reader in a future FME Desktop Version?

We are using following FME product: FME(R) 2016.0.1.1 (20160224 - Build 16177 - WIN32) We noticed that fields of type 'Lookup' are not supported. We get following error: Microsoft SharePoint List Reader: The Field 'Gemeinde' of type 'Lookup' is currently not supported and will be excluded from the feature schema.Are there efforts underway to support fields of type 'Lookup' in Microsoft SharePoint List Reader in a future FME Desktop Version? Or is there a know workaround solving this problem?

6 years ago

vishnuedakkat93

asked in Data

How to convert ESRI shapefile to CityGML by using an ADE with proper geometry(LoD)?

I am having different dataset, that i have to convert to CityGML using ADEs. When am trying to do this, TRANSLATION WAS SUCCESSFUL is displayed (eg: 780 features transformed)BUt, when am viewing it in FME Data Inspector, "THERE IS NO GEOMETRY IN THIS VIEW" is shownI am using FME trail version. LOG TABLE shows this: "The 'FFS' reader was destroyed successfullyFailed to display the table contents due to the following error:----------------------------------------------------------------The floating license environment variable LM_LICENSE_FILE is defined, but is ignored by FME. To enable FME to use LM_LICENSE_FILE, set the environment variable FME_USE_LM_ENVIRONMENT to the value YES."please help me..----------------------------------------------------------------

FeatureWriter transformer behaves differently on FME Server 2016.1 and FME Desktop 2016.1 (it ignores DWG template files)

I am using FME Server 2016.1.1 and FME Desktop 2016.1.3.1 to make a workspace for FME Server that will write a DXF/DWG file with the FeatureWriter transformer. I have to use a template DWG file to be able to write the correct linetypes and block names.But I have noticed that the FeatureWriter transformer, when running on FME Server, will simply ignore the template DWG file I have specified, and write in the log that "No AutoCAD Template file specified". However, running the same workspace, with the same parameters, locally on FME Desktop, the FeatureWriter transformer will use the template DWG file as expected.I have tried putting the template DWG file on the server's local C: drive with an absolute path, putting the template DWG file on a network share with an UNC path, and uploading the tempate DWG file when publishing the workspace. No matter what, the FeatureWriter transformer will always always ignore the template DWG file when running on FME Server.The only way I ha

6 years ago

sandeepreddy124

asked in Data

How to give Autofitwidth to xlsx file using alasql

Hi can anyone please help me to find an answer to keep autofitwidth to all columns in xlsx file

6 years ago

josesauz

asked in Data

Oracle Spatial data - Sql Creator output

I am using SQL executor to get some data from Oracle SpatialData, Im getting the data but is not possible export/output in a shapefile or .gdb (Polylines)...Please advice

132

6 years ago

Page 169 / 272

Badge winners

disco2000has earned the badge Welcome Back
mikeinhamiltonhas earned the badge Teacher (Grey)
mikeinhamiltonhas earned the badge English Speaker
mikeinhamiltonhas earned the badge Student (Grey)
mikeinhamiltonhas earned the badge Expert (Grey)

Show all badges

30,107: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.