importing statistics from another solution

Posted on 04/04/2011 15:51:20

I want to import the statistics from one solution to another and I only want the last to years. How would I go about doing it?
Witch tables are involved?

Replies

Posted on 05/04/2011 02:13:05

Hi
If you have access database it’s enough to copy Statisticsv2.mdb file.
If you have MSSQL database you need to copy tables:
-        Statv2NotFound
-        Statv2Object
-        Statv2Page
-        Statv2s
-        Statv2Session
-        Statv2SessionBot

If you have configured statistics triggers you also need to copy next tables.
-        StatsV2Trigger
-        StatsV2TriggerMail
-        StatsV2TriggerSession
-        StatsV2TriggerStep

Posted on 05/04/2011 08:41:31

It's a MSSQL.
What is the best and easiest way to copy these tables?
I was thinking of only copying the last two years.
Witch and how are the tables connected and are there any dependencies?

Posted on 06/04/2011 03:21:53

1. The best way is MSSQL import wizard. Dynamicweb doesn’t contain functionality for statistic migration.

2. It’s difficult to limit copying data by 2 years – you need to manually remove older rows (I don’t see another way how to limit it, but maybe MSSQL can filter import data by condition – I don’t know).

3. There are next dependencies:

a. Statv2Page depends from Statv2Object

b. StatsV2TriggerStep depends from StatsV2Trigger

There is no other dependencies within mentioned tables.

I want to prevent you from unnecessary actions. Statv2Session table (main statistics table) contain links (not dependences) to users and pages. If you have different users and pages this copying statistics will not be actual.

Describe please full situation, why do you need to copy only statistics, why don’t you need pages, paragraph tables? This information helps me give you right solution.

You must be logged in to post in the forum

Developer forum

importing statistics from another solution

Replies