M. To create a standard section database from spreadsheet data
To import section data from either a Microsoft Office Excel spreadsheet or CSV file, use the following procedure.
-
On the Home ribbon tab, select the Import
Spreadsheet tool from the Standard
Profile group.
The Standard Profile Database Wizard - Import Spreadsheet opens. -
Click Browse to locate the spreadsheet file or CSV file
to import.
Each sheet in the spreadsheet will correspond to a table. The first two rows of the sheet are the Field and Units, respectively. Starting with the third row, each row represents a separate profile to include in the table.
-
Type a Filename to use for the database file.
By default, the file name of the selected spreadsheet file will be used.
The file extension (.db3) will be added. The maximum length of the file name is 50 characters. The default value is ProfileDatabase.
-
Add additional database information:
Setting Description Title The title of the database to display in the tree view (in both the Standard Profile Databases dialog and the Section Database Manager application). Version Optional version information for the database. Description Optional description text for the database. Country/ Manufacturer Optional country or manufacturer name for the database. Profiles Required profile type of the database sections. Icon The icon to display in the tree view (in both the Standard Profile Databases dialog and the Section Database Manager application). Click Browse to locate a raster image file (type .bmp or .png) that is 16x16 pixels.
- Click Next. The Table Info page is displayed. A table is added for each sheet in the spreadsheet file, with the title of that sheet used as the default table Name.
- Select the appropriate Shape from the drop-down.
- Repeat step 7 for each table in the database.
- Click Finish.