Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Carl,

Depending on the program (this looks like the output from MySQL Workbench) and the tables are MySQL/MariaDB - the MyISAM is specific MySQL/MariaDB database engine. If you have MySQL or MariaDB and MySQL Workbench installed you can import/restore the data.

The second dump has the data after value with each row in parentheses. You could open the file in any text editor. The remove the first part and the use find and replace to remove the parentheses and each '.

The program that generated the data probably allows you to get all the rows and export/save them as a csv file.

Jay

On 01/15/2014 04:08 PM, Carl Paulsen wrote:
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','','',





--
Jay Lozier
jslozier@gmail.com


--
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.