Support Forums

Some of the ad images/thumbs from other site?

This is a discussion on Some of the ad images/thumbs from other site? within the Technical Support forums, part of the Technical Support Forums category; At the moment i have a costumer who usually do a mass upload. So far i solved it via MYSQL ...


Go Back   68 Classifieds Forums > Technical Support Forums > Technical Support

Reply
 
Thread Tools Display Modes
Old 09-09-2010, 03:35 AM   #1
Customer
 
Join Date: Jun 2010
Posts: 15
Rep Power: 2
smog is on a distinguished road
Question Some of the ad images/thumbs from other site?

At the moment i have a costumer who usually do a mass upload. So far i solved it via MYSQL CSV importing. As the AD side its working pretty neat, and used the same (they corporate logo) AD image.

The problem is they asked if its possible to do the "mass upload" for the images aswell (differet picture for different ads), (via the same MYSQL CSV import method)

Since the pictures/thumbnails need to be on the site storage and even if i change the picture location "picture.jpg" for example "http://costumersite/uploads/picture.jpg" @ MYSQL it doesnt show it for me.

I can ask them to create they own thumbnails/normal pictures and store it on they own ftp, but is it possible to point to that site/image?

Hope i was clear.

Thanks for any support!
smog is offline   Reply With Quote
Old 09-09-2010, 07:55 AM   #2
curmudgeon
 
Join Date: Mar 2006
Posts: 5,290
Rep Power: 130
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

Images arent stored in the database, just their name is which is used in a URL to display the images. That being said, you can put the image name in the database as part of a csv upload BUT the process that uploads images during normal ad placement checks for duplicate names and assigns a new one if the original image name is in use. It also creates a thumbnail image and additionally resizes the original image.

Ive created scripts in the past that imported ads, checked for dup ads, uploaded photos, created thumbs etc etc but it was very site specific and complex. Also, depending on how many ads there are and how many images per ad the process can be pretty lengthy if your running on a low budget hosting plan.
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline   Reply With Quote
Old 09-09-2010, 08:13 AM   #3
All Hands On Deck
 
 
Join Date: Mar 2008
Posts: 2,832
Rep Power: 69
seymourjames is a jewel in the rough
Default

Yup - we do XML feeds which you can make from a csv file if you wish but you need dedicated hosting or a VPS as the process is CPU hungry. There are companies out there who will scrape the target web site and make an xml feed for you as well. Its a complicated process due to every site being different and therefore not cheap to develop and organize.

Bulk Uploading-Adverts Via Feeds
__________________
"The fool doth think he is wise, but the wise man knows himself to be a fool.".

TemplateCodes.com for 68 Classifieds
seymourjames is offline   Reply With Quote
Old 09-09-2010, 09:56 AM   #4
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,491
Rep Power: 131
Eric Barnes is just really nice Eric Barnes is just really nice
Default

I have also done this in the past and what I did was have them enter the full url to the image on their server and added that to the db. Then modified the script and if the image had "http" in it then just the show the full url to the image. That way I didn't have to store the images for them.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline   Reply With Quote
Old 09-13-2010, 07:31 AM   #5
Customer
 
Join Date: Jun 2010
Posts: 15
Rep Power: 2
smog is on a distinguished road
Default

Quote:
Originally Posted by Eric Barnes
I have also done this in the past and what I did was have them enter the full url to the image on their server and added that to the db. Then modified the script and if the image had "http" in it then just the show the full url to the image. That way I didn't have to store the images for them.
Thats what i wanna do. The problem is when i change the picture name in the database like picture.jpg to http://yoursite.com/images/picture.jpg it doesnt show me any pic only the text.

The product database sync is solved only the picture part is missing.
smog is offline   Reply With Quote
Old 09-13-2010, 08:13 AM   #6
curmudgeon
 
Join Date: Mar 2006
Posts: 5,290
Rep Power: 130
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

Quote:
Originally Posted by smog
Thats what i wanna do. The problem is when i change the picture name in the database like picture.jpg to http://yoursite.com/images/picture.jpg it doesnt show me any pic only the text.

The product database sync is solved only the picture part is missing.
Notice Eric said he MODIFIED THE SCRIPT.
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline   Reply With Quote
Old 09-15-2010, 02:57 AM   #7
Customer
 
Join Date: Jun 2010
Posts: 15
Rep Power: 2
smog is on a distinguished road
Default

Quote:
Originally Posted by Eric Barnes
I have also done this in the past and what I did was have them enter the full url to the image on their server and added that to the db. Then modified the script and if the image had "http" in it then just the show the full url to the image. That way I didn't have to store the images for them.
But in that case there will be no thumbnails, only text. Right?
smog is offline   Reply With Quote
Old 09-15-2010, 08:38 AM   #8
curmudgeon
 
Join Date: Mar 2006
Posts: 5,290
Rep Power: 130
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

Quote:
Originally Posted by smog
But in that case there will be no thumbnails, only text. Right?
It all depends on what you do, this is not a one size fits all scenario. If the other site has thumbs AND full size images you can alter the script to display them from the other site. If the other site doesnt have thumbs, your site wont make them. You may be able to get away with using the full size images as thumbs by simply pointing to the full size image for the thumb and restricting the display size at the html markup level but this often results in pretty poor images.
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline   Reply With Quote
Old 09-15-2010, 10:28 AM   #9
All Hands On Deck
 
 
Join Date: Mar 2008
Posts: 2,832
Rep Power: 69
seymourjames is a jewel in the rough
Default

Basically the only real way to do this perfectly is by running the checkout process in some form for each advert so that you scale your images correctly. The csv file is converted easily into an XML feed as a first step. The XML Feeds is then processed where the images are uploaded using in this case our multiple image uploader module and scaled per norm. We have the modules to do this but it is a time consuming and expensive thing to do. This is because every site structure is different - categories, extrafields, etc. We do not sell these modules generally as every job (site) is a custom undertaking. Depending upon complexity of your site structure we may be able to convert what we have for your application.
__________________
"The fool doth think he is wise, but the wise man knows himself to be a fool.".

TemplateCodes.com for 68 Classifieds
seymourjames is offline   Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
location of thumbs and photos MrGForce Customizations 28 02-10-2010 01:57 PM
Site Critiques: www.damiun.nl - a charity classifieds site damiun Site Critiques 3 12-03-2009 11:19 AM
Images Bo Sanchez Technical Support 3 02-06-2009 02:36 PM
Site with square blue folder cat images free2take Templates, HTML, CSS, and Design Help 0 09-25-2008 10:04 AM


All times are GMT -4. The time now is 08:33 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0