p 6 xer file parser builder

8/20/2019 p 6 Xer File Parser Builder

1/45

XER File:

C:\work\02-Personnal\01-Tutorial\02-Draft\01-Import-!"-to-P#-usin$ t%e Parser\TE"T1&'er

Ta(le:

CURRTYPEOBSPOBSPROJECTCALENDARPROJWBS


2/45

Row Count:

181

10111


3/45

)urr*i+ +e)imal*+i$it*)nt )urr*s,m(ol +e)imal*s,m(ol +i$it*$roup*s,m(ol

1 2 $ . ,13 2 £ . ,14 2 ¥ . ,15 2 € . ,16 2 ¥ . ,17 2 $ . ,

18 2 RUB . ,1 2 $ . ,20 2 $! . ,21 2 R$ , .22 2 $ . ,23 2 $ . ,24 2 $ . ,25 2 "# . ,26 2 S. . ,27 2 $ . ,28 2 B# . ,2 2 $U . ,


4/45

pos*)urr*fmt*t,pe ne$*)urr*fmt*t,pe )urr*t,pe )urr*s%ort*name

%1.1 &%1.1' US D)**+ USD%1.1 &%1.1' P)-/ S* "BP%1.1 &%1.1' J++# Y JPY%1.1 &%1.1' E-) EUR%1.1 &%1.1' C# Y-+ R! CNY%1.1 &%1.1' C++/+ D)**+ CAD

%1.1 &%1.1' R-##+ R-!* RUB%1.1 &%1.1' A P#) ARS%1.1 &%1.1' B)*+ B)*+) BOB%1.1 &%1.1' B+*+ R+* BRL%1.1 &%1.1' C*+ P#) CLP%1.1 &%1.1' C)*-!+ P#) COP%1.1 &%1.1' "-9+# D)**+ "YD%1.1 &%1.1' P++-+9+ "-++ PY"%1.1 &%1.1' P-+ N-) S)* PEN%1.1 &%1.1' S-+# D)**+ SRD%1.1 &%1.1' :-*+ B)*+ ;-) :E;%1.1 &%1.1' U--+9+ P#) UYU


5/45

$roup*+i$it*)nt (ase*e')%*rate

3 13 0.6186033 1.27083 0.687113 6.825023 1.03757

3 0.033483 3.7103 7.57083 1.76653 507.583 157.743 202.53 46403 2.72443 2.83 2.14463 21.247


6/45

o(s*i+ parent*o(s*i+ $ui+ se*num o(s*name

540 0 E#


7/45

o(s*+es)r


8/45

po(s*i+ po(s*parent*i+ se*num po(s*name po(s*+es)r

100 0 POBSR)) P) O++)R))101 100 0 P P) O++)102 100 100 P1 P) O++)103 100 200 P2 P) O++)104 100 300 P3 P) O++)105 100 400 P4 P) O++)

106 100 500 P5 P) O++)107 100 600 P6 P) O++)108 100 0 =


9/45

po(s*mana$er

=


10/45

pro.*i+ f,*start*mont%*num rsr)*self*a++*/a$ allow*)omplete*/a$

607 1 Y Y


11/45

rsr)*multi*assi$n*/a$ )%e)kout*/a$ pro.e)t*/a$ step*)omplete*/a$

Y N Y N


12/45

)ost*t,*re)al)*/a$ (at)%*sum*/a$ name*sep*)%ar +ef*)omplete*p)t*t,pe

N Y . CPD


13/45

pro.*s%ort*name a))t*i+ ori$*pro.*i+ sour)e*pro.*i+ (ase*t,pe*i+ )ln+r*i+

TEST 178


14/45

sum*(ase*pro.*i+ task*)o+e*(ase task*)o+e*step priorit,*num

1000 10 10


15/45

w(s*ma'*sum*leel str$,*priorit,*num last*)%e)ksum )riti)al*+rtn*%r*)nt

2 500 0


16/45

+ef*)ost*per*t, last*re)al)*+ate plan*start*+ate plan*en+*+ate s)+*en+*+ate

0.00 20111225 00M00 20111225 00M00


17/45

a++*+ate last*tasksum*+ate f)st*start*+ate +ef*+uration*t,pe

20111228 18M46 DT;/DUR2


18/45

task*)o+e*pre' $ui+ +ef*t,*t,pe a++*(,*name

A >)L:S6Q/S!R T)- +/


19/45

we(*lo)al*root*pat% pro.*url +ef*rate*t,pe a++*a)t*remain*/a$

COSTPERTY N


20/45

a)t*t%is*per*link*/a$ +ef*task*t,pe a)t*p)t*link*/a$ )riti)al*pat%*t,pe

Y TTT+# Y CTT);*)+


21/45

task*)o+e*pre'*/a$ +ef*rollup*+ates*/a$ use*pro.e)t*(aseline*/a$

Y Y Y


22/45

rem*tar$et*link*/a$ reset*planne+*/a$ allow*ne$*a)t*/a$ sum*assi$n*leel

Y N N SLT+##>


23/45

last*n*+ates*i+ last*(aseline*up+ate*+ate )r*e'ternal*ke, appl,*a)tuals*+ate


24/45

loa+e+*s)ope*leel e'port*/a$ new*n*+ates*i+ ne't*+ata*+ate

7 Y


25/45

)lose*perio+*/a$ sum*refres%*+ate trsr)sum*loa+e+

181230 00M00


26/45

)ln+r*i+ +efault*/a$ )ln+r*name pro.*i+ (ase*)ln+r*i+

178 Y C))+ S+/+/ ;-** T


27/45

last*)%n$*+ate )ln+r*t,pe +a,*%r*)nt week*%r*)nt mont%*%r*)nt ,ear*%r*)nt

20110617 00M00 CAB+# 8 40 172 2000


28/45

rsr)*priate

N


29/45

)ln+r*+ata

&0VVC+*/+D++&'& &0VVD+9#OW&'& &0VV1&'&'' &0VV2&'& &0VV0V08M00VV16M00'&'''' &0VV3&'&


30/45

&/V4017'&'' &0VV1&/V4032'&'' &0VV2&/V40364'&'' &0VV3&/V40427'&'' &0VV4&/V40507'&


31/45

'' &0VV5&/V40536'&'' &0VV6&/V40543'&'' &0VV7&/V4063'&'' &0VV8&/V40728'&'' &0VV&


32/45

V4071'&'' &0VV10&/V40871'&'' &0VV11&/V4003'&'' &0VV12&/V4010'&'' &0VV13&/V410


33/45

7'&'' &0VV14&/V4104'&'' &0VV15&/V41155'&'' &0VV16&/V41235'&'' &0VV17&/V41268'&''


34/45

&0VV18&/V41275'&'' &0VV1&/V41421'&'' &0VV20&/V4145'&'' &0VV21&/V4151'&'' &0VV


35/45

22&/V41606'&'' &0VV23&/V41633'&''''''


36/45

w(s*i+ pro.*i+ o(s*i+ se*num pro.*no+e*/a$ sum*+ata*/a$

40484 607 540 13580 Y N40584 607 540 1350 N N40585 607 540 1350 N N40586 607 540 1350 N N40587 607 540 1350 N N40588 607 540 1350 N N

4058 607 540 1350 N N4050 607 540 1350 N N4051 607 540 1350 N N4052 607 540 1350 N N4053 607 540 1350 N N4054 607 540 1350 N N4055 607 540 1350 N N4056 607 540 1350 N N4057 607 540 1350 N N4058 607 540 1350 N N405 607 540 1350 N N40600 607 540 1350 N N



40625 607 540 1350 N N40626 607 540 1350 N N40627 607 540 1350 N N40628 607 540 1350 N N4062 607 540 1350 N N40630 607 540 1350 N N40631 607 540 1350 N N40632 607 540 1350 N N40633 607 540 1350 N N40634 607 540 1350 N N


37/45

40635 607 540 1350 N N40636 607 540 1350 N N40637 607 540 1350 N N40638 607 540 1350 N N4063 607 540 1350 N N40640 607 540 1350 N N40641 607 540 1350 N N

40642 607 540 1350 N N40643 607 540 1350 N N40644 607 540 1350 N N40645 607 540 1350 N N40646 607 540 1350 N N40647 607 540 1350 N N40648 607 540 1350 N N


38/45

status*)o+e w(s*s%ort*name w(s*name p%ase*i+

WSO TEST S+* O*, "+# WBWSO A EWSO B P)>-WSO C C)#->)WSO 1 P)> EWSO 2 P)>## E

WSO 3 P EWSO 4 X>+>+* &R)+' EWSO 5 X>+>+* &S+>' EWSO 6 C* EWSO 7 S->- EWSO 8 E*>>+* EWSO #-+) EWSO 1 + E>+A ; C))*WSO 2 C)*-T)#WSO 3 D-#:##*WSO 4 T++#WSO 5 P-B*)C)##)

WSO 6 B-* X++*# &. ++*#, >WSO 7 P+>+#WSO 1 P C)#->)WSO 2 S-/)WSO 3 X+) C)#->)WSO 4 P>)##)WSO 1 S /*)R>*++)WSO 2 R)+/#,> +/ +WSO 3 W+ #-*9 +/ /++WSO 4 P* W)WSO 5 ;)-/+) W)WSO 6 ;+!>+) W)

WSO 1 ;-+> A+WSO 2 C)##) A+WSO 1 ;-+> A+WSO 2 C)##) A+WSO 1 ;-+> A+WSO 2 C)##) A+WSO 1 P +!>+)WSO 2 S* +!>+)&+>#,*+)#'WSO 1 P )WSO 2 EQ- W)WSO 3 E*>>+* W)WSO 4 #-+) W)

WSO 5 #-*+) W)WSO 6 ;)) >*-/ +>)9, !>WSO 7 P+WSO 1 P W)WSO 2 EQ- W)WSO 3 E*>>+* W)WSO 4 #-+) W)WSO 5 #-*+) W)WSO 6 P+ W)WSO 1 P #+**+) >*-/


39/45

WSO 2 S* #+**+) &P+>#,*+)#WSO 3 EQ- W)WSO 4 E*>>+* W)WSO 5 #-+) W)WSO 6 #-*+) W)WSO 7 ;)) >*-/ +>)9, !>WSO 8 P+

WSO 1 P #+**+) >*-/ WSO 2 S* #+**+) &P+>#,*+)#WSO 3 EQ- W)WSO 4 E*>>+* W)WSO 5 #-+) W)WSO 6 #-*+) W)WSO 7 P+


40/45

parent*w(s*i+ e*user*p)t e*et)*user*alue ori$*)ost

26463 6 0.88 0.0040484 6 0.88 0.0040484 6 0.88 0.0040484 6 0.88 0.0040584 6 0.88 0.0040584 6 0.88 0.00

40584 6 0.88 0.0040584 6 0.88 0.0040584 6 0.88 0.0040584 6 0.88 0.0040584 6 0.88 0.0040584 6 0.88 0.0040584 6 0.88 0.0040585 6 0.88 0.0040585 6 0.88 0.0040585 6 0.88 0.0040585 6 0.88 0.0040585 6 0.88 0.00

40585 6 0.88 0.0040585 6 0.88 0.0040586 6 0.88 0.0040586 6 0.88 0.0040586 6 0.88 0.0040586 6 0.88 0.0040603 6 0.88 0.0040603 6 0.88 0.0040603 6 0.88 0.0040603 6 0.88 0.0040603 6 0.88 0.0040603 6 0.88 0.00

40604 6 0.88 0.0040604 6 0.88 0.0040605 6 0.88 0.0040605 6 0.88 0.0040606 6 0.88 0.0040606 6 0.88 0.0040612 6 0.88 0.0040612 6 0.88 0.0040613 6 0.88 0.0040613 6 0.88 0.0040613 6 0.88 0.0040613 6 0.88 0.00

40613 6 0.88 0.0040613 6 0.88 0.0040613 6 0.88 0.0040614 6 0.88 0.0040614 6 0.88 0.0040614 6 0.88 0.0040614 6 0.88 0.0040614 6 0.88 0.0040614 6 0.88 0.0040615 6 0.88 0.00


41/45

40615 6 0.88 0.0040615 6 0.88 0.0040615 6 0.88 0.0040615 6 0.88 0.0040615 6 0.88 0.0040615 6 0.88 0.0040615 6 0.88 0.00

40616 6 0.88 0.0040616 6 0.88 0.0040616 6 0.88 0.0040616 6 0.88 0.0040616 6 0.88 0.0040616 6 0.88 0.0040616 6 0.88 0.00


42/45

in+ep*remain*total*)ost e*)ompute*t,pe e*et)*)ompute*t,pe

0.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;1

0.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;1



0.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;1


43/45

0.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;1

0.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;10.00 ECC> EEP;1


44/45

$ui+ tmpl*$ui+ plan*open*state

-JUUU8RJU7"


45/45

p 6 xer file parser builder

Documents