marc2excel 0.1.0

Convert MARC files to Excel spreadsheets and vice-versa.

marc2excel
==========

[|Build Status|] (https://travis-ci.org/alexandermendes/marc2excel)
[|Coverage Status|] (https://coveralls.io/github/alexandermendes/marc2excel?branch=master)

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:

.. code:: python

import marc2excel
marc2excel.marc2excel('path/to/file.mrc', 'path/to/save/file.xls')

Converting Excel to MARC:

.. code:: python

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 :raw-latex:`\1` $j | 852 :raw-latex:`\1` $j [2] |
+=======+===============+==========================+==============================+
| 123 | some\_value | another\_value | another\_value |
+-------+---------------+--------------------------+------------------------------+

Testing
-------

Tests can be run using:

::

python setup.py test

.. |Build Status| image:: https://travis-ci.org/alexandermendes/marc2excel.svg?branch=master
.. |Coverage Status| image:: https://coveralls.io/repos/github/alexandermendes/marc2excel/badge.svg?branch=master