[kronolith] CSV import not working

[Florin Andrei]

On Tue, 2003-07-08 at 15:52, Jan Schneider wrote:
> Zitat von Florin Andrei <florin at sgi.com>:
> > I attached to this message the CSV file that i'm trying to import. It
> > was generated (i think) on a Windows system, probably using Microsoft
> > Project.
> 
> Without testing your csv file, my wild guess is, that this file will never
> work. For one it doesn't have an end date what *might* cause general
> problem with Kronolith.

Ok, i hacked the file, manually adding an "End Date" column and just
copy/pasting the same date from "Start Date". See attached new2.csv
file.
I then associated the following matching fields in Kronolith:
System - Title
Owner - Description
Start Date - Start Date
End Date - End Date
Click on Import... Then i get two notices:

Notice: Undefined index: Start Date in
/data/www/horde/templates/data/datemap.inc on line 20
Imported field:

Notice: Undefined index: End Date in
/data/www/horde/templates/data/datemap.inc on line 20
Imported field:

Don't change anything here, just click on Import again...

It says "CSV file successfully imported"...

But when i go to the Calendar there's no event imported at the expected
dates. :-(

> Beside that (not only) the first row contains empty fields, while you still
> choose the first row to contain the column names. But how should we
> associate the following rows with column names, if most of them are not
> only the same but also empty.

Alright then.

I imported the CSV file into OpenOffice, then saved it again as CSV. The
result is in the attached new3.txt file. Then tried to import that last
file.
I created the same matching fileds pairs as above.
Click on Import.
I get the same notices about undefined indexes.
Click on Import again.
Kronolith reports success.
Go to the Calendar...
Nothing there. :-(

Can you indicate me please a CSV format that will work with Kronolith?
Thanks.

-- 
Florin Andrei

"Never send a human to do a machine's job." - Agent Smith
-------------- next part --------------
A non-text attachment was scrubbed...
Name: new2.csv
Type: text/x-comma-separated-values
Size: 238 bytes
Desc: not available
Url : http://lists.horde.org/archives/kronolith/attachments/20030708/cd684c33/new2.bin
-------------- next part --------------
"System","Owner","Start Date","End Date"
"Build in red","jm",07/09/2003,07/09/2003
"Default to Corp","fa",07/10/2003,07/10/2003
"Move gates","jm",07/11/2003,07/11/2003
"gone","pjb",07/14/2003,07/14/2003