Skip to main content

Utility to ease reading data from tabular data files

Project description

Tab Import is a Python utility to ease imports of tabular data from CSV, ODF, XLS or XLSX files.

Some formats require an external Python library:

  • ODF: ooolib

  • XLS/XLSX: xlrd

This library is meant to be used inside a Django project context.

Usage:

#!/usr/bin/env python

import tabimport

smart_file = tabimport.FileFactory(file_path)
for data_line in smart_file:
    do_something_with(data_line['header'])

Import helper

To use the Django import helper in your Django project, follow the steps below.

  1. Add ‘tabimport’ into your INSTALLED_APPS setting.

  2. Include the urls of tabimport into your urls:

    url(r'^data-import/', include('tabimport.urls')),
  3. In any of your models for which you’d like to enable data import, set a class variable like this: support_tabimport = True.

  4. You can then link to the tabimport utility from one of your templates by reversing a url with tabimport:

    <a href="{% url 'tabimport' %}">Import utility</a>

Alternatively, your models can include a class method which will receive the imported data as a dictionary just before they are used to create a new instance. This allows you to handle special cases in imported data:

@classmethod
def prepare_import(cls, values):
    return values

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

TabImport-0.5.0.tar.gz (8.9 kB view details)

Uploaded Source

File details

Details for the file TabImport-0.5.0.tar.gz.

File metadata

  • Download URL: TabImport-0.5.0.tar.gz
  • Upload date:
  • Size: 8.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.2

File hashes

Hashes for TabImport-0.5.0.tar.gz
Algorithm Hash digest
SHA256 a69d936f6a0d6d628f7d244e7f183792de0a7a9be9af6b69102ac2da581f620b
MD5 2a470e93de791eb95c2a8e43955c2ac9
BLAKE2b-256 4661a01865071c592f03e2de3e0c2401d48f19f2e9bcb831b0ea14d74fa9db68

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page