Convert MARC files to Excel spreadsheets and vice-versa.
Project description
Convert MARC files to Excel spreadsheets and vice-versa.
Installation
From PyPI:
pip install marc2excel
From GitHub:
git clone https://github.com/alexandermendes/marc2excel cd marc2excel python setup.py install
Usage
Running scripts:
The following scripts can be run from anywhere, once the package is installed.
Converting MARC to Excel:
Usage: marc2excel_cli.py [OPTIONS] SOURCE_PATH SAVE_PATH Convert MARC (.mrc, .marc) to Excel (.xlsx) Options: -d Specify directories for SOURCE_PATH and SAVE_PATH. --utf8 Force records to be decoded as UTF-8. --silent Don't display progress. --help Show this message and exit.
Converting Excel to MARC:
Usage: excel2marc_cli.py [OPTIONS] SOURCE_PATH SAVE_PATH Convert Excel (.xlsx) to MARC (.mrc) Options: -s, --sheet INTEGER Index of the sheet from which to extract data. -d Specify directories for SOURCE_PATH and SAVE_PATH. --utf8 Force records to be encoded as UTF-8. --silent Don't display progress. --help Show this message and exit.
Running from Python:
Converting MARC to Excel:
import marc2excel
marc2excel.marc2excel('path/to/file.mrc', 'path/to/save/file.xls')Converting Excel to MARC:
import marc2excel
marc2excel.excel2marc('path/to/file.xls', 'path/to/save/file.mrc')Spreadsheet guidelines
Spreadsheets require a header row that must adhere to the following guidelines:
The field tag is required for all fields.
For non-control fields, the indicator and subfield tags are also required.
Backslashes should be used to indicate blank spaces in indicators.
Subfields should be prepended with a dollar symbol.
Leaders can be added from a column with the heading LDR (optional).
Repeated fields can be created by appending headers with [number].
Example:
001 |
245 \\ $a |
852 \1 $j |
852 \1 $j [2] |
|---|---|---|---|
123 |
some_value |
another_value |
another_value |
Testing
Tests can be run using:
python setup.py test
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
