Pallet Status Import

Version 7.1 by Theib Sawaf on 2018/09/30 12:17

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

    <!-- Exported file directories -->
    <add key="ERPProductionDirectory" value="C:\IMPACT\StruSoft\ERPProduction\Out" />

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:
Copyright 2024 StruSoft AB
IMPACT Wiki