With the help of CSV files DHL, GLS and DPD are connected.
Separator
The entries are separated with a |.
header data
The header line consists of:
| Shipment Ref-No. | sender Ref. no. | sender remark | Mand. Ref. no. | proceedings | participation | cost center | product | service list | NN Currency | TV currency | Rec. Ref. no. | Rec. Name1 | Rec. Name2 | Rec. Name3 | Rec. Postcode | Rec. location | Rec. district | Rec. Street | Rec. Hausnr. | Rec. Tel | Rec. fax | POOL_REC_EMAIL | POOL_REC_DATEOFBIRTH | POOL_REC_CARD_NO | POOL_REC_TYPE_OF_CARD | POOL_REC_ID | POOL_REC_MINIMUM_AGE | POOL_REC_MA_LOCATION | POOL_REC_MA_DISTRICT | POOL_REC_MA_STREET | POOL_REC_SURNAME | POOL_REC_FIRST_NAME | POOL_REC_CONTRACT_ID | POOL_REC_CITICENSHIP | POOL_REC_ADDITIONAL_QUERY | POOL_REC_ANSWER | POOL_REC_IDP_CONF | Rec. Add.-Partner | Rec. remark | UST-IdNr. | Rec. country | POOL_REC_DISTRICT_OF_CUSTOMS | weight | number of shipments | customs type | POOL_WORKSTATION | POOL_ZOLL_MRNNUMBER | Advance Nat. | POOL_V_PREVIEW_NAT_TERM | undeliverability notice | POOL_AVISE | POOL_V_PREVIEW_INT | POOL_V_PREVIOUS_INT_TERM | POOL_V_PREVIOUS_INT_TRANSP | POOL_EPACK_AHEAD | POOL_IDENTEXPRESS | POOL_EXCHANGE_DIFFERENDERETADDR | POOL_EXCHANGE_EXCHANGE_TYPE | POOL_EXCHANGE_TEST_TYPE | POOL_EXCHANGE_PERFORMANCE_ATTR | POOL_SHIPMENT_ID | POOL_EXWORKS | POOL_CONTENTS | POOL_USAGE_PURPOSE | POOL_PREDATE | POOL_SHIPPMENTCONTENTDHL | POOL_INVOICETYPEDHL | POOL_INVOICENUMBERDHL | POOL_INVOICEDATEDHL | POOL_SIGNATORYDHL | POOL_CUSTOMSTARIFFDHL | POOL_INVOICEDHL | POOL_EXPORTTYPEDHL | POOL_EXPORTREASONDHL | POOL_INVOICEITEMSDHL | POOL_EXTRADATA | POOL_ADDITIONAL_1 | POOL_ADDITIONAL_2 | POOL_ADDITIONAL_3 | customs declaration |
The header data is not output in the standard configuration.
Content
The content can look like this:
| 121212 | asas | 1 | 101 | EUR | EUR | 1KuAbw8 | Johannes Neumann | 21465 | Reinbek | Borsigstrasse | 24 | 0 | Johannes Neumann | DE | 2.5 | 1 | 0 | 1 | Test product|1124.0Test product|1124.0 |
Note the last column here: this can also contain the | character as a separator symbol for the customs declaration.
Application
The CSV files are available for DHL Easylog, DPD Delisprint and GLS Gepard. An XML file is generated for the connection to UPS Worldship. DPD, DHLand Internetmarke are also directly connected via the respective web service. In addition, Wemalo provides a connection to Shipcloud, in which all common shipping service providers are contained in one interface.
Example
Sendungs Ref-Nr.|Abs. Ref-Nr.|Abs. Bemerkung|Mand. Ref-Nr.|Verfahren|Teilnahme|Kostenstelle|Produkt|Serviceliste|NN Währung|TVWährung|Empf. Ref-Nr.|Empf. Name1|Empf. Name2|Empf. Name3|Empf. PLZ|Empf. Ort|Empf. Ortsteil|Empf. Strasse|Empf. Hausnr.|Empf. Tel|Empf. Fax|POOL_EMPF_EMAIL|POOL_EMPF_GEBDATUM|POOL_EMPF_AUSWEISNR|POOL_EMPF_AUSWEISART|POOL_EMPF_AUSWEISBEH|POOL_EMPF_MINDESTALTER|POOL_EMPF_MA_ORT|POOL_EMPF_MA_STADTTEIL|POOL_EMPF_MA_STRASSE|POOL_EMPF_NACHNAME|POOL_EMPF_VORNAME|POOL_EMPF_VERTRAG_ID|POOL_EMPF_STAATSANGEHOERIGKEIT|POOL_EMPF_ZUSAETZLICHEABFRAGE|POOL_EMPF_ANTWORT|POOL_EMPF_IDP_CONF|Empf. An.-Partner|Empf. Bemerkung|UST-IdNr.|Empf. Land|POOL_EMPF_ZOLLBEZIRK|Gewicht|Sendungsanzahl|Zoll-Warenart|POOL_WORKSTATION|POOL_ZOLL_MRNNUMBER|Vorausverf. Nat.|POOL_V_VORAUSVERF_NAT_TERMIN|Unzustellbarkeitsanzeige|POOL_AVISE|POOL_V_VORAUSVERF_INT|POOL_V_VORAUSVERF_INT_TERMIN|POOL_V_VORAUSVERF_INT_TRANSP|POOL_EPACK_VORAUS|POOL_IDENTEXPRESS|POOL_TAUSCH_ABWEICHENDERETADDR|POOL_TAUSCH_TAUSCHTYP|POOL_TAUSCH_PRUEFUNGTYP|POOL_TAUSCH_LEISTUNGATTR|POOL_SHIPMENT_ID|POOL_EXWORKS|POOL_CONTENTS|POOL_VERWENDUNGSZWECK|POOL_VORDATE|POOL_SENDUNGSINHALTDHL|POOL_RECHNUNGSARTDHL|POOL_RECHNUNGSNUMMERDHL|POOL_RECHNUNGSDATUMDHL|POOL_UNTERZEICHNERDHL|POOL_ZOLLTARIFDHL|POOL_RECHNUNGSBEMDHL|POOL_EXPORTARTDHL|POOL_EXPORTGRUNDDHL|POOL_RECHNUNGSPOSITIONENDHL|POOL_EXTRADATA|POOL_ADDITIONAL_1|POOL_ADDITIONAL_2|POOL_ADDITIONAL_3|Zollinhaltserklärung
121212|||asas|1|||101||EUR|EUR|1KuAbw8||Johannes Neumann||21465|Reinbek||Borsigstrasse|24||||||00||||||Johannes Neumann||||||||||DE||2.5|1||0||||||||||||1||||||||||||||||||||||“Testproduct|1124.0Testproduct|1124.0″
121212|||asas|1|||101||EUR|EUR|1KuAbw8||Johannes Neumann||21465|Reinbek||Borsigstrasse|24||||||00||||||Johannes Neumann||||||||||DE||2.5|1||0||||||||||||1||||||||||||||||||||||“Testproduct|1124.0Testproduct|1124.0″
Example 2
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 |
| Shipment Ref-No. | sender Ref. no. | sender remark | Mand. Ref. no. | proceedings | participation | cost center | product | service list | NN Currency | TV currency | Rec. Ref. no. | Rec. Name1 | Rec. Name2 | Rec. Name3 | Rec. PLZ | Rec. location | Rec. district | Rec. Street | Rec. Hausnr. | Rec. Tel | Rec. fax | POOL_REC_EMAIL | POOL_REC_DATEOFBIRTH | POOL_REC_CARD_NO | POOL_REC_TYPE_OF_CARD | POOL_REC_ID | POOL_REC_MINIMUM_AGE | POOL_REC_MA_LOCATION | POOL_REC_MA_DISTRICT | POOL_REC_MA_STREET | POOL_REC_SURNAME | POOL_REC_FIRST_NAME | POOL_REC_CONTRACT_ID | POOL_REC_CITICENSHIP | POOL_REC_ADDITIONAL_QUERY | POOL_REC_ANSWER | POOL_REC_IDP_CONF | Rec. Add.-Partner | Rec. remark | UST-IdNr. | Rec. country | POOL_REC_DISTRICT_OF_CUSTOMS | weight | number of shipments | customs type | POOL_WORKSTATION | POOL_CUSTOMS_MRNNUMBER | Advance Nat. | POOL_V_PREVIEW_NAT_TERM | undeliverability notice | POOL_AVISE | POOL_V_PREVIEW_INT | POOL_V_PREVIOUS_INT_TERM | POOL_V_PREVIOUS_INT_TRANSP | POOL_EPACK_AHEAD | POOL_IDENTEXPRESS | POOL_EXCHANGE_DIFFERENDERETADDR | POOL_EXCHANGE_EXCHANGE_TYPE | POOL_EXCHANGE_TEST_TYPE | POOL_EXCHANGE_PERFORMANCE_ATTR | POOL_SHIPMENT_ID | POOL_EXWORKS | POOL_CONTENTS | POOL_USAGE_PURPOSE | POOL_PREDATE | POOL_SHIPPMENTCONTENTDHL | POOL_INVOICETYPEDHL | POOL_INVOICENUMBERDHL | POOL_INVOICEDATEDHL | POOL_SIGNATORYDHL | POOL_CUSTOMSTARIFFDHL | POOL_INVOICEDHL | POOL_EXPORTTYPEDHL | POOL_EXPORTREASONDHL | POOL_INVOICEITEMSDHL | POOL_EXTRADATA | POOL_ADDITIONAL_1 | POOL_ADDITIONAL_2 | POOL_ADDITIONAL_3 | customs declaration |
| 121212 | asas | 1 | 101 | EUR | EUR | 1KuAbw8 | Johannes Neumann | 21465 | Reinbek | Borsigstrasse | 24 | 0 | Johannes Neumann | DE | 2.5 | 1 | 0 | 1 | Test product|1124.0Test product|1124.0 |