Importing your PayPal history into MySQL

Here's one way to do it:

1.) Login to PayPal -> History - > Download My History -> Custom Date Range (Note: if you have a large amount of transactions, PayPal will time out and you'll get nothing. The trick is to do a year at a time.) -> File Types For Download -> Comma Delimeted - All Activity -> Download History.

This should put a "Download.csv" file on your desktop.

2.) Open Download.csv in Excel, delete first row, and save as another .csv file (for example, paypal-2006.csv).

3.) Login to your MySQL database using phpMyAdmin.

4.) phpMyAdmin -> (your database) -> SQL -> Insert and Run the following:

CREATE TABLE `paypal` (
`Date` varchar(255) NOT NULL default '',
`Time` varchar(255) NOT NULL default '',
`TimeZone` varchar(255) NOT NULL default '',
`Name` varchar(255) NOT NULL default '',
`Type` varchar(255) NOT NULL default '',
`Status` varchar(255) NOT NULL default '',
`Subject` varchar(255) NOT NULL default '',
`Gross` varchar(255) NOT NULL default '',
`Fee` varchar(255) NOT NULL default '',
`Net` varchar(255) NOT NULL default '',
`FromEmailAddress` varchar(255) NOT NULL default '',
`ToEmailAddress` varchar(255) NOT NULL default '',
`TransactionID` varchar(255) NOT NULL default '',
`ReferenceTxnID` varchar(255) NOT NULL default '',
`ReceiptID` varchar(255) NOT NULL default '',
`Balance` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

5.) phpMyAdmin -> paypal -> Import -> Browse -> (select paypal-2006.csv) -> replace the semi-colon (;) with a comma (,) in the "Fields Terminated By" box -> GO

-Bob

2 comments on “Importing your PayPal history into MySQL”

Leave a Reply

Your email address will not be published. Required fields are marked *

Shares