RPOWER.SQL Server Configuration
This article discusses how to set up the RPOWER Database Importer on the computer designated to host the RPOWER MySQL Multi-Store Database.
If this computer is also the RPOWER.Reports Web-Based Reporting Web server, you can use these directions.
- General Corporate Server Setup
- Configure Remote Desktop (RDP) or Terminal Server if it is used for remote control. We strongly recomment not using Remote Desktop!
- If using RPOWER.Reports, install Internet Information Services (before the .NET Framework)
- Install Microsoft .NET Framework.
- For most applications, install Microsoft SQL Server, but MySQL is also available.
- If using MySQL, install the MySQL ODBC Driver.
- Install RPOWER File Exchange (RFX).
- Install the RPOWER Database Importer (described in this article).
- If using RPOWER.Reports, after finishing this document, go to RPOWER.Reports Web-Based Reporting and complete that document starting with Adobe Acrobat Reader.
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
- 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.
- Select the destination folder and push Next >.
- Push Install.
Run the RPOWER DB Importerand push Finish.
Configure the Database Importer
- Right-click the D/B icon by your clock (in the Notification Area) and select
Database server name, enter localhost.
- Click either
SQL Serverdepending upon what type of database was installed.
- If you clicked on
SQL Serverenter 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.
- Push Save.
- Push Resume.
Create a Shortcut
The installer does not yet create a shortcut to run the Importer. We need to create one manually.
- 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.
- Right-click-drag RPDBImporter.exe onto your Desktop and select
Create Shortcuts Here.
- Rename the icon to RPDB Importer.
- Either press Ctrl-C with this icon selected, or right-click it and select
- Right-click the Start menu and select
- Navigate to Programs and click down on Startup.
- Click on the right and either press Ctrl-V or right-click on the right and select
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.
- Click System Status.
- Press Alt-U to bring up a set of brown buttons.
- Click Reset Export Flags.
- Click OK.
- Click System Maintenance...
- Click Execute SQL Exports
- 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.