data-wizard 1.0.0b2

Django Data Wizard

Django Data Wizard is a wq-powered web-based tool for mapping structured data (e.g. Excel, XML) into a highly normalized database structure via Django. The current implementation relies heavily on the ERAV implementation provided by vera, though there are plans to extend this to support any database structure (#3).

The unique feature of Django Data Wizard is that it allows novice users to map spreadsheet columns to database fields (and cell values to foreign keys) on-the-fly during the import process. This reduces the need for preset spreadsheet formats, which most data import solutions require.

Django Data Wizard supports any format supported by wq.io. Additional formats can be integrating by creating a custom wq.io class and then registering it with the wizard. For example, the Climata Viewer uses Django Data Wizard to import data from climata’s wq.io-based data loaders.

Note: Django Data Wizard was formerly known as the dbio contrib module in wq.db. The implementation has been extracted from wq.db and renamed to avoid confusion with other similar libraries.

Getting Started

pip3 install data-wizard

Django Data Wizard is an extension to wq.db, the database component of the wq framework. See https://github.com/wq/django-data-wizard to report any issues.

Examples