Text Rollover - GLUTRITX
The GLUTRITX utility inserts data into the following tables based on the data indicators in the supplied file:
- tx_thread_mstr, tx_note_mstr, tx_note_dtl — Threaded Notes (SYUTTXUP) page
- txt_text_dtl — Text tabs on GLUPGN/GLUPKY/GLUPOB/GLUPKP/GLUPOG pages
File Format
Data Lines
Data lines are comma-separated data columns/values in the input file. Any data lines that begin with "--" or a blank line, or any data with a single character, will be ignored.
A data line must begin with one of these values:
| Data Column #1 | Description | Table Insert |
|---|---|---|
| AT | Associated text | txt_text_dtl |
| AC | Associated text continuation lines (linked with AT) | txt_text_dtl |
| TS | Thread subject | tx_thread_mstr |
| NS | Note subject (linked with TS) | tx_note_mstr |
| TX | Thread text (linked with NS) | tx_note_dtl |
Essentially, data lines starting with AT can be supplemented (continued) with AC data lines, while TS data lines can be supplemented with NS and TX data lines.
Input File Columns
AT & TS data line columns 1-9 of the data input file are formatted as follows.
Notes:
- Text Type (used in AT data lines) must exist in common code GLTT/XXXXXXXX.
- CD1-4 (used in TS data lines) refer to Thread Code 1-4 (tx_thread_mstr.thread_cd1-4) of SYUTTXUP.
| 1 | 2 | 3 | 4 | 5 | 5 | 6 | 7 | 8 | 9 | Table Name | Page |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AT | GN | Ledger | [ Text Type ] | [ Text ] | n/a | n/a | n/a | n/a | n/a | GLG_GEN_MSTR | GLUPGN |
| AT | KY | Ledger | Key | [ Text Type ] | [ Text ] | n/a | n/a | n/a | n/a | GLK_KEY_MSTR | GLUPKY |
| AT | KP | Ledger | Org Part | Org Part Code | [ Text Type ] | [ Text ] | n/a | n/a | n/a | GLK_GRP_MSTR | GLUPKP |
| AT | OB | Ledger | Object | [ Text Type ] | [ Text ] | n/a | n/a | n/a | n/a | GLO_OBJ_MSTR | GLUPOB |
| AT | OG | Ledger | Obj Grp | Obj Grp Cd (glo_grp) | [ Text Type ] | [ Text ] | n/a | n/a | n/a | GLO_GRP_MSTR | GLUPOG |
| TS | GN | Ledger | CD1 | CD2 | CD3 | CD4 | [ Thread Subject ] | n/a | n/a | GLG_GEN_MSTR | GLUPGN |
| TS | KY | Ledger | Key | CD1 | CD2 | CD3 | CD4 | [ Thread Subject ] | n/a | GLK_KEY_MSTR | GLUPKY |
| TS | KP | Ledger | Org Part (glk_grp_id) | Org Part Code (glk_grp) | CD1 | CD2 | CD3 | CD4 | [ Thread Subject ] | GLK_GRP_MSTR | GLUPKP |
| TS | OB | Ledger | Object (glo_obj) | CD1 | CD2 | CD3 | CD4 | [ Thread Subject ] | n/a | GLO_OBJ_MSTR | GLUPOB |
| TS | OG | Ledger | Obj Grp (glo_grp_id) | Obj Grp Cd (glo_grp) | CD1 | CD2 | CD3 | CD4 | [ Thread Subject ] | GLO_GRP_MSTR | GLUPOG |
Test Mode
Set TestMode to false to insert the data in the tables. A value of true will evaluate the data but will not insert it.
Examples
1. The data lines below will add "Comment" into txt_text_dtl for GLGGenMaster and will use ledger "GL" to get the data link:
AT,GN,GL,Comment,This is some test content
AC,This is the second line of the content for above
AC,This is the third line of the content for above
2. The data line below will add "Comment" into txt_text_dtl for GLOGrpMaster. Column #6 must be eight characters or less and is only for AT/AC. Column #4 is glo_grp_mstr.glo_grp_id. Column #5 is glo_grp_mstr.glo_grp which is needed to establish the link.
AT,OG,GL,AFS,105,Reason,This is some test content for a reason or comment
AC,This is one more line for the same record
3. Add the data to tx_thread_mstr for glk_key_mstr. Column #4 is glk_key_mstr.glk_key. Thread Code 1-4 are a maximum of eight characters. NS data will be linked to TS record and TX data will be linked to NS.
TS,KY,GL,530000,TCode1,TCode2,TCode3,TCode4, Some note for glk key mstr with key 530000
NS,This comment is linked with TS record above
TX,This comment is linked with NS record above