Jump to content
Sign in to follow this  
Craig D.S.

best method of inserting Excel Data into a Site Model

Recommended Posts

Pasting the data into a text file, and Import Survey File does not seem to import all cell data.

So what are the best ways to import one's Excel spreadsheet data into a Site model

Share this post


Link to post

export the text file as a simple text document with the following format:

id Northing Easting Elevation Description

nothing else.

then use the import survey command.

Share this post


Link to post

Thanks for replying Jonathan.

I should have stated that the Excel file has only Z height values, and is not the regular survey data file.

that was why I was having trouble in this case.

I can open the tab delineated text file in AccuTrans 3D, save it as a DXF, import that into VW and build the site model around that data.

There does not seem to be an internal way to only insert Z height values...

Share this post


Link to post

As I'm not very familiar with survey files...How do I insert the extra fields for the" id Northing Easting Elevation Description

"?

is ID from 0 to n-1?

Can Northing and Easting be 0,1,2 etc

And I'm not uure of description

I guess I'd better study up on this.

Share this post


Link to post

let me first start by asking do you have a survey file from a surveyor? Or are you generating this from scratch.

Share this post


Link to post

I'm generating this myself, from spot elevations a metre apart, to make a 21x21 or 25x25 grid, which can then be visualized in 3D Surface Charts

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×