How-to
Downloading the Yearly ISBN Report
Downloading the ISBN requests, numbers, Ministry dates and the legal deposit steps of each printing for a chosen year as an Excel workbook.
The yearly report gives the ISBN requests and legal deposit (derleme) steps of a year in one Excel workbook.
- On the Yearly report (Excel) card at the side of the Editorial → ISBN & legal deposit screen, select the year in the Year list.
- Press the download button of the card. The label of the button includes the year you selected.
The report contains the requests that were not cancelled. A request is in the report when it was opened or given a number in the selected year, or when one of its printings was printed in that year. Each printing is a separate row and appears in the report of the year it was printed. A reprint of a book whose request was opened in an earlier year is therefore in the report of the year of the reprint. A printing without a print date appears in the report of the year the request was opened or given its number. A request with no printing in the year is a single row, with the printing columns empty. The columns are as follows.
| Column | Content |
|---|---|
| ISBN, Eser adı, Biçim, Baskı, Durum | The details of the request (title, form, edition, status) |
| Başvuru no, Başvuru tarihi, ISBN tarihi | The steps at the Ministry of Culture and Tourism (application number, application date, ISBN date) |
| Basım no, Basım tarihi, Bandrol | The details of the printing (printing number, print date, bandrol) |
| Derleme gönderildi, EYDeS, Ajans nüshası, Derleme tamam | The dates of the legal deposit steps (copies sent, EYDeS, agency copy, deposit complete) |
Cells whose value starts with =, +, - or @ are written as text and do not work as formulas in Excel.