Sunday 26 November 2017

How to import and export data from total station to USB (Pentax W-1502 N)

 Pentax W-1502 N 

  Points Export 






Exporting points from PENTAX-1502 N Total Station.

1 Start Total Station (by keeping Batteries to their slot, batteries slot on right side) and then click power button.

               PENTAX W-1502 N Display will show like this
               1 Field Genius                   2 Instrument setup
                3 About                             4 Exit
Select 1 Field Genius to start surveying mode and wait for some seconds to connect instrument.

2 Level Instruments

Make no change, but keep face right if you work in face right or left face otherwise click à Continues.

3 Project managers:-

 Here you select you’re job that want to export to USB select à Open
Open project files (here you will see your job name if you select right job) click à Continues or by mistake you select other job click “Go back”.

4 Connect your USB to Total station PENTAX W-1502 N to USB slot (USB slot is on right side with keypad on down side). When you connecting USB check your point in map view, that your job or open properly…!

 5 Now click on àPENTAX” button that make and place in left side down. After the click you will see like this on your Total Station display.

Import and Export
 ASCII co-ordinates    Export template
 ASCII co-ordinate     Field file export
DXF file Import        DXF file Export
SDR file Export       Shape file Import
LandXML Import      Shape file Export
Like this you will see a lot file format’s Import and Export.
You can Export as per your requirements.
For Example:-
You want to Export For “Auto CAD civil 3d” then you  need to Export ASCII Co-ordinate file, because Auto CAD civil 3D work with (TAXT, CSV, DXF etc file format) but mostly Export ASCII Co-ordinate file this file format is also called CSV file format.
Now Select à  ASCII Co-ordinate file format
You will see PENTAX W-1502 N display like this

Points list                  _____ALL_____

Precision                    ______3______

Field Delimiter              __COMMA____

Angular Format             _____DMS____

ü  Include Header

Output format             ___STANDER__
New format           edit format        Delete format

After this click à OK
Again Export ASCII co-ordinate file

Here you will see your
All folder and sub folder in Total station or USB file and folder too look for “HARDDISK” and select it.
PENTAX W-1502 N show you all the file inside the folder and file that inside the folder or USB connected ,
Save as file name
 Keep name for your Project file

 And now select à save file.
Now you will receive message like this…!
For example:-
122 Points exported.

You are done.


If you are going to import these points to “AUTO CAD Civil 3D” you must remove heading….!
    Removing heading form CSV file or test file.
Open your exported file with notepad or Excel, but notepad is better for this…!
When you open your exported file with notepad sample remove these
Points ID, Northing (local), Easting (local), Elevation (local), Description and all above point 1
And then Go to à file and click à Save file.
If you open your exported file with excel then you have to do long process but not too much.
With excel
Open with excel
Go to file select à open file à select you file
Now action window will be open
Select à next again à next and select comma and click àFinish
(If you got on step 3/3 general, text etc. then selectsà text and click à finish
Now delete all above your first co-ordinate “line and heading.
Leave only Five columns.
Now apply this formula to make is on one row with comma delimited
Select new cell front to your first point after column Five and
Gotoà Fx (faction) now select Category “text
And find “Concatenate” and then select click à Ok
 Now one first
row “ text1” select no’s 1,
Second row “text2” write comma “,
3rd row “text3” select northing
4rd row “text4” write comma “,
5rd row “text5” select Easting
6rd row  “text6” write comma “,
7rd row “text7” select Elevation
 8rd row  “text8” write comma “,
9rd row “Text9” select Description
Click now click à OK
Now select you are this column (column six) and right and Copy it.
Now go to desktop right click and to go à new and select “new text document
Open it and “Paste” coped text here.
Now to go file and save as it with new name.

And you are done.

  WATCH VIDEO TUTORIAL  



THANKS

Read more

All about Civil engineering site works.


No comments:

Post a Comment