Marketplace/Reviewers/Apps/Weekly updates/run reports
From MozillaWiki
< Marketplace | Reviewers | Apps | Weekly updates
Contents
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
- Create output folder
- Create subfolder called
sql
- Download all the files in the folder to
sql
- alternatively edit
weekly.sh
to change the script folder. The script expects the following folder structure by default: - <output folder for the reports>
- <output folder for the reports>/sql/app_reviewer_report_tarako.sql
- <output folder for the reports>/sql/app_stats.sql
- ...
- alternatively edit
- run the following command, in the output folder:
sql/weekly.sh <fromdate> <todate> <dbusername> <dbpassword>
- e.g.
sql/weekly.sh 2014-10-24 2014-10-31 v1pUser s00perSecurePass
(not the actual credentials!)
- e.g.
- after the script has executed you should have 7 files (names reflect the <todate> used)
- developers 2014-10-31.txt
- App Reviewer Report 2014-10-31.txt
- App stats 2014-10-31.txt
- Rejected and Banned 2014-10-31.csv
- Rejected and Banned 2014-10-31.txt
- Approved and Queued 2014-10-31.csv
- Approved and Queued 2014-10-31.txt
- if you have write access, upload all these files to the App Reports folder
Next Steps for weekly apps report
- Convert the .csv output files into Google spreadsheets for ease of use by the report recipients
- Open a new (or any random existing) Google spreadsheet
- Go to File|Import and locate the Approved....csv file (its normally in Recent)
- In the Import dialog
- select 'Create new spreadsheet' as the action (the default) and
- select 'Tab' as the character separator
- Press Import; then Cancel once completed
- Repeat with Rejected....csv
- Locate the 2 new Google spreadsheets you created - they'll be in your drive root by default
- Move (drag and drop) them into the App Reports folder, which will share them also.
- Go to the folder and open the 2 spreadsheets to get the urls.
- Paste them into the weekly note.