Csv2Agn V1.0

This utility converts the CSV file generated by Microsoft Project to a Psion 3a agenda file.

Microsoft project will export various entities with a project as a comma separated variable file.  This utility processes the tasks export.

The file is of the following format

Variable	Description
1		Task number
2		Task Description
3		Duration
4		Start Date
5		End Date
6		always null
7		Resource name

This utility will create an agenda file of the same name in the same directory as the CSV file.  It will contain an entry for each record unless the record ends before the current month.  All entries are converted as untimed entires.  Entries that extend across mutliple days will be converted as entries that repeat on weekdays.  If the resource on an entry matches a search string then the year code letter for that entry will be the initial letter of the resource description.  The title of the entry is the resource name (if any) followed by the task description.

The search string, the default name and path for the CSV file are hard coded within the program code.

The source code has been included so that anyone else who might want to make use of this code can amend it to their own requirements.

Caveat

While I have used my best endevors to develop this software,  I will not be responsible for an damage or loss of data or anything else.  You use this software at your own risk.  However, so do I!

Feedback

If you find any problems, or wish to make an suggestions for enhancements then please mail me.  Please also let me know if you wish to be kept informed of any upgrades.  My e-mail address is:

david@kurzbyrn.demon.co.uk

This and other pieces of software are available from my website

http://www.kurzbyrn.demon.co.uk/psion.htm