Read CSV file and update orders in eCommerce App - VBScript
Featured
Read CSV file and update orders in eCommerce App - VBScript is project number 260434 posted at GetAFreelancer.com. Click here to post your own project.
Closed
(Selected Service Provider gvyshnya)
| Status: |
Closed
|
| Budget: |
N/A
|
| Created: |
05/10/2008 at 16:01 EDT |
| Bidding Ends: |
05/12/2008 at 16:01 EDT
|
| Project Creator: |
Scarabmedia
Buyer Rating:           (1 reviews)
|
| Description: |
Need done his weekend!
I am receiving a csv file via FTP into my site. I need to read the data and post Fedex tracking numbers to each item in a given order.
Sample data (I've added headers only to show what each column is).
"Order Number","Ship Date","Carrier Code","Carrier Description","Product Code","Product Description","Carton Number","Tracking Number" "3151002","05/02/2008","200","FedEx Ground","0085788","Type A Hotel Kit","1","091469171862558" "3385002","05/02/2008","200","FedEx Ground","0085788","Type A Hotel Kit","1","091469171862428" "3391002","05/02/2008","200","FedEx Ground","0085788","Type A Hotel Kit","1","091469171862435" "1029002","05/05/2008","200","FedEx Ground","0085788","Type A Hotel Kit","1","091469171864996"
I only need to write three items to the table. Carrier Description, Ship Date and Tracking number.
The file will be uploaded daily and this will need to be automated. Suggestions for doing so are appraciated. Currently we run a task on the Win Server to open an ASP page that processes orders and generates a flat file we FTP to the fullfilment company. This project entails reading the file they return and updating our orders.
I own a shopping cart application and my programmer has left for other business. I am looking for an efficient, fast and dedicated programmer who can help me with similar projects and clean-up in my ASP powered cart. Let's do this project and see where it goes.
My current programmer (previous employee, contracting back to me) has too much on his plate and cannot respond to my requests for days. This is exceptionaly urgent as the client has been waiting.
|
| Job Type: |
|
| Database: |
MS Access
|
| Operating system: |
MS Windows
|
| Bid count: |
2
|
| Average bid: |
$ 455
|
|

|