Skip to main content

Cross-platform self-contained CLI to convert ABET and MDB databases into SQLite, SQL, CSV, and XLSX.

Project description

ABET CONVERTER

ABET CONVERTER is a cross-platform command-line interface (CLI) tool for exporting data from Lafayette Instrument's ABET (Animal Behavior Environment Test) software — used to program and run behavioral experiments. Converts .ABETdb and .mdb database files into easier formats:

  • SQLite
  • SQL
  • CSV
  • XLSX

You do not need to install mdbtools yourself. ABET CONVERTER includes the needed runtime files and chooses the correct one automatically for Windows, macOS, or Linux.

What This Tool Does

Use this tool when you have an .ABETdb or .mdb file and want a file that is easier to open, inspect, or share.

For example, you can turn:

input.ABETdb

into:

input.sqlite

Install Python

You need Python 3.11 or newer.

Download Python here:

https://www.python.org/downloads/

During Python installation on Windows, enable:

Add python.exe to PATH

Install ABET Converter

Open a terminal.

On Windows, open PowerShell.

On macOS or Linux, open Terminal.

Run:

python -m pip install abet-converter

ABET CONVERTER is installed from PyPI, the official Python package website.

You do not need to choose a Windows, macOS, or Linux installer. The same Python package works on all supported systems. When you run the command, ABET CONVERTER detects your system and uses the correct bundled runtime:

  • Windows: vendor/mdbtools/windows/...
  • macOS: vendor/mdbtools/macos/...
  • Linux: vendor/mdbtools/linux/...

Check That It Works

Run:

abet-converter --help

If you see help text, the installation worked.

If your terminal says abet-converter is not recognized or not found, the Python script directory is probably not on your PATH. Run:

python -m abet_converter doctor

To add the script directory to your user PATH, run:

python -m abet_converter path --add

Then open a new terminal and check again:

abet-converter --help

This explicit repair step is needed because Python wheels installed from PyPI cannot safely edit your system PATH during pip install.

Convert One File

This example converts one ABET database into one SQLite file:

abet-converter --input input.ABETdb --output input.sqlite

You can replace input.ABETdb with the path to your own file.

Convert A Folder

This example converts all supported files in a folder:

abet-converter --input incoming-folder --output converted-folder --recursive

Export Other Formats

SQLite is the default format.

To export CSV files:

abet-converter --input input.ABETdb --output output-folder --format csv

To export several formats at once:

abet-converter --input input.ABETdb --output output-folder --format sqlite --format csv --format xlsx

Large XLSX Files

Excel has a row limit for each sheet.

If a database table is too large for one Excel sheet, ABET CONVERTER automatically splits that table into more sheets.

For example:

tbl_Data
tbl_Data_2
tbl_Data_3

This keeps all rows instead of silently dropping data.

Windows Notes

If this command does not work:

python -m pip install abet-converter

try:

py -m pip install abet-converter

Then check:

abet-converter --help

Windows users do not need to install extra database tools.

macOS Notes

If this command does not work:

python -m pip install abet-converter

try:

python3 -m pip install abet-converter

Then check:

abet-converter --help

macOS users do not need to install extra database tools.

Linux Notes

If this command does not work:

python -m pip install abet-converter

try:

python3 -m pip install abet-converter

Then check:

abet-converter --help

Linux users do not need to install extra database tools on supported architectures.

What Is A Coding Agent?

A coding agent is an AI tool that can help with a software project.

It can read files, explain code, run commands, edit files, run tests, and help fix errors.

You can use a coding agent even if you are not a programmer. You can ask it to do practical tasks in plain language.

Using A Coding Agent To Install Or Modify This Project

You can ask a coding agent things like:

Install this project on my computer.
Run the tests and explain any failure.
Convert this ABETdb file to SQLite.
Add a new output format.

If you want to work on the project itself, ask the agent to clone the repository, install it, run the tests, and explain the files before making changes.

Project Links

  • GitHub: https://github.com/vcanonici/abet-converter
  • PyPI: https://pypi.org/project/abet-converter/

Citation

If you use ABET CONVERTER in research, please cite the repository.

@software{canonici_abet_converter_2026,
  author = {Canonici, Vinicius Garcia and Pinto, Carlos},
  title = {ABET CONVERTER},
  year = {2026},
  version = {0.3.5},
  url = {https://github.com/vcanonici/abet-converter},
  note = {Cross-platform CLI to convert ABET and MDB databases into SQLite, SQL, CSV, and XLSX}
}

License

GNU GPL v3 or later

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

abet_converter-0.3.5.tar.gz (2.7 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

abet_converter-0.3.5-py3-none-any.whl (2.7 MB view details)

Uploaded Python 3

File details

Details for the file abet_converter-0.3.5.tar.gz.

File metadata

  • Download URL: abet_converter-0.3.5.tar.gz
  • Upload date:
  • Size: 2.7 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for abet_converter-0.3.5.tar.gz
Algorithm Hash digest
SHA256 f79ad5ff9ac86866a96b14d4a02e2788fa5b421938fa73305484ba5a45b80cb7
MD5 f7e7deb717ca39a68e5ceeec9a988d4c
BLAKE2b-256 b679a4cf0cd27907f28e328ec8fff61579cacd040eccf7529f57034f6df2b716

See more details on using hashes here.

Provenance

The following attestation bundles were made for abet_converter-0.3.5.tar.gz:

Publisher: release.yml on vcanonici/abet-converter

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file abet_converter-0.3.5-py3-none-any.whl.

File metadata

  • Download URL: abet_converter-0.3.5-py3-none-any.whl
  • Upload date:
  • Size: 2.7 MB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for abet_converter-0.3.5-py3-none-any.whl
Algorithm Hash digest
SHA256 69323b9f2c0b568dfc727b6f66a05d6f127c50f6979061473e4066da16d787a0
MD5 f52a83f1fdeadb55b55cd692be236ecd
BLAKE2b-256 97cfc3b47929df39b0f72058537e595003bc798537a38c266b863ff19f93e831

See more details on using hashes here.

Provenance

The following attestation bundles were made for abet_converter-0.3.5-py3-none-any.whl:

Publisher: release.yml on vcanonici/abet-converter

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

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