[kronolith] CSV import not working

[Jan Schneider]

Zitat von Florin Andrei <florin at sgi.com>:

> 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. :-(

Then it wasn't the missing end date column.

> > 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. :-(

Though I've rewritten most of the import/export code in CVS HEAD, I can't
import this file either. It looks like Kronolith's import filter can't
handle missing starting times at the moment.

I'll try to fix this if I find some time and no one beats me. But I'm not
sure about the stable branch, because of the said rewrite. It's more likely
that we release a new major version than that I touch the old code again.
;-)

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft