Pallet Status Import
Format
The file format is text with a comma separated values with the extension *.tvn
Contents
The contains element data: Factory, Project, Element Id, Element mark, Production Date,.. etc
Configuration
<!-- Pallet System file directories-->
<add key="PalletStatusImportDirectory" value="C:\IMPACT\StruSoft\Pallet\In" />
<add key="PalletErrorDirectory" value="C:\IMPACT\StruSoft\Pallet\Error" />
<add key="PalletProcessedDirectory" value="C:\IMPACT\StruSoft\Pallet\Processed" />
<add key="ProductionCompanyId" value="1050"/>
Details
Example of a TVN file with 2 elements on the pallet (cast unit):
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;
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;
Below it is show in table form with column numbering:
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | |
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 | ||||
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 |
Picked Values
The following values are picked from the file:
Project = Column[11]
Element Mark = Column[19]
Element Id = Column[27]
Standard = Column[29]
Functionality
First the cast status is changed from Planned to Produced in the table imp_production_cast.
Then the status machine is triggered to update the status of the element identified by the given Standard, Project and Element Id.