Dashlane to 1Password import issue

camilleroux

Hi,

I want to quit Dashlane and use 1password, but I can't import the Dashlane export (either on Mac OS app and online).
Online, 0 passwords out of 421 are imported. It can save fex notes if I let them in the file. Here is the message I get:

Error: No importable items were found in the selected file.

Session: RW5J635BP5AZHGVDNMZ4PRM6NU

Time: 2019-02-03 18:49:50 +01:00

On the mac app, I get the following message:

Lancer l’importation
Collecte des éléments à importer
Impossible de lire les éléments du fichier. Vérifier le format d'importation.
Terminé

(The weird characters are not a copy-paste bug)

I tried to contact 1password some days ago by email and I still get no answer :(

Someone can help me?

---

1Password Version: Mac 7.2.4
Extension Version: Not Provided
OS Version: OS X 10.14.2 (18C54)
Sync Type: Not Provided

MrC

Hi @camilleroux ,

See my reply here. This should help you move forward.

FYI: the "wierd characters" in the error message above is called Mojibake. 1Password for Mac is not properly handling the encoding of the error message strings.

camilleroux

Ok, that's fine!
I should modify the format with Numbers, export it, change ';' by ',', then remove quotes, then fix passwords I broke, then import it on web app (because import doesn't work on the mac app and the error message was not precise)
@MrC Could you reset my trial, to finally try 1password with passwords imported? Thanks

MrC

@camilleroux ,

I would re-export from Dashlane.

Open the export with Numbers, and ensure your Dashlane items have not split across rows. If any has, join the rows correctly, placing data in the correct columns.

Then, use the csv converter in the converter suite . Just follow the directions. You'll be able to import via the Mac app.

Numbers can export as a standard CSV file. Do that, adding labels, as per the directions for the CSV converter.

I don't work for Agilebits so have no ability to restore trials.

camilleroux

ok! Why shoud I restart? Is it better to import via the Mac app?

MrC

@camilleroux ,

I sounds like you made a lot of changes to your CSV, to manually try to get things to work. You don't have to restart, but just be sure you have proper CSV formatting.

The 1PIF that will be generated by the csv converter will import into 1Password on the Mac (or Windows) reliably. 1PIF is a more robust format than CSV.

MrC

@camilleroux ,

Your posting here prompted me to review yet again the Dashlane exports with the latest versions. I updated the post I linked above with a small edit:

Edit 2019-02-03: I've looked at the Dashlane exports yet again. The XLS export is useless. The CSV export is still broken. And the JSON export is a butchered, incomplete mess.

CSV is the best route to go, since it is the least broken, and is the most useful export Dashlane offers. It is clear that exports are very lower priority for them.

camilleroux

Ok, I did that.

FYI here the formulas I used in Numbers: (sorry, the formula are in French ;( )

-A> Dashlane Export::A1
-B> Dashlane Export::B1
-C> SI(ESTVIDE(Dashlane Export::C1);Dashlane Export::D1;Dashlane Export::C1)
-D> Dashlane Export::F1
-E> SI(ESTVIDE(Dashlane Export::C1);"";Dashlane Export::D1)

MrC

@camilleroux ,

I’m sorry, I don’t understand. There should be no formulas. The export would be simple text values. Do you need an example?

camilleroux

You're right. It was to have them in the good order for the web import. Nevermind.

Lars

:) :+1: