Difference between revisions of "WBW2 ZStoWGS Export"

From ZUGSEIL Wiki
Jump to navigation Jump to search
(Created page with "==Material_Level.csv== The fields for export were agreed on 5 June 2024 together with Peter Staufer (SBB). This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom". The export format must be a csv-file in UTF8, comma separated. {| class="wikitable" |+ !Excel view column !Column Name !Description how to pull data from ZUGSEIL |- |A |Warengruppennummer Level 1 und 2 |It is alwas the 9 digits long...")
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Material_Level.csv==
==WGS-Tool_WBW-Export.csv==
The fields for export were agreed on 5 June 2024 together with Peter Staufer (SBB).  
The fields for export were agreed on 16 June 2024 together with Peter Staufer (SBB).  


This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom".  
This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom".  
Line 9: Line 9:
!Excel view column
!Excel view column
!Column Name
!Column Name
!Example value
!Description how to pull data from ZUGSEIL
!Description how to pull data from ZUGSEIL
|-
|-
|A
|A
|Warengruppennummer Level 1 und 2
|Ebene 1 - de
|It is alwas the 9 digits long classification number but only the level 1 and 2
|Anlagen
|German name of the classification item 1st level from "SBB Warengruppen" schema
|-
|-
|B
|B
|Sprache
|Ebene 1 - fr
|Language code DE, EN, IT, FR
|Installations
|French name of the classification item 1st level from "SBB Warengruppen" schema
|-
|-
|C
|C
|Warengruppenbezeichnung
|Ebene 1 - it
|Name of the classification item in specific language
|Strutture
|}
|Italien name of the classification item 1st level from "SBB Warengruppen" schema
 
==Material_Group.csv==
The fields for export were agreed on 5 June 2024 together with Peter Staufer (SBB).
 
This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom".
 
The export format must be a csv-file in UTF8, comma separated.
 
{| class="wikitable"
!Excel view column
!Column Name
!Description how to pull data from ZUGSEIL
|-
|A
|Warengruppennummer Level 3
|It is alwas the 9 digits long classification number but only the level 3
|-
|B
|Sprache
|Language code DE, EN, IT, FR
|-
|C
|Warengruppenbezeichnung
|Name of the classification item in specific language
|}
 
==Material_Group_Attributes.csv==
The fields for export were agreed on 5 June 2024 together with Peter Staufer (SBB).
 
This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom".
 
The export format must be a csv-file in UTF8, comma separated.
 
{| class="wikitable"
!Excel view column
!Column Name
!Description how to pull data from ZUGSEIL
|-
|A
|Warengruppe
|It is alwas the 9 digits long classification number but only the level 3
|-
|B
|Lead Buyer
|The Lead buyer is of the classification item. This is the responsible buyer person and rule type default. Exported must be the staff number, like: UE51083[[File:DAS Lead Buyer.png|none|thumb]]
|-
|C
|Category Manager
|The strategical buyer is of the classification item. This is the responsible buyer person and rule type default.. Exported must be the staff number, like: UE51083[[File:DAS strategical buyer.png|none|thumb]]
|-
|-
|D
|D
|Risk Class
|Ebene 1 (#)
|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_K800.60".
|300000000
|Classification item number 1st level, full 9 digits long number
|-
|-
|E
|E
|Sustainable Class
|Ebene 2 - de
|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_NH".
|Energieanlagen
|German name of the classification item 2nd level from "SBB Warengruppen" schema
|-
|-
|F
|F
|Cybersecurity Class
|Ebene 2 - fr
|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_CS".
|Installations énergétiques
|French name of the classification item 2nd level from "SBB Warengruppen" schema
|-
|-
|G
|G
|Division_BP
|Ebene 2 - it
|Thi column holds the value from the classification mapping rule "WG SBB - EK-Bereiche". Output is always the target classification item element number like G or PP or EIB etc.
|Sistemi energetici
|Italien name of the classification item 2nd level from "SBB Warengruppen" schema
|-
|-
|H
|H
|Team_OPE
|Ebene 2 (#)
|The operative buyer is of the classification item. This is the value from field area description. But only in case the rule type is "procurement path rule" and the procurement path with identifier "TL_OPE"[[File:DAS operative buyer devision description.png|none|thumb]]
|301300000
|Classification item number 2nd level, full 9 digits long number
|-
|-
|I
|I
|Teamlead_OPE
|Ebene 2 Verantwortlicher
|The operative buyer is of the classification item. This is the name (first and last) from the responsible person. But only in case the rule type is "procurement path rule" and the procurement path with identifier "TL_OPE"[[File:DAS Teamlead OPE.png|none|thumb]]
|U222029
|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". Search the employee always on level 3. It is then the '''responsible''' buyer person. Exported must be the staff number, like: UE51083
'''Important''': It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.[[File:Cat2mgtres.png|none|thumb]]
|-
|-
|J
|J
|MAIN_OPE
|Ebene 2 Stellvertreter
|The operative buyer is of the classification item. This is the name (first and last) from the responsible person. But only in case the rule type is "default".[[File:DAS MAIN OPE.png|none|thumb]]
|U231901
|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". Search the employee always on level 3. It is then the '''deputy''' buyer person. Exported must be the staff number, like: UE51083
'''Important''': It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.[[File:Cat2mgtdep.png|none|thumb]]
|-
|-
|K
|K
|EKG_R3
|Ebene 3 - de
|This is the operative buyer R3 group is of the classification item. Output must be the goup number but only in case the rule type is "procurement path rule" and the procurement path with identifier "EKG_R3"[[File:DAS EKG R3.png|none|thumb]]
|Freileitungstechnik (Instandhaltung)
|German name of the classification item 3rd level from "SBB Warengruppen" schema
|-
|-
|L
|L
|EKG_S4
|Ebene 3 - fr
|This is the operative buyer S4 group is of the classification item. Output must be the goup number but only in case the rule type is "procurement path rule" and the procurement path with identifier "EKG_S4"[[File:DAS EKG S4.png|none|thumb]]
|Technique des lignes aériennes (maintenance)
|French name of the classification item 3rd level from "SBB Warengruppen" schema
|-
|-
|M
|M
|Ist veraltet
|Ebene 3 - it
|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png|none|thumb]]
|Tecnologia delle linee aeree (manutenzione)
|Italien name of the classification item 3rd level from "SBB Warengruppen" schema
|-
|N
|Ebene 3 (#)
|301305000
|Classification item number 3rd level, full 9 digits long number
|-
|O
|Ebene 3 Verantwortlicher
|U231901
|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". Search the employee always on level 3. It is then the '''responsible''' buyer person. Exported must be the staff number, like: UE51083
'''Important''': It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.[[File:Cat2mgtres.png|none|thumb]]
|-
|P
|Ebene 3 Stellvertreter
|U222029
|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". Search the employee always on level 3. It is then the '''deputy''' buyer person. Exported must be the staff number, like: UE51083
'''Important''': It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.[[File:Cat2mgtdep.png|none|thumb]]
 
|-
|Q
|Bereich
|EIT
|This column holds the value from the classification mapping rule "WG SBB - EK-Bereiche". Output is always the target classification item element number like G or PP or EIB etc. from classification item 3rd level. If no assignment exist this field stays empty.
|-
|R
|Risikoklassifizierung Produktsicherheit
|Hoch
|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_K800.60" from classification item 3rd level. If no assignment exist this field stays empty.
|-
|S
|Risikoklassifizierung Nachhaltigkeit
|Mittel
|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_NH" from classification item 3rd level. If no assignment exist this field stays empty.
|-
|T
|Risikoklassifizierung Cyber Security
|Gering
|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_CS" from classification item 3rd level. If no assignment exist this field stays empty.
|}
|}
== WGS Export ==
The WGS export can be exported over the [[App:SBB-WBW-Import-Export|SBB-WBW-Import-Export]] / SBB WG WGS Export


==Related Articles==
==Related Articles==
[[SBB:WBW Parallelinstanz & Customizing]]
[[SBB:WBW Parallelinstanz & Customizing|WBW Parallelinstanz & Customizing]]
 
[[App:SBB-WBW-Import-Export|SBB-WBW-Import-Export]]

Latest revision as of 10:19, 18 July 2024

WGS-Tool_WBW-Export.csv

The fields for export were agreed on 16 June 2024 together with Peter Staufer (SBB).

This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom".

The export format must be a csv-file in UTF8, comma separated.

Excel view column Column Name Example value Description how to pull data from ZUGSEIL
A Ebene 1 - de Anlagen German name of the classification item 1st level from "SBB Warengruppen" schema
B Ebene 1 - fr Installations French name of the classification item 1st level from "SBB Warengruppen" schema
C Ebene 1 - it Strutture Italien name of the classification item 1st level from "SBB Warengruppen" schema
D Ebene 1 (#) 300000000 Classification item number 1st level, full 9 digits long number
E Ebene 2 - de Energieanlagen German name of the classification item 2nd level from "SBB Warengruppen" schema
F Ebene 2 - fr Installations énergétiques French name of the classification item 2nd level from "SBB Warengruppen" schema
G Ebene 2 - it Sistemi energetici Italien name of the classification item 2nd level from "SBB Warengruppen" schema
H Ebene 2 (#) 301300000 Classification item number 2nd level, full 9 digits long number
I Ebene 2 Verantwortlicher U222029 Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". Search the employee always on level 3. It is then the responsible buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.
Cat2mgtres.png
J Ebene 2 Stellvertreter U231901 Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". Search the employee always on level 3. It is then the deputy buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.
Cat2mgtdep.png
K Ebene 3 - de Freileitungstechnik (Instandhaltung) German name of the classification item 3rd level from "SBB Warengruppen" schema
L Ebene 3 - fr Technique des lignes aériennes (maintenance) French name of the classification item 3rd level from "SBB Warengruppen" schema
M Ebene 3 - it Tecnologia delle linee aeree (manutenzione) Italien name of the classification item 3rd level from "SBB Warengruppen" schema
N Ebene 3 (#) 301305000 Classification item number 3rd level, full 9 digits long number
O Ebene 3 Verantwortlicher U231901 Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". Search the employee always on level 3. It is then the responsible buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.
Cat2mgtres.png
P Ebene 3 Stellvertreter U222029 Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". Search the employee always on level 3. It is then the deputy buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken.
Cat2mgtdep.png
Q Bereich EIT This column holds the value from the classification mapping rule "WG SBB - EK-Bereiche". Output is always the target classification item element number like G or PP or EIB etc. from classification item 3rd level. If no assignment exist this field stays empty.
R Risikoklassifizierung Produktsicherheit Hoch This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_K800.60" from classification item 3rd level. If no assignment exist this field stays empty.
S Risikoklassifizierung Nachhaltigkeit Mittel This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_NH" from classification item 3rd level. If no assignment exist this field stays empty.
T Risikoklassifizierung Cyber Security Gering This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_CS" from classification item 3rd level. If no assignment exist this field stays empty.

WGS Export

The WGS export can be exported over the SBB-WBW-Import-Export / SBB WG WGS Export

Related Articles

WBW Parallelinstanz & Customizing

SBB-WBW-Import-Export

Retrieved from "https://wiki.zugseil.com/en/index.php?title=WBW2_ZStoWGS_Export&oldid=27124"