Are you really sure that your blog entries are still true: You are not able to import csv files?

benutzer

I have a 1password family account and need to import an account from roboform. Your Helpdesk still says the same as a few years ago: I need an old version of Roboform and an old windows version of 1password. I tried that when this hint was new, but I did not succeed at that time. - Are you really sure that you are not able to import a csv file that is exported by roboform into the current version of 1password? I simply can't believe that!

---

1Password Version: Version 6.8.2 (682003)
Extension Version: Not Provided
OS Version: 10.12.6 (16G29)
Sync Type: Not Provided
Referrer: forum-search:roboform

MrC

@benutzer ,

Roboform has traditionally not exported CSV files, but rather provides a Print List into a web browser page. This is HTML code. I have not checked in a while, but does Roboform now export CSV?

In either case, you can use the roboform converter in the converter suite to convert and import your Roboform data (Logins, Safe Notes, and Identities). Use the 1.10 version in Testing Bits, mentioned in the first post of the thread.

benutzer

Yes, Roboform exports either HTML or CSV, you can choose. If I use your converter, I get this error message:
Joachims-iMac:~ joachimfischer$ cd '/Users/joachimfischer/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl roboform '/Users/joachimfischer/Downloads/RfExport.csv' -v
-bash: cd: /Users/joachimfischer/Desktop/convert_to_1p4: No such file or directory
Joachims-iMac:~ joachimfischer$

By the way, what "converter options" should be entered?

MrC

@benutzer ,

The roboform converter only supports the Print Page format of Roboform's export, as per the README.pdf.

Which version of Roboform are you using? I'll take a look at its CSV export.

I'll suggest you can probably also use the csv converter in the suite as well for Roboform's CSV export, but since I haven't seen it yet, I'm not sure what fields are extant.

benutzer

I use Roboform Version: 8.4.3 [s-f]. The export is via HTML or CSV, no other format is possible.

When I use the CSV converter the error message remains the same. What does that mean: "No such file or directory"?

MrC

@benutzer ,

It says that you don't have the convert_to_1p4 folder directly on the Desktop. The attempt to change to that folder (aka directory) is failing, since it is not there (perhaps you have it inside some other directory).

Again, with the CSV, don't select the roboform converter - it cannot work against CSV.

I'll take a look at version 8.4.3 tonight.

benutzer

As you see I have both the app and the csv file on the desktop, and I used the csv converter. But I still get the same error message:

Joachims-iMac:~ joachimfischer$ cd '/Users/joachimfischer/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl csv '/Users/joachimfischer/Desktop/RfExport.csv' -v
-bash: cd: /Users/joachimfischer/Desktop/convert_to_1p4: No such file or directory
Joachims-iMac:~ joachimfischer$

MrC

@benutzer ,

Open Terminal.app. Enter the following command:

ls /Users/joachimfischer/Desktop/convert_to_1p4

What are the results?

benutzer

OK, now I managed to arrange everything on the desktop as necessary. I had to remove the folder onepassword-utilities.

Now I get this message:

Joachims-iMac:convert_to_1p4 joachimfischer$ cd '/Users/joachimfischer/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl csv '/Users/joachimfischer/Desktop/RfExport.csv' -v
CSV column names do not match expected names

Joachims-iMac:convert_to_1p4 joachimfischer$

MrC

@benutzer ,

OK, progress!!!

See the CSV section in the README.pdf, regarding the column header row requirement.

If you are using the 1.10 version of the converter, from Testing Bits, mentioned in the first post of the converter suite thread, you'll see in Step 2 how to setup the CSV export (the section Exporting from your Password Manager has a specific CSV sub-section that tells you the labels to provide in row 1 for your columns for Login items).

benutzer

Success! It was necessary to adjust the labels of the columns, then it worked fine. Thank you for your help.

An advice at the end: You should withdraw all old notes within the help section dealing with Roboform. It only needs this new instruction, because probably nobody uses Roboform 6.9 oder 1Password 4 any longer.

benutzer

Next problem: Now I try to do the same thing on a windows computer. I get this result:

C:\WINDOWS\system32>perl %USERPROFILE%\Desktop\convert_to_1p4\convert_to_1p4.pl csv -v %USERPROFILE%\Desktop\RFExport.csv
Invalid converter specified
Usage: convert_to_1p4.pl

Select a converter:

Select one of the converters above and add it to the command line to see more
complete options. Example:

    perl convert_to_1p4.pl ewallet

As far as I see I specified the converter correctly. Where is the fault?
By the way: The path to the Desktop is not set.

MrC

@benutzer ,

You are not in the correct directory. You are doing this:

perl %USERPROFILE%\Desktop\convert_to_1p4\convert_to_1p4.pl

Change directories as per the README.pdf instructions:

cd %USERPROFILE%\Desktop\convert_to_1p4

and then run the perl command.