Marketplace/Reviewers/Apps/Weekly updates/run reports

Weekly SQL reports instructions

Prerequisites

• Mozilla LDAP and functional VPN access
• Access to the apps reports folder on Andrew's Google Drive - standard Mozilla LDAP credentials will do, or request access.
• Access to marketplacedb.ro.mktns.mktdb.services.phx1.mozilla.com
  • see https://mana.mozilla.org/wiki/display/websites/Services#Services-MarketplaceDatabaseROSlave
  • you will need access for your account enabling, as well as the common DB username and password
• mysql (5.5+)
• if not using a *nix based system, something that will execute bash scripts

Step by Step

1. Create output folder
2. Create subfolder called sql
3. Download all the files in the folder to sql
   1. alternatively edit weekly.sh to change the script folder. The script expects the following folder structure by default:
   2. <output folder for the reports>
   3. <output folder for the reports>/sql/app_reviewer_report_tarako.sql
   4. <output folder for the reports>/sql/app_stats.sql
   5. ...
4. run the following command, in the output folder: sql/weekly.sh <fromdate> <todate> <dbusername> <dbpassword>
   1. e.g. sql/weekly.sh 2014-10-24 2014-10-31 v1pUser s00perSecurePass (not the actual credentials!)
5. after the script has executed you should have 7 files (names reflect the <todate> used)
   1. developers 2014-10-31.txt
   2. App Reviewer Report 2014-10-31.txt
   3. App stats 2014-10-31.txt
   4. Rejected and Banned 2014-10-31.csv
   5. Rejected and Banned 2014-10-31.txt
   6. Approved and Queued 2014-10-31.csv
   7. Approved and Queued 2014-10-31.txt
6. if you have write access, upload all these files to the App Reports folder

Next Steps for weekly apps report

1. Convert the .csv output files into Google spreadsheets for ease of use by the report recipients
   1. Open a new (or any random existing) Google spreadsheet
   2. Go to File|Import and locate the Approved....csv file (its normally in Recent)
   3. In the Import dialog
      1. select 'Create new spreadsheet' as the action (the default) and
      2. select 'Tab' as the character separator
   4. Press Import; then Cancel once completed
   5. Repeat with Rejected....csv
2. Locate the 2 new Google spreadsheets you created - they'll be in your drive root by default
3. Move (drag and drop) them into the App Reports folder, which will share them also.
4. Go to the folder and open the 2 spreadsheets to get the urls.
5. Paste them into the weekly note.