Chemwatch Knowledgebase

Generally, there are two options to generate Manifest related reports for materials located in folders/stores using the Report Generator tool. 

1. Basic Template(s) - accessible through the Basic tab

A worked example is provided below.

2. Advanced Template(s) - accessible through the Advanced tab

A worked example is provided below.

The Report Generator tool provides the ability to extract data based on specific datapoints located in method builder directories. Any report can be generated through various formats listed in the description table below.

The table below provides the descriptions of the available various formats to choose from when generating a report..

Table: File Formats and Descriptions

File Format	File Extension	Description	Graphic
Microsoft excel (XLS)	.xls	XLS file is a spreadsheet format in MS windows and Mac OS which features calculation tools and graphical tools, pivot tables and used as an industry standard for spreadsheets. This type of format uses a grid f cells arranged in numbered rows and letter-named columns to organise data manipulations like arithmetic operations.
Comma-separated values (CSV) (recommended)	.csv	CSV file consists of any number of records separated by line breaks of some kind; each record consists of fields separated by some other character or string, most commonly a literal comma or tab.  Usually, all records have an identical sequence of fields. CSV is a delimited data format that has fields/columns separated by the comma character and records/rows terminated by new lines and can apply own separator.
HyperText Markup Language (HTML)	.html	HTML file is a web page format file that can be displayed in a web browser. HTML allows data text, images and objects to be embedded and supports various languages. Supports common browsers; google chrome, firefox and internet explorer. Common browsers    Google chrome  Firefox Internet explorer  Safari
Extensible Markup Language (XML)	.xml	XML file can be used through the internet. It utilises textual data format via Unicode for global languages. XML-based formats have become the default for many office-productivity tools, including Microsoft Office(Office Open XML), OpenOffice Apple iWork.  XML has also been employed as the base language for communication protocols, such as XMPP. Applications for the Microsoft .NET Framework use XML files for configuration.
Microsoft excel (XLSX)	.xlsx	default file format for documents used by Microsoft Excel as of Excel 2007

Common reports containing data points required for reporting purposes are:Manifest Hazardous Chemicals Register or Dangerous Goods Register. 

These types of reports may include the following data points; Material Name, Cat Name (Product Name, Supplier, Date of Manufacture, Location (Folders/Stores Path), Dangerous Goods (DG) Class, Packing Group, UN Number, Manifest Quantity (Volume/Weight ), Hazchem, Poison Schedule, etc.

Worked Example: Generate Reports using Basic Templates

The following steps illustrate the sequence with screen capture on ‘how to use a basic template to export data to a spreadsheet. In this worked example, the data will be exported from a folder node at the Area (level 1) of the tree using the basic template name “Manifest locations and volumes GOLD”.  

Steps

In "simple search mode" select the Home module button  (if it’s not already the default module)

1. Expand Manifest directory nodesto view the folder location, e.g. level 1 Area node

2. Press the Folder name. Take note that the manifest list grid defaults to Cat Name. The default view mode is Cat Name.

3. Clickthe Report Generator button at the top right corner of the user interface

4. Ignore the default selection “Selected”and click the Current page radio button option

5. Click the OK button

6. Select the Report field’s drop-down arrow  to list available report templates 

7. Select the Report name template from the list, e.g., Materials volumes and locations GOLD

8. Select the Country from the drop-down arrow , e.g., Australia 

9. Select the Language from the drop-down arrow , e.g., English 

10. Select the SDS format as GHS from the drop-down arrow  

11. Select the Report units from the drop-down arrow , e.g., Original

12. Select the Format from the drop-down arrow, e.g., XLS

13. Pressthe Download button

Steps

In "simple search mode" select the Home module button  (if it’s not already the default module)

1. Expand Manifest directory nodes to view the folder location, e.g. level 1 Area node

2. Press the Folder name. Take note that the manifest list grid defaults to Cat Name. The default view mode is Cat Name.

3. Clickthe Report Generator button at the top right corner of the user interface

4. Ignore the default selection “Selected”and click the Current page radio button option

5. Click the OK button

6. Press the Advanced tab from the report generator panel

7. Select the Country from the drop-down arrow  , e.g., Australia

8. Select the Language from the drop-down arrow  , e.g., English 

9. Select the SDS format as GHS from the drop-down arrow  

10. Hover move pointer over the Add icon to open the method builder window in order to add data points and then create a report template

11. Click the Add Report datapoints button to open the method builder window and create a report template

12. Select the expand arrow   next to the Identification folder directory to open the list of datapoints

13. Click the data points checkboxes  listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

14. Scroll up to select the expand arrow  next to the PPE folder directory to open the list of datapoints

15. Click the data point checkboxes   listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

16. Scroll down to select the expand arrow next  to the Physical Properties folder directory to open the list of datapoints

17. Click the data points checkboxes  listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

18. Scroll down to select the expand arrow next  to the Regulatory folder directory to open the list of datapoints

19. Click the data points checkboxes   listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

20. Scroll down to select the expand arrow next  to the Dangerous Goods (DG) Data folder directory to open the list of datapoints

21. Click the data points checkboxes  listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

22. Scroll down to select the expand arrow next  to the Safety folder directory to open the list of datapoints

23. Click the data points checkboxes   listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

24. Scroll down to select the expand arrow nextto the Manifest folder directory to open the list of datapoints

25. Click the data points checkboxes   listed below. Note that the selected data points will be automatically listed on the right-hand side pane for further editing.

26. Type  the Report template name in the Report Name free text field

27. Press the Create Report button

   A confirmation message will display in the top middle of the user interface when the report is created and the method builder window will close and the report generator panel will be retained to continue the tasks below.

28. Select the “Enable multiple” checkbox  

29. Select the Report units from the drop-down arrow  , e.g., Original

30. Select the Format from the drop-down arrow, e.g., XLS

31. Select the Download images checkbox

32. Pressthe Download button

33. Choose a “file location” from the desktop/laptop to save the report if your desktop is not set to automatically save downloads to the “Downloads Folder” 

34. Open the downloaded file “Manifest Data Report.xls”

35. The report exports data into the respective report format, e.g., spreadsheet .

The datapoints in the report templatein the Advanced mode have been created by Chemwatch and the information exported is an inference from the data located in the source folder or location within the system’s tree structure, which is data drawn from your company’s inventory.

Manifest Report with GHS Pictograms

Manifest Report with DG Diamonds