11.1. pyVig - Cable Matrix Database Prepration User Guidelines!

INFORMATION COLLECTION

• First step to generate the visio drawing is to collect informations in an Excel database and make it ready in the format pyVig can read it.

• There are two ways Excel databse can be prepared.

  1. Prepare it manually: For details of Excel database requirements see : Excel database Preparation Guidelines Section.

  2. Prepare it Automatically: 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:

• 11.1.1. Manual
  • 11.1.1.1. Devices Tab - Mandatory Columns
  • 11.1.1.2. Cablings Tab - Mandatory Columns
  • 11.1.1.3. Devices Tab - Optional Columns
  • 11.1.1.4. Cablings Tab - Optional Columns
  • 11.1.1.5. sample excel database
• 11.1.2. Auto-Generate
  • 11.1.2.1. Add Custom Functions
  • 11.1.2.2. Generate pyVig readable Excel file

---

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