From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Thierry Volpiatto Newsgroups: gmane.emacs.help Subject: Re: syncing w3m/firefox bookmarks Date: Sat, 21 Nov 2009 23:17:30 +0100 Organization: ThierryVolpiatto Message-ID: <87pr7by139.fsf@tux.homenetwork> 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=utf-8 Content-Transfer-Encoding: 8bit X-Trace: ger.gmane.org 1258842269 1453 80.91.229.12 (21 Nov 2009 22:24:29 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Sat, 21 Nov 2009 22:24: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:24:23 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 1NByNP-0001zp-9r for geh-help-gnu-emacs@m.gmane.org; Sat, 21 Nov 2009 23:24:19 +0100 Original-Received: from localhost ([127.0.0.1]:37272 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NByNO-0003Gt-N5 for geh-help-gnu-emacs@m.gmane.org; Sat, 21 Nov 2009 17:24:18 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NByMz-0003Gg-JQ for help-gnu-emacs@gnu.org; Sat, 21 Nov 2009 17:23:53 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1NByMv-0003Dc-QE for help-gnu-emacs@gnu.org; Sat, 21 Nov 2009 17:23:53 -0500 Original-Received: from [199.232.76.173] (port=34030 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NByMv-0003DN-Kn for help-gnu-emacs@gnu.org; Sat, 21 Nov 2009 17:23:49 -0500 Original-Received: from lo.gmane.org ([80.91.229.12]:49060) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1NByMv-0004sX-8b for help-gnu-emacs@gnu.org; Sat, 21 Nov 2009 17:23:49 -0500 Original-Received: from list by lo.gmane.org with local (Exim 4.50) id 1NByMr-0001ik-R0 for help-gnu-emacs@gnu.org; Sat, 21 Nov 2009 23:23:45 +0100 Original-Received: from 23.77.197-77.rev.gaoland.net ([77.197.77.23]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 21 Nov 2009 23:23:45 +0100 Original-Received: from thierry.volpiatto by 23.77.197-77.rev.gaoland.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 21 Nov 2009 23:23:45 +0100 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 44 Original-X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 23.77.197-77.rev.gaoland.net Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAElBMVEUHBARgJRFPS0WbMBTC TSG/uJs0yyVHAAAACXBIWXMAAAsSAAALEgHS3X78AAAACXZwQWcAAAAwAAAAMADO7oxXAAABpUlE QVQ4y3VTQXKDMAyUnD7AwvQOhtxj5N4LFh9ow/+/UtlpM0BczWSS0Wola7UBeEb3+3kJ/5p9ZLz3 UI0n0J0Y4K/lh1nG24FhlJOR2LdSKtpV5gfi/Zd+NdaJBbB4D5N0JnfUIVp6obZURkJwS2a8b9uX AkgxA5gCEcknAH1s2z0DPooWmjGKcJR+HNZt+9bm0GtGRycRuZGs98Ffr02vABWGopIAhmXmxnQN BwBXZjgFLHRoqbfeYxCLWqsjLyKhbEHW+A5nEs699Q2O80ALrgHTmUTy6P0MnKyKQpKHpoNWokxs F0D5VegvWmEozyE6nuMiS98mWzlUQ9bW8qYfqOaFtzWlYCqGeIs6HEyl08jkrxUG9MF5ipXpOOpd ZMoXPPVSLWJiiwNNB+eRSyxJZmQKcacikgucnCRiHuJOLmyYJRDPwOqAvY4pA+Wy+VS8G26BAsdb Ph2Hw7ORy/H0IOG0TnaM8Cp0XrFYyU0v2z8AqkifPVbLZ0qo/gsRg60C7p+8Ov9jrUIxFde+jnAq X42hyp/c+ZcnVyUYBarrqZt3+R8450png3cWKgAAACV0RVh0Y3JlYXRlLWRhdGUAMjAwOC0wNS0z MVQyMjoxNDoyMiswMjowMM7uH/IAAAARdEVYdGpwZWc6Y29sb3JzcGFjZQAyLHVVnwAAACB0RVh0 anBlZzpzYW1wbGluZy1mYWN0b3IAMngyLDF4MSwxeDFJ+qa0AAAAJXRFWHRtb2RpZnktZGF0ZQAy MDA3LTEwLTI4VDE3OjA4OjQ4KzAxOjAwhqNSRgAAAABJRU5ErkJggg== User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.1.50 (gnu/linux) Cancel-Lock: sha1:/w2dZpJSmPmpCRDgUyavjXn1sTM= X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 3) 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:70012 Archived-At: rustom writes: > On Nov 21, 10:15 pm, Thierry Volpiatto > wrote: >> rustom writes: >> > On Nov 21, 11:30 am, 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 = >> > 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) > Thanks, it will be helpful as i have a poor knowledge of sql. -- A + Thierry Volpiatto Location: Saint-Cyr-Sur-Mer - France