Embedded Commands in User Defined Data

From Support

Contents 1 List of Embedded Commands 1.1 MAILTO 1.2 SUBJ/SUBJECT 1.3 MAILFROM 1.4 ATTACHNAME 1.5 EXT 1.6 IMGSERVER 2 COMBINATIONS

List of Embedded Commands

The following is a list of commands that can be embedded into the User Defined Data of a spool file and picked up by one or more RJS Products.

The User Defined Data field is 255-character length field that is a part of the attributes of each AS/400 Spool File. This field may overridden during spool file creation (changed after creation) by changing the USRDFNDTA parameter.

NOTE: These commands are CASE SENSITIVE. They must be entered in upper case. The values that follow do not need to be in any particular case.

MAILTO

RULES:

• Separate email addresses by using a semi-colon ( ; )
• Terminate the MAILTO: command by using the tilde ( ~ )

This command will allow you to embed up to 10 different email addresses into the User Defined Data fields of a report. Each email address must be separated (delimited) with a semicolon. Once the last email address is entered, the MAILTO command must be terminated with a tilde.

Example:

MAILTO:support@rjssoftware.com; sales@rjssoftware.com~

SUBJ/SUBJECT

RULES:

• Terminate the SUBJ: command by using the tilde ( ~ )

This command will allow you to override the default Subject Line that was setup in the WinSpool/400 Email Report Server settings. Once the Subject Line has been entered, the SUBJ command must be terminated with a tilde.

Note: WinSpool/400 Email Report Server uses SUBJ and Email Report Server/400 uses SUBJECT

Example:

SUBJ:These products are so great that we should purchase some more for other areas of production~

or

SUBJECT:These products are so great that we should purchase some more for other areas of production~

MAILFROM

RULES:

• Terminate the MAILFROM: command by using the tilde ( ~ )

This command will allow you to override the default From Address that was setup in the WinSpool/400 Email Report Server settings. Once the From Address has been entered, the MAILFROM command must be terminated with a tilde.

Example:

MAILFROM:support@rjssoftware.com~

ATTACHNAME

RULES:

• Terminate the ATTACHNAME: command by using the tilde ( ~ )
• Go under FILE > SETTINGS. Select the Work Files tab. Locate the "Spool File Temporary Work File" field and change the file name from "REPORT.TMP" to "@USERDEFINED.TMP"

This command will allow you to override the default Attachment Name that was setup in the WinSpool/400 Email Report Server settings. Once the Attachment Name has been entered, the ATTACHNAME command must be terminated with a tilde.

Example:

ATTACHNAME:Invoice~

EXT

RULES:

• Terminate the EXT: command by using the tilde ( ~ )

This command will allow you to override the default Attachment File Extension that was setup in the WinSpool/400 Email Report Server settings. Once the Attachment FILE Extension has been entered, the ATTACHNAME command must be terminated with a tilde.

IMGSERVER

As of Batch Report Server/400 V1.23 , index values can be set in the user defined data field of a report via the OVRPRTF command when a report is generated on the AS/400 or by using the RJS AS/400 Report Splitter product.

The index user defined data line format is:

IMGSERVER:Doc Title;Index1;Index2;Index3;Index4;Index5;Index6;Index7;Index8;Index9;Index 10;Doc Type;                                  

Listed below is a sample index line set in the user defined data field of a report via the OVRPRTF command. This sample simply sets the document title to Customer Invoice and also sets the invoice number to 123456 and name to Johnson Outboard. The WebDocs - iSeries Edition document type will be AR:

IMGSERVER:Customer Invoice;123456;Johnson Outboard; ; ; ; ; ; ; ; ;AR;                                  

Note: Parameters are always delimited by a semicolon (;). Always leave at least one blank space between each semicolon delimiter if a parameter will not be used.

COMBINATIONS

All of the commands above can be combined into the User Defined Data field. You will have the full 255-character field to work with. You may use any or all of the above commands in any order in the User Defined Data field. The tilde terminator must be included for each of the command or you will see the commands starting to run together.

If your embedded commands exceed the 255-character limit, they will be automatically trimmed down without warning. If you find this happening please contact Technical Support to discuss alternate options.

The only exception to this rule is when the spool file is being converted via WinSpool/400 Electronic Forms. In this case, the EXT: command will automatically be added to the User Defined Data Field which means that 8 or 9 characters will need to be added to the current value in the User Defined Data field. (NOTE: Anything that was previously in the User Defined Data field will be preserved when WinSpool/400 Electronic Forms makes this change)

Example using Email Report Server/400

EXT:PDF~MAILTO:support@rjssoftware.com~SUBJ:This is a test email~MAILFROM:support@rjssoftware.com~ATTACHNAME:TEST~