Library for reading legacy DBF file with library data
Project description
Skoufas Library DBF Reader
Functions to read and convert from the DBF file used to track books in the Skoufas library
Columns in DBF file
Column | Name (english) | Name (Greek) |
---|---|---|
A01 | Author surname, name, language | ΕΠΩΝΥΜΟ,ΟΝΟΜΑ ΣΥΓΓΡΑΦΕΑ |
A02 | title | Τιτλος |
A03 | subtitle | Υποτιτλος |
A04 | Dewey | Ταξινομικος αριθμος |
A05 | entry_number | αριθμος εισαγωγης |
A06 | translator, edition, entry_number | μεταφραστης, εκδοση, αριθμος εισαγωγης |
A07 | edition | εκδοση |
A08 | editor | εκδοτης |
A09 | edition place | τοπος εκδοσης |
A10 | edition date | ετος εκδοσης |
A11 | pages | σελιδες |
A12 | topics | θεμα 1 |
A13 | topics | θεμα 2 |
A14 | topics | θεμα 3 |
A15 | topics | θεμα 4 |
A16 | curator | επιμελητης |
A17 | notes | σημειωσεις (συνηθως αν είναι δωρεες) |
A18 | material | συνοδευτικο υλικο |
A19 | isbn | |
A20 | Notes | σημειωσεις |
A21 | series | Σειρα |
A22 | θεσεις κλειδια | |
A23 | θεσεις κλειδια | |
A24 | θεσεις κλειδια | |
A25 | θεσεις κλειδια | |
A26 | θεσεις κλειδια | |
A27 | θεσεις κλειδια | |
A28 | θεσεις κλειδια | |
A29 | θεσεις κλειδια | |
A30 | θεσεις κλειδια |
Checks required
- Duplicated Entry Numbers (~800)
- Non-numeric entry numbers (~130)
- Missing entry numbers (~200)
- Weird author names
- 12760EZ,GABRIEL GARCIA
- 15767ΗΓΟΠΟΥΛΟΣ,ΧΡΗΣΤΟΣ
- Weird deweys and replacements (~300)
- Loan -> Book Entry or Entry number?
- Translator corrections
Columns required
BookEntry
- Title
- Subtitle
- DeclaredAuthors
- Dewey
- Edition
- EditionDate
- EditorId (FK: Editor)
- CuratorId (FK: Curator)
- Pages
- PagesText
- Volumes
- Notes
- Material
- HasCD
- HasDVD
- ISBN
Author
- Name
- Surname
- Middlename
- Fullname
Authorship (Many-to-Many)
- AuthorId (FK: Author)
- BookEntryId (FK: BookEntry)
Translator
- Name
- Surname
- Middlename
- Fullname
Curator
- Name
- Surname
- Middlename
- Fullname
Editor
- Name
- Place
Translation
- TranslatorId (FK: Translator)
- BookEntryId (FK: BookEntry)
Entry Numbers (one-to-many)
- Number (unique)
- BookEntryId (FK: BookEntry)
Topic
- Name
BookInTopic (many-to-many)
- TopicId (FK: Topic)
- BookEntryId (FK: BookEntry)
Donor
- Name
- Surname
- Middlename
- Fullname
Donation (Many-to-Many)
- DonorId (FK: Donor)
- BookEntryId (FK: BookEntry)
Customer
- Name
- Surname
- Middlename
- FullName
- IdNumber
- IdType
- PhoneNumber
Loan
- CustomerId (FK: Customer)
- BookEntryId (FK: BookEntry)
- StartDateTime
- EndDateTime
- Note
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for skoufas-dbf-reader-0.0.1rc40.post1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5a2e46ce25274cefa72551b4324ab9d16f030bcd457722e21e4d7d472d37460a |
|
MD5 | 87fabe65538e3b2a7aeac0e7029d4dd8 |
|
BLAKE2b-256 | 235cf21dfd37ab46b55d1435f4c755ca2f47cf95aa52a08d931fdfa60c15b73b |
Close
Hashes for skoufas_dbf_reader-0.0.1rc40.post1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | abf57b2e0de7a1ec7f03d3b2cc73286637f4886f7094dfc6d6a2e5ad9421bf8e |
|
MD5 | 10662a4722284448b8ca7676a6a32a7d |
|
BLAKE2b-256 | 8838a45281bb62f321571f82256da1131a561d1e00e11db5ddd66ff9df4462ab |