Decrypting an entire CSV file
A2ZUniforms.com
sales@a2zuniforms.com
Mon Apr 1 15:47:02 2002
This is a multi-part message in MIME format.
--Boundary_(ID_8ytwJ3HbC55/7xGLY7pM3Q)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
Hey guys. I'm new to the list and I think I will finally find the answer to my question here. Our shopping cart encrypts our order log file (filename.csv) (pipe delimited) and adds to the file each time a new order is placed. Up until now we have downloaded the encrypted file, opened it in Wordpad, using PGP Tray select CURRENT WINDOW > DECRYPT AND VERIFY. This will allow us to copy the decrypted info entire file and past it to a new window. If we were to simply try and decrypt the file without going through the process just described, it would decrypt the file and create a bunch of individual "decrypted" files with goofy names and no extensions.
We just created a script to log into the webserver, download the CSV files and then run a BAT file to decrypt the file we just downloaded. But when using the command line to decrypt the file the only thing we end up with is the last record added to the encrypted CSV file. The file is decrypted on a Win XP machine. Can anybody tell me the command line we should use to
1) decrypt the file
2) keep the entire contents of the file
3) keep the same file name after it is decrypted
A sample of the encrypted info is shown below. If there are 50 orders , then there would be 50 sections (if that is what you call them)
Thanks,
Tim Durham
-----BEGIN PGP MESSAGE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org
hQIOA8gNDLAgh8LpEAgA41i6fpZYfVw4SxFiUPFAak47GV6jcBuGCWyAGKMcC4Yd
7WWaR4KnOcMtoE0DsIoQcgBrBV0/Fi4+t1B77JBwDNmyAAa7fyys9K5iSBjBqEFk
jlslKUUBmD+XXQ0E9JGpdHeV8npnJOkvHYLDdWjYr22lLMee0OAeDRn401FkxcvW
iyCG9y0xWUROhWpe1UNmW6siLRbM9oM7ahdvjWg+73LcmIhwkkeHUnGasKNQj8Tc
QpVpU4Jx2HkQPYtcX48SXhVZ04wQC2+UwMMR+xtti0EbOlprV1w6+p6WlIVnbAVR
2JeLKO3QdCngi3J3vN5WbWV8Nqa0L944mtn8yREAwgf/WIzBuZRCyU/tUsb4Hkqi
ml1AUjWdMfL2IiBBxeyqY5dgRdAlWYay1VhfsMlc5W/RFQPE9Of1LrWrEfEmCdz0
Pj12dohN4Fhkdm+U4U7DR66EKXQoOY5/OQgODmsH7tOWx4l1+X66A3oCgtojel7u
v0ODCbxhcKxrmqLx76MlcotSEV9qqOHDMjKH9BJoYMpWM+VlZAs3Ozm4Tfo4K49p
W/9BjBNCN3UwK12+IXZ1wluHiOLyaC3VvusuiG5IJQW3ffBRgWQga38p0KUmnTz9
isN/cm/GXo26VyoINqjRyXZ9mMDAlsURSp2yk+Rwe7LUuYBTniGyAzMGeziYsSAp
fcnA6vncOZb5Q73lrMg0ODbWYCMHJijsHQmP4nVDgB53qQjitFcCgUChmMyhOaOQ
/3QpPBN8MMSRr5uU6rMcGVbgM2Rc818VamftX1BX3K/U4zwoJqVPAI/1l3SZWk2b
v0rLGQXEtCJA6Q8lii0X+UsYXojlZJEk01Zju1fVY+l+EciwAfyRCEwxDxqKT4Uo
Pc68VGI/EJH99nk6yVMCQs2ryW3slJziMq2Oq2e6IA10OhbZF7no1pQQhywEX4GR
0BiHTJvh07gGCnGEDIOHYWCjDHA1qUBIofQMo1BQrKzk7ZDKN4esN9Wih2LgZA3l
yUI9SMFw6jxypkNJ59LFx+HGx+r63TcBHRPqWeO5D+NtsgIG7PpYSXwdOhENg7St
+Bc7QpFXcQLx0ufBh6Eq2ky4octcMyiPjADSDn/7cfNx2xyAyOtwEzkK6g8H9agz
y5jPKSqHrPhpYp+eRidJHeEEeZjWyPHvHM/dKcFRL04LeFs6nwiGm/snUtqnU0jn
WacTApK4L4vz3ZtvB3as0Qtr9kNtV7C8krH/Q4n3Z8WoMCcQnGwGZQe9Sg6v0w==
=o6Qi
-----END PGP MESSAGE-----
-----BEGIN PGP MESSAGE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org
hQIOA8gNDLAgh8LpEAgAg9qlAHJAIM2T7elNspEZ5tDTOG/kjMMn7e5aHmsqHujt
vPXf4Jwa51aCb+N5ymMBnhWhK6nzFd+GgMs9LWYpfZVouU0GzSkdQ9iXcX9AHkQU
ROSrroACd1kFDKB+E2sa2klEAREgU46v0yjMf4lWzz0VoGv+ql0HWOLBGYcrMCJl
/fItLhdehkoUovtIf6fAiEVSCIUySsteCH1lZjWkUVXuDm3AH8i0jEil3m2K63J7
lT17uJCXKBcgsQTn/AKW6zvm952WuvbIGEwoK9E02xtdmg2yWeWmS0jUggDLghnn
7CYT5KRi8KChPNlJ1O4ZHSnr9jhvX/WJleXpoW0UrggA4TtKybQwIxIMeu1/Oeud
L00xREzmQF2bDVF00x1zF4KLKbKZEv/w41Vl/Oy2CY0zxxk8PX4jHPo8oLZJX6+4
AJHK+FxtISorXKfNVavRqFnL7ELtEruZNn0O6LYvtplA7U3COlnBIMjX2VyaYBSJ
8hpxtn7IIsQOsE9SDlFwCTbpW8RQPQlPeGFRta1mKHj6eU1NS8ybxTPG977+jTt7
oMolBowSJ2PjN147N/h7UDaMt4xSdyUH+Z40jvmoM1GkMhL4FCvcEVr/RcJy1SqA
/owidEkm2pNmXwhNvcpbVyeF8PGN4u+ZDQoUnTXj39QRNqYq4A+AM8y6FTU7EYFS
b8np0bKMlSkFFjtwzuWn7AoGg0D8+qQ23eApaN1SzvkAh7sDdy02sdommGUT82jo
u7vSbpTYrdHLJvBFc5A7Xr9S5m5hvHFpi0udszKDFl+pJ0CxWw4fdUk50LNCSN6w
LoEaDIi8MzO8c4s8lGf9RwUqKjNOXIykB3Vj+bJ5/eSgz1qnl25LHMEe9Kr4ZNlP
EJ5maqt1+9NTZhblLOA3QAMNd9WkxQbxljMV+qREScvbfvOhlhzOaBNpXVbNmNcC
namw3SIyHgYaf/7FRLDZcHYkNhGoZZzGpH+DRkHOuLNvlJkwgSaF9ugU0+ye2+ID
hqfksPFdRC8iMUQaTfDcNsucRoDPMshm7aa6qr6lSRaezV6T7r6zxlC7e/ryFYTd
cvVP/YtqHax/SbOvOUTUHBpBXi+4gyQNFdgr+R5RcOo+jKJqDj4wUxRIz9LE1LU4
D9MuBqg0B6+LlC+CmMbmnFkoRHTvW/tYT0HMP2hk3+VJtK4o9lqKDf3CbTTalA/e
kFhCG3I7YhXJjNZua9HaqnxqbdDbHf5XpQh2anLhk8QW69f0JMPFPTme4uUED2vz
3LindPWbHHfg2NwEqX6JgTHWjh4HpmUaQMinOMAHT7NZfPKoUnDpro86R8mDgkUK
emZM+K1ccuDGKJhEiYIdzhqmuUSRzPABgDGLTYQdlQOcugUVoJitrwYWtefCfjnq
j0tHTRTnHasC
=jXuV
-----END PGP MESSAGE-----
--Boundary_(ID_8ytwJ3HbC55/7xGLY7pM3Q)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2713.1100" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hey guys. I'm new to the list and I think I
will finally find the answer to my question here. Our shopping cart
encrypts our order log file (filename.csv) (pipe delimited) and adds to the file
each time a new order is placed. Up until now we have downloaded the
encrypted file, opened it in Wordpad, using PGP Tray select CURRENT WINDOW >
DECRYPT AND VERIFY. This will allow us to copy the decrypted info entire
file and past it to a new window. If we were to simply try and decrypt the
file without going through the process just described, it would decrypt the file
and create a bunch of individual "decrypted" files with goofy names and no
extensions.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We just created a script to log into the webserver,
download the CSV files and then run a BAT file to decrypt the file we just
downloaded. But when using the command line to decrypt the file the only
thing we end up with is the last record added to the encrypted CSV file.
The file is decrypted on a Win XP machine. Can anybody tell me the command
line we should use to</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1) decrypt the file</FONT></DIV>
<DIV><FONT face=Arial size=2>2) keep the entire contents of the
file</FONT></DIV>
<DIV><FONT face=Arial size=2>3) keep the same file name after it is
decrypted</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>A sample of the encrypted info is shown
below. If there are 50 orders , then there would be 50 sections (if that
is what you call them)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Tim Durham</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT size=2>
<DIV><FONT face=Arial>-----BEGIN PGP MESSAGE-----</FONT></DIV>
<DIV><FONT face=Arial>Version: GnuPG v1.0.4 (GNU/Linux)</FONT></DIV>
<DIV><FONT face=Arial>Comment: For info see http://www.gnupg.org</FONT></DIV>
<DIV><FONT
face=Arial>hQIOA8gNDLAgh8LpEAgA41i6fpZYfVw4SxFiUPFAak47GV6jcBuGCWyAGKMcC4Yd</FONT></DIV>
<DIV><FONT
face=Arial>7WWaR4KnOcMtoE0DsIoQcgBrBV0/Fi4+t1B77JBwDNmyAAa7fyys9K5iSBjBqEFk</FONT></DIV>
<DIV><FONT
face=Arial>jlslKUUBmD+XXQ0E9JGpdHeV8npnJOkvHYLDdWjYr22lLMee0OAeDRn401FkxcvW</FONT></DIV>
<DIV><FONT
face=Arial>iyCG9y0xWUROhWpe1UNmW6siLRbM9oM7ahdvjWg+73LcmIhwkkeHUnGasKNQj8Tc</FONT></DIV>
<DIV><FONT
face=Arial>QpVpU4Jx2HkQPYtcX48SXhVZ04wQC2+UwMMR+xtti0EbOlprV1w6+p6WlIVnbAVR</FONT></DIV>
<DIV><FONT
face=Arial>2JeLKO3QdCngi3J3vN5WbWV8Nqa0L944mtn8yREAwgf/WIzBuZRCyU/tUsb4Hkqi</FONT></DIV>
<DIV><FONT
face=Arial>ml1AUjWdMfL2IiBBxeyqY5dgRdAlWYay1VhfsMlc5W/RFQPE9Of1LrWrEfEmCdz0</FONT></DIV>
<DIV><FONT
face=Arial>Pj12dohN4Fhkdm+U4U7DR66EKXQoOY5/OQgODmsH7tOWx4l1+X66A3oCgtojel7u</FONT></DIV>
<DIV><FONT
face=Arial>v0ODCbxhcKxrmqLx76MlcotSEV9qqOHDMjKH9BJoYMpWM+VlZAs3Ozm4Tfo4K49p</FONT></DIV>
<DIV><FONT
face=Arial>W/9BjBNCN3UwK12+IXZ1wluHiOLyaC3VvusuiG5IJQW3ffBRgWQga38p0KUmnTz9</FONT></DIV>
<DIV><FONT
face=Arial>isN/cm/GXo26VyoINqjRyXZ9mMDAlsURSp2yk+Rwe7LUuYBTniGyAzMGeziYsSAp</FONT></DIV>
<DIV><FONT
face=Arial>fcnA6vncOZb5Q73lrMg0ODbWYCMHJijsHQmP4nVDgB53qQjitFcCgUChmMyhOaOQ</FONT></DIV>
<DIV><FONT
face=Arial>/3QpPBN8MMSRr5uU6rMcGVbgM2Rc818VamftX1BX3K/U4zwoJqVPAI/1l3SZWk2b</FONT></DIV>
<DIV><FONT
face=Arial>v0rLGQXEtCJA6Q8lii0X+UsYXojlZJEk01Zju1fVY+l+EciwAfyRCEwxDxqKT4Uo</FONT></DIV>
<DIV><FONT
face=Arial>Pc68VGI/EJH99nk6yVMCQs2ryW3slJziMq2Oq2e6IA10OhbZF7no1pQQhywEX4GR</FONT></DIV>
<DIV><FONT
face=Arial>0BiHTJvh07gGCnGEDIOHYWCjDHA1qUBIofQMo1BQrKzk7ZDKN4esN9Wih2LgZA3l</FONT></DIV>
<DIV><FONT
face=Arial>yUI9SMFw6jxypkNJ59LFx+HGx+r63TcBHRPqWeO5D+NtsgIG7PpYSXwdOhENg7St</FONT></DIV>
<DIV><FONT
face=Arial>+Bc7QpFXcQLx0ufBh6Eq2ky4octcMyiPjADSDn/7cfNx2xyAyOtwEzkK6g8H9agz</FONT></DIV>
<DIV><FONT
face=Arial>y5jPKSqHrPhpYp+eRidJHeEEeZjWyPHvHM/dKcFRL04LeFs6nwiGm/snUtqnU0jn</FONT></DIV>
<DIV><FONT
face=Arial>WacTApK4L4vz3ZtvB3as0Qtr9kNtV7C8krH/Q4n3Z8WoMCcQnGwGZQe9Sg6v0w==</FONT></DIV>
<DIV><FONT face=Arial>=o6Qi</FONT></DIV>
<DIV><FONT face=Arial>-----END PGP MESSAGE-----</FONT></DIV>
<DIV><FONT face=Arial>-----BEGIN PGP MESSAGE-----</FONT></DIV>
<DIV><FONT face=Arial>Version: GnuPG v1.0.4 (GNU/Linux)</FONT></DIV>
<DIV><FONT face=Arial>Comment: For info see http://www.gnupg.org</FONT></DIV>
<DIV><FONT
face=Arial>hQIOA8gNDLAgh8LpEAgAg9qlAHJAIM2T7elNspEZ5tDTOG/kjMMn7e5aHmsqHujt</FONT></DIV>
<DIV><FONT
face=Arial>vPXf4Jwa51aCb+N5ymMBnhWhK6nzFd+GgMs9LWYpfZVouU0GzSkdQ9iXcX9AHkQU</FONT></DIV>
<DIV><FONT
face=Arial>ROSrroACd1kFDKB+E2sa2klEAREgU46v0yjMf4lWzz0VoGv+ql0HWOLBGYcrMCJl</FONT></DIV>
<DIV><FONT
face=Arial>/fItLhdehkoUovtIf6fAiEVSCIUySsteCH1lZjWkUVXuDm3AH8i0jEil3m2K63J7</FONT></DIV>
<DIV><FONT
face=Arial>lT17uJCXKBcgsQTn/AKW6zvm952WuvbIGEwoK9E02xtdmg2yWeWmS0jUggDLghnn</FONT></DIV>
<DIV><FONT
face=Arial>7CYT5KRi8KChPNlJ1O4ZHSnr9jhvX/WJleXpoW0UrggA4TtKybQwIxIMeu1/Oeud</FONT></DIV>
<DIV><FONT
face=Arial>L00xREzmQF2bDVF00x1zF4KLKbKZEv/w41Vl/Oy2CY0zxxk8PX4jHPo8oLZJX6+4</FONT></DIV>
<DIV><FONT
face=Arial>AJHK+FxtISorXKfNVavRqFnL7ELtEruZNn0O6LYvtplA7U3COlnBIMjX2VyaYBSJ</FONT></DIV>
<DIV><FONT
face=Arial>8hpxtn7IIsQOsE9SDlFwCTbpW8RQPQlPeGFRta1mKHj6eU1NS8ybxTPG977+jTt7</FONT></DIV>
<DIV><FONT
face=Arial>oMolBowSJ2PjN147N/h7UDaMt4xSdyUH+Z40jvmoM1GkMhL4FCvcEVr/RcJy1SqA</FONT></DIV>
<DIV><FONT
face=Arial>/owidEkm2pNmXwhNvcpbVyeF8PGN4u+ZDQoUnTXj39QRNqYq4A+AM8y6FTU7EYFS</FONT></DIV>
<DIV><FONT
face=Arial>b8np0bKMlSkFFjtwzuWn7AoGg0D8+qQ23eApaN1SzvkAh7sDdy02sdommGUT82jo</FONT></DIV>
<DIV><FONT
face=Arial>u7vSbpTYrdHLJvBFc5A7Xr9S5m5hvHFpi0udszKDFl+pJ0CxWw4fdUk50LNCSN6w</FONT></DIV>
<DIV><FONT
face=Arial>LoEaDIi8MzO8c4s8lGf9RwUqKjNOXIykB3Vj+bJ5/eSgz1qnl25LHMEe9Kr4ZNlP</FONT></DIV>
<DIV><FONT
face=Arial>EJ5maqt1+9NTZhblLOA3QAMNd9WkxQbxljMV+qREScvbfvOhlhzOaBNpXVbNmNcC</FONT></DIV>
<DIV><FONT
face=Arial>namw3SIyHgYaf/7FRLDZcHYkNhGoZZzGpH+DRkHOuLNvlJkwgSaF9ugU0+ye2+ID</FONT></DIV>
<DIV><FONT
face=Arial>hqfksPFdRC8iMUQaTfDcNsucRoDPMshm7aa6qr6lSRaezV6T7r6zxlC7e/ryFYTd</FONT></DIV>
<DIV><FONT
face=Arial>cvVP/YtqHax/SbOvOUTUHBpBXi+4gyQNFdgr+R5RcOo+jKJqDj4wUxRIz9LE1LU4</FONT></DIV>
<DIV><FONT
face=Arial>D9MuBqg0B6+LlC+CmMbmnFkoRHTvW/tYT0HMP2hk3+VJtK4o9lqKDf3CbTTalA/e</FONT></DIV>
<DIV><FONT
face=Arial>kFhCG3I7YhXJjNZua9HaqnxqbdDbHf5XpQh2anLhk8QW69f0JMPFPTme4uUED2vz</FONT></DIV>
<DIV><FONT
face=Arial>3LindPWbHHfg2NwEqX6JgTHWjh4HpmUaQMinOMAHT7NZfPKoUnDpro86R8mDgkUK</FONT></DIV>
<DIV><FONT
face=Arial>emZM+K1ccuDGKJhEiYIdzhqmuUSRzPABgDGLTYQdlQOcugUVoJitrwYWtefCfjnq</FONT></DIV>
<DIV><FONT face=Arial>j0tHTRTnHasC</FONT></DIV>
<DIV><FONT face=Arial>=jXuV</FONT></DIV>
<DIV><FONT face=Arial>-----END PGP
MESSAGE-----</FONT></DIV></FONT></BODY></HTML>
--Boundary_(ID_8ytwJ3HbC55/7xGLY7pM3Q)--