Welcome, Guest. Please login or register.
Login with username, password and session length

It's a release candidate! VirtueMart 2.0 RC - the next generation VirtueMart - is available! Read more....

  Advanced search

247038 Posts in 67506 Topics- by 258314 Members - Latest Member: aniketana
« previous next »
Pages: [1]   Go Down
Print
Author Topic: Export to excel?  (Read 2182 times)
starkyyz
Newbie
*
Posts: 8
« on: June 14, 2007, 13:07:53 PM »
Does anyone know if virtuemart can export to excel?  Or export to text, even?  Any export functions?

Thanks!
Logged
Toivo Talikka
Newbie
*
Posts: 17



WWW
« Reply #1 on: June 14, 2007, 15:19:10 PM »
Hi,

Here is a discussion and code to export orders in CSV format:
http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=24040.0

On the other hand, if you are handy with MySQL Administrator or MySQL Query Browse and have access to your database, you can export any table in Excel format: 

Under Schema Tables right click a table, select 'Edit Table Data' and then select File - Export resultset.  The options include:
  • Export as CSV file
  • Export as Excel file

Regards,
Logged
Toivo
-------------------------
Total Data Pty Ltd
Sydney, Australia
bikisek
Newbie
*
Posts: 4


WWW
« Reply #2 on: November 09, 2007, 12:49:49 PM »
1.Use Orders>upload CSV

2.Now set this symbol:

;
and
"

3. click to export order to CSV and save file to disk.
4. change code in PSPAD to win1250
5.open file in excel

good luck.. Smiley
Logged
Bikisek Smiley - Because open source matters

www.lovecke-potreby.eu
Pages: [1]   Go Up
Print
« previous next »
Jump to: