Friday 23 April 2021

Sample Template for eText BIP Report

 Sample Template for eText BIP Report 

You can see step by step video to develop eText BIP Report using this Link


Please find the attached templates:

1) eText Template -

You can see step by step video to develop eText BIP Report using this Link

<TEMPLATE TYPE>

DELIMITER_BASED

<OUTPUT CHARACTER SET>

iso-8859-1

<CASE CONVERSION>

UPPER

<NEW RECORD CHARACTER>

Carriage Return

 

<LEVEL>

DATA_DS

<MAXIMUMLENGTH>

<FORMAT>

<DATA>

<COMMENTS>

<NEW RECORD>

TableHeader

20

Alpha

'Person Id'

 

1

Alpha

'|'

 

20

Alpha

'Title'

 

1

Alpha

'|'

 

20

Alpha

'First Name'

 

1

Alpha

'|'

 

20

Alpha

'Last Name'

 

 

<LEVEL>

G_1

<MAXIMUMLENGTH>

<FORMAT>

<DATA>

<COMMENTS>

<NEW RECORD>

CLRDAta

20

Alpha

PERSON_ID

 

1

Alpha

'|'

 

20

Alpha

TITLE

 

1

Alpha

'|'

 

20

Alpha

FIRST_NAME

 

1

 

'|'

 

20

Alpha

LAST_NAME

 

<END LEVEL>

G_1

 

<END LEVEL>

DATA_DS

 

2) Fixed Position eText Template  - 

You can see step by step video to develop Fixed Position eText BIP Report using this Link

<TEMPLATE TYPE>

FIXED_POSITION_BASED

<OUTPUT CHARACTER SET>

iso-8859-1

<CASE CONVERSION>

UPPER

<NEW RECORD CHARACTER>

Carriage Return

 

<LEVEL>

DATA_DS

<POSITION>

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

<NEW RECORD>

TABLE_HEADER

1

15

Alpha

R, ' '

'Person Id'

 

16

3

Alpha

R, ' '

'|'

 

19

15

Alpha

R, ' '

'Title'

 

35

3

Alpha

R, ' '

'|'

 

39

50

Alpha

R, ' '

'First Name'

 

90

3

Alpha

R, ' '

'|'

 

94

20

Alpha

R, ' '

'Last Name'

 

<LEVEL>

G_1

<POSITION>

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

<NEW RECORD>

TABLE_HEADER

1

15

Alpha

R, ' '

PERSON_ID

 

16

3

Alpha

R, ' '

'|'

 

19

15

Alpha

R, ' '

TITLE

 

35

3

Alpha

R, ' '

'|'

 

39

50

Alpha

R, ' '

FIRST_NAME

 

90

3

Alpha

R, ' '

'|'

 

94

20

Alpha

R, ' '

LAST_NAME

 

<END LEVEL>

G_1

<END LEVEL>

DATA_DS

 

4 comments:

  1. Hi I am using exactly the same template as you have mentioned, the output is returning only 1 row of data. It is returning 1 Header and then 1 row of data ..
    Can you help what could be the issue.

    Also, I am using HCM Extract for xml creation and creating this integration

    ReplyDelete
    Replies
    1. It means issue is with loop if XML is generating more than one records.
      Please check the data group loops in your template.
      Try to import the xml in rtf template and view output in word only if output is as expected then upload rtf to fusion

      Delete
  2. Is it possible to have multiple data headers and data sections to use it for returning two sections on the output file?

    ReplyDelete
  3. Excellent example. I saw your YouTube video tutorial but my Report output is showing blank result

    ReplyDelete

Avoid/Ignore if we have empty tag in XML.

 Ignore the Empty Tag in XML or avoid blank rows in For loop BIP Report. If we have blank row of data in For Loop in BIP Reports like in bel...