Web Development

Ask something
Discussion Locked

autodownload into SQL server for website

0 helpful
5 replies

by ajd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to set up a website that gets its data from a SQL server database. The SQL server needs to have its data updated automatically every 24hrs from a CSV file available from a financial website.
How do I go about:
1. Setting up the website to automatically download this CSV file at predefined times.
2. Getting the SQL databse to import the newly downloaded CSV file after the download is complete?
Thanks.

5 replies

by me

Hi,

I assume you use MS IIS and ASP as your scripting language.

>>1. Setting up the website to automatically
>>download this CSV file at predefinedtimes.

For Question 1, you can use Softwing's ASPtear 1.0, to grab the CSV file from the financial website. It is free.

Refer http://www.alphasierrapapa.com/iisdev/components/asptear/

It support both http & https. More documentation on the url above.

There is an article on Grabbing Information from other Servers @ http://www.4guysfromrolla.com/webtech/071199-1.shtml

To automate its execution you could run at command from your NT shell.

>> 2. Getting the SQL databse to import the
>> newly downloaded CSV file after the
>>download is complete?

I assume you know how to write Stored Procedure in MS SQL. You can write and schedule the SP to read the downloaded or latest CSV file and to run at predefined interval.

Hope it may help.

Cheers,
Goboxe

You could use Softwing's ASPtear 1.0.It is free.

Refer http://www.alphasierrapapa.com/iisdev/components/asptear/

It support both http & https. More documentation on the url above.

There is an article on Grabbing Information from other Servers @ http://www.4guysfromrolla.com/webtech/071199-1.shtml

Good luck.

Cheers,
Goboxe

by andrew

If you don't want to use a 3rd party tool, you can write a simle download component using the Microsoft Internet Transfer Control which ships with VB. I did it with about 20 lines of code. Email me if you'd like me to send it to you.

You may alsowant to wrap your update stored procedure in a small VB application (why not the same one that performs the download?). Opening a disk file and parsing it from within a stored proc is no fun.

This discussion is closed to new replies.