Skip to main content

Import images into Magento database without using Magento core files.

here code is to import images into magento databse without using any core files.
this is for product's images. you can modify it for gallery images also.
here all the images took from media/import and copied to that perticular directory.

you can find here,how images created there directory structure.

if images name is example.gif,then will create directory structure like e/x/example.gif.
that is means this images will copy to media/catalog/product/e/x/example.gif
and the value /e/x/example.gif will insert into table catalog_product_entity_varchar.you can see this image at fronend to that perticular product.Actaully i did script to imaport product with catagory,attribute,images,description.... etc
it is nothing but a cron job.i took only import images part from my script.

$LargeProductImageURL=$LargeImageURL!=""?basename($allData[$key]->LargeImageURL):"";

$first_2_letter = substr("$LargeProductImageURL", 0,2);
$first_letter = substr("$first_2_letter", 0,1);
$second_letter = substr("$first_2_letter", -1);
$product_image ="/".$first_letter."/".$second_letter."/".$LargeProductImageURL;

$product_path=$media_path."".$slash."catalog\product";
$import_images=$media_path."".$slash."import".$slash."".$LargeProductImageURL;
$mypath1=$product_path."".$slash."".$first_letter;
if(!is_dir($mypath1))
{
mkdir($mypath1,0777,TRUE);
}
$mypath2=$product_path."".$slash."".$first_letter."".$slash."".$second_letter;
if(!is_dir($mypath2))
{
mkdir($mypath2,0777,TRUE);
}
//copy ( string $source , string $dest [, resource $context ] )
$Image_dest=$mypath2."".$slash."".$LargeProductImageURL;
@copy($import_images,$Image_dest);

#####check Is images are ready for copy or not
if (file_exists($import_images)) {
$product_image = $product_image;
}
else {
$product_image="no_selection";
}
#######
$UrlKey = strtolower(str_replace(" ","-",$PName));
$URL_path= $PName.".html";

/*if(empty($LargeProductImageURL))
{$product_image="no_selection";}*/

$db_obj->query("INSERT INTO catalog_product_entity_varchar(entity_type_id, attribute_id,store_id,entity_id,value) VALUES
('".$catalog_product."','56','0','".$entity_id."','".$PName."'),
('".$catalog_product."','82','0','".$entity_id."','".$UrlKey."'),
('".$catalog_product."','469','0','".$entity_id."','2'),
('".$catalog_product."','67','0','".$entity_id."','".$PName."'),
('".$catalog_product."','69','0','".$entity_id."','".$PName."'),
('".$catalog_product."','70','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','71','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','72','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','86','0','".$entity_id."',''),
('".$catalog_product."','90','0','".$entity_id."',''),
('".$catalog_product."','92','0','".$entity_id."','container2'),
('".$catalog_product."','95','0','".$entity_id."',''),
('".$catalog_product."','96','0','".$entity_id."',''),
('".$catalog_product."','97','0','".$entity_id."',''),
('".$catalog_product."','83','0','".$entity_id."','".$URL_path."')", $db_conect);

regard
Manoj Ninave

Comments

Post a Comment

Popular posts from this blog

Import Customers by csv file in Magento

Import Customers by csv file in Magento here i developed script to import customers in magento by csv file. csv file have following columns ########customerid (unique key) accesskey (customer type) emailaddress password firstname lastname companyname billingaddress1 city state postalcode country phonenumber faxnumber ########### here i didn't use any magento's core file. code is given below,i hope it will help you :) set_time_limit(36000); error_reporting(0); /** * @Use Script to import customer's data in Magento Database * @createDate Mar 2010 * @author Manoj Ninave (manojninave@gmail.com) **/ define("DB_HOST","localhost",TRUE); // database server name define("DB_USER","root",TRUE); // database user define("DB_PASS","",TRUE); // database user's password define("DB_NAME","dbname",TRUE); // database name require_once('db.class.php'); if( !isset($db_obj) ) {...
3 comments
Read more

How to get detail information about facebook user

Solution to get Detailed information about facebook user. 1) First you need to log in to the Facebook Developer application: Go to the Facebook Developer AppAfter following the link, click “Allow” to let the Developer application access your profile. 2) Begin setting up a new application. Go to the Developer application and click “Set Up New Application”. Give your application a name, check to accept the Terms of Service, then click Submit. You’ll see some basic information about your application, including: but for that you will need PHP client library you can download “PHP client library” after clicking the above link. for detail information see get started * Your API key: this key identifies your application to Facebook. You pass it with all your API calls. * Your application secret: Facebook uses this key to authenticate the requests you make. As you can tell by its name, you should never share this key with anyone. code: require_once ‘facebook.php’; $appapikey = ‘Your API Key’; $a...
2 comments
Read more

PHP Birthday

This information took from http://www.sitepoint.com/ PHP was released by Rasmus Lerdorf on June 8, 1995. His original usenet post is still available online if you want to examine a computing artefact from the dawn of the web. Many of us owe our careers to the language, so here’s a brief history of PHP… PHP originally stood for “Personal Home Page” and Rasmus started the project in 1994. PHP was written in C and was intended to replace several Perl scripts he was using on his homepage. Few people will be ancient enough to remember CGI programming in Perl, but it wasn’t much fun. You could not embed code within HTML and development was slow and clunky. Rasmus added his own Form Interpreter and other C libraries including database connectivity engines. PHP 2.0 was born on this day 15 years ago. PHP had a modest following until the launch of version 3.0 in June 1998. The parser was completely re-written by Andi Gutmans and Zeev Suraski; they also changed the name to the recursive “PH...
1 comment
Read more