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.
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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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) }
Premium Content
You need an Expert Office subscription to comment.Start Free Trial