Trying to export from Nordpass and the .csv is import is being rejected by 1Pass [Solved]

cuencanerd
cuencanerd
Community Member
edited September 2022 in Mac

Saving a .csv and when I try to import to 1Pas it says invalid file


1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Browser:_ Not Provided
Referrer: forum-search:nordpass

Comments

  • Hi @cuencanerd:

    Are you importing using 1Password for Mac, or my.1Password.com? Let me know.

    Jack

  • cuencanerd
    cuencanerd
    Community Member

    1Password Mac

  • MrC
    MrC
    Volunteer Moderator

    @cuencanerd @Jack.P_1P

    The Nordpass CSV contains row data that will cause 1Password's importers to fail. It contains extra folder name rows, and has Windows end-of-line markers.

    @cuencanerd - I can create a nordpass converter for the converter suite if you'd like to convert / import into 1Password 7 or 8.

  • cuencanerd
    cuencanerd
    Community Member

    Jack,

    I am using 8.8. If a simple converter will do it great. I am reasonably technical. If there's something I can do to reformat the table correctly I am happy to do it. But your help is GREATLY appreciated

  • MrC
    MrC
    Volunteer Moderator
    edited September 2022

    @cuencanerd

    A quick overview, as I'm working on the converter now...

    Only Login, Credit Card, or Secure Note can be imported via CSV.

    Via the web interface, you'll have to set the row type for each item.

    In the app, you have to separate the items by category (they can't be intermixed).

    You'll have to:

    • Remove the type-folder rows.

    • Remove the identity type rows (1Password cannot import these).

    Export the final data as UTF-8 CSV.

    Also note that the Nordpass CSV export is lossy. For Credit Card, it does not export your PIN field, so you'll want to verify your data afterwards.

  • cuencanerd
    cuencanerd
    Community Member

    That's easy. I only care about logins and notes. Will I do 2 separate imports or can it be one with the two types (logins and notes) grouped?

  • MrC
    MrC
    Volunteer Moderator

    @cuencanerd

    Traditionally the categories had to be in separate CSV files.

  • cuencanerd
    cuencanerd
    Community Member

    No problem

  • MrC
    MrC
    Volunteer Moderator
  • cuencanerd
    cuencanerd
    Community Member

    Is there a link to the converter?

  • cuencanerd
    cuencanerd
    Community Member

    Or do I just enter the command lines as shown (with diff file names)?

  • MrC
    MrC
    Volunteer Moderator

    @cuencanerd

    Give me a minute to update the Custom version. It's the version that supports 1PUX, 1PIF and CSV. When the zip is posted, I'll ping back here.

    I only have a free Nordpass account, so am unaware if there are record types other than the 4 I show above.

  • cuencanerd
    cuencanerd
    Community Member

    Jack - I really appreciate all your help. You rock!

  • MrC
    MrC
    Volunteer Moderator

    @cuencanerd

    Ok, I have updated the pre-release version. It is in the Custom folder under link mentioned in the converter suite link. You only need the zip archive in Custom. Follow the basic directions in the README, but use the command line (not the helper app).

    I have not yet updated the README to be 1PUX aware.

    The default output will be 1PUX, so your command will look like:

    perl convert.pl nordpass -v ~/Desktop/nordpass.csv
    

    Let me know it goes!
    MrC

    FYI: you can enable debug with -d (or -dd for extensive debug).

  • cuencanerd
    cuencanerd
    Community Member

    I imported 1 item to test...worked great. Had a looooong day. Want to do this after I have had more sleep. Will try a more comprehensive try tomorrow. Again, many thanks. I'll update you once I work on it over the weekend.

  • MrC
    MrC
    Volunteer Moderator
    edited September 2022

    Sounds good @cuencanerd .

    Have a good weekend.

    [ Edit: just in case it isn't clear, use your raw export from Nordpass w/the converter ]

  • cuencanerd
    cuencanerd
    Community Member

    Just imported my 550 passwords. Looks like it was a perfect import. Can't thank you enough for the effort and help.

  • MrC
    MrC
    Volunteer Moderator

    Excellent. Thanks for reporting back @cuencanerd .

    Enjoy 1Password!

  • cuencanerd
    cuencanerd
    Community Member

    👍

  • I'm glad to see MrC was able to help you get imported @cuencanerd! Feel free to get in touch if there's anything else we can help you with as you get started with 1Password. 😀

    Jack

This discussion has been closed.