How do I export Software License Info?

Thank you for sharing your success and for the nice feedback PeterNorman .

I woke up early today, and this thread's notification email was a perfect read to accompany the morning's coffee.

Cheers, and Happy Holidays,
MrC

Hi!

MrC, thank-you very much for your https://1password.community/discussion/101693/moving-to-1password-from-another-password-manager!

Upon realizing that 1Password for Mac 8.10.54 CSV Export does not include Software Licenses, research led me to this forum thread and your https://1password.community/discussion/101693/moving-to-1password-from-another-password-manager.

I tried importing 1Password's 1pux export file into RoboForms, KeePassXC and Minimalist in the hope that one of those apps would allow me to then export my 1Password Software License data in a useful form. No luck!

Now, my 407 Software Licenses are living in an Apple Numbers spreadsheet thanks to your command line Perl scripts.

I really appreciate the time and effort you put into the https://1password.community/discussion/101693/moving-to-1password-from-another-password-manager!

Thank-you again and all the best!
Peter

Thank you MrC. 💙

-Dave

Fantastic SFO !

Let me know if there are any feature additions you need to simplify your work.

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.

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.

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

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.

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

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).