I want a Stand Alone application created in VB or some thing similar language that will do the followings:
1. securely pull data from an existing oscommerce database. The current database is hosted on web as local host and no remote connection is allowed. So need a solution that will be able to either pull data from remote site or generate report by logging on the net against oscommerce.
2. Create the following reports from the extracted data:
Total selling product by region, by month , by user
3. The VB application should give admin ability to choose a specific customer and export the demographic info along the product info to a csv file (locally)
4. Also the VB program should have some interface on the PC (Stand alone) that will allow manually enter a sale transaction to the same database it is extracting data from the oscommerce.
So Basically keep a similar structured database on Host and replicate the transaction automatically from net to localhost, generate report and ability to add data from local machine to the same database.