Are we able to date filter all the reports on the admin website and have them published on the public website? The issue we have is all our reports on the public website are showing incorrect info as it includes double ups, we have all the match reports entered after 2004 but pre 2004 they are only spasmodic, and we have historical data covering the pre 2004 period. On the admin website I can filter the data by excluding pre 2004 data which will then exclude any double ups from matches entered before 2004 and the historical data – how do I do this with the public website?
Another question - can you import matches from the old Version 11 database into the online version?
As i could keep updating the old database with matches and then import them all at once...
The double ups are deliberate. As we have only entered random games between 1989 and 2004 we use the historical data to cover all those games, when we get a chance we continue to add in these older games. I just use the date filters in the admin version to remove those games when running all our reports.
For the public site it looks like we have 2 choices –
1. Remove all the pre 2004 games from the database until we have all those games entered, so the historical data in the current database will be correct and then when all the games have been entered, remove the historical data. Question though – can the random pre 2004 games be stored in a separate database and then merged with the main database when all games have been entered?
2. Don’t give anyone access to the public website until all games pre 2004 have been entered and just continue to use the admin website with date filters to remove pre 2004 games when running all reports.
cheers