The Underscore Archives

Hi s´unya,
I didn't mean to suggest that we have found that "there is a direct
import method" but would certainly be interested if someone doesn't use
the intermediate csv and parsing stage. With a macro and script it is
just the upload which takes any time.

Rupert Russell
www.comcar.co.uk

-----Original Message-----
From: s'unya [mailto:sunya.dickman at gmail.com] 
Sent: 09 March 2007 13:17
To: underscore at under-score.org.uk
Subject: Re: [_] A question of elegance


Hi,

Excellent, thanks for the very helpful questions and suggestions.

As Russel said, " ..the client views their excel spreadsheet as the main
data and calculation core of their business, whilst the table that
exists on the website is just a regular "snapshot"...".

I like the xml/xsl suggestion except that the client needs to be able to
simply put in a bunch of data, which is why I settled on CSV - the
client can understand how they work and they are relatively easy to copy
and paste into a textarea or something. Thanks for the backup tip... I
didn't give it a thought. I am mostly worried about this method because
the id field auto increments so the id can become very big very quickly.

I really like the excel import/swap thing as it obviates the
incrementing id problem and sounds like it might cut out all the csv
parsing if there is a direct import method. I didn't realise it could be
done with mysql... is there something I am missing? I will do a search
on it, ... and any tips would be mucho appreciated!

Thanks again.

-- 
                      o
            o                 o
                O   O   O
      o  0   O s´unya O   0  o
        www.the-resort.com
-- 
underscore_ list info/archive -> http://www.under-score.org.uk