From empty
To version 10.1
edited by Theib Sawaf
on 2018/10/17 15:26
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Pallet Status Import
Parent
... ... @@ -1,0 +1,1 @@
1 +IMPACT Applications.Sync.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.XWikiGuest
1 +XWiki.TheibSawaf
Default language
... ... @@ -1,0 +1,1 @@
1 +en
Content
... ... @@ -1,0 +1,53 @@
1 +(% id="HFormat" %)
2 +== Format ==
3 +
4 +The file format is text with a comma separated values with the extension *.tvn
5 +
6 +(% id="HContents" %)
7 +== Contents ==
8 +
9 +The contains element data: Factory, Project, Element Id, Element mark, Production Date,.. etc
10 +
11 +(% id="HConfiguration" %)
12 +== Configuration ==
13 +
14 + <!~-~- Pallet System file directories~-~->
15 + <add key="PalletStatusImportDirectory" value="C:\IMPACT\StruSoft\Pallet\In" />
16 + <add key="PalletErrorDirectory" value="C:\IMPACT\StruSoft\Pallet\Error" />
17 + <add key="PalletProcessedDirectory" value="C:\IMPACT\StruSoft\Pallet\Processed" />
18 +
19 +(% id="HDetails" %)
20 +== Details ==
21 +
22 +
23 +Example of a TVN file with 2 elements on the pallet (cast unit):
24 +
25 +ARBETSMOD;MAN (PALETT);BATCHFIL;;POST;;PALFIL;211530;OBJEKT;MALMÖVäGEN ET1 EMP S64050000;ORDER;P64029631;TLMFIL;631-0;STAPEL;0;MO;0;PRDFIL;PL-31022;PRODDATUM;2018-03-01;PRODTID;09:48:59;OMPRODUKTION;;ELEMENTID;166;STANDARD;1101;
26 +ARBETSMOD;MAN (PALETT);BATCHFIL;;POST;;PALFIL;211530;OBJEKT;MALMÖVäGEN ET1 EMP S64050000;ORDER;P64029631;TLMFIL;631-0;STAPEL;0;MO;0;PRDFIL;PL-31022;PRODDATUM;2018-03-01;PRODTID;09:48:59;OMPRODUKTION;;ELEMENTID;167;STANDARD;1101;
27 +
28 +Below it is show in table form with column numbering:
29 +
30 +|(% data-sheets-value="{~"1~":3,~"3~":1}" %)0|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":3,~"3~":2}" %)2|(% data-sheets-value="{~"1~":3,~"3~":3}" %)3|(% data-sheets-value="{~"1~":3,~"3~":4}" %)4|(% data-sheets-value="{~"1~":3,~"3~":5}" %)5|(% data-sheets-value="{~"1~":3,~"3~":6}" %)6|(% data-sheets-value="{~"1~":3,~"3~":7}" %)7|(% data-sheets-value="{~"1~":3,~"3~":8}" %)8|(% data-sheets-value="{~"1~":3,~"3~":9}" %)9|(% data-sheets-value="{~"1~":3,~"3~":10}" %)10|(% data-sheets-value="{~"1~":3,~"3~":11}" %)11|(% data-sheets-value="{~"1~":3,~"3~":12}" %)12|(% data-sheets-value="{~"1~":3,~"3~":13}" %)13|(% data-sheets-value="{~"1~":3,~"3~":14}" %)14|(% data-sheets-value="{~"1~":3,~"3~":15}" %)15|(% data-sheets-value="{~"1~":3,~"3~":16}" %)16|(% data-sheets-value="{~"1~":3,~"3~":17}" %)17|(% data-sheets-value="{~"1~":3,~"3~":18}" %)18|(% data-sheets-value="{~"1~":3,~"3~":19}" %)19|(% data-sheets-value="{~"1~":3,~"3~":20}" %)20|(% data-sheets-value="{~"1~":3,~"3~":21}" %)21|(% data-sheets-value="{~"1~":3,~"3~":22}" %)22|(% data-sheets-value="{~"1~":3,~"3~":23}" %)23|(% data-sheets-value="{~"1~":3,~"3~":24}" %)24|(% data-sheets-value="{~"1~":3,~"3~":25}" %)25|(% data-sheets-value="{~"1~":3,~"3~":26}" %)26|(% data-sheets-value="{~"1~":3,~"3~":27}" %)27|(% data-sheets-value="{~"1~":3,~"3~":28}" %)28|(% data-sheets-value="{~"1~":3,~"3~":29}" %)29|
31 +|(% data-sheets-value="{~"1~":2,~"2~":~"MAN (PALETT)~"}" %)ARBETSMOD|(% data-sheets-value="{~"1~":2,~"2~":~"MAN (PALETT)~"}" %)MAN (PALETT)|(% data-sheets-value="{~"1~":2,~"2~":~"BATCHFIL~"}" %)BATCHFIL| |(% data-sheets-value="{~"1~":2,~"2~":~"POST~"}" %)POST| |(% data-sheets-value="{~"1~":2,~"2~":~"PALFIL~"}" %)PALFIL|(% data-sheets-value="{~"1~":3,~"3~":211530}" %)211530|(% data-sheets-value="{~"1~":2,~"2~":~"OBJEKT~"}" %)OBJEKT|(% data-sheets-value="{~"1~":2,~"2~":~"ENSKEDEVäGEN ET1 ALLéN P64050029~"}" %)MALMÖVäGEN ET1 EMP S64050000|(% data-sheets-value="{~"1~":2,~"2~":~"ORDER~"}" %)ORDER|(% data-sheets-value="{~"1~":2,~"2~":~"P64029631~"}" %)P64029631|(% data-sheets-value="{~"1~":2,~"2~":~"TLMFIL~"}" %)TLMFIL|(% data-sheets-value="{~"1~":2,~"2~":~"631-0~"}" %)631-0|(% data-sheets-value="{~"1~":2,~"2~":~"STAPEL~"}" %)STAPEL|(% data-sheets-value="{~"1~":3,~"3~":0}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"MO~"}" %)MO|(% data-sheets-value="{~"1~":3,~"3~":0}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"PRDFIL~"}" %)PRDFIL|(% data-sheets-value="{~"1~":2,~"2~":~"PL-31022~"}" %)PL-31022|(% data-sheets-value="{~"1~":2,~"2~":~"PRODDATUM~"}" %)PRODDATUM|(% data-sheets-numberformat="{~"1~":5,~"2~":~"yyyy-mm-dd~",~"3~":1}" data-sheets-value="{~"1~":3,~"3~":43160}" %)2018-03-01|(% data-sheets-value="{~"1~":2,~"2~":~"PRODTID~"}" %)PRODTID|(% data-sheets-value="{~"1~":2,~"2~":~"09:48:59~"}" %)09:48:59|(% data-sheets-value="{~"1~":2,~"2~":~"OMPRODUKTION~"}" %)(((
32 +OMPRODUKTION
33 +)))| |(% data-sheets-value="{~"1~":2,~"2~":~"ELEMENTID~"}" %)ELEMENTID|(% data-sheets-value="{~"1~":3,~"3~":166}" %)166|(% data-sheets-value="{~"1~":2,~"2~":~"STANDARD~"}" %)STANDARD|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|
34 +|(% data-sheets-value="{~"1~":2,~"2~":~"MAN (PALETT)~"}" %)ARBETSMOD|(% data-sheets-value="{~"1~":2,~"2~":~"MAN (PALETT)~"}" %)MAN (PALETT)|(% data-sheets-value="{~"1~":2,~"2~":~"BATCHFIL~"}" %)BATCHFIL| |(% data-sheets-value="{~"1~":2,~"2~":~"POST~"}" %)POST| |(% data-sheets-value="{~"1~":2,~"2~":~"PALFIL~"}" %)PALFIL|(% data-sheets-value="{~"1~":3,~"3~":211530}" %)211530|(% data-sheets-value="{~"1~":2,~"2~":~"OBJEKT~"}" %)OBJEKT|(% data-sheets-value="{~"1~":2,~"2~":~"ENSKEDEVäGEN ET1 ALLéN P64050029~"}" %)MALMÖVäGEN ET1 EMP S64050000|(% data-sheets-value="{~"1~":2,~"2~":~"ORDER~"}" %)ORDER|(% data-sheets-value="{~"1~":2,~"2~":~"P64029631~"}" %)P64029631|(% data-sheets-value="{~"1~":2,~"2~":~"TLMFIL~"}" %)TLMFIL|(% data-sheets-value="{~"1~":2,~"2~":~"631-0~"}" %)631-0|(% data-sheets-value="{~"1~":2,~"2~":~"STAPEL~"}" %)STAPEL|(% data-sheets-value="{~"1~":3,~"3~":0}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"MO~"}" %)MO|(% data-sheets-value="{~"1~":3,~"3~":0}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"PRDFIL~"}" %)PRDFIL|(% data-sheets-value="{~"1~":2,~"2~":~"PL-31022~"}" %)PL-31022|(% data-sheets-value="{~"1~":2,~"2~":~"PRODDATUM~"}" %)PRODDATUM|(% data-sheets-numberformat="{~"1~":5,~"2~":~"yyyy-mm-dd~",~"3~":1}" data-sheets-value="{~"1~":3,~"3~":43160}" %)2018-03-01|(% data-sheets-value="{~"1~":2,~"2~":~"PRODTID~"}" %)PRODTID|(% data-sheets-value="{~"1~":2,~"2~":~"09:48:59~"}" %)09:48:59|(% data-sheets-value="{~"1~":2,~"2~":~"OMPRODUKTION~"}" %)(((
35 +OMPRODUKTION
36 +)))| |(% data-sheets-value="{~"1~":2,~"2~":~"ELEMENTID~"}" %)ELEMENTID|(% data-sheets-value="{~"1~":3,~"3~":167}" %)167|(% data-sheets-value="{~"1~":2,~"2~":~"STANDARD~"}" %)STANDARD|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|
37 +
38 +== Picked Values ==
39 +
40 +The following values are picked from the file:
41 +
42 +Project = Column[11]
43 +Element Mark = Column[19]
44 +Element Id = Column[27]
45 +Standard = Column[29]
46 +
47 +== Functionality ==
48 +
49 +First the cast status is changed from Planned to Produced in the table imp_production_cast.
50 +Then the status machine is triggered to update the status of the element identified by the given Standard, Project and Element Id.
51 +
52 +
53 +
Copyright 2018 StruSoft AB
Impact Documentation