Skip to main content

BeeBreed

BeeBreed is the reference system for genetic selection in Germany and German-speaking countries. BeePass recognizes 3 different BeeBreed export formats, each with its own dedicated parser.

BeeBreed Datenimport (111 columns)​

The Datenimport format is the full BeeBreed data export. Each row contains a queen's information and one coupled evaluation.

Marker columns​

BeePass detects this format when 5 or more columns are present among:

NST, L1A, LV1A, Z1A, NR1A, J1A, SANFT, WABEN, SCHWARM, GESAMT, BOMI1, BIMI1

Zuchtbuchnummer reconstruction​

The breeding book number is reconstructed from 5 columns:

L1A=DE, LV1A=44, Z1A=1, NR1A=3, J1A=2022
→ serial_number = "DE-44-1-3-2022"

The same logic applies for the dam (prefix 2A) and the drone sire group (prefix 4A).

Trait mapping​

BeeBreed columnBeePass fieldDescription
SANFTGentlenessScore 1-4
WABENComb sittingScore 1-4
SCHWARMNon-swarmingScore 1-4
GESAMTHoney (kg)Total production
ENTWICKVigorScore 1-4
WINTERWinteringScore 1-4
AUSRAUMHYG (cells)6h or 24h depending on AUSRAUMH
ANPAARTYPMating code1=INS, 2=BSF, 3=NAT
DROHNENSDI code1 drone = SDI

Additional columns (BOMI1, BIMI1, SMR, VSH...) are preserved in the origin_data JSON field.

BeeBreed Stockkarten (32 columns)​

Inspection cards (Stockkarten) contain multiple rows per queen: each row corresponds to one inspection. This is the only format where N rows = N evaluations for the same queen.

Detection​

BeePass detects this format when column 1A is present, along with at least 3 of these columns:

JST, DATUM, HONIG, SANFT, WABEN, SCHWARM, BOMI, BIMI, SMR, VSH

How it works​

  • Column 1A contains the full Zuchtbuchnummer (no reconstruction needed)
  • BeePass groups rows by Zuchtbuchnummer: 1 unique queen + N evaluations
  • The evaluation year is extracted from column JST or from the last segment of the Zuchtbuchnummer
  • Traits are the same as Datenimport (SANFT, WABEN, SCHWARM, HONIG...)

BeeBreed Zuchtwerte (33 columns)​

The Zuchtwerte export contains calculated breeding values (Zuchtwert) and their reliability (Sicherheit) for each trait.

Detection​

Column 1A present + 5 or more columns among:

GZW, ZWHO, SIHO, ZWAG, SIAG, ZWWS, SIWS, ZWSN, SISN, ZWVI, SIVI, ZWWF, SIWF, INZW, INZQ

Key columns​

ColumnDescription
GZWGesamtzuchtwert (total breeding value)
ZWHO / SIHOHoney: value / reliability
ZWAG / SIAGGentleness: value / reliability
ZWWS / SIWSComb sitting: value / reliability
ZWSN / SISNNon-swarming: value / reliability
INZW / INZQInbreeding coefficients

Imported data​

This format imports queens with their pedigree. Breeding values are stored as read-only data in the origin_data JSON field — they serve as reference but do not replace BeePass calculations.

Export from BeeBreed​

  1. Log in to beebreed.eu
  2. Navigate to the Datenexport section of your account
  3. Select the desired format (Datenimport, Stockkarten, or Zuchtwerte)
  4. Download the CSV file
Imported data by format

Datenimport and Stockkarten create queens + evaluations. Zuchtwerte imports queens with breeding values as reference data (read-only).

Recommended import order

If you have multiple BeeBreed files, import Datenimport first (queens + 1 evaluation), then Stockkarten (additional evaluations). Existing queens will be matched by their Zuchtbuchnummer.

See also​