web data retrieval help

[omper]

I am looking for some help. listed here is a description of what i am trying to do ..


1 using database access 2007.

2 based on specific fields in current database

3 goto specified web site and sign in.. once done select from drop down box on website a specific selection.. wait for new window to come up.. click a link.. wait for new window..

4 input data in web page from field in database

5 retrieve specific data from webpage after updat..

6 store that data into current database in specific fields..

.. IF you can help with this.. please email me or post here..

Thanks

[kcddoorman]

What is this for exactly cause I'm thinking you shouldn't do these types of things to peoples websites unless your name is google

[jaxjagfan]

I am looking for some help. listed here is a description of what i am trying to do ..


1 using database access 2007.

2 based on specific fields in current database

3 goto specified web site and sign in.. once done select from drop down box on website a specific selection.. wait for new window to come up.. click a link.. wait for new window..

4 input data in web page from field in database

5 retrieve specific data from webpage after updat..

6 store that data into current database in specific fields..

.. IF you can help with this.. please email me or post here..

Thanks

You will need assistance from the webmaster with this one. In order to write data to a webserver you will need at a minimum Read/Write Access. Most web apps today are written in .Net and are pretty secure. Data is normally gathered from a User form into an XML transaction to the web/app server and them wrote to a database server. There is NEVER an open connection between the end user and the database.

If you are exchanging data with an organization it is much better to use EDI (Electronic Data Interchange).

[omper]

First i do have read write priv. and no this is not being used for wrong doing.. i simply work for a company that already has login rights to get this information. just trying to eliminate some work and streamline..

tks

[jaxjagfan]

I am looking for some help. listed here is a description of what i am trying to do ..


1 using database access 2007.

2 based on specific fields in current database

3 goto specified web site and sign in.. once done select from drop down box on website a specific selection.. wait for new window to come up.. click a link.. wait for new window..

4 input data in web page from field in database

5 retrieve specific data from webpage after updat..

6 store that data into current database in specific fields..

.. IF you can help with this.. please email me or post here..

Thanks

The scenerio should be:
1. Extract your data and prep your upload file in the specified format (May include saving to a specific folder or drive and may include encryption). (Your step 1 and 2 is combined here)
2. Do your step 3
3. If it is single record entry, enter the info and press ok/accept, else your business partner should have the ability (and functionality) in the site to accept upload file.
4. If it was single entry, partner site will check validity of entry and return an accept/retry/fail. If multiple records, partner site will import upload file (in the specified format), check formatting, check data validity, parse and process data, and return a result dataset to the page with the ability to save/download results in a prespecified format.
5. If all was successful to this point you will have a download file to import in your database for processing and storage.

I have done a lot of projects for major corporate clients as a developer and business systems analyst. At a minumum, you and your business partner should be exchanging records via ftp or https. Some banks I have dealt with have software packages which will allow you to login and upload/download files. I work for an insurance company now and we are exchanging data with state and federal govt entities, insurance agents, customers, vendors, and other entities.