Супермаг УКМ4 XML - импорт-экспорт : УКМ-4

SMak · █ 29.06.2016 22:43

или вот такая ошибка возникает именно из-за отсутствия чеков отдельными файлами?

Код:

2016.06.29 (среда) 22:12:58 1.33.1.0 sp1 [12] WARN Sm.Cash.Server
источник: SmCashServerLib
Ошибка драйвера кассы при загрузке данных для МХ Троицко-Печорск в базе данных ABTRPECH. Условный номер кассы 97. Дополнительную информацию см. в следующем сообщении.
--------------------------------------------------------
2016.06.29 (среда) 22:12:58 1.33.1.0 sp1 [12] ERROR Sm.Cash.Server
----- Прерывание работы программы -----
сообщение: "ORA-02291: integrity constraint (SUPERMAG.SMCCASHCHECKZ) violated - parent key not found"
исключение: Sm.Core.InteropException
hResult: 80004005h; доп. код: 2291
источник: Microsoft OLE DB Provider for Oracle
----- Причина исключения, уровень вложения 1 -----
сообщение: "INSERT INTO Supermag.SMCashChecks(LocID, DeskNum, ZNum, CheckNum, PrintTime,Cashier,TotalSum, OpCode, DepID )  VALUES (-2,-1,-1,-1,TO_DATE('20160629 111047','YYYYMMDD HH24MISS'),1,TO_NUMBER('1309,0500000000004','9999D9999999999999','NLS_NUMERIC_CHARACTERS='','''),1,-1)"
исключение: Sm.Core.InteropException
hResult: 80004005h; доп. код: 0
источник: SmLibaryBase trace

whitewizard · █ 30.06.2016 04:12

Не очень мне нравятся отрицательные значения

Код:

VALUES (-2,-1,-1,-1,

bob · █ 30.06.2016 07:39

Цитата:

SMak ➤ а нужны ли чеки, если не используем оперсводку?

Можно и без них.

SMak · █ 30.06.2016 09:29

супермагу они тоже не нравятся :(
а пытаемся вгрузить вот это:

Код:

<?xml version="1.0" encoding="utf-8"?>
<shift storeId="25" posNum="97" shiftNum="217" dateClose="2016-06-29T20:00:00">
  <version>1.0</version>
  <dateClose>2016-06-29T20:00:00</dateClose>
  <cashierName />
  <cashierCode>1</cashierCode>
  <saleAmount>1468.9</saleAmount>
  <returnAmount>130.4</returnAmount>
  <saleCount>3</saleCount>
  <returnCount>1</returnCount>
  <receipt>
    <receiptNum>50004</receiptNum>
    <receiptDateTime>2016-06-29T11:10:47</receiptDateTime>
    <cashierCode>1</cashierCode>
    <type>0</type>
    <amount>1309.0500000000004</amount>
    <item>
      <article>105918</article>
      <quantity>1</quantity>
      <price>188.95</price>
      <barcode>2500000195051</barcode>
      <egaisBarcode />
      <total>188.95</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>063243</article>
      <quantity>1</quantity>
      <price>299</price>
      <barcode>2210304</barcode>
      <egaisBarcode />
      <total>299</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>063243</article>
      <quantity>1</quantity>
      <price>299</price>
      <barcode>2210304</barcode>
      <egaisBarcode />
      <total>299</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>068650</article>
      <quantity>1</quantity>
      <price>103.95</price>
      <barcode>2500000193644</barcode>
      <egaisBarcode />
      <total>103.95</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>016490</article>
      <quantity>1</quantity>
      <price>114.95</price>
      <barcode>4607065000813</barcode>
      <egaisBarcode />
      <total>114.95</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>016490</article>
      <quantity>1</quantity>
      <price>114.95</price>
      <barcode>4607065000813</barcode>
      <egaisBarcode />
      <total>114.95</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>084716</article>
      <quantity>1</quantity>
      <price>68.45</price>
      <barcode>4620739973206</barcode>
      <egaisBarcode />
      <total>68.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>091794</article>
      <quantity>1</quantity>
      <price>32.45</price>
      <barcode>2500000159749</barcode>
      <egaisBarcode />
      <total>32.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>091794</article>
      <quantity>1</quantity>
      <price>32.45</price>
      <barcode>2500000159749</barcode>
      <egaisBarcode />
      <total>32.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>091794</article>
      <quantity>1</quantity>
      <price>32.45</price>
      <barcode>2500000159749</barcode>
      <egaisBarcode />
      <total>32.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>072907</article>
      <quantity>1</quantity>
      <price>22.45</price>
      <barcode>2500000090097</barcode>
      <egaisBarcode />
      <total>22.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>188.95</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>299</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>299</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>103.95</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>114.95</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>114.95</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>68.45</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>32.45</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>32.45</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>32.45</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>22.45</paymentAmount>
    </payment>
  </receipt>
  <receipt>
    <receiptNum>50006</receiptNum>
    <receiptDateTime>2016-06-29T11:13:11</receiptDateTime>
    <cashierCode>1</cashierCode>
    <type>0</type>
    <amount>130.4</amount>
    <item>
      <article>043378</article>
      <quantity>1</quantity>
      <price>35.95</price>
      <barcode>4607120854184</barcode>
      <egaisBarcode />
      <total>35.95</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <item>
      <article>107326</article>
      <quantity>1</quantity>
      <price>94.45</price>
      <barcode>2500000197925</barcode>
      <egaisBarcode />
      <total>94.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>35.95</paymentAmount>
    </payment>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>94.45</paymentAmount>
    </payment>
  </receipt>
  <receipt>
    <receiptNum>50007</receiptNum>
    <receiptDateTime>2016-06-29T11:16:04</receiptDateTime>
    <cashierCode>1</cashierCode>
    <type>1</type>
    <amount>94.45</amount>
    <item>
      <article>107326</article>
      <quantity>1</quantity>
      <price>94.45</price>
      <barcode>2500000197925</barcode>
      <egaisBarcode />
      <total>94.45</total>
      <stockId>1</stockId>
      <enterType>0</enterType>
      <sellerId>1</sellerId>
      <sellerName />
    </item>
    <payment>
      <paymentId>0</paymentId>
      <paymentAmount>94.45</paymentAmount>
    </payment>
  </receipt>
</shift>