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

Palace Stock Tracker 5
Stock Tracker 5 Home
Download

Purchase
Purchase Licence
Hardware List and Labels

Palace Stock Tracker 5 Documentation
All Documentation
Getting Started
Operator Login
Overview
Adding Items
Selling Items
Managing Contacts
Reference
Client Options
Administration Area
Printing
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

Training
Training Courses

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
 

Divider

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

Copyright (C) 2003-2019 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: 44 Southchurch Road, Southend. SS1 2LZ.

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