1702148 - The columns of a CSV file exported from certain localized password managers are translated but are not recognized when imported in Firefox

Status: NEW

(Firefox :: about:logins, defect, P3)

Description

[Cosmin Muntean [:cmuntean], Ecosystem QA]

Attachment: Logins exported from 1Password FR build.gif

[Affected versions]:

• Firefox Nightly 89.0a1 (Build ID:20210330215136);
• Firefox Beta 88.0b4 (Build ID: 20210328185936)

[Affected Platforms]:

• Windows 10 x64;
• macOS 10.15.7;
• Linux Mint 20 x64;

[Prerequisites]:

• Have the latest Firefox Beta build installed.
• Have a CSV file exported from 1Passsword app: you can use this CSV file exported from 1Passsword app on FR locale.

[Steps to reproduce]:

1. Open the Firefox browser with the profile from prerequisites.
2. Navigate to "about:logins" page.
3. Open the menu, click the "Import from a file..." option.
4. Select and import the CSV file described in prerequisites.
5. Observe the behavior.

[Expected result]:

• The logins are imported.

[Actual result]:

• The "File Format Issue" modal is displayed because the "password" and "username" columns are translated and not recognized by Firefox.

[Notes]:

• I haven't managed to reproduce this issue with KeepassXC or Bitwarden apps on different locales because the columns are not localized in this case.
• Attached a screen recording of the issue.

Comment 1

[Sam Foster [:sfoster] (he/him)]

:flod, do you have any thoughts on a approach here? We need to identify the columns and map them to "URL", "name", "password" etc. But the output from exporting data from some password managers has translated these headers. Its likely but not necessarily true that the language used in the CSV file would match the Firefox language.

Comment 2

[Francesco Lodolo [:flod]]

I'm not fully following here: the CSV file linked above doesn't have translated column names, while the video clearly has.

Is this about the CSV file generated by an external software? If so, we can't really expect to have control on what other password manager do.

This seems either a feature to add (think for example of CSV import in Google Spreadsheet, with ability to map column to specific fields), or something that users need to fix on their own (likely a SUMO article).