[ic] Newbee needs help converting Access DB to MySQL for Interchange bookstore

[Dan Browning]

At 08:38 PM 8/1/2002 -0400, you wrote:
>Can anyone point me in the direction of simple instructions on how to begin.
>I am trying to convert my ASP/Access (85,000 items) bookstore to
>Interchange/MySQL.
>
>My bro has a small Hosting company (4 servers) and has installed Interchange
>for me and has linked it to his MySQL server. (I have read the literature on
>the DB options that Interchange offers and I assume the most preferable
>options for a DB of this size is to use MySql.) I downloaded the foundation
>store product.txt file, opened it in Excell, added a few of my books to the
>template, saved it as tab delimited file and uploaded it as a test. I
>visited the  site, expecting the TXT file to be read and the DB appended
>with the new items but nothing happened.  No errors etc.  I used the admin
>on the site to manually add an item and it worked.
>
>As you can tell from this note, I have little programming experience but am
>determined to learn Interchange - I just need a little help - alright a lot
>of help - getting started. Anyone feeling sympathetic today??
>
>Dave

I have a very meager Excel HOWTO up on the website 
(http://icdevgroup.org/~danb/).  TXT import is not the only way to do it, 
but you first need to have some Perl modules installed:

perl -MCPAN -e shell

And then this in the resulting shell (as one line)...

install IO::Scalar OLE::Storage_Lite Parse::RecDescent 
Spreadsheet::ParseExcel Spreadsheet::WriteExcel

If you were using Access or MS-SQL as your datasource for ASP, it probably 
wouldn't be that difficult to export to tab delimited, import into excel, 
and then move the columns around a bit for IC.  But I bet that is what you 
were planning to do.  :-)  Good luck,

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Kavod Technologies <db@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As the trials of life continue to take their toll, remember that there
is always a future in Computer Maintenance.
                 -- National Lampoon, "Deteriorata"