Skip to main content
Skip table of contents

ImportViewInGrid: insert data from a Notes view into any grid

Tag: ImportViewInGrid

ImportViewInGrid allows you to insert the content of any Notes database view or folder into any grid that contains a corresponding set of data.

Detailed Description

When supplied with a pair of keys that joins the content of a Notes view and the content of a grid (eg. user id), ImportViewGrid appends the content of the wanted columns in the Notes view to the grid.

Tag Attributes

Attributes

Value Description

Server

Server name/org Required

Database

Database path - Required

Name

View name - Required

ImportKey

key column name in the Notes view - Required

GridKeyUID

key column unique ID in the grid - Required

Target

The corresponding Grid Code.

Sets the target grid panel - Not Required.

If no target is set, the default main grid target will be used.

SetParam attributes

Attribute

Value Description

Value

Column name in source Notes view

ColumnID

UID of the grid column to be created

NB: “_IMPORTED_" will be added as a prefix to the provided ColumnID.

ColumnTitle

Title of the grid column to be created

NB: if not supplied, the column title of the Notes view is used

Example Script

XML
<ytriaAutomation>

    <focus target="tree" category="Documents"/>
    <Values KeepAlive="This">
        <SetParam Field="ALl" value="True"/>
        <ShowTypeColumns value="false"/>

        <Select lines="all"/>
        <ImportViewInGrid target="GridValues" server='TheServer/TheOrg' database='names.nsf' Name='($Users)' ImportKey='$38' GridKeyUID='GridColID'>
            <SetParam Value='ShortName' ColumnID='ShortName' ColumnTitle='IMPORTED SHORTNAME'/>
            <SetParam Value='InternetAddress' ColumnID='Email' ColumnTitle='IMPORTED EMAIL'/>
        </ImportViewInGrid>
        <UnSelect lines="all"/>
    </Values>

</ytriaAutomation>

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.