Converter for Password Boss JSON [Solved: Converter available]

Hi @drwadmin ,

I have never looked at Password Boss or it's JSON output. I can take a look at it if that would be helpful. Your export would need to be in the unencrypted format.

Edit: The converter suite as of 2020-11-21 now includes this converter.

@drwadmin ,

I've taken a cursory look at the export using some sample data I created. I can make a converter for this.

Since there are a fair number of combinations of item types, I'd like to first create the converter table entries required based on data you actually have. To collect this Type / Sub-type information:

1. Export your data file to your Desktop, using the default name of PasswordBossExport.json (this location / name is used by step 3 below).
2. Open the Terminal app (its under Applications/Utilities, or you can use Spotlight to find it for you).
3. Copy / paste the following command for me (use Copy / Paste, don't enter it manually since the spaces I've included are important). It should be a single long line:

pr -mt <(grep secure_item_type_name ~/Desktop/PasswordBossExport.json) <(grep '^ "type" : ' ~/Desktop/PasswordBossExport.json) | sort -u

4. Provide me with the output. It should not contain any sensitive data - if it does, don't copy/paste it here). It should look like this:

  "secure_item_type_name" : "DW     "type" : "Bank",
  "secure_item_type_name" : "PI     "type" : "Address",
  "secure_item_type_name" : "PI     "type" : "Company",
  "secure_item_type_name" : "PI     "type" : "Email"
  "secure_item_type_name" : "PI     "type" : "Names",
  "secure_item_type_name" : "PI     "type" : "PhoneNumber",
  "secure_item_type_name" : "PV     "type" : "Application",
  "secure_item_type_name" : "PV     "type" : "Website",
  "secure_item_type_name" : "SN     "type" : "DriverLicense",

With this, I can start work on the converter, and we can adjust it to meet your needs as we go.

I'm sorry, @drwadmin , since you were in the Mac forum, I assumed you were on a Mac. Yet somehow by your user name, I had a suspicion you were on Windows!

I'll start the converter and add an option to output the data I need. I should have this for you sometime later today.

@drwadmin ,

I've posted an update to the converter I placed in the Custom folder mentioned above. Please update your earlier version and give it a try.

Of your list, I've implemented the following:

PV::Application (8)
PV::EmailAccount (6)
PV::Website (174)
PV::Server (7)
PV::WiFi (8)
DW::CreditCard (1)
PI::Names (2)
SN::GenericNote (1)

and also SN::DriverLicense. The remaining items from your list will go to Secure Notes

PI::Address (1)
PI::Company (1)
PI::Email (2)
PI::PhoneNumber (1)

Unfortunately I cannot associate these with the Identity entry I created from the PI::Names category, since there is no linkage information. Creating multiple Identify records seems wrong. So, post-import, you can update your Identity records with the correct information from these.

To run the converter, re-run the cd and conversion commands you ran above, without the --dumpcats option this time. You can add the -v option if you'd like verbose output showing you category import/export counts:

$ perl convert.pl passwordboss -v ..\PasswordBossExport.json
Imported 15 items
Exported 1 identity item
Exported 1 email item
Exported 1 server item
Exported 7 note items
Exported 1 creditcard item
Exported 3 login items
Exported 1 wireless item
Exported 15 total items
You may now import the file C:\Users\cappella\Desktop\1P_import.1pif into 1Password

Import the mentioned file into 1Password, and examine the records to see how they look.

Hi @drwadmin ,

Good feedback, thanks.

1. I don't think we need both URLs, the one that is the first field in a password record is fine.

I'll compare the URLs - if they are different, I'll keep both; otherwise I'll ditch the dup.

2. That color gets auto generated so it doesn't need to be included.

It's customizable, so thought you or others might want the option. Some folks use colors like tags. My general policy is to retain all information available.

3. Looking at what came over with the subtitle notes, it is just the username, we don't need that.

That's what I was thinking. I'll compare, and eliminate a dup. But subtitle seems to be the appropriate identifier, from the specific PWB entry that supplements the title, making them uniquely identifiable (e.g. for Joe's two phone records, Joe's Phone: 555-1222, and Joe's Phone: 555-1313. Likewise for credit card numbers, etc.). Anyway, I can include commented out entries that append this subtitle, or maybe introduce an option such as --appendsubtitle.

Some other notes on the import:
• In some cases we do have multiple identities as part of their auto-fill options on web forms. If having two identities in 1password isn't really allowed I guess we can just make it a note and delete it later. Like I have one for being an admin and one that is just my own work profile depending on the type of form I need to fill out. When I looked at the identities that came over, they were missing a several fields from the original entry in PWB like address, phone, and company. I also see lots of notes that got added including pieces of the identity I am guessing, which if we can’t get those into the identity entry, are necessary. We can just delete those unless they can be removed from the code.

You can have any number of 1Password Identities. And the converter creates them based on the PI::Names entries. You have two, so should have two Identity records.

What I cannot do, is connected your other PI items such as address, phone, and company to those Identity records, because there is nothing in the export that link's them to each other. In the export, they are just arbitrary, disconnected entries. You have two email address entries - how could I know if one or both or neither should be associated what one or both of your name entries? So you will need to copy / paste the appropriate field values from those items (stored as Secure Notes), and place the data into the the correct Identity record created for you.

• Looking at the fields that come over in the notes section, I would say none of them are useful and just clutter up the record. There are just generated in PWB and not useful unless you are using PWB (subtitle, remote_connection, windows_application, password_age, password_visible_recipient, ignoreItemInSecurityScore). Can you remove those, otherwise I can probably figure out how to pull them out of the code. I did check a couple of entries that we had notes on and those did come over.

Of all the fields you listed above, some are on Windows exports only, and some I do not see in either. Here's what I see...

Windows / Mac:

subtitle

Windows only:

ignoreItemInSecurityScore
password_age

I don't see the following in my Mac or Win PWB export:

remote_connection
windows_application
password_visible_recipient

How were they generated, or more importantly, how can I generate them (so that I may add filters to the code)?

• Is it possible to override the Created and last modified in 1password with the same fields in PWB?

I don't see either of these dates in my export. Where are these coming from, and how did you get them generated?

• All the passwords that were shared to me came over as a private password entry. Is it possible to exclude those as we would want those to be reshared by person who shared it? Wasn’t sure if you saw something that designates it as such.

How would I know they were "shared". What specifically and unambiguously in the export can tell us that?

Again thank you for all your work on this. I understand if any of the questions above would add significant amount of work. At least I was able to import which is a step in the right direction. I work for a nonprofit org and we have to import for multiple staff.

You're welcome. Happy to help!

I've posted another update, which includes:

1. removes the login_url when it is the same as url
2. adds an ----appendsubtitle option, as per discussion above. See screenshot showing entries with and without this option enabled.

Hi @drwadmin ,

I can add those fields to the two "ignore" lists I added to the most recent update. You can probably figure out how that's done too, by the code I showed above.

The created and modified time stamps are not present in my export records:

so if Password Boss is not exporting these values, there's nothing I can do convert them! :-)

Regarding "shares", again, if there is nothing in the JSON export file that can be used to indicate a record is shared, there's nothing I can do. So you'd need to figure out how to isolate your exports to include only the records you want converted.