- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,819 Posts
25,118 Replies

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

6819 Posts

How to store a select result in a constant

I'm new on FME and want to know if is there a way to store an oracle select as constant? This value will be used to update some oracle tables.

how to extract 2d building foot print from lidar point cloud

how can i get 2d building foot print from lidar point cloud data?

I have Feature layer which is made with FME at AGOL. Now I would like to update that layer, but translation fails every time. I am using Esri ArcGIS Online (AGOL) Feature Service writer and Format Parameters are Writer Mode = INSERT, Truncate Layer First = YES and Rollback On Failure = YES. I think that it should work with those parameters. If I delete layer from AGOL, then it works fine, but if I don't delete layer, then translation fails. I would not like to delete layer manually. How to update AGOL Feature layer with FME?

How to determine position of one feature in relation to another?

Hello,I have 2 Shape files, one point, other line. I need to determine on which side of the line point feature is located. I need to take only points that are within 5m of line. For every point I need to add new attribute that will allow me later to separate right and left.Orientation of the line is determined by start and end point of the line.This is way out of my league so I need Your help.

How to define material/appearance in the cesium 3d tiles writer?

HiIs there any convenient way to modify the material definiton for the batched 3d models when using cesium 3d tiles writer?I'm creating b3dm from CityGML and viewing them in the Cesium app in a browser. My problem is that some of the facades look too dark because of the shading according to the position of the sun. I read that setting some of the material settings of the gLTF, so that any shading from light source is flat, should solve the problem and make the building equally bright on each surface. It would be awesome if one could define these material/appearance settings as parameter values in the cesium 3d tiles writer.

Incremental extract of Intergraph data to Smallworld

I am looking to do an initial extract of a utility customer's Intergraph data to Smallworld using FME workbench. Is there a way to do an incremental extract on a nightly basis, without completely reloading the entire database?In other words, is there a way to identify daily changes in Intergraph data (ie time stamp, versions, etc) ?@MarkAtSafe

6 years ago

greenstone1564

asked in Data

Output buildings into individual .obj files

So I have a large CityGML file, which is the LoD2 model of New York City. I now would like to export all buildings into individual .obj files. Currently I am facing two challenges:The file is too large (30G) to be loaded into FME data inspector directly.I do not know how to extract individual buildings in a programmatic way.I already loaded the data file into a 3D City Database using the importer / exporter. But still confused how to solve the two technical challenges above. Any advice would be helpful. Thanks!

Issue authorizing FMEServer for ArcGIS Online

Hi @Mark2AtSafe, @RylanAtSafeHaving trouble authorizing FME Server (FME Server 2017.0 - Build 17259 - win64) for use with ArcGIS Online. The FMEServer instance is part of a private network, therefore I have followed examples including those at:https://knowledge.safe.com/questions/43567/arcgis-online-oauth-authorize-issue-on-fme-server.htmlhttps://knowledge.safe.com/questions/65076/connecting-to-arcgis-online-via-fme-server.htmlhttps://knowledge.safe.com/articles/40215/configuring-fme-server-to-use-oauth-based-web-conn.html I have done the following:The FMEServer has been enabled for HTTPSThe service account under which FMEServer runs on the server has necessary proxy whitelisting to hit the AGOL domainsSince the FMEServer is private, it is not accessible publicly, nor has a public DNS entry. So as per the example in (3) I have set up a nip.io redirect to the IP address of the 'private' FMEServerI've got a registered application in AGOL (so got a clientId, clientSecret etc).

Highlight Cells in Existing Worksheet

Hi Everyone,I have a workflow that takes a submitted Excel workbook and validates all of the input. The validations are not simple and often require checking data against databases, checking against other rows/tabs in the workbook etc. At the moment, I am writing out any issues/validation failures to a text file e.g. The value: 'XYZ' supplied on Tab: 'Tab1' in Row:5 Column:'C' is invalid for reason 'ABC'. I would like to highlight Cell C5 in red on the original file and send it back. I don't want to create a new file or write all the data back out, just simply locate specific cells in the file I read in at the start and change their formatting. Is this possible? Thanks!J

6 years ago

kmeinert

asked in Data

Writing to an ArcSDE Versioned table - where did my edits go?

So I'm simply trying to update a versioned table (happens to be non-spatial) in my ArcSDE database. The table exists now in SDE, I just want to truncate it and replace it with a whole new set of records every so often. Everything seems to run correctly in the log, but when I go view the table, even under my version (the one I used in the writer), all the old records are there like nothing ever happened. It says it wrote them, where did they go? So not only did it not truncate the table like I told it to, it didn't write the new records either. If it matters, I've tried using both SDE writers with the same result. Tried using the Insert vs Update parameter, same result. Tried using the SDE default version instead of my own, same result. This is a 10.0 SQL database, but I have 10.1 loaded on my desktop.

Hi, I have a table containing Id's and url's referring to online pdf's. For each record in the table I want to search a specific string in the associated pdf. If the string has a match in the pdf, I want to retrieve the Id from the record containing the url to the pdf. I tried using feature reader en pdf reader but didn't get far. So any help would be welcome.Idris

Generating X & Y points for Chainage

Hi guys, Hope you are well. I am just trying to figure out what would be the best way of doing this and if FME has a method. I understand Arcmap can do this but may take sometime.I have a shapefile generated which has a chainage of a road with various chainage parts/distances. I then have a spreadsheet which contains 40 records which has a start chainage and end chainage. What i require is to create X & Y coordinates for the start chainage and end chainage within the chainage of the shapefile for the spreadsheet. So basically this spreadsheet will then have another column with the X and Y coordinates.What would be the best process to do this? Is there a specific transformer that can be used to create these points? Start ChainageEnd Chainage153150154340

Delete existing records instead of Truncate in Oracle Spatial Writer before Loading new data

I am creating a Dynamic Data Uploading Workspace which will read all .mdb files present inside a folder & upload Data in the corresponding tables in Orace Spatial DB. The problem is the DB user which I have, to perform this Upload operation does'nt have Truncate rights on tables since its not the Table Owner & for policy reasons it cannot be given these rights although it has Insert,Update,Delete rights. How do I Delete records from Tables before inserting new ones? Apart from creating 2 seperate workbenches, First for deleting the records using SQLExecuter & second for inserting using Dynamic writer & connecting the 2 using Batch Processing.

Problem writing a dwg filename which contains arabic character

Hi,Using fme workbench I am writing(fan out) dwg files. Some of the filename has arabic character which fme is not able to write. following is the messageERROR |AutoCAD Writer: An error occurred for dataset 'D:\\Projects\\Filegdb_to_AutoCad\\Output-dwg\\?????? ????.dwg', in function RealDWGWriter::saveDatabaseAs: 'eFilerError'Note: fme is able to write arabic attribute as OD without any issue but the cannot create file.I am on windows 10 arabic enable OS. I can create arabic filename outside fme.Any solution or workaround.Regards

180

6 years ago

asked in Data

Is it possible to write Geodatabase metadata using FME Cloud/Server?

Only the Open API Geodatabase writer can be used on FME Server/Cloud, which doesn't allow you to expose the 'geodb_type' and 'geodb_metadata_string' format attributes. Is anyone aware of a workaround for writing metadata to Geodatabase? This seems to be a major drawback of Server/Cloud if not.

Hi, I try to open an XML file downloaded with the SentinelDownloader but I get this error: Loaded module 'SENTINEL2' from file 'C:\\Program Files\\FME\\plugins/gdal/GDAL.dll'FME API version of module 'SENTINEL2' matches current internal version (3.8 20180604)SENTINEL2 reader: Opening dataset 'C:/4-Igual que 3 pero bajando ALL/all/S2A_MSIL2A_20181103T111221_N0209_R137_T30TVK_20181103T122857.SAFE/MTD_MSIL2A.xml'SENTINEL2 reader: Cannot find =Level-2A_User_Product.General_Info.L2A_Product_InfoSENTINEL2 reader: Failed to open the dataset 'C:/4-Igual que 3 pero bajando ALL/all/S2A_MSIL2A_20181103T111221_N0209_R137_T30TVK_20181103T122857.SAFE/MTD_MSIL2A.xml'. Please ensure source data is valid and correct reader is selectedA fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'SENTINEL2' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, depend

Reading fme_connections.data

Hi all,I am trying to create a workspace to automatically review other workspaces to ensure they meet our development standards and guidelines. One of these standards is that all connections used should be in the master connections file we all share. Which reader do I use to read the fme_connections.data file and get a list of the connection names? A standard text reader returns a load of #$@#@!# so I assume it's encrypted somehow?Thanks in advanceJames

Read THREDDS Data Server Data Via OPeNDAP into FME Workbench

Is it possible to read in data into an fme workbench from a THREDDS data server via Opendap? I can see that this article (https://blog.safe.com/2014/10/netcdf-meets-gis-geospatial-architecture-scientific-data/) suggests that it is possible but a cannot find any useful resources that explains the process. Any help/direction to docs will be much appreciated.

Global Mapper GMG Format

Hi, having problems Reading a Global Mapper raster format: *.GMGThe *.gmg format is a grid format in binary formAnyone know how to read it with fme?

How to create a KML file from a set of jpg geotagged

Hello, I am new in FME.I need to create a KML that contains a set of placemarks with every jpg geotagged photo.INPUT: Set of jpg geotaggedOUPUT: KML with photo icons that I clic and show me the photo in a window. Thanks for your answers.

How to add text to buildings?

I'm trying to generalize the map. I want to add building names to their geometry, but I have a problem with that. I tried to use TextAdder and Aggregator and the result is good. I then use the temporary location to be able to use ArcPy and here the problem arises. When I add TextAdder and Aggregator, I get an error:Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.ERROR 000732: Input Features: Dataset pre_aggregation does not exist or is not supported When I don't use TextAdder and Aggregator everything is good.

6 years ago

venuContributor

asked in Data

File geodatabase output in Network location issue

I am generating Results with Esri file geodatabase in Network location but I am receiving following errorUnable to connect to the File Geodatabase at '\\\\server\\project\\Test.gdb'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024894'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details Please advise for further.

Is there existing FME transfomer for me to connect text and point?

I would like to combine existing text to the point attribute (z-coord). In the picture there is point and line string to point to it. In the other end of the line, there is a text object. All object are separate ones. Only the each object coordinates gives the hint, which text belongs to which point. Anyway Happy New Year from Finland despite the latest ice hockey result. ;-)

How to create underground properties in a Minecraft map?

Hi everyone, I'm working on a Minecraft map based on a DEM and some layers, like rivers, vegetation and underground.I'd like to get some tips about how to associate geological layers to a DEM point cloud and then export to Minecraft. I have a .tiff and some .shp files, and I'm using Bowen Island's workbench as a basis, so I think it might be associate to the custom transformer "MinecraftRasterizer". Thanks in advance!

Hello, does anyone know how to create and write microstation dgn text with leader lines? Many thanks, Owen

190

6 years ago

Page 134 / 273

Badge winners

ngstokehas earned the badge Welcome Back
erniehas earned the badge Student (Grey)
erniehas earned the badge Expert (Grey)
nimirat5has earned the badge Expert (Grey)
nimirat5has earned the badge Teacher (Grey)

Show all badges

30,419: 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.