password-exporter icon indicating copy to clipboard operation
password-exporter copied to clipboard

Empty usernamefield error on import

Open r0land opened this issue 12 years ago • 10 comments

Hello

I have exported my passwords to a CSV file. Then I have tryed to import this file (without any changings) to another Firefox profile. I got several errors there.. the tool cannot import 14 of 155 passwords because of empty usernamefield.

The problem is the following:

Many saved passwords don't need a usernamefield because the webpage comes with just a password field (for example: my netgear router & emule). In other cases (for example: FireFTP) there is no need for usernamefield (and other fields).

FireFTP is a Firefox extension. It is a powerfull FTP client which works as a Firefox tab. It saves just hostname, username, password and "FireFTP" as formsubmiturl.

All these saved passwords are working very well while using Firefox all the time. And they are working if I copy the Firefox password files (key3.db & signons.sqlite) from one profile to another.

Normally it would be enough to copy the files.. but I have to different profiles on two different computers.. and I have to merge the files. This would work for me.. if there wouldn't be the errors..

Could you fix this maybe? Or do you have any ideas for a workaround?

Greetings

PS: Great extension. Helped me a lot switching from Opera to Firefox some years ago!

r0land avatar Jun 11 '13 17:06 r0land

Now I have tryed to change the "" (empty) to "notused" (or what ever else) at the related usernamefield. This produced on import the same amount of errors at the same passwords.. but now with the empty passwordfields. After changing these values from "" to "whatever" too.. the passwords could be imported.

Router page and some others are working again.

r0land avatar Jun 11 '13 17:06 r0land

FireFTP is not working this way.

If I import the FireFTP passwords then I can see them later in the list of saved passwords. But if I try to connect to the servers using FireFTP.. I have to re-enter the passwords there. Then I can connect.

And now I have checked, that all passwords are imported to Firefox but not to the FireFTP preferences itself. Looks that FireFTP has an own password-file somewhere.

Confusing me a little..

r0land avatar Jun 11 '13 18:06 r0land

Deleting the FireFTP passwords from Firefox password list.. will delete the passwords out of the FireFTP preferences too.

I think FireFTP checks that there is a "NotUsed" or "WhatEver" value at the usernamefields and passwordfields.

Sorry for spamming that much.. but I am somehow frustrated for these errors!

r0land avatar Jun 11 '13 18:06 r0land

Oh.. now I found one the problems maybe:

The hostname for ftp-servers is stored (of course) as something like "ftp.domain.de" or "ftp.127.0.0.1".. but on import.. the importer adds "http://" to the address.

So after import the hostname is stored as "http://ftp.domain.de" instead of "ftp.domain.de".

This is really stupid!

Could you change that please??

r0land avatar Jun 11 '13 18:06 r0land

Ok, that's it (in case of FireFTP): I have deleted all the passwords and then I have imported just the FireFTP passwords again. They all begins with "http://" now (what is really stupid) instead of "ftp.somewhat.." as it is saved in the CSV file.

After import I deleted the http-part of one hostname in Firefox. FireFTP found the password and could connect. Great!

r0land avatar Jun 11 '13 18:06 r0land

If I change all the ftp hostnames in the CSV file from "ftp.domain.." to "ftp://ftp.domain.." or to "ftp://domain.." then the importer will not add "http://".. but FireFTP cannot find the passwords then.

And if I add "ftp://" to the hostnames within FireFTP.. then they will be stored in Firefox as "ftp.ftp://..".

This is a doom loop!

Best way for me is now to import the hostnames as they are exported.. and delete manually in Firefox the added "http://".

r0land avatar Jun 11 '13 18:06 r0land

My conclusion is: The importer should get fixed!

Please import passwords with empty usernameField. Please import passwords with empty passwordField. Please don't add "http://" to "ftp.domain.." hostnames.

More problems by editing a password file with LibreOffice-/OpenOffice-Calc and saving it to a CSV file:

  1. The importer awaits EVERY value noticed as "value" separeted by , (comma). Saving a CSV file in LibreOffice (and OpenOffice) will give you the possibility to use " but ONLY at text-fields! If you have numeric fields, Calc will not use "" at the values! Take care to format ALL fields to TEXT (@). Otherwise the importer will stuck for ever without the chance to stop the import!

  2. If you have an EMPTY CELL.. take care to write some text there. If you have several empty cells (and you will have them!).. then write in all the cells the same text. Something like EmptyCell or what ever else. After saving the CSV file.. open it with a text editor and REPLACE "EmptyCell" with "". The reason is that Calc cannot write "" for empty cells.. it will write nothing! The importer cannot handle that and would stuck for ever!

  3. If the CSV file is saved you have to change the first line in it to "# Generated by Password Exporter; Export format 1.1; Encrypted: false" because Calc will add "" and commas here too!

r0land avatar Jun 11 '13 18:06 r0land

Same here. Just a simple case: 1 password. Gets exported with the "formSubmitURL", "usernameField" and "passwordField" empty (that is, just two double quotes). When importing this exported file it will not import it's own export file with the result "<URL> ('[JavaScript Error: "l.usernameField is null" {file: "resource://gre/components/storage-mozStorage.js" line: 938}]' when calling method: [nsILoginManagerStorage::addLogin])" Did you actually try to export the passwords, delete them and then import them again? This error should have been obvious.

rschalie avatar Dec 31 '13 09:12 rschalie

I encountered the same issue, when trying to import user names and passwords from Norton Identity Safe. Please allow quoted null values for usernameField and passwordField.

Drakis avatar Dec 15 '15 12:12 Drakis

I have the same problems as listed above, but from the post dates and lack of replies it seems that this add-on is no longer supported.

ineuw avatar Jul 03 '16 20:07 ineuw