methodprobiz

I am willing to pay for help to get the following result... please? help :) This is for a CD store... arranged for main category as "This kind of Music", "That kind of Music", etc. Then there is the Artist/Band Names under the main categories. I would like the CD Titles for each artist to show *with* the Band Names. That is to say... anytime that a CD title (the product) is shown, the band name will show as well - it shows in the header, but not actually on the product pages, the what's new box, the invoices, printable catalog... and such. I'm so tired of beating my head against the wall on this, please message me with quotes? I don't know any php coders so any suggestions welcome. Time is limited. Thank you good people of this forum for existing!

Another seeker of contribution or event a hint as to how to write code for Parent Catagory Link to be used on product_info.php as well as *any* page that shows a product's name (invoices, print catalog, shopping cart, etc, emails, etc.). I found one post that vaguely referenced the need for a join but still so far from understanding. Anyone?

:'( Still having a heck of a time trying to figure this out... parent catagory of a product to display on command. I gather it requires a 'join' statement... sure would appreciate any tips or advise from you more experienced coders

You have had this working with EP? Cool, then there is hope for my scope yet! I may not know the exact terminology for you but I know how to help you if you can access your SQL database through phpMyAdmin... look in your OSC database for the "products" table... there should be an entry for image_med -look for the others listed in that message to make sure you are in the right place, if it is not there you will need to run a query to add it. (as a side note I strongly suggest this is associated with your Image HTML Package so there should be an SQL query instruction within the install file to reference on what exactly to paste into your query window and run). Best of luck!

Success! In my case (reposted below for you searchers) the errors were caused by my define of 'DIR_FS_DOCUMENT_ROOT' trying to use the shared SSL path. By changing this to path '/home/rooted/public_html/catalog' the connection was re-established and EP file loaded - YAY!! BTW, Same $tempdir settings were used (see below) The reason $DOCUMENT_ROOT did not work for me is that it also generated a reference to the shared SSL path. I would prefer using the shared SSL but for now this will work. Have a great day and 3 Cheers to Mibble for a wonderful (nearly mandatory) contribution!

This may help you: http://www.oscommerce.com/forums/index.php?act=ST&f=7&t=195262

This is most likely being caused by something other than EP but just the same... your database table (products) is missing entry for image_med in the field list. If you have phpMyAdmin, view your products table Make sure you are in correct table by finding one of the other entries in the list that seem to be working - do you see image_med in there? If not, you will need to insert that ...best way is to check the install instructions of contribution using this (UltraPics?), and verify that you have followed any SQL query instructions for adding tables to your database. Good luck!

Not sure if this will help but worth a shot... search the file you are importing for the text 'none' - if you see it has been inadvertently placed within any catagories_name columns thats the deal. OR verify that you are infact filling out the catagory names (it could be that EP wants all products within catagories but I do not know this for certain). Good luck!

My first thought is... remember to password protect your admin area since currently it is totally exposed. (though you probably only have it like this to get help but just incase hehe). On to your issue... You do not need to move the images as long as they worked before this contrib. However, the file you should be editing to define your paths is /catalog/admin/includes/configure.php (do you actually have a file catalog/admin/config.php ??) Additionally, I am guessing that more than the images definition needs tweeking because your backup path is failing. This is not a "direct" cut and paste answer but... Here is what works for me (note I have my OSC on a subdomain and use shared SSL so you will need to adjust for your requirements - or use SSL as recommended). I made notes in the code to help you out for your cart as installed in root/catalog/. Make a backup copy of the file incase your adjustments don't work out. // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'https://secureserver.webhost.com/~username/catalog'); // eg, [url="http://localhost"]http://localhost[/url] - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://catalog.mywebsite.com'); //you should have something like 'http://impursenationsandmoore.com' but mine is like this per subdomain use define('HTTPS_CATALOG_SERVER', 'https://secureserver.webhost.com/~username/catalog'); define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module - be sure to change true to false if you are NOT SSL ready define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server revert if needed to: /home/secureserver/public_html define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/username/public_html/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', 'https://secureserver.webhost.com/~username/catalog'); //finally! using URL makes images work right in SSL admin define('DIR_FS_CATALOG', '/home/username/public_html/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'username_osc1'); define('DB_SERVER_PASSWORD', 'somecrazycharacters'); define('DB_DATABASE', 'username_osc1'); define('USE_PCONNECT', 'false'); // use persisstent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> *If you make a change that doesn't work and you get an error, analyze the path it shows you because sometimes its just a slash '/' that is needed or not needed to achieve proper result. Make special note of this line, it was a snag for me in getting images in admin to work: define('DIR_WS_CATALOG', 'https://secureserver.webhost.com/~username/catalog'); //finally! using URL makes images work right in SSL admin Try using this: define('DIR_WS_CATALOG', 'http://impursenationsandmoore.com' ); //finally! using URL makes images work right in SSL admin and remember to change SSL line from true to false for your file If my notes are confusing, there is a file that can be placed on your site to show you how your server paths are specifically called. Someone posted it in one o' these forums along the way so you'll have to search for it, I believe it was called myenv.php if that helps.

Hmm.. I'm not familiar with linux but here's my method: Download file from EP, open a new excel file and choose from 'Data' tab the 'Import External Data/Import Data' options and select the EP.txt file. You will be prompted with options, choose 'Delimited' and 'Tab' only. Continue with general settings defaulted to finish. Make your edits (add at least one product to test) etc. and save twice: save as excel(.xls) to work with again easily and more importantly, save as .txt file - it is this .txt file you will use in the upload to EP process. You may see some warning from Excel about characters nullified or something but thats fine as long as you don't have apostrophies and other characters warned about in EP documentation. Next, go to EP and upload that .txt file and verify success. I hope this helps :) PS. I don't think you should have to rename the extensions to .cvs but I am far from knowing everything.

Looks like you need to add this entry: define('FILENAME_PRINT_CATALOG', 'print_catalog.php'); //adding print catalog to the 'catalog/includes/filenames.php' file. Paste this anywhere before the closing php tag (though alphabetical is recommended method).

Incase this is helpful in resolving, this error occurs after attempt to upload same inventory file that worked before. Downloading a backup still works great :) Example of URL when this error occurs: *I do not have split feature enabled that I am aware of.

Alas, I have similar issue to others here - though for a while I had this running smooth so I know it works(worked) excellent :thumbsup: This admin/configure.php did work before, I have made notes as to why some lines are defined as they are... note that I tried the $DOCUMENT_ROOT method but no new result define('HTTP_SERVER', 'https://secureserver.webhost.com/~rooted/catalog'); // eg, [url="http://localhost"]http://localhost[/url] - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://catalog.mywebsite.com'); define('HTTPS_CATALOG_SERVER', 'https://secureserver.webhost.com/~rooted/catalog'); define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/home/secureserver/public_html'); // tried to $DOCUMENT_ROOT define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/rooted/public_html/catalog/admin/'); // keep!(see backup page) absolute path required define('DIR_WS_CATALOG', 'https://secureserver.webhost.com/~rooted/catalog/'); // keep - absolute path required - finally! using URL makes images work right in admin define('DIR_FS_CATALOG', '/home/rooted/public_html/catalog/'); // absolute path required define('DIR_WS_IMAGES', '../images/'); //keep this for thumbnailer to find Reference: catalog/admin/ easypopulate_functions.php Line 32 is like this here: move_uploaded_file($filename['tmp_name'], $target); catalog/admin/ easypopulate.php has these: Line 670 $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name); Line 693-694 foreach ($readed as $read){ $newreaded .= $read; -I have verified admin/temp directory has full write permission -I have attempted various settings for temp reference w/no success... the following is what I was using when the EP module worked well to have temp in admin for security purposes: $tempdir = "/admin/temp/"; $tempdir2 = "/temp/"; *However I have now placed a catalog/temp reference just incase (with 0777 as my server setup requries for full write permissions - instead of 0755) -My OSC setup is located on subdomain example for admin access: http://catalog.mywebsite.com/admin -Despite trying my best to backup all files to be edited when installing new mods, as well as full backup of database... I was unable to restore this mod to the point of getting this back in order after installing On the Fly GD thumbnail contribution and PayPal Shopping Cart IPN (which has since been removed) Unfortunately I am not sure which of these threw off the EP since upload was not attempted after thumbnailer, my bad! Please have mercy - or a flashlight? cuz I'm now in tha dark!

As an easypopulate user, I am also interested in compatability resolve of this contribution. Anyone to share experience or suggestions?

Update! I now have rid myself of the error at line 65 however the 'function' of calling the parent catagory of a product is not being acheived. See step 2 for where I think the problem is now... 1) add catagories_name to array of catalog/print_catalog.php ...*and adjust previous lines for proper closing of array, note updated snip below shows how removing ')' and changing the semi-colon to comma from line 64 and placing in line 65 resolves the error. Example: 'date_added' => tep_date_long($print_catalog['products_date_added']), 'manufacturer' => $print_catalog['manufacturers_name'],//removed closing ')' 'catagory' => $print_catagory['categories_name']);//here is ***** line 65***** } ?> 2) In includes/modules/print_catalog.php used one of the ouput statements as a model and call the array result for 'your' category. Using this: [code<?php echo TEXT_CATAGORIES_NAME . $print_catalog_array[$i]['catagories_name']; ?>[/code] AND adding the following code to catalog/includes/language/english/print_catalog.php : define('TEXT_CATAGORIES_NAME', 'Band Name: '); Results in the text 'Band Name: ' displayed in proper location, however no band name (catagories name) is actually rendering... evidently I still need a formula added to check parent catagory of a product (sub-catagory of main catagory) and then if actually post that result - ultimately revealing band name (parent catagory) of cd title (product). Help? ;) I tried copy/pasting from product_info.php but I am coming up short, and still searching.

OOps! can't edit my post so please allow me to add: What I am trying to do with adding catagory (or sub-catagory) to product listing / printable catalog is to display the parent catagory/sub-catagory every time the product is shown. For example: MUSIC CD's (main catagory) > BAND NAME (sub-catagory) > CD TITLE (product) Perhaps I am taking the 'add catagories_name' too literally and should be placing instead a specific catagory name reference? hmm...

I have the following error: My understanding of php is limited - but I am determined to improve. I would greatly appreciate your help to accomplish this while I continue to figure out the syntax of php :blush: I know this is going to clarify other questions of php application as well so thank you much in advance! I attempt to follow these instructions by doing this (): 1) add catagories_name to array of catalog/print_catalog.php ... array was originally: $print_catalog_array[] = array('id' => $print_catalog['products_id'], 'name' => $print_catalog['products_name'], 'description' => $print_catalog['products_description'], 'model' => $print_catalog['products_model'], 'image' => $print_catalog['products_image'], 'price' => $print_catalog['products_price'], 'specials_price' => $print_catalog['specials_new_products_price'], 'tax_class_id' => $print_catalog['products_tax_class_id'], 'date_added' => tep_date_long($print_catalog['products_date_added']), 'manufacturer' => $print_catalog['manufacturers_name']); so i added (on line 65) 'catagory' => $print_catagory['categories_name']; at line 65 however that seems to be the problem... I tried adding it at different lines, and adding a ')' such as the two previous lines, no success yet. Can you provide syntax of how this line should be added? If there should be a join inserted to the $print_catalog_query_raw please be so kind as to advise me on this? ... below is the full php chunk after line was added to array incase I am adding to wrong array or calling improper: <?php $print_catalog_query_raw = "select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, cd.categories_name, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id=p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id=c.categories_id left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.parent_id='0' and c.categories_id=cd.categories_id left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by cd.categories_name, c.parent_id, c.sort_order, c.categories_id, pd.products_name"; //$print_catalog_split = new splitPageResults($print_catalog_query_raw, MAX_DISPLAY_PRINT_CATALOG); //$featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_FEATURED_PRODUCTS); $print_catalog_query = tep_db_query($print_catalog_query_raw); while ($print_catalog = tep_db_fetch_array($print_catalog_query)) { $print_catalog_array[] = array('id' => $print_catalog['products_id'], 'name' => $print_catalog['products_name'], 'description' => $print_catalog['products_description'], 'model' => $print_catalog['products_model'], 'image' => $print_catalog['products_image'], 'price' => $print_catalog['products_price'], 'specials_price' => $print_catalog['specials_new_products_price'], 'tax_class_id' => $print_catalog['products_tax_class_id'], 'date_added' => tep_date_long($print_catalog['products_date_added']), 'manufacturer' => $print_catalog['manufacturers_name']); 'catagory' => $print_catagory['categories_name']; //here is ***** line 65***** } ?> 2) In includes/modules/print_catalog.php use one of the ouput statements as a model and call the array result for 'your' category. I know part 1 needs to be accurate first but to kill two birds with one stone... so far to execute this step, I have referenced: <?php echo $print_catalog_array[$i]['description']; ?> as an example to write: <?php echo $print_catalog_array[$i]['catagories_name']; ?> and placed this within the same <tr> to test. Am I close?

I haven't tried uninstalling this contrib but have you tried using the installation readme.html file as a reference to retrace your steps? since no changes are made to the SQL database it should pretty much just be a reversal of what was done to the files (that are specifically noted to make backups of) and of course the removal of the "product_thumb.php" files. If you need clips of those "original" files, make a specific note to the ones you need and I will do my best to help you out.

Loving the effeciency of this contribution! However I am encountering a small technical difficulty... In admin (secured by ssl) the top two image links that *should* be visible for access to oscommerce.com and administration panel disappear (no red x, no link, nothing) once I edit admin/includes/configure.php line: define('DIR_WS_IMAGES', 'images/'); to read as define('DIR_WS_IMAGES', '../images/'); ... oddly if i do not alter the path, then those two image links are visible rendering the 3rd as a red x broken link and knocking out my top left "os banner" image to a red x as well. Havin a hard time finding out how to make this jive since the image arrays seem to be pulling similarly from the admin/index.php and icon images all residing in the main catalog/image/ folder together - any suggestions?

Installed V2.5 Quick Stock Update then attempted to run. At admin screen I see this code with is followed by 'Configuration' menu only / nothing else below or beside: In the catalog.php file I have: '<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a>'); '<a href="' . tep_href_link(FILENAME_QUICK_STOCKUPDATE, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_QUICK_STOCKUPDATE . '</a><br>' . } the last "}" is line 31 I have tried changing the last '</a><br>'. to look like this instead: '</a>' with no change in result. This must be something so simple I'm going to smack myself but I can't seem to grasp it. Any help appreciated. This Contribution will be handy for me if I can get it running. Thanks!

uh oh, i probably should NOT have put real path there - umm thats a fake path, yeah yeah thats it. Moderator, would you delete that? Hackers - don't hurt me :blush: I can't edit my post.

Installed V2.5 Quick Stock Update then attempted to run. At admin screen I see this code with is followed by 'Configuration' menu only / nothing else below or beside: In the catalog.php file I have: '<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a>'); '<a href="' . tep_href_link(FILENAME_QUICK_STOCKUPDATE, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_QUICK_STOCKUPDATE . '</a><br>' . } the last "}" is line 31 I have tried changing the last '</a><br>'. to look like this instead: '</a>' with no change in result. This must be something so simple I'm going to smack myself but I can't seem to grasp it. Any help appreciated. This Contribution will be handy for me if I can get it running. Thanks!