RPOWER.SQL Store Configuration

From RPOWERWiki

Jump to: navigation, search

This article discusses how to set up a store to send data to the SQL Server database hosted at the RPOWER office.

Contents

Preparatory Steps

Before you follow any of the instructions below, make sure you delete all files in the rpower/EXPORTS/DATACNX/ClientOut directory. It is best to start out with an empty ClientOut directory so no unwanted data gets sent across. Any exports files containing legitimate data can be re-created after performing the steps in the Reassign New MIDs and the Performing the First Post section.

Setting Consolidation Group

The consolidation group number is a number used to consolidate data from a group of stores into a single set of data in our SQL database. Typically, the serial number of the first store in a group to export data to the SQL database is the serial number used as the consolidation group number.

To set up a consolidation group number for a store:

  1. Log into RPOWER's Manager Functions.
  2. Click System Setup...
  3. Click System Information
  4. Click More Options...
  5. In the Reports Database consolidation group textbox, type in the consolidation group number (typically, the serial number of the first store from a group of stores to export data to the SQL database).
  6. Click Save. RPOWER may reset all mids at this time. As a safety measure, it is best to explicitly do that by following the instructions under Reassign New MIDs.
  7. Exit Manager Functions.

Reassign New MIDs

Reassigning MIDs is important if this is the first time this store is sending data to a SQL Database. It allows the store to start exporting with a "clean slate" so to speak.

  1. Log into Manager Functions.
  2. Click System Status
  3. Press Alt-U to bring up a set of hidden function buttons.
  4. Click Reassign All New MIDs. You may see a progress bar as RPOWER reassigns new MIDs.
  5. Click OK
  6. Click OK to close the System Status dialog, and click Done to exit Manager Functions

Clearing Export Flags

Clearing Export Flags is done so that all non-transaction data is passed into the SQL Database. Not only is this done before the first time a store posts data to the SQL Database, but also any time a store's database requires a manual sync to resolve any data import errors.

  1. Log into Manager Functions.
  2. Click System Status
  3. Press Alt-U to bring up a set of hidden function buttons.
  4. Click Reset Export Flags. You may see a progress bar as RPOWER clears the export flags.
  5. Click OK
  6. Click OK to close the System Status dialog, and click Done to exit Manager Functions

Setting up RFX (RPOWER File Transfer)

There are two files to set up for data transfer to us. One is called DATACNX.ini and the other is called RFX.ini. Both files either need to be created, or already exist, in the winrun/ini directory.

Setting up DATACNX.ini

The DATACNX.ini file contains data export settings.

  1. On the computer acting as the file server, navigate to the rpower/winrun/ini directory.
  2. If a DATACNX.ini file does not exist, then create the file.
  3. Open the DATACNX.ini in Notepad, or another text editor.
  4. Enter in text so it looks like the example below. (You can copy and paste the example.) The keys here are to set the Server= setting to the name of the computer acting as the fileserver, and making sure the ExportTICKET_SALES=1 line is in the file.
[Setup]
Server=CASH1  ; change the computer name to the file server name
ExportAllTC=0
ExportTICKET_SALES=1
ExportTICKET_ITEM=1
IntradayMinutes=10

Save the DATACNX.ini file and close your text editor.

Setting up RFX.ini

The RFX.ini file governs where the data export files are sent.

  1. On the computer acting as file server, navigate to the rpower/winrun/ini directory.
  2. If an RFX.ini file does not exist, create the file.
  3. Open the RFX.ini file in Notepad or another text editor.
  4. Enter in text so that the file looks like the example below. The key here is to set the Server= setting to the computer that acts as the file server.
 [Setup]
 Server=FILESVR
 ServerKey=12345678
 API=DATACNX,HOST=rpower.dyndns.org:32150,CG=XXXX <- set CG and remove this note

Save the RFX.ini file and close your text editor.

Afer performing the above steps, restart foreground and background RPOWER on the file server.

Performing the First Post

A First Post is used to send all non-transactional data to the SQL Database.

This step is optional because the first time RPOWER creates an export file at close of day, it will automatically do a First Post. But you can force a First Post if you don't want to wait until the store closes its day, or if you need to resolve an import error. (If resolving an import error, you only need to follow the instructions in the Clearing Export Flags section and then follow the instructions in this section.)

  1. Log into Manager Functions.
  2. Click System Maintenance...
  3. Click Execute SQL Exports
  4. In older software, when the Repost date range? dialog appears, click No. In newer software, when the Execute SQL Exports dialog appears, click System Data Post. You may see a progress bar as RPOWER exports the non-transaction data.
  5. Click Done to exit Manager Functions.

Push Data to RPOWER

If you haven't already, restart both background and foreground on the file server. This will push the exported data across to our SQL Database.

Clear First Post Lock

Performing a first post will lock the database so that no transactions are posted until the database receives a file back from the importer. This forces a sync of the item ids at the store with those in the SQL database. In most cases, this happens automatically and should happen automatically. When a store is the first of a consolidation group to post to us, the database just uses the item ids that were defined at that store, and so the importer will not send a file back to the store to correct its ids. To do this manually:

  1. Log into Manager Functions.
  2. Click System Status
  3. Press Alt-U to bring up a set of hidden function buttons.
  4. Click the button in the upper left called Reset First Post Lock.
  5. Click OK to leave the System Status panel.

Once the first post lock is removed, the store will start sending transactions across to us again. Please do not do this for subsequent stores in a consolidation group.

Requesting Site Login Information

After pushing the site data to RPOWER, be sure to send an email to RPOWER requesting a user name and password. You will get an email back the same day with the user account information.

User accounts are automatically granted access to the Dashboard. For that same user account to be able to access the RPOWER.Reports web reports, the site must be stamped for RPOWER Reports.

Be aware that the first time a store pushes data to our SQL Database, the data might not be immediately available. There is a manual authorization process that needs to be performed to tell the database the incoming data is correct. Typically, data is available later the same day. If you need the data immediately for reporting purposes, or for the WhenToManage integration, contact RPOWER and they will make your data available. Again, this authorization process only occurs on the very first post from a store. Subsequent data posting does not need authorization.

Posting Historical Data

After setting up a site to push data to RPOWER, you may need to post data prior to the date of the first post. You can post up to a month back. Depending upon how busy the site is, you may be able to post as little as a week at a time, or as much as a month. During the export process, RPOWER locks tables, and if you are exporting a large amount of data at one time, it could cause issues. So, you may want to start by exporting a week, and if that takes very little time, export two weeks, and if that takes very little time, export three weeks, and so on. It is recommended you do not export historical data during high traffic times at sites.

To post historical data:

  1. Log in as a a manager
  2. Click System Maintenance
  3. Click Execute SQL Exports
  4. When prompted Repost date range? click Yes
  5. Click the Through Date button and select your date
  6. Click the From Date button and select your date
  7. Click OK/Begin

RPOWER will generate a single export file covering the dates you specified, and push that file up to the RPOWER servers.

Views
Personal tools