Re: [fsardoni] Importing a database of products from a CSV file

Thu, 26 Aug 2010 15:18:36 -0700

OK. It works with your suggestion of changing the default ";" to ","...

As a note for others, it only works when changing the import from
"CSV" to "CSV using LOAD DATA" and the default "Fields Terminated By" = ";" to =","

Thank you again Chris.

Re: [chris] Importing a database of products from a CSV file

Thu, 26 Aug 2010 15:08:01 -0700

Hi Chris, thanks again for your help.
What I am trying to achieve here is an import of all my products from an existing CSV.

Step 1: From PHPmyAdmin I exported the cms_products table (as a CSV file) to see what columns CMS Builder creates when I created my first product manually.

Step 2: I copied the content from my original "products" CSV into the export CSV file from CMS Builder and then tried to upload it to CMS builder DB.

In short I want to do a quick upload of all my products instead of creating each record (for my products) manually.

Importing a database of products from a CSV file

Thu, 26 Aug 2010 11:28:10 -0700

Hi is there a known issue importing a database (products) via phpmyadmin with a .CSV file? Or better yet, is there a particular way that the .CSV file needs to be formatted?
I exported what CMS Builder creates as .CSV and then use that to copy and paste all the rows of my products. Saved it and then re-upload the file to the MySQL db. However I get an error:

Invalid field count in CSV input on line 2.

what's that all about? Any helps as always, is GREATLY Appreciated.

Re: [fsardoni] Creating a side menu with categories of products

Wed, 25 Aug 2010 14:57:17 -0700

Ok I think I got it working without the previous error. Thank you.
The code now looks like this:

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/content/g/o/f/gofgof/html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

list($categoriesRecords, $selectedCategory) = getCategories(array(
'tableName' => 'categories',
));

list($productsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
));

?>

(All Products)

Re: [chris] Creating a side menu with categories of products

Wed, 25 Aug 2010 14:37:27 -0700

Ok! That fixed it for the most part. Thank you. Now I am getting this error message:

Notice: Undefined variable: categoryRecord in /home/content/g/o/f/gofgof/html/includes/productnavigation.php on line 27 (All Products)

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/content/g/o/f/gofgof/html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

list($categoriesRecords, $selectedCategory) = getCategories(array(
'tableName' => 'categories',
));

list($productsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
));

?>

(All Products)

Re: [fsardoni] Creating a side menu with categories of products

Wed, 25 Aug 2010 10:43:26 -0700

Hi Chris another issue I discovered is that when I am clicking on my side navigation links while in the productsList.php page I get all the records always. When I then click on the product that was found in the productsList.php I go to the productDetail.php page which is correct but when I then click back on any other link the url changes to:
http://www.greetingsoffaith.com/productDetail.php?category=32
instead of showing me or bringing me back to:
http://www.greetingsoffaith.com/productsList.php?category=32:

Why is that? and Or should it be that way?
Thank you

Re: [chris] Creating a side menu with categories of products

Wed, 25 Aug 2010 08:41:16 -0700

Hi Chris, where do I change that to reflect the field "categories"??
Thank you.
Yes I did check the Sub-categories Tutorial, infact some of the code is lifted from there.

Re: [chris] Creating a side menu with categories of products

Tue, 24 Aug 2010 15:16:46 -0700

Hi Chris, thank you for your help:
The link is: http://www.greetingsoffaith.com/productsList.php
Please find all my files attached.
I am also having this issue where the products are displaying a number instead of the category name... It's a mess. Sorry and thank you.

PS.forgive the look it is not css stylized yet.

Re: [fsardoni] Creating a side menu with categories of products

Tue, 24 Aug 2010 14:28:19 -0700

Now I can't seem to have the categories finding and displaying the proper products. Can anyone help? Thank you

Re: [fsardoni] Creating a side menu with categories of products

Tue, 24 Aug 2010 14:03:06 -0700

Ok I found one solution: removing the line 1 :

of the navigation fixed it.

Creating a side menu with categories of products

Tue, 24 Aug 2010 13:55:17 -0700

Hi I need some help in creating a side menu with categories of products.
I have built it following some directions from this forum but I am having problems with the following error:

Warning: Cannot modify header information - headers already sent by (output started at /home/content/g/o/f/gofgof/html/productsList.php:29) in /home/content/g/o/f/gofgof/html/includes/productnavigation.php on line 1

Can someone please help me or just point me to the right thread in this forum?
Many thanks in advance.