RPOWER.SQL Server Configuration

From RPOWERWiki

Jump to: navigation, search

This article discusses how to set up the RPOWER Database Importer on the computer designated to host the RPOWER MySQL Multi-Store Database.

Contents

Required Components

If this computer is also the RPOWER.Reports Web-Based Reporting Web server, you can use these directions.

If you are using Remote Desktop, it is imperative that you click on the link above. Installation instructions for each of the other components can be found on their respective pages.

Download Database Importer

  1. Click here to download the RPOWER Database Importer and either select Run or save the file into your RPOWER.Central Installation Files folder and run it from there.
  2. Select the destination folder and push Next >.
  3. Push Install.
  4. Check Run the RPOWER DB Importer and push Finish.

Configure the Database Importer

  1. Right-click the D/B icon by your clock (in the Notification Area) and select Edit Preferences...
  2. In Database server name, enter localhost.
  3. Click either MySQL or SQL Server depending upon what type of database was installed.
  4. If you clicked on SQL Server enter the instance name. By default, when using SQL Server Express, the instance name is sqlexpress. If you installed SQL Server, use the instance name you specified during installation.
  5. Push Save.
  6. Push Resume.

Create a Shortcut

The installer does not yet create a shortcut to run the Importer. We need to create one manually.

  1. In Windows Explorer, navigate to your installation folder (e.g., RPOWER.Central\RFX\DATACNX\Importer). You may have to refresh your view in Windows Explorer.
  2. Right-click-drag RPDBImporter.exe onto your Desktop and select Create Shortcuts Here.
  3. Rename the icon to RPDB Importer.
  4. Either press Ctrl-C with this icon selected, or right-click it and select Copy.
  5. Right-click the Start menu and select Explore.
  6. Navigate to Programs and click down on Startup.
  7. Click on the right and either press Ctrl-V or right-click on the right and select Paste.

Force a "First Post" From a Store (optional)

You don't always have to force what is called a "first post" from the store. Once RPOWER has been stamped for reports, the first time it creates a DATACNX export file, this file is a "first post". A "First Post" contains all NON-transactional data from a store such as customers, sales categories, menu items, and employees.

From Manager Functions:

  1. Click System Status.
  2. Press Alt-U to bring up a set of brown buttons.
  3. Click Reset Export Flags.
  4. Click OK.
  5. Click System Maintenance...
  6. Click Execute SQL Exports
  7. On the SQL Exports dialog it will ask if you want to Report date range?. Click No.

RPOWER will then generate a DATACNX export file containing first post information.

NOTE: It is recommended that you either do this when the store is closed, or when it is slow. The probability exists that doing this can cause a file lock error which could possibly bring the system down. Also recommended is that you only do this on the fileserver since it will run faster than performing this task from another workstation.

Views
Personal tools