Electrical Design Software | Elecdes Design Suite by Scada Systems Ltd

How to Import a Database onto the Drawing

General

This function is provided for the purpose of importing any dbase 3, 3+ or 4 database file to a table on a drawing. You may specify the tabular format (text size, column spacing, borders required etc.) and which fields and records you wish to import.

Procedure

  1. Select Import Database from the Utilities and BOM menu.

  2. You will be displayed a dialog box asking whether you wish to display the imported table data in model space or paper space. Paper space will normally give the best results.

  3. Select Yes, for paper space, to display the imported table in the same units as your border sheet (i.e. 1 drawing unit = 1 border sheet unit) and for text to be placed in the plane of the border sheet.

  4. Select No, for model space, to display the imported table in the same units as your model. (i.e. 1 drawing unit = 1 x the base drawing units of FT or M, you may enter units such as IN, FT, MM or M to scale the table size). Table text will be placed in the plane of the current model space UCS.

  5. A list of database files in the current directory will be displayed. Select a file. (You can change directory to import a file from any directory.)

  6. Select the fields (from the displayed list of all fields in the DBF) that you wish to import.

    The left list contains the selection list of all fields in the database file. Fields moved to the right list will be imported.

    Click in the left list to select a field and click in the right list to deselect a field.

    You may select all fields by clicking [>>]. You may deselect all fields by clicking [<<].

  7. Select the type of border you require to be constructed around the table.

  8. If using model space, enter the table text size and spacing in scaled units (e.g. 20cm, 5in). If using paper space, enter the sizes in drawing units - relative to your border sheet scale (e.g. for metric 5.0 and for imperial 0.25).

    Character spacing: This value is an estimate of the average character width. If you find that your data overruns the width of the columns increase this value. To minimise the space the imported data uses, horizontally, decrease this value.

    Text height: Enter the height of text you wish to use. If you modify this you may have to modify the previous spacing value.

    Line spacing: Enter the size of the gap to leave between lines of data. Any horizontal border lines constructed are placed in the centre of this gap.

    First record to import: This is the number of the first record, in the database file, to be imported.

    Last record to import: This is the number of the last record, in the database file, to be imported (inclusive). All records between the first and the last (inclusive) will be imported.

    TIP: For a user defined subset of a file to be imported (e.g. all DEVICE's from a bill of materials), use the Database Editor sorting functions to separate those records desired, from others, before importing.

  9. You will now be requested to select the insert point of the top left corner of the table. Paneldes will automatically place you in model space or paper space.

  10. The table will be drawn.