Submit form NEW client info & Client updates.

[GemstoneTalent]

We are experimenting with an online form in FP2000 that sends results via
email - comma delimited text file. Works great...BUT

For initial clients with no records, this is OK, but for existing clients,
it would be wonderful to populate the form with existing data that they
could update and submit.

We plan on having a routine to compare the emailed data to the existing
data on our local machine, update changed fields. Then, periodically
(nightly?) copy the local data to a server database [ACCESS2000] to update
the client record "copy". Does this sound OK?

My hunch is the form will require changed to ASP(?) [or a separate form for
updates of existing clients] and a Table with the required fields will need
to be on the web server.

What "flavor" forms do I need?
How do I get the data to populate the form?
Can I email the updated records to myself from this setup?

I am certain there are other methods - we are wide open to suggestions.

TIA - Rick



Gemstone Talent
www.GemTal.com

 

[Thomas A. Rowe]

You would need to use ASP/VBScript with a login function so the user could access their record, then
update it back to the database, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[GemstoneTalent]

I was trying to avoid writing back to the database, probably because I
don't understand how to compare the data, make the updates and replicate to
our local database. It seemed easier to email the revised file and do the
comparision/update locally, then copy the table back to the internet once a
day.

The emails would also provide a back up of the changes any client made and
when they made them. The DATABASE will have fields to record changes made
with date and time.

We track about 150 various skills, plus Height & Weight stats that change
frequently for the babies and toddlers, but rarely for adults. The
administrative ca-ca is growing, but could be almost eliminated with a good
scheduling/tracking system.

We are still in the design phase of the tables, so we have utmost
flexibility. This is the due diligence where I'm trying to determine the
optimum way to set up before getting started building. I will try to do as
much as possible myself and will bring someone on to help as required. We
are trying to keep costs down on this initial version. Is it a huge deal to
reconstruct for a web based program vs local? (just realized this may be
the wrong group)

You would need to use ASP/VBScript with a login function so the user could access their record, then
update it back to the database, etc.

We are experimenting with an online form in FP2000 that sends results via
email - comma delimited text file. Works great...BUT

For initial clients with no records, this is OK, but for existing clients,
it would be wonderful to populate the form with existing data that they
could update and submit.

We plan on having a routine to compare the emailed data to the existing
data on our local machine, update changed fields. Then, periodically
(nightly?) copy the local data to a server database [ACCESS2000] to update
the client record "copy". Does this sound OK?

My hunch is the form will require changed to ASP(?) [or a separate form for
updates of existing clients] and a Table with the required fields will need
to be on the web server.

What "flavor" forms do I need?
How do I get the data to populate the form?
Can I email the updated records to myself from this setup?

I am certain there are other methods - we are wide open to suggestions.

TIA - Rick



Gemstone Talent
www.GemTal.com

Gemstone Talent
www.GemTal.com

 

[Thomas A. Rowe]

When the content is written back to the database it would replace the current content with whatever
changes the user has made or was allowed to make. This would allow real-time 24x7365 updating by the
users, and if they make a mistake, they could just login again and correct it.

You could still send an email if you wish.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

I was trying to avoid writing back to the database, probably because I
don't understand how to compare the data, make the updates and replicate to
our local database. It seemed easier to email the revised file and do the
comparision/update locally, then copy the table back to the internet once a
day.

The emails would also provide a back up of the changes any client made and
when they made them. The DATABASE will have fields to record changes made
with date and time.

We track about 150 various skills, plus Height & Weight stats that change
frequently for the babies and toddlers, but rarely for adults. The
administrative ca-ca is growing, but could be almost eliminated with a good
scheduling/tracking system.

We are still in the design phase of the tables, so we have utmost
flexibility. This is the due diligence where I'm trying to determine the
optimum way to set up before getting started building. I will try to do as
much as possible myself and will bring someone on to help as required. We
are trying to keep costs down on this initial version. Is it a huge deal to
reconstruct for a web based program vs local? (just realized this may be
the wrong group)

You would need to use ASP/VBScript with a login function so the user could access their record, then
update it back to the database, etc.

We are experimenting with an online form in FP2000 that sends results via
email - comma delimited text file. Works great...BUT

For initial clients with no records, this is OK, but for existing clients,
it would be wonderful to populate the form with existing data that they
could update and submit.

We plan on having a routine to compare the emailed data to the existing
data on our local machine, update changed fields. Then, periodically
(nightly?) copy the local data to a server database [ACCESS2000] to update
the client record "copy". Does this sound OK?

My hunch is the form will require changed to ASP(?) [or a separate form for
updates of existing clients] and a Table with the required fields will need
to be on the web server.

What "flavor" forms do I need?
How do I get the data to populate the form?
Can I email the updated records to myself from this setup?

I am certain there are other methods - we are wide open to suggestions.

TIA - Rick



Gemstone Talent
www.GemTal.com

Gemstone Talent
www.GemTal.com

 

[Thomas A. Rowe]

This is not going to be an easy project, but can be accomplish via FP and ASP or ASP.net custom
(hand) coding.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

I was trying to avoid writing back to the database, probably because I
don't understand how to compare the data, make the updates and replicate to
our local database. It seemed easier to email the revised file and do the
comparision/update locally, then copy the table back to the internet once a
day.

The emails would also provide a back up of the changes any client made and
when they made them. The DATABASE will have fields to record changes made
with date and time.

We track about 150 various skills, plus Height & Weight stats that change
frequently for the babies and toddlers, but rarely for adults. The
administrative ca-ca is growing, but could be almost eliminated with a good
scheduling/tracking system.

We are still in the design phase of the tables, so we have utmost
flexibility. This is the due diligence where I'm trying to determine the
optimum way to set up before getting started building. I will try to do as
much as possible myself and will bring someone on to help as required. We
are trying to keep costs down on this initial version. Is it a huge deal to
reconstruct for a web based program vs local? (just realized this may be
the wrong group)

You would need to use ASP/VBScript with a login function so the user could access their record, then
update it back to the database, etc.

We are experimenting with an online form in FP2000 that sends results via
email - comma delimited text file. Works great...BUT

For initial clients with no records, this is OK, but for existing clients,
it would be wonderful to populate the form with existing data that they
could update and submit.

We plan on having a routine to compare the emailed data to the existing
data on our local machine, update changed fields. Then, periodically
(nightly?) copy the local data to a server database [ACCESS2000] to update
the client record "copy". Does this sound OK?

My hunch is the form will require changed to ASP(?) [or a separate form for
updates of existing clients] and a Table with the required fields will need
to be on the web server.

What "flavor" forms do I need?
How do I get the data to populate the form?
Can I email the updated records to myself from this setup?

I am certain there are other methods - we are wide open to suggestions.

TIA - Rick



Gemstone Talent
www.GemTal.com

Gemstone Talent
www.GemTal.com

 

[GemstoneTalent]

Rats. I thought this was headed in that direction.

If I go ahead and leave the client info databases on line, would
replication be the method to update our local records?

It would be convenient to have all of our current data online for easy
access (no pun intended) while on the road.

One thing that might (or might not) hold influence, is an XML feed we plan
to use to populate Project Information directly from an online source. I
would not think it matters whether it's to our local HD or a web server.
Mapping the file would hopefully be similar, but I digress to another group
again...

TIA

This is not going to be an easy project, but can be accomplish via FP and ASP or ASP.net custom
(hand) coding.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

I was trying to avoid writing back to the database, probably because I
don't understand how to compare the data, make the updates and replicate to
our local database. It seemed easier to email the revised file and do the
comparision/update locally, then copy the table back to the internet once a
day.

The emails would also provide a back up of the changes any client made and
when they made them. The DATABASE will have fields to record changes made
with date and time.

We track about 150 various skills, plus Height & Weight stats that change
frequently for the babies and toddlers, but rarely for adults. The
administrative ca-ca is growing, but could be almost eliminated with a good
scheduling/tracking system.

We are still in the design phase of the tables, so we have utmost
flexibility. This is the due diligence where I'm trying to determine the
optimum way to set up before getting started building. I will try to do as
much as possible myself and will bring someone on to help as required. We
are trying to keep costs down on this initial version. Is it a huge deal to
reconstruct for a web based program vs local? (just realized this may be
the wrong group)

