473,666 Members | 2,039 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

cataloging MS Word Docs with ASP.NET and SQL

MDB
Once again, just looking to see if my thinking is off base (there's that
naivete again) or if there's a better approach. The requirement is for users
to create MS Word documents that will eventually find their way into a
central directory on the server. Once they're in that place, I'm looking for
a way to 'catalog' them, in effect, extracting information from data fields
in each document, as well as the document's location as a URL, to store in a
SQL database, and then, of course, use an ASP.NET application for other end
users to view the documents in their browser. Please note that the need is
NOT to store the entire document in the SQL db, just data from fields that
would be on the template that all the Word documents would be created from.
However, access those fields from an ASP.NET application appears to involve
invoking the Word object over and over again, and tests have been wholly
unsatisfactory. I've considered a VBScript, but would not have a central
location to place the macro, and so haven't even tested that approach. The
information I would need to store about each document include various
categories concerning the document's contents, so it isn't just a matter of
reading the directory and scooping up document names. Is there any other
approach that I could possibly consider?

MDBloemker
md********@hotm ail.com
Nov 18 '05 #1
2 1050
I suggest you look into using this product:
http://officewriter.softartisans.com...ewriter-8.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"MDB" <md*@hotmail.co m> wrote in message
news:wI******** ************@te lcove.net...
Once again, just looking to see if my thinking is off base (there's that
naivete again) or if there's a better approach. The requirement is for users to create MS Word documents that will eventually find their way into a
central directory on the server. Once they're in that place, I'm looking for a way to 'catalog' them, in effect, extracting information from data fields in each document, as well as the document's location as a URL, to store in a SQL database, and then, of course, use an ASP.NET application for other end users to view the documents in their browser. Please note that the need is
NOT to store the entire document in the SQL db, just data from fields that
would be on the template that all the Word documents would be created from. However, access those fields from an ASP.NET application appears to involve invoking the Word object over and over again, and tests have been wholly
unsatisfactory. I've considered a VBScript, but would not have a central
location to place the macro, and so haven't even tested that approach. The
information I would need to store about each document include various
categories concerning the document's contents, so it isn't just a matter of reading the directory and scooping up document names. Is there any other
approach that I could possibly consider?

MDBloemker
md********@hotm ail.com

Nov 18 '05 #2
Check out this KB article:

http://support.microsoft.com/?kbid=224351

-Jason

MDB wrote:
Once again, just looking to see if my thinking is off base (there's that
naivete again) or if there's a better approach. The requirement is for users
to create MS Word documents that will eventually find their way into a
central directory on the server. Once they're in that place, I'm looking for
a way to 'catalog' them, in effect, extracting information from data fields
in each document, as well as the document's location as a URL, to store in a
SQL database, and then, of course, use an ASP.NET application for other end
users to view the documents in their browser. Please note that the need is
NOT to store the entire document in the SQL db, just data from fields that
would be on the template that all the Word documents would be created from.
However, access those fields from an ASP.NET application appears to involve
invoking the Word object over and over again, and tests have been wholly
unsatisfactory. I've considered a VBScript, but would not have a central
location to place the macro, and so haven't even tested that approach. The
information I would need to store about each document include various
categories concerning the document's contents, so it isn't just a matter of
reading the directory and scooping up document names. Is there any other
approach that I could possibly consider?

MDBloemker
md********@hotm ail.com

Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
359
by: sudha | last post by:
Hi I need to write a c# program which has to merge selected word documents into one word document. Kindly advise the efficient way to achieve this. Thanks in advance sudha
2
2274
by: Jagdip Singh | last post by:
Hi all, I uninstalled db2 without dropping old instance. I have one database which i want to access again through new db2 i installed. I opted for fresh db2 directory while installing instead keeping old directory. I created new instance during installation of db2 which is different from old one. I tried catalog database for old database from new instance but did not able to access database
41
6088
by: Ruby Tuesday | last post by:
Hi, I was wondering if expert can give me some lite to convert my word table into access database. Note: within each cell of my word table(s), some has multi-line data in it. In addition, there is one row containing picture(s) as well. So far, what I did is doing it manually for each word docs I have. Select Table Convert Table to Text(I use ^ character for delimiter)
10
3042
by: Neil | last post by:
An article at http://news.com.com/2100-1012-991694.html?tag=fd_top states: "XML would allow easier interchange of data generated in Office documents with back-end systems or existing Web services." As part of an Access 2000 application, I have to continually parse Word documents and store the parsings in Access tables using Automation to control Word and parse the document. Is there a way that XML would help with that? Thanks.
1
615
by: ajk | last post by:
. Hi, All: I know how to insert files into a Word doc using C#. However, the program I've written to do this runs much too slowly. The "myObj".Application.Selection.InsertFile method executes at a snails pace. Here are the detais: I wrote a C# program that creates a new Word doc and then loops through a
3
1099
by: gabe | last post by:
I have a directory of word docs (maybe 2 or 3 hundred), all of the docs are based on a custom template and they have 20 or so fields, I would like to read all of the fields into a db. Any help would be appreciated. gabe
6
4621
by: Eric Layman | last post by:
Hi, I have fields from textareas. With a click of a button, php is able to grab these fields and by using header(), convert the output to Ms Word doc. But the outcome of the word doc doesn't wrap the text in textarea. the result is one very veyr long string of text which stretch MS word all
1
2931
by: webgirl | last post by:
Hi everyone, I have a weird problem with some Word/Excel automation code that I run from Access (not sure if I should therefore post this in the Access forum..? Thought I'd try here first) Basically, the code either opens a document (if it exists) or creates it from a template if it doesn't. Docs can be Word or Excel docs. The weird part is that the code was working earlier tonight. But now it's not, not properly, anyway. Now, what...
2
2628
by: KYG | last post by:
Hi , I'm trying to design and build a web app (my first C++ app) using the WT C++ web toolkit. Been looking for a way to read an MS Word doc into a 'stream?' and manipulate (search, copy/ delete paragraphs, format etc) its contents from my c++ program. lastly, is there a free c++ library or a way to convert MS Word docs to PDF using C++
0
8448
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8783
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8552
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8640
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7387
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6198
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4198
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2773
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.