Skip to main content

Export all Outlets Report

This article outline how to export a list of all your outlets and their data

Written by Noel

Overview

Weighsoft does not currently have an "Export" option on the Outlets screen (although it has been requested to be added in a future version of the software).

In order to get the information you can either speak to support to get an extract of the data, or follow the below steps to create a report which will export the data for you and can be run at any time going forwards,


Create a Custom Report

To get a "Data Dump" such as this it is usually better to use the "Report Generator 1" which essentially passes a query to the background of the system and displays the response.

  1. Hover on Reports and Click on View More Reports

  2. Click on "Generator 1" in the top-right corner

  3. In the "Title" field enter "Outlet Export Report"

  4. In the "Code" area, paste the below "Report Code" text exactly as it appears.

  5. Click on Create

  6. Click on Report to run the report

Important: Do not edit the report code text at all without first talking to the Support Team.
​
The code is a query designed to get specific data from the databse itself so any changes must be in the correct format or could potentially casue issues accross the entire system

Report Code

select o.Code, o.Name, o.Address1, o.Address2, o.Address3, o.Town, o.Postcode, o.Telephone, o.Internal, o.ExternalOutlet, l.Description as 'Linked Location', a.Description as 'Set Activity', o.WasteCode, 
s.Name as 'Linked Supplier', o.InvoiceName, o.IsDefaultActivity, o.IsDefaultSkipOrder, o.IsDefaultWeighbridgeLocation, o.IsDefaultMaterialOrder, o.IsDefaultHazOrder, o.IsDefaultRMCOrder, o.Deleted, o.LastModified, o.LastModifiedUser, * from Outlet o
left join location l on l.id = o.locationid
left join ActivityCode a on a.id = o.ActivityId
left join Supplier s on s.id = o.supplierid
left join account ac on ac.id = o.customeraccountid

Did this answer your question?