{
    "info": {
        "author": "Henrique Portela, SKisContent",
        "author_email": "henrique.portela@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Framework :: Django",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Natural Language :: English",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Programming Language :: Python :: 3",
            "Topic :: Software Development :: Libraries"
        ],
        "description": "# Django Excel Fixture\n\n[![Build Status](https://travis-ci.org/portela/django-excel-fixture.svg?branch=master)](https://travis-ci.org/portela/django-excel-fixture)\n\nDjango-excel-fixture is an easy way to import, export and test using .xlsx file.\n\n## Motivation\n\nExcel is a must in the corporate world. It is an easy to use and highly powerful application, currently being used by millions of users (maybe more than a billion user). Django-excel-fixture provides a way to import, export data using excel file (.xlsx); and also use it as test fixture.\n\n\n## Installation\n\nTo install it, simply:\n\n```console\n$ pip install django-excel-fixture\n```\n\nThen add it to your INSTALLED_APPS on your settings.py:\n\n```python\nINSTALLED_APPS = (\n    #...\n    'django_excel_fixture',\n)\n```\n\n## Usage\n\n\n### Exporting data from database:\n\nIf you already have some data in the database, to export it to a .xlsx file:\n\n```console\n$ python manage.py dumpdata --format xlsx --output myfilename.xlsx\n```\n\nIt is also possible to select a specific model:\n\n```console\n$ python manage.py dumpdata myapp1.MyModelName --format xlsx --output myfilename.xlsx\n```\n\n* If you leave out the **output** option, the table is dumped to stdout in CSV format.\n* There will be sheets only for table with data\n\n### Importing data into the database:\n\nTo manually load the data from the Excel file, use:\n\n```console\n$ python manage.py loaddata myfilename.xlsx\n```\n\n### Using as test fixture:\n\nTo use the fixture in a test, just add to the test class:\n\n```python\nclass MyTestCase(TestCase):\n    fixtures = ['myfilename.xlsx']\n\n    def ...\n```\n\n* No performance optimization has been made. Caution is advised.\n\n\n## Excel file format\n\n* Currently, it is only compatible with .xlxs format.\n* Every sheet is a model. The sheet title represents the model's identification.\n* Every column represents a field.\n* Every row represents a object (database entry).\n\n\n## Contribution\n\n```console\ngit clone git@github.com:SKisContent/django-excel-fixture.git\ncd django-excel-fixture\npython -m venv .venv\nsource .venv/scripts/activate\npip install -r requirements.txt\npython runtests.py\n```\n\nAuthors\n------\n\n* [Henrique Portela](https://github.com/portela)\n* [SKisContent](https://github.com/SKisContent)\n\nLicense\n=======\n\nThe MIT License.\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "http://github.com/portela/django-excel-fixture",
        "keywords": "",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "django-excel-fixture",
        "package_url": "https://pypi.org/project/django-excel-fixture/",
        "platform": "any",
        "project_url": "https://pypi.org/project/django-excel-fixture/",
        "project_urls": {
            "Homepage": "http://github.com/portela/django-excel-fixture"
        },
        "release_url": "https://pypi.org/project/django-excel-fixture/0.1/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Django: import data, export data and test using xlsx files.",
        "version": "0.1"
    },
    "last_serial": 5912419,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5d2612ab7cf96fa8c5ca49e0af2611a9",
                    "sha256": "3b68232ee3380241c7c07e148bc24f20d1cc02cfa321ecbcba935aa4e5000e0d"
                },
                "downloads": -1,
                "filename": "django_excel_fixture-0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "5d2612ab7cf96fa8c5ca49e0af2611a9",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 8201,
                "upload_time": "2019-10-01T13:50:53",
                "url": "https://files.pythonhosted.org/packages/82/5a/55f8821adabe65ecb2343ce95e115fa62ead3931183651b1f9c0bad37319/django_excel_fixture-0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4cb840454ecac15f5890e8ca0ef0aaf7",
                    "sha256": "1d47c2146b8e7ee7830a512dd807fc01cb0ec3f099d1a9a97f1869df2db1e95a"
                },
                "downloads": -1,
                "filename": "django-excel-fixture-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "4cb840454ecac15f5890e8ca0ef0aaf7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6644,
                "upload_time": "2019-10-01T13:50:56",
                "url": "https://files.pythonhosted.org/packages/2f/64/cbd080e3f5c58461d942d556fbcfa87188355ae12f8af1882e4f36cdc5f5/django-excel-fixture-0.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "5d2612ab7cf96fa8c5ca49e0af2611a9",
                "sha256": "3b68232ee3380241c7c07e148bc24f20d1cc02cfa321ecbcba935aa4e5000e0d"
            },
            "downloads": -1,
            "filename": "django_excel_fixture-0.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "5d2612ab7cf96fa8c5ca49e0af2611a9",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 8201,
            "upload_time": "2019-10-01T13:50:53",
            "url": "https://files.pythonhosted.org/packages/82/5a/55f8821adabe65ecb2343ce95e115fa62ead3931183651b1f9c0bad37319/django_excel_fixture-0.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "4cb840454ecac15f5890e8ca0ef0aaf7",
                "sha256": "1d47c2146b8e7ee7830a512dd807fc01cb0ec3f099d1a9a97f1869df2db1e95a"
            },
            "downloads": -1,
            "filename": "django-excel-fixture-0.1.tar.gz",
            "has_sig": false,
            "md5_digest": "4cb840454ecac15f5890e8ca0ef0aaf7",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 6644,
            "upload_time": "2019-10-01T13:50:56",
            "url": "https://files.pythonhosted.org/packages/2f/64/cbd080e3f5c58461d942d556fbcfa87188355ae12f8af1882e4f36cdc5f5/django-excel-fixture-0.1.tar.gz"
        }
    ]
}