Follow

Viewing and Exporting Posted Modules (Excel/CSV) (with video guidance)

In this guidance, you will learn:

  • How to view the posted modules' data
  • How to export the posted modules' data 
  • How to read CSV file 
  • The difference between CSV V1 and V2 files 

Users can now view posted modules and export data using CSV exports in Higg.org. If the module is not posted, you can't review and export the module data. 

Video guidance: https://apparelcoalition.org/updated-exporting-module-data/

Viewing Posted Modules

  1. To view either your own, or a shared posted module, go to the "Modules" tab in FEM or FSLM.
  2. Find the module you would like to view, either in "My Modules" (if it is your own module) or in "Shared with me" section (to view a shared posted module).
  3. Click on the "View Assessment" icon next to the module you'd like to view.
  4. If the shared module is not posted, you can't view their module data.
  5. This will open the module in the online platform so you can review responses throughout the assessment.

 Screen_Shot_2019-11-11_at_3.17.04_PM.png

Screen_Shot_2019-11-11_at_3.16.35_PM.png

 

Exporting Posted Modules (Excel File)

Exporting a single module:

1. Follow the same steps above to access the Modules page for FEM or FSLM. 

2. Find the module you would like to export, either in "My Modules" (if it is your own module) or in "Shared with me" section (to export a shared posted module).

3. Click on the "Excel" to export the module into the excel file. The file will show up in your downloads. 

4. If the shared module is not posted, you can't export their module data into excel file. 

Screen_Shot_2019-11-11_at_3.35.32_PM.png

Screen_Shot_2019-08-01_at_1.30.41_PM.png

 

Exporting Posted Modules (CSV)

Exporting a single module:

1. Follow the same steps above to access the Modules page for FEM or FSLM. 

2. Find the module you would like to export, either in "My Modules" (if it is your own module) or in "Shared with me" section (to export a shared posted module).

3. Click on the "CSV v1" or "CSV v2" to export the module into the .csv file. The file will show up in your downloads. 

  • CSV v1: self-assessment and verified assessment data is located in two rows

Screen_Shot_2019-11-11_at_3.45.35_PM.png

  • CSV v2: self-assessment and verified assessment data is located in one row

Screen_Shot_2019-11-11_at_3.46.59_PM.png

4. If the shared module is not posted, you can't export their data into the CSV file. 

Screen_Shot_2019-11-11_at_3.41.12_PM.png

 

Exporting all shared posted modules into one file (bulk export):

1. Follow the same steps above to access the Modules page for FEM or FSLM. 

2. Go to the "Shared with Me" section to view shared modules. 

3. Click on the "Download Bulk CSV v1" or "Download Bulk CSV v2" button at the top right of the page. This will download your bulk .csv file. The file will show up in your downloads. 

Same as single CSV file,

  • Bulk CSV v1: self-assessment and verified assessment data is located in two rows

Screen_Shot_2019-11-11_at_3.57.46_PM.png

  • Bulk CSV v2: self-assessment and verified assessment data is located in one row

Screen_Shot_2019-11-11_at_3.56.56_PM.png

4. If the shared module is not posted, you can't export their data into the bulk CSV file.

Screen_Shot_2019-11-11_at_3.49.19_PM.png

 

Understanding the Higg FEM Bulk CSV Export:

The Bulk CSV includes 5 key sections of information in the following order:

  • Account and module information
  • Higg FEM scoring results for total, section, level, and question scores
  • Air emission, wastewater, water and chemical management sections applicability 
  • All module response data (answers to module questions) 
  • All module verification data (including the verified result and corrected response) 
  • Total GHG emission amount and GHG calculations 

Please use the reference excel file attached below to understand what the column headers in the bulk export are referring to. 

A few things to be aware of when using the bulk export:

  • The sections of the module may be out of order. Please use the reference guide attached below and the column headers to identify which section of data you are looking at within the module. 
  • "Null" or blank means the question or section was not applicable/visible to that facility
  • Energy Level 3 is un-scored and will not show up in the scoring section
  • If you are looking for the Site Info Permits section, look for the column headers starting with "sip" (e.g. sipindustrysector, sipfacilitytype, etc.)

Please use the reference guide attached below to understand what the column headers in the bulk export are referring to (note there are three tabs):

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.