Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,822 Posts
25,139 Replies

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

6822 Posts

Pass a list of files to the JPEG reader?

I would like to to use the DirectoryAndFilePath Reader to assemble a list of file paths, and then feed tha to a JPEG reader as the list it should read. I have also looked at the FeatureReader, to see if it could be used under program control. But I am drawing a blank. Any hints?

Does anyone know of a fast and simple way to "smudge" an ECW file? I know this sounds strange but I essentially want to read a large ECW file and smudge it so that you cannot see any details within the resulting output ECW image. Any ideas? Thank you in advance.

Transformation PostGIS to Bentley Microstation DGN V8

Hey all, I have a question about translating spatial data from a PostGIS database to Bentley Microstation DGN V8. Just to get an idea of what I am doing: the superior goal of my work is to store spatial data from DGN-V8-file in a central PostGIS-database, so that the spatial data can be accessed from any other place. So far, so good. The other way around, a DGN-V8-file should be the result when retrieving information from the PostGIS-database. The translation from DGN-V8 to PostGIS with FME works very well, all spatial information as well as additional attributes are transfered. On the way back, translating the PostGIS-tables to DGN-V8, the problem occures. All the geometry information gets into the new file as well as five attributes (igds_color, igds_weight, igds_style, igds_class, igds_graphic_group). But the rest of the attributes stored in the PostGIS database are ignored. They don't appear in the resulting DGN-V8-file. For instance, there is a table, which contain text infor

3D DGN Elevations to Shapefiles

Hi, I have a 3D Microstation v8 DGN file which I need to convert to shapefile. How do i get the elevation data out of the DGN and into an attribute field in the shapefile? Thanks!

Esrishape format

Hi, I have a doubt, Would it be possible to obtain the name of EsriShape file as an attribute of his reader? Thanks

LAS file to 3D pdf

This question was asked in February by SWach I'm having the same problem as Sarah with writing point clouds to 3D PDF and retaining colour. I assign the colour from a raster using the PointCloudOnRasterComponentSetter transformer. Then Coerce to points preserving the colour as an attribute and use this attribute in PDFStyler to assign the colour. Stills comes out black. Sarah's soloution "I needed to add an ElevationExtractor, Bufferer and 3D Forcer between the PointCloudCoercer and PDFStyler." If you're out there Sarah can you explain how you used these transformers to assign the colour from the imagery that is accepted by 3D PDF? Anyone else with ideas? Martin

Datadownload service not sending file geodatabase

Dear All , We are using datadownload service to extract data and sending it by email , output files excel and filegeodatabase , excel is zipped and sent by email , but file geodatabase is creaetd on the server but not zipped , that is why email is not contained the file geodatabase , is there is any reason for that. Thanks ,

swachContributor

LAS file to 3D pdf

Hello, I having issues creating a 3D pdf from a coloured LAS file. I can make the points display in the pdf but it is not displaying the colour of the points. What am I missing? Thanks Sarah Wach Manitoba Hydro

Authoring FME ETLs

I working within my organization to help fellow team members understand the differences between FME Workbench and FME Server. Could someone in the community provide an explanation of where FME ETL development occurs? Is it in FME Workbench; or, FME Server?

kimoContributor

OLD CSV reader fails in 2013 SP4

When I go to run my scripts written in earlier versions the csv reader fails all features, but wastes time reading them all with no errors. After fiddling around for half a day I found a workaround. Delete the old reader and add a new one with the same parameters. Just saving the workbench in the new format is not enough. So I will have to edit every single script written that uses a CSV reader. Not Happy.

Writing to Oracle Spatial with apparently valid geometries - but are rejected by Oracle DB

Hello all I have had it several times, that i cannot write to Oracle Spatial DB apparently correct (at least by GeometryValidator Transformer) geometries. I can write these geometries with other writers (i tested ESRI shapes and ESRI geodatabase). I know that oracle has his own strict geometry validation rules. Strange enough, the ORA-Error echoed back (ORA 20263) is not a common error found here for example: http://docs.oracle.com/cd/B14117_01/server.101/b10744/toc.htm Is there a way to check before the insert, if a geometry is valid (in strict Oracle DB terms). Or is there a parameter within the writer that can catch the Ora-Error, skip the geometry, and continue the process of writing with the other pending geometries? I'm working with FME Desktop 2013 (20130124), DB is Oracle Spatial 10.2.0.4.0 Yes, you guessed right, english is not my native language. I appreciate your help. Bernard

.TAB to GeoJson error

Hi there, I am doing a conversion from a .TAB file to a .JSON file. When i run the work bench normally it works fine. However, when i try to convert it to a batch file i get an error saying that it is unable to open output file. My reader is... G:\\spatial\\Manage\\ParkingBays\\Data\\PAT\\Road_Marking.TAB My writer is.... G:\\spatial\\Export\\External\\YellowLineParking\\Data\\Road_Marking.json and the error i get is....... Unable to open output file: 'G:\\spatial\\Export\\External\\YellowLineParking\\Data\\Road_Marking.json\\PAT' Can anyone explain to me how and why this error is occuring? Where does the "PAT" bit come from? And how can I stop it from happening? Many thanks in advance for your help. Matt

MapInfo .MAP file sizes

Hi All, Encountered an interesting problem today... The background is that we are currently migrating from MapInfo to Esri and are in the process of migrating the data. With MapInfo on life support we need to provide users with the data now residing in the SDE back into TAB format. So to do this we've written quite a few workbenches. What we have noticed is that the .MAP file is consistantly 20-30% larger in size than the original .MAP before it went into the SDE. I would normally attribute this to picking up some extra "stuff" in the double translation process, but if you take the TAB into MapInfo and pack the table, the .MAP returns to it's original size... Very strange. Can any-one tell me why? It's not an issue (for me) but I would love to know what's going on!

Layer/Shp/Geodatabase files - How to get this into a oracle table/database?

Hi guys, Pretty much written in subject. But got a few gis esri products. Shp, layer and geodatabases. I am wondering what is the best method to get these into a oracle database. Does anyone have any examples or point me into how to get this setup? Thank you

Creating feature-linked annotations in an ESRI geodatabase

Hallo everyone, I tried a lot, but can't find a solution. I have a polyline feature class in a file geodatabase and want to create several annotations out of it. That means, the non-annotation-feature has already been written. Writing multiple annotation classes according to the feature's attributes is already possible in my workflow, but they are not feature-linked yet. It is stated here, that the "geodb_linked_feature_id" attribute connects the feature's Object ID to the ID of the annotations and thereby virtually the two datasets. But what am I supposed to enter in this field? When I choose the OBJECTID attribute of the polyline feature nothing happens. A second point that confuses me: If the polyline feature would not be already written, the documentary (here) tells me to use the 'geodb_text_feat_class_name' format attribute to link annotations to the feature. In the example, the annotation class name is entered for this attribute. But what does it he

Extracting parameters from an FME Server notification message

Hi all, I’m using FME Server and ActiveMQ to chain together a series of workbenches, running each in turn depending on the notification messages sent between FME Server and ActiveMQ (JMS). The notifications sent from ActiveMQ are JSONs with the parameters required by the workbench to run successfully. For example, the notification will contain Source Dataset, Coordinate System, File Type, etc. My problem is that I need to pass the parameters defined in the notification to the workbench at runtime and don’t know how to accomplish this when the notification is being read from an FME Server Topic. Initially I was going to use scripted parameters to read a json containing the required parameters from a url and extract the required information. This works really well if the notification and its endpoint is well defined but, now that I’m trying to read my notification message from an FME Server Topic, I don’t have a well defined JSON (notification message) to read from. As an alt

almosttransform

Swiss Interlis 1 to Oracle no sdo_geometry column?

Hi Guys, I'm loading data from the Swiss interlis 1 reader (ili2fme) into Oracle Spatial Relational. All run fine but the oracle geometry is not created. Instead of this I have a my_table_sdgeom table created and inside a lot of columns and coordinates(sdo_X..). I'm a bit confuse because I would have expected the Oracle Spatial Relational writer to to create a sdo_geometry column. How can I create this sdo_geometry column? Regards!

vkiContributor

output to oracle

I'm new to FME, so my question may be quite simple: In ORACLE I would like to output the content of a table into a new table. Except for two attributes, the structure of new table is the same as the one of the input-table. The input-table has a field "Geometry" with the type "SDO_GEOMETRY" and the output-table has to have it too. (We don't have Oracle Spatial though). I first defined a reader (format: Oracle Spatial Object) and tried to define a writer. But what format do I have to choose for the writer? With oracle non-spatial I loose the geometry and with oracle Spatial Relational the geometry is no longer saved in an "SDO_GEOMETRY"-field, but in four new tables. How could I do this (is it possible at all without oracle spatial)? Many thanks in advance!

francis_mContributor

KML folder icon

Hi I have a workbench that create a kmz file with placemark and overlay within some nested folder. My placemark and photooverlay use a style that is referenced onto a web server. I want my folder to use a custom icon. All folder the same icon as my placemark and photooverlay. Any idea how to do this in FME ? thanks!

FME -> log file

Hello, Our source control team asks that we use the major, minor, build, patch identifier on our FME scripts. When they go to production they drop the patch. So...we start with blah_1.2.0.1.fmw and when promoted to production we have blah_1.2.0.fmw. What I'm struggling with is ensuring that the log generated for the blah_1.2.0.1.fmw is named the same; blah_1.2.0.1.fmw. Moreover, when in production...I need the log to be named blah_1.2.0.fmw. I've tried unsetting the log value among the workspace properties, but this only works one time in execution - i.e. the log being named the same as the script. How do I ensure this behavior is consistent? Note - I cannot, at this time, introduce additional flags when we call fme on the command line, nor do we allow scripts to be touched (edited) when in production...i.e. manually set the log name. Any help or advice would be greatly appreciated. -abe Longmont, Colorado

Basic question: How to extract nodes from polys ?

Hi, This simple task has been stumped. I'm trying to extract 3D nodes from 3D polylines and 3D polygons, to be stored as point features in a separate dataset.. I've tried TopologyBuilder, GeometryExtractor and a handful of other transformers, but I can't seem to find the right combo. I'm sure it's quite simple, but I do need advice on this. Cheers. Lars

issues with Writer

I'm using FeatureMerger to join a spatial and non-spatial database based on a common attribute (country column) and in the output, I'll like to write all attributes from both databases. I used "Copy attribute from Transformer", but it copied only some of the attributes...I tested it with just one database and selected Copy Attribute from Feature, it didnt select all the attributes as seen in picture. Please what am I doing wrongly? Thanks

Read XML via Web

Hi there, I am new to XML and the FME resources availible have been great so far. I am stumped though. I am trying to read a dynamic XML file via the web (similar to RSS I would assume). At this point I can access an XML file via the web and can save this file onto my local computer. Once that is done I take this XML file and use FME to flatten it for attributes and can also add in a 2D point to populate coordinate information... I am loving the FME funcationality so far. Where I am stuck is that I would like to have FME connect into to a web source to read an flatten the XML file instead of having to access the XML via a web browser and then save the XML file onto my local machine. If I plug in the XML url into a FME reader I get an error, here is an example of the error: "Sending HTTP 'GET' request to 'http://www.enetpulse.com/wp-content/uploads/sample_xml_feed_enetpulse_soccer.xml', waiting for response ... The uri-map document 'C:\\ap

Trying to find out if your software supports the conversion of ESRI shp file data to Spatial Info objects, (not just Autocad objects). Thanks in advance. Erc

Float / double value from XML

Hi, Let me explain what I want to do: I have a ".obj" file, and a ".xml" file which contains some metadata. The coordinates in the ".obj" file are in a local reference frame. Thus, to get them in a projected SRS, I need to translate them using some values that I can parse in the ".xml" file. What I want to do is: Read ".obj" and ".xml" file Compute convex (concave) hull of the geometries in the ".obj" file Translate the hull with values read from the ".xml" file Save the translated geometry in a ".shp" and force its EPSG with a value read in the ".xml" file In the ".xml" file, the EPSG is in the tag <SRS> (e.g. <SRS>EPSG:2154</SRS>) and the origin of the coordinates (the transltion I want to apply) is in the tag <SRSOrigin> (e.g. <SRSOrigin>652367,6862971,0</SRSOrigin>). These tags are enclosed in a ModelMetadata tag. To do the tra

1
...
254
255
256
257
258
259
260
...
273

Page 257 / 273

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

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

OK

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.