Help moving from StickyPassword to 1 Password, please [Solved]

JulesBechthold
JulesBechthold
Community Member
edited November 2022 in Windows

Hi thank you for your help, in advance!
I have downloaded the mrc-converter-suite and Perl, as well as the export of the xml version of StickyPassword. I've gotten stuck in the import part in the cmd box. I've tried ignore timestamps and cannot get any farther. Any help would be appreciated.
Thanks,
Jules


1Password Version: 8.9.8
Extension Version: 2.4.3
OS Version: Windows 10 Home
Browser:_ Chrome

«1

Comments

  • MrC
    MrC
    Volunteer Moderator

    Hello @JulesBechthold

    I'm I correct in understanding that you have succesfully performed the conversion, but are not sure how to import the resulting 1PUX file created by the converter?

    If that is correct, then open 1Password, click the ellipsis icon, and select Import... :

    and either drag your 1PUX onto the dialog's drag area, or click the Add File text button in the Import dialog and navigate to the location where you had the 1PUX file created (as per the README, that would be your Desktop).

    Then, click the Import button:

  • JulesBechthold
    JulesBechthold
    Community Member

    No, MrC.
    I couldn't get the conversion completed.

  • MrC
    MrC
    Volunteer Moderator
    edited November 2022

    Can you provide some more details about where you're having trouble, @JulesBechthold ?

    Also, you might want to see some of the example Videos in the Extra Help folder at the suite's download location. Try the Command line - Windows Enpass.mp4 video - it demonstrates the process.

  • JulesBechthold
    JulesBechthold
    Community Member

    I watched the videos, still got stuck.
    This is the error I received.
    Microsoft Windows [Version 10.0.19044.2251]
    (c) Microsoft Corporation. All rights reserved.

    C:\Users\jules>\Destop|mrc-converter-suite
    '\Destop' is not recognized as an internal or external command,
    operable program or batch file.

    C:\Users\jules>cd %USERPROFILE%\Desktop\mrc-converter-suite

    C:\Users\jules\Desktop\mrc-converter-suite>perl convert.pl -v enpass --ignoretimestamps ..\pm_export.xml
    utf8 "\xFF" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    (S utf8) 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 "\xFE" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xAE" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xBB" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xB7" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xDF" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xAB" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xA0" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xF8" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xA9" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xD8" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    utf8 "\xCF" does not map to Unicode at
    C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Utils.pm line 93 (#1)
    Unexpected failure parsing CSV: row 1 at C:/Users/jules/Desktop/mrc-converter-suite/./Converters/Enpass.pm line 792.
    Import summary:
    0 items discovered
    Export summary:
    0 total items

  • MrC
    MrC
    Volunteer Moderator

    @JulesBechthold

    You want the stickypassword converter, not the enpass converter:

    perl convert.pl -v stickypassword --ignoretimestamps ..\pm_export.xml

  • JulesBechthold
    JulesBechthold
    Community Member

    @MrC I think I found some of my error, but still can't get a converted file.
    C:\Users\jules\Desktop\mrc-converter-suite>perl convert.pl -v stickypassword --ignoretimestamps ..\pm_export.xml
    Use of uninitialized value $value in sprintf at
    C:/Users/jules/Desktop/mrc-converter-suite/./Converters/Stickypassword.pm line 370 (#1)
    (W uninitialized) An undefined value was used as if it were already
    defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
    To suppress this warning assign a defined value to your variables.

    To help you figure out what was undefined, perl will try to tell you
    the name of the variable (if any) that was undefined.  In some cases
    it cannot do this, so it also tells you what operation you used the
    undefined value in.  Note, however, that perl optimizes your program
    and the operation displayed in the warning may not necessarily appear
    literally in your program.  For example, "that $foo" is usually
    optimized into "that " . $foo, and the warning will refer to the
    concatenation (.) operator, even though there is no . in
    your program.
    

    Uncaught exception from user code:
    Error parsing time at C:/Strawberry/perl/lib/Time/Piece.pm line 598.
    Time::Piece::strptime("Time::Piece", 16010101, "%Y%m%d") called at C:/Users/jules/Desktop/mrc-converter-suite/./Converters/Stickypassword.pm line 468
    Converters::Stickypassword::parse_date_string(16010101) called at C:/Users/jules/Desktop/mrc-converter-suite/./Converters/Stickypassword.pm line 483
    Converters::Stickypassword::date2epoch(16010101, "local") called at C:/Users/jules/Desktop/mrc-converter-suite/./Converters/Stickypassword.pm line 125
    Converters::Stickypassword::ANON(16010101, "birthdate") called at C:/Users/jules/Desktop/mrc-converter-suite/./MCS/Core.pm line 151
    MCS::Core::normalize_records(MCS::Core=HASH(0x3c39db8), MCS::Generators::PUX=HASH(0x53f2068), "identity", ARRAY(0x3c3a6f0), HASH(0x3c3a798)) called at C:/Users/jules/Desktop/mrc-converter-suite/./Converters/Stickypassword.pm line 251
    Converters::Stickypassword::import(Converters::Stickypassword=HASH(0x3c42b78), "..\pm_export.xml", undef) called at convert.pl line 200

    C:\Users\jules\Desktop\mrc-converter-suite>

  • JulesBechthold
    JulesBechthold
    Community Member

    @MrC I made that correction, but it still won't convert. Any other ideas?

  • MrC
    MrC
    Volunteer Moderator

    @JulesBechthold

    Ok, that's progress.

    It appears your data file has something that the converter is not expecting.

    Let me download the latest version and check the export.

  • MrC
    MrC
    Volunteer Moderator
    edited November 2022

    @JulesBechthold

    Sorry for the delay.

    I've placed an updated Stickypassword.pm converter module in the Custom folder at the suite's download location. Please replace your Converters\Stickypassword.pm module with the new one, and retry the conversion.

    I made two changes:

    1. Provide a default "Untitled" value if your identity does not have a Person Details > Title. One of your errors above indicates that you have an identity record without this title.

    2. Don't attempt to convert birth date values prior to Dec 31, 1899. The second error above indicates you have a Jan 01, 1601 value, clearly an nonsensical birthday for anybody using a computer. The version of StickyPassword I tested today enforces a minimum date 01-01-1899 date value, so I'm unsure how you got that 1601 year.

  • JulesBechthold
    JulesBechthold
    Community Member

    Thank you @MrC. I also apologize for the delay. I was traveling all day yesterday and could not respond.
    I have successfully created the .1pux file (with your help - THANK YOU), but now the system is not allowing me to import it because it is not in .csv format. This is the message I receive:
    We weren’t able to use that file. Try again with a CSV file or contact support.

    Error: Invalid file format.

    Session: 47RXBQR2ORFFVODYANAIVLK3IE

    Time: 2022-11-28T14:48:33.382Z

  • MrC
    MrC
    Volunteer Moderator

    @JulesBechthold

    You need to use a Desktop version of 1Password to import the 1PUX file.

  • JulesBechthold
    JulesBechthold
    Community Member

    @MrC I am on my desktop.

  • MrC
    MrC
    Volunteer Moderator

    Great, @JulesBechthold

    Then we seem to be back to the earlier post:

  • MrC
    MrC
    Volunteer Moderator
    edited November 2022

    I just ran a test conversion and import:

  • JulesBechthold
    JulesBechthold
    Community Member

    @MrC it doesn't say that anymore. I did go back to the top and review what you sent me. It doesn't give any other option but .csv now...

  • MrC
    MrC
    Volunteer Moderator

    Try quiting the Desktop app, and 1Password Completely. Then relaunch it and check again.

  • JulesBechthold
    JulesBechthold
    Community Member

    I logged out, restarted my computer and still it only gives me the option of importing a .csv file.

  • MrC
    MrC
    Volunteer Moderator

    Can you share a screenshot of that import dialog / page? @JulesBechthold

  • JulesBechthold
    JulesBechthold
    Community Member

  • MrC
    MrC
    Volunteer Moderator
    edited November 2022

    @JulesBechthold

    That is the Web interface. Use the 1Password 8 desktop application for Windows.

  • JulesBechthold
    JulesBechthold
    Community Member

    Okay, now I get

  • MrC
    MrC
    Volunteer Moderator

    @JulesBechthold

    This has been a rocky road for you, sorry about the unpleasant journey.

    That error is indicating that 1Password doesn't like something in the 1PUX file as created by the converter. 1Password 8's requirements for a 1PUX are quite stringent, but unfortunately there are no useful diagnostics to indicate where the issue is. So, we'll have to attempt to locate the issue by trial and error.

    The converter supports selecting a list of import and export types. That is, the types of items you want considered from the original password manager's export (these are the "import types"), and the types of items you want placed into the 1PUX export (these are the export types).

    The stickypassword converter supports the following import and export types (these are seen using the --help option):

    Supported import types:
        appaccount bankacct bookmark creditcard identity note securememo webaccount
    Supported export types:
        bankacct creditcard identity login note
    

    If you are receptive to testing out where the failure is and is not occurring, we could narrow the records such that the export only contains a subset of the original items. If the import then succeeds, we know the failure is in the records that were skipped.

    Try starting with login export types, since those are likely the bulk of your records:

    perl convert.pl -v stickypassword --exp login ..\pm_export.xml
    

    Then, try to import the resulting 1PUX file. If that works, then we know that some record in one of the other categories is causing the issue, and we can move to those.

  • JulesBechthold
    JulesBechthold
    Community Member

    Ok, thanks @MrC . I have to leave for an appointment. I'll try that in the morning.

  • JulesBechthold
    JulesBechthold
    Community Member

    @MrC That worked! You ARE the BEST!! Thank you so much! I got 4945 passwords out of 5071 records. That's good enough for me! I can always click a forgot password link in the future if I need to. Thanks again! You're awesome!

  • MrC
    MrC
    Volunteer Moderator
    edited February 2023

    @JulesBechthold

    That's great progress!

    I would like to resolve where stickypassword is creating some data that the 1PUX generator is having trouble with. If you are still receptive, could you try bankaccount, creditcard, and note export types, one at a time?

    This would isolate the area where I need to hunt to find what might be going wrong (there are a couple of possibilities that come to mind, but I'd prefer not to guess and hope for the best).

    The good news is, that for each of those export types you try above, you'll be able to just move the items from the newly created vault into your main vault and know that you have more items transferred.

    The identity category is more complex, since it splits items into the other categories. I'd like to focus on this one last.

    If you have no more interest in spending time on this, I understand.

  • JulesBechthold
    JulesBechthold
    Community Member

    Okay, so I got zero records with bankacct, but I didn't expect any. I got one record with credit card and 112 with note. That leaves 13 records unaccounted for by my reckoning.

  • MrC
    MrC
    Volunteer Moderator

    Ah, that's fantastic, @JulesBechthold .

    So this leaves identity. Do you have that many Identities?

  • JulesBechthold
    JulesBechthold
    Community Member

    Probably

  • JulesBechthold
    JulesBechthold
    Community Member

    But I don't really need them anymore.

  • MrC
    MrC
    Volunteer Moderator

    That's fine @JulesBechthold , don't worry about it.

    I have found at least one place that creates a problem. I'll test other scenarios here. Thanks for you patience and feedback.

    Enjoy 1Password!

This discussion has been closed.