This section describes the interface between Super Natural and Con-nect.
This section covers the following topics:
You can write report data to Con-nect documents using the transaction modes for reporting Report Type CON-NECT and Destination CON-NECT.
To use the Super Natural Con-nect interface, you must have a cabinet in Con-nect with the same name as your user ID in Super Natural
Report Type CON-NECT is intended for the creation of form letters. When you create a transaction with Report Type CON-NECT, text variables in a selected Con-nect document are replaced with values from the resulting report. A separate Con-nect document is written for each record found by Super Natural.
You can use Report Type CON-NECT with all Report Destinations except WORK FILE, PC FILE and USER FILE.
To create a form letter
Add a reporting transaction with Report Type CON-NECT.
When you leave the Add Transaction window, the CON-NECT Documents window appears which lists all the Con-nect documents available which contain text variables.
Select a Con-nect document. You cannot use a document which contains Con-form system variables.
The following version of the Worksheet appears:
16:11 ***** Super Natural ***** 07.Jan.1998
SN3011 - Worksheet - Thursday
Ref DB Field Name Text Variable S Def Info Del
BI ________________________________ _______________ ___ __ __ __
BJ ________________________________ _______________ ___ __ __ __
BK ________________________________ _______________ ___ __ __ __
BL ________________________________ _______________ ___ __ __ __
BM ________________________________ _______________ ___ __ __ __
BN ________________________________ _______________ ___ __ __ __
BO ________________________________ _______________ ___ __ __ __
BP ________________________________ _______________ ___ __ __ __
BQ ________________________________ _______________ ___ __ __ __
BR ________________________________ _______________ ___ __ __ __
BS ________________________________ _______________ ___ __ __ __
BT ________________________________ _______________ ___ __ __ __
BU ________________________________ _______________ ___ __ __ __
BV ________________________________ _______________ ___ __ __ __
Enter "*" in Fieldname column to select fields or enter NEXT
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
|
The Text Variable and Sort (S) columns are specific to Report Type CON-NECT.
Enter in the Field Name column the names of the fields whose contents you want to write to a Con-nect text variable.
You can also enter an asterisk (*) to get
a selection list of the fields available.
If you want the contents of a field to be written to a Con-nect text variable, enter the name of the text variable you want the contents of a field to be written to next to the field in the Text Variable column.
You can also enter an asterisk (*) to get
a selection list of the Con-nect text variables
available in the document you have chosen.
If the document you have selected contains a text variable which you do not want to link to a field in Super Natural, the text variable field in Con-nect is left blank when you run the transaction.
Use the Sort (S) column to define sort fields as described in the section Sort/Control Column in the section Working with the Worksheet. You cannot define control breaks.
The other columns function as described in the section Working with the Worksheet.
Specify your selection criteria.
You can also specify logical conditions, calculation or file linking if you wish.
Issue the RUN command.
A formatted Con-nect document is created for each record found by the Super Natural transaction. The Con-nect text variables are replaced by the values of the fields you linked them to on the Worksheet.
An example of a Con-nect document created for a record found by a transaction using Report Type Con-nect in conjunction with Destination SCREEN is shown below:
16:15:36 NAME = 'A' THRU 'AC' 1998-01-07
ICON 1
Dear MS Adelman,
This letter was created using a Con-nect document which contains variables.
These variables were replaced with actual values from our Demo Database with
the help of Super Natural.
Your personal data is stored under the personnel number: 104439.
In particular:
Name: Adelman
First name: Anna
Job: VICE PRESIDENT
Hobby: SHAKESPEARE
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--
Print Exit Flip + Cancel
|
 |
Warning: When you run a transaction of Report Type CON-NECT and Destination CON-NECT, a Con-nect document is created for EACH record found. You can issue the COUNT command to
check how many records will be found. |
When you add a transaction with Destination CON-NECT, the resulting report data is written as a document to Con-nect.
When you run the transaction, a screen indicating the number of records sent to Con-nect is displayed.
To invoke Con-nect
Documents sent to Con-nect from Super Natural are identified by a prefix automatically supplied by Super Natural, the transaction ID, date and time of transaction execution. The documents look the same as the Super Natural screen output.
If the transaction is of Report Type CON-NECT, the resulting documents are formatted and stored in the system folder Compose.
For all other types of reports available, the resulting document is stored in the system folder SuperNatural. This folder is called Connect as of Con-nect Version 2.4.
You can process these documents using Con-nect.
For further information, see the Con-nect User's Guide or contact your Con-nect administrator.
When you leave Con-nect, you return to your Super Natural session automatically.
The following is an example of a document sent to Con-nect using Destination CON-NECT and Report Type LIST:
13:18 * * * C O N - N E C T 2 * * * 15.Mar1998
Cabinet SNDEMO Display (ICONN 1998/03/15 13:10) Wednesday
Folder SuperNatural File Page 1 Line 1
----------------------------------------------------------------------------
LBLTEST NAME = A THRU AC 1
01.08.
LAST-NAME A FAM-STATUS
G
E
-------------------- -- ----------
Adelman 34 MARRIED
35 SINGLE
Adkinson 33 MARRIED
58
38 SINGLE
39 DIVORCED
Asmussen 37 MARRIED
41 SINGLE
Press ENTER for next page or type a command (FLIP for PF-keys)
Command / /
Column Copy Erase Export File Flip Format Info Modify
Output Page Position Print Quit Send Top Translat
|