1Password PUX import fails..how to track error locations?

I finally decided to ditch 1Password, but when I try to import a PUX file, I receive this error: " [3939] [Login] “a-Idtag”: The field Name exceeds the maximum encrypted value length of 1000 characters."

I’ve deleted some longer text fields, but none have exceeded 1000 characters. Each time I edit something, I get different errors: “[3627] [Login] “a-Idtag”: The field Name exceeds the maximum encrypted value length of 1000 characters.”
This is an encrypted file. How do I find what is causing this import error?
There are no visible Names or Field Names that come anywhere close to 1000 characters.
Thanks!

@kboi Welcome to the forum!

The 1PUX format by definition is a “1Password Unencrypted eXport”, so it is not actually encrypted. The file format is described here:

 

The 1000-character limit is for the length after encryption. As explained here, this means that the length prior to encryption cannot be longer than 688 characters (if the text contains only ASCII characters), or may max out at 172 characters (if every character is a 32-bit Unicode character).

If you are having trouble finding the offending record, then you can divide your login items into two halves, and attempt to import each half — for the one that fails with the same error, divide the file again into halves, and repeat until you find the lolgin that is causing the error.

To divide the data, in case 1Password doesn’t allow you to select which logins to include in an export, you could process the exported file as follows:

  1. Make a copy of the 1PUX file, and rename the .1pux extension to .zip.
  2. Unzip the .zip file into a folder.
  3. Within the unzipped folder, open the export.data file in a text editor.
  4. Within the "items: [ ]" section of the JSON structure, individual items start with {"uuid": and end with }, (or just }, for the last one) — delete about half of the exported items, and save the file.
  5. Re-zip the contents of the folder.
  6. Rename the .zip extension to .1pux.