Skip to content

aquenneville/credit-suisse-monthly-country-economic-indicators-extractor

Repository files navigation

credit-suisse-monthly-country-economic-indicators-extractor

A friend at Argo Capital Management, asked me to extract the data from the country economic indicators tables found in his Credit Suisse pdf document (CS2016.pdf - example page 21). I created a JSmooth wrapper standalone application and later a Spring boot application hosted on Heroku. Both of the projects can be built from the parent pom in the main folder. Try it here!

Requirements

Java v8 or higher, No Java required on Windows run the executable.

Shell/git skills to run this app

Credit Suisse pdf document with key tables

The Excel file is generated in the project folder. In Spring boot the Excel file can be downloaded.

Features

  • Pdf extraction with iText
  • Regex
  • Data sent to Excel using Poi
  • Exe package using JSmooth (to be used in Windows)
  • User can extract data until he presses 'Q' to quit
  • Spring boot application version (I tweaked the code for the upload from spring.io: https://spring.io/guides/gs/uploading-files/)

Spring boot first App Run

mvn clean install

mvn --projects spring-boot-credit-suisse-monthly-country-economic-indicators-extractor spring-boot:run

Then open your browser at: http://localhost:8080

Running the Standalone app

On Linux/Mac: Open a Terminal and run: java -jar [ ] -pdf_file CS2016.pdf -page 9

On Windows: Open a cmd window and run: cs-markets-cei-extractor.exe -pdf_file CS2016.pdf

-pdf_file: (mandatory) pdf file

-page: (optional) page number to extract

TODO List

  • Finish readme
  • Add Screenshots
  • Add jsmooth, exe package
  • Add Usage
  • Add Travis CI build badge
  • Refactor code
  • Add field validation
  • Add page or pages feature
  • Add user instructions on page
  • Add Heroku deployment
  • Add Bootstrap and Jquery
  • More testing... file exist, page in range of doc, etc

Screenshots

1st page

Table data to extract

Spring boot application

Springboot execution

Standalone application

Loop execution

Changelog

  • Bootstrap added to web page.

Releases

No releases published

Packages

No packages published

Languages