Importing from Dashlane, missing logins

NaxterraNaxterra
edited May 11 in Windows

Hello

I am on Trial version and I am trying to import my Dashlane logins into 1Password. I have more than 500 pages and around 30 secure notes saved in Dashlane. I exported them as CSV and then imported to 1Password. I got total of 14 entries in 1Password.

How can I get all of my logins and notes?

I used https://my.1password.eu/home and then Import.

Side note, some of the imported entries are wrong too. Like there is an entry called 'Cell' with password 'Mobile'


1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Windows 10 x64
Sync Type: Dashlane

Comments

  • brentybrenty

    Team Member

    @Naxterra: Thanks for reaching out! Can you tell me the specific steps you took to export the CSV and import it into 1Password? This is generally what we recommend, but naturally it depends heavily on the quality and format of the exported data. Depending on what you have, you may have better luck using @MrC ’s converter to get it into 1Password's native format first, which can be imported directly into the desktop app (rather than the web interface). Let me know.

  • Hello

    My steps are like below,

    1. Log in to Dashlane Windows app.
    2. File > Export > Unsecured CSV
    3. Save as CSV
    4. Go to https://my.1password.eu/home
    5. Click on my name on top right > Import
    6. Select Dashlane and then select my CSV
    7. Import

    MrC's converter didn't work. I executed it as
    C:\Users\username\Desktop\mrc-converter-suite>perl convert.pl -v csv C:\Users\username\OneDrive\DashlaneExport.csv

    result is

    CSV_PP ERROR: 1012 - INI - the header contains an empty field @ rec 1 pos 0

    Failed to parse file: C:\Users\username\OneDrive\DashlaneExport.csv
    See error hint above.

  • MrCMrC Community Moderator

    @Naxterra ,

    The csv converter needs some specific column header names. Hence, the error message above.

    The Dashlane export is likely to contain a few different categories. The csv converter requires a single category in the export file, so you'll need to copy / edit the export file, and remove all but one category type. Let's consider Logins first. Remove all but the login lines, and then add the column labels as explained in the README.html file under the CSV section. It states specifically which column labels you need. You'll see this table:

    Once you have the labels, and only the Login entries, you can run the converter as you did on that edited Dashlane export.

    Let's see if this gets you further along.

  • I am not sure how to do that. When I open it via Excel, there is only one column and lots of rows, more than 1300 rows. I can't edit one by one a csv file.

    Also many of rows have following format
    XDA-Developers,"xda-developers.com","username","email","","password",""

  • MrCMrC Community Moderator
    edited May 12

    @Naxterra ,

    Excel should be fine.

    You may have to Import the file rather than open it. Import as CSV. I no longer have Excel here, so can't verify the steps for you.

    Make sure you export the edited CSV file - by exporting as CSV in the UTF-8 format - don't just Save it.

    You should be able to easily identify your Login types. They will have the same number of columns, and should have a URL, email/login name, password, and a title. What you've identified above seems right, if you want those converted into 1Password logins. Since you have both email + username, columns, you can pick the one that should be used on a login page, and label that as your Login Username column in the spreadsheet. You can label the other one whatever you want.

    I'm hoping that most of your 1300 rows are Logins, and the others you can readily identify to remove from the copied CSV.

    Dashlane exports are quite problematic.

  • Sadly I have around 500ish logins, rest seems other fields. Like below;

    -no-name- = Feedback Summary
    -no-name- = [email protected]
    -no-name- = country
    birth_month css3pie = month
    birth_day css3pie = 1
    recaptcha_response_field = Mahomed rrenFo
    lang = British English

    and many other entries.

    In my logic 1Password should recognize login fields and import them. As for other fields it should skip them, or at least ask for how to do mapping.

  • brentybrenty

    Team Member

    @Naxterra: I'm not sure what 1Password could be expected to do with language fields, as it has nothing like that. I don't know what that would be for. And I definitely don't think it would be desirable for most people if 1Password were to just "skip" them, as there's presumably a reason you have them -- unless that's something specific to the app that I'm not aware of. That's why it's beneficial to convert it into a form usable by 1Password: so you can be sure you're not losing data. Exports can be mangled, and we don't want it to get mangled further by having 1Password "guess" what it is. It requires some effort, but what goes in is what comes out, so it's generally worth it unless you don't care about the data. I just wish it wasn't mangled in the first place, as that would be a lot easier for you. :blush:

  • MrCMrC Community Moderator
    edited May 12

    @Naxtera,

    First, let's dismiss the idea that 1Password can just import these as is. The issue is that Dashlane's exports are bad - really bad. I've described this many times, for example here and here. It is not possible to "detect" what you are calling "login fields" because these are just a sequence of characters. Example: which of those below is a the login and which is the password, and which are notes?

    Jonas
    jonasuser
    [email protected]
    jonaspass
    jonasother
    

    So, you have some manual work to do, and there's no wary around this.

    You mention "rest seems other fields" - are you saying that each of these are in separate rows? This would indicate a Dashlane CSV export formatting issue (I mention this issue in those links). Perhaps rather than try to correct these CSV issues, you could just remove these 1-column entries, and deal with those manually later.

    The goal for you is to get a CSV file that has all / most of your login entries, all arranged in nice columns. If that's not something you're able to do, there's not much anyone else can do to help, since we don't want to see your confidential data.

  • I edited CSV file, removed lots of lines and now it has 428 lines. I imported same CSV file into 1Password. First I selected Dashlane and it failed with Unable to import. Error: No importable items were found in the selected file. Then I selected CSV from Other menu.

    First it imported around 1200 entries, after that it imported 428. Now I have 1671 entries in my account, and all of them are invalid.

    For example
    Title is
    9anime,"9anime.is","","email","","password",""
    website https:// (yes only https:// nothing more) and some of them has website https://undefined

    No username, no password

  • MrCMrC Community Moderator
    edited May 12

    @Naxterra ,

    Your CSV is not formatted the way 1Password requires. The columns must be in exactly this order:

    title,website,username,password,notes,custom field 1,custom field 2, custom field …
    

    One of the reasons I suggested using the csv converter, is that you can get plenty of diagnostics. This can tell you exactly where things go wrong, down to the record. Here's how things should look:

    You can see the record number (row), the fields, and how they are being mapped to 1Password fields.

    And here's what happens where there's an error in the CSV:

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file