| Index: trunk/wikistats/analytics/_readme.txt |
| — | — | @@ -0,0 +1,21 @@ |
| | 2 | +This folder contain bash and perl files to create and fill database 'analytics', a.o. for monthly dashboard. |
| | 3 | + |
| | 4 | +== analytics_new.sh == |
| | 5 | +Defines the database and tables and loads data from existing csv files. |
| | 6 | +It executes SQL from analytics_create_and_load_from_csv.txt |
| | 7 | + |
| | 8 | +== analytics_upd.sh == |
| | 9 | +Prepares new csv files (delegated to analytics_generate_csv_files.sh), |
| | 10 | +and empties and reloads all tables for which csv files are in this folder. |
| | 11 | +It executes SQL from analytics_refresh_from_csv.txt |
| | 12 | + |
| | 13 | +== CSV files == |
| | 14 | +CSV files and where they are generated: |
| | 15 | + |
| | 16 | +analytics_in_binaries.csv <- AnalyticsPrepBinariesData.pl |
| | 17 | +analytics_in_comscore.csv <- AnalyticsPrepComscoreData.pl |
| | 18 | +analytics_in_comscore_regions.csv <- manual |
| | 19 | +analytics_in_language_names.csv |
| | 20 | +analytics_in_offline.csv <- manual |
| | 21 | +analytics_in_page_views.csv <- /home/ezachte/wikistats/pageviews_monthly.sh (file copy after that) |
| | 22 | +analytics_in_wikistats.csv <- AnalyticsPrepWikiCountsOutput.pl |