Viewtracker 4.0.0

The data stored consists of:

  • The total amount of page views
  • The total amount of page views for each user
  • The time-stamp of the last page view of a user

 

If you had legacy data in the old format, Viewtracker 4.0 migrates all data into the new format: 

 

Since Viewtracker 4.0.0 the data is no longer stored as xml in the OS_PROPERTYENTRY table. We moved all implementations to Active Object because of performance reasons. All old views data will be migrated to the new data structure automatically.

Following entries will be migrated: 

  • Anonymous visits
  • Visits, where the user still has a Confluence account

(warning) Please note: Visits from users that can not be found in the Confluence user directory will not be migrated

 

The new table AO_05769A_VISIT_ENTITY looks like this: 

ColumnType 
CONTENT_IDBIGInt

The Id of the tracked page

IDINTPrimary Key
USER_KEYVARCHAR(255)The key of the tracked user
VISIT_TIMEDATETIMEThe timestamp of the Visit
DEVICE_TYPEINT

0 = Desktop

1 = Mobile


Some examples:


 

 

Viewtracker ≤ 3.2.2

The Viewtracker add-on stores its data for each page separately in the table os_propertyentry under the entity_key = ch.bitvoodoo.confluence.plugins.ViewTrackerMacro as XML.
Example:

<list>
  <ch.bitvoodoo.confluence.plugins.viewtracker.PageRequest>
    <value>11</value>
    <username>Total</username>
    <date>2014-10-29 11:18:38.442 CET</date>
  </ch.bitvoodoo.confluence.plugins.viewtracker.PageRequest>
  <ch.bitvoodoo.confluence.plugins.viewtracker.PageRequest>
    <value>8</value>
    <username>john.doe</username>
    <date>2014-10-31 10:28:10.543 CET</date>
  </ch.bitvoodoo.confluence.plugins.viewtracker.PageRequest>
  <ch.bitvoodoo.confluence.plugins.viewtracker.PageRequest>
    <value>3</value>
    <username>mike.miller</username>
    <date>2014-10-29 11:51:16.364 CET</date>
  </ch.bitvoodoo.confluence.plugins.viewtracker.PageRequest>
</list> 


The data stored consists of:

  • The total amount of page views
  • The total amount of page views for each user
  • The time-stamp of the last page view of a user

 

Comments  (0)

Attachments  (3)

Add Attachment
  File Modified
PNG File image2016-2-10 15:40:27.png 10. Feb. 2016 by Oliver Sträßer
PNG File image2016-4-22 14:13:18.png 22. Apr. 2016 by Oliver Sträßer
PNG File image2016-4-22 14:13:32.png 22. Apr. 2016 by Oliver Sträßer