convert keepassx2 csv to 1password format (with group name as custom field)

PasswordMunge.py

import csv
import json
from os import path

KEEPASS_COLUMNS = [
	"Group","Title","Username","Password","URL","Notes"
]

ONE_PASSWORD_COLUMNS = [
	'title','website','username','password','notes','custom field 1'
]

# read keepass csv (exported with keepassx2)
with open(path.expanduser('~/passwords.csv'), newline='') as keepassCsv:
	keepass = csv.reader(keepassCsv, delimiter=',', quotechar='"')

	# open 1password csv
	with open(path.expanduser('~/1password.csv'), 'w', newline='') as onePasswordCsv:
		onePassword = csv.writer(onePasswordCsv, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)

		# for each keepass record
		for recordList in keepass:
			# record
			record = dict(zip(KEEPASS_COLUMNS, recordList))
			group = record['Group'].split('/')[1]

			# convert to 1password values list
			onePasswordRecord = [record['Title'], record['URL'], record['Username'], record['Password'], record['Notes'], 'group:' + group]

			# write to 1password csv
			onePassword.writerow(onePasswordRecord)

			# debug
			# print(json.dumps(record))
			# print(json.dumps(onePasswordRecord))

limitations:

• no history (not exported by keepassx2, not supported by 1password)
• no advanced fields (not exported by keepassx2)
• deleted entries are exported (could be easily added)