Import Encrypted Images - Revision history

Atlioddsson at 14:26, 24 February 2016

2016-02-24T14:26:58Z

Atlioddsson at 08:42, 24 February 2016

2016-02-24T08:42:00Z

Atlioddsson at 16:04, 24 April 2014

2014-04-24T16:04:15Z

Atlioddsson: Created page with "Let's say you've lost your TimeSnapper database (for whatever reason) but you have all the images in a safe place. However, you are not able to view them since you've password p..."

2011-11-26T17:41:41Z

Created page with "Let's say you've lost your TimeSnapper database (for whatever reason) but you have all the images in a safe place. However, you are not able to view them since you've password p..."

New page

Let's say you've lost your TimeSnapper database (for whatever reason) but you have all the images in a safe place. However, you are not able to view them since you've password protected them. TimeSnapper uses a very secure way of encrypting the images so that no one can view them unless they have the password.

So when you start TimeSnapper for the first time, it creates a new database. You'll need to import the images into TimeSnapper be let it know where those images are. You do that by:

Tools > Advanced > Import images from older version

When TimeSnapper imports the images, it is unaware that they are encrypted (that information is saved in the database that got lost). So, what you need to do is tell TimeSnapper that these images are encrypted by updating the database. First make sure you:

Tools > Options > Privacy > Check the protect screenshots and use the same password as previously

Then using TS SQL Executer plugin [[SQL Executer Plugin]], run the following update (called an SQL statement):

update activity set PWDID = (select max(PWDID) from pwd) where SNAPDATE < '2011-10-15'

... and now you should be all set! (Make sure you update the date in the SQL statement appropriately.)

@@ Line 21: / Line 21: @@
      update activity set PWDID = (select max(PWDID) from pwd)
-Now click "OK".  Then TimeSnapper should connect all the existing pictures that you have imported to the password you just entered.
+or if you only want to update for e.g. the year 2015:
      update activity set PWDID = (select max(PWDID) from pwd) where SNAPDATE between '2015-01-01' and '2015-12-31'
-... and now you should be all set!  (Make sure you update the date in the SQL statement appropriately - this will update all from the year 2015.)
+Now click "OK".  Then TimeSnapper should connect all the existing pictures that you have imported to the password you just entered.

@@ Line 31: / Line 31: @@
 Then using TS SQL Executer plugin [[SQL Executer Plugin]], run the following update (called an SQL statement):
-     update activity set PWDID = (select max(PWDID) from pwd) where SNAPDATE < '2011-10-15'
+     update activity set PWDID = (select max(PWDID) from pwd) where SNAPDATE between '2015-01-01' and '2015-12-31'
-... and now you should be all set!  (Make sure you update the date in the SQL statement appropriately.)
+... and now you should be all set!  (Make sure you update the date in the SQL statement appropriately - this will update all from the year 2015.)

@@ Line 8: / Line 8: @@
 When TimeSnapper imports the images, it is unaware that they are encrypted (that information is saved in the database that got lost).  So, what you need to do is tell TimeSnapper that these images are encrypted by updating the database.  First make sure you:
-     Tools > Options > Privacy > Check the protect screenshots and use the same password as previously
+     Tools > Options > Privacy > Check the "protect screenshots" checkbox and use the same password as previously
 Then using TS SQL Executer plugin [[SQL Executer Plugin]], run the following update (called an SQL statement):