Which extensions will I need?

Dear Friends,

I'm jumping into eCart5 headfirst with a project that requires the following for a cooking and kitchen utensils store:

• A member login process.
• A solution where only logged members are able to view prices.
• A admin backend for the store that the client can manage products, etc.
• No payment gateway required, only a 'wish list' that is stored in a database.

Am I correct is assuming that besides eCart5, I'll need Security Assist to build the login and 'protected pages' function — and the combo of DataAssist, Digital File Pro, SecurityAssist, Cookies Toolkit and CSS Menu Writer to create the store backend?

Also, client has product info in an Excel spreadsheet. How would that integrate into the process? (About 75 products total, in 5 categories).

I have the main pages ready to go as Dreamweaver templates (home, product section page, and product detail page.)

Sorry for the swarm of questions, just want to make sure I have the right tools to proceed, and I'm not overlooking anything. Thanks so much in advance for any guidance anyone could provide!

Let me see if I can help...

eCart 5 for the cart.
SecurityAssist for the user login
DataAssist for the backend mgmt.
Universal Email 4 (replaces Digital File Pro)
CSS Menu Writer for navigation, but not required

I'm not sure why you need the Cookie toolkit.

WebAssist doesn't have an Excel export option at this time.
However you can write an export to CSV or PDF using other scripts utilizing SQL queries.

MySQL to CSV sample

<?php

$host = 'localhost';

$user = 'mysqlUser';

$pass = 'myUserPass';

$db = 'myDatabase';

$table = 'my_table';

$file = 'my_export_filename';



$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());

mysql_select_db($db) or die("Can not connect.");



$result = mysql_query("SHOW COLUMNS FROM ".$table."");

$i = 0;

if (mysql_num_rows($result) > 0) {

while ($row = mysql_fetch_assoc($result)) {

$csv_output .= $row['Field']."; ";

$i++;

}

}

$csv_output .= "\n";



$values = mysql_query("SELECT * FROM ".$table."");

while ($rowr = mysql_fetch_row($values)) {

for ($j=0;$j<$i;$j++) {

$csv_output .= $rowr[$j]."; ";

}

$csv_output .= "\n";

}



$filename = $file."_".date("Y-m-d_H-i",time());

header("Content-type: application/vnd.ms-excel");

header("Content-disposition: csv" . date("Y-m-d") . ".csv");

header( "Content-disposition: filename=".$filename.".csv");

print $csv_output;

exit;

?>

Recommended PDF script

pdf/

Hi Tom,

Thank you soooooo much for your help. I think I've researched everything well, but wanted to confirm before I got rolling.

Also, thanks for the tip on the spreadsheet export —*that's gold! ;-)

Again, I greatly appreciate your time and help! Wish me luck ;-)

Thank you!