Forum Moderators: phranque
What I need, in specific:
A script that will read the files I have, and put them into a database structure that I'm designing right now.
After that, a script that will read the contents of the database tables, etc. and output web pages based on that, and 2 different template files.
I've been looking at sourceforge, freshmeat, and hotscripts, and haven't had any luck. I'm going to try creating one for myself, but my perl programming knowledge is still somewhat lacking.
The shopping cart script I use does that for most of the product information on our site, and the company we got it from (ahg.com) also offers a dedicated SQL database/site integration script called ForwardSQL [dbwww.com]. They're also very good about doing quick and reasonably priced custom alterations to their scripts.
As for a script that will take your existing data and creat the DB automatically, I dunno... That's the part I did by hand.
This might help. I would use the dynamic creation method instead of static pages. Basicly when I have a change on the product page or category page I edit two files and done. Product records are stored in a Access 2k DB or you can use their SQL version.
Brian
Related thread:
looking for freeware programs for ecommerce [webmasterworld.com]
Related Article:
Builder.com Review of Akopia [builder.com]
Anyway, I have taken a look at the Akopia thing as well, but not in any great detail. Most of what I have is in text files, tab delimited. And I have the site almost done by hand, or rather, my wife has almost done the site by hand.
Collaborating might be an idea. Problem is, I'm such a perl novice, I doubt I could help much :)
The only reason I haven't gone into the Akopia thing before is that it seems very large, and I don't need all that. It's a large site I'm handling, but not large on features, programming needs, etc.
I'll drop you a sticky sometime later this week, and maybe we can talk. I've found some of the elements of what I want in individual perl scripts, that I would need to modify, but I think the guts of it are out there. It's just a matter of putting it together so that it works, makes sense, and is the easiest possible solution. :) That's why I'm studying perl. ;)
Don't worry, I'm a perl novice too (but at least it's easier than C :)) Here, here regarding Akopia ... too much for a simple site - just thinking maybe some day it would be helpful if I took on a big project. Probably the best thing would be if we can just keep in contact and trade 'secrets' and so on.
K per record? Number of fields?
I found out yesterday I need to download the file again, because somehow the pricing info got corrupted on some of the items.
