Custom *.lst file that will give certain output - (concentration needed)

Can someone that is more versed in *.lst file editing (it can be either V8i or Connect edition at this point whatever works) take a look and maybe give some resolution to this ? Some stuff like in what paper number is located the part/group/asembly etc.. probably isn't possible i dont know please help.

Explanation of variables:

these are definition for drawing names 

Explanation are in the picture above  

The first 9 symbols are specified by XXXX firm and are the same for the entire project. (red and blue frame)

The next 3 digits are also specified by XXXX firm. However, these digits differ depending on the construction part.

For example, in the case of the example project, there is a number for the filter support, a number for the platform on the device, a number for the roof railing and another number for the pipe support.

The letter after the digits describes the type of part.

With this number, their ERP system can distinguish between the different types of parts and process them correctly.

A= assembly parts with profiles and/or plates

R= assembly parts for railings

G= gratings

E= profile single parts (cuttings) for assembly parts with „A“

F= plate single parts (cuttings) for assembly parts with „A“

M= profile single parts (cuttings) for assembly parts with „R“

N= plate single parts (cuttings) for assembly parts with „R“

J= purchased parts with blanks, like insulation plates

X= drawings without parts, like assembly drawings, multidrawings for gratings, sketches and so on.

The last 4 digits can be chosen by the program itself. These are a sequential number to distinguish the different parts. (i've found that i've only managed to do this with this variable while printing to *.PDF file System.Path.GetFileNameWithoutExtension (PrintDefinition.SourceFile) & System.String.Format ("{0:D3}", PrintDefinition.Sequence) )

Now the problematic part : 

For them 

There are 2 ways to send the parts list:

As an .xsr file or the "XXXfirm-Interface-Sample.xltm" file must already be filled in correctly. // file is uploaded at the end of the post

The ".xsr" example file can also be opened with the Windows Notepad.

The “.xsr” file can also be sent as .csv or .txt. =>> THESE I CAN EXPORT //file example is uploaded at the end of the post 

These are data records of the respective parts which are differentiated with a ";" as a separator. => THIS ONE I KNOW HOW TO DEFINE

Each component is one line. The separators must be strictly adhered to.

example:

• Zeichnungsnummer;;;Benennung;Kunde/Abmessung;;;Beschaffungsart;Benennung2;;Rohmaterialmenge;Gewicht;Konstrukteur; Oberfläche;; AV Gruppe;; Zeichnungsnummer;1;;Zuschnittswert;;;;;;zugehörige Baugruppe;;Stückzahl;;Lieferfähigkeit;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Bennenung Englisch;;;;;;;;;;;;;;;;;;;;Rohmaterial

explanation of the terms

• „Zeichnungsnummer“ =part number
• „Benennung“

• • for X0001 Teile = name of the module
  • for assembly and single parts

• • • A+R+G = name of the part with Material

• • • • HEA240...3425 - S235JR
      • Profile…length(mm) – Material

• • • E+F+M+N

• • • • BL15*150...340 - S355J2
      • BL(plate)thickness(mm)*with(mm)…length(mm) – Material

• „Beschaffungsart“   //this part is abit tricky and it has "if's" and "or's" variables which i dont know how

• • • X+A+R+G = FF
    • E+M = FTS
    • F+N = FTL
    • J = FTX

• „Benennung2“ = same like „Benennung“ // yes who knows why
• Rohmaterialmenge //also "IF's" and "OR's" 

• • • For profile = length in mm
    • For plates = Volume (mm³) // this one => strange (length*width*height ; again dont know how)

• „Oberfläche“ //paint area => this i saw in the variables and it is in the default footer of the default list file

• • • Area for painting (m²)

• „AV Gruppe“ //These again are the combinations of certain things populating certain drawings which i dont know if bentley can differentiate

• • • X=KM-NZ // FOR VIEWS
    • A+R = KM-NP // GROUPS AND/OR ASSEMBLEY'S 
    • G+J= KM-NK // GRATINGS AND INSULATION PLATES AND SUCH
    • E+F+M+N = KM-NE // PROFILE PLATES CUTTINGS 

• Zeichnungsnummer = drawing number // WHICH I DEFINED IN THE TAGS => CELL AS "NAME2"  = DRAWING NAME
• „Zuschnittwert“

• • • For plates = „17“ // REALLY DONT KNOW WHY'S THAT "17"
    • For other parts there is no input necessary // one would think isnt there enough information ???

• “zugehörige Baugruppe”

• • • For single parts the number of the assembly part
    • // PROBABLY THIS "PART" BELONGS" TO THIS "GROUP" OR "ASSEMBLY" WHICH AGAIN I DONT KNOW IF PROSTEEL CAN VIEW ASSEMBLEY'S AS AN VARIABLE OR THIS GROUP BELONGS TO THIS PAGE AS IN SC-237140|100|X|0001 (X FOR VIEW , A FOR GROUP "100" FOR ASSEMBLY POSITION) ; "0001" PAGE NUMBER WHICH AGAIN I DONT KNOW HOW CAN I MAKE IT IN THIS FORMAT

• • • For assembly parts the number of the whole construction (SC-237140100X0001)

• “Stückzahl”

• • • Amount of the part for the group // MEANS HOW MANY OF THE SINGLE PARTS IS THERE IN THAT PARTICULAR GROUP

• “Lieferfähigkeit”

• • • A+R+G = J // ASSEMBLY PARTS WITH PROFILES AND/OR PLATES + ASSEMBLY PARTS FOR RAILING + GRATINGS = PURCHASED PARTS WITH BLANKS, LIKE INSULATION PLATES 
    • For other parts there is no input necessary //WHAT OTHER PARTS?????

• “Benennung in Englisch”   //SEEING THEIR EXAMPLE THIS IS JUST AN EMPTY CELL IN EXCEL

• • • “Benennung” in English   

• Rohmaterial // MATERIAL OF STEEL (S235,275,355 etc...)

• • • E+F+M+N = material of the part
    • For other parts there is no input necessary

snapshot od CSV file snapshot 

Example of CSV - export file 

SC-229137_400_Stückliste_Vault_export.csv

file into which this needs to be imported (had to zip it since *.xltm arent allowed here)

Scheuch-Schnittstelle-Muster.7z

Can Prosteel do something like this, I am already contemplating that i'll need to physically input most of these  . Am not a begineer user so i have some expirience (5yrs) but once in a while something comes along that challenges your knowledge.

Kind regards