How do I export Software License Info?

Hello @SFO! 👋

Thanks for reaching out. You can export your items to 1PUX format using this guide: How to export your data from the 1Password desktop app

Exports are designed to allow you to bring your items to another password manager if you ever decide to leave 1Password. Does this option work for you? Or was there another reason why you wanted to export your Software License items?

I look forward to hearing from you.

-Dave

No, I need it in a spreadsheet. I don't need to move it into another password manager. Why was this functionality removed? Feels like system lock in.

@SFO

If you're interested in using the https://1password.community/discussion/101693/moving-to-1password-from-another-password-manager, I can add an option to the onepux converter to allow selection of categories. It already allows selection of vaults and tags. It can generate a CSV.

@MrC Oh, I have all my licenses put into a single vault for ease already. Sounds like I can just use your tool to move it into a csv file, if I'm reading this right?

Thanks!

@SFO

That's correct. Your command will look like:


perl convert.pl onepux -v --to_format csv --match_vault /software_license/ ~/Desktop/1PasswordExport-VXSLWGDV65BIZE5XVRANA44SDU-20240611-081013.1pux


Producing the rather wide CSV:

Note: I just updated the suite. For some reason, my build process didn't have an entry in the README for the onepux converter (I recently moved my development environment to a new machine).

Thanks @MrC. I'm not sure what's going on. The process matches, begins processing, but then I get an error saying it requires a 1pux file.

I've tried exporting from 1P8 multiple times, and I've followed the renaming and location directions, gave AppleScript the proper permissions, just can't figure out what's going wrong.

@SFO

Can you show the full command you are executing, or that the AppleScript generates in the Terminal?

For a single 1PUX file, those messages don't make sense to me. The "requires a 1PUX file" error would come before the skipping/processing of vaults.

Ok, weirdly, I managed to get it to run this time. Using the helper I couldn't get it to run and I had started by going straight to the terminal with the commands you provided, but it wasn't working. Clearly I messed something up because when I went back to the terminal this last time it worked.

Sorry about that, and thank you for your help @MrC !!!

@SFO

I'm guessing you've added extra options to the helper in the form of the full perl command (rather than just the options). The perl command is being doubled up here. Try just using the two command line statements directly in Terminal:


cd '/Users/christopherolson/Desktop/mrc-converter-suite'
/usr/bin/perl convert.pl onepux v --to_format csv --match_vault Software '/Users/christopherolson/Desktop/pm_export.1pux'


See if this works for you.

@MrC Yeah, sorry I guess I didn't edit my comment quickly enough.

I figured I was messing something up using the helper when I pasted in my response, so I went back straight to the terminal again and got it to work. Thank you so much.