Re: [libreoffice-users] Re: Connection to SQL database

Below is an excerpt from the file referring to the donations_money 
table.  Obviously there are some ID fields, donation info fields 
(Amount, Date, etc.), a primary key field, etc.  Immediately after the 
table, there's the "dump" of all the data in that table.  I've only 
included one or two "records" from the dump, but there are many hundreds 
or even thousands of records.

There are quite a few tables in the file, many of which we don't need 
(past logins under the old system, for example).

Any wisdom on how to convert this data into CSV files?  I thought I'd 
need to either "open" it with MySQL or connect to it via Base. If I 
could convert it to CSV, I can do any cleanup and prep work in Calc or 
some other tool I'm more familiar with.

Thanks again, everyone!


Excerpt:


-- Table structure for table `donation_money`
--

DROP TABLE IF EXISTS `donation_money`;
CREATE TABLE `donation_money` (
  `dm_id` mediumint(9) NOT NULL auto_increment,
  `dm_resource_id` mediumint(9) default NULL,
  `dm_promise_id` mediumint(9) default '0',
  `dm_date` date default NULL,
  `dm_amount` float(10,2) default NULL,
  `dm_receipt_number` varchar(15) default NULL,
  `dm_donation_code` varchar(15) default NULL,
  `dm_appeal_code` varchar(15) default 'NONE',
  `dm_payment_code` 
enum('CHE','CRD','CAS','ACH','STK','PAY','INK','OTH') default NULL,
  `dm_mem_hon` enum('NUL','MEM','HON') default NULL,
  `dm_mem_hon_who` varchar(40) default NULL,
  `dm_foundation_code` varchar(15) default 'NONE',
  `dm_in_kind_desc` varchar(60) default NULL,
  `dm_comment` varchar(255) default NULL,
  `dm_send_thank_you` tinyint(1) default '1',
  `dm_in_thank_you_set` tinyint(1) default '0',
  `dm_from_distribution_id` mediumint(9) default '0',
  `dm_user_field1` varchar(50) default NULL,
  `dm_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
  `dm_created_by` varchar(15) default NULL,
  `dm_modified` timestamp NOT NULL default '0000-00-00 00:00:00',
  `dm_modified_by` varchar(15) default NULL,
  PRIMARY KEY  (`dm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `donation_money`
--


/*!40000 ALTER TABLE `donation_money` DISABLE KEYS */;
LOCK TABLES `donation_money` WRITE;
INSERT INTO `donation_money` (`dm_id`, `dm_resource_id`, 
`dm_promise_id`, `dm_date`, `dm_amount`, `dm_receipt_number`, 
`dm_donation_code`, `dm_appeal_code`, `dm_payment_code`, `dm_mem_hon`, 
`dm_mem_hon_who`, `dm_foundation_code`, `dm_in_kind_desc`, `dm_comment`, 
`dm_send_thank_you`, `dm_in_thank_you_set`, `dm_from_distribution_id`, 
`dm_user_field1`, `dm_created`, `dm_created_by`, `dm_modified`, 
`dm_modified_by`) VALUES 
(1,467,NULL,'2008-05-12',60.00,'03718C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','',1,1,NULL,NULL,'2008-05-14 
15:39:14','jessi','2008-08-07 
17:17:40','george'),(2,467,NULL,'2007-06-11',35.00,'04379C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','',




--

Carl Paulsen

Dover, NH 03820


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted