Skip to content

This repository contains a script to extract data from a tab-delimited text file and load it into a SQLite database. The script handles data validation and cleaning, and includes a command line interface for specifying input and output files. Requires Python 3 and the sqlite3 library.

Notifications You must be signed in to change notification settings

edeniyanda/Python-Text-File-Importer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Python-Text-File-Importer

This repository contains a script to extract data from a tab-delimited text file and load it into a SQLite database. The script handles data validation and cleaning, and includes a command line interface for specifying input and output files.

Requirements

  1. Python 3

  2. sqlite3 library

Usage

To run the script, use the following command:

python3 Python-Text-File-Importer.py

Notes

The input file must be a tab-delimited text file with a header row.

The output database file will be created if it does not exist, or overwritten if it does.

Any errors or warnings encountered during the import process will be logged to the console.

Contributing

I do welcome contributions to this project! If you have an idea for how to improve the code, please open an issue or submit a pull request.

To contribute:

  1. Fork the repository
  2. Create a new branch for your changes
  3. Make your changes and commit them
  4. Push the branch to your fork
  5. Open a pull request

Before submitting a pull request, please make sure to run the test suite and ensure that all tests are passing.

Thank you for considering contributing to this project!

About

This repository contains a script to extract data from a tab-delimited text file and load it into a SQLite database. The script handles data validation and cleaning, and includes a command line interface for specifying input and output files. Requires Python 3 and the sqlite3 library.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages