how do I sort autofill data?
How do I get form data sorted properly. I have already done the browser.formfill.bucketsize = 999999999. However it still sorts "joed571@hotmail.com" and "joed572@hotmail.com" ahead of "joed57@hotmail.com".
How do I get form data sorted properly. I have already done the browser.formfill.bucketsize = 999999999. However it still sorts "joed571@hotmail.com" and "joed572@hotmail.com" ahead of "joed57@hotmail.com".
All Replies (3)
You can try to do the sorting with the SQLite Manager extension.
- SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/
- Open formhistory.sqlite (you may need to do this on a copy of the file)
- Hit the Execute SQL tab
- Drop the existing moz_formhistory_index and create a new moz_formhistory_index
drop index "main"."moz_formhistory_index"; CREATE INDEX moz_formhistory_index ON moz_formhistory (fieldname,value);
Use this for case insensitive sorting:
CREATE INDEX moz_formhistory_index ON moz_formhistory (fieldname,value COLLATE NOCASE);
Where do I find formhistory.sqlite?
Never mind I found it. But I don't understand what I am supposed to do with it. I need an exact step by step instruction.
Modified by jdevlin
That is a file in the Firefox Profile Folder. SQLite Manager has a button (Select Profile Database) to open files in the Firefox Profile Folder.