DATEV export: customer names on your phone system
If your customers and suppliers are kept in DATEV, the phone system still does not know them. The usual way is an export of the master data as a file, which a service reads and uses to give the phone system the name for every call.
What matters for the export
- A file, not access to DATEV: export the debtors and creditors as a CSV file. What the export is called in your DATEV program and which columns it contains depends on the program, version and export settings.
- Always to the same place: write the export regularly under the same name into the same folder, e.g. on a file share. The reading service then picks up every new version without manual work.
- Phone numbers and names: the important columns are phone and mobile number, the company name or first and last name of the person and, for numbers without a country code, the country.
- Header line and character set: exports in the DATEV format start with a header line of their own (EXTF or DTVF) before the column names and are often saved in the ANSI character set.
With CallerHub: choose the file, map the columns
- Under Data sources, create a data source “CSV file” and enter the file, e.g.
\\fs01\export\debitoren.csv. - Open Map columns. CallerHub suggests a mapping based on the column names (phone, mobile, company, first/last name, country, account). It detects the separator, encoding (UTF-8 or ANSI) and the DATEV header line itself.
- Check the first rows and the result in the preview, then Save and apply.
Several phone columns are possible. The display name can have fallbacks: {Company} || {First name} {Last name} takes the company and, if it is empty, the name of the person. The account number can serve as the ID in a link to the record.

Example
"EXTF";700;16;"Debitoren/Kreditoren";… ← DATEV header line, skipped
"Konto";"Name (Adressatentyp Unternehmen)";"Name (Adressatentyp natürl. Person)";"Vorname (Adressatentyp natürl. Person)";"Land";"Telefon";"Mobil"
10001;"Müller und Söhne GmbH";"";"";"DE";"069 90009230";""
10002;"";"Schäfer";"Jürgen";"AT";"0316 0001234";"0664 0001234"
Result with the suggested mapping: 069 90009230 → “Müller und Söhne GmbH”, +43 664 0001234 → “Jürgen Schäfer”. The country code comes from the column Land (country); without a country, the configured code applies (e.g. 49). If a number occurs more than once, the first match in the file wins.
The example is reconstructed and has not been checked with a real DATEV export; check the preview in the dialog. CallerHub only reads the exported file and does not access DATEV itself.
On which phone system?
On any phone system CallerHub connects to: STARFACE through a module, 3CX through the CRM template, Asterisk and FreePBX via HTTP, desk phones through the LDAP phone book and the FRITZ!Box through the phone book export. Further sources such as Active Directory for colleagues can be added; the first source with a match provides the name.
The phone numbers are held only in CallerHub’s memory, not in a database and not in another file. When the CSV file changes, CallerHub reads it again.
Frequently asked questions
Does CallerHub access DATEV?
No. CallerHub only reads the exported CSV file. It needs neither access to DATEV nor an installation on the DATEV computer.
How up to date are the names?
As up to date as the export. CallerHub reads the file again whenever it changes; if the export is written to the same place regularly, CallerHub picks up the changes automatically.
What about umlauts and the DATEV character set?
With the encoding set to “Automatic”, CallerHub reads UTF-8 if the file is valid UTF-8, otherwise ANSI (Windows-1252), which is typical for DATEV and Excel. You can also set the encoding explicitly.
Does this work with the free basic edition?
Yes. The basic edition allows one data source and one interface, for example the DATEV export on a STARFACE.
Test it with your own data.
Try the full edition for 30 days: choose “Request trial …” in CallerHub and the trial key arrives by e-mail. The setup wizard guides you through data source, phone system and test lookup. After that, CallerHub continues as the free basic edition without losing settings or data.