It allows to create XLS file to import data into Django Model. The xls implements most of the validation rules of the django model fields, this prevent errors due the lack of constraints
- BigIntegerField
- BooleanField
- AutoField
- CharField
- DateField
- DateTimeField
- DecimalField
- EmailField
- FloatField
- ForeignKey
- GenericIPAddressField
- IntegerField
- NullBooleanField*
- PositiveIntegerField
- PositiveSmallIntegerField
- SmallIntegerField
- TextField
- TimeField
- URLField
- UUIDField
- choices
- unique
- max value (MaxValueValidator)
- min value (MinValueValidator)
- max length MaxLengthValidator)
- min length (MinLengthValidator)
The full documentation is at http://django-excel-data-sync.readthedocs.io/en/latest/
Install ExcelDataSync:
pip install django-excel-data-sync
Add it to your INSTALLED_APPS:
INSTALLED_APPS = (
...
'excel_data_sync.apps.XlsDataSyncConfig',
...
)
Does the code actually work?
source <YOURVIRTUALENV>/bin/activate (myenv) $ pip install tox (myenv) $ tox
Stable | |||||
Development | |||||
Project home page: | https://github.com/saxix/django-excel-data-sync | ||||
Issue tracker: | https://github.com/saxix/django-excel-data-sync/issues?sort | ||||
Download: | https://pypi.python.org/pypi/django-excel-data-sync/ | ||||
Documentation: | https://django-excel-data-sync.readthedocs.org/en/latest/ |