Access website1 from website2

Question

1.00/5 (2 votes)

See more:

Hi all,

Today my manager gave a task that I am finding lil complicated.
The project goes like this :

We have an internal website that was developed by someone else from outside.
This website does : 1) Login 2) Query Data
The problem that users are facing is like they have to process more than 1000 of results by that query, which takes a lot of time.

The problem with the website 1 is that it is not user friendly.
The user fetch thousand of account in grid (*Paging is not an issue*), then they have to click on each fetched account and note the transaction of each account in excel. They have to do this for all more than 1000 accounts.Even I don't have access to database of the website 1 otherwise I could have create an application that connects to the database of website 1.

So I have to develop a Website 2 that will auto do all this task from Website 1 and give this final result in excel.

Now i have to develop a website that can :

1) Automatically login to the existing website depending on the windows logon credentials.
2) Query data between given dates.
3) Process each data And extract the data in excel.

Thanks in Advance..!!

Regards,
Pratik

Posted 15-Aug-13 20:23pm

xxxMI

Updated 18-Aug-13 1:19am

v2

Add a Solution

Comments

walterhevedeich 16-Aug-13 2:31am

Is website2 also internal?, Why can't you just create an application that connects to the database of website1.

xxxMI 18-Aug-13 6:03am

Yes, the website 2 is also an internal website. But the problem is that I dont have access to database of the website 1.

Maarten Kools 16-Aug-13 3:55am

Why create a whole new site? As I read it, you'll have to extend the existing project. So you'll need to build in AD authentication and extend the query page with date controls and process the input.

xxxMI 18-Aug-13 7:13am

I want to automate the website 1. The problem with the website 1 is that it is not user friendly. The user fetch thousand of account in grid, then they have to click on each fetched account and note the transaction of each account in excel. They have to do this for all more than 1000 accounts.Even I don't have access to database of the website 1 otherwise I could have create an application that connects to the database of website 1.

So I have to develop a Website 2 that will auto do all this task from Website 1 and give this final result in excel.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 16-Aug-13 4:13am

So, what is the problem you are facing currently?

xxxMI 18-Aug-13 7:12am

I want to automate the website 1. The problem with the website 1 is that it is not user friendly. The user fetch thousand of account in grid, then they have to click on each fetched account and note the transaction of each account in excel. They have to do this for all more than 1000 accounts.Even I don't have access to database of the website 1 otherwise I could have create an application that connects to the database of website 1.

So I have to develop a Website 2 that will auto do all this task from Website 1 and give this final result in excel.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 18-Aug-13 11:40am

Look, if you can't connect to Database, then check whether they have some Web Service/WCF Services so that you can call the function present in that Service to get all the Account info and show that in the new site.

If you don't have the Service, then ask for the Database credentials and connect to that directly.

Otherwise, just try to optimize the original site's source code to make it user-friendly.

The problem is you are trying to get the data from other website without connecting to it. It can't be possible unless you have some authentic credentials to connect and get the data.

Hope you get what all I said. So, reply me with your views. :)

Thanks7872 16-Aug-13 5:21am

I think you,your self not clear about what has been assigned.
Query data between given dates. You just need to change your page(you said ' Query Data page').
Process each data And extract the data in excel.Again the same thing in query data page. Whats the problem?

May i know what you expect from us?

xxxMI 18-Aug-13 7:11am

I want to automate the website 1. The problem with the website 1 is that it is not user friendly. The user fetch thousand of account in grid, then they have to click on each fetched account and note the transaction of each account in excel. They have to do this for all more than 1000 accounts.Even I don't have access to database of the website 1 otherwise I could have create an application that connects to the database of website 1.

So I have to develop a Website 2 that will auto do all this task from Website 1 and give this final result in excel.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeBlack · Answer 1 · 2013-08-15T23:23:00

I agree with the ^Mo^'s suggestion.

If you have a code for the old website than you can extend that website.
But incase if you dont have a code for the old website than you will have to create new one.

And if you are supposed to create a new website than my advice is to put the paging in your control so that instead of fetching 1000 records fetch only top 50 or 100 records so it will reduce the load on your site. In short, provide grid with paging facility and load data dynamically.

And if user has some specific criteria than provide the serch functioanlity also. So that your page will not get havier.