Images embedding via hyperlink

[Arcadia1]

Hi,

I need to embedd about 15thsd pictures from one of my suppliers into my online shop.

They cannot provide the pictures via dvd or ftp.

I do have the links to all pics and importing via EP seems to fail due to character restrictions of 64, this much I could find here in the forum.

So the 64 needs to be changed to 90 or more as needed in the right file via phpmyadmin. I found phpmyadmin in my cpanel from my provider but am clueless of what to change how and where.

 

So a short tutorial form someone who knows would be awesome because I know htere are others who have the same problem here but did not get an answer.

 

Any help appreciated from a OSC rookie.

 

JJ

[♥kymation]

You need to change the products_image field in the products table for the small images, and the image field in the products_images table for the large images.

 

Regards

Jim

[Arcadia1]

Hi Jim,

 

I will happily do so if you tell me where I find that....?

[♥kymation]

In your database. Use your host's database management tool to make the changes. They should have instructions for using their tools.

 

Regards

Jim

[Arcadia1]

You are referring to the mysql database on my providers server, right?

If so, they do have the phpmyadmin installed and I was looking around and do not know where to find it. And of course I hate to mess it up ....;-)

 

JJ

[♥kymation]

Right. I have no idea where your host has their copy of phpMyAdmin, but it's probably somewhere on their control panel. Of course you should backup your database before making any changes.

 

Regards

Jim

[Arcadia1]

Ok,

 

I did set the value to varchar(200) in products table = products_image AND products_images table=image field

 

I did reload my shop page but still no pics show up.

 

Anything else to get that straight?

 

Thanks

JJ

[Arcadia1]

here a link that I have in EP:

http://www2.stevenshobby.com:5641/si/ProductFiles/pbp1003.jpg

 

and here is where it should show up for the large one:

http://hobbymarketusa.com/product_info.php?products_id=42858&osCsid=c1j0d924ne53jatuepp8oj4ob0

and for the small one:

http://hobbymarketusa.com/index.php?cPath=428_674_675&osCsid=c1j0d924ne53jatuepp8oj4ob0

[♥kymation]

osCommerce expects all images to be in the images/ directory. If you want to link to images on a remote site, you'll need to modify the code to look for those images at that remote location. You also need to have the permission to hotlink those images as this will load up the remote server.

 

Hotlinking remote images is not recommended for a number of reasons.

 

Regards

Jim

[Arcadia1]

Hi Jim,

I think we are turning in circles here. My posting clearly states that my supplier is unable to provide the images via dvd/cd-rom or ftp access. Yet I am allowed to link to them.

And yes, I already have over 30thsd images in the images folder. But I need to add about 15thsd links to images.

First you tell me I have to change the mysql data base. So I did but showing no results.

Now you tell me I have to change "the code" and I am willing to do so.

Is there anybody here in this community who achieved this goal?

 

Please let me know how to do it .

 

Thank you

JJ

[♥kymation]

Sorry my answers did not meet your high standards. I'm just trying to help.

 

You now say that you have images for some products already in your images folder, but you want to add more images remotely. How is osCommerce supposed to know which is which? You would need to add a field or two to the database to give it the location of each image. You'll also have to modify the osCommerce code, in multiple locations, to use that information. You will also have to modify the osC admin to use the correct location when you are changing/updating products there.

 

This is more than a simple help question that this forum is intended to answer. What you want is a custom coded addon. I would give you the code if I had it, but I don't, and I don't know of anyone who has done this.

 

Regards

Jim

[Arcadia1]

Hi Jim,

maybe you think to complicated here.

I have an old and outdated shopsoftware html based only. There I can put in the file name and it get the image from the image folder, I can even let the SW search for images to a product.

But if I enter simple url to an image it will show me just that image and not look in the image folder.

 

I do not really understand why this simple solution is such a big deal with an up to date open source program ! I am not the first having this problem and maybe other people who would love to use OSC would IF they do not need to or simply cannot upload thsds of images into a folder.

 

Also, how come that somehow it is possible to link to a youtube video but not to a simple image? Talking about the multiple image solution in 2.3.3. or so.

I am a rookie and would like to maintain my simple world with simple solution for users, not programmers.

I do not mind finding my way through some code and change to fit as needed but somehow I get the feeling that a lot explained here in the forums is for programmers and not for "users".

 

Or can I simply insert the url to an image into the ep as lets say image 3 or 4 and instead of the youtube vid I will see an image?

 

No one ever tried this out?

 

JJ

[♥kymation]

You can insert the HTML code for a remote image into the HTML field for the large images. That will work on the Product Info page that uses large images. You will not see any image where the small images are used as that is looking in the images/ directory. Is that good enough for you?

 

Regards

Jim

[Arcadia1]

Hi Jim,

we are getting there. Btw, do not think I am ungrateful for your input ! English is my second language and even my wife tells me I do not express myself as "polite" as americans do....lol....It is just not given to me.

So to sum it up:

 

Thumbnail AND large images are being showed if they are in the pre-set images (sub-) folder.

Large images can also be linked to but will NOT show as thumbnails. They will show on the product page.

 

So I guess if I place a picture in the images folder thumbnail style that says: click for pic ! it should do the trick? (Am I a poet or what?)

That is a work around not perfect but I gues I gonna go this way until there will be a programm update. Because if it can be done for the "large" pic it should be possible for the thumbnail, too. I do not even understand why the programming is restricting this way.

 

Thank you Jim ! o:)

[Arcadia1]

Not yet solved,

I will ppost some screenshots etc. later.

Small icon pic shows on product page but it will not pop up the larger version of it !

http://hobbymarketusa.com/product_info.php?cPath=428_674_675&products_id=42856&osCsid=c1j0d924ne53jatuepp8oj4ob0

What the heck is that now?

 

JJ