You would need to use ASP/VBScript with a login function so the user could access their record, then
update it back to the database, etc.

We are experimenting with an online form in FP2000 that sends results via
email - comma delimited text file. Works great...BUT

For initial clients with no records, this is OK, but for existing clients,
it would be wonderful to populate the form with existing data that they
could update and submit.

We plan on having a routine to compare the emailed data to the existing
data on our local machine, update changed fields. Then, periodically
(nightly?) copy the local data to a server database [ACCESS2000] to update
the client record "copy". Does this sound OK?

My hunch is the form will require changed to ASP(?) [or a separate form for
updates of existing clients] and a Table with the required fields will need
to be on the web server.

What "flavor" forms do I need?
How do I get the data to populate the form?
Can I email the updated records to myself from this setup?

I am certain there are other methods - we are wide open to suggestions.

TIA - Rick



Gemstone Talent
www.GemTal.com

Gemstone Talent
www.GemTal.com

Gemstone Talent
www.GemTal.com

 

[Thomas A. Rowe]

It all depends on what checks and balance you want to implement. Basically with the users updating
the live site, once a day you could download the database, you would never want to upload the
database to the server.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Rats. I thought this was headed in that direction.

If I go ahead and leave the client info databases on line, would
replication be the method to update our local records?

It would be convenient to have all of our current data online for easy
access (no pun intended) while on the road.

One thing that might (or might not) hold influence, is an XML feed we plan
to use to populate Project Information directly from an online source. I
would not think it matters whether it's to our local HD or a web server.
Mapping the file would hopefully be similar, but I digress to another group
again...

TIA

This is not going to be an easy project, but can be accomplish via FP and ASP or ASP.net custom
(hand) coding.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

I was trying to avoid writing back to the database, probably because I
don't understand how to compare the data, make the updates and replicate to
our local database. It seemed easier to email the revised file and do the
comparision/update locally, then copy the table back to the internet once a
day.

The emails would also provide a back up of the changes any client made and
when they made them. The DATABASE will have fields to record changes made
with date and time.

We track about 150 various skills, plus Height & Weight stats that change
frequently for the babies and toddlers, but rarely for adults. The
administrative ca-ca is growing, but could be almost eliminated with a good
scheduling/tracking system.

We are still in the design phase of the tables, so we have utmost
flexibility. This is the due diligence where I'm trying to determine the
optimum way to set up before getting started building. I will try to do as
much as possible myself and will bring someone on to help as required. We
are trying to keep costs down on this initial version. Is it a huge deal to
reconstruct for a web based program vs local? (just realized this may be
the wrong group)

You would need to use ASP/VBScript with a login function so the user could access their

record,
then

update it back to the database, etc.

We are experimenting with an online form in FP2000 that sends results via
email - comma delimited text file. Works great...BUT

For initial clients with no records, this is OK, but for existing clients,
it would be wonderful to populate the form with existing data that they
could update and submit.

We plan on having a routine to compare the emailed data to the existing
data on our local machine, update changed fields. Then, periodically
(nightly?) copy the local data to a server database [ACCESS2000] to update
the client record "copy". Does this sound OK?

My hunch is the form will require changed to ASP(?) [or a separate form for
updates of existing clients] and a Table with the required fields will need
to be on the web server.

What "flavor" forms do I need?
How do I get the data to populate the form?
Can I email the updated records to myself from this setup?

I am certain there are other methods - we are wide open to suggestions.

TIA - Rick



Gemstone Talent
www.GemTal.com



Gemstone Talent
www.GemTal.com

Gemstone Talent
www.GemTal.com

 

[GemstoneTalent]

What if we made changes locally? Would they be overwritten?

It all depends on what checks and balance you want to implement. Basically with the users updating
the live site, once a day you could download the database, you would never want to upload the
database to the server.

Gemstone Talent
www.GemTal.com

 

[Thomas A. Rowe]

Yes, if you download the database from the web. However custom code can be written to export the
data from the "live" database in .csv file format, that you could then import into a local copy.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================