Basic script needed for transferring data from email into customized format for mailing

Fertiggestellt Veröffentlicht Nov 17, 2006 Bezahlt bei Lieferung
Fertiggestellt 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.

C Programmierung Datenverarbeitung JavaScript Script Install

Projekt-ID: #108004

Über das Projekt

5 Vorschläge Remote Projekt Aktiv Nov 17, 2006

Vergeben an:

Ellemer

Hi, I can write that script.

$100 USD in 1 Tag
(2 Bewertungen)
2.8

5 Freelancer bieten im Durchschnitt $146 für diesen Job

afonsobds

i can do your project, have made an similar job. Please, send me some email and i create sample for you. thanks

$100 USD in 4 Tagen
(1 Bewertung)
2.7
betty1

please see PM for details

$300 USD in 1 Tag
(0 Bewertungen)
0.0
sonuagrawal

My bid is $100.

$100 USD in 1 Tag
(0 Bewertungen)
0.0