MrC's Convert to 1Password Utility (mrc-converter-suite)

Estrojen1193

@MrC The export was done on OSX, 10.12.4. mSecure 3.5.6. What I will do is do the "cross reference" for the categories from mSecure to 1Password. I only have a few that I added truly custom fields, so most are basic with name of site/app, login/password/secret questions. Give me a few days, but I'll get it. Thank you so much for your help!

MrC

@Estrojen1193 ,

That sounds basically correct. But be sure to cross reference the data that is present in the CSV export file.

For the login/password being incorrectly split, what I'll need to see is a single sample line of your CSV file, where the problem exists. Change the username and password for security. But please pick a problematic entry where the username and password contain no Spaces, Commas, or Double Quotes. You can post the line here, or send it to me via email (my email address is at the top of the convert_to_1p4.pl script which you can open with a text editor).

Take your time, it's your project so get to it when it suits you.

ErnieS

I am using MacOS Sierra 10.12.3 and currently running Roboform 2.6.1 on both a Mac and Windows. I am trying to move my passwords from Roboform to 1Password using the transfer software. I exported the Roboform data on the Windows machine using the "Print" function in Roboform and I get an HTML file. I moved that HTML file to my Mac and used the drop-and-drag method after installing convert_to_1p4 software. I finally got Perl to run a conversion after getting the converter moved to the desktop but I got a bunch of conversion errors and no output file (where does it put this file, anyway??). Here are the errors from the command window:

ernie$ cd '/Users/ernie/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl roboform '/Users/ernie/Desktop/goodstuff.htm' -v
utf8 "\xFF" does not map to Unicode at Utils/Utils.pm line 78 (#1)
(F) When reading in different encodings, Perl tries to map everything
into Unicode characters. The bytes you read in are not legal in
this encoding. For example

    utf8 "\xE4" does not map to Unicode

if you try to read in the a-diaereses Latin-1 as UTF-8.

utf8 "\xFE" does not map to Unicode at Utils/Utils.pm line 78 (#1)
utf8 "\xA3" does not map to Unicode at Utils/Utils.pm line 78 (#1)
utf8 "\xA9" does not map to Unicode at Utils/Utils.pm line 78 (#1)
utf8 "\xA8" does not map to Unicode at Utils/Utils.pm line 78 (#1)
utf8 "\xAE" does not map to Unicode at Utils/Utils.pm line 78 (#1)
Unexpected RoboForm print list format; please report your platform and version of RoboForm

Ernests-iMac:convert_to_1p4 ernie$

Any suggestions greatly appreciated!

MrC

HI @Ennie,

Export and Conversion must generally be done on the same platform, since the file formats are different, and there is no facility in the converter to specify the export platform type (for a variety of reasons, this presents several challenges).

That said, I did put a sneaky trick into the roboform converter to support this. Add the `--windows`` option to your command line, and it should do the right thing. (I added this option for me to debug these files on OS X).

ErnieS

Thanks. But, it doesn't recognize this option. I get:

Ernests-iMac:convert_to_1p4 ernie$ cd '/Users/ernie/Desktop/convert_to_1p4' && /usr/bin/perl convert_to_1p4.pl roboform '/Users/ernie/Desktop/goodstuff.htm' -v --windows

*** Unknown option: windows

MrC

@Ennie,

Oh, sorry, you need the 1.10 version in Testing Bits, mentioned in the first post of the converter suite thread.

ErnieS

Worked Great!! Thanks for the converter! Now to try out 1Password.

MrC

Excellent, and you're welcome.

Enjoy 1Password, @Ennie !

MrC

Follow-up to @Estrojen1193 's issue above. We resolved the issue offline. Estrojen1193 had customized many of the stock categories, so the msecure converter was unable to recognize them. With Estrojen1193's guidance, I created a customized version of the converter module to match the category templates, and the conversion / import was completed satisfactorily.

DaveyDave

Hi. Because data exported from 1Password is unencrypted, I export directly to an encrypted disk image. I then convert the data.1pif file using the "1Password (for printing)" converter. The output file is saved to my Desktop which I then move to my encrypted disk image. Is it possible to save the output file directly to the encrypted disk image? Thanks!

MrC

@DaveyDave ,

You can use the -o option to specify the output file's location. Eg:

$ perl convert_to_1p4.pl onepif --format html_expanded 1P4_login.1pif -o foo.html -v
Imported 1 item
Exported 1 login item
Exported 1 total item
Your output file is foo.html

DaveyDave

@MrC ,

Thanks for the fast response. It worked perfectly.

By the way, the html_expanded format is awesome!

MrC

@DaveyDave ,

You're very welcome, and thanks for the kind words!

djustman

Back in February/March, there was a thread regarding a converter for Lockbox Pro. You indicated you were too busy to write one then; might you have time now (or in the near future)? I have used LockBox Pro for many years (and have recommended it to many of my friend, who are now users) and we need a solution to transfer our data to a better-supported password manager (like 1Password). Thanks for your help.

MrC

Hi @djustman ,

Sure, I'd be happy to write one. It will suffer from the limitations I mentioned in the sequence of threads (which I had to go back and re-read, since I'd forgotten about them). The data in Password box, as you see it, and as exported, is quite free format, so the best the converter can do is guess at the fields (based upon your help telling me what they are).

I don't have Password Box on my system. So I'll need you to generate for me an export file that contains dummy information for the available Category types (which according to the user @mclarenm would be Credit Card, Bank Account, Password, Contact Info, Notes, Other. Please include in one or more of them multi-line Information sections, and some Notes. I'll use this to write the converter and test it, and we can work out the details. It will likely be a back-and-forth process between you and I.

It will be challenging to reliably detect any data that should go into 1Password's Login category since Password Box does not have a Login category (it does have Password category). So if you have, for example, your Login records in the Other category and use a fairly consistent naming scheme for your URLs, passwords, and usernames, I'll need to know what that scheme is.

djustman

OK, here are several entries from my LockBox export (I've gone ahead and modified some of the sensitive data):

[ data deleted my MrC ]

MrC

@djustman ,

Oh, sorry, I should have mentioned. Email the raw file to me, since I have to read exactly the format you have (and copy / paste ruins that). That's why I'd need you to create a dummy, sample file, since I'll need the actual file generated. I'm going to delete your data above.

My email is at the top of the convert_to_1p4.pl script, which you can read with a text editor. Download from Testing Bits, mentioned in the first post of the converter suite .

We can work out any additional details via email, so as not to pollute this thread.

djustman

the export function uses shared wi-fi to transfer data from the iPhone to a desktop browser window
what I posted was exactly as it appeared in the browser window (with the modifications to sensitive info)
tell me what you need me to send you
thanks

MrC

@djustman ,

Ok, then you can save the web page using your browser. How you do this depends upon the browser you use. For example, in Firefox, it would be File > Save Page. We can try both Text File and Web Page, HTML Only. With Safari, it is File > Save As and you choose Page Source. I'd like to work with just one format, so lets just go with the HTML output (i.e. Web Page, HTML Only or Page Source).

You can edit this file to modify it, but be careful as to which editor you use. Be sure it is UTF-8 capable, and doesn't change the format! Unfortunately, this will be difficult for me to explain how to do, and how to detect.

djustman

I'm using Chrome. I can change the "view" to source file, but my only option to save it is as "text"

djustman

I also saved the exported file as a Microsoft Word doc, in which I used repeated "search & replace" commands to format it into discrete blocks of text, separating each entry with double-paragraphs

MrC

@djustman,

I can't use the Word document. It is entirely too much difficulty to read this format.

Since you are using Chrome, use File > Save Page As > Webpage, HTML Only.

djustman

Under File > Save Page As > my only two choices are "text" and "All Files"
I'm using Chrome on a Mac
Should I try this in Safari instead?

djustman

Safari offers "Page Source" and "Web Archive" as choices under File > Save As >

djustman

How do I edit the .webarchive file?

MrC

@djustman,

I'm confused about your Chrome choices:

In Safari, use Page Source.

Don't save as a webarchive file. That would be because you are saving as a Complete page, not just HTML only.

djustman

OK, I've edit the file in Text Edit
Where should I email it?

MrC

@djustman ,

I mentioned it in this post above.

djustman

I'll get back to this later this afternoon. Have a Dr.'s appt in 15 minutes. Thanks.

djustman

Just sent off the sample file via email. Hope I have it in the proper format. Thanks!