- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,826 Posts
25,147 Replies

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

6826 Posts

ciarabContributor

Mapinfo True Type Font

I have a mapinfo tab file and some of the text strings are not displaying correctly. I need to extract this string into an attribute but it is populating as 2 Á¶ . Is there a way to use the custom ttf file in fme to obtain the correct string?Thanks

How to replicate the summary / preview shown in a new Reader

When I add a new Reader, e.g., Excel, select a file, and then open the 'parameters' dialog, there's a summary showing 1. Sheets to Read, 2. Preview (of selected sheet), and 3. Attributes (of selected sheet). I want to replicate that in a workflow... how to do it? I just want to know how to get this information from the file, I don't need to know how to format it and all that.

8 years ago

elboukhari012b

asked in Data

how to convert polygon of postgresql to autocad

110

8 years ago

bearmanParticipant

asked in Data

Changing CAD Font style

Hi, I'm looking to convert CAD text to a line feature where the geometry represents the centre-line of the text. The basic algorithm is:generate the oriented bounding box of the CAD textgenerate the center line of that bounding box.This is working fine however it looks like FME uses a 'default' font style so when I change the font style in CAD the bounding box does not change. I've tried exposing various autocad properties and changing the style but when I use inspector the text (and resultant bounding box) are always the same. (Changing the size works, just not the style).Is there any way of converting the font style so it is honoured when you open it in Inspector?Or does inspector have a 'default' font it always uses?Thanks.Ash.

Google Geocoder rejections not being output

I have a number of google geocoder transformers in sequence which amongst other things take in the rejected outputs from the previous geocoder transformer. This works fine apart from the first geocoder in the sequence which doesnt carry a rejected count despite not passing the full input count. Has anyone come across this before? Any help appreciated!

8 years ago

guillaumefme

asked in Data

How could it be possible to display all elements of a list (created by the FeatureMerger transformer) in a KML Description Balloon?

8 years ago

kmickelraj

asked in Data

How to add 3ds file to all the citygml coordinates

8 years ago

Anonymous

asked in Data

Excel sheet name as parameter

I have a workspace that reads from a text file where each line is the path to a shapefile. I then have a workspace runner that passes each path to a second FME script as the [SourceDataset_SHAPE] parameter. The second FME script opens the shapefiles one by one and does some processing. This works well for formats like shape, DWG, and geojson, but it doesn't work for Excel because the FME script that gets sent the parameter doesn't know which sheet name to open. I can't seem to pass the sheet name as a parameter, and the sheet names are different for each Excel that I sent to this script so I can't hard code it. Is there a way to send that sheet name to the FME script and have it open the Excel and read from the desired sheet name? Thanks

3580

8 years ago

m_tengbrandParticipant

asked in Data

Problem reading SHP-file when I run workbench on FME-server

I have problem reading SHP-file when i run workbench on FME-server. The same workbench runs without problem on the same machine in FME-desktop.I get the error:BADNEWS: Shape Reader: Failed to open dataset '\\\\sv101\\webkartor\\ValsProd\\PPL_PPL_Y.shp' which is neither an existing file nor directory (shapread.cpp:307)Shape Reader: Failed to open dataset '\\\\sv101\\webkartor\\ValsProd\\PPL_PPL_Y.shp' which is neither an existing file nor directory (stftrans.cpp:275) - (..\\..\\..\\foundation\\framework\\engine\\reader.h:130) - (shapread.cpp:307)

110

8 years ago

tim_woodContributor

asked in Data

GeometryRefiner - Convert single points incorrectly stored as multipoint to point

I'm reading an FGDB point feature class containing single points but the geometry type has been incorrectly set as "multipoint". I thought I would need to fix this in my Workspace as I'm then sending the data to FeatureMerger to compare (attributes & geometry) against an older version of the data where the geometry type is set correctly as "point".So I used GeometryRefiner which appears to output the "multipoint" features as "point" features.However, FeatureMerger doesn't seem to need this. It produces the same results without using GeometryRefiner as it does with it. Happy days.Maybe Matcher would be less tolerant and GeometryRefiner would be needed there...?

geometry_text_string cannot be converted correctly

I have a oracle special data from database one which looks like below, it was a label or a text something. MDSYS.SDO_GEOMETRY(2001,82232,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,0,6001,11,1,1),MDSYS.SDO_ORDINATE_ARRAY(360.784660012623,0,0,1,131072,16,7209045,7602281,3211296,655373,630758.221843477,5523011.93164305))and I want to copy it to database two with FME.I added an AttributeExposer as a transformer to expose oracle_element{}, and added a ListExploder to list _element_index for the oracle_element{}. I also set geomedia_text_font_size to 0 with another AttributeCreater. But the result I got was always something like below:MDSYS.SDO_GEOMETRY(2001,82232,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,0,6001,8,1,1),MDSYS.SDO_ORDINATE_ARRAY(360.784660012623,0,0,1,65536,4,437918234,630758.221843477,5523011.93164305)).It seems the source data saved the geometry_text_string with 16 bytes, while the target data saved it in 8 bytes. My question is that is there any transformer or any way to copy the source data

150

8 years ago

fmelizardContributor

asked in Data

Writing to ArcSDE and getting ArcObjects Error '-2147215968' {Linestring or poly boundary is self-intersecting}

I am trying to write a polygon dataset to an ArcSDE database, but it is failing on one of the features!2016-11-17 18:59:51| 130.7| 3.7|ERROR |An error occurred while attempting to insert a row into the table 'citystreets' using a cursor. The error number from ArcObjects is: '-2147215968'. The error message from ArcObjects is: {Linestring or poly boundary is self-intersecting}I am using a GeometryValidator, but it isn't picking up any errors! What can I do?

Revit pipes network to 3d GIS (Postgis)

Is there any workaround to export 3d pipes from revit to postgis 3d? I installed the fme plugin to revit and exported into ifc with various options on but none of the exported files contained (or at least I couldnt find). My and goal is to export 3d pipes with various attributes + the 3d geom into postresql/postgis and visualize it in augmented reality (augment . net) Could you provide me some help how can I export pipes from revit to postgis 3d?

480

8 years ago

mmccartContributor

asked in Data

Can't Write values to ArcGIS Online Feature Services

This morning, FME Server started to throw errors writing <NULL> values to numeric values using the ArcGIS Online Writer. Everything was working until Esri upgraded AGOL overnight. We've submitted a ticket to Esri, but wanted to submit a question here as well.The error we're getting is: ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'AVL DB'. The error code from the server was '1000' and the message was: 'Attribute 'Right Wing Plow State' has an invalid value of ''. The value should be data type esriFieldTypeDouble.'We were able to successfully add a feature via the REST API using the following:[ { "geometry" : {"x" : -94.44920, "y" : 41.88339}, "attributes" : { "LABEL" : "Test Insert", "RIGHTWINGPLOW" : null, "ACTIVE_MATERIAL" : "NONE" } } ]Does anyone have the syntax needed

oscardInfluencer

Hi.I have to store a raster (ECW format) in a MBTILES (the writer is SQLITE).The raster looks like this:My first FME attempt has been this one: The MBTILES format needs two tables in the database: tiles and metada. FME builds the first one and then I create the second one with SQLite Browser. After renaming the database from .sqlite to .mbtiles, I add the file to QGIS to see the result: The bigger the zoom the crazier the puzzle.I have almost zero experience with FME and I don't know what I could do to fix this.Does anyone know what is wrong with the process? Or is there a better way to get a MBTILES from a raster?Thanks for your help!

Is there a way to distinguish feature types whether they are real tables or views?

Hi,I need to reproject feature coordinates (with ReframeReprojector) coming from an Oracle Spatial Object reader and therefore want to exclude feature types that are views from being reprojected.Manuel

8 years ago

peteralstorpContributor

asked in Data

Export 1 feature per PostGIS-table

Hello fellow, GISers.Simple yet complex problem. I want to export 1 feature per table for a schema in my PostGIS-database for test purposes. I want to output the data to shapefiles with filename=table name and output folder=schema name. I want the whole setup to be dynamic since I want to run it later on all my schemas (a schema list). This seems more tricky than I thought it would be. Any ideas?

