Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 04-17-2009 12:36:32
- kev
- Member
- Registered: 03-16-2009
- Posts: 399
Exporting orders out of CCP6 as a CSV file
Hi,
I know that there are 'orders' and 'orderitems' tables in Home > Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin and have exported orders and orderitems as CSV files using the export function. However, I would like to be able to get the order information exported as 1 CSV file that contains both the order and orderitems together (hope I'm explaining this ok!).
Order 1
order item 1
order item 2
Order 2
order item 1
order item 2
order item 3
order item 4
etc
I think that I can do this from here Raw Database Admin???
But don't know what to write in the SQL Statement box?
Could somebody please provide some advice on how to do this.
Thanks,
Kev
Offline
#2 08-26-2010 07:04:25
- sushisushi
- Member
- From: barnsley, UK
- Registered: 06-26-2008
- Posts: 88
- Website
Re: Exporting orders out of CCP6 as a CSV file
Bump
Buy sushi making ingredients, sushi party kits and Japanese food at wwwsushisushi.co.uk
Offline
#3 08-26-2010 07:18:01
- Dave
- Member
- Registered: 07-05-2003
- Posts: 11233
Re: Exporting orders out of CCP6 as a CSV file
You really can't do that with SQL calls especially not with the results in the order shown. You would have to write some code to manipulate the result sets to get things in that order which implies exporting both of the tables then writing some code to process them to arrive at the desired output.
Offline
#4 08-26-2010 17:54:54
- Design_Wholesale
- Member
- From: England!
- Registered: 11-21-2008
- Posts: 1104
- Website
Re: Exporting orders out of CCP6 as a CSV file
Use something like PHPMyAdmin or the like and submit a MySQL statement using the JOIN function. - Not a MySQL guru myself, but I know that what you want can be done with any decent database manipulation software that will allow you to make and merge, or dump to a single file, database calls.
Last edited by Design_Wholesale (08-26-2010 17:55:22)
Offline
#5 08-27-2010 03:05:45
Re: Exporting orders out of CCP6 as a CSV file
I would try creating a 'view' with the combined data from the two tables, then try exporting that - if the direct export from a query does not work.
Nigel
| Professional Quality Customisable Skins for your ClickCartPro Powered Site
-----------------------------
Certified Support Partner
Offline
#6 08-27-2010 06:00:21
- Dave
- Member
- Registered: 07-05-2003
- Posts: 11233
Re: Exporting orders out of CCP6 as a CSV file
You can GET the data requested with a single call but I'm reasonably certain you won't be able to get the data in the sequence shown using just SQL.
Offline