1Password CSV importer breaks if first column of CSV is sometimes empty
When I export my passwords from Bitwarden in CSV format, the first column is folder
, which may have an empty value. When this is the case, the CSV importer on my.1password.com considers the first non-empty field to be the folder, thus causing everything to become horribly misaligned.
Here's a sample CSV file:
folder,favorite,type,name,notes,fields,login_uri,login_username,login_password,login_totp ,,login,1fichier,,API Key: XXXX,https://1fichier.com/,email,XXXX, ,,login,Adobe,,,https://www.adobe.com/,email,XXXX, ,,login,AliExpress,,,https://aliexpress.com/,email,XXXX, ,1,login,Amazon,,,https://www.amazon.com/,email,XXXX,otpauth://totp/Amazon:email?secret=XXXX&issuer=Amazon&algorithm=SHA1&digits=6 ,,login,appdb,,,https://forum.appdb.to/,username,XXXX, ,1,login,Apple,"Backup code: XXXX",App-specific password (Cydia Impactor): XXXX,https://appleid.apple.com/,email,XXXX," " ,,login,Atlassian,"Backup code: XXXX",,https://id.atlassian.com/,email,XXXX,otpauth://totp/Atlassian:email?secret=XXXX&issuer=Atlassian ,,login,Barion,,,https://www.barion.com/,email,XXXX,
Running sed -i 's/^,/"x",/g' bitwarden_export_sample.csv
allows the 1Password web importer to work correctly.
Before:
After:
1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Sync Type: Not Provided
Comments
-
Hi @nyuszika7h!
Thank you for reporting this! I was able to reproduce this issue on my machine, so I will open an internal issue so that the developers can look at this :)
I have also edited the CSV data since it included your personal information, since this is a public forum :+1:
ref: dev/b5/b5#12615
0 -
I wanted to send you a quick update to let you know that our developers have recently looked at this and tested a fix, which has been released already:
The CSV importer now preserves the integrity of columns while handling csv files. {12475}
Thank you again for reporting this :+1:
0