{ "info": { "author": "Alexander Mendes", "author_email": "alexanderhmendes@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Programming Language :: Python" ], "description": "marc2excel\n==========\n\n|travis| |coveralls| |pypi|\n\nConvert MARC files to Excel spreadsheets and vice-versa.\n\n\nInstallation\n------------\n\nFrom PyPI:\n\n::\n\n pip install marc2excel\n\nFrom GitHub:\n\n::\n\n git clone https://github.com/alexandermendes/marc2excel\n cd marc2excel\n python setup.py install\n\n\nUsage\n-----\n\nRunning scripts:\n~~~~~~~~~~~~~~~~\n\nThe following scripts can be run from anywhere, once the package is\ninstalled.\n\nConverting MARC to Excel:\n\n::\n\n Usage: marc2excel_cli.py [OPTIONS] MARC_PATH\n\n Convert MARC_PATH to an Excel spreadsheet.\n\n The path to the saved spreadsheet will be the same as MARC_PATH but with a\n .xlsx extension.\n\n If a directory is specified for MARC_PATH all files found in that\n directory with .mrc, .marc or .lex extensions will be converted and the\n .xlsx versions saved in the same directory.\n\n The option to force utf-8 encoding is included to help deal with any\n poorly formed MARC records that you might encounter. For example, those\n that are utf-8 encoded but without the leader set appropriately, or those\n that contain mostly utf-8 data but with a few non-utf-8 characters (any\n non-utf-8 characters will be replaced with the official U+FFFD REPLACEMENT\n CHARACTER).\n\n Options:\n -d Specify a directory for MARC_PATH.\n --silent Don't display progress.\n --utf8 Force utf-8 encoding.\n --help Show this message and exit.\n\n\nConverting Excel to MARC:\n\n::\n\n Usage: excel2marc_cli.py [OPTIONS] EXCEL_PATH\n\n Convert EXCEL_PATH to an MARC file.\n\n The path to the saved MARC file will be the same as EXCEL_PATH but with a\n .mrc extension.\n\n If a directory is specified for EXCEL_PATH all files found in that\n directory with .xlsx extensions will be converted and the .mrc versions\n saved in the same directory.\n\n The option to force utf-8 encoding is included to help deal with any\n poorly formed data found in the spreadsheet. For example, where rows\n contain data that is utf-8 encoded but without the leader set\n appropriately, or rows that contain mostly utf-8 data but with a few non-\n utf-8 characters (any non-utf-8 characters will be replaced with the\n official U+FFFD REPLACEMENT CHARACTER).\n\n Options:\n -d Specify a directory for EXCEL_PATH.\n --silent Don't display progress.\n --utf8 Force utf-8 encoding.\n --help Show this message and exit.\n\n\nRunning from Python:\n~~~~~~~~~~~~~~~~~~~~\n\nConverting MARC to Excel:\n\n.. code-block:: python\n\n import marc2excel\n marc2excel.marc2excel('path/to/file.mrc', 'path/to/save/file.xls')\n\nConverting Excel to MARC:\n\n.. code-block:: python\n\n import marc2excel\n marc2excel.excel2marc('path/to/file.xls', 'path/to/save/file.mrc')\n\n\nSpreadsheet guidelines\n----------------------\n\nSpreadsheets require a header row that must adhere to the following\nguidelines:\n\n- The field tag is required for all fields.\n- For non-control fields, the indicator and subfield tags are also\n required.\n- Backslashes should be used to indicate blank spaces in indicators.\n- Subfields should be prepended with a dollar symbol.\n- Leaders can be added from a column with the heading LDR (optional).\n- Repeated fields can be created by appending headers with [*number*].\n\n**Example:**\n\n+-------+---------------+------------------+------------------+\n| 001 | 245 \\\\\\\\ $a | 852 \\\\1 $j | 852 \\\\1 $j [2] |\n+=======+===============+==================+==================+\n| 123 | some\\_value | another\\_value | another\\_value |\n+-------+---------------+------------------+------------------+\n\n\nTesting\n-------\n\nTests can be run using:\n\n::\n\n python setup.py test\n\n.. |travis| image:: https://travis-ci.org/alexandermendes/marc2excel.svg?branch=master\n :target: https://travis-ci.org/alexandermendes/marc2excel\n :alt: Test success\n.. |coveralls| image:: https://coveralls.io/repos/github/alexandermendes/marc2excel/badge.svg?branch=master\n :target: https://coveralls.io/github/alexandermendes/marc2excel?branch=master\n :alt: Test coverage\n.. |pypi| image:: https://img.shields.io/pypi/v/marc2excel.svg?label=latest%20version\n :target: https://pypi.python.org/pypi/marc2excel\n :alt: Latest version released on PyPi", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/alexandermendes/marc2excel", "keywords": "", "license": "BSD", "maintainer": "", "maintainer_email": "", "name": "marc2excel", "package_url": "https://pypi.org/project/marc2excel/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/marc2excel/", "project_urls": { "Homepage": "https://github.com/alexandermendes/marc2excel" }, "release_url": "https://pypi.org/project/marc2excel/1.2.1/", "requires_dist": null, "requires_python": "", "summary": "Convert MARC files to Excel spreadsheets and vice-versa.", "version": "1.2.1" }, "last_serial": 2355594, "releases": { "0.1.0": [], "0.1.1": [ { "comment_text": "", "digests": { "md5": "265b19a68d436b79a2316db7d15e921e", "sha256": "b1e47c6527e33b8acde4ca26a7c60617bc727835d6189d0498f40519a0011288" }, "downloads": -1, "filename": "marc2excel-0.1.1.tar.gz", "has_sig": false, "md5_digest": "265b19a68d436b79a2316db7d15e921e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5929, "upload_time": "2016-05-20T13:30:46", "url": "https://files.pythonhosted.org/packages/9c/59/a1b2d46505339d92d8bb60d8c96bd1333f9ced8d5710a9bdd705a7802fe7/marc2excel-0.1.1.tar.gz" } ], "1.0.0": [ { "comment_text": "", "digests": { "md5": "f923b2302bd1431b1d0ebed6d5dd5c6e", "sha256": "9d411eed439e12f53c68a6e5ed6fd8708e1def20e6599e8394f48549b170ecbd" }, "downloads": -1, "filename": "marc2excel-1.0.0.tar.gz", "has_sig": false, "md5_digest": "f923b2302bd1431b1d0ebed6d5dd5c6e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6151, "upload_time": "2016-09-21T14:53:03", "url": "https://files.pythonhosted.org/packages/74/af/2f5fc4cd6097b2aa11cc277688ff9eda64c4e0de9ecc8b58a9334a3caa48/marc2excel-1.0.0.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "44dda8fe110c71dd5bf77893137d806f", "sha256": "2289af907b5042a2efdfcdbdc78eefcc76e59c3d4e0165bc792bf6268bf834de" }, "downloads": -1, "filename": "marc2excel-1.1.0.tar.gz", "has_sig": false, "md5_digest": "44dda8fe110c71dd5bf77893137d806f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6118, "upload_time": "2016-09-21T15:29:37", "url": "https://files.pythonhosted.org/packages/92/c2/6d971692e8b8a011adb087431aa5dcb62e6be04ed8094374240cd479eb43/marc2excel-1.1.0.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "35b9626d8936499deab45b7d0346ef1d", "sha256": "716b48d0b8cde66ac706d486b935339e138247d213b4923be3a6137d78e7e125" }, "downloads": -1, "filename": "marc2excel-1.2.0.tar.gz", "has_sig": false, "md5_digest": "35b9626d8936499deab45b7d0346ef1d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6572, "upload_time": "2016-09-21T16:11:44", "url": "https://files.pythonhosted.org/packages/d3/6f/f0837b5114b507fb9ff3dda9a87c88799c5d773a73abcddaee39c4d27dcd/marc2excel-1.2.0.tar.gz" } ], "1.2.1": [ { "comment_text": "", "digests": { "md5": "39df2057c73278913cf199265387c825", "sha256": "7ee5969a8feaacf8f6b6b2abb2ebc853c8d8933b8c23687b9a89ad4741242eb0" }, "downloads": -1, "filename": "marc2excel-1.2.1.tar.gz", "has_sig": false, "md5_digest": "39df2057c73278913cf199265387c825", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6668, "upload_time": "2016-09-21T17:24:52", "url": "https://files.pythonhosted.org/packages/03/99/baecdaeb8c6268faa56678fa2fddf6dc76302ef4e06117a8f86331e9c84e/marc2excel-1.2.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "39df2057c73278913cf199265387c825", "sha256": "7ee5969a8feaacf8f6b6b2abb2ebc853c8d8933b8c23687b9a89ad4741242eb0" }, "downloads": -1, "filename": "marc2excel-1.2.1.tar.gz", "has_sig": false, "md5_digest": "39df2057c73278913cf199265387c825", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6668, "upload_time": "2016-09-21T17:24:52", "url": "https://files.pythonhosted.org/packages/03/99/baecdaeb8c6268faa56678fa2fddf6dc76302ef4e06117a8f86331e9c84e/marc2excel-1.2.1.tar.gz" } ] }