[_] A question of elegance
s'unya
sunya.dickman at gmail.com
Fri Mar 9 13:17:13 GMT 2007
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