Introduction

This script helps you transform pages of PDF tables into a nice CSV file, specifically made for the Transaction History PDFs that you can request from the GCash App's transaction history.

Getting Started

Prerequisites

Requires the following packages:

• rJava (requires JDK with your system)
• tabulizer
• tidyverse
• data.table
• lubridate

install.packages('rJava)
install.packages('tabulizer')
install.packages('tidyverse')
install.packages('data.table')
install.packages('lubridate')

Obtaining GCash Transaction History

1. Download GCash app in Android or iOS
2. As of v5.31.0:558, go to Home > Transaction History to email the details to email account. Please check if you need to be a Verified User with a Verified Email Account for that one. Take note transactions need 24 hours before they're made available.
3. Download the PDF. Might land in your Spam folder. Take note of password in their instructions and the number of pages in the document.

User Input

Take note to change the following fields at the end of the file.

setwd("INPUT FOLDER HERE")
ExtractTxnHistory2CSV("INSERT FILE WITH FILE EXT HERE",                  # "transaction_history.pdf"
                      "INSERT PASSWORD HERE",                            # "surname_last-4-digits-of-mobtel"
                      "INSERT NUMBER OF PAGES HERE, NO QUOTATION MARKS") # 2

Built With

• R - Used the v3.5.2 package
• RStudio - IDE for R

Authors

• Joshua Koa

License

This project is licensed under the MIT License - see the LICENSE.md file for details.

Acknowledgments

• rOpenSci team for their work on the bindings for Tabula, also check their documentation here to learn more