13.2.1. pyVig - Cable Matrix Database Prepration User Guidelines!

INFORMATION COLLECTION

• First step to generate the visio drawing/design is to collect informations in Excel

• Second is to make it ready in the format pyVig can read it.

There are two ways Excel databse can be prepared.

1. Manual: For details of Excel field requirements see : Excel database Preparation Guidelines Section.

2. Auto: with help of pyVig native modules which takes advantage of facts-finders clean files and draft it for you. Make adjustments to it as necessary

Contents:

• 13.2.1.1. Manual
  • 13.2.1.1.1. Devices Tab - Mandatory Columns
  • 13.2.1.1.2. Cablings Tab - Mandatory Columns
  • 13.2.1.1.3. Devices Tab - Optional Columns
  • 13.2.1.1.4. Cablings Tab - Optional Columns
  • 13.2.1.1.5. sample excel database
• 13.2.1.2. Auto-Generate
  • 13.2.1.2.1. Add Custom Functions
  • 13.2.1.2.2. Generate pyVig readable Excel file
  • 13.2.1.2.3. Line Color Code

---

Script will continue on next step to generate the visio file using the above cable matrix excel file.