Import coordinates in SDMS format into Auto Cad

[tim216]

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
east (x)
elev (z)
descriptor

any help or reference would be great.

Tim

 

[pardal]

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

 

[tim216]

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

 

[pardal]

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

 

[pardal]

Hi Tim .

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

 

[zliazmei]

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&quot
If it will help I will send it to you

Zmei

 

[pardal]

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

k281969@hotmail.com
Pardal

 

[zliazmei]

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

 

[bzinger]

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

 

[tim216]

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.

 

[zliazmei]

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

 

[tim216]

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.

 

[zliazmei]

HI Tim1

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

 

[tim216]

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

 

[zliazmei]

YOU HAVE MAIL
Zmei

 

[tim216]

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