MozillaZine

is it possible to selectively clear form history?

User Help for Mozilla Firefox
ginahoy
 
Posts: 217
Joined: October 18th, 2007, 8:32 pm

Post Posted May 5th, 2018, 1:15 pm

I frequently rely on the 'form history' feature that pre-fills email address, name, etc when submitting various website forms. If there a way to selectively delete stored data on a per-field basis, or for a given web page? Or maybe an add-on to manage form-history, similar to password management add-ons? This would avoid having to clear the entire form history and start over again -- for example, if I make a typo when submitting a form.

dickvl

User avatar
 
Posts: 52388
Joined: July 18th, 2005, 3:25 am

Post Posted May 5th, 2018, 11:04 pm

There is this extension, but you will have to update to Firefox 56 or later.
Form History Control https://addons.mozilla.org/firefox/addo ... y-control/

compatibility.firefox: {"max":"*", "min":"56.0"}

siffemoz
 
Posts: 112
Joined: January 29th, 2016, 4:36 pm

Post Posted May 6th, 2018, 12:05 am

The extension dickvl mentioned is likely the safest way, but if you like to twiddle you can delete selectively with DB Browser for SQLite (http://sqlitebrowser.org). Install it first, then:

- click FF Menu/Help/Troubleshooting Information
- click the Application Basics/Profile folder/Open folder button
- close FF and make a copy of formhistory.sqlite, then double click it

The DB browser should open and load that file. To delete entries:

- under Tables, R. click moz_formhistory and choose Browse table
- click the fieldname or value header to sort
- for any entries you want to delete, L. click the number to the far left of the entry
- click the Delete record button

When done, you'll be prompted to save.

ginahoy
 
Posts: 217
Joined: October 18th, 2007, 8:32 pm

Post Posted May 6th, 2018, 2:34 am

Thanks. I already have a FF add-on that can browse and delete records from sqlite database (SQLite Manager). Not sure why I didn't think of that!
Wow. My form history table has nearly a thousand entries! Probably best to delete and start fresh. In the meantime, I just deleted a particularly annoying entry that prompted my question =D>
Last edited by ginahoy on May 8th, 2018, 11:58 pm, edited 3 times in total.

siffemoz
 
Posts: 112
Joined: January 29th, 2016, 4:36 pm

Post Posted May 8th, 2018, 11:32 pm

I used to use SQLite Manager until Quantum came along :-)

dickvl

User avatar
 
Posts: 52388
Joined: July 18th, 2005, 3:25 am

Post Posted May 9th, 2018, 7:09 pm

See these pages about starting SQLite Manager as a standalone XULrunner application with Firefox 52 ESR:
https://github.com/lazierthanthou/sqlit ... /issues/31
https://github.com/lazierthanthou/sqlit ... r/releases

Download and save: sqlitemanager-xr-0.8.3-all.zip
Extract all files in the ZIP archive to a folder (sqlite-manager) and add a link (full path) to application.ini to the command line you use to start Firefox 52.

https://developer.mozilla.org/en-US/Moz ... #XULRunner

ginahoy
 
Posts: 217
Joined: October 18th, 2007, 8:32 pm

Post Posted May 9th, 2018, 11:29 pm

Thanks for the tip. I'm unfamiliar with XULrunner apps. You referred to FF52 ESR, but is it possible to run SQLite as standalone XULrunner app after I upgrade to Quantum? I just read the wikipedia page that said XULrunner is no longer supported.

tomatoshadow2

User avatar
 
Posts: 294
Joined: May 11th, 2017, 9:52 am

Post Posted May 9th, 2018, 11:32 pm

A lot of XUL has and is being removed from Firefox.

Frank Lion

User avatar
 
Posts: 20039
Joined: April 23rd, 2004, 6:59 pm
Location: ... The Exorcist....United Kingdom

Post Posted May 10th, 2018, 12:23 am

ginahoy wrote:I frequently rely on the 'form history' feature that pre-fills email address, name, etc when submitting various website forms. If there a way to selectively delete stored data on a per-field basis, or for a given web page?

Try this - https://support.mozilla.com/en-US/kb/co ... tocomplete
Metal Lion latest SeaMonkey & Thunderbird Themes - Sea Monkey and Silver Sea Monkey
"The only thing necessary for the triumph of evil, is for good men to do nothing." - Edmund Burke (attrib.)

Frank Lion

User avatar
 
Posts: 20039
Joined: April 23rd, 2004, 6:59 pm
Location: ... The Exorcist....United Kingdom

Post Posted May 10th, 2018, 12:24 am

Frank Lion wrote:
ginahoy wrote:I frequently rely on the 'form history' feature that pre-fills email address, name, etc when submitting various website forms. If there a way to selectively delete stored data on a per-field basis, or for a given web page?

Try this - https://support.mozilla.com/en-US/kb/co ... tocomplete


Deleting individual form entries

If you want to remove one of your previous form entries from Firefox's history:

Click on the form field and press the ↓ key to display all the saved entries. You may type the first few letters of the entry to limit the number of entries displayed.
Use the ↓ key or the mouse pointer to highlight the entry you wish to delete.
Press Delete. The entry will be removed.

Repeat the process for each entry that you'd like to delete.
Metal Lion latest SeaMonkey & Thunderbird Themes - Sea Monkey and Silver Sea Monkey
"The only thing necessary for the triumph of evil, is for good men to do nothing." - Edmund Burke (attrib.)

ginahoy
 
Posts: 217
Joined: October 18th, 2007, 8:32 pm

Post Posted May 10th, 2018, 1:54 am

Deleting individual form entries

If you want to remove one of your previous form entries from Firefox's history:

Click on the form field and press the ↓ key to display all the saved entries. You may type the first few letters of the entry to limit the number of entries displayed.
Use the ↓ key or the mouse pointer to highlight the entry you wish to delete.
Press Delete. The entry will be removed.

Repeat the process for each entry that you'd like to delete.

Sounds simple enough but it doesn't work. If I select an entry from the drop-down and press the delete key, that only removes it from the field. It's still in the drop-down and is not removed from the database.

Frank Lion

User avatar
 
Posts: 20039
Joined: April 23rd, 2004, 6:59 pm
Location: ... The Exorcist....United Kingdom

Post Posted May 10th, 2018, 2:03 am

ginahoy wrote:Sounds simple enough but it doesn't work. If I select an entry from the drop-down and press the delete key, that only removes it from the field. It's still in the drop-down and is not removed from the database.

Well, in that case, you'll have to take the far harder router of editing using a SQLite editor, won't you?
Metal Lion latest SeaMonkey & Thunderbird Themes - Sea Monkey and Silver Sea Monkey
"The only thing necessary for the triumph of evil, is for good men to do nothing." - Edmund Burke (attrib.)

ginahoy
 
Posts: 217
Joined: October 18th, 2007, 8:32 pm

Post Posted May 10th, 2018, 2:12 am

...in that case, you'll have to take the far harder router of editing using a SQLite editor, won't you?


Sure, but I'm curious why Mozilla put up a help page with instructions that don't work. I suspect it either worked with previous versions and that feature was eliminated, or it only works for versions more current than what I'm running.

dickvl

User avatar
 
Posts: 52388
Joined: July 18th, 2005, 3:25 am

Post Posted May 10th, 2018, 6:52 pm

You need to install Firefox 52 ESR in order to use SQLite Manager.
Starting SQLite Manager as a XULrunner application allows to use the extension without the need to open a browser window, so you only use Firefox 52 ESR to get XULrunner support.

Note that the user agent shows that you use the Firefox version from the Ubuntu repositories.
Ubuntu has a habit to customize its version, so it might behave differently than the official Firefox version.

Note that you need to use the cursor Down key to highlight (select) an item in the drop-down list and press Delete to remove the highlighted entry.

ginahoy
 
Posts: 217
Joined: October 18th, 2007, 8:32 pm

Post Posted May 10th, 2018, 10:20 pm

dickvl wrote:Note that the user agent shows that you use the Firefox version from the Ubuntu repositories.

I have two machines. My XP machine is running 52 ESR with SQLite as an add-on. My Linux machine is running FF 55 from the Ubuntu repository. I'm interested in installing 52 ESR on my Linux machine so I can run SQLite stand-alone.

...you only use Firefox 52 ESR to get XULrunner support.

So it's possible to install two different versions of FF on the same machine? I'm intrigued, but that sounds tricky. Both the program and the profile paths would need to be different, no?

Note that you need to use the cursor Down key to highlight (select) an item in the drop-down list and press Delete to remove the highlighted entry.

OK. The above-linked Mozilla page says to use either the down cursor or mouse pointer. I only tried the mouse. I just tried using the cursor to highlight and it works! True, that's a lot easier than editing the database since I can do it immediately in like 2 seconds when I see an entry that doesn't belong. Thanks! I'm still curious about installing two versions of FF on same machine if you don't mind explaining that.

Return to Firefox Support


Who is online

Users browsing this forum: Google [Bot] and 9 guests