Basic script needed for transferring data from email into customized format for mailing
$100-300 USD
Bezahlt bei Lieferung
Hi we need to have information that comes from an email transferred into a format that our shipping company can process. The email contains the online transaction receipt from customers with their name, address and shipping address and it must be put into a specific format for our shipping company to process the orders.
Here is an example of how they require their information to be presented to them:
00375|||Ronald |JONESE|521 E Grove St||Mishawaka|IN|12345|USA|LIVE-DVD|1|Asylum-DVD|1|FADE-DVD|1|LETHAL-DVD|1|LAND-DVD|1|
00376|||Patrick |JACKSON|230 Tazewell St. ||Norfolk|PA|23510|USA|FSPOV1-DVD|1|FSPOV3-DVD|1|
00377|||MIKE|JONES|300 Queen Anne Avenue North ST||Seattle|WA|98109|USA|FETISH2-DVD|1|FETISH3-DVD|1|FETISH4-DVD|1|FETISH5-DVD|1|
00378|||Khim |jones|P.O. BOX 9999 DANGAR||Newcastle||5555|AUSTRALIA|FETISH1-DVD|1|
The information for the titles of our videos is coded so for every title of our movie, there is a code associated with it. This code is what needs to go in the field after the country.
So for example, if a customer orders "Fetish video volume 4" this would be coded similar to "FETISHVOL4-DVD". The title of the product would be in the email and it would need to be converted to the code we supply.
THE PROGRAM MUST USE THE "PIPE" characters to separate the fields of data.
This information can be put into a text editor program as basic as Notepad or in Excel or other program more suited for this type of information.
Rate is negotiable.
You can live anywhere in the world. We can pay via Wire, Paypal or other means.
Thank you.
Here is an example of the data coming in from an email transaction receipt:
MERCHANT: BSB International, Inc.
Customer Billing Information
Name: John Doe
Address: 99999 Wilshire Dr
City: Ashford
State: TN
Zip Code: 22222
Country: USA
E-mail: AAAAAA@AAAAA.COM
Customer Shipping Information
Name: <unspecified> <unspecified>
Address: <unspecified>
City: <unspecified>
State: <unspecified>
Zip Code: <unspecified>
Country: <unspecified>
*************************************
Billing Information
Type of Card: VISA
Card Number: xxxxxxxxxxxx
Exp Date: 1010
Amount: $22.22
Trans Date: Wed 2006-Nov-15 09:05:39 PST
Trans Code: AUTH/TKT 111111
Items or Services Purchased
-------------------------------------------------------------
FETISH VIDEO 1! - DVD, FETISH FANTASIES ¿ VOLUME 2 - DVD, Diary of a FETISH- DVD, FETISH FANTASIES ¿ VOLUME 3 - DVD,
Miscellaneous Information
-------------------------------------------------------------
Product: FETISH SAMPLE 1! - DVD Quantity: 1 Size: Options: ; Product: FETISH FANTASIES ¿ VOLUME 2 - DVD Quantity: 1 Size: Options: ; Product: Diary of a FETISH- DVD Quantity: 1 Size: Options: ; Product: FETISH FANTASIES ¿ VOLUME 3 - DVD Quantity: 1 Size: Options: ;
<unspecified>
If the customer does not enter a shipping address then the script should use the billing address as the address to use in the data file.
In addition, we would be adding new videos to the list / script every month and would need to script to allow for additional entries on a regular basis.
Projekt-ID: #108004
Über das Projekt
Vergeben an:
5 Freelancer bieten im Durchschnitt $146 für diesen Job
i can do your project, have made an similar job. Please, send me some email and i create sample for you. thanks