Convert fixed width files from Brower sports timers into CSV files appropriate for upload to google docs spreadsheets.

Steinar Bang 54f612220d Spelling correction: Browser -> Brower 10 years ago
.gitignore 2b90458b14 Ignore Brower-generated .txt files and script generated .csv files. 11 years ago
Makefile eb1dda4337 Corrected Makefile header comment. 11 years ago
README.org 54f612220d Spelling correction: Browser -> Brower 10 years ago
combine_user_and_time.pl 849377f9fb Use sort to always get the skiers in the same order. 11 years ago

README.org

Introduction

The perl script in this repository converts fixed width files from Brower timers into CSV files appropriate for upload into google docs spreadsheets.

Preconditions

    The script has been developed on [[https://www.debian.org/][debian]], but should be able to run on any command line with the following programs in the PATH:
  • GNU make
  • perl

GNU make from GnuWin32 and Strawberry Perl should be enough to run this script on Windows systems.

Doing conversion

The steps for doing a conversion, are:

  • Copy the .txt file exported from the Brower clock into the
  • directory containing the script
  • Open a command line window on the directory containing the script
  • (and the .txt file), and give the command:

      make
      
    1. Create a new spreadsheet on Google docs
    2. In the spreadsheet, choose File->Import
    3. In "Import File":
    4. Click on "Choose..." and browse to the .csv file
    5. Select "Replace spreadsheet"
    6. Click on the "Import" button