00197198-02_XML-Import-SetupCenter-5.1 - 第18页
Setup Center 5. 1 - X ML Import 18 of 22 4 Restrictions 4.1 Import The following co lumns of table PackagingUnit can not be im ported: Column Name Desciption Restriction State Verification state No Necessar y to import…
Setup Center 5.1 - XML Import
17 of 22
The following example shows a file, which updates the MSD open date of an existing packaging
unit in the database.
<?xml version="1.0" encoding="utf-8" ?>
<PackagingList ImportVersion="1.0.3.1">
<Packaging
IdPackaging="X0000001"
ComponentName="Component01"
ComponentBarcode=""
MsdOpenDate="2007-12-01T09:00:00+01:00"
</PackagingList>
Setup Center 5.1 - XML Import
18 of 22
4 Restrictions
4.1 Import
The following columns of table PackagingUnit cannot be imported:
Column Name
Desciption
Restriction
State
Verification state
No
Necessary to import, because
Setup Center manages this
attribute.
SplicedPackagingUnitId
Predecessor in a
splice chain
Yes
Packing Units within a splice chain
cannot be imported
DepletedDate
Depleted date
No
Set by Setup Center or not useful
for import.
LastModifiedDate
Date of last
change
No
Set by Setup Center automatically
GreyZone
Transition zone,
which is notified in
traceability file
Yes
Do not import or update packaging
units, which have a grey zone value
greater than zero. This causes
invalid traceability data at station of
the X-Series.
VerifiedDate
Date of last verify
No
Set by Setup Center
The packaging unit editor is not automatically updated.
Processing of big files may slow down the setup verification, if the Setup Center also manages
one or more barcode scanners.
Setup Center 5.1 - XML Import
19 of 22
5 Error result file
Faulty or partially processed XML import files will be copied to the directory ‘XML-NotOK’
and an additional text file with the name of the XML file and the postfix ".error.txt" will be
created. The following file is an example (Please see also Appendix A):
Line 67: Attribute 'OriginalQuantity' contains invalid data.
Line 85: Attribute 'Quantity' contains invalid data.
Line 103: Attribute 'ManufactureDate' contains invalid data.
Line 121: Attribute 'ExpiryDate' contains invalid data.
Line 139: Attribute 'MsdLevel' contains invalid data.
Line 157: Required attribute 'IdPackaging' is missing.
Line 174: Attribute 'IdPackaging' contains invalid data.
Line 192: String value of 'IdPackaging' exeeds the maximum length of 40.
Line 210: Required attribute 'ComponentName' is missing.
Line 227: Attribute 'ComponentName' contains invalid data.
Line 245: String value of 'ComponentName' exeeds the maximum length of 256.
Line 263: Required attribute 'ComponentBarcode' is missing.
Line 280: String value of 'ComponentBarcode' exeeds the maximum length of 256.
Line 298: Attribute 'OriginalQuantity' contains invalid data.
Line 316: Attribute 'OriginalQuantity' contains invalid data.
Line 334: Attribute 'Quantity' contains invalid data.
Line 352: Attribute 'Quantity' contains invalid data.
Line 370: Quantity is missing ('OriginalQuantity' or 'Quantity' required).
Line 386: String value of 'Manufacturer' exeeds the maximum length of 256.
Line 404: String value of 'Supplier' exeeds the maximum length of 256.
Line 422: String value of 'DeliveryNote' exeeds the maximum length of 256.
Line 440: String value of 'Extra1' exeeds the maximum length of 256.
Line 458: String value of 'Extra2' exeeds the maximum length of 256.
Line 476: String value of 'Extra3' exeeds the maximum length of 256.
Line 494: String value of 'Comment' exeeds the maximum length of 256.
Line 513: Quantity is missing ('OriginalQuantity' or 'Quantity' required).
Line 519: Attribute 'Quantity' contains invalid data.
Line 526: Attribute 'Quantity' contains invalid data.
Line 533: Packing unit is used within a setup and cannot be updated.
Line 540: Packing unit is used within a splice chain and cannot be updated.
Line 547: Packing unit is used within a splice chain and cannot be updated.
Line 554: Packing unit is used within a splice chain and cannot be updated.
Line 561: Packing unit is used within a setup and cannot be updated.
The file has the following format:
<Line Number>: <Error Message>
<Line Number> Line number of the first row, which describes the error-prone
packaging unit
<Error Message> Error message which describes the issue
The XML Import checks the XML Import file in two levels. First level checks the “PackagingId” and
the correct data types, for example that the quantity can be converted to an integer. If the first
checks are successfully succeeded, Setup Center checks in the second level constraints and
restrictions. Therefore for each line several error lines can be written to the error result file.