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:
`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
Thank you for this, I couldn’t figure out why my import wasn’t working, but you put me on the right track!
Hi Bob, what is your feeling about encrypting this information? I’m working on listing PayPal purchase history for a client of mine and will have to determine what fields contain PII and will therefore need to be encrypted.
Also, do you think the transaction ID should be encrypted? Alone it’s worthless, but just wondering your thoughts.
Thanks,
-Jibran
PII
http://en.wikipedia.org/wiki/Personally_identifiable_information