The Official Website of AgoraCart and Agora.cgi
AgoraCart.com Demos Download AgoraCart User Manuals & Wiki Gold Members Forum Go Gold Now! Gold Version Memberships
Shop Live Sites | iMegaMall.com | AgoraPros.com | AgoraPay | WebHosting Search | SnooperClick.com Search

AgoraCart.com

• About
• Features
• Download
• Payment Gateways
• Send a Donation
• Founders Club
• BLOG: News & Updates

Showcases & Demos

• AgoraCart Demos
• Shop Live Stores

Downloads & Add-ons

• Gold Version Downloads
• DBwizz Database Mgr.
• AgoraCart.com Store

Help & Support

• User Manuals
• Gold Version Users Forum
• Gold Version Chat
• Tech Support
• Certified Agora Pros
• Certified Designers
• Hire a Freelancer

Gold Version Members

• Member Benefits
• Join Today!
• Gold Members Home
• Gold Version Users Forum
• Gold Version Chat Rooms
• Gold Version Downloads

For Store Owners

• Merchant Accounts
• Cool Resources
• Advertise Here
• "Powered by" Logos
• Web Hosting Search

Misc.

• Contact Us
• MEET's Talking Guide
• The Ancient Greek Agora

AgoraCart Free User Forums

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software


Official Sponsors of the AgoraCart Project:

       


Register • Search • FAQ • Log in

AgoraCart Free User Forums Forum Index » Misc Product / Database » Problem importing images from flat file

The time now is Thu May 02, 24 5:11 am
View previous topic | View next topic
Reply to topic Page 1 of 1
Problem importing images from flat file
Author Message
enchant
Newbie - Two Blades
Joined: 31 Aug 2005
Posts: 20
Reply with quote
Post Problem importing images from flat file 
I have a customer's database in a flat file, and I'm trying to import it into Agora. Here is a sample line from the file:

JE-0002|Jewelry|93.57|Pearl set|<img src="pearl.jpg">|Pearl earring set|2.00|<img src="pearl-tn.jpg">|

When I import the file and edit any product using the Store Manager, the Image File (column 5) shows like this:
<img src=

After a lot of playing around, I discovered that if I edit the flat file and remove the quotes:
JE-0002|Jewelry|93.57|Pearl set|<img src=pearl.jpg>|Pearl earring set|2.00|<img src="pearl-tn.jpg">|
...things improve, but they're not perfect:
<img src=pearl.jpg
Notice it's missing the closing angle bracket.

After a lot of screwing around, I found this interesting but unhelpful thing. If I alter the last letter of the image file to something other than 'g', the tag completes. e.g.:
JE-0002|Jewelry|93.57|Pearl set|<img src=pearl.jpx>|Pearl earring set|2.00|<img src="pearl-tn.jpg">|
And editing the product shows that field as:
<img src=pearl.jpx>

FWIW, the other image tag shows up just fine in the "2nd Image" field.

I know I'm probably doing something wrong, but I can't figure it out for the life of me.
Wed Dec 21, 05 6:40 am View user's profile Send private message
Dan
Guest



Reply with quote
Post  
probably the best way to do this is to set up your image manager the way you want it done. for example you may want your product images here...
public_html/prodimg
this will work best for froogle. suppose you have tons of images and want them in folders sorted by category names...
public_html/prodimg/rings
public_html/prodimg/bracelets
you can do that too.
suppose you want to run all of your images through the store/html/images folder. that's ok too. whatever the case, set up a couple of products with the means of image path you want. get it working then export the dB or just download the data.file. take a look at how the manager writes the data to the dB and use that as a template.
dan
Wed Dec 21, 05 7:00 am
scottcrew
Moderator
Joined: 13 Feb 2004
Posts: 7516
Location: The West Side of MI USA

Reply with quote
Post  
Your database file should look more like:
JE-0002|Jewelry|93.57|Pearl set|<img src="%%URLofImages%%/pearl.jpg" BORDER=0>|Pearl earring set|2.00|%%IMG%%pearl-tn.jpg|||||%%OPTION%%blank.html

HTH!


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
Wed Dec 21, 05 7:17 am View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
scottcrew
Moderator
Joined: 13 Feb 2004
Posts: 7516
Location: The West Side of MI USA

Reply with quote
Post  
Your database file should look more like:
JE-0002|Jewelry|93.57|Pearl set|<img src="%%URLofImages%%/pearl.jpg" BORDER=0>|Pearl earring set|2.00|%%IMG%%pearl-tn.jpg|||||%%OPTION%%blank.html

HTH!


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
Wed Dec 21, 05 7:19 am View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
enchant
Newbie - Two Blades
Joined: 31 Aug 2005
Posts: 20
Reply with quote
Post  
Thanks Bonnie - Looks like it's working now.
Wed Dec 21, 05 8:04 am View user's profile Send private message
Display posts from previous:

AgoraCart Free User Forums Forum Index » Misc Product / Database » Problem importing images from flat file

The time now is Thu May 02, 24 5:11 am | All times are GMT - 7 Hours
 
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Another K-Factor Technologies, Inc. Web Site     © Copyright 1999 - 2005