Reference for exporting bookmarks and history in Firefox

 

Exporting bookmarks into html format

1. Click the Bookmarks button and select Show All Bookmarks to open the Library window.
2. From the toolbar on the Library window, click Import and Backup and choose Export Bookmarks to HTML....

 

how do I save my browsing history to a separate file, before cleaning my cache

 

If you wish to preserve the history save your Firefox profile , or specifically the database file places.sqlite

 

Use SQLite plugin for firefox and mount the places.sqlite file.   The file is located in:

C: \ Users \ \ App Data \ Roaming \ Mozilla \ Firefox \ Profiles \ \ places.sqlite

 

Once SQLite is installed in Firefox, go to the Tools menu and select the application.  Once opened, use: Database / Connect Database / C:/temp/places.sqlite  (location you copied the users places.sqlite file)

 

 

Get the bookmarks into a readable format[1]

You can easily get dates in a readable format by converting the Unix Epoch format to a date/time format:

SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,'unixepoch') AS DateAdded

FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id

I don't think that it matters which table is open when you paste the code in the "Execute SQL" text area to run the code.

 

 

 

 

In Firefox, need help pulling up history on specific date [2]

You need to scroll down through the history until you arrive there or try to formulate a query to select that date.

• https://developer.mozilla.org/en/Places_query_URIs

---

You can also use the SQLite Manager extension to create list

• SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/

1. Open Profile Directory -> places.sqlite -> Go
2. Hit the Execute SQL tab
3. Use a Select like this:

SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title

FROM moz_places, moz_historyvisits

WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000

That query shows all history entries from April
The date and time is saved in 64 bit EPOCH format in micro seconds.

• http://en.wikipedia.org/wiki/Unix_time

..........

---

[1] https://support.mozilla.org/en-US/questions/996638

[2] https://support.mozilla.org/en-US/questions/835204

Secret Ctrl-F12 console in Adobe Premiere CS6

Was tired of having Premiere CS6 generate a peak file with every video that I imported into it.  Found this article 5 hidden features in Adobe Premiere CS6  that shows how to bring up a console allowing you to disable this feature and other setting in Premiere.

Using CSVDE - Group name with space

Was working with CSVDE to export users into a csv, but had no luck with exporting users from a group name containing spaces (i.e  "Group 2").  One of my examples had the filter contained in quotes.

Discovered that:
The filter clause should be enclosed in parenthesis, not quotes. The quotes
should enclose the distinguished name of the group.

csvde -f report.txt -r (memberOf=CN="Group 2",OU=Test1,DC=t410corp,DC=com) -l
sAMAccountName,displayName,mail

You can also replace the space with "\20" (without the quotes).

How to Fix C00002E2 Directory Services could not start error – jet engine error

 

Running a Active Directory on Windows Server 2012 Core in a VM on a Hyper-V host.  The host lost power and corrupted the AD instance running on the VM.

 

Server 2012 would enter into the Repair mode and I caught the error 0x0c00002e2 as the resultant issue and discovered that AD was indeed corrupted.  This is the only domain controller for the domain and has accounts on it, so a backup was not an option.  (I know.... Murphy was in rare form today).

 

I found two helpful links:

 

How to recover Hyper-V Guest Domain Controller from Stop Error 0xc00002e2
(Michael Pollards answer was helpful, but I ran into a deeper problem because the ntds.dit database was corrupt).

• Open a Command Prompt (Win-R, CMD, Enter). Type NTDSUTIL and press Enter.
• Type activate instance ntds and press Enter.
• Type Files and press Enter.
• Type Info and press Enter. Verify the folder is actually C:\Windows\NTDS.
• Type Compact to and press Enter. I created C:\Windows\NTDS\Temp and used that.
• Copy the new file Ntds.dit in the temp folder over top of the old one in NTDS, and delete all the *.log files.

However, when trying to compact the database, I received basically the error:
                        could not initialize the jet engine error 501

 

How to Fix C00002E2 Directory Services Could Not Start – Blue Screen
Very helpful, and I was able to boot the domain controller.

 

Basic steps were:

 

Boot into Directory Services Restore Mode. When the server powers on, press F8 before the OS begins to load.  I used the recovery mode| change startup button, to bring up the boot options.

 

I was running Server Core, so from the prompt, cd \windows\ntds
Created a 'temp' folder in the c:\windows\ntds folder.
Copied the ntds.dit file to that temp folder.
Ran the commands below:

 

• Type: esentutl /g c:\windows\ntds\ntds.dit
• This will perform an integrity check, (the results indicate that the jet database is corrupt - ok)
• Type: esentutl /p   c:\windows\ntds\ntds.dit
• Agree with the prompt

I had to run the last command twice for it to return success.
Rebooted and system was up an running.