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 (glk_key)	[ Text Type ]	[ Text ]	n/a	n/a	n/a	n/a	GLK_KEY_MSTR	GLUPKY
AT	KP	Ledger	Org Part (glk_grp_id)	Org Part Code (glk_grp)	[ Text Type ]	[ Text ]	n/a	n/a	n/a	GLK_GRP_MSTR	GLUPKP
AT	OB	Ledger	Object (glo_obj)	[ Text Type ]	[ Text ]	n/a	n/a	n/a	n/a	GLO_OBJ_MSTR	GLUPOB
AT	OG	Ledger	Obj Grp (glo_grp_id)	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 (glk_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