SKU
09/20/2007

Requirements:

    It is assumed that there is currently a SQL server running on the system.

    
Folder content:

"Scripts" contains the scripts required to attach the database.

"SKU DB" contains the database in a compressed archive.


The Database:
    Copy the zipped database SKU_DB to the target system. 
    Extract to the SQL data folder. Usually c:\program files\microsoft sql server\mssql\data

    Copy the scripts folder to the target system. The folder must be in the root of c:.
    Example: c:\scripts

    Use the script SKU_attachDB.bat to attach the database to the sql server.
    Use the script SKU_GrantAccess.bat to allow access to the database attached above.

ODBC:
    An ODBC connection is required on all PC's running VCRetail4.exe and SNC_TS.exe. 
    Use the ODBC administrator tool to create a system DSN SKUdb. 
    Select SQL authentication. select default database SKU.

    To enable the use of this database...

    Use form FDNDC, near the bottom find the field "Foreign SKU's file". Enter "SQL" in
    in the field. 

    Restart the Terminal server. 
    The terminal server should show "SQL database on" on the status bar.

End of SKU installation
------------------------------------------------------------------------------


ODBC:
 (pronounced as separate letters) Short for Open DataBase Connectivity.

On all client computers:
This includes terminals and terminal server.

create an entry under system dsn for SKUdb using the sql driver, point to 
the SKU database.

OS dependant
start > settings > control panel > administrator tools > data source (ODBC)  
Select System DSN (Data Source Name)
select add > SQL Server 
Name: SKUdb
Server: enter name of sql or MSDE server or IP
Next
Choose sql authentication
select client config > select tcp >ok
Check connect to sql server to obtain additional configuration options.
if using sql server authentication enter the user and password
Next
Check the change default database to: SKU
Next
Finish
Click on test, if you anything but success you are not connecting to the 
database. you must correct this for the client computer to access the database.



------------------------------------------------------------------------------

------------------------------------------------------------------------------
*************
POS Rewards:
*************

you must have a plu for Rewards cards.
Example:

Use FDNmu to select plu's

add this plu to a preset for data base query.
80527 long name = *Rwards, short name = *Rwards, promt for modifiers = 1.

Use FDNPS to select preset mask to add the Rewards plu.

Use PSFL1 field "Enforce HA, GC, RW to SQL Database" to direct Rewards
 to the SQL database. 

Running:

The SQL server or MSDE should be running.

start the terminal server snc_ts.exe

The terminal server should show "SQL database on" on the status bar.

start the terminal program

logon to the terminal, start an order, touch the Rwards key, enter rewards manually or via magnetic card reader. 


------------------------------------------------------------------------------

------------------------------------------------------------------------------
****************
POS Gift Cards:
****************

You must have a PLU's for Gift Cards and add them to Preset Mask ( the item or tender screens ).

Example:

Use FDNmu to Add the following PLU's

Add PLU 80546 short name = " *GiftCrd",  long name =" *Gift Card", promt for modifiers = "1", PLU Restriction =" 5".

Note 80546 is a paid in.  97191 is the generated transaction code. 97191 should be used in reporting.

Add PLU 97391 ShortName= "GCRedeem" LongName = "Partial Card Redemption" PLU enforce = "4" PLU Resrtict Code = "5"

Add PLU 97392 ShortName= "CashOut" LongName = "Full Card Redemption" PLU Resrtict Code = "5"

Use FDNPS to add the Gift Card PLU's to select preset masks.

Add 80546 to a preset mask of your choice for Cift Card Balance Query or Adding Funds to Gift Card.
Add 97391 and 97392 to the tender preset mask.

Use PSFL1 field "Enforce HA, GC, RW to SQL Database" to direct Rewards
 to the SQL database. 


Running:

The SQL server or MSDE should be running.

start the terminal server snc_ts.exe

The terminal server should show "SQL database on" on the status bar.

start the terminal program

logon to the terminal, start an order, touch the GiftCrd key, enter Gift Card manually or via magnetic card reader. 
use the tender screen(total) and select your choice of tender Cashout or GCRedeem.


----------------------------------------
----------------------------------------

Transfering Type 16 data from the pos-r database

See the document "Converting Sbase to SQL Database.doc"


------------------------------------------------------------------------------

------------------------------------------------------------------------------

A simple connectivity test: 

Assumes you have data to view.

snc_sql_view.exe can be use as a simple connectivity test

snc_sql_view.exe and glist.exe must be copyed to the c:\pos folder.

glist must be copyed to the c:\report folder.

create a shortcut for the snc_sql_view.exe

The command line on the shortcut should look like the following.

C:\pos\SNC_SQL_VIEW.exe /ODBC SKUdb /PLU C:\POS\POS-R /TYPE 16

Run the snc_sql_view shortcut

select the sql rewards list button, the glist screen should appear.

if not, something is wrong.


******
Notes:
******

   uses port 1433-1434 TCP and UDP
   if a Router or firewall is used, be sure to configure them for this application.