Join the Mozilla’s Test Days event from Dec 2–8 to test the new Firefox address bar on Firefox Beta 134 and get a chance to win Mozilla swag vouchers! 🎁

Mozilla 도움말 검색

고객 지원 사기를 피하세요. 저희는 여러분께 절대로 전화를 걸거나 문자를 보내거나 개인 정보를 공유하도록 요청하지 않습니다. "악용 사례 신고"옵션을 사용하여 의심스러운 활동을 신고해 주세요.

자세히 살펴보기

How to remove all descriptions from all bookmarks?

  • 4 답장
  • 3 이 문제를 만남
  • 13 보기
  • 최종 답변자: user1129207

more options

Having descriptions makes for a very large file when exporting bookmarks. I would like to remove all the descriptions in bulk from all my bookmarks. How would I achieve this?

As well, is there any way to stop Firefox from adding the description when bookmarking a page?

Having descriptions makes for a very large file when exporting bookmarks. I would like to remove all the descriptions in bulk from all my bookmarks. How would I achieve this? As well, is there any way to stop Firefox from adding the description when bookmarking a page?

선택된 해결법

Try to run the code posted here in SQLite Manager.

The last posted code (Query 4) will remove the descriptions. You can use query 3 to see the descriptions


-- Query 3: test compound query
Select Content
From moz_items_annos
Where ID In (
Select Itm.ID
From moz_anno_attributes As Atr
Join moz_items_annos As Itm On Atr.ID = Itm.anno_attribute_id
Where Atr.Name = 'bookmarkProperties/description'
And Itm.Content Not In ('', 'Add bookmarks to this folder to see them displayed on the Bookmarks Toolbar')
)

-- Query 4: update Descriptions to empty string
Update moz_items_annos
Set Content = ''
Where ID In (
Select Itm.ID
From moz_anno_attributes As Atr
Join moz_items_annos As Itm On Atr.ID = Itm.anno_attribute_id
Where Atr.Name = 'bookmarkProperties/description'
And Itm.Content Not In ('', 'Add bookmarks to this folder to see them displayed on the Bookmarks Toolbar')
)
문맥에 따라 이 답변을 읽어주세요 👍 1

모든 댓글 (4)

more options

선택된 해결법

Try to run the code posted here in SQLite Manager.

The last posted code (Query 4) will remove the descriptions. You can use query 3 to see the descriptions


-- Query 3: test compound query
Select Content
From moz_items_annos
Where ID In (
Select Itm.ID
From moz_anno_attributes As Atr
Join moz_items_annos As Itm On Atr.ID = Itm.anno_attribute_id
Where Atr.Name = 'bookmarkProperties/description'
And Itm.Content Not In ('', 'Add bookmarks to this folder to see them displayed on the Bookmarks Toolbar')
)

-- Query 4: update Descriptions to empty string
Update moz_items_annos
Set Content = ''
Where ID In (
Select Itm.ID
From moz_anno_attributes As Atr
Join moz_items_annos As Itm On Atr.ID = Itm.anno_attribute_id
Where Atr.Name = 'bookmarkProperties/description'
And Itm.Content Not In ('', 'Add bookmarks to this folder to see them displayed on the Bookmarks Toolbar')
)
more options

I was just testing and four of my 300 descriptions are for folders (presumably I added those to help myself remember the point of what was in those folders). If you have added descriptions to folders and didn't want to delete those, you would need something along the lines of the criterion I've bolded here:

SELECT moz_items_annos.content 
FROM moz_items_annos INNER JOIN moz_bookmarks ON 
  moz_items_annos.item_id=moz_bookmarks.id 
WHERE anno_attribute_id=3 AND moz_bookmarks.type=1

When you're comfortable that you're viewing just what you want to delete, then you could create a DELETE query. I didn't test that myself.

more options

"Export" of bookmarks involves Firefox creating a bookmarks.html file, rather than doing a manual "backup" into a bookmarks.json format file. When it comes to doing an export, the descriptions for bookmarks is very small in comparison to the Favicon data that would exported. A bookmarks.html being exported can be as much as 25 times as large as the same bookmarks file from which the Favicon data was deleted.

more options

@cor-el As I already had SQLite Manager installed, this worked like a charm. Thank you very much!

Is there no way to stop Firefox from adding the descriptions when bookmarking sites? If not, this would be an excellent addition.

@the-edmeister I already have favicons turned of inFfirefox through the about:config.

Again, thanks for the swift replies. I shall mark this resolved.