Back Office > Administration > Batch Reports
Description
This menu item is used to set up Reports that will be run by the End of Day service. Batch Reports can be configured to be run on a regular basis like Daily/Weekly/Monthly/etc. The option to print, save to file, email or FTP them, can also be configured. Nearly every SwiftPOS Report, with only a few exceptions, can be setup as a Batch Report and run at user specified times.
To Be Considered
- The legal requirement that any personal data "Is the data encrypted in transit and at rest" so there is no risk of a “notifiable data breach” This means that you can only transmit data via a secure FTP server and NOT via email because it is NOT secure.
- Ensure all Location Groups (Venues) have been set up with Locations assigned to them. If this is NOT the case, then some Batch Reports may not be visible via this menu item.
- If you are sending data to an FTP Server, then we recommend that you also duplicate your batch report and save a file locally. If the FTP Server is not operational, then you can always manually transfer a copy of the CSV file to the FTP Server. This might also be an option with emailing reports also in the event that the email server is not working. The option to go back and generate a report for "Yesterday" or earlier is NOT available.
- All of the same filters that are used when running Reports in SwiftPOS may be used with the exception of the From/To date filters. Selection of a specific date as a report filter, is NOT applicable to Batch Reports.
Batch Reports
This screen is accessed from here.
It displays a list of all of the Batch Reports assigned to the currently logged in Clerk/Staff Member. You can add as many Reports to the list as needed and the End of Day service will run them at the selected frequency. Note : SwiftPOS must be registered and the End of Day service running for the Batch Reports to be sent to their destination.
Search Filters
- The filters at the top of the screen can be used to limit the number of rows displayed in the grid. The filters include the following types:
- Search Screens - The filter fields of this type are: Location Group and Destination.
- Full/Partial Texts - The filter fields of this type are: Email
Find Fields
The Find fields above the grid will automatically sort the rows in the grid by the field selected. Entering a value into in any one of the Find fields will cause the closest matching row to be highlighted.
Grid
The grid displays the: ID, Name, Report Name, Clerk, Due Next, Frequency, Destination and File Type. Note : To edit an entry in the grid, double click a row. Rows displayed in the grid can be sorted by toggle selecting the column headings.
Footer
- New - Select to add a Batch Report.
- Copy - Select to copy the selected Batch Report.
- Edit - Select to edit the selected row.
- Delete - Select to remove the selected Batch Report from the grid. Below are the likely reasons why a Report may not delete:
- When you open Batch Reports and click Show All, does anything show?
- Are you logged in as a Clerk/Staff Member who has access to all Location Groups (Venues)?
- Also have you unselected Process Batch Reports in the End of day setup and restarted the End of Day service?
- Show All Clerks/Hide Other Clerks - Select to toggle between displaying Batch Reports for All Clerks/Staff Members or only for the currently logged in Clerk/Staff Member.
- Close - Select to exit.
Batch Report Full Edit Batch
This screen is accessed from here, and is used to create and modify Batch Reports. There are a number of customisation options available when creating Batch Reports.
Header
- ID - Displays the Batch ID assigned to the created Batch Report.
- Name - Displays/Enter the name assigned to the Batch Report.
Report
- Report Name - Select to open the Reports screen to select a report, from the available reports or from the Stored Procedures list of exports available, and specify the required filters. Selected Reports are included as part of the Batch Reports List. To ensure that Batch Reports run when no one is logged on, ensure all SwiftPOS Services in Start > Control Panel > Administrative Tools > Services are set to log on as an Administrator. Note : From/To Report filters cannot be used when creating Batch Reports. Instead ensure a pre-defined Period is selected instead.
- Location Group - Select from the drop down list, the Location Group (Venue) to which each Batch Report will be assigned. By selecting a Location Group (Venue) it just means that when the End of Day process for that Location Group (Venue) runs the Batch Report will be exported to the specified Location Group (Venue).
- Clerk - Select from the drop down list the Clerk/Staff Member generating the selected Batch Report. By assigning a Batch Report to a Clerk/Staff Member then the data Reported will be limited to that data which the selected Clerk/Staff Member is authorised to view.
- Due Next - Select from the drop down calendar the date and time that the selected Batch Report is next due to be generated.
Report Frequency
Select one of the following :
- Daily - Select to run the selected Batch Report daily. This is used for Replenishment Reports as well.
- Daily Run Times - Select the Edit Times button to display the Daily Run Times screen.
- Weekly - Select to run the selected Batch Report weekly. Once selected the day of the week can be selected set.
- Fortnightly - Select to run the selected Batch Report fortnightly. This option uses the Next Report Due date and produces Reports for the two week period prior to that date plus the trading time. Example: If the Next Report Due date is set to 15th April 2014 then the date range selected would be 1st April 2014 at 6:00 to 15th April 2014 at 5:59am (assuming your End of Day Run Time is set to 6:00am. Technically, the logic is; from-date is next-Report-due-date - 14 + start time and to-date is next-Report-due-date + start-time - 1 sec.
- Monthly - Select to run the selected Batch Report monthly. Note : The time of the day that all Batch Reports are run is set here.
Destination
The destination determines the way in which the Reports are exported. The options are Printer, File, Email and FTP Server. Please note that the appropriate mail server settings must be entered into the Global Preferences menu item before any Batch Reports are exported using the email destination type.
- Printer - Select to print Batch Reports to a predetermined printer. The printer to be used is configured here.
- File - Select to ensure Batch Reports are written to a file. When selected the following File Properties will be displayed:
- Path - Defaults to C:\Users\Public\Documents\SwiftPOS Reports. To change select/enter the file path to which the Batch Report will be written. Note : If the Path (folder) is to be located over a local area network (LAN) or VPN (ie. not on the local PC) then ensure the Path is specified in Universal Naming Convention (UNC) format or also know as the network path (eg. \\OtherServer\SwiftPOS\...), and not in a mapped drive format (eg. S:\SwiftPOS\...). Also, ensure the appropriate folder permissions are configured when using a LAN or VPN location.
- Fixed File Name - It is recommended not to select this unless a specific file name is required to export a Batch Report to a 3rd party application that always expects the same file name. Defaults to the Report name which should suffice for most users. For further information click here.
- Include Header Row - Select to ensure columns headings are included when either a CSV or TSV file type is selected.
- Email - Select to ensure Batch Reports are emailed. When selected the following Email Properties will be displayed:
- Recipients - Enter the email address(es) (separated by semi colons) that the Batch Report will be sent to. This can also be done by selecting the button to the right to open the Edit Batch Report Email List popup, which can then be used to enter email addresses on separate lines. Note : using this method does not require the entering of semi colons as these will be generated automatically. The following is a sample of how multiple email addresses should look when correctly entered : gday@swiftpos.com.au; steve@swiftpos.com.au or gday@swiftpos.com.au;steve@swiftpos.com.au
- Fixed File Name - It is recommended not to select this unless a specific file name is required. For further information click here.
- FTP Server - Select to ensure Batch Reports are sent to an sFTP Server. When selected the following properties will be displayed:
- FTP Path - Enter the file path/folder to which the Batch Report will be written, on the sFTP Server. Other FTP settings requiring configuring before this option can be used can be found via the Location Group (Venue) screen.
- Fixed File Name - It is recommended not to select this unless a specific file name is required. For further information click here.
- Email Groups - Select to email Batch Reports using Email Groups. This allows the inclusion and removal of email addresses to Email Groups rather than having to edit each Batch Report's Recipient list. When selected the following properties will be displayed:
- Fixed File Name - It is recommended not to select this unless a specific file name is required. For further information click here.
- Email Groups - Select from the list displayed the Email Groups to receive the selected Batch Report. Note : If issues are encountered when emailing Reports, please ensure the Batch Reports/Service Email Setup settings are configured correctly in Global Preferences and that you can use an email client on the same PC to connect to the same Outgoing Mail Server (SMTP) (ask your ISP or server administrator to help you with this if necessary) Also check with your ISP as to how many emails you can send before it is considered as spam.
- Please note that you cannot send personal data (like Member details) via email.
File Format |
Description |
PDF - Portable Document Format |
Portable Document Format is most commonly associated with Adobe Acrobat. |
XLSX - Microsoft Excel |
XLSX format is used with Microsoft Excel Spread sheet application. |
TXT - Plain Text |
Plain text format can be opened in almost any text editor. Most commonly associated with Notepad or email messages. |
RTF - Rich Text Format |
Rich Text Format includes formatting and is most commonly associated with Microsoft Word. |
TIF - Tagged Image File Format |
Tagged Image File Format is a widely used image format. Especially useful for sending Reports that cannot be easily edited. |
XML - Extensible Mark-up Language |
Extensible Mark-up Language format is used mostly for exporting data to third party applications. |
HTM - Hypertext Mark-up Language |
Hypertext Mark-up language format is used primarily for creating websites and is able to be formatted similarly to Rich Text Format. |
CSV - Comma Separated Values |
Comma Separated Values format is a text file where each column of data is separated by a comma. Used when third party applications are used to process the data contained in the file. |
PSV - PIPE-Separated Values |
Pipe (|) Separated Values format is a text file where each column of data is separated by a | character. Used when third party applications are used to process the data contained in the file. |
TSV - Tab Separated Values |
Tab Separated Values format is a text file where each column of data is separated by a tab. Used when third party applications are used to process the data contained in the file. |
XLSX - Pivot Table |
Select to export the report data to an Excel Pivot table. |
Note : It is also possible to specify your own file extension when a Batch Report is generated using the Fixed File Name field. This however, is not recommended.
Footer
- New - Select to add a Report as part of the list of Batch Reports.
- Copy - Select to copy and add the currently selected Batch Report.
- Run - Select to perform a test run of the Batch Report and will indicate to the user if there is no data to display or a problem has occurred. If a Batch Report runs through the testing ok you can be sure that it will export automatically without any problems.
- Save - Select to save changes.
- Undo - Select to undo changes made.
- Delete - Select to delete the current Batch Report.
- Close - Select to exit.
Reports
This screen is accessed from here, and is used to select the Report required and specify the filters. Note : The From/To Report date/time range cannot be used when creating Batch Reports. Instead ensure the pre-defined Periods are used instead.
There is no way to go back and get reports for "Yesterday" a week after the event. You cannot select a specific date for batch reports.
Daily Run Times
This screen is accessed from here, and is used to specify times to run the selected report. Only useful if there is a requirement to run a specific report multiple times through out a trading day. Note : Data reported at each of the times intervals set will be for the period from Start of Day Trading time and up to the set time interval.
Right click in the grid to display a list of pre-fill options available. Hourly, 3 Hourly, 6 Hourly or 12 Hourly. Select anyone of these to fill the grid with the required times, or enter the times, each on a separate line, in 24h format manually. For example, 1pm is entered as 13:00.
Fixed File Name Variables
In addition to being able to create a completely Fixed File Name there are also extended options which allow File Names to be generated by using variables. Any of the variables listed below can simply be entered into the Fixed File Name field in the Batch Reports screen and when the Batch Report is processed the data relating to each variable will be retrieved from SwiftPOS. This feature is mainly used by OnTap Data / Liquor File customers who need to create their scan data Report with a specific file naming convention. Note : When using the Fixed File Name option, SwiftPOS will append data to the file if it already exists.
Variable |
Type |
Description |
$Time1 |
Time |
Inserts the current time in the following format: HHmmss. |
$Time2 |
Time |
Inserts the current time in the following format: HHmm. |
$Date1 |
Date |
Inserts the current date in the following format: yyyyMMdd. |
$Date2 |
Date |
Inserts the current date in the following format: MMddyyyy. |
$Date3 |
Date |
Inserts the current date in the following format: ddMMyyyy. |
$Date4 |
Date |
Inserts the current date in the following format: yyMMdd. |
$Date5 |
Date |
Inserts the current date in the following format: MMddyy. |
$Date6 |
Date |
Inserts the current date in the following format: ddMMyy. |
$Date7 |
Date |
Inserts the current date in the following format: yyyyMMdd -1 day. |
$Date8 |
Date |
Inserts the current date in the following format: MMddyyyy -1 day. |
$Date9 |
Date |
Inserts the current date in the following format: ddMMyyyy -1 day. |
$Date10 |
Date |
Inserts the current date in the following format: yyMMdd -1 day. |
$Date11 |
Date |
Inserts the current date in the following format: MMddyy -1 day. |
$Date12 |
Date |
Inserts the current date in the following format: ddMMyy -1 day. |
$Date13 |
Date |
Inserts the current date in the following format: yyyyMMdd +1 day. |
$Date14 |
Date |
Inserts the current date in the following format: MMddyyyy +1 day. |
$Date15 |
Date |
Inserts the current date in the following format: ddMMyyyy +1 day. |
$Date16 |
Date |
Inserts the current date in the following format: yyMMdd +1 day. |
$Date17 |
Date |
Inserts the current date in the following format: MMddyy +1 day. |
$Date18 |
Date |
Inserts the current date in the following format: ddMMyy +1 day. |
$GrpPrefix |
Location Group Prefix |
Inserts the Location Group Prefix into the filename, e.g.: 0001. |
$Site0 |
Location Group ID |
Inserts the Location Group ID as raw data, e.g.: 12. |
$Site1 |
Location Group ID |
Inserts the Location Group ID into a 1 character string. |
$Site2 |
Location Group ID |
Inserts the Location Group ID into a 2 character string. |
$Site3 |
Location Group ID |
Inserts the Location Group ID into a 3 character string. |
$Site4 |
Location Group ID |
Inserts the Location Group ID into a 4 character string. |
$Site5 |
Location Group ID |
Inserts the Location Group ID into a 5 character string. |
$Site6 |
Location Group ID |
Inserts the Location Group ID into a 6 character string. |
$Site7 |
Location Group ID |
Inserts the Location Group ID into a 7 character string. |
$Site8 |
Location Group ID |
Inserts the Location Group ID into a 8 character string. |
$Site9 |
Location Group ID |
Inserts the Location Group ID into a 9 character string. |
Related Topics
- Administration
- Custom Batch Export/Reports
- POS Configuration Index - Reporting Configuration
- POS Operation Index - Reporting Features
- Report Filters/Settings
- Reports