8 years ago

cniven

asked in Data

Is it possible to direct Writer output into a new or existing ESRI feature data set (SDE)

I'd like to place output from a writer directly into a feature dataset. Is this possible using the existing canvas based tools, or with Python?

8 years ago

rnodagalaParticipant

asked in Data

How to read Geomedia smart store files (*.DDC)?

510

8 years ago

karnilContributor

asked in Data

Fail to export watertight (solid) 3D models

Hi! I am trying to get watertight solids from city roof data for 3D-printing. It seems as if somehow many of the solids from the extruded roof polygons sticks together and greates a mess that no 3D-printing software can handle. I have tried countless ways to get around this but it never gets better than this simple workspace. Does anyone have a clue what might be causing this? - The initial polygons are defined as IFMEPolygon in the inspector, and the output is set to .obj - None of the initial polygons are vertical. - In the inspector from the extrusion all is well, the extrusions seems to be independent solids).- In the obj most of them somehow gets mixed together?I feel I must be missing something really simple./Robin

8 years ago

frohoman

asked in Data

obj reader parameters

The obj reader includes parameters for files to be used for co-ordinate transformation. What are the format and extensions for these files.

8 years ago

n543

asked in Data

LAS spatial filtering using 3d object

Is it possible to spatially filter a LAS file using a 3d object? I have created a multipatch 3d AOI in ArcGIS expecting to be able to do 3d spatial analysis with it, but appears that LAS datasets cannot be used with the 3d Analyst extension - Inside 3d tool.Is this possible in FME? I have tried spatial relator but that does not seem to achieve what I am after.

Check if point is within polygon based on matching attribute.

Hi,One of the things I currently have to work on is checking if points from an Arc shapefile are within their proper postal code. I normally have to check this visually, but a coworker suggested I may be able to do this check in FME but he doesn't use it so could not really give any input as to how to do it.Basically, there are points that have a postal code assigned to them in their attributes and polygons that outline those postal codes.Looking at the software I was thinking this would be done with the PointOnAreaOverlayer transformer but I cannot figure out how to tell it to check if, for example, the point with postal code 62025 is inside the 62025 polygon.Any help with this would be greatly appreciated.Thank you.

Nested feature types in CityGML

Hi all,I'm interested in writing CityGML that comprise fairly complex relationships between features. From my current experiments It seems like producing nested structures is difficult, at least when using the in-built CityGML writer, and I have not been able to work this out. For example, I have been testing the IFC to CityGML workspace from the 3Dtutorial [1]. One part of this converting the IFCFurnishingElement and IFCBuildingProxy to the CItyGML BuildingFurniture type. According to the CityGML UML , the furniture type should be navigable from room which should be a part of the building. However it seems these features are skipped when writing out the file (even though features are counted up going to the writer). My end goal is to understand how to populate ADE attributes from the energy ADE xsd. While I can successfully write out feature types for the ADE with some attributes, I don't understand how to nest the features with each other. For example, ThermalBoundary composi

8 years ago

anne_shanahan

asked in Data

How to store folder connection credential within writter properties

Hi all, I'm hoping to use FME to replicate from our internal ESRI SDE (i.e. the FMW running as scheduled task sitting on our internal server) to a geodatabase that sits on a cloud server. To connect to the folder for the geodatabase I need to enter a Username and Password. As the task scheduler runs when I'm logged off the server the credentials need to be stored with the FMW rather than just a mapped network drive on Windows. Has anyone had any experience connecting to remote folders via FME or storing username/passwords within the writer properties? Some guidance would be great. I'm fairly new to FME. Thank you :)

280

8 years ago

Page 209 / 274

Badge winners

albineprohas earned the badge Welcome Back
andyliuhas earned the badge Student (Grey)
_fabian_has earned the badge Teacher (Bronze)
akesoderqvisthas earned the badge Teacher (Grey)
deepakkumar7250has earned the badge Student (Grey)

Show all badges

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