Page History

...

Introduction

Using the ScriptExecuter utility, you can export data from an SQL database complying with relevant criteria to the .csv file. For example, the data by dishes, prices, sales (cash and non-cash payments, returns) over a specified period.

...

For proper work of the utility, installed MS SQL is needed.

To export the data, download the ScriptExecuter distributive. The distribution package contains:

...

To configure export, first, create a link to the SQL database (web.udl).

1. Create a file

   having

   with the .udl extension for configuring connection with MS SQL

   Info
   For correct work of ScriptExecuter.exe, create all three files — the parameters file, the request file and the .udl file — in the UTF-16 LE coding.

   
   

2. Right-click on it and open its properties
3. On the Provider tab, select Microsoft OLE DB Provider for SQL Server
   
4. On the Connection tab, fill in the data for SQL server connection, and press Test Connection.
   
   

5. Now, create an SQL request (SQLQuery3.sql). Below is an example of a simplest request:

   Code Block
   DECLARE  @RSIFR INT = :rsifr  SELECT TOP 1000  [SIFR]  ,[CODE]  SELECT COUNT(*) FROM [RK7BaseRK169].[dbo].[MENUITEMS]  where (CODE=2)

   
   

6. Create a list.txt file. In this file, specify the parameters from the readme.txt file that will define the export from the SQL database.

...

Once the shortcut is run, a folder (in our case this is the 73905 folder) containing the TEST.csv should appear in the root directory. A folder containing logs (Log folder) is also created. Here you can track the operations, their success, and errors.
Image Added

Export from SQL to sFTP and from StoreHouseStore House

There is an adjustment allowing to export data from StoreHouse.

...

Usage: Run the 105829 script or open it as a text file and copy-paste it to the MS SQL console

Attachments: