24 replies to this topic

[xvoyance]

I upload my products images separately with FTP and put under catalog/images.
How could I tell OSC 2.3.1 when I create new products that their images are there?

Thanks.

[GemRock]

if you dont want to edit the product and let it upload the image which does two things: upload image and write image name to the db, then only way is enter the image name in the product table in the db.
Ken

[xvoyance]

GemRock, on 21 April 2012 - 01:43 PM, said:

if you dont want to edit the product and let it upload the image which does two things: upload image and write image name to the db, then only way is enter the image name in the product table in the db.
Ken

I also want to edit the products, since there are other fields need to fill out. So, how should I tell osc that the image is there?

[GemRock]

well, it sounds like you drove from a to b but then you decided you should take a coach/bus to go from a to b so you drove back to a and take a coach/bus. you try to tell the coach driver not to charge you because you already been to b early on but i guess you wont be successful. outcome: your first trip to b is a complete waste, or for your question, you ftp'ed the image to server is a complete waste, and there is no easy way such as a tick box to tell edit/add new not to upload iamge.



Ken

Edited by GemRock, 21 April 2012 - 03:42 PM.

[GoTTi]

are your images in consecutive order like 1.jpg, 2.jpg, 3.jpg, etc? if they are, use the easy populate addon and you would be on the right path to getting it done quickly.

[GemRock]

further to my comment, you can try to comment out the upload product image code in categories.php. i dont have the file at hand so cant tell you where they are.

Ken

[xvoyance]

GemRock, on 21 April 2012 - 04:10 PM, said:

further to my comment, you can try to comment out the upload product image code in categories.php. i dont have the file at hand so cant tell you where they are.

Ken

COMMENT OUT? sure, that is easy, i know how to do it. (You can actually leave it there.) But how to tell the system the file is there? That is my question.

[spooks]

As gotti said use easy populate, or phpMyAdmin but perhaps this thread will help you see better http://forums.oscommerce.com/topic/307356-oscommerce-road-map-for-the-newbies

[GemRock]

xvoyance, on 21 April 2012 - 11:39 PM, said:

...But how to tell the system the file is there? That is my question...

the answer is easy: as you say you are going to edit the product (or add new product for that matter), during the process, you browse to the image file on your local pc, then the system will save the image file name in the db w/o uploading it again to the server, that way, it will tell the system the file is there by matching the file you FTP'ed to server and the name of same file in the db. but if you want to detect whether files have been uploaded to server, if yes then no upload; if no then do the upload, then the whole thing wont be as easy as just comment out a file lines of code. it becomes complicated albeit still do'able (NOT worthy it at all imo).

Ken

[xvoyance]

spooks, on 22 April 2012 - 12:04 PM, said:

As gotti said use easy populate, or phpMyAdmin but perhaps this thread will help you see better http://forums.oscommerce.com/topic/307356-oscommerce-road-map-for-the-newbies

Could Easy Polulate support in-line input data
i.e. put my input data in the http command line like
http://www.mysite.com/catalog/easypopulate.php?product_model=1111&product_name="aasdsa"....
instead of file upload?

[spooks]

Such things can be done if only the get method is used and you ensure sessions remain (cookie use) but I suspect that uses post, read the add-ons documentation

Caution: pure use of the query string to pass data to the dBase is an invite to hackers

[xvoyance]

GemRock, on 21 April 2012 - 01:43 PM, said:

if you dont want to edit the product and let it upload the image which does two things: upload image and write image name to the db, then only way is enter the image name in the product table in the db.
Ken

Could you please tell me how to insert directly into the db? Thanks.

[GemRock]

you use phpMyAdmin (accessed from cpenal) to edit tables directly. after logging in to phpmyadmin, choose the db if there are more than one dbs, then select the products table, find the product you want to enter the product image, click Edit against the product in question, enter the file name of the product image into the field of products_image. if the image on the server is not directly under the images folder, ie, under sub-folder(s), then include the sub-folder(s) name(s) before the product image file name. click Save/Go button to save the entry.

if the image files are named in such a way that it uses the product name or model or product id, all of which are unique, then you can write a few lines of php code to insert product image name programmatically. the code can be saved as a php file and re-used every time after you FTP'ing images to server. it can be run is this way: http://www.yoursite.com/write_images_to_db.php. thats how i do it.

Ken

Edited by GemRock, 25 April 2012 - 07:37 AM.

[xvoyance]

GemRock, on 25 April 2012 - 07:37 AM, said:

you use phpMyAdmin (accessed from cpenal) to edit tables directly. after logging in to phpmyadmin, choose the db if there are more than one dbs, then select the products table, find the product you want to enter the product image, click Edit against the product in question, enter the file name of the product image into the field of products_image. if the image on the server is not directly under the images folder, ie, under sub-folder(s), then include the sub-folder(s) name(s) before the product image file name. click Save/Go button to save the entry.

if the image files are named in such a way that it uses the product name or model or product id, all of which are unique, then you can write a few lines of php code to insert product image name programmatically. the code can be saved as a php file and re-used every time after you FTP'ing images to server. it can be run is this way: http://www.yoursite.com/write_images_to_db.php. thats how i do it.

Ken

Sure, I know all what you said. I am trying the second way, i.e. writing a PHP to insert it directly into the DB.
But my question is how to write that code?
Can you write that line directly?

[jhande]

Forgive me for being so naive...

But why all these scripts to populate the database with product info & image details?

Either use osC's admin panel or the Easy Populate contribution.

Just sounds to me like you're trying to reinvent the wheel.

[xvoyance]

jhande, on 26 April 2012 - 01:02 AM, said:

Forgive me for being so naive...

But why all these scripts to populate the database with product info & image details?

Either use osC's admin panel or the Easy Populate contribution.

Just sounds to me like you're trying to reinvent the wheel.

Have you seen in a supermarket or a bookstore, which I am going to built, they use barcode scanner to scan the products and the products goes immediately into their computers, which is called "realtime".

EP is a batch processing.....People today have forgot what is "batch processing"

OSC admin panel could not retrieve the products information from libraries, such as google books or ISBNDB or OPENLIBRARY, not either their images. Furthermore, I do not want to fill out the form for 100000 books with possibility to make mistakes. 100000 books is only a mini (a scale less than nano, presumably you all know what is nano but not batch) book store!

Edited by xvoyance, 26 April 2012 - 01:33 AM.

[jhande]

Thank you for the explaination.

[xvoyance]

jhande, on 26 April 2012 - 01:54 AM, said:

Thank you for the explaination.

I have actually finished everything, i.e. fill out the form automatically, except the last step for image, which need to insert into DB directly.

I f you can help you I can achieve that quicker.

[GemRock]

the code can be downloaded from my website (see profile) on shop demo & test bed home page.

Ken

[xvoyance]

got it. investigating........

Edited by xvoyance, 26 April 2012 - 03:44 PM.