Line feed and/or return characters during import [Solved: mSecure 5]

Durtdawber
Durtdawber
Community Member
edited December 2020 in 1Password 7 for Windows

When I imported my data from another password manager, all of the linefeeds/returns came in as "\n". I there a way to mass update these so that they work as line returns?


1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Sync Type: Not Provided

Comments

  • MrC
    MrC
    Volunteer Moderator

    @Durtdawber ,

    Which password manager was this, and what was your export format?

  • Durtdawber
    Durtdawber
    Community Member

    mSecure 5. CSV. I just downloaded your utility and was trying to use it. I was able to successfully run the mSecure 5 convert but a couple of things happened.
    1. Everything came in as a Secure Note.
    2. the \n line feeds were still in the notes.

    Thanks,

    Donnie

  • MrC
    MrC
    Volunteer Moderator

    @Durtdawber ,

    Please run the converter using the `--dumpcats1`` command line option so we can see which categories the converter is detecting. You can report the output here. It will look like:

    perl convert.pl msecure5 _TestFiles/msecure/msecure5_mac.csv --dumpcats
                   Categories     Known?   Field Count(s)
                 Bank Account      yes         11
                 Calling Card      yes         6
                  Combination      yes         5
                  Credit Card      yes         12
                Email Account      yes         12
               Frequent Flyer      yes         9
               Insurance Info      yes         9
                        Login      yes         9
                   Membership      yes         8
                  Secure Note      yes         4
    
  • Durtdawber
    Durtdawber
    Community Member

    Here is the output.

              Categories     Known?   Field Count(s)
              Login               yes         11
              Secure Note   yes         4
    
  • MrC
    MrC
    Volunteer Moderator

    @Durtdawber ,

    Ok, I see from the README that I have not tested this converter on Windows, so may not be handling newlines correctly. I'm checking now...

  • MrC
    MrC
    Volunteer Moderator
    edited December 2020

    @Durtdawber ,

    Sorry for the delay - I had some issues updating Windows on my virtual machine where I do testing.

    Ooof, looks like mSecure now requires purchasing the product to do an export of data. I'm not going to pay $30 US to test this (I recall now this is the reason I never tested this on Windows).

    But let see if we can make progress. I'll need you to help me understand where the issues are as best you can.

    Looks like you have 11 Login items and only 4 Secure Note items. Does that seem correct?

    Is it the Notes area in 1Password that has the \n issue? Is that the only location?

  • Durtdawber
    Durtdawber
    Community Member
    edited December 2020

    No that is not correct. I have 254 items in my mSecure 5 file. 157 logins and 97 secure notes. I noticed that the number was real low when you had me runt he --dumpcats command.

    Yes, it in the Secure Notes where the \n is not converting (but I found a few in some login entries also).

    If you can't or don't have time to work on this, that's ok. I can spend Christmas break editing the secure notes to get them straightened out. I already took care of the few problems I found in the logins. Also, some images I had in secure notes did not come over so I have to re-import them in 1Password as secure documents.

    It's your call.

    Thanks,

    Donnie

  • MrC
    MrC
    Volunteer Moderator
    edited December 2020

    @Durtdawber ,

    Would you be able to create me 2 Login items and 2 Secure Note items. In one or two of the items, add some multi-line notes to the notes area, and include some Unicode characters on a separate line, such as:

    Line 1
    Line 2
    øπéå∫ß
    Line 4

    If you could export those entries only, and send me that export file, I can resolve the issues. It is important that you not edit the file since that may change some characteristics about it.

    My email is at the top of the convert.pl script.

  • Durtdawber
    Durtdawber
    Community Member

    Test file is on it's way.

    Thanks,

    Donnie

  • ag_ana
    ag_ana
    1Password Alumni

    Thank you as always to MrC for all the support :)

  • MrC
    MrC
    Volunteer Moderator
    edited December 2020

    We've worked out the issues offline, and I've updated the converter to handle mSecure 5's Windows exports (which are quite different from the macOS export).

  • Blake
    edited December 2020

    @MrC swoops in to save the day 💙

This discussion has been closed.