Scheduled Import of Goods Self Cost

In StoreHouse5, it is possible to configure automatic self cost import from r_keeper 7, performed according to the schedule.

To do this:

• Make settings in the manager station
• Create a self cost type
• Configure import plugin
• Specify the period
• Set up the event

Library Copying

To configure the import of goods self cost, copy all DLL files from the StoreHouse folder, and then make necessary settings at the manager station. Do not forget to configure the goods self cost in StoreHouse: create the required goods, make sets for dishes and make a receipt note.

1. Download the archive with library files from the FTP server ftp://ftp.ucs.ru/StoreHouse 5/_utils/sh5rki/
2. Unpack the archive into the reference server folder. Agree to replace the files.
3. Unpack the archive into the manager station folder. Agree to replace the files.
4. Copy RTL60.BPL from the StoreHouse5\Client installation folder into the reference server and manager station folder.
5. Restart the reference server and the manager station. 

Use your dealer ID to authorize at the FTP server.
If your r_keeper 7 is installed from the archive, copy the above-mentioned files to the rkeeper\bin\win folder.

Manager Station Settings

1. Launch the manager station
2. Go to Service > Data export > StoreHouse Database Configurations 
   
   
3. Right-click in the blank field and select New Store House Configuration
    
   Specify the following properties:
   1. User Name: for example, Admin
   2. Server:port: StoreHouse 5 server address and port. They must be divided by a semicolon.
      
   3. User password
   4.  StoreHouse Version in the drop-down menu
   5. Change the Status to active and save the changes
   6. If you use r_keeper 7 version 7.7.0 and higher, click Test
      
      
   7. The message on connection error via WebApi will appear. As WebApi is not used, ignore the message and click OK.
      

Creating Self-Cost Types

1. Go to Menu > Self-cost Type
   
   
2. Right-click in the blank field and select New Self-Cost Type
   
3. Specify self-cost Name
4. Check the following boxes in the properties:
   • Use in Reports
   • Allow Overridings
5. In the Store House Config, select the one, previously created in Database Configurations
6. Optionally, you may specify the Commodity Group — in quotes, exactly as in StoreHouse. It is not obligatory, you may specify this property right before the import. It is also possible to specify several commodity groups, separated with spaces or commas.
   
7. Change the status to Active
8. Save the changes.
   
   

Plugin Settings

1. To launch the plugin, Plugin External user's data is used. Do not delete the Plugin External user.
   
2. In the manager station, go to Personnel > Employees
   
   
3. Go to Head Office > XML-Editing > Properties
   • in the Manager Restrictions, check the HTTP Access box
     
   • in the Priveleges block of the Manager Restrictions section, check the Menu box
     
4. Go to Options > OLAP Reports > Reporting Servers
   
   
5. Click on the References server:
   • In the XML interface line of the HTTP restrictions section, select HTTP Access
   • In Restrictions, check the HTTP Access box
     
6. Go to Service > Plugins configurations
   
   
7. Select the Import SH plugin. Right-click in the blank space and select New Plugin configuration
   
8. Specify the configuration name and change the status to Active
   
   
9. Double-click in the Settings line of the Basic block
   
10. The plugin configuration window will open
    
    Fill in the following lines:
    • Active Only: to import self costs only for active elements of r_keeper 7 reference
    • Department: specify the department name as in StoreHouse. To see the name, start SDBman and go to StoreHouse > Departments and department groups
      
      
    • SH root apex: the name of the root group in StoreHouse, from which the data will be imported
      
    • Item: the item to be imported. Depending on the value, the corresponding type of item will be imported.
    • Item type (first line): item of menu group, where self costs will be imported to
    • Self-Cost Type: the self-cost type created earlier
    • Calculation Mode: the way of self cost calculation
    • Include taxes: the self cost will include taxes
      

The plugin is configured.

If needed, you can create several plugin configurations. For example, if you need to import self costs from different StoreHouse departments, create the corresponding number of events.

Periods Settings

Periods for the plugin define the start time of self-cost import. Create and configure the period.

Events Settings

1. In the manager station, go to Options > Customization > Event List
   
2. Right-click in the blank space and create a new event
   
3. Fill in the following fields:
   • Name: specify the event name
   • Status: change it to active
   • Event Type: select Run plugin from the drop-down list
   • Period: select the previously created period
   • Plugin: select the previously created plugin for import
   • Plugin Config: select the corresponding plugin configuration
     

The plugin is configured.

After the start time, the records will appear in the event log.

In the manager station, in Menu > Menu, the self cost imported from StoreHouse will appear.

Logging

pluginISBadEntries.data — the records, the requests for which were failed. 

rkCroner-Log.txt — rkcroner logs for r_keeper version 7.7.0.56 and higher. Contains records on how the event has worked.

importSH — the records of errors during the import. When 2 copies are launched, a temporary log file is created in the folder with the plugin.
After the log path is received from the configuration, the old log copies the data from the configuration into a new one and is deleted after that.
If 2 copies of importsh are launched simultaneously, 2 files will be created: importsh.exe-0.log, importsh.exe-1.log