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 年 前
.gitignore 2b90458b14 Ignore Brower-generated .txt files and script generated .csv files. 11 年 前
Makefile eb1dda4337 Corrected Makefile header comment. 11 年 前
README.org 54f612220d Spelling correction: Browser -> Brower 10 年 前
combine_user_and_time.pl 849377f9fb Use sort to always get the skiers in the same order. 11 年 前

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