http://qs321.pair.com?node_id=402870


in reply to Adding Products automation

About the saving images, I wanted to save a product image from a another website to my server. Is that possible?? When parsing the website with the product image I want to retrieve, it'll look for the image file name.

Saving the image is easy so long as you can find it in the HTML source. I'll presume that you're willing to either use a HTML parser or that you know where the images are stored before hand. If this is the case then all you need to do is something like this:

#!/usr/bin/perl -w use LWP::Simple; use strict; my $image = getstore("http://www.perltraining.com.au/images/logo.png", "/tmp/logo.png") or die "no content?";

This gets the logo.png image from the perltraining.com.au website and stores it in your tmp directory. You will need to change that directory if you are on a Windows box.

Once you've saved the image then you'll need to work out what to do with it. Some e-commerce sites store the whole image in the database in blob format (heaven forbid) and others more sensibly store the filename.

Make sure that you scrutinise how oScommerce works with the database. In particular, if oScommerce is using InnoDB tables in MySQL then you should take advantage of that and use transactions in your code.

I've avoided the potential legal issues here. Make sure you have the right to copy those images and use them in your site. :)

I hope this helps.

jarich

Replies are listed 'Best First'.
Re^2: Adding Products automation
by perleager (Pilgrim) on Oct 27, 2004 at 04:23 UTC
    Hello,
    thank you all for replyin.

    Jarich, I think you understood my problem more and basically gave me what I needed to finish up this script. I never knew about the getstore command and how it can download a image to the tmp directory like that. Now that you gave me that example, I'm well on my way on finishing it. About the image being stored as a blob on the db, heck no =). I'll be parsing the image file name from the image url and store its filename in the db. And about the legal issue, the product images / info I'll be stealing is from my distributor main website which allows its retail members to use for such purposes. =)

    Anthony