Post Format

spispna.pdf parser (Miscellaneous)

Description

Current all Polish Postal Codes extractor. In Poland all postal codes are published quarterly by official Post Office on the official site. Data are stored in spispna.pdf file. This script will exclude all postal codes from this file and save them to CSV file or directly to database.

Perfect for web systems that need up to date postal codes in Poland. Just logon, click start button and you get actual data.

Features

  • Advanced polish Postal Codes analyzer – extract data from pdf file:
    • postal code
    • city
    • street name
    • house number
    • community
    • county
    • voivodeship
  • Written in PSR standards
  • Extract 115000 always up to date polish postal codes
  • Perfect for web systems
  • Saving data in utf8 format
  • Linked to spispna.pdf file

Security

  • Support sessions
  • User login/password required
  • CSRF token included
  • PHP PDO used to avoid any SQL injection
  • All requested data double checked before usage

Requirements

  • Hosting server
  • Minimum PHP 5.3
  • MySQL database for data

Installation

  1. Copy files to your hosting folder
  2. Login using default credentials
    • Login: demo
    • Password: demo
  3. Go to configuration section and change login and password
  4. Setup database params

Changelog

ver. 1.1, 2018-05-10

- added: login page
- added: clear tables option
- added: error_reporting(E_ALL)
- added: session
- added: CSRF token
- updated: code refactorized to PSR standards
- updated: configuration
- updated: template and views

ver 1.0, 2018-04-10

- upload spispna.pdf
- setup parsing params
- setup database params
- setup database table names
- analyze PDF and extract data to DB or CSV

Continue reading..

Leave a Reply