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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

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.

×
×
  • Create New...