×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Import coordinates in SDMS format into Auto Cad

Import coordinates in SDMS format into Auto Cad

Import coordinates in SDMS format into Auto Cad

(OP)
I am attempting to write a VB app that will import survey design coordinates into acad. I have basicaly written the application I need to know how to convert from a comma or space delimeted format to an sdms ( each value occupies one line ) ex: pt no
           north (y)
           east (x)
           elev (z)
           descriptor

any help or reference would be great.

   Tim

RE: Import coordinates in SDMS format into Auto Cad

TIM216.

What do you want to do with the points?
A 3dpolyline?
What about PO NO and DESCRIPTOR?
Could you send a point-no.csv file and a sample of the drw you wnat to?
If so please do it to k281969@hotmail.com



 

Pardal

RE: Import coordinates in SDMS format into Auto Cad

(OP)
All I need to do is get them to come in as the current acad point style I can create a block to show the pt no and descriptor as an attribute. my current excel sheet save the data as a csv but my data collector exports as sdms to a text file so I have to export to a text file then enter the data into the appropriate cells then import that to acad so that I can connect the dots so to speak. If I can make acad read this format I save several steps.

                      Tim

RE: Import coordinates in SDMS format into Auto Cad

Please send me a sample of your txt file , does not matter what it is , I need to check it with the routine I{m developing.
k281969@hotmail.com

Pardal

RE: Import coordinates in SDMS format into Auto Cad

Hi Tim .

I'm waiting for your SMDS file sample, with out it I can not do nothing.

Pardal

RE: Import coordinates in SDMS format into Auto Cad

HI there
I have a lisp routine that makes something like this.
It reads text file with point name x y z coordinates and inserts blocks with atributes
It works with separators (, . / and "single space")
If it will help I will send it to you

Zmei

RE: Import coordinates in SDMS format into Auto Cad

Hi Zmei , could you send me your Lisp routine ?
I will send you what I did up today.

k281969@hotmail.com

Pardal

RE: Import coordinates in SDMS format into Auto Cad

HI Tim!
I have the routine that you need please sent here your email.
just sent them to Pardal!.
Zmei

RE: Import coordinates in SDMS format into Auto Cad

Tim,

I have a similar situation, I am looking to import a SDMS ali file into AutoCad.  Did you get a way of reading the multiline SDMS format in VB?  Any help would be appreciated.

Thanks.

Ben

RE: Import coordinates in SDMS format into Auto Cad

(OP)
HELLO ZMEI AND PARDAL
   I AM SORRY I HAVE TAKEN SO LONG AT GETTING BACK TO YOUR POST. TO BE HONEST I HAVENT REALY HAD ANY OPPORTUNITY TO CONTINUE MY PROGRAM IN VB. BUT I AM DEFINITLEY INTERESTED IN SEEING YOUR LISP ROUTINE.
   TO ANSWER YOUR QUESTION BEN NO. WHAT I ENDED UP DOING WAS CREATING A BLOCK CALLED SURVEY POINT THEN INSERTING IT AT THE X,Y,AND Z COORDS AT THE COMMAND LINE. VERY TEDIOUS BUT I AM NOT DEALING WITH MORE THAN 10 POINTS AT A TIME.

RE: Import coordinates in SDMS format into Auto Cad

HI Tim!

As i think my routine will need some minor changes for the type of work you need, Please can you give me a little more details.

How exactly looks your SDMS file (I dont know what means SDMS :( ).

The curent routine can read coma space or any other user defined separator ( unfortunately no TAB) from the file looking like this:

Name,Xcoord,Ycoord,ZCoord
Name,Xcoord,Ycoord,ZCoord

The other works with Excell2000
with cells in the same order.
Other versions of excell need to know what version you are using.

ZMEI

RE: Import coordinates in SDMS format into Auto Cad

(OP)
THE STANDARD SDMS FORMAT IS AS FOLLOWS
LINE 1 POINT NO.
LINE 2 X COORD
LINE 3 Y COORD
LINE 4 Z COORD
LINE 5 POINT DESCRIPTOR ( OPTIONAL )
EXAMPLE:
1
1500.00
2500.00
125.00

I GUESS THE PROBLEM I AM HAVING IS FIGURING OUT THE COMMAND TO MAKE ACAD TAKE EACH LINE AND MAKE A SINGLE LINE WITH ALL 5 VALUES BEFORE IT INSERTS THE POINT. IF I FIGURE THAT PART OUT THEN I CAN JUST LINK IT TO A LISP OR VBA ROUTINE THAT READS AN ASCII FILE AND INSERT MY SURVEY BLOCK.

RE: Import coordinates in SDMS format into Auto Cad

HI Tim1

Your routine is ready.
Just tell me where to send it.
Zmei

RE: Import coordinates in SDMS format into Auto Cad

(OP)
YOU CAN E-MAIL ME AT TIMOTHY_DAY@HOTMAIL.COM

RE: Import coordinates in SDMS format into Auto Cad

YOU HAVE MAIL
Zmei

RE: Import coordinates in SDMS format into Auto Cad

(OP)
zmei,
   I hate to say this but like a doofus I managed to delete all of my in box before I opened your file.Could you send it again.

   Thanks Tim

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources