We have a CGI Cart (The Selena Sol CGI Shopping Cart) that writes a file to disk in a format that we cannot import into our main customer database. The format of the file is displayed below:
Item = product name
Description = product details go here
Your Price = $ 89.95
Quantity = 1
Subtotal For Item = $ 89.95
Subtotal: = $ 89.95
Shipping: = $ 7.95
Grand Total: = $ 97.90
Name = Your Name
Phone Number = Your Number
Email = xxxxxx
Mailing Address Street = 1234 Some St.
Mailing Address City = Anytown
Mailing Address State = Any state
Mailing Address Zip = Anyzip
Zip+4 = zip+4
Mailing Address Country = USA
Card Holder Name = Card Name
Card Number = 41111111111111111111
EXP Date = 10/10
Security Code = 1234
Payment Type = Visa
Comments = Some comments here
Shipping Option = ups ground
We need the file format to remain the same for when it is sent to the customer email, but different when written to file.
We need the format of this file to be tab Delimited as shown below:
Fastin| 60 Fastin Tablets|89.95|1|89.95|89.95|7.95|97.90|Your Name| Your Number| |1234 Some St.| Anytown| Any state| Anyzip| zip+4| USA| Card Name|41111111111111111111|10/10|1234| Visa| Some comments here| ups ground
We will provide access to all CGI libraries and provide support. We also may need additional fields after we do a test of these basic fields. Some fields, like zip+4 might be blank, but the system still needs to have some type of placeholder.
If more details are needed, please ask and we will get back to you asap.