| Author |
|
mustangcoupe
Super User
Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
|
| Posted: May 30 2005 at 19:52 | IP Logged
|
|
|
Dave is there a way to pull the data from the disc libary? I want to export the data to another database. Can I export it to a file?
Todd
__________________
Todd Hannemann
HA newbie 
 PowerHome - UPB - ELK
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: June 01 2005 at 12:22 | IP Logged
|
|
|
Todd,
Absolutely...you could do it a couple of different ways depending upon how want the data.
The first and easiest would be to just pull a "Discs" report off of the report menu. Leave all the boxes blank to retrieve everything. After the report is displayed, go to File->Export and export in the format of your choice (Excel, CSV, SQL, etc).
You can also retrieve the raw data using the SQL Report option. The data for the discs is contained within a couple of tables...discs and tracks. You could pull the info from each table and save as SQL for import into another database. Open the "SQL Query" window under the reports menu and enter "select * from discs" without the quotes. Hit "Do-it" and then export it as SQL from the File menu. Then enter "select * from tracks" and do the same.
Let me know if you need any help,
Dave.
|
| Back to Top |
|
| |
mustangcoupe
Super User
Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
|
| Posted: June 02 2005 at 10:52 | IP Logged
|
|
|
PERFECT Dave.... Now I see why Tomy Calls you DTG 
__________________
Todd Hannemann
HA newbie
PowerHome - UPB - ELK
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: sql command to pull data
