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

1…2728303233…52

Comments

  • amfca
    amfca
    Community Member

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

  • amfca
    amfca
    Community Member

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

  • MarkyMarkyMark
    MarkyMarkyMark
    Community Member

    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
    MarkyMarkyMark
    Community Member

    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
    MarkyMarkyMark
    Community Member

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

  • MrC
    MrC
    Volunteer Moderator
    edited February 2017

    @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
    Petsnspace
    Community Member

    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
    MrC
    Volunteer Moderator
    edited February 2017

    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
    cs88rf
    Community Member

    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
    MrC
    Volunteer Moderator
    edited February 2017

    @cs88rf

    MrC blushes... and then blushes again.

  • AGAlumB
    AGAlumB
    1Password Alumni

    ;)

  • PGorham
    PGorham
    Community Member

    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
    MrC
    Volunteer Moderator

    @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
    AGAlumB
    1Password Alumni

    @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
    TomA5555
    Community Member

    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
    MrC
    Volunteer Moderator

    @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
    xnetworkerx
    Community Member

    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
    MrC
    Volunteer Moderator
    edited March 2017

    Hi @xnetworkerx ,

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

  • xnetworkerx
    xnetworkerx
    Community Member

    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
    MrC
    Volunteer Moderator

    @xnetworkerx ,

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

  • xnetworkerx
    xnetworkerx
    Community Member
    edited March 2017

    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
    MrC
    Volunteer Moderator
    edited March 2017

    @xnetworkerx ,

    Exactly how was the file exported from Excel?

  • xnetworkerx
    xnetworkerx
    Community Member

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

  • MrC
    MrC
    Volunteer Moderator

    @xnetworkerx ,

    Can you export it as UTF8, no BOM?

  • xnetworkerx
    xnetworkerx
    Community Member

    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
    MrC
    Volunteer Moderator

    @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
    xnetworkerx
    Community Member

    Version 1.09

  • MrC
    MrC
    Volunteer Moderator
    edited March 2017

    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
    xnetworkerx
    Community Member
    edited March 2017

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

  • MrC
    MrC
    Volunteer Moderator

    @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
This discussion has been closed.