This article explains how to download the Connections export from the ZDHC Gateway. It helps brand users who track supplier progress in a spreadsheet or use the data for their own reporting.
01/ What's Changed
If you have used the Connections export before, the following changes apply:
- The ClearStream columns now show the supplier's latest ClearStream report, regardless of whether the supplier shares wastewater data with you.
- The supplier's wastewater data sharing setting now controls only the four RCA/CAP data columns. The column showing this setting is called RCA/CAP Shared.
- The export no longer contains empty cells. Every cell contains a value or one of the standard texts explained in the article What do the columns in the Connections export mean?
02/ Overview
The Connections export is a CSV file containing one row per connection associated with your organisation. Each row provides a summary of the connected organisation, helping you track supplier information and reporting status in one place.
The export includes:
- Organisation information: Gateway organisation ID, name, organisation type, country and industry IDs (OS ID, Higg ID and IPE ID).
- Wastewater and ClearStream: Wastewater profile, subscription status, and the date, ID, number of parameters and result of the latest ClearStream report.
- RCA/CAP: Whether the supplier shares RCA/CAP with your organisation, the number of RCA/CAP entries and how many remain unresolved.
- Chemical Inventory and InCheck: Subscription status, Chemical Inventory sharing permissions, and the date, ID and inventory type of the latest InCheck Report.
- Connection details: Connection status, who initiated the request, request date, connection labels and your organisation's data sharing settings.
The Connections export provides summary information for each supplier. To download the reports themselves in PDF or CSV format, use the Data Hub.
Important: The export contains connections in all statuses: active, pending, rejected and disconnected. The search and filters applied on the Organisation Connections page do not affect the exported file.
03/ Prerequisites
- You have a ZDHC Gateway account for a brand organisation.
04/ Steps
- Click Brand Module in the main menu at the top of the page.
- Click Connections in the menu on the left. The Organisation Connections page opens.
Click Export Connections at the top right of the page.
The CSV file downloads automatically. The ZDHC Gateway does not display a confirmation message.
- Find the file in your downloads folder. The filename follows the format connections-DD_MM_YYYY.csv, using the export date.
- Open the file in your spreadsheet programme. The CSV values are comma-separated.
To view only your current connections, filter the Status column to Active.
- Review the exported rows and columns to understand each supplier's connection, subscription and reporting information. Refer to the Knowledge Base guidance on interpreting the Connections export for further details.
05/ Tips & Notes
Tip: If special characters such as m³ or °C do not display correctly, import the CSV file instead of opening it directly. In Microsoft Excel, go to Data > From Text/CSV, select 65001: Unicode (UTF-8) as the file origin and Comma as the delimiter.
Note: The export always contains all your connections. Search and filters on the Organisation Connections page, including the default Active filter, do not change the exported file. As a result, the file may contain more rows than the list displayed on screen.