Import and Export Macro

Introduction of drawing table

Drawing table is an important feature in engineering drawings. It is one of the means of communicating required information between manufacturing partners or confined to a single manufacturing plant. There are different tables in engineering drawing for example BOM Table, Hole Dimension Table, Design table etc. . .

 

Many Manufacturing sectors have different norms of tables in their work-space and most users want some additional options in table than the conventional one. So it consumes so much time to generate drawing tables following those conventions. Since there is a human intervention in this monotonous work there are more chances of making miss-entries or missing some data in table. These kind of mistake can lead to a huge impact on the end product. So there is a need to automate the process of creating tables which should be enhanced one than manually created tables.

This business situation requires:

 

Automation:
Automating the process of generating and updating of tables and check whether entered data is valid to reduce time consumption.

 

 

Human Error:
To reduce Human Errors like missing data and miss-entries caused because of monotonous work.

 

 

Enhanced Table:
Make attribute links to each text range of the table so that whenever there is a modification in data table will update automatically.

 

 

Table Style:
Along with table operations some users follow font standards in Drawing sheet so it is also required to set font properties of each text range in drawing table as of excel file.

 

There were a range of challenges faced during the course of the project. Few of them are listed below:

  1. Implementing for macro to make it consume less time in Drawing table operation was challenging.
  2. Validation check for some data is not available directly in CAD API’s.
  3. To make generic macro which can reach basic needs for all table types and for all users.

After carefully consideration of requirements and analysis of the API provided by the CAD system, we have come up with two macros.
They are:

  1. IMPORT TABLE
  2. EXPORT TABLE

IMPORT TABLE:

Macro to generate table from Excel data.

Some of the features we included in import table command are:

  • Importing table data from Excel file and creating the table at mouse click.
  • Selecting type of table to be generated.(BOM Table, Hole Dimension Table, …)
  • Updating of table by adding, removing or changing position of Table columns.
  • Change position and Anchor point of Table.
  • Change the table header row position (at Top or at Bottom).
  • Validate the imported table data.

Screen Shot 2015-09-09 at 10.29.59 PM

EXPORT TABLE:

Macro to extract table data and store in excel file.

Some of the features we included in export table command are:

  • To select any table and copy the data to browse excel file.
  • Replace an existing file data with new table data.

Screen Shot 2015-09-09 at 10.29.59 PM

 

Some of the results that we achieved through these macros are:

Flexibility:

Flexibility for user to handle Drawing tables with ease.

 

 

Enhanced Table:

Attribute links to each text range in table gives updation of data according
to changes in sheet. Hence makes tables more enhanced.

 

Validation:

Validating of table data and reflecting wrong data to users.

 

 

Productivity:

Since macro can handle variety of tables. Hence increases productivity of users.

 

 

Request trial version

CADVision Engineers