Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

VLOG Shipment Interface (SQL API)

Back | Level back

The ware economy EULANDA® is a interface to the dispatched system VLOG. This is based on different views and procedures, you control the delivery.

The following description is for persons who use the dispatched software on the side of the side, tied up with EULANDA®. To simplify the control, a sentence of APIs will be used to simplify updates and customized extensions.

The dispatch software could call up all transmissions by the EXPORT_VLOG_Sendung view. Intern the transmission table has a status field named DispatchDeliveryStatus, which is standing on 1 if the transmission will be transferred to VLOG.

A transmission could exist of several packets, but at least one packet. The packet data are standing in the EXPORT_VLOG_SendungPaket view.

The mandator name will always be handed over because of the inter view which could be gather the transmissions from different databases.

At first the process of the views had to query the EXPORT_VLOG_Sendung-View. If there where data, the pertinently packets could be taken over by the EXPORT_VLOG_SendungPaket. As Where-Clause you should only took over packets to avoid that packages in the meantime put on to be processed to those the information was not read yet.

If the data will be accepted by VLOG, you have to set the cn_VLOG_Sendung value to 2 by the procedure DispatchDeliveryStatus (= Data accepted). The data will be fade out both views (EXPORT_VLOG_Sendung and EXPORT_VLOG_SendungPaket).

After printing the labels you have to update DispatchDeliveryStatus=3. With the delivery of the status value you have to be careful that the field @Mandator will be deliver, too stets thus the procedure will be update the right database.

If a carrier supports the delivery costs, they could be deliver by cn_VLOG_Sendung.

As soon as the tracking number will be known, it could be set by the cn_VLOG_SendungPaket procedures.

The receiver and the receive date could be handed over, if the transmission arrived at the receiver. That could be taken place by the cn_VLOG_SendungPaket procedure.

Beside the polling of both views (EXPORT_VLOG_Sendung and EXPORT_VLOG_SendungPaket), the sending software could be ask if the daily conclusion of a carrier and mandator have to accomplish. For that you could use this procedure cn_VLOG_Tagesabschluss. As soon the parameter @Value supplies the value 1 you have to accomplish the daily conclusion of the mandator and carrier.

Thus you could already access of data which are faded out you had the views named EXPORT_VLOG_Sendung_Alle and EXPORT_VLOG_SendungPaket_Alle.

Views for VLOG supply
EXPORT_VLOG_Sendung
EXPORT_VLOG_Sendung_Alle
EXPORT_VLOG_SendungPaket
EXPORT_VLOG_SendungPaket_Alle

Procedures for VLOG supply
cn_VLOG_Sendung
cn_VLOG_SendungPaket
cn_VLOG_Tagesabschluss
 

Here you you find the names of the views and also the names of the procedures and mandator names, should be adjustable. The views in EULANDA® could be extended by other fields, and also new parameters could be added by the procedures. Because of that reason you should only indicate  the procedures with their parameter name like the example shows. Views should be call with field names like „SELECT MATCH, NAME1,NAME2....“ instead of  „SELECT *“. The views with the postfix "All" should not be use in the normal operation, because of they are unfiltered and the filter is not only depending by „DispatchDeliveryStatus“.

The VLOG interface is not for free. You can get  the price for the EULANDA® interface at the EULANDA® drove out and at VLOG :

MHP Software GmbH
Justus-von-Liebig Strasse 3
D-31535 Neustadt am Rübenberge
fon: +49 (0)5032/9656-0
fax: +49 (0)5032/9656-11
web: www.mhp-net.de