SQL DB modifier

1. Settings and connection test

1.1. Software

  • R-Keeper 7
  • Game-Keeper 3
  • CardSystem 5
  • Delivery 7
  • KDS
  • UCS video
  • Another/Any
Select your DBMS: Microsoft SQL serverFirebird SQL server

1.2. DB connection

SQL server name: the same format as in RK7 connection string "Data Source=" parameter value ("95.31.31.240\sqlweb")
Database name: the same as in RK7 connection string "Initial Catalog=" parameter value ("rk7web")
SQL DB username: ("sa")
SQL DB password:
No valid connection
fill in proper parameters and press "connect"

1.3. Other settings

LOG (engine) page timeout: ms

2. Manual SQL request execution

2.1. Any SQL request

Input correct SQL query

Press the button:


3. MANUAL GET OPERATIONS

3.1. For common shift split

Use preset operation code to execute necessary operation

You should put operation code here:

1 = get full common shifts list
2 =
3 = get cash shifts out of one date with common (which should be fixed)
4 = get null start date (empty) cash shifts list
5 =
6 = get null start date (empty) common shifts list
7 =
8 = get associated null shifts list (if so)
9 = get all cash shifts in several days long common shifts

Press the button:


3.2. For order category change

Use preset operation code to execute necessary operation

You should put operation code here:

1 = get full order category list
2 = get order category and type dependence list
3 = get all tables where is order category used

Press the button:



4. MANUAL EDIT OPERATIONS

4.1. SPLIT COMMON SHIFTS

Execute operation 1 from 3.1. before split

Input new common shift DATE here:

format is YYYY-MM-DD

Input new common shift NUMBER here:

in case of several shifts selected this one will be the start of numbering (extra)

do not split shift, create new only



if you have set at least one of these parameters, choose only ONE shift from the list to split

Select common shifts to split:

Press to start:

4.2. Change order category

Execute data prepare operation first by pressing "prepareforuot" button

You have to decide which cash server sales should get what order category

Select order categories for each cash server:

Press to start:

5. AUTOMATIC EDIT OPERATIONS

5.1. AUTOSPLIT

This button makes the check and split automatically

INFO

You use this software at your own risk
Check results in DB or reports after and restore the database immediately if necessary

Press this button:

6. MANUAL REPORTS

6.1. Use preset report code to execute necessary query

See result as last query on this page very buttom;
the result will be shown as full report dataset table without grouping and filtering

You should put report code here:

1 = payments list

Press the button:


6.2. Select one of available report queries to execute

Execute data prepare operation first by pressing the button below

Use drop down list here:

View name

Press the button:



If you want to get layout based reports with grouping and filtering use Rkeeper Mate Reports software

7. UNIVERSAL TABLE EDITOR

7.1. Get all tables in DB

7.2. Choose one or several tables to open for edition

7.3. Table is opened for edition

Proceed with result as last query table on this page very buttom