Welcome to Django Excel Data Sync’s documentation!¶

Contents:

Django ExcelDataSync¶

It allows to create XLS file to import data into Django Model. The xls implement most of the validation rules of the django model fields, this prevent errors due the lack of constraints

Supported Fields¶

BigIntegerField BooleanField CharField DateField DateTimeField DecimalField EmailField FloatField ForeignKey GenericIPAddressField IntegerField NullBooleanField* PositiveIntegerField PositiveSmallIntegerField SmallIntegerField TextField TimeField URLField UUIDField

Supported Validations¶

unique max value min value max length min length

Documentation¶

The full documentation is at https://excel_data_sync.readthedocs.io.

Quickstart¶

Install ExcelDataSync:

pip install django-excel-data-sync

Add it to your INSTALLED_APPS:

INSTALLED_APPS = (
    ...
    'excel_data_sync.apps.XlsDataSyncConfig',
    ...
)

Add ExcelDataSync’s URL patterns:

from excel_data_sync import urls as excel_data_sync_urls


urlpatterns = [
    ...
    url(r'^', include(excel_data_sync_urls)),
    ...
]

Features¶

TODO

Running Tests¶

Does the code actually work?

source <YOURVIRTUALENV>/bin/activate
(myenv) $ pip install tox
(myenv) $ tox

Credits¶

Tools used in rendering this package:

Installation¶

At the command line:

$ easy_install django-excel-data-sync

Or, if you have virtualenvwrapper installed:

$ mkvirtualenv django-excel-data-sync
$ pip install django-excel-data-sync

Usage¶

To use Django Excel Data Sync in a project, add it to your INSTALLED_APPS:

INSTALLED_APPS = (
    ...
    'excel_data_sync.apps.XlsUploaderConfig',
    ...
)

Add Excel Data Sync’s URL patterns:

from excel_data_sync import urls as excel_data_sync_urls


urlpatterns = [
    ...
    url(r'^', include(excel_data_sync_urls)),
    ...
]

Contributing¶

Contributions are welcome, and they are greatly appreciated! Every little bit helps, and credit will always be given.

You can contribute in many ways:

Types of Contributions¶

Report Bugs¶

Report bugs at https://github.com/saxix/django-excel-datasync/issues.

If you are reporting a bug, please include:

Your operating system name and version.
Any details about your local setup that might be helpful in troubleshooting.
Detailed steps to reproduce the bug.

Fix Bugs¶

Look through the GitHub issues for bugs. Anything tagged with “bug” is open to whoever wants to implement it.

Implement Features¶

Look through the GitHub issues for features. Anything tagged with “feature” is open to whoever wants to implement it.

Write Documentation¶

ExcelDataSync could always use more documentation, whether as part of the official ExcelDataSync docs, in docstrings, or even on the web in blog posts, articles, and such.

Submit Feedback¶

The best way to send feedback is to file an issue at https://github.com/saxix/django-excel-datasync/issues.

If you are proposing a feature:

Explain in detail how it would work.
Keep the scope as narrow as possible, to make it easier to implement.
Remember that this is a volunteer-driven project, and that contributions are welcome :)

Get Started!¶

Ready to contribute? Here’s how to set up django-excel-datasync for local development.

Fork the django-excel-datasync repo on GitHub.

Clone your fork locally:

$ git clone git@github.com:your_name_here/django-excel-datasync.git

Install your local copy into a virtualenv. Assuming you have virtualenvwrapper installed, this is how you set up your fork for local development:
```
$ mkvirtualenv django-excel-datasync
$ cd django-excel-datasync/
$ python setup.py develop
```
Create a branch for local development:
```
$ git checkout -b name-of-your-bugfix-or-feature
```
Now you can make your changes locally.
When you’re done making changes, check that your changes pass flake8 and the tests, including testing other Python versions with tox:
```
$ flake8 src tests
$ python setup.py test
$ tox
```
To get flake8 and tox, just pip install them into your virtualenv.

Commit your changes and push your branch to GitHub:

$ git add .
$ git commit -m "Your detailed description of your changes."
$ git push origin name-of-your-bugfix-or-feature

Submit a pull request through the GitHub website.

Pull Request Guidelines¶

Before you submit a pull request, check that it meets these guidelines:

The pull request should include tests.
If the pull request adds functionality, the docs should be updated. Put your new functionality into a function with a docstring, and add the feature to the list in README.rst.
The pull request should work for Python 2.6, 2.7, and 3.3, and for PyPy. Check https://travis-ci.org/saxix/django-excel-datasync/pull_requests and make sure that the tests pass for all supported Python versions.

Tips¶

To run a subset of tests:

$ python -m unittest tests.test_xls_uploader

Credits¶

Development Lead¶

Stefano Apostolico <s.apostolico@gmail.com>

Contributors¶

None yet. Why not be the first?

History¶

0.1.0 (2016-12-13)¶

First release on PyPI.