MOVED: Command line interface to yulqen/bcompiler-engine. Used by DfT to collect and clean data using Excel spreadsheets. https://git.sr.ht/~yulqen/datamaps
  • Python 99.8%
  • Nix 0.2%
Find a file
Repository files (latest commit first)
Filename Latest commit message Latest commit date
2025-01-19 15:58:20 +00:00
.github/workflows amended GH actions workflow file 2021-05-03 15:48:44 +01:00
datamaps Fix test and update pyproject file 2025-01-19 15:58:20 +00:00
.build.yml Adds working build manifest 2025-01-19 15:58:20 +00:00
.gitignore updated poetry lockfile and gitignore 2020-06-21 14:51:57 +01:00
BUILDING.md added deps and instructions for building with pyinstaller on windows 10 2020-05-17 16:18:29 +01:00
CHANGELOG.md updated repr() for Master associated with a month 2021-05-19 17:42:25 +01:00
cli.py multiprocessing fix 2019-09-28 15:06:04 +01:00
dm.spec fixes for actios 2021-05-03 16:27:23 +01:00
LICENSE.txt added MIT 2019-10-21 10:29:10 +01:00
mypy.ini added back the stuff I need to develop in vim 2019-10-02 20:23:33 +01:00
noxfile.py fixes for actios 2021-05-03 16:27:23 +01:00
poetry.lock added lock and shell.nix files 2023-03-25 17:35:29 +00:00
pyproject.toml Fix test and update pyproject file 2025-01-19 15:58:20 +00:00
pytest.ini housekeeping - adding some pytest config and other stuff 2022-06-21 22:55:39 +01:00
README.md updated README 2022-06-23 11:49:47 +01:00
requirements.txt updated dependency on bcompiler-engine to v1.1.5 2021-05-16 15:39:18 +01:00
requirements_dev.txt housekeeping - adding some pytest config and other stuff 2022-06-21 22:55:39 +01:00
shell.nix added lock and shell.nix files 2023-03-25 17:35:29 +00:00

Tests

Introduction

datamaps is a command line tool, written in Python, which facilitates the collection of data using Excel as the 'form'. It accepts that Excel files are freely distributable, easy to understand and already well integrated in the non-technical office environment.

The tool uses a concept a datamap, which is simple, user-created CSV file which maps cell references within Excel 'templates'. The datamap concept makes it easy to design pretty Excel spreadsheets with blank cells (the 'template') intended for the user to complete - the cell references in the datamap inform the datamaps program where it should expect to find user-entered data. At this point, the output is another master spreadsheet which contains all the data from each completed template compiled into a single table. This is then used by other tools for further analysis.

The documentation found at Datamaps - Twenty Four Software gives a more detailed explanation.

Installation

pip install datamaps

Bugs and issues

Please report bugs as Github issues.