Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

getting pics out of db

 
Reply
   X-Cart forums > Forum FAQs and guides
 
Thread Tools Search this Thread
  #21  
Old 02-04-2005, 08:38 AM
 
mark_d mark_d is offline
 

Advanced Member
  
Join Date: Jun 2003
Posts: 39
 

Default

Hello all,

I'm trying to get the images to be stores NOT IN FILES directory,

I want the here.

WEB ROOT
..IMAGES/Thumb
..IMAGES/detail
..XCART DIR

So, the directory for the images is at the same directory level as x-cart.

I see how I can change the template files to display the to the customer. BUT, why does the full paths that are asked (durring import, products and detail images) for not being used, if they HAVE to be in the x-cart/FILES directory, why ask for the full path?

Also, I did a complete install of the V4.0.11 and the config.php had that extra last line feed inthe config.php - no one fix that for how many versions..??

Any input/direction/enlightenment would be greatly appreciated.

Mark
__________________
X-Cart V3.3.6 - w/ Product Import Mod
Unix
---------------------------------------------
Currently migrating to V4.0.11
Reply With Quote
  #22  
Old 02-04-2005, 09:23 AM
  rjcbear's Avatar 
rjcbear rjcbear is offline
 

X-Adept
  
Join Date: Jun 2004
Location: Alabama,U.S.A
Posts: 503
 

Default

Mark,

When you are importing your images using a cvs file X-cart uses the path to find and load the images into the DB. Once they are loaded in the DB they get assing a name that has to do with your product number and after you take them out of your DB they will be named as follows:

t_######.jpg for thumbnails
d_#####.jpg for detailed images

I hope this will help you

Kind regards,
Ricky
__________________
X-CART Gold version 4.0.14 & 4.1.11
Apache Version 1.3.29 (Unix)
EWDHosting-Quality X-cart Hosting
We will always sell you the right shoe and the left one is free.
Reply With Quote
  #23  
Old 02-04-2005, 09:29 AM
 
mark_d mark_d is offline
 

Advanced Member
  
Join Date: Jun 2003
Posts: 39
 

Default

My images were never in the database - I CANT toooo many for even for temp (10MB database size limit) So I want to import right into the file system.

But, thanks, I think what I needed to know is that (if I am correct?)

The paths asked at import ARE ONLY for importing and NOT for displaying?
In other words;

The full path to images specified durring product and detail image import, are ONLY to read and insert BLOB into the database when 'Stored in database' option is used.

Am I understanding correctly?


Thanks
Mark.
__________________
X-Cart V3.3.6 - w/ Product Import Mod
Unix
---------------------------------------------
Currently migrating to V4.0.11
Reply With Quote
  #24  
Old 02-06-2005, 07:44 PM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

OK, I followed the first post exactly, but everything failed...anyone have any ideas???

Thanks!
Danielle
__________________
Danielle
X-Cart Pro 4.0.10
X-Gift-Registry
X-AOM
Reply With Quote
  #25  
Old 02-24-2005, 08:12 AM
 
Dybbuk Dybbuk is offline
 

Advanced Member
  
Join Date: Feb 2005
Posts: 77
 

Default

Quote:
Originally Posted by cotc2001
Ok i've found out that it just won't export from the database to the filesystem BUT if i delete all detailed images from products and then change the image location and then upload a detailed image it WILL then place it into the file system.

Very, Very strange

Hi,

I had exactly the same problem affecting the thumbnail directory having already added images to the database.

The only way I could remove thumbnail images from the database in order to set up an image file directory was to install phpMyAdmin and truncate the xcart_thumbnails table in mysql. This cleared the images and allowed me to change the image location in xcart from database to file directory.

Works fine now.

DB
__________________
Version 4.0.16
Reply With Quote
  #26  
Old 02-24-2005, 02:15 PM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

And then you had to reupload all your pics right???
__________________
Danielle
X-Cart Pro 4.0.10
X-Gift-Registry
X-AOM
Reply With Quote
  #27  
Old 02-27-2005, 08:31 AM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

Can someone help me with this? I am trying to switch my pics to the file system, but they keep saying failed. My permissions are 777. I really do not want to have to reupload all my pics as I have a TON. Does anyone know I make the switch?

Thanks!
__________________
Danielle
X-Cart Pro 4.0.10
X-Gift-Registry
X-AOM
Reply With Quote
  #28  
Old 02-27-2005, 08:46 AM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

Whew OK I finally got them to move and it says success. BUT, the images are all still in my database. I tried the optimize table thing suggested earlier in this thread and it did nothing. Even worse, I tried deleting a few of the images from the database manually, and now the thumbnail isn't showing. I looked and all the images are in the file system like they're supposed to be. Why aren't they showing on the product?

Thanks!
__________________
Danielle
X-Cart Pro 4.0.10
X-Gift-Registry
X-AOM
Reply With Quote
  #29  
Old 02-27-2005, 08:49 AM
 
balinor balinor is offline
 

Veteran
  
Join Date: Oct 2003
Location: Connecticut, USA
Posts: 30,253
 

Default

Make sure they successfully transferred. You should now have images in your Files directory, and the Images location should say File System.
__________________
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
Reply With Quote
  #30  
Old 02-27-2005, 08:55 AM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

Yep, the images are in the folders in the file system and the image location says file system. It all worked perfectly except that the images are still coming from the database, because if I delete an image in the database, it makes the product image disappear.
__________________
Danielle
X-Cart Pro 4.0.10
X-Gift-Registry
X-AOM
Reply With Quote
Reply
   X-Cart forums > Forum FAQs and guides



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 08:07 PM.

   

 
X-Cart forums © 2001-2020