If you have a Field Label of 'Date', change the name to something else, like 'Date Changed'. One last caveat I found from my conversion. Your notes must be in column whose heading is 'Notes' (usually AH). You must have the third entry in the set of 3, and it should be a '0' (show) or a '1' (hide). Two things that will mess you up every time:

Also, move any field entries, in sets of 3, back to the next blank 'Field x' group, so you don't lose them. Go through, line by line, making sure that your notes are in the Notes column (AH). It is set to '0' if you want to see the entry, or '1' if you want it hidden when the program is working. One thing to be careful of while you are editing: The 'Hidden' entry must be there. Use the Excel 'Freeze Panes' option to keep these on your screen. This is your guidance to how the CSV file is set up. On the second line (now the first, if you followed my tip above) of the CSV file, there will be your item headers ('Is Template?', 'Title', 'Category', 'Field x Label', 'Field x Value', 'Field x Hidden', and finally 'Notes'). At least I think it's needed, but I was unable to find any documentation on mSecure about the program (another gripe for another forum!). The first line is some directive information for the importer program, giving some basic information about the file, etc. The above fixes in your text editor should have corrected about 80-90% of the changes required, but this part is all manual. Load the CSV file into Excel, and now comes the slow slog to make things correct. Save the file, and you should now be ready for Excel. NOTE: Do not delete the double quotes in the note entry! These are delimiters used by Excel and mSecure to find the start and end of text when commas or other text delimiters are found in the note. You will probably notice that the last line in the sequence has a double quote (') at the end of it. Repeat these two steps until you have moved the note to a single line. Use the delete key to bring the next line up to the end of this line. Add a mnemonic to yourself for the line break. Find each entry spanning multiple actual lines. This is important if your editor does automatic line breaks, so you can separate long wrapped lines from multiple line entries. If you can set it up so the line numbers are shown on the left, do it now, so you can see the line breaks more easily. Advice to you depending on your text editor. You may also want to look for ',Custom 1,0,' through ',Custom 9,0,' and change those as well. You want to keep them as a blank placeholder so Excel (and mSecure) will deal with it appropriately. Do not erase them, especially if you have a note on that entry. These are placeholders for the PP export file. You may find a number of entries in the file that look like ',Custom,0,'. This step is optional but will make your Excel fix a lot easier. These are PP templates, which you really don't want to import. You will see a number of lines that start with a '1,'. I use TextPad, but you can use any textual editor for this step. Load the file (probably called 'PassPlusDatabaseExport.csv') into a TEXT editor. Here are a few things that I did to get my CSV file into shape for importing: The export facility in PP doesn't handle this terribly well, especially if your Notes span multiple lines with line breaks in there. However, if you are like me and many other longtime PP users, your file has lots of Notes, any number of 'duplicated' entries, and other non-standard items. Well, if you have a simple PP database, this method will work just fine, I suppose. Converting Passwords Plus to mSecure: The CORRECT WAY!ĭataViz suggests that you export your PP database to a CSV file, then go to mSecure and import it there using the special 'Import from DataViz Passwords Plus CSV' option on the import screen.

Point passwords plus to the data file