Home banner
Home Palace Stock Tracker 5 Palace Stock Tracker 4 Software Outsourced Application Coding Contact Get Support

Palace Stock Tracker 5
Stock Tracker 5 Home

Purchase Licence
Hardware List and Labels

Palace Stock Tracker 5 Documentation
All Documentation
Getting Started
Operator Login
Adding Items
Selling Items
Managing Contacts
Client Options
Administration Area
Client Software Setup
Setup Connection to Database
Server Setup
Setup SQL Server and Import Data
Setup Stock Tracker Server App
Setup Postcode Database (optional)
Setup Server Backup

Known Issues
PST5 Known Issues

Icon  Setup Postcode Database (optional)

To import postcode data your organisation needs to register for Royal Mail PAF (this is free for charities and microbusinesses)
More information here.

Note Importing the PAF database can take several hours and may affect server performance.

Create Database

  • Open SQL Server Management Studio and login.
  • Right click Databases -> New Database… -> Database name = "PAF".
  • Press OK.

Create User

  • Expand SQL Root\ Security\Logins -> right click New User….
    • Login name: "PAF"
    • SQL Server Authentication
    • Password: (contact Palace IT for password)
    • Uncheck Enforce password policy, Enforce password expiration and User must change password at next login.
    • Default database: "PAF"
    • User Mapping (left side): Tick PAF | User: PAF | Default Scehma: dbo
  • Press OK to save user.

Import CSV

  • Extract your own Royal Mail PAF CSV file to a folder on the server (not on Desktop or Desktop subfolder).
  • Right click Databases\PAF -> Tasks -> Import Flat File...
    • Introduction window
    • Next >
    • Specify Input File window
    • Browse to file
    • New table name: "PAFData"
    • Next >
    • Preview Data window
    • Next >
    • Modify Columns window
    • Enter the colmns exactly as shown in the image below....

    • Next >
    • Summary window
    • Finish...

Setup Stock Tracker Server App

  • Open the Stock Tracker Server App and press Database Settings.
  • In the Royal Mail PAF Database section enter:
    • Server Name or IP: (name or IP of the SQL Server hosting the PAF database).
    • SQL Server Instance Name: "SQLEXPRESS".
    • Database Name: "PAF".

The next time a client logs in the postcode features will be automatically enabled.

Contents  Contents
Top  Top


Contact Contact    Privacy Privacy Policy    This site does not use cookies.

Copyright (C) 2003-2021 Palace IT Limited, all rights reserved.
Palace IT Limited is a company registered in England and Wales with company number 4547485. VAT registration number: GB 803 6258 43. Registered address: Ground Floor, The Maltings, Locks Hill, Rochford, Essex, England, SS4 1BB.

This website and connected software products are protected by copyright and intellectual property law.