-=LRK=- Posted November 24, 2007 Posted November 24, 2007 New Installation, then customized to death. Now, apparently, when I use either CSV importer (I installed two of them) I get an extra space at the beginning of the Product Image. The CSV does not have the space, but then the SQL database does have it. I am pretty sure that buried somewhere in the code is an extra space causing the images/%20filename.jpg But I have looked manually, and with a Dreamweaver Search for anything I could think of. My first guess would be in admin/configure.php where the /images folder gets defined, but that's not it. The odd thing, is that if I edit the product in Admin, it shows up. If I update it, it fixes the naming problem. However, anything I batch CSV upload is screwed up. Any clues?
porpoise1954 Posted November 24, 2007 Posted November 24, 2007 New Installation, then customized to death. Now, apparently, when I use either CSV importer (I installed two of them) I get an extra space at the beginning of the Product Image. The CSV does not have the space, but then the SQL database does have it. I am pretty sure that buried somewhere in the code is an extra space causing the images/%20filename.jpg But I have looked manually, and with a Dreamweaver Search for anything I could think of. My first guess would be in admin/configure.php where the /images folder gets defined, but that's not it. The odd thing, is that if I edit the product in Admin, it shows up. If I update it, it fixes the naming problem. However, anything I batch CSV upload is screwed up. Any clues? Does your CSV file have the values seperated by comma - space by any chance? * * * * * * * * * * * * * * * * * * * * * Porpoises are most happy when wet! \ _ \ _ \ _ \ _ \ _ \ _ \ _ \ _ \ _ \ _ \ _ \ _
-=LRK=- Posted November 24, 2007 Author Posted November 24, 2007 Does your CSV file have the values seperated by comma - space by any chance? Nope, CSV is fine, SQL entry has space. Any other ideas?
Guest Posted November 24, 2007 Posted November 24, 2007 Nope, CSV is fine, SQL entry has space. Any other ideas? edit sql
-=LRK=- Posted November 24, 2007 Author Posted November 24, 2007 edit sql If I want to make a price change to my Product Database in Excel then batch upload the changes, it will break all the Image links again. So, Of course, I'd like to find the problem and just fix it. I'm still looking, but so far no luck.
-=LRK=- Posted November 24, 2007 Author Posted November 24, 2007 If I want to make a price change to my Product Database in Excel then batch upload the changes, it will break all the Image links again. So, Of course, I'd like to find the problem and just fix it. I'm still looking, but so far no luck. Turns out, it was Excel tagging the image with a HyperLink. Once I removed the Hyperlinks, it exported properly.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.