ASCII Import options

Discussion of MicroSurvey CAD related issues and questions.

Moderators: Brian Sloman, Jason Poitras, James Johnston

Post Reply
Scott Partridge
Posts: 35
Joined: Sun Nov 10, 2002 11:44 am
Location: Calgary, Alberta
Contact:

ASCII Import options

Post by Scott Partridge » Thu Jun 30, 2005 3:15 pm

I keep meaning to suggest this idea for the MSCAD wishlist....

I'd like a tool that would let me define my own ASCII import formats for MSCAD. For example, given this data file:

MARCH 2005 ATS AND ATSCOR POINTS
FILE, SEC, QTR, CNR, 10TM_N, 10TM_E, SURVEYED-UNSURVEYED, TYPE
514056,7,NE,CS,5962170.367,-70426.554,,ATSCOR
514056,7,NE,E4,5962163.74,-69624.389,S,ATS
514056,7,NE,N4,5962973.05,-70411.963,S,ATS
514056,7,NE,NE,5962965.42,-69610.015,S,ATS

I'd like to be able to create a file definition that would allow me to state a starting point number for the first point record and parse the record as follows (assuming I select 1001 as my starting point number):

Pt#, North, East, Description

1001,5962170.367,-70426.554,NE CS 7-056-14-5
etc

This tool could also be configured to ignore a fixed number of records at the beginning and/or at the end of the file.

Ideally, the tool would read input files in their native format and import them into an MSCAD drawing as per my definition file.

Yes, I know that I could write lisp code to do this, or reformat the file in Excel.

I'm looking at potentially doing this with several hundred files. Other applications, like Trimble Geomatics Office, provide this functionality.

While I'm at it, to be able to create custom ASCII export files with user defined header and fotter records would be great too.

Glen Cameron
Posts: 1395
Joined: Fri Nov 08, 2002 12:18 pm
Location: Corbeil, Ontario, Canada
Contact:

ASCII wish list

Post by Glen Cameron » Mon Jul 04, 2005 4:51 am

We will add this to the list to be looked at!

Cheers,
Glen W. Cameron, C.E.T.
City of North Bay, Ontario

Post Reply