Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,828 Posts
  • 25,154 Replies
6828 Posts
itay
Contributor
itayContributor
asked in Data
Design file working units

Hi all,I was wondering if there is a way to influence the creation of DWG files, without the use of a template file, so that it would be displayed in meters as working units in Microstation?

80
erik_jan
Contributor
8 years ago
L
limpan
asked in Data
Problem using direct connect to ESRI Geodatabase from FME Server

On my server machine I can use direct connect in ArcCatalog to connect to a Geodatabase, Using the same parameters (sde:oracle11g:<dbinstance> )in FME Server causes an abort with the message "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Server library could not be loaded}".  On my local machine where I author my workspaces I can run the workspaces in FME Desktop using direct connect.  ArcGIS version 10.0 FME Server 2012 sp3  Any suggestions why FME Server direct connect won't work? 

1870
rylanatsafe
Safer
8 years ago
M
mark_f
asked in Data
Old questions bumping to top

Why are old questions getting bumped to top of the list? There doesn't seem to be any activity

80
M
8 years ago
L
louiseschatz95
asked in Data
Road features, GML to CityGML

Hi, I want to transform a 2D gml file to a 3D Citygml file. The data I have is a road feature and are polygons. I tried a lot, but till now didn't really find out how I can do that. Can anyone help me, the best would be a step by step explination. Thanks a lot!

140
B
8 years ago
peteralstorp
Contributor
peteralstorpContributor
asked in Data
SQL: aggregate table data in subgroups

Hi, fellow FMEers. I have a simple yet complex problem that I need to solve with SQL (SQLite) for my FME-script to run efficiantly. This may not be the correct forum, but since there are so many talented people here who enjoy helping out and solving complex problem I thought I'd give it a try here anyway. I have data I want to aggregate but in subgroups - taking z-level into account. It's a geological profile where I want to simplify the incoming data before I create my profile. Example datax, y, z_from, z_to, value1,2,1,2,A1,2,2,3,A1,2,3,4,B1,2,4,5,A1,2,5,6,A1,2,6,7,A1,2,7,8,Cwith SQL I want to aggregate on value but only rows that are adjacent (sort of a dissolve but on non-spatial data). And I want to calculate (also in sql) the correct z_from- and z_to-values. So the result from the example data above should be:x, y, z_from, z_to, value1,2,1,3,A 1,2,3,4,B1,2,4,7,A1,2,7,8,C Any help on this will be remembered for all eternity.Peter

5822
peteralstorp
Contributor
8 years ago
L
lucvdberghe
asked in Data
Exporting smallworld data to Esri Geodatabase (Personal Geodb)

Hello,I want to export Smallworld (4.3) objects to a Esri Geodatabase (Personal Geodb) with FME 2014. Creating the database with the objects seems to go without a lot of problems, but the objects don't have any geometries. During the initial setup and run of my workbench, the logfile showed that the attribute 'fme_db_operation' needed a value, so I added a 'INSERT'. This helped in creating the database, but the geometries weren't created.When using Smallworld 4.0, I didn't have those issues when exporting to the same format, so I don't really know how to get the correct result. Any ideas or suggestions?Thanks a lot!Luc

490
L
8 years ago
C
candimk
asked in Data
Read only the Default model in Microstation DGN

We have dgns that have multiple models (both design and sheet models). When I am writing these features to another file (fairly obscure Graphic Technologies, GTViewer files) it takes the elements from all of the models in the DGN. How can I set FME to only read the features from ONLY the "default" model?

1030
L
8 years ago
I
imran
asked in Data
Advanced browser in microsation reader

Hi,  I am using microsation(V7) reader to read various microstation DGN files in order to get them migrated in some other file formats, while selecting the source files the advaced browser is not allowing me to add folder name, I had to individually select the files, currently I am using FME 2015.1.0.1 the previous FME versions allowed the user to add the path of a root directory under folder so that one can mention the root directory followd by the filter extension and check the subfolder option so that all the files with specific extension which may reside in diffrent subfolders got selected, this kind of facility is not available in this version. Can anybody help me in getting a solution out of this.  Thanks in advance IMRAN

170
L
8 years ago
P
pimverver
asked in Data
XMLFlattener has no output

Dear all, I am at my wit's end here.In this article: https://knowledge.safe.com/articles/1207/reading-c...the XMLFlattener transformer is shown. I have made a workflow with the xml from the article as input file for an XMLFlattener to create feature paths at the node 'shipto'. The input file is valid XML. The output of the flattener however is only a _creation_instance attribute with a value of 0. As a test I fed the XML as an XML Reader. Instantly it translates the xml children in the correct feature attributes.What in the world is going wrong here?I have been searching for 3 hours or more, tried the XMLFragmenter but the results are the same. Thanks for any suggestion!The workflow and the xml source file is included herePim Verver

320
david_r
Evangelist
8 years ago
S
summercyn1110
asked in Data
3d distance between points and polygons

I have 2 input files. One is point cloud, and the other one is the CityGML. In the CityGML, I have the roof surface (polygons), and for point could, I have all the points just above the roof. I wanted to measure the (vertical) distance from roof to each point.I firstly used the SurfaceDraper to drape the points onto the roof, then measure the distance between the draped point and the original points. But it didn't work by SurfaceDraper. Then I wanted to create lines between every initial points and the points on the ground(I set the points' z value to 0). I wanted to use 3DLineOnDTMIntersector to the points on the roof surface with which I can measure the distance.However, I can't even connect the points in point cloud with the points on the ground to make these lines. I tried PointConnect but it can't make separated lines.. Is there any other transformers that can help?Thanks in advance.

190
takashi
Contributor
8 years ago
S
summercyn1110
asked in Data
SpatialFilter keeps rejecting filter polygons

Hi all!I've got a point cloud file of an area, and citygml file of this area as well. In the citygml file, I have the roof surface as polygons. Now I am connecting the points in the point cloud with the polygons of the roof surface. I tried several transformers, such as PointOnAreaOverlayer, Interjector, and now SpatialFilter. But as you can see in the below snapshot, the filters are rejected at the first place. I tried to add a BoundingBoxReplacer to my roof surface before the SpatialFilter. But still it didn't work.Thanks in advance.

180
S
8 years ago
G
gaelle
asked in Data
IFC Feature format attribute

As a newbie with FME I started with the tutorial BIM to GIS (basic).I used the tutorial field, added my reader and tried to match it in the workspace to the source IFC. However, my IFC (exported from Revit) has very few feature format attributes when the IFC tutorial source has a long list, and the attribute selected in the Tutorial source does not appear in my IFC source.Where does the feature format attribute come from? Is it from the revit IFC exporter, or does it depends from my revit model?Thanks

110
daveatsafe
Safer
8 years ago
gmbutler2
Contributor
gmbutler2Contributor
asked in Data
FME2014 or newer, does the dgnstyler recognize cell element priorities?

I am currently running Microstation V8i and all the cells I use have priority information. However, I am running FME 2013 and when I insert a cell, the priorities I have created for them are overwritten with 0 as their priority. Do the newer version of FME recognize the cell priority within a cell object or is there some other way, possibly an igds formatter that I can install that assigns a priority to objects when written into microstation?

90
M
8 years ago
N
nhaz
asked in Data
many xyz to gdb

I have many (about 20000)xyz files with Schema x (coord) y (coord) z (relative height) and no header. My output should be a gdb with geodb_points geometry.In my workbench I use csvReader so far. Then I use geometrieFilter Transformer. To read all the thounds of files I use a workspacerunner in an different workbench with the PATH reader. result is a gdb with 1000 feature classes. So now I have almost transformed 2/3 of my data (when I saw that huge disc space and stopped to improve workbench) but recognised that fme imported tables instead of feature classes (I guess in case of "wait for job to complete"=no at workspacerunner) .To save disc space I decided to delete attributes (only one left: height) and work with 2DForcer.My question ist now: how can I improve processing time? Using a different reader? Mark Ireland wrote there: http://gis.stackexchange.com/questions/54558/huge-... that xyzReader is much faster than csvReader. If I use xyzpointcloudReader I cannot use x y an

270
N
8 years ago
S
steveculshaw
asked in Data
Any solution for FME Workbench crashing?

I'm finding FME crashing every time I try to start it.Checked in the application event log and I can see an error reported ...Faulting application name: fmeworkbench.exe, version: 2016.7.19.16178, time stamp: 0x56ecc220Faulting module name: ig7icd64.dll, version: 10.18.10.4176, time stamp: 0x550c0501Exception code: 0xc0000005Fault offset: 0x000000000017325aFaulting process id: 0x1c84Faulting application start time: 0x01d1cba8da8e46f7Faulting application path: C:\Program Files\FME\fmeworkbench.exeFaulting module path: C:\Windows\system32\ig7icd64.dllReport Id: 2f81a12e-379c-11e6-b705-74e54352be0f

940
S
8 years ago
A
Anonymous
asked in Data
ElasticSearch

I see that ElasticSearch is now supported in FME 2016.1. Is it also supported in FME Server? If so, what version?

110
david_r
Evangelist
8 years ago
T
tomvdven
asked in Data
KML to CSV - no lat/lon

Hi, I want to convert KML containing placemarks to CSV, e.g.:<Placemark> <styleUrl>#msn_placemark_circle122</styleUrl> <ExtendedData> <SchemaData schemaUrl="#S_mdm_centroids_BB_SSDDSII"> <SimpleData name="MDM_ID">DE-BB-304102</SimpleData> <SimpleData name="MDM_NAME">Walsleben</SimpleData> <SimpleData name="MDM_lat">52.9507</SimpleData> <SimpleData name="MDM_long">12.66</SimpleData> <SimpleData name="MDM_Direction">SE</SimpleData> <SimpleData name="MDM_CAPACITY">11</SimpleData> <SimpleData name="Import_Type">1</SimpleData> </SchemaData> </ExtendedData> <Point> <coordinates>12.66021255820746,52.95028030420562,0</coordinates> </Point> </Placemark> The output contains all SimpleData but not the actual point coordinates. I have tried workbench and quick trans

100
pratap
Contributor
8 years ago
U
User16212721574218637446
asked in Data
Splitting up a GeoTiff to evaluate cells colors

I need to evaluate the color of each individual cell of a geotiff. I splitted the geotiff into it's cells using the RasterTiler with CellSize 1,1 and it seems to work. I do now just need to access the color of each cell and to test for it. I tried to do it using the Tester, but it seems that it doesn't work.

90
U
8 years ago
A
anjitha
asked in Data
How to calculate x,y coordinates from point feature class as same as ArcGIS calculate

I have a point POI (Points of Interest) feature class. I need to calculate X and Y coordinates (Lat\\Long ) in a FME workbench process. How do I do this with FME workbench ?    Can someone help me to model this or any other direct converter   (Feature class has [shape] field.)

7268
T
8 years ago
U
u1
asked in Data
Convert .las to .dwg or .dxf ?

Hello, i am recently started using this software and i want to convert to classes from my las file to dwg so i can use them in Skatch up? Is there a way or i am too newbee :D Thanks

13680
U
8 years ago
D
davidalvarez76
asked in Data
Write the result on the same folder as the input

Hello I have a work-space that is converting CVS files to SHP files. Right now the work-space creates all the SHP into a specific folder, but I need the SHP to be inside each of the folder that contains the CVS. Current SituationRootFolder 1 (CVS)Folder 2 (CVS)Folder 3 (CVS) ....SHP 1, SHP 2, SHP 3...GoalRoot Folder 1 (CVS), SHP 1Folder 2 (CVS), SHP 2Folder 3 (CVS), SHP 3...Best regards, David

260
jdh
Contributor
8 years ago
R
r_stirland
asked in Data
Transparency in 3D PDF

Is it possible to write transparent 3D objects to PDF?  I'm trying to create a transparent 3D water level on a 3D surface map, and am using the PDFStyler to give the water level a Fill Opacity of 0.4.  However, when it is written to the PDF, the water is a solid colour with no transparency at all. When I try to output the same thing to a 2D Geospatial PDF, the transparency works correctly.  Is this a limitation of FME's 3D PDF writer, or is there a way to do it?  Thanks

260
gio
Contributor
8 years ago
A
Anonymous
asked in Data
How to Delete from Geodatabase

I am using the Esri Geodatabase (ArcSDE Geodb) writer and unlike the Oracle writer, there is no Writer Mode dropdown so I can select DELETE. How do I delete records from a geodatabase?Thanks

1160
david_r
Evangelist
8 years ago
S
svn
asked in Data
how to move microstation cell to desired leve

how to move microstation cell to desired leve

140
M
8 years ago
philippeb
Enthusiast
philippebEnthusiast
asked in Data
Excel Text Alignment

Hello!Is it possible to set only once the vertical text alignment (and put the fields in bold at the same time) for all the fields in my writer for an Excel file?If I have 20 fields, I would like to be able to do it only one time. I don't want to use a template each time.Thanks!

60
philippeb
Enthusiast
8 years ago

Badge winners

Show all badges
30,469
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.