Single line files conversion

Hi everyone,

I found a very useful tool on Sage x3 v11 for converting import files with linear structures to sage x3 acceptable templates. As we know, Sage x3 templates for imports and exports have more than a single line, that is, the header, the detail, and optionally for some imports like Miscellaneous issue and receipt, the stock journal line.

I have tested this tool and found it effective but it does not convert a file with a header and multiple detail lines properly. It only recognizes the first entry on a detail line.

The tool is found in "Usage >> Imports/Exports >> Single line files conversion"

For example, a miscellaneous issue template has 3 indicators that are, E for the header, L for the line details, and S for the Stock journal.

A. The file to be converted below: The first 2 lines are constant

H E           L             S                 END
C   Entry Storage site Allocation date Description Movement code   Entry line no. Product Description 1 Unit Quantity Warehouse   Unit Quantity Lot Sublot Location Status Serial number Analytical dimension Analytical dimension
E CLST 18092021 New PC L 1000 HARDWARE New PC UN 25 CLWH S UN -25 HDW0002 SUB0002 CLSW1 A ADMIN ADMIN

B. The converted file from Sage x3 using the single lines file conversion which can be imported into Sage x3 using the Imports function.

E 20 CLST 18092021 Hardware Issue1
L 1000 HARDWARE Computer Hardware UN 25 UN 25
S UN -25 CLSW1 A

C. Below is a multiple lines file which when converted, gives the same output as (B) above

H E L S END
C Entry Storage site Allocation date Description Movement code Entry line no. Product Description 1 Unit Quantity Warehouse Unit Quantity Lot Sublot Location Status Serial number Analytical dimension Analytical dimension
E CLST 18092021 New PC L 1000 HARDWARE New PC UN 25 CLWH S UN -25 HDW0002 SUB0002 CLSW1 A ADMIN ADMIN
L 2000 HARDWARE1 New PC UN 35 CLWH S UN -35 HDW0002 SUB0002 CLSW1 A ADMIN ADMIN
L 3000 HARDWARE2 New PC UN 45 CLWH S UN -45 HDW0002 SUB0002 CLSW1 A ADMIN ADMIN
L 4000 HARDWARE3 New PC UN 50 CLWH S UN -50 HDW0002 SUB0002 CLSW1 A ADMIN ADMIN

Does anyone know how I can get multiple lines converted using the same tool or how can I achieve the same result with multiple lines? Please help.