Powershell
Powershell

Using Powershell to Convert PFX to PEM

Hi,

I'm looking for a code snippet to do the following, I've created a bit of the code:

1. Read a list certificates - $certs gci c:\certs -include *.pfx -name
2. For each certificate name run the following command against it
openssl pkcs12 -in <certificate name.pfx> -out <certificate name.pem> -nodes -password pass:<Password>
3. The password has to be extracted from an excel spreadsheet with two columns, certificate name and password.

I essentially want to be able to convert a load of pfx certs to pem certs and retrieve the associated passwords from a spreadsheet, the certificate name in the spreadsheet will be identical to the one in step 1

Any help appreciated.

ndr-itsolutionsAsked: 2015-10-31

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 74

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented: 2015-10-31

Does it really need to be an Excel file? A CSV is much easier to handle.

ndr-itsolutionsAuthor Commented: 2015-10-31

CSV is fine.

LVL 74

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented: 2015-10-31

I'll reverse the logic slightly, using the CSV to locate files instead of going the other way round.
The CSV has columns certname (without file extension) and password.

push-location c:\certs
import-csv certs.csv | % { openssl pkcs12 -in "$($_.certname).pfx" -out "$($_.certname).pem" -nodes -password pass:$($_.password) }

Open in new window

This does not work well if you have a big list of certs, but only want to apply the script to a few you put the files in the folder.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial