Jakost a kvalita, čeština Quality management, English

DRIVER CSV

Quality management » Interconnection » Drivers »

Driver CSV
Print
Code: SW-DRV-CSV

When deploying the driver, it is necessary to configure it using an XML configuration file. The instructions below describe the configuration options.

 

Location of individual files

 

The "Palstat.Drivers.CSV.dll" driver is located in the ../CAQdesktop/APL/Drivers/ directory and is part of the update/installation package that you download from our customer portal.

The "Palstat.Drivers.CSV.xml" configuration file must be located in the ../CAQdesktop/CONFIG/Drivers/ directory or in the ../CAQservice/CONFIG/Drivers/ directory if you use the CAQservice (recommended). The default configuration file is included in the installation package ../CAQservice/CONFIG/Drivers/


Driver imports data into the Palstat system according to the set configuration in the file "Palstat.Drivers.CSV.xml"

Driver can be configured to automatically load data into the system


Sample configuration file Palstat.Drivers.CSV.xml

<?xml version="1.0" encoding="utf-8"?>
<Settings>
  <Delimiter>;</Delimiter>
  <HeaderLinesCount>1</HeaderLinesCount>
  <Parameters>
    <Parameter Name="Date" Position="1" Format="dd.MM.yyyy"></Parameter>
    <Parameter Name="Time" Position="2" Format="HH:mm:ss"></Parameter>
    <Parameter Name="PartNumber" Position="3"></Parameter>
    <Parameter Name="CharCode" Position="4"></Parameter>
    <Parameter Name="MachineCode" Position="5"></Parameter>
    <Parameter Name="ActualValue" Position="6"></Parameter>
  </Parameters>
</Settings>

Description of parameters

List of parameters that can be set in the driver.

Delimiter     item separator (default value is ";")
HeaderLinesCount     number of header lines (default value is "1")
Parameters     parameter settings
  Name   parameter name in code (from allowed parameters)
  Position   position from which parameter is to be filled (from "1")
  Default   default value
  Format   format date and time
  LowerTolerance   for subtraction "-" (default value is "+")
       
Allowed parameters PartNumber   part number – Číslo dílu
  PartIndex   change index – Index změny
  PartName   part name (default value is PartNumber) – Název dílu
  CharCode   characteristic code – Kód kóty
  CharName   characteristic name (default value is CharCode) – Název kóty
  MachineCode   machine (machine code in codelist Machines) - Stroj
  ActualValue   measured value – Nová hodnota
  NominalValue   nominal value - JR
  UpperValue   upper limit - HT
  LowerValue   lower limit - DT
  UpperTolerance   upper tolerance (if not used UpperValue) – odchylka od JR, která dopočítá HT
  LowerTolerance   lower tolerance (if not used LowerValue) – odchylka od JR, která dopočítá DT
  DateTime   date and time of inspection - default value is current date and time
  Date   inspection date (if not used DateTime) - default value is current date
  Time   inspection time (if not used DateTime) - default value is current time
  User   inspector (default value is IMPORT) - Kontrolor
  NestName   cavity name - Otisk
  NestNumber   cavity number – Název otisku
  Info1   Info1
  Info2   Info2
  Info3   Info3
  Info4   Info4
  Info5   Info5 
 

 


https://www.palstat.cz/ - Systém řízení kvality Ubytování ve Vrchlabí