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

Order export format question

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 11-09-2005, 06:21 PM
 
creative xpress creative xpress is offline
 

Advanced Member
  
Join Date: Aug 2005
Posts: 71
 

Default Order export format question

When I export the orders into a delimited file I am getting a format that looks like this:

"7";"sku";"etc..";

how do I go about not getting the text qualifiers so that it looks like this:

7; sku; etc..;

Any Ideas? I have looked through both the tpl file and the php file and I can not see anywhere where it is controling this. Is this a function of the MySql db system?

Please help!
Cameron
__________________
Xcart
Version: 4.1.6
Reply With Quote
  #2  
Old 12-27-2005, 04:57 AM
 
balinor balinor is offline
 

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

Default

Pretty sure that's the way MySQL exports stuff to preserve the columns, as some of the tables contain items with ; and , in them.
__________________
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
Reply With Quote
  #3  
Old 02-08-2006, 10:27 AM
 
logoworks logoworks is offline
 

Member
  
Join Date: Sep 2004
Posts: 19
 

Default

I want to export a csv that is comma delimited but i need the information in a different order than what x-cart default outputs. Is there any way to tell x-cart to what order to put the information of the order.

For example instead of order#, sku, product name. I want product name, price, sku.

Hope this makes sense, and hope there is an answer.
__________________
-RR
x-cart version 4.4.4
Reply With Quote
  #4  
Old 02-08-2006, 11:07 AM
 
creative xpress creative xpress is offline
 

Advanced Member
  
Join Date: Aug 2005
Posts: 71
 

Default

You can change the order in the order_export.tpl . Just rearange the items listed into the order that you would like them in.
__________________
Xcart
Version: 4.1.6
Reply With Quote
  #5  
Old 02-08-2006, 11:07 AM
 
Shooter Shooter is offline
 

Advanced Member
  
Join Date: Dec 2005
Location: Hannibal, NY
Posts: 85
 

Default

Quote:
Originally Posted by logoworks
I want to export a csv that is comma delimited but i need the information in a different order than what x-cart default outputs. Is there any way to tell x-cart to what order to put the information of the order.

For example instead of order#, sku, product name. I want product name, price, sku.

Hope this makes sense, and hope there is an answer.

Heres the answer I paid for:

http://www.x-cart.com/xcart_manual/online/

Hope that helps you as mush as it did me. No! I hope it helps you more than it did me.. then you would have accomplished something.
__________________
v4,1.11 Gold
Affiliate
AOM
FancyCategories
RMA
SpecialOffers
Sales-n-Stats Live
Price Match
Checkout Specials
Testimonials
Recently Added-Shop points
Magnifier
Gift Registry
CDSEO
SnS <-- no longer supported -just ripped off for registration
Price Match
Product Manager
Tag Cloud
Glossary
Marketing Manager
On Sale
Customer Reward Points
Customer Referral Points.. and others

Shooter

Visit us at ShootersBilliards.com for all of your pool cue and billiards needs.
Reply With Quote
  #6  
Old 02-08-2006, 11:13 AM
 
logoworks logoworks is offline
 

Member
  
Join Date: Sep 2004
Posts: 19
 

Default

thanks creative express.

i also found this topic that helped.

http://forum.x-cart.com/viewtopic.php?t=10168
__________________
-RR
x-cart version 4.4.4
Reply With Quote
  #7  
Old 02-08-2006, 11:13 AM
 
logoworks logoworks is offline
 

Member
  
Join Date: Sep 2004
Posts: 19
 

Default

as for shooter. Sounds like you may need some counseling
__________________
-RR
x-cart version 4.4.4
Reply With Quote
  #8  
Old 02-08-2006, 01:33 PM
 
Shooter Shooter is offline
 

Advanced Member
  
Join Date: Dec 2005
Location: Hannibal, NY
Posts: 85
 

Default

Quote:
Originally Posted by logoworks
as for shooter. Sounds like you may need some counseling

I have had enough of that. What I really need are some tech support points
__________________
v4,1.11 Gold
Affiliate
AOM
FancyCategories
RMA
SpecialOffers
Sales-n-Stats Live
Price Match
Checkout Specials
Testimonials
Recently Added-Shop points
Magnifier
Gift Registry
CDSEO
SnS <-- no longer supported -just ripped off for registration
Price Match
Product Manager
Tag Cloud
Glossary
Marketing Manager
On Sale
Customer Reward Points
Customer Referral Points.. and others

Shooter

Visit us at ShootersBilliards.com for all of your pool cue and billiards needs.
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design



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 01:43 PM.

   

 
X-Cart forums © 2001-2020