MrC's Convert to 1Password Utility (mrc-converter-suite)

Success - thanks so much!!

Hi @MrC ,

Awesome & Fantastic tool! Thank you !! I have 600 logins created in 1password successfully with macOS 10.12.6 from iCloud Keychain.

Somehow, every login has a note like "created: 2018-01-22 06:03:12 modified: 2018-01-22 06:03:12", but i didn't add any converter options before.

Cloud you please help with this problem （or how to remove these notes quickly）? Thank you again for helping.

Hi @MrC ,

Yes, that would be great with your help! Could you please generate the modified converter for me ? Thank you so much!

Hi @MrC , That worked perfectly! Thanks a lot .

MrC - I was able to use your converter to transfer the contents of my wife's PasswordWallet to 1Password. Worked like a champ. Thanks.

I want to thank you for all of your hard work here. Amazing effort.

Here's my issue: I want to export my Chrome passwords and import them into 1P. I've followed the Chrome flags export process, but unfortunately I'm not prompted to enter my macOS credentials, so I get an empty file (just column names).

I then followed the sqlite export process described here: https://www.axllent.org/docs/view/export-chrome-passwords/

It created the csv file, but again, I wasn't prompted for my credentials, so the password fields are all encrypted.

On a whim I examined and then ran this python script: https://github.com/manwhoami/OSXChromeDecrypt. I reformatted the data so it was tab-delimited, then converted to CSV.

It exported all of the passwords, but it's missing a lot of fields that your script expects (it seems). I started down the path of modifying the script — which I can do if necessary — but I've already burned 3 hours on the process so far, so I figured I'd first ask you about the lack of credential prompts.

If you don't have a quick solution for that, alternatively will you please point me to the format (columns) your script is expecting so I can export the right fields in the right order with the right column names?

It only exports the origin url, username, and password.

However, I'm pretty sure I can get to all of these (Chrome's database field names), just need to add them to the script:

origin_url
action_url
username_element
username_value
password_element
password_value
submit_element
signon_realm
preferred
date_created
blacklisted_by_user
scheme
password_type
times_used
form_data
date_synced
display_name
icon_url
federation_url
skip_zero_click
generation_upload_status
possible_username_pairs

Looking at Converters/Csv.pm, it looks like it wants these columns for logins:

[ 'title',      0, qr/^title$/i, ],
[ 'url',        1, qr/^login url$/i, ],
[ 'username',       1, qr/^login username$/i, ],
[ 'password',       1, qr/^login password$/i, ],
[ 'notes',      0, qr/^notes$/i, ],
[ 'tags',       0, qr/^tags$/i, ],

Are they the ones? if so, should I use the "textname" or the "fields" name?

Oh, and FWIW, if other folks are having problems getting stuff out of Chrome, that script does work great.

https://github.com/manwhoami/OSXChromeDecrypt

To change the "pretty" output format used by the script to a plain csv that your script should be able to convert to a 1P_import.1pif file, change this chunk of the script:

            print("{}Passwords for Chrome "
                  "Profile{} -> [{}{}{}]".format(blue, end, violet,
                                                 profile.split("/")[-2], end))

            for i, entry in enumerate(db_data):
                entry["pass"] = chrome_decrypt(entry["pass"], safe_storage_key)

                print("  {}[{}]{} {}{}{}".format(green, i + 1, end, bold,
                                                 utfout(entry["url"]), end))
                print("\t{}User{}: {}".format(green, end, utfout(
                    entry["user"])))
                print("\t{}Pass{}: {}".format(green, end, utfout(
                    entry["pass"])))

into:

            print("Title,Login Username,Login Password,Login URL,Notes")

            for i, entry in enumerate(db_data):
                entry["pass"] = chrome_decrypt(entry["pass"], safe_storage_key)

                print("\"\",\"\","  "," + utfout(entry["user"]) + "," + utfout(entry["pass"]) + utfout(entry["url"]) + ",\"\"")

(Note that this change will only modify the way passwords/logins are exported... if you have other things stored in your browser like credit cards and such, they'll still format the "pretty" way.)

I'm absolutely not endorsing this script... I only know enough Python to google the syntax needed to make this change, and there are likely problems with it, especially if your username or password include a double-quote character ("). But hey, if nothing else is working, this seems to do the trick.

(Edited to fix the replacement code.)

That would be brilliant!

Yeah! That worked!

It would be awesome if the 1Password importer gave me an error indicating that I need to remove the header from the file!

Taj

That's fair - I was sort of thinking the same thing!