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

amfca

Command line did the trick. Thanks so much MrC !
Alan

amfca

Command line worked. Thanks again for the help MrC !
Alan

MarkyMarkyMark

MrC, thank you for your scripts.

I am attempting to export passwords from macOS Sierra 10.12.3. local keychain export looks ok but it seems to not be allowing me to copy items (either individually or en masse) from iCloud keychain. I get a "The contents of this item cannot be retrieved." error.

Is it something to do with access control on the iCloud keychain?

Apologies if this has already been addressed, I hunted through some of the 30 pages of this thread before posting!

Thanks mw

MarkyMarkyMark

oh hey scrap that, I found something on page 11 - it seems that disabling (unticking) the keychain feature in iCloud and keeping a local copy before copying and running the script against solves the problem. I still got some errors as it ran ~400 iterations but these were mostly duplicates...
I'll crack on and see how I go. Fingers crossed. And thanks again!

MarkyMarkyMark

Awesome ~500 logins created in 1password! Fantastic resource. Now to work out if I like it enough to ditch the apple native approach :)

MrC

@MarkyMarkyMark ,

You're welcome, and Great Sleuthing! I'm glad you got it figured out.

Use both Keychain and 1Password - they both have their purposes.

Enjoy 1Password!

Petsnspace

MrC,

I am having a similar converting from datavault as @amfca had with roboform. I am unfamiliar with the perl language. Can you tell me the command line I would need to enter to convert from datavault to 1password. the export file name I saved was pm_export.csv. Thank you for the help.

MrC

Hi @Petsnspace ,

Sure, no problem:

perl convert_to_1p4.pl  datavault -v ../pm_export.csv

assuming the file pm_export.csv and the folder convert_to_1p4 is on your Desktop.

Please be sure you are using the 1.10 version of the converter in Testing Bits, mentioned in the converter suite.

Bring 'em back alive.

cs88rf

To all Roboform users trying to convert their passcards into 1password file -

MrC has been extremely active and helpful in improving his converter in the past week. Among my 750 passcards, the conversion rate vastly improved in this process, and I'm happy to report that less than 10 items failed to convert in the latest build of converter version 1.10! This is highly remarkable. Roboform's passcards and exports are known for incompatibility. I've tested these RF exports with Dashlane and LastPass, none of them converts (imports) as well as this latest build from MrC.

Looks like customization and dev-user communication triumphs all else in this case!

If you have a large database of passcards from Roboform, please share your experience with MrC. This will helps greatly improve the converter's ability. I believe my 750 passcards, at least 95% of which can be converter successfully now, just helped grow the power of this converter. Imagine just 5 more RF users with similar amount of data :blush:

@1Password Team - award MrC in some way for this great tool. This converter beats all your competitor's product now =D

MrC

@cs88rf

MrC blushes... and then blushes again.

AGAlumB

;)

PGorham

MrC

Thanks for all your work with conversions. Keychain clearly is not easy - that sort of attests to Apple's security concerns (too bad Keychain is not as easy to work with as 1Password), but following your instructions with your tools got it done with no issues. I could kick myself for being so late to the game, but at least I am here now.

MrC

@PGorham ,

You're very welcome. You are right, Keychain exporting is not for the faint of heart.

But the good news is, you now have your Keychain data imported, so you can use 1Password to its fullest.

Enjoy 1Password!

AGAlumB

@PGorham: I'm glad to hear that you were able to get your data safely migrated out of Keychain — that's pretty much the hardest part! Be sure to let us know if you have any questions at all as you're getting started with 1Password. Better late than never! :chuffed:

TomA5555

Hi
I am converting from Apple Keychain. I did manage to export the keychain

After that, I followed the instruction in the download exactly but I received the error:

Users/Tom/Desktop/pm_export.txt' -v
Can't open perl script "convert_to_1p4.pl": No such file or directory
Computer-2:d Tom$

I saw some people talking about Perl here, but the explanations assume that I know more than I do.

MrC

@TomA5555 ,

The issue has to do with Sierra and its changes to how unsigned AppleScripts run. Please use the 1.10 version in Testing Bits mentioned in the first post of the converter suite thread. If the AppleScript still doesn't work for you, just use the command line as described in the README. It will look essentially like:

cd ~/Desktop/convert_to_1p4 perl convert_to_1p4.pl keychain -v ../pm_export.txt

with the end file name depending upon what you named your Keychain export.

xnetworkerx

I have the following problem when running the script on Mac OS Sierra:

cd '/Users/Tom/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl csv '/Users/Tom/Desktop/neu2.csv' -v
-bash: cd: /Users/Tom/Desktop/convert_to_1p4: No such file or directory

MrC

Hi @xnetworkerx ,

Is the convert_to_1p4 folder itself directly on your Desktop (not inside another folder - but itself, on the Desktop)?

xnetworkerx

OK, thank you. I had the folder in another folder. Now, but, I get the next error:

cd '/Users/Tom/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl csv '/Users/Tom/Desktop/neu2.csv' -v
utf8 "\x81" does not map to Unicode at Text/CSV_PP.pm line 691 (#1)
(F) When reading in different encodings, Perl tries to map everything
into Unicode characters. The bytes you read in are not legal in
this encoding. For example

    utf8 "\xE4" does not map to Unicode

if you try to read in the a-diaereses Latin-1 as UTF-8.

utf8 "\x9A" does not map to Unicode at Text/CSV_PP.pm line 691 (#1)
utf8 "\x94" does not map to Unicode at Text/CSV_PP.pm line 691 (#1)
CSV column names do not match expected names

MrC

@xnetworkerx ,

Where did this file come from? It seems not to be a CSV file.

xnetworkerx

But it is a csv file that was edited in Excel.

I have exported from Firefox into a csv and then post-processed in excel

MrC

@xnetworkerx ,

Exactly how was the file exported from Excel?

xnetworkerx

Excel- File
save under
Format MS-DOS- (.csv)

MrC

@xnetworkerx ,

Can you export it as UTF8, no BOM?

xnetworkerx

Next Error
cd '/Users/Tom/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl csv '/Users/Tom/Desktop/neu-utf8.csv' -v
CSV column names do not match expected names

I described then set the column names. title, URL, username, password

At the beginning, there is always the following characters, which I do not get. 

MrC

@xnetworkerx

You are making progress! Which version of the converter suite are you using? You can look at the Changes.txt file to see the latest version entries.

Can you expand more on what you mean by "At the beginning..."?

xnetworkerx

Version 1.09

MrC

Ok, please update to 1.10, and we'll go from there @xnetworkerx . It is located in Testing Bits, mentioned in the converter suite thread, first post. Please note you will have to change your column header names. The following are the new titles (change made to accomodate additional record categories):

Title, Login Username, Login Password, Login URL, Notes

Also, please let me know what you mean by "At the beginning...".

xnetworkerx

I started version 1.10 and adjusted the column names.
Nevertheless, this error appears again:
CSV column names do not match expected names

MrC

@xnetworkerx,

Please show me the first row of your CSV - just the header names.

The header names work fine. Example CSV:

$ cat ~/Desktop/csv-example.csv
Title,"Login Username","Login Password","Login URL",Notes
"My Login","Joe Blow","Super Secret","http://www.example.com","These are my
Notes"

Example conversion run:

$ perl convert_to_1p4.pl  csv -v ~/Desktop/csv-example.csv
Imported 1 item
Exported 1 login item
Exported 1 total item
You may now import the file /Users/cappella/Desktop/1P_import.1pif into 1Password