jdice

Hi...I uploaded googlesitemap generator by bobby about a year ago. It only has two files...googlesitemapcategories.php & googlesitemapproducts.php. Then I go to google.com/webmasters/sitemaps and put my website in. However, the googlesitecategories.php is fine but googlesitemapproducts.php is not. Google is giving me this error: 1193 Invalid date An invalid date was found. Please fix the date or formatting before resubmitting....FOR MY googlesitemapproducts.php page. does anyone know how I fix this? Here is my products.php page: <?php /** * Google Sitemap Generator * * Script to generate a Google sitemap for osCommerce based stores * * @license http://opensource.org/licenses/gpl-license.php GNU Public License * @version 1.2 * @link http://www.oscommerce-freelancers.com/ osCommerce-Freelancers * @copyright Copyright 2006, Bobby Easland * @author Bobby Easland * @filesource */ /* * Include the application_top.php script */ include_once('includes/application_top.php'); /* * Send the XML content header */ header('Content-Type: text/xml'); /* * Echo the XML out tag */ echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n"; ?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <?php /* * Define the uniform node function */ function GenerateNode($data){ $content = ''; $content .= "\t" . '<url>' . "\n"; $content .= "\t\t" . '<loc>'.trim($data['loc']).'</loc>' . "\n"; $content .= "\t\t" . '<lastmod>'.trim($data['lastmod']).'</lastmod>' . "\n"; $content .= "\t\t" . '<changefreq>'.trim($data['changefreq']).'</changefreq>' . "\n"; $content .= "\t\t" . '<priority>'.trim($data['priority']).'</priority>' . "\n"; $content .= "\t" . '</url>' . "\n"; return $content; } # end function /* * Define the SQL for the products query */ $sql = "SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered FROM " . TABLE_PRODUCTS . " WHERE products_status = '1' ORDER BY products_last_modified DESC, products_date_added DESC, products_ordered DESC"; /* * Execute the query */ $query = tep_db_query($sql); /* * If there are returned rows... * Basic sanity check */ if ( tep_db_num_rows($query) > 0 ){ /* * Initialize the variable containers */ $container = array(); $number = 0; $top = 0; /* * Loop the query result set */ while( $result = tep_db_fetch_array($query) ){ $top = max($top, $result['products_ordered']); $location = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $result['pID'], 'NONSSL', false); if ( tep_not_null($result['last_mod']) ){ $lastmod = $result['last_mod']; } else { $lastmod = $result['date_added']; } $changefreq = 'weekly'; $ratio = ($top > 0) ? ($result['products_ordered']/$top) : 0; $priority = $ratio < .1 ? .1 : number_format($ratio, 1, '.', ''); /* * Initialize the content container array */ $container = array('loc' => htmlspecialchars(utf8_encode($location)), 'lastmod' => date ("Y-m-d", strtotime($lastmod)), 'changefreq' => $changefreq, 'priority' => $priority ); /* * Echo the generated node */ echo generateNode($container); } # end while } # end if /* * Close the urlset */ echo '</urlset>'; /* * Include the application_bottom.php script */ include_once('includes/application_bottom.php'); ?>

Hi...I uploaded googlesitemap generator by bobby about a year ago. It only has two files...googlesitemapcategories.php & googlesitemapproducts.php. Then I go to google.com/webmasters/sitemaps and put my website in. However, the googlesitecategories.php is fine but googlesitemapproducts.php is not. Google is giving me this error: 1193 Invalid date An invalid date was found. Please fix the date or formatting before resubmitting. How do I do that? Also, shouldn't I be submitting an index page to google? Like mysite.com/catalog instead of mysite.com? Thanks for help and time, Sincerely, Janet I am not sure what to do. my server date and time is this: 10/18/2009 22:04:17 Here is my googlesitemapproducts.php page: <?php /** * Google Sitemap Generator * * Script to generate a Google sitemap for osCommerce based stores * * @license http://opensource.org/licenses/gpl-license.php GNU Public License * @version 1.2 * @link http://www.oscommerce-freelancers.com/ osCommerce-Freelancers * @copyright Copyright 2006, Bobby Easland * @author Bobby Easland * @filesource */ /* * Include the application_top.php script */ include_once('includes/application_top.php'); /* * Send the XML content header */ header('Content-Type: text/xml'); /* * Echo the XML out tag */ echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n"; ?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <?php /* * Define the uniform node function */ function GenerateNode($data){ $content = ''; $content .= "\t" . '<url>' . "\n"; $content .= "\t\t" . '<loc>'.trim($data['loc']).'</loc>' . "\n"; $content .= "\t\t" . '<lastmod>'.trim($data['lastmod']).'</lastmod>' . "\n"; $content .= "\t\t" . '<changefreq>'.trim($data['changefreq']).'</changefreq>' . "\n"; $content .= "\t\t" . '<priority>'.trim($data['priority']).'</priority>' . "\n"; $content .= "\t" . '</url>' . "\n"; return $content; } # end function /* * Define the SQL for the products query */ $sql = "SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered FROM " . TABLE_PRODUCTS . " WHERE products_status = '1' ORDER BY products_last_modified DESC, products_date_added DESC, products_ordered DESC"; /* * Execute the query */ $query = tep_db_query($sql); /* * If there are returned rows... * Basic sanity check */ if ( tep_db_num_rows($query) > 0 ){ /* * Initialize the variable containers */ $container = array(); $number = 0; $top = 0; /* * Loop the query result set */ while( $result = tep_db_fetch_array($query) ){ $top = max($top, $result['products_ordered']); $location = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $result['pID'], 'NONSSL', false); if ( tep_not_null($result['last_mod']) ){ $lastmod = $result['last_mod']; } else { $lastmod = $result['date_added']; } $changefreq = 'weekly'; $ratio = ($top > 0) ? ($result['products_ordered']/$top) : 0; $priority = $ratio < .1 ? .1 : number_format($ratio, 1, '.', ''); /* * Initialize the content container array */ $container = array('loc' => htmlspecialchars(utf8_encode($location)), 'lastmod' => date ("Y-m-d", strtotime($lastmod)), 'changefreq' => $changefreq, 'priority' => $priority ); /* * Echo the generated node */ echo generateNode($container); } # end while } # end if /* * Close the urlset */ echo '</urlset>'; /* * Include the application_bottom.php script */ include_once('includes/application_bottom.php'); ?>

Okay...you are probably going to think I am the stupidest person on this planet. I did not check any choices in the UPS module setup menu. I should have known to. I guess when I had installed a previous DHL shipping module...I had to go in and comment out code to exclude certain shipping options. In this MVS, you can do that in the adminstration section. I feel so stupid. Now I am getting UPS ground quotes back. Thanks for your time, Janet

I tried disabling everything but ups...just ups symbol and weight shows up...not shipping quote.

Okay I ran a sale through...this is what ups sends me: UPSOnLine4%1DM%08846%US%46219%US%105%2%76.16%0.00%76.16% 8:00 A.M.% 4%1DA%08846%US%46219%US%105%2%44.38%0.00%44.38%10:30 A.M.% 4%1DP%08846%US%46219%US%135%2%40.80%0.00%40.80%End of Day% 4%2DA%08846%US%46219%US%205%2%18.19%0.00%18.19%End of Day% 4%3DS%08846%US%46219%US%305%2%13.48%0.00%13.48%End of Day% 4%GND%08846%US%46219%US%005%2%10.34%0.00%10.34%End of Day%

Okay, I replaced both [email protected] with my email address and took the slashes/star out. what next?

Do you think the fact that I have BTS template would affect the installation of this module. I have installed several contributions splitting files in both the catalog area and template/fallback folder before with no problems. But I did look at the osmax version of MVS and compared it alittle. I do not have Osmax. I just have a bts template. I noticed the sql files were vastly different. If so...do you know what files need to be changed. It is mostly working...flat rates are working just fine. and UPS symbol is showing up during checkout and so are the pounds. I am just not getting ups quotes back during checkout. Just thought I would ask...I know you don't have all day to help us self learners. ...so don't feel like you have to answer all my questions. But I know sometimes...it could be something simple you already know...I could quickly change. Thanks for your help so far, Janet

Okay...it is late....I will look at my version of MVS. When I have MVS turned on...UPS and my flat fee come up...but UPS is not returning quotes. Only my flat fee quote is coming up. Maybe there is another reason I am overlooking. I will look into it some more. Maybe I don't need to modify regular shipping modules as I thought. If MVS is supposed to work after installation..right out of box...then I have done something wrong. Maybe there is another reason UPS is not returning quotes. Well, now I have us both scratching our heads. Janet

Well...my version of oscommerce did not have a ups module at all. I have a shop with two different suppliers. One supplier ships with a flat fee...the other supplier uses ups. i have used Multivendorshipping in the past. This worked quite well with two different shipping methods. So I upload MVSV1.1 like I did before. I first modifed the Table module to work with mvs. This took care of my flat rate shipping. Then I realized I did not even have ups to begin with as one of my shipping modules in my original oscommerce. So I upload UPS Choice. Got it working perfectly by itself...UPS Choice returned quotes just fine. And then I went to modify the UPS Choice file to work with MVS but I have been unsuccessful. When I enable MVS in my administration by clicking TRUE. My checkout page show UPS and flat rate shipping as options however, UPS is not returning any quotes. However, when I click False turning of MVS. UPS choice returns quotes just fine by itself. So I must have modified catalog/shipping/modules/ups wrong. If there is an easier way to do this...I open to suggestions. Janet

Hello, Thank you for your response. However, I believe you have to adapt the existing UPS Choice Shipping Module to work the MVS UPS Choice Module. It involves alot of moifications. I first did the table module which was easy but I am not having such an easy time adapting the UPS choice Shipping Module to work with MVS. There seem to be alot of modifcations. I was hoping to compare my files to someone else's. The needed modified file I am referring to is: catalog/includes/modules/shipping/ups.php. This file I believe must be modified properly to work with MVS. Sorry if anyone thought I was being pushy bumping my post...just thought my post was getting lost in the shuffle. I have spent a month on this total trying to solve this myself and searching/googling oscommerce solutions extensively before asking for help over a week ago. So after a long day of searching again, and repeated attempted trials...I did finally post again in hopes someone would see my post who had knowledge. I honestly meant no harm. Sincere apologizes to anyone I bothered. Thank you again and I will continue working on this:) Janet quote name='kymation' date='Feb 27 2009, 06:45 PM' post='1374335'] Not trying to be rude, but please don't bump your posts. It makes it less likely that you will get an answer. The UPS Choice module is included with the MVS distribution. See catalog/includes/modules/vendors_shipping/ups.php. Regards Jim

ANYONE???

Hi....Not to be bum...but was wondering if anyone has modified UPS CHOICE files to work with MVS(multivendor shipping)? I think it is just two files that have to be modified....includes/modules/shipping/ups AND includes/languages/english/modules/shipping/ups files? I have spend all day on this...and taking a break finally. The TABLE file in the example modifications(instructions for modifications) are vastly different from UPS files. I'm not sure I am even doing it right. I have got UPS choice to work just fine in the original shipping modules that come with oscommerce. However, not with MVS. I know I have to do alot of modifications to the two files above to get them to work together. I was just wondering if someone has already conquered this and willing to share it? Thanks for viewing my post, Janet

Okay...that was so silly of me...how could I have overlooked it. I was clicking all those buttons. I had remembered seeing it before...but couldn't remember where. I must have thought I clicked on the manage button the second time around and didn't. Gosh thanks for your help. Janet :rolleyes:

okay...I finally got the vendor module working....I had a couple files in the wrong place...some minor corrections in code as well. So now I have set up a sample vendor 1 ...but I see no shipping option to choose from for each particular vendor I use...like ups or flat rates or table rates... I see a place for handling charges....tare weight...etc...but no shipping option to choose from for each vendor. where do I do this at? Sincerely, Janet

Okay...to anyone who can help...I have finished what I thought were table modifications. However, In the beginning in the module instructions...it says to take the table.php file from catalog/includes/modules/shipping/table.php and to make changes to this file. At the end...after all modifications are done...it says to put it in the file to includes/modules/vendor_shipping/and close it. Now I am confused. Because when I went to my cpanel and tried to upload it to includes/modules/vendor_shipping/ and to save it as table.php. There is already a modified MVS file there... Why don't I just put the table.php file back to where I got it from to begin with ....like the catalog/includes/modules/shipping/table.php ??? Or did I just modify the wrong file???? Please someone respond to this...if you know the answer. Janet