S
skc
Hi,
I have made a custom web application using .asp and an
Access 2000 backend database. This application allows
users to enter reference numbers. Once reference numbers
are entered, a list is generated to be run on an external
database to get account information for the account
reference in question. By this I mean the account
holder's name, address, postcode etc...
Next, I have to import this back into the database so that
the database is enriched with more information. Staff
then work on the records, phoning customers to make sure
details are correct etc... If details are not correct,
then amendments are made on screen and saved to the
database along with the original record. This is to show
what the original record looked like and the revised
version - if there were any changes.
My problem at the moment is getting the whole thing going
for real as the setup is a test. I want to migrate to
SQL2000 and make this application run in a live
environment so that I can upload the enriched files on a
daily basis quickly and easily. Furthermore, it has been
discussed whether I can upload enriched data (maybe a .txt
file) onto the main database using a file upload facility -
is this possible?
At the moment, this is how my system works - which is
still at trial stage, so I would not mind any comments on
improvement:
1. Enter customer references. This gets posted into a
table with a timestamp, user's name (for tracking)
2. I then generate a list of two or more occurences of the
customer references. This part I am unsure about,
particularly when my list of two or more would have
different ID numbers from the records in my original table!
3. Once an external enrichment process has occurred, then
I import and overwrite the entire table (is this right?)
4. Staff can then search for and lookup the enriched data
by entering a customer reference. There is then a form
beside the original data, where they can post any
amendments.
5. Amendments are then created as a new record inthe
table, flagged as 'Amendment' and the original record
flagged as 'Original'.
6. A list can then be produced showing the Original Data
and Amendments on fields that have been amended.
Help will be appreciated.
Thanks.
SKC
I have made a custom web application using .asp and an
Access 2000 backend database. This application allows
users to enter reference numbers. Once reference numbers
are entered, a list is generated to be run on an external
database to get account information for the account
reference in question. By this I mean the account
holder's name, address, postcode etc...
Next, I have to import this back into the database so that
the database is enriched with more information. Staff
then work on the records, phoning customers to make sure
details are correct etc... If details are not correct,
then amendments are made on screen and saved to the
database along with the original record. This is to show
what the original record looked like and the revised
version - if there were any changes.
My problem at the moment is getting the whole thing going
for real as the setup is a test. I want to migrate to
SQL2000 and make this application run in a live
environment so that I can upload the enriched files on a
daily basis quickly and easily. Furthermore, it has been
discussed whether I can upload enriched data (maybe a .txt
file) onto the main database using a file upload facility -
is this possible?
At the moment, this is how my system works - which is
still at trial stage, so I would not mind any comments on
improvement:
1. Enter customer references. This gets posted into a
table with a timestamp, user's name (for tracking)
2. I then generate a list of two or more occurences of the
customer references. This part I am unsure about,
particularly when my list of two or more would have
different ID numbers from the records in my original table!
3. Once an external enrichment process has occurred, then
I import and overwrite the entire table (is this right?)
4. Staff can then search for and lookup the enriched data
by entering a customer reference. There is then a form
beside the original data, where they can post any
amendments.
5. Amendments are then created as a new record inthe
table, flagged as 'Amendment' and the original record
flagged as 'Original'.
6. A list can then be produced showing the Original Data
and Amendments on fields that have been amended.
Help will be appreciated.
Thanks.
SKC