Mit DBK
Driftsstatus: Normal drift.

FTP order integration to BOP

Bookstores with a high ordervolume, can deliver orders directly to Bogportalen through XML orderfiles placed on a DBK FTP server.

Customers with a order integration to the current version of Bogportalen, will have to make minor adjustments to make the integration work on the new Bogportalen platform 

BOP order integration vs. AB format order integration

DBK has two different types of integrations for sending orders to DBK: 

  • BOP order integration (described on this page) can be used by bookstores to order large volumes of orders to themself. It’s not possible to deliver the orders from this integration to any other addresses (eg. end customers). 
  • AB order format order integration can be used by publishers, bookstores (with a webshop) and webshops to place orders for their end customers. See more here. 

1) FTP details

Server address (host): TBA

Protocol: SFTP

Port number: TBA

Authentication method: username/password

Directory structure:

    • Upload of orders: /Orders/Pending/  

    • DBK wil move succesfully imported order lines here: /Orders/Ok

    • DBK wil move order lines not imported here: /Orders/Error

 

File naming conventions:
Uploaded orders should have unique filenames.

Recommended format: <DBK customer number>-<date>-internal order id>.xml. Eg: 1050-20250918-12345.xml 

Update frequency:
Files uploaded to the server will be imported everyXYZ minute 


2) XML Format Specification

XML file structure:  XML files for DBK can be validated against the XSD using a XML Schema validation service like Corefiling. 

Encoding: The files needs to be encoded in UTF-8 without BOM 

 

Please note that the format has not yet been finalized.

Field description

bop-order-example.xml 
<?xml version="1.0" encoding="utf-8"?>
<ExternalOrder xmlns="http://m8600.order.bogportalen.dk">
  <RequestId>90</RequestId>
  <Order>
    <SalesType>DO</SalesType>
    <OrderType>DO</OrderType>
    <AcceptPartialShipment>true</AcceptPartialShipment>
    <YourReference>17-07-2011 16:30:15</YourReference>
    <DeliveryDate>2011-01-01</DeliveryDate>
    <CustomerId>1111</CustomerId>
    <ShipPackaging />
    <ShipComment />
    <ShipMode>Default Carrier</ShipMode>
    <OrderItem>
      <OrderItemId>345109</OrderItemId>
      <Isbn13>9788777066399</Isbn13>
      <Quantity>1</Quantity>
      <Title>Lad alt blive din læremester</Title>
      <CustomerReference>345109</CustomerReference>
      <AcceptPartialShipment>true</AcceptPartialShipment>
      <OrderReference>20532</OrderReference>
    </OrderItem>
    <OrderItem>
      <OrderItemId>345110</OrderItemId>
      <Isbn13>9781408803011</Isbn13>
      <Quantity>1</Quantity>
      <Title>Fantastic Beasts and Where to Find Them</Title>
      <CustomerReference>345110</CustomerReference>
      <AcceptPartialShipment>true</AcceptPartialShipment>
      <OrderReference>20533</OrderReference>
    </OrderItem>
    <PaymentMethod>Invoice</PaymentMethod>
  </Order>
</ExternalOrder>
ExternalOrder

Root element. Contains one or more orders.

  • RequestId
    Reference number for the order delivery. Can be freely defined by the customer.

Order

  • SalesType
    Indicates whether the order is a normal order (DO), standing order, approval copy, etc. Currently only DO is used.

  • OrderType
    Same as SalesType – currently only DO is supported.

  • AcceptPartialShipment
    Boolean (true/false). Indicates whether partial delivery is accepted.

  • YourReference
    Optional reference field. May contain free text.

  • DeliveryDate
    Desired delivery date. Optional. Format: YYYY-MM-DD.

  • CustomerId
    Customer number at DBK.

  • ShipPackaging
    Optional. Specifies packaging instructions.

  • ShipComment
    Optional. Free text, e.g. “Please deliver at the back entrance”.

  • ShipMode
    Specifies delivery method. Currently only “Default Carrier” is supported.

  • OrderItem
    One or more order lines must be included.

    • OrderItemId
      Line ID (freely definable by the customer).

    • Isbn13
      ISBN number of the product (13 digits).

    • Quantity
      Number of copies ordered.

    • Title
      Optional. Book title (informational only).

    • CustomerReference
      Optional. Customer’s own reference.

    • AcceptPartialShipment
      Boolean. Optional per order line.

    • OrderReference
      Optional reference field.

  • PaymentMethod
    Currently only “Invoice” is supported.

XSD for orders to BOP
Sample file

3) Error messages and handling

XML file structure:  XML files for DBK can be validated against the XSD using a XML Schema validation service like Corefiling. 

Resubmission: Orderlines that fails, and has been put into the /Orders/Error folder, hasn’t been imported and will not be processed. The errors shopuld be corrected, and the orderlines should be sent again to get the lines processed. When resubmitting, only orderlines that fails should be submitted, to avoid orderlines to be submitted twice

Duplicate order lines: DBK doesn’t handle duplicate orders, so be aware that orders are only uploaded once, to prevent ordering (and paying for) duplicate orders.

Søg på dbk.dk: