نقل النقاط من الاوتوكاد الي الاكسل ثم عمل ملف SDR للتوقيع بجهاز التوتل ببرنام سوكيا لينك Sokkia Link

How to Convert AutoCAD Designs to SDR Files

Introduction to the Process

• The video introduces the process of converting designs created in AutoCAD or similar software into Excel files, and subsequently into SDR files for total stations. This is essential for engineers and technicians who need to implement designs in real-world settings.

Drawing Points in AutoCAD

• A simple AutoCAD file named "Point" is used, containing a 5m x 5m square where multiple points will be drawn for conversion into an SDR file. The initial point coordinates are set at (0,0).

• Various points are defined within the square:

• Top point at (0,5)

• Right point at (5,5)

• Bottom point at (5,0)

• Left point at (0,0)

• Center point at (2.5,2.5)

This results in five distinct points with specific X and Y coordinates.

Assigning Elevation Values

• Each drawn point is assigned an elevation value:

• Point one: Z = 30.52

• Point two: Z = 28.64

• Point three: Z = 56.24

• Point four: Z = 34.25

• Point five: Z = unspecified but noted as zero.

These values are crucial for accurate positioning when using total stations later on.

Extracting Data from AutoCAD

• To extract data from the drawing:

• Use the "Data Extraction" tool and select either all objects or specific points.

• If selecting specific points, only those chosen will be processed.

This allows users to focus on relevant data without unnecessary clutter from other elements in the drawing.

Exporting Data to Excel Format

• After extraction:

• Users can choose whether to link extracted data back to the original drawing or export it directly into an Excel file.

The latter option is selected here; thus creating a new Excel file that contains all relevant coordinate information formatted correctly for further use.

Finalizing and Saving Files

• Once exported:

• Users rename their points appropriately within Excel for clarity before saving them as tab-separated text files.

This step ensures that each coordinate's context remains clear when imported into other software like Sukiya Link later on.

Importing Data into Sukiya Link Software

• In Sukiya Link:

• Users must select the correct format corresponding with their previously saved tab-separated text files before importing data.

This ensures compatibility and accuracy during subsequent operations involving total station setups and measurements taken from these coordinates.

Conclusion of Data Processing Steps

• Upon successful importation of SDR files:

• The program displays all necessary details such as coordinates and elevations while allowing users to visualize how these relate spatially through drawings generated by their inputted data.

This finalizes the workflow from design creation through practical application using total stations effectively based on user-defined parameters throughout each stage of processing steps outlined above.

Extracting Points from AutoCAD to Total Station

Overview of Data Extraction Process

• The discussion revolves around extracting coordinates (X, Y, Z) from AutoCAD into the Sokia Link program.

• The points are labeled in Excel with identifiers such as "4D," "2D," "5D," and "1D" for clarity, despite their non-sequential arrangement.

• This method allows for a structured design output from AutoCAD, facilitating the creation of an SDR file.

• The SDR file is then uploaded to the total station for accurate site marking and surveying.

• Emphasis is placed on ensuring that point identification aligns with visual representations in AutoCAD drawings.