1Password 8: Import or open .PIF file

MrC,

I ended up successfully migrating several hundred software licenses. A very important recommendation was to convert the CSV file to a PIF file using the Perl tool. This also solved the localization problem.

Since it may be helpful to others, I will briefly describe my workflow:

• I exported the software licenses from Bitwarden into a CSV file.
• I opened the CSV file with Apple Numbers. As Bitwarden does not have a software license category, all licenses were exported with the type "note". As I had all licenses in a folder, I could easily select them. However, all user-defined fields have been combined into one field named "fields".
• I split the contents of "fields" into individual fields. This is an example of the formula I used to extract the version information: IFERROR(REGEX.EXTRACT(E2,"(Version: )(.*)$",1,2),"").
• I copied the table to a new table (Edit > Paste Formula Results) and fixed some entries manually.
• I removed the columns I did not need anymore, such as "fields" and changed the column labels to match the list given in the readme.html.
• I exported the table to a new CSV file.
• I ran the Perl script. Two comments: The argument "--sepchar" mentioned in the readme.html is obviously not supported anymore, and it is obviously also not required. The Apple Numbers CSV export format uses ";" as the delimiter. However, the argument "--sepchar ;" was not required. The Perl script still worked beautifully. Moreover, the date format has to be yyyy-mm-dd, not mm/yyyy or mmyyyy as mentioned in the readme.html.
• I finally imported the generated PIF file into 1Password.
• Done :-)

Again, many thanks to everybody for supporting me!