Jump to content
gottaloveit

Automatically send data feed to Froogle

Recommended Posts

Hey guys I've sort of done everything right but after editing the froogle.php file I'm getting this error.........

 

Warning: mysql_connect(): Access denied for user 'fukuokaf_Nigel '@'localhost' (using password: YES) in /home/fukuokaf/public_html/tsurishopjapan/admin/froogle.php on line 109
Error when connecting itself to the data base

 

I've made the user "fukuokaf Nigel" to have all privilages and has the correct password. What's up and why won't it connect to my SQL?

 

Thanks,

 

Nigel :)

Share this post


Link to post
Share on other sites

^k

Edited by killerwhale65

Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

hi,

 

i just uploaded my first feed to froogle, but i get a message saying my feed is incorrect, cause 1 line has "too few tabs". checked the feed but it seems ok. What can i do about this?


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

Hi!

First of all I want to thank you all for the great support!

Second, I had to reinstall OSC from scratch...I renamed the admin folder, I installed SEO contribution and I am trying to install froogle Feeder. I uploaded the feeds/ folder to my root and changed CHMOD to 777(including subfolders and files), modified froogle.php and uploaded in myrenamedadmin/folder.

When I point to http://www.mywebsite.com/myrenamedadmin/froogle.php it takes me to the admin panel. Is it where it should take me?!

When I point to http://www.mywebsite.com/feeds/myfroogle_file.txt the page cannot be displayed. :(

Can anyone have a look over my froogle.php file and help me with this? Am I missing something?

 

Thank you very much for your time and patience!

 

Simone

 

<?php
//  Title: Froogle Data Feeder 1.62
//  Author: Calvin K
//  Contact: calvink@conceptulanetworking.com
//  Organization: Conceptual Networking
//  Last Update: 12/21/05

//
// This feeder has been revised to work with Ultimate SEO URLs 2.1d (http://www.oscommerce.com/community/contributions,2823)
//

// Change to 'false' to disable the use of SEO
define('SEO_ENABLED','true');

if(SEO_ENABLED=='true'){
 //********************
 // Modification for SEO
 // Since the ultimate SEO was only installed on the public side, we will include our files from there.
 require_once('home/username/public_html/includes/configure.php');
 require_once('home/username/public_html/includes/filenames.php');
 require_once('home/username/public_html/includes/database_tables.php');
 $languages_id = 1;   // CHANGEME - Change this to the id of your language.  BY default 1 is english


 include_once('../' .DIR_WS_CLASSES . 'seo.class.php');
 $seo_urls = new SEO_URL($languages_id);

 function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) {
 global $seo_urls;
 return $seo_urls->href_link($page, $parameters, $connection, $add_session_id);
 }
}

//********************

//  Start TIMER
//  -----------
$stimer = explode( ' ', microtime() );
$stimer = $stimer[1] + $stimer[0];
//  -----------


$OutFile = "/home/username/public_html/feeds/myfroogle_file.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt";
$destination_file = "myfroogle_file.txt";  //"CHANGEME-filename-to-upload-to-froogle.txt";
$source_file = $OutFile;
$imageURL = 'http://www.mywebsite.com/images/';
if(SEO_ENABLED=='true'){
  $productURL = 'product_info.php';   // ***** Revised for SEO
$productParam = "products_id=";   // ***** Added for SEO
}else{
  $productURL = 'http://www.mywebsite.com/product_info.php?products_id=';
}

$already_sent = array();

if(SEO_ENABLED=='true'){
 $home = DB_SERVER;		  //  ****** revised these because we can....
 $user=DB_SERVER_USERNAME;
 $pass=DB_SERVER_PASSWORD;
 $base=DB_DATABASE;
}else{
 $home = "localhost";
 $user="******";
 $pass="******";
 $base="my_osc_db";
}

$ftp_server = "ftp://hedwig.google.com";
$ftp_user_name = "******";
$ftp_user_pass = "******";
$ftp_directory = ""; // leave blank for froogle

$taxRate = 0; //default = 0 (e.g. for 17.5% tax use "$taxRate = 17.5;")
$taxCalc = ($taxRate/100) + 1;  //Do not edit
$convertCur = false; //default = false
$curType = "USD"; // Converts Currency to any defined currency (eg. USD, EUR, GBP)
if($convertCur)
{
  if(SEO_ENABLED=='true'){
   $productParam="currency=" . $curType . "&products_id=";
  }else{
   $productURL = "http://www.mywebsite.com/product_info.php?currency=" . $curType . "&products_id=";  //where CURTYPE is your currency type (eg. USD, EUR, GBP)
  }
}

//START Advance Optional Values

//(0=False 1=True) (optional_sec must be enabled to use any options)
$optional_sec = 0;
$instock = 0;
$shipping = 0;
$lowestShipping = "4.95";  //this is not binary.
$brand = 0;
$upc = 0;   //Not supported by default osC
$manufacturer_id = 0;  //Not supported by default osC
$product_type = 0;
$currency = 0;
$default_currency = "USD";  //this is not binary.
$feed_language = 0;
$default_feed_language = "en";  //this is not binary.
$ship_to = 0;
$default_ship_to = "ALL"; //this is not binary, not supported by default osC for individual products.
$ship_from = 0;
$default_ship_from = "USD"; //this is not binary, not supported by default osC for individual products.

//END of Advance Optional Values

if (!($link=mysql_connect($home,$user,$pass)))
{
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $base , $link ))
{
echo "Error the data base does not exist";
exit();
}

$sql = "
SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,
products_model AS prodModel, products_weight,
manufacturers.manufacturers_name AS mfgName,
manufacturers.manufacturers_id,
products.products_id AS id,
products_description.products_name AS name,
products_description.products_description AS description,
products.products_quantity AS quantity,
products.products_status AS prodStatus,
FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,
CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url,
products_to_categories.categories_id AS prodCatID,
categories.parent_id AS catParentID,
categories_description.categories_name AS catName
FROM categories,
categories_description,
products,
products_description,
products_to_categories

left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id )
left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) )

WHERE products.products_id=products_description.products_id
AND products.products_id=products_to_categories.products_id
AND products_to_categories.categories_id=categories.categories_id
AND categories.categories_id=categories_description.categories_id
ORDER BY
products.products_id ASC
";


$catInfo = "
SELECT
categories.categories_id AS curCatID,
categories.parent_id AS parentCatID,
categories_description.categories_name AS catName
FROM
categories,
categories_description
WHERE categories.categories_id = categories_description.categories_id
";

function findCat($curID, $catTempPar, $catTempDes, $catIndex)
{
if( (isset($catTempPar[$curID])) && ($catTempPar[$curID] != 0) )
{
	if(isset($catIndex[$catTempPar[$curID]]))
	{
		$temp=$catIndex[$catTempPar[$curID]];
	}
	else
	{
		$catIndex = findCat($catTempPar[$curID], $catTempPar, $catTempDes, $catIndex);
		$temp = $catIndex[$catTempPar[$curID]];
	}
}
if( (isset($catTempPar[$curID])) && (isset($catTempDes[$curID])) && ($catTempPar[$curID] == 0) )
{
	$catIndex[$curID] = $catTempDes[$curID];
}
else
{
	$catIndex[$curID] = $temp . " > " . $catTempDes[$curID];
}
return $catIndex;

}

$catIndex = array();
$catTempDes = array();
$catTempPar = array();
$processCat = mysql_query( $catInfo )or die( $FunctionName . ": SQL error " . mysql_error() . "| catInfo = " . htmlentities($catInfo) );
while ( $catRow = mysql_fetch_object( $processCat ) )
{
$catKey = $catRow->curCatID;
$catName = $catRow->catName;
$catParID = $catRow->parentCatID;
if($catName != "")
{
	$catTempDes[$catKey]=$catName;
	$catTempPar[$catKey]=$catParID;
}
}

foreach($catTempDes as $curID=>$des)  //don't need the $des
{
$catIndex = findCat($curID, $catTempPar, $catTempDes, $catIndex);
}

$_strip_search = array(
"![\t ]+$|^[\t ]+!m", // remove leading/trailing space chars
'%[\r\n]+%m'); // remove CRs and newlines
$_strip_replace = array(
'',
' ');
$_cleaner_array = array(">" => "> ", "?" => "", "?" => "", "?" => "", "?" => "", "\t" => "", "	" => "");

if ( file_exists( $OutFile ) )
unlink( $OutFile );

$output = "product_url \t name \t description \t price \t image_url \t category \t offer_id";

//create optional section
if($optional_sec == 1)
{
if($instock == 1)
	$output .= "\t instock ";
if($shipping == 1)
	$output .= "\t shipping ";
if($brand == 1)
	$output .= "\t brand ";
if($upc == 1)
	$output .= "\t upc ";
if($manufacturer_id == 1)
	$output .= "\t manufacturer_id ";
if($product_type == 1)
	$output .= "\t product_type ";
if($currency == 1)
	$output .= "\t currency ";
if($feed_language == 1)
	$output .= "\t language ";
if($ship_to == 1)
	$output .= "\t ship_to ";
if($ship_from == 1)
	$output .= "\t ship_from ";
}
$output .= "\n";


$result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) );

//Currency Information
if($convertCur)
{
$sql3 = "
SELECT
currencies.value AS curUSD
FROM
currencies
WHERE currencies.code = '$curType'
";

$result3=mysql_query( $sql3 )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql3 = " . htmlentities($sql3) );
$row3 = mysql_fetch_object( $result3 );
}

$loop_counter = 0;

while( $row = mysql_fetch_object( $result ) )
{
if (isset($already_sent[$row->id])) continue; // if we've sent this one, skip the rest of the while loop

if( $row->prodStatus == 1 || ($optional_sec == 1 && $instock == 1) )
{

	if($convertCur)
	{
		$row->price = ereg_replace("[^.0-9]", "", $row->price);
		$row->price = $row->price *  $row3->curUSD;
		$row->price = number_format($row->price, 2, '.', ',');
	}

	if(SEO_ENABLED=='true'){
			$output .= tep_href_link($productURL,$productParam . $row->id) . "\t" .
			preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" .
			preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" .
			$row->price . "\t" .
			$row->image_url . "\t" .
			$catIndex[$row->prodCatID] . "\t" .
			$row->id;
	}else{
	  $output .= $row->product_url . "\t" .
	  preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" .
	  preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" .
	  $row->price . "\t" .
	  $row->image_url . "\t" .
	  $catIndex[$row->prodCatID] . "\t" .
	  $row->id;
	}

//optional values section
if($optional_sec == 1)
{
	if($instock == 1)
	{
		if($row->prodStatus == 1)
		{
			$prodStatusOut = "Y";
		}
		else
		{
			$prodStatusOut = "N";
		}
		$output .= " \t " . $prodStatusOut;
	}
	if($shipping == 1)
		$output .= " \t " . $lowestShipping;
	if($brand == 1)
		$output .= " \t " . $row->mfgName;
	if($upc == 1)
		$output .= " \t " . "Not Supported";
	if($manufacturer_id == 1)
		$output .= " \t " . "Not Supported";
	if($product_type == 1)
	{
		$catNameTemp = strtolower($catName);
		if($catNameTemp == "books")
			$productTypeOut = "book";
		else if($catNameTemp == "music")
			$productTypeOut = "music";
		else if($catNameTemp == "videos")
			$productTypeOut = "video";
		else
			$productTypeOut = "other";

		$output .= " \t " . $productTypeOut;
	}
	if($currency == 1)
		$output .= " \t " . $default_currency;
	if($feed_language == 1)
		$output .= " \t " . $default_feed_language;
	if($ship_to == 1)
		$output .= " \t " . $default_ship_to;
	if($ship_from == 1)
		$output .= " \t " . $default_ship_from;
}
$output .= " \n";
}
$already_sent[$row->id] = 1;


$loop_counter++;
if ($loop_counter>750) {
$fp = fopen( $OutFile , "a" );
$fout = fwrite( $fp , $output );
fclose( $fp );
$loop_counter = 0;
$output = "";
}
}

$fp = fopen( $OutFile , "a" );
$fout = fwrite( $fp , $output );
fclose( $fp );
echo "File completed: <a href=\"" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a><br>\n";
chmod($OutFile, 0777);

/*
//Start FTP to Froogle

function ftp_file( $ftpservername, $ftpusername, $ftppassword, $ftpsourcefile, $ftpdirectory, $ftpdestinationfile )
{
// set up basic connection
$conn_id = ftp_connect($ftpservername);
if ( $conn_id == false )
{
echo "FTP open connection failed to $ftpservername <BR>\n";
return false;
}

// login with username and password
$login_result = ftp_login($conn_id, $ftpusername, $ftppassword);

// check connection
if ((!$conn_id) || (!$login_result)) {
echo "FTP connection has failed!<BR>\n";
echo "Attempted to connect to " . $ftpservername . " for user " . $ftpusername . "<BR>\n";
return false;
} else {
echo "Connected to " . $ftpservername . ", for user " . $ftpusername . "<BR>\n";
}

if ( strlen( $ftpdirectory ) > 0 )
{
if (ftp_chdir($conn_id, $ftpdirectory )) {
echo "Current directory is now: " . ftp_pwd($conn_id) . "<BR>\n";
} else {
echo "Couldn't change directory on $ftpservername<BR>\n";
return false;
}
}

ftp_pasv ( $conn_id, true );
// upload the file
$upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII );

// check upload status
if (!$upload) {
echo "$ftpservername: FTP upload has failed!<BR>\n";
return false;
} else {
echo "Uploaded " . $ftpsourcefile . " to " . $ftpservername . " as " . $ftpdestinationfile . "<BR>\n";
}

// close the FTP stream
ftp_close($conn_id);

return true;
}

ftp_file( $ftp_server, $ftp_user_name, $ftp_user_pass, $source_file, $ftp_directory, $destination_file);

//End FTP to Froogle
*/

//  End TIMER
//  ---------
$etimer = explode( ' ', microtime() );
$etimer = $etimer[1] + $etimer[0];
echo '<p style="margin:auto; text-align:center">';
printf( "Script timer: <b>%f</b> seconds.", ($etimer-$stimer) );
echo '</p>';
//  ---------

?>

Share this post


Link to post
Share on other sites

docprego: check to see if froogle provides more details as to why those products aren't showing up. they usually provide details product by product if there is an issue.

 

magicsenses: double check your server paths.

 

killerwhale65: please post the first 5 lines of your feed.

 

Tsuri Japan: check your sql info again... are you sure it's localhost?

 

Load-This: it doesn't actually convert the currency, it specifies the currency to use in osC. the conversions should be done by osC provided you have set it up.


Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites
Warning: mysql_connect(): Unknown MySQL Server Host 'mysqlfilesecureservernet' (0) in /home/content/m/y/w/mywebpage/html/store/admin/froogle.php on line 108

Error when connecting itself to the data base

 

We are switching our hosting over from a dedicated server, to a shared server on Godaddy, and seeing as we now have to use numerically incremented files off of the "secureserver.net" I cannot use localhost for accessing the mysql, but when I type in the name of mysql database, followed by "secureserver.net" I think the SEO is converting it, and it won't allow me to access the database.. but.. I'm not sure.

 

if(SEO_ENABLED=='true'){
 $home=mysqlfile.secureserver.net;		  //  ****** revised these because we can....
 $user=user;
 $pass=password;
 $base=databasename;
}else{
 $home = "mysqlfile.secureserver.net";
 $user="user";
 $pass="password";
 $base="databasename";
}

 

 

...help? o.o?

Share this post


Link to post
Share on other sites

I ... stand corrected.

 

Apparently it just took me writing it out to see my own error.

I shouldn't of messed with the layout of the files under the SEO, they weren't designed for that.

I'll be quiet now.

 

<.<;;

...

 

=D I like uploading files. Smells like victory.

Share this post


Link to post
Share on other sites
killerwhale65: please post the first 5 lines of your feed.

 

hi, here are the first 5 lines:

 

product_url 	 name 	 description 	 price 	 image_url 	 category 	 offer_id
http://www.micro-wings.com/product_info.php?currency=USD&products_id=28	Emirates Airbus A380-800	Founded in 1985, this airline from the Emirate of Dubai has developed splendidly, thanks to the country's oil wealth. It is therefore little wonder that Emirates has ordered no less than fourty-five of the jets, which will be delivered to Dubai starting 2006. A model of this future jet will now be released with the registration A6-EDA.	20.73	http://www.micro-wings.com/images/herpa_514521.png	Herpa Wings 1:500 > Airbus	28 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=29	Etihad Airways Airbus A330-200	Etihad from Abu Dhabi, founded in 2003, has reached the title of the fastest growing airline of all time. It started its operations with three super modern A330-200s.	18.75	http://www.micro-wings.com/images/herpa_514538.png	Herpa Wings 1:500 > Airbus	29 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=30	SN Brussels Airlines Airbus A330-300	Following the bankruptcy of Belgium?s national airline Sabena, its former subsidiary Delta Air Transport (DAT) took over the European route network. In the meantime, DAT has been renamed SN, and even serves the traditional Sabena routes to the former Belgian colonies in Africa. Sabena?s well-known ?S? logo was adopted, along with the airline?s three A330-300s.	18.64	http://www.micro-wings.com/images/herpa_508582.png	Herpa Wings 1:500 > Airbus	30 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=32	Air Madagascar Boeing 767-300	Since the country's current president came into office in 2002, the huge island state in the Indian Ocean has become more stable. This former French colony is on the way to a brighter future, just like its airline. Its flagship jet is mostly operated on the routes to Paris, Milan, and Bangkok.	16.61	http://www.micro-wings.com/images/herpa_506083.png	Herpa Wings 1:500 > Boeing	32 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=35	Air France Concorde		14.48	http://www.micro-wings.com/images/herpa_507028.png	Herpa Wings 1:500 > Aerospatiale	35 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=43	Gift Certificate 25?		26.04	http://www.micro-wings.com/images/gift_25.png	Waardebonnen	43 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=44	Gift Certificate 10?		10.41	http://www.micro-wings.com/images/gift_10.png	Waardebonnen	44 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=45	Gift Certificate 50?		52.08	http://www.micro-wings.com/images/gift_50.png	Waardebonnen	45 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=48	Germanwings Airbus A319 "Bearbus"	Three years ago, Germanwings started operations as a low-cost airline from Cologne/Bonn airport with four Airbus A319s from the Eurowings fleet. In the meantime there are now 22 A319s in service and 19 more on order. Since 2005, Germanwings has also been flying from Berlin and Hamburg in addition to its hubs in Stuttgart and Cologne/Bonn and decorated their A319-100 D-AKNO with a bear, the heraldic animal of the German capital.	15.51	http://www.micro-wings.com/images/herpa_509107.png	Herpa Wings 1:500 > Airbus	48 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=49	ADAC Dornier 328	Producer Fairchield Dornier developed the DO-328, the fastest turboprop regional plane of all times. From an engineering point of view this was brilliant, but the development costs drove Dornier into bankruptcy. Two years after they had stopped production, AvCraft resumed manufacturing the Dornier 328Jet. One user of this jet is the German Automobile Club ADAC.	13.02	http://www.micro-wings.com/images/herpa_515078.png	Herpa Wings 1:500 > Dornier	49 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=50	KLM Airbus A330-200	In the 1980s, KLM already operated Airbus A310-200 jets, which were later replaced by Boeing 767s, and the latter now by A330-200s. Six airplanes have been ordered, which also has something to do with new fleet policy coming from the Air France-dominated parent company Air France-KLM. The model comes with the registration PH-AOA.	18.69	http://www.micro-wings.com/images/herpa_514903.png	Herpa Wings 1:500 > Airbus	50 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=51	CSA Czech Airlines ATR-72	On high-demand shorthaul routes such as Prague-Berlin, CSA operates ATR-72 turboprops, which are more economical than any modern jet. The original of our model is OK-XFA, the first of four of its type introduced in 1992, named after the city of Cesky Krumlov.	13.49	http://www.micro-wings.com/images/herpa_508063.png	Herpa Wings 1:500 > ATR	51 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=52	DHL Airways Boeing 757-200F (new livery)	Although it was founded in 1969 in the USA, DHL today is mainly owned by the German Deutsche Post AG. The new company colors symbolize that the initially red and white courier service has merged with Deutsch

 

Froogle mentions an error on line 12: too few tabs - bad feed data:

1:product_url: http://www.micro-wings.com/product_info.php?currency=USD&products_id=50
2:name: KLM Airbus A330-200
3:description: In the 1980s, KLM already operated Airbus A310-200 jets, which were later replaced by Boeing 767s, and the latter now by A330-200s. Six airplanes h


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

FlyingMonkey: Froogle Merchant Center reports 325 for all of the following:

 

# of items processed # of items succeeded # of active items

 

 

But only 307 actually appear on Froogle. There are no errors anywhere.

 

Since that post I have added new products and uploaded a new feed to froogle. Now Froogle lists all 3 of those item data counts above as 350 which is accurate. But once again only 332 show up on Froogle, which is 18 less. Same exact amount as last time! None of the new products I added are among the missing. I do not know for certain if the items missing this time are the same as last time ( I suspect they are), I only know that the new ones all made it on to Froogle just fine. I painstakingly figured out which 18 are missing and checked them, there is nothing unusual in the feed about these products at all. I cannot see any reason why they are not listed.

Edited by docprego

Share this post


Link to post
Share on other sites
FlyingMonkey: Froogle Merchant Center reports 325 for all of the following:

 

# of items processed # of items succeeded # of active items

But only 307 actually appear on Froogle. There are no errors anywhere.

 

Since that post I have added new products and uploaded a new feed to froogle. Now Froogle lists all 3 of those item data counts above as 350 which is accurate. But once again only 332 show up on Froogle, which is 18 less. Same exact amount as last time! None of the new products I added are among the missing. I do not know for certain if the items missing this time are the same as last time ( I suspect they are), I only know that the new ones all made it on to Froogle just fine. I painstakingly figured out which 18 are missing and checked them, there is nothing unusual in the feed about these products at all. I cannot see any reason why they are not listed.

 

If no errors are show in the Froogle Merchant Center, then it's an issue with Froogle or the products just haven't all populated yet. Try contacting Froogle/Google directly.


Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites
hi, here are the first 5 lines:

 

product_url 	 name 	 description 	 price 	 image_url 	 category 	 offer_id
http://www.micro-wings.com/product_info.php?currency=USD&products_id=28	Emirates Airbus A380-800	Founded in 1985, this airline from the Emirate of Dubai has developed splendidly, thanks to the country's oil wealth. It is therefore little wonder that Emirates has ordered no less than fourty-five of the jets, which will be delivered to Dubai starting 2006. A model of this future jet will now be released with the registration A6-EDA.	20.73	http://www.micro-wings.com/images/herpa_514521.png	Herpa Wings 1:500 > Airbus	28 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=29	Etihad Airways Airbus A330-200	Etihad from Abu Dhabi, founded in 2003, has reached the title of the fastest growing airline of all time. It started its operations with three super modern A330-200s.	18.75	http://www.micro-wings.com/images/herpa_514538.png	Herpa Wings 1:500 > Airbus	29 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=30	SN Brussels Airlines Airbus A330-300	Following the bankruptcy of Belgium?s national airline Sabena, its former subsidiary Delta Air Transport (DAT) took over the European route network. In the meantime, DAT has been renamed SN, and even serves the traditional Sabena routes to the former Belgian colonies in Africa. Sabena?s well-known ?S? logo was adopted, along with the airline?s three A330-300s.	18.64	http://www.micro-wings.com/images/herpa_508582.png	Herpa Wings 1:500 > Airbus	30 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=32	Air Madagascar Boeing 767-300	Since the country's current president came into office in 2002, the huge island state in the Indian Ocean has become more stable. This former French colony is on the way to a brighter future, just like its airline. Its flagship jet is mostly operated on the routes to Paris, Milan, and Bangkok.	16.61	http://www.micro-wings.com/images/herpa_506083.png	Herpa Wings 1:500 > Boeing	32 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=35	Air France Concorde		14.48	http://www.micro-wings.com/images/herpa_507028.png	Herpa Wings 1:500 > Aerospatiale	35 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=43	Gift Certificate 25?		26.04	http://www.micro-wings.com/images/gift_25.png	Waardebonnen	43 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=44	Gift Certificate 10?		10.41	http://www.micro-wings.com/images/gift_10.png	Waardebonnen	44 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=45	Gift Certificate 50?		52.08	http://www.micro-wings.com/images/gift_50.png	Waardebonnen	45 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=48	Germanwings Airbus A319 "Bearbus"	Three years ago, Germanwings started operations as a low-cost airline from Cologne/Bonn airport with four Airbus A319s from the Eurowings fleet. In the meantime there are now 22 A319s in service and 19 more on order. Since 2005, Germanwings has also been flying from Berlin and Hamburg in addition to its hubs in Stuttgart and Cologne/Bonn and decorated their A319-100 D-AKNO with a bear, the heraldic animal of the German capital.	15.51	http://www.micro-wings.com/images/herpa_509107.png	Herpa Wings 1:500 > Airbus	48 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=49	ADAC Dornier 328	Producer Fairchield Dornier developed the DO-328, the fastest turboprop regional plane of all times. From an engineering point of view this was brilliant, but the development costs drove Dornier into bankruptcy. Two years after they had stopped production, AvCraft resumed manufacturing the Dornier 328Jet. One user of this jet is the German Automobile Club ADAC.	13.02	http://www.micro-wings.com/images/herpa_515078.png	Herpa Wings 1:500 > Dornier	49 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=50	KLM Airbus A330-200	In the 1980s, KLM already operated Airbus A310-200 jets, which were later replaced by Boeing 767s, and the latter now by A330-200s. Six airplanes have been ordered, which also has something to do with new fleet policy coming from the Air France-dominated parent company Air France-KLM. The model comes with the registration PH-AOA.	18.69	http://www.micro-wings.com/images/herpa_514903.png	Herpa Wings 1:500 > Airbus	50 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=51	CSA Czech Airlines ATR-72	On high-demand shorthaul routes such as Prague-Berlin, CSA operates ATR-72 turboprops, which are more economical than any modern jet. The original of our model is OK-XFA, the first of four of its type introduced in 1992, named after the city of Cesky Krumlov.	13.49	http://www.micro-wings.com/images/herpa_508063.png	Herpa Wings 1:500 > ATR	51 
http://www.micro-wings.com/product_info.php?currency=USD&products_id=52	DHL Airways Boeing 757-200F (new livery)	Although it was founded in 1969 in the USA, DHL today is mainly owned by the German Deutsche Post AG. The new company colors symbolize that the initially red and white courier service has merged with Deutsch

 

Froogle mentions an error on line 12: too few tabs - bad feed data:

1:product_url: http://www.micro-wings.com/product_info.php?currency=USD&products_id=50
2:name: KLM Airbus A330-200
3:description: In the 1980s, KLM already operated Airbus A310-200 jets, which were later replaced by Boeing 767s, and the latter now by A330-200s. Six airplanes h

 

hmm... the feed seems fine. Check to date the feed was processed in the Froogle Merchant Center and ensure it's one created by the Feeder. Lemme know how it goes.


Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites
hmm... the feed seems fine. Check to date the feed was processed in the Froogle Merchant Center and ensure it's one created by the Feeder. Lemme know how it goes.

 

 

hi, yes it was created by the feeder. I used nothing else so far. Sent it several times already but get the same error always. And the error always mentions the same lines.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

Hi all.

I installed contrib. , I am receiving data from froogle and Google base in my feeds folder. I uncomment ftp and it says success for Google base and for Froogle it says wrong password or username (I think I have to wait for that to work). Anyway I uploaded those files manually, and for froogle it says

 

Outcome: Feed contains some errors - help

 

Number of items processed: 3382

Number of items succeeded: 3382

Number of active items: 0

 

Feed file name: froogle-outfile.txt

Uploaded at: 05/29/06 10:50

Processed at: 05/29/06 12:10

Errors

 

Line # ▼ Error Bad feed data

Feed not approved to go live - help

 

 

So I guess I am waiting for approval right?

But in google base I have :

 

Status File name Type Expires Uploaded Processed Items Errors

Failure - help - details googlebase-outfile.txt Products Jun 29, 2006 6:30am PDT May 30, 2006 6:30am PDT May 30, 2006 6:31am PDT 0 0

 

I guess something is wrong.

Please someone let me know what is going one.

Than you all.

Share this post


Link to post
Share on other sites
hi, yes it was created by the feeder. I used nothing else so far. Sent it several times already but get the same error always. And the error always mentions the same lines.

 

 

Ok now i got an email from Froogle saying that my prices are wrong. They refered to a product that is discounted, so i think here lies the problem. What can i do about it?


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

and i always get a "page cannot be displayed" when i click on Froogle on the shops admin page. The feed is however created, but i dont know if its uploaded so i upload it by hand to be sure.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

hmm. the feed your uploading is probably not generated by the feeder then. try deleting the feed. run the feeder and check to see if a feed is created...

 

If there is still an issue, I suggest using the feeder i personally released without SEO.

Edited by FlyingMonkey

Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites

I don't know about the rest of you but I followed the instructions to log in to Google Base to update my froogle feed as instructed in today's email from Google and got the message 'Forbidden'.

Share this post


Link to post
Share on other sites

i have no other way of creating a feed so i wouldnt know what else would create the feed. I deleted the feed, and after running froogle.php the feed appears in /feeds, however the froogle.php ends up in a "page cannot be displayed".


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites
I don't know about the rest of you but I followed the instructions to log in to Google Base to update my froogle feed as instructed in today's email from Google and got the message 'Forbidden'.

 

i have the same.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

It seems we can upload our Froogle feed as usual and now products go into Google Base as well as Froogle.

 

.....BUT.... it seems the Froogle file is being processed by the MUCH fussier Google Base upload/server. I was getting 100% success on Froogle feeds, but that instantly dropped to about 50% after the changeover. The errors are all "An invalid encoding was specified for the bulk upload file", which the Help elaborates as "Your bulk upload contains an invalid UTF-8 character.". Most of the failed items contained a "?" in the description. As an experiment I converted them to "GBP " and they uploaded successfully. Unfortunately this still leaves odd characters that cause errors. I think the real solution is to use something like utf8_encode, iconv, recode or mbstring in the code, but I don't know which yet (and probably won't have time to get back to this for a while).

 

Hope this enlightens others wondering why their feeds are now erroring.

 

aNNa

Share this post


Link to post
Share on other sites
I think the real solution is to use something like utf8_encode, iconv, recode or mbstring in the code, but I don't know which yet (and probably won't have time to get back to this for a while).

 

Update:

I tried utf8_encode & that sorted out the "?"s, but some products appeared in Google Base with undefined characters that I think were originally long "em" dashes. So there's more to do, and I'm really not going to come back to this for a while.

 

Happy weekend folks!

anNA

Share this post


Link to post
Share on other sites

Hello, Great contribution, Set it up and got it working the first time ... All was well until google rejected my feed :(

My question is how much traffic do you really get from froogle? Trying to decide if it is worth making the changes they want me to.

Share this post


Link to post
Share on other sites

Well every single line of my feed now has an error. The help file tells me what an integer is. It doesn't tell me why it is expecting an integer where froogle didn't though. The bad data in the video feed is 'NR'

 

'The value you entered is not a valid integer. Please be sure to enter a whole number value only. For example, "100" is a valid integer, but "100.01" is not.'

Edited by radders

Share this post


Link to post
Share on other sites

Sorted!

It seems that they have chaged the 'rating' parameter to be an integer, and the shipping now is in the format 'country_code::price'. The final piece of the jigsaw is getting rid of the single and double quotes in the UTF character set and replacing them with the ascii ones. I couldn't see how to do that automatically so had to edit all the affected entries. Oh well!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×