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 join the content of a Notes view and the content of a grid (e.g., user ID), the ImportViewGrid appends the content of the desired columns in the Notes view to the grid.

This will only be applied to the currently selected rows in 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.
Family	Name of family Multivalue for the imported columns If the family exists in the grid, the imported columns are integrated according to the current status of the rows: values for exploded rows are set as part of the corresponding multivalue set, unexploded rows are set as mulitvalues. It is highly recommended to use unexploded imports (set with the Separator parameter) to unexploded grids, and exploded imports (no separator set) with exploded grids. Missing values (no match between list key and grid key) are set as No Value. If the family does not exist, it is created. Not Required

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>