• No results found

Create Excel Spreadsheet Page

In document SP3DProgGuide (Page 114-120)

Step 4 - Specify Occurrence Properties Page, page 122 Step 5 - Identify the Outputs Page, page 124

Related Topics

Creating Part Occurrence Symbols with the Part Definition Wizard: An Overview, page 110

Workflow for Creating a VB Part Occurrence Symbol, page 112

Step 1 - Create VB Project Page

Sets options for the Visual Basic project. Some of the information on this page becomes VB comments in the main class module that the wizard generates. For example, the text in the Author box becomes a comment in the header that tells who ran the wizard.

You cannot advance to the next page of the wizard until you have completed the Project name, Class name, Intergraph library location, and Save project as boxes.

Project name - Allows you to specify the name of the Visual Basic project for the symbol.

Class name - Specifies the name of the Visual Basic class. As you type text in the Project name box, the Class name box fills with the same text, except it starts with C. The maximum length of the project name and class name together is 39 characters.

Project description - Provides a brief description of the project.

Author - Gives the name of the author. The default is the current user. The default name is your Windows login name.

Company - Gives the company of the author. The default is the company name entered during the software installation.

Intergraph library location - Provides the path to an Intergraph-supplied library.

This location is where the CoreTraderKeys.bas file is stored. More than likely, this location is [Product

Directory]\Programming\Programming\ExampleCode\Symbols\Modules.

Note

The wizard checks to see if the delivered module files already exist in the location specified. If files already exist in the location, the wizard does not copy over them, and the existing files are included in the resulting VB project. If the files do not exist in the location, the wizard copies the Intergraph .bas files from the wizard's Templates folder to the specified location, and the files are also included in the resulting VB project.

Custom library location - Provides the path to a custom library.

Save project as - Give the name of the project that you are creating.

Create bulkload spreadsheet - Specifies that the wizard creates an Excel workbook containing the entered data for the symbol. You can use this workbook to bulk load

Related Topics

Specify VB Project Information, page 117

Specify VB Project Information

1. In the Project name box, type a name for the symbol VB project. For example, type MyPump. As you type text in the Project name box, the Class name box fills with the same text, except it starts with C.

2. In the Project description box, type a brief explanation of the project, such as Test Symbol.

3. Type your name and company in the Author and Company boxes, respectively.

The default name is your Windows login name, and the default company is the text entered during installation of the software.

4. Click the ellipsis button beside the Intergraph library location box to select a location for the VB libraries.

Tip

The wizard checks to see if the delivered module files already exist in the location specified. If files already exist in the location, the wizard does not copy over them, and the existing files are included in the resulting VB project. If the files do not exist in the location, the wizard copies the Intergraph .bas files from the wizard's Templates folder to the specified location, and the files are also included in the resulting VB project.

5. Click the ellipsis button beside the Save project as box to specify the project name and location. The default name is the value in the Project name box with a .vbp extension.

6. If you want the wizard to create an Excel workbook with the symbol information, make sure the Create bulkload spreadsheet box is selected.

Notes

Some of the information on this page becomes VB comments in the main class module that the wizard generates. For example, the text in the Author box becomes a comment in the header that tells who ran the wizard.

The maximum length of the project name and class name together is 39 characters.

You cannot advance to the next page of the wizard until you have

completed the Project name, Class name, Intergraph library location, and Save project as boxes.

Related Topics

Step 1 - Create VB Project Page, page 115

Step 2 - Create Excel Spreadsheet Page

Creates an Excel workbook containing the part class for the symbol. After running the wizard, you must open the workbook, add individual parts, and bulk load the

workbook into the Catalog Database for the symbol information to take effect.

Creating the Excel workbook during the wizard is optional; however, it may save you some time because otherwise you must create the workbook or worksheets manually after running the wizard.

Catalog server - Specifies the name of the server that stores the Catalog Database.

This box is not available.

Catalog name - Sets the name of the Catalog Database. This box is not available.

Part class name - Type the name of the part class that you want to create. The name must not exceed 30 characters and must not include any spaces.

Copy from - Allows you to select an existing part class to use as a template for the new part class. This button displays the standard catalog browser window. The wizard completes all applicable boxes on the rest of the pages with the information from the template. This is not available.

Part class description - Type a brief description of the part class. This description will appear on the Index sheet of the resulting bulkload workbook if you specified to create one.

Classification - Allows you to select a part class type. Your selection determines the type of symbol, such as piping or equipment. This text will appear in the Definition section of the part class sheet in the resulting bulkload workbook.

Save in Excel file - Specifies the name of the Excel workbook. The default name is the project name with the .xls extension.

Related Topics

Specify Excel Workbook Information, page 119

Specify Excel Workbook Information

The Catalog server and Catalog name boxes are not available in this version.

1. In the Part class name box, type a name for the symbol part class. This name will be the sheet name in the Excel workbook that the wizard creates. The name must not exceed 30 characters and must not include any spaces. If you click Copy from, you can select an existing part class as a template, and all the applicable values from that part class appear on the following pages.

2. In the Part class description box, type a brief explanation of the part class. This description will appear on the Index sheet of the resulting bulkload workbook if you specified to create one.

3. In the Classification box, select a part class type. Your selection determines the type of symbol, such as piping or equipment. This text will appear in the

Definition section of the part class sheet in the resulting bulkload workbook.

4. In the Save in Excel file box, select a location for the bulkload workbook that contains the symbol data. The default name is the value entered in the Project name box on the previous page of the wizard plus an .xls extension.

Notes

You must complete both the Part class name and Classification boxes before you can advance to the next page of the wizard.

Related Topics

Step 2 - Create Excel Spreadsheet Page, page 118

In document SP3DProgGuide (Page 114-120)

Related documents