Pallet Status Import

Last modified by Theib Sawaf on 2018/10/17 15:26

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" />

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:     

01234567891011121314151617181920212223242526272829 
ARBETSMODMAN (PALETT)BATCHFIL POST PALFIL211530OBJEKTMALMÖVäGEN ET1 EMP S64050000ORDERP64029631TLMFIL631-0STAPEL0MO0PRDFILPL-31022PRODDATUM2018-03-01PRODTID09:48:59

OMPRODUKTION

 ELEMENTID166STANDARD1101 
ARBETSMODMAN (PALETT)BATCHFIL POST PALFIL211530OBJEKTMALMÖVäGEN ET1 EMP S64050000ORDERP64029631TLMFIL631-0STAPEL0MO0PRDFILPL-31022PRODDATUM2018-03-01PRODTID09:48:59

OMPRODUKTION

 ELEMENTID167STANDARD1101 

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.
 

    

Tags:
Created by Theib Sawaf on 2018/09/27 15:39
Copyright 2018 StruSoft AB
Impact Documentation