- - 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,921 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

raimondContributor

asked in Data

ORA-12592 and ORA-03135

The translation is running and writing records to Oracle. But suddenly i get an Oracle error ORA-12592 or ORA-03135 and the translation stops.The database is online.What can cause this problem.

151

7 years ago

sigtillContributor

asked in Data

RECORD streaming KMZ-file

You can use FME Server to stream a KMZ-file to a Google Earth instance. However, can you also do the reverse? Ie get FME Desktop or FME Server to Record data from a KMZ-file-stream?

7 years ago

robyn_studts

asked in Data

Draw lines between points

I have an object that has that has two Point styles. I can translate point styles into cells in Microstation but I would like to generate a line that will go between the two cells. To be honest I am not sure where to even start. Any help would be appriciated

How do I translate Smallworld 4.22 linears into microstation custom line styles

In a previous question I asked how to translate a custom line style from one Microstation file to another and the answer was add the lines with the custom styles to the seed file save it delete the lines and don't compress. It worked brilliantly. Now I need to translate from Smallworld into Microstation and have a chain that I am translating from Smallworld use a custom line style in Microstation. I tried using the same seed file as before and the same methodology or at least as close as I could when creating the fmw file and it did not work. I guess the question is, can I create a line in Microstation using a custom line style from a Smallworld chain object? and if so how?Any help would be appretiatedThanksRobyn

Good morning,I have a FME Server job that runs a python caller. Part of this python caller is to run some sql in a postgres database. When I look in my fme job log I can see the step being called but I don't see any logging from the sql. Is it possible to add the logging from the postgres log into the fme log?

WebService GML Reader Error 422

Someone have idea? why my WebService give error 422 (Unprocessable Entity) when i use reader GML? If i use "Text File", my WebService works!?!?!?

After a cell update via sql, the formulas in Excel don't update automatically

Hi all,I am updating a cell of an Excel sheet using a SQLExecutor. The update of the cell works fine but I have a formula links to this cell that doesn't update.I check in Excel and the Woorkbook Calculation parameter is set to automatic.As I have more than 1000 formulas, I don't want to clik on them and press enter (the only solution I found for now) to update them.I put in attached the workspace.

ciarabContributor

Hi I'm not very familiar with ESRI software. I have created an update/insert process on a Layer I created in AGOL and I noticed even though I specifed 500 char for a field in FME writer, it is truncated to 254 when written to AGOL. Does AGOL adhere to the shp limitations of 254 char max or have I missed something ? ThanksCiara

From which format to a 3D Minecraft City Map

I'm a Minecraft user that would like to model my city including some buildings.Unfortunately I don't know the type of file that include this kind of 3d coordinates and so I'm asking here. If I'm looking for a dataset that has information about the GPS location of my territory but including also 3d information about the buildings of my city which format I should look for ?Thanks!Gavin

7 years ago

ian2016

asked in Data

Can I use something similar to update and ERSI File Geodatabase

Can I use something similar to update and ERSI File Geodatabase. I am trying to use the fme_db_operation but no data is being updated

7 years ago

fmelizardContributor

asked in Data

Create heatmaps on an hourly basis

I need to create heat maps on an hourly basis using FME. Is there a third party service I can call from FME or a technique that works well?

SDE Writer - Existing Table Error ('-2147216061')

I'm using the Esri Geodatabase (ArcSDE Geodb) writer to try to inset features into an existing feature class but when I do I get a fatal error saying that the table already exists ('-2147216061'). The error text in the log begins, "An error occurred while attempting to create the feature class...". Why is it trying to re-create the feature class when it knows that I imported it when I added the writer?_________________________________________________Writer Mode: UPDATE (Tested INSERT and got same results)Transaction Type: TransactionsFeature Class Settings - Drop Table: No / Truncate Table: YesFME: 2016.1.2.1ArcGIS: 10.3.1SDE Database: 10.4.0 (non-versioned)__________________________________________________

CityGML generic Attributes

Hi there, i have a CityGML writer which works perfect and writes Lod0FootPrint's for buildings. However the generic attributes attached to the buildings are not written completely. The writer is just writing one generic attribute and is ignoring the other ones. What do i have to do? I enbaled the "Include Generic Attributes as Feature Types" option! Thx in advance Thomas

455

7 years ago

boubcherContributor

asked in Data

Data Base data download

Hello There we build a service to doeload data direct from the Data base , some time the user cear a new view or table that represent layer we in the request we will send the table name as parameter but worksapce need to scan the availability of that table each time the request commes and complet the process for the down load , this way we dont have to predefine the table in the work sapce in advance Any idea how we acheive that

7 years ago

brooks

asked in Data

Update writer schema from reader schema changes

I am trying to figure out a way to update the schema of a writer after changes are made to the schema of a reader. In this case, there are no transformers, just a reader pointing directly to a writer. The name on the writer is different from the reader but that is the only difference. Occasionally a field length will change on the reader or a new field is added to the reader. I can bring those changes into the workspace by updating the reader, and I am looking for a way for the change attributes of the writer if the reader changes.

Use of the Geometryreplacer

I have managed so far to extract a bunch of features from the output of a HttpCaller. All features are meant to be linestrings. In an attribute, conveniently called Linestring there is a list of coordinates, for example: 52.1626086 4.5000322 52.1632634 4.5000649 52.1633422 4.4997202 52.1634249 4.4993502 52.1634390 4.4993159.To the best of my knowledge, I can use a GeometryReplacer that is pointed towards the attribute Linestring and has as encoding GML. Which should result in linestring geometries. However the conversion fails, without any noticable messages in the log. Does anybody have any suggestions?Thanks in advance

589

7 years ago

lazarlubomirContributor

asked in Data

Export of SQL update script for Oracle

Hello,please, I just wanna ask, if FME Desktop is able to generate SQL update script for ORACLE database, e.g. in sql format?Example:UPDATE sampleSET band='CCC'WHERE fid=123456Thank You for tips!Lubo

7 years ago

tim_woodContributor

asked in Data

Setting fme_db_operation value from an attribute

I have an FGDB feature class which includes a "DBOperation" attribute with values of INSERT, UPDATE, or DELETE. I want to assign these to fme_db_operation but when I do this in an AttributeCreator, it gets changed to...<at>Value<openparen>DBOperation<closeparen>I've changed the AtrributeCreator to Conditional Value which seems to be happier.Has anyone else had this experience?

Inform write jpeg_exif_xresolution header

Hello,Is possible to inform or write jpeg_exif_xresolution and jpeg_exif_yresolution header in a jpg image created with FME Server?Thanks in advance

7 years ago

gaelle

asked in Data

How to convert 2 buildings from 2 different IFC files in a single CityGML file?

I have 2 buildings, each with its own IFC file and I am able to convert them individually from IFC to LOD2 CityGml.Those 2 buildings are part of the same neighborhood, and I would like to have them combined in a single CityGML file.I have basically combined the 2 individual workbenches in a new workbench so the transformation run in parallel, to have 2 building features in a single GityGml file. A cityGML is generated which is 6000KB but there is no geometry.Anyone know how to fix that?

7 years ago

sigtillContributor

asked in Data

Connection issues to MS SQL

I have read this: https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.htmlAnd tried to fix it with all these steps, with no luck. UPDATE: With respect to workspaces these was updated from FME Server 2015.1.3.1 - Build 15573 - win64 to FME Server 2016.1.2.1 - Build 16674 - win642017-01-24 20:12:10| 0.1| 0.0|INFORM|FME Configuration: Using Named Connection values from 'XXX' for MSSQL_ADO_12017-01-24 20:12:10| 0.1| 0.0|INFORM|Creating reader for format: Microsoft SQL Server Non-Spatial2017-01-24 20:12:10| 0.1| 0.0|INFORM|Trying to find a DYNAMIC plugin for reader named `MSSQL_ADO'2017-01-24 20:12:10| 0.1| 0.0|INFORM|FME API version of module 'MSSQL_ADO' matches current internal version (3.8 20160224)2017-01-24 20:12:10| 0.1| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 2 DEF line(s). Found 9 attribute(s)2017-01-24 20:12:10| 0.1| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `XXX' for read operation2017-01-

Photogrammetry Point cloud Noise removal

I have a point cloud of a surface which has been derived from pix4d photgrammetry software. There is a large amount of noise and outlying points generated, which when triangulating a surface creates a bumpy surface. These point clouds are for relatively flat ground surfaces. Unfortunately pix4d does not have an easy solution to remove of such outlying pointsTo help smooth the point cloud and the resultant end data, is there a way to filter the point cloud to remove these outliers if i know the maximum slope of the surface? Or if this is not possible that the elevation difference between points is too large? Thanks.

How do I create a hyperlink from a shapefile to an image url?

Is it possible to create a hyperlink to an image url in a csv spreadsheet using fme?

How to create parameters for selecting a table (feature type) from an Esri geodatabase (gdb)?

I want to create (user) parameters for selecting a table (feature type) from an Esri geodatabase (gdb). So I would like to see a dialog which asks for an gdb and afterwards show a list with all the feature types (tables) from the selected gdb.How to do so? I am able to create a parameter for selecting a gdb but how to add a list of the feature types which are part of the gdb and select one? Any idea?Best regards,Frank

112

7 years ago

Page 205 / 272

Badge winners

epro_adminhas earned the badge Welcome Back
adrian_farrellhas earned the badge Welcome Back
jsextonhas earned the badge Welcome Back
carolina_whas earned the badge Webinar Watcher (Bronze)
user01has earned the badge Welcome Back

Show all badges

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