From empty
To version 8.1
edited by Theib Sawaf
on 2018/10/07 13:36
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,51 @@
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 + <!~-~- Exported file directories ~-~->
15 + <add key="ERPProductionDirectory" value="C:\IMPACT\StruSoft\ERPProduction\Out" />
16 +
17 +(% id="HDetails" %)
18 +== Details ==
19 +
20 +
21 +Example of a TVN file with 2 elements on the pallet (cast unit):
22 +
23 +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;
24 +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;
25 +
26 +Below it is show in table form with column numbering:
27 +
28 +|(% 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|
29 +|(% 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~"}" %)(((
30 +OMPRODUKTION
31 +)))| |(% 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|
32 +|(% 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~"}" %)(((
33 +OMPRODUKTION
34 +)))| |(% 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|
35 +
36 +== Picked Values ==
37 +
38 +The following values are picked from the file:
39 +
40 +Project = Column[11]
41 +Element Mark = Column[19]
42 +Element Id = Column[27]
43 +Standard = Column[29]
44 +
45 +== Functionality ==
46 +
47 +First the cast status is changed from Planned to Produced in the table imp_production_cast.
48 +Then the status machine is triggered to update the status of the element identified by the given Standard, Project and Element Id.
49 +
50 +
51 +
Copyright 2018 StruSoft AB
Impact Documentation