From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: rustom Newsgroups: gmane.emacs.help Subject: Re: syncing w3m/firefox bookmarks Date: Sat, 21 Nov 2009 09:43:44 -0800 (PST) Organization: http://groups.google.com Message-ID: References: <87iqd5f9ea.fsf@fh-trier.de> <87y6m1vwpw.fsf@tux.homenetwork> <87r5rtvvd0.fsf@tux.homenetwork> <87ws1kewz2.fsf@fh-trier.de> <43eb3a87-24dd-4415-b091-6517e928175e@f18g2000prf.googlegroups.com> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: ger.gmane.org 1258841489 31668 80.91.229.12 (21 Nov 2009 22:11:29 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Sat, 21 Nov 2009 22:11:29 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Sat Nov 21 23:11:22 2009 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1NByAH-0003SB-TW for geh-help-gnu-emacs@m.gmane.org; Sat, 21 Nov 2009 23:10:46 +0100 Original-Received: from localhost ([127.0.0.1]:55067 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NBut8-0002Bx-Fh for geh-help-gnu-emacs@m.gmane.org; Sat, 21 Nov 2009 13:40:50 -0500 Original-Path: news.stanford.edu!usenet.stanford.edu!postnews.google.com!u36g2000prn.googlegroups.com!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 37 Original-NNTP-Posting-Host: 59.95.19.231 Original-X-Trace: posting.google.com 1258825425 4041 127.0.0.1 (21 Nov 2009 17:43:45 GMT) Original-X-Complaints-To: groups-abuse@google.com Original-NNTP-Posting-Date: Sat, 21 Nov 2009 17:43:45 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: u36g2000prn.googlegroups.com; posting-host=59.95.19.231; posting-account=mBpa7woAAAAGLEWUUKpmbxm-Quu5D8ui User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5,gzip(gfe),gzip(gfe) Original-Xref: news.stanford.edu gnu.emacs.help:174935 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:70007 Archived-At: On Nov 21, 10:15=A0pm, Thierry Volpiatto wrote: > rustom writes: > > On Nov 21, 11:30=A0am, Thierry Volpiatto > > wrote: > > >> TODO: > > >> - Importing Firefox bookmarks in Emacs bookmarks. > > > In /.mozilla/firefox// there is a sqlite database called > > places.sqlite > > > If you copy that out (safer that way!) to some other directory say ~/ > > tmp > > and there run > > ~/tmp$ sqlite3 places.sqlite > > > then give > > select * from moz_places, moz_bookmarks where moz_places.id =3D > > moz_bookmarks.fk > > you get (I think!!) something like a dump of firefox's bookmarks > > [My firefox is 3.5] > > Thank you for this precious info. ;-) > > -- > A + Thierry Volpiatto > Location: Saint-Cyr-Sur-Mer - France I think my sql is almost certainly wrong I got some sense of whats there from here (but its not enough) https://developer.mozilla.org/en/The_Places_database http://kb.mozillazine.org/Places.sqlite#Technical_Information Also if you want to hack on sqlite its nice to have something like sqlite manager (firefox plugin)