Project Detail

Description

Overview: This project will provide a script that will obtain data from an Amazon Seller Account and post that information into a sheet of a spreadsheet on the company's Google Docs starting at the specified cell.

Calling method: Command line
input parameters: Amazon login ID (an email address)
Amazon password
Google login ID
Google password
Google doc spreadsheet filename
Google sheet name
Google cell
logfile

First web page (see attached sign-in.html): https://www.amazon.com/gp/sign-in.html?ie=UTF8&email=&disableCorpSignUp=&path=%2Fgp%2Fyourstore&redirectProtocol=&mode=&useRedirectOnSuccess=1&query=signIn%3D1%26action%3Dsign-out%26useRedirectOnSuccess%3D1%26ref%5F%3Dpd%5Firl%5Fgw%5Fr%26path%3D%2Fgp%2Fyourstore&pageAction=%2Fgp%2Fyourstore
"Your account" --> "Your seller account" --> "View your payments account"--> logon

Retrieve all payments to bank account.

Balance as of 02-Mar-2008: $153.25 Transfer funds now
The amount shown to the left will be automatically transferred on 11-Mar-2008

from all statements.

Place them in the specified Google doc's specified sheet starting at the specified cell.

Place the most recent date in the specified cell. In the next column place the associated amount. Place each additional date and amount beneath these cells in descending date order, creating a table of bank transfers.

Do not require the focus or keyboard if at all possible (no inkey).

Prefer WSH.

Source code required.

Some limited integration test with production account under controlled situations will be allowed.


Additional files submitted:
account_summary.htm