G
G Dahler
Hello,
Sorry if I'm posting to the wrong newsgroup: I really don't know where to
post this question !
We need to be able to generate a word document, from a template, and fill in
some "blanks" using data coming from an oracle database. We need the
solution to be as simple as possible. Scalability is NOT an issue here, we
will have a very small number of users.
The generation could occur from a web page, or from a fat client, we don't
care. We have a native oracle client installed as well as ODBC drivers to
oracle.
Of course, the best solution would be a web page.
Here is an example of what we need.
a) The end user has to input some id (Ex: client id) (In a text box in a
word document or on a web page)
b) After the "id" is filled, the macro/program/application has to fetch some
data from an oracle database and fill in some fields in a word document.
For example, the original document template could be:
Dear Mr _Z_,
Our records indicate that on _X_, you asked for information about our new
product _A_. We sent you an invoice #(_B_) for the amount of _C_
After inputing the customer id, our end user should end up with a word
document containing something like:
Dear Mr Smith,
Our records indicate thant on May 26th 2003, you asked for information about
our new product "Ultra carpet cleaner". We sent you an invoice #8121 for the
amount of 23.87$
What is the easiest/cheapest way to do it.
We are running office 2000 premium. We are NOT a microsoft shop, we run on
UNIX and Netware. If we could only use VB for application or jscript, that
would be fine. We simply don't know where to look at, which doc to read. We
may be hiring a consultant to do this, but we presume it is VERY easy to do
and don't want to end up with a costly solution.
We already have some sort of prototype using excel and word, but it's very
complicated and we cannot close the excel app after getting the data from
oracle. It was only an experiment and is way too complicated.
Thanks
Sorry if I'm posting to the wrong newsgroup: I really don't know where to
post this question !
We need to be able to generate a word document, from a template, and fill in
some "blanks" using data coming from an oracle database. We need the
solution to be as simple as possible. Scalability is NOT an issue here, we
will have a very small number of users.
The generation could occur from a web page, or from a fat client, we don't
care. We have a native oracle client installed as well as ODBC drivers to
oracle.
Of course, the best solution would be a web page.
Here is an example of what we need.
a) The end user has to input some id (Ex: client id) (In a text box in a
word document or on a web page)
b) After the "id" is filled, the macro/program/application has to fetch some
data from an oracle database and fill in some fields in a word document.
For example, the original document template could be:
Dear Mr _Z_,
Our records indicate that on _X_, you asked for information about our new
product _A_. We sent you an invoice #(_B_) for the amount of _C_
After inputing the customer id, our end user should end up with a word
document containing something like:
Dear Mr Smith,
Our records indicate thant on May 26th 2003, you asked for information about
our new product "Ultra carpet cleaner". We sent you an invoice #8121 for the
amount of 23.87$
What is the easiest/cheapest way to do it.
We are running office 2000 premium. We are NOT a microsoft shop, we run on
UNIX and Netware. If we could only use VB for application or jscript, that
would be fine. We simply don't know where to look at, which doc to read. We
may be hiring a consultant to do this, but we presume it is VERY easy to do
and don't want to end up with a costly solution.
We already have some sort of prototype using excel and word, but it's very
complicated and we cannot close the excel app after getting the data from
oracle. It was only an experiment and is way too complicated.
Thanks