Skip to content
/ Conjuror Public

An experiment in the CSV format, open data, magic, and wizardly things!

License

Notifications You must be signed in to change notification settings

bnvk/Conjuror

Repository files navigation

The Magical Conjuror

NPM

Conjuror

Conjuror is magical wizard who knows how to do cool things with CSV data and dons an epic beard- kind of like Santa Claus, sans the whole naughty or nice bit. Conjuror is based on Data Packages, which are a nifty way to wrap simple CSV data in JSON, and was created by the OKFN.

Getting Started

  1. First install Conjuror npm install -g conjuror
  2. Then set it up by running setup script conjuror setup
  3. To use Conjuror to you will need to make copies of the following two data files:
  • data/_template.csv
  • data/_template.json

Rename these files something like clients.csv or receipts.csv or whatever suits your needs add modify the values of the JSON schema & CSV columns as you see it. Once the schema & CSV matches, you can start adding data items to the CSV such as:

date, time, description, client, location, rate
2015-02-07, 2, improved importing of files, conjuror, cafe, 0.00
2015-02-08, 2, updated commands & documentation, mailpile, home, 0.00

You can manually add items to the CSV, or you can use the rough implemenation of the time tracker tool by running a separate script called ctrack read more about this below.

Conjuror Commands

  • conjuror - shows a help screen with following commands
  • conjuror setup - setups up Conjuror on a new machine
  • conjuror view - renders filtered data to CLI for quick checks
  • conjuror track - add a new entry to an existing project
  • conjuror output - output a filtered report as PDF, HTML, and CSV

Flags (BROKEN AT THE MOMENT)

Normally the conjuror command should accept flags to be run as a normal shell command, but I broke that recently!

Flag Short Flag Behavior
--help -h shows list of commands
--input -i selects data.json schema file to open up
--formats -f allows you to choose different output formats (cli, csv, html, pdf)
--output -o specify Name of File to be output
--date -d filters by numerous date styles 'February, Feb, 02 read below
--search -s searches for a string like magic contained within a longer string I love doing magic tricks
--trim -t filters by an item like 'client' (currently hardcoded value)
--price -p Override the calculated price with a fixed price
--currency -c what currency the thing is in
--extra -e Text that appears in extra field of template (overrides field in config).
--details -l Affects visibility of the data_details field in a template (show, hide)
--message -m Shows up as a data_message in a template
--generated -g Allows specifying custom invoice date

Run either of the follow two examples from terminal command line

Example (trim)

node conjuror.js --input data/clients.json --trim client-name

This command should have printed data to your command line that matches your trim parameter.

Example (output & date)

node conjuror.js -i data/clients.json -o "Feb Invoice" -t client-name --date=Feb

The following examples are formats of dates values you can pass using the --date flag

  • Month - February or Feb or 02 which picks month of current year
  • Exact - 2015-09-04 gets all values since date
  • Range - 2015-09-04:to:2015-11-15 selects between two exact values

The above example should have outputted an HTML rendering of your the entries parsed from your data. The output will be located in output/Feb Invoice.html

Note: regarding PDF export

To generate PDF outputs, you need to install wkhtmltopdf for your operating system on Debian that is done with sudo apt-get install wkhtmltopdf

Why The Magical Name & Terminology?

Well, there is that quote by Asimov about technology... there is also the Cyber Wizard Institute which you should check out... and I really wanted to use this icon of a magical bearded wizard.

Made in Berlin

About

An experiment in the CSV format, open data, magic, and wizardly things!

Resources

License

Stars

Watchers

Forks

Packages

No packages published