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