I would like input on the best way to go about the following.

The scenario is this:

An estate agent needs to update property details on a database. The estate 

agent may have more than one office and each office must upload any 

changes to a single web site. The changes uploaded by one office should 

also be downloaded by the other office/s and, for the time being each 

office will only update their own details.



This project has to be done on a tight budget. The office side of things 

is a VB front end to an Access db. The web server is remote, running NT4 

supporting ODBC/Access and is accessed via dial-up from each office. There 

is no provision on the server for using the replication manager or any 

other programs running server side.



My idea is this:



After making changes to the db in the office the user clicks a button to 

upload these changes to the web site.



1. The application outputs a CSV file containing any changes.

2. The app connects to the net and ftp's the file along with any 

associated pictures to the web server.

3. Whilst connected the app will check for CSV files from other offices 

and download these if they exist.

4. The app disconnects from the net.

5. If files were downloaded they are then imported into the existing db.



The problem I have is finding the best way of importing the CSV to the db 

at the web server.

I know I could have an ASP page do this but that relies on somebody 

actually visiting the page.

Perhaps I could open the page from the application after the ftp upload?



Am I going about this the right way or does anybody have any better ideas 

or even better -> examples?

I would appreciate any good snippets for CSV import and export :¬)

Hi Mark,

   We too upload files in this way. The ftp application is written in VB and

it calls an asp file  at the end  that will split the uploaded file and

transfer its contents into the database.

1. The asp file must be opened in an window with no

toolbars,statusbar,addressbar,etc..

2. The asp file must  have commit and rollback instructions.

3. The window would be closed on 'onload' event



With Regards,

R. Sathish Kumar

sathish297@y...





----- Original Message -----

From: "Mark Hardy" <mark@f...>

To: "Access ASP" <access_asp@p...>

Sent: Friday, January 25, 2002 12:01 AM

Subject: [access_asp] Remote db Sync





> I would like input on the best way to go about the following.

> The scenario is this:

> An estate agent needs to update property details on a database. The estate

> agent may have more than one office and each office must upload any

> changes to a single web site. The changes uploaded by one office should

> also be downloaded by the other office/s and, for the time being each

> office will only update their own details.

>

> This project has to be done on a tight budget. The office side of things

> is a VB front end to an Access db. The web server is remote, running NT4

> supporting ODBC/Access and is accessed via dial-up from each office. There

> is no provision on the server for using the replication manager or any

> other programs running server side.

>

> My idea is this:

>

> After making changes to the db in the office the user clicks a button to

> upload these changes to the web site.

>

> 1. The application outputs a CSV file containing any changes.

> 2. The app connects to the net and ftp's the file along with any

> associated pictures to the web server.

> 3. Whilst connected the app will check for CSV files from other offices

> and download these if they exist.

> 4. The app disconnects from the net.

> 5. If files were downloaded they are then imported into the existing db.

>

> The problem I have is finding the best way of importing the CSV to the db

> at the web server.

> I know I could have an ASP page do this but that relies on somebody

> actually visiting the page.

> Perhaps I could open the page from the application after the ftp upload?

>

> Am I going about this the right way or does anybody have any better ideas

> or even better -> examples?

> I would appreciate any good snippets for CSV import and export :¬)




$subst('Email.Unsub').







_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com

Thanks for your reply.

Would you be able to let me see and example of the asp page? It could save 

me a lot of time. I haven't had to export and import to csv before so it 

would be a great help.



Regards,

Mark.







> Hi Mark,

>    We too upload files in this way. The ftp application is written in VB 

and

> it calls an asp file  at the end  that will split the uploaded file and

> transfer its contents into the database.

> 1. The asp file must be opened in an window with no

> toolbars,statusbar,addressbar,etc..

> 2. The asp file must  have commit and rollback instructions.

> 3. The window would be closed on 'onload' event

> 

> With Regards,

> R. Sathish Kumar

> sathish297@y...