Skip to content

clange/csv2orgclock

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Convert CSV to org-mode clock data

This program converts a CSV table containing clock logs (i.e., at what times = columns you worked on what task = rows) to the Org mode format for Emacs. This is convenient when you do not have access to your full Org mode setup, e.g., on a mobile device.

For subsequent processing, e.g., generating reports that can be further transcribed into official timesheets, I recommend following the clocktable-spreadsheet principle.

See here for a sample spreadsheet with a useful coloring setup. Exporting that to CSV creates an input file ready for this program.

Usage

The program requires the name of a CSV file as an argument. Thus, with sbt, you can run it like

sbt 'run Org.csv'

This will write to standard output. Once you are happy with the output, i.e., the program no longer throws errors, redirect the output to a *.org file. For technical reasons, you will need to manually strip a few lines of sbt output at the top and bottom of that file before processing it with Org mode.

The most convenient way of fixing errors (e.g., incomplete entries) is to repetitively run a command like this:

sbt 'run Org.csv' | tee output.org

General notes

This is a normal sbt project. You can compile code with sbt compile, run it with sbt run, and sbt console will start a Scala 3 REPL.

For more information on the sbt-dotty plugin, see the scala3-example-project.

About

Converting CSV clock logs to Org Mode

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages