Go Back   nV News Forums > Software Forums > Software Development

Newegg Daily Deals

Reply
 
Thread Tools
Old 10-29-07, 10:18 PM   #1
MUYA
 
Join Date: Jul 2002
Location: Hong Kong
Posts: 6,794
Send a message via MSN to MUYA
Arrow Conversion of word files into XML and then extracting to an Oracle database

Hi guys,
For those who are experts please could you answer a few questions if you could kindly please.

For the company I work for, most of the stuff we needs to be documented into a pre-formated word file (bread and butter of our company). A check list of sorts. These word files contain tables with columns which are consistent through which ever clients we have. Each document can share a particular row or have a similar row.
My question is how hard/easy would it be to convert these table ladened word files into XML which can then be extracted into a database per each client?
The goal of this project is to get away from manual reference/generation of these documents and to control certain aspects of these documents, ie the rows so they are nearly all consistent between clients.
Is this easy for someone with the know how? Or inherently hard? Or is there another way.
Any thoughts welcome!
__________________
I5-2500k@4.7GHz - MSI Z77A-GD65 - 4GB X2 A-DATA DDR3 1600 - Corsair H100 - Antec Quatro 850W
Gigabyte Windforce X3 GTX 680 OC - Dell 24" IPS
Intel 320 300 GB SSD - 1 TB Hitachi HDD - 2x 250 GB WD HDD
Corsair K90 - Corsair Venegance 2000 Headset - Razer Naga Epic
Corsair 600T Case
MUYA is offline   Reply With Quote
Old 10-31-07, 08:47 PM   #2
MUYA
 
Join Date: Jul 2002
Location: Hong Kong
Posts: 6,794
Send a message via MSN to MUYA
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Anyone please?
__________________
I5-2500k@4.7GHz - MSI Z77A-GD65 - 4GB X2 A-DATA DDR3 1600 - Corsair H100 - Antec Quatro 850W
Gigabyte Windforce X3 GTX 680 OC - Dell 24" IPS
Intel 320 300 GB SSD - 1 TB Hitachi HDD - 2x 250 GB WD HDD
Corsair K90 - Corsair Venegance 2000 Headset - Razer Naga Epic
Corsair 600T Case
MUYA is offline   Reply With Quote
Old 11-01-07, 12:20 AM   #3
ephmrl
Registered User
 
Join Date: Dec 2006
Posts: 81
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Quote:
Originally Posted by MUYA
Anyone please?
If you want to buy software that already does it, here's what google turned up:

http://rustemsoft.com/ (XML converter 6.00)
http://www.cambridgedocs.com/product...ds/xDocPro.htm
http://www.xml.com/pub/a/2003/12/31/qa.html (old discussion on conversion methods)

Never used any of these, so buyer beware. From the looks of it though, it shouldn't be too bad to code something up if your needs are simple, and you are willing to dive into and debug parsing word docs (didn't see a real spec in a quick search, so may require some trial and error).

Good luck .
ephmrl is offline   Reply With Quote
Old 11-01-07, 02:26 AM   #4
MUYA
 
Join Date: Jul 2002
Location: Hong Kong
Posts: 6,794
Send a message via MSN to MUYA
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Thanks bud, but is there another easier way? erm rater than covert straigh to XML, erm extract to the database maybe?
__________________
I5-2500k@4.7GHz - MSI Z77A-GD65 - 4GB X2 A-DATA DDR3 1600 - Corsair H100 - Antec Quatro 850W
Gigabyte Windforce X3 GTX 680 OC - Dell 24" IPS
Intel 320 300 GB SSD - 1 TB Hitachi HDD - 2x 250 GB WD HDD
Corsair K90 - Corsair Venegance 2000 Headset - Razer Naga Epic
Corsair 600T Case
MUYA is offline   Reply With Quote
Old 11-01-07, 11:32 AM   #5
Sycario
Registered User
 
Join Date: Nov 2006
Location: St. Louis, MO
Posts: 363
Send a message via AIM to Sycario
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Do you have an example of a word doc? I don't use word but I can see what I come up with.
__________________

Comp Specs:
Intel Q9650 @ 3.95Ghz
Asus Rampage Extreme
2x2GB Mushkin DDR3-1600 @ 6-6-6-17
eVGA GTX 280 SSC
BFG ES-800 PSU
Sycario is offline   Reply With Quote
Old 11-01-07, 09:23 PM   #6
ViN86
 
Join Date: Mar 2004
Posts: 15,486
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Quote:
Originally Posted by MUYA
Thanks bud, but is there another easier way? erm rater than covert straigh to XML, erm extract to the database maybe?
XML is probably your best bet for what you want to do.

i bet EG knows how to do it.

EDIT: this may help
http://www.oooforum.org/forum/viewtopic.phtml?t=7242

its openoffice, but might help you...
ViN86 is offline   Reply With Quote
Old 11-01-07, 10:07 PM   #7
MUYA
 
Join Date: Jul 2002
Location: Hong Kong
Posts: 6,794
Send a message via MSN to MUYA
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Thanks Vin,

But, we use MS office.

The thing is we are using a converter to convert word to XML. I am assuming ( I cannot confirm) that we are using MS office to convert the word files to XML files.

The problem is when we try to extract a column into the database, they all have the same amount of columns etc, nearly the same structure, only some are parsed, and not all. Even even those that are parsed into the database, there are some rows missing. When we check the Word and XML files we cannot find anything different!...I dunno what gives...

we are talking a lot of files we have to move into the database and we do not want to do it manually obviously....

...cheers for the insight anyway guys
__________________
I5-2500k@4.7GHz - MSI Z77A-GD65 - 4GB X2 A-DATA DDR3 1600 - Corsair H100 - Antec Quatro 850W
Gigabyte Windforce X3 GTX 680 OC - Dell 24" IPS
Intel 320 300 GB SSD - 1 TB Hitachi HDD - 2x 250 GB WD HDD
Corsair K90 - Corsair Venegance 2000 Headset - Razer Naga Epic
Corsair 600T Case
MUYA is offline   Reply With Quote
Old 11-01-07, 10:24 PM   #8
evilghost
Registered User
 
Join Date: Jul 2005
Posts: 3,606
Default Re: Conversion of word files into XML and then extracting to an Oracle database

I'd chime in but I've got very little experience with Office products and data transformation between them. If I knew how to help I would

Can you export to CSV?
evilghost is offline   Reply With Quote

Old 11-01-07, 10:53 PM   #9
jcrox
Mahna Mahna
 
jcrox's Avatar
 
Join Date: Jul 2006
Location: Madison, Wi
Posts: 6,134
Default Re: Conversion of word files into XML and then extracting to an Oracle database

I don't know how to do it just yet myself as we just started learning the stuff yesterday but I believe ADO.NET handles that exact stuff.
__________________

Gaming

MSI MPower Z87 | 4770k | CNPS9900MAX-B | 8GB G.Skill 1866 | EVGA GTX760 |ThermalTake 850w | X-Fi Titanium | HAF | Asus PA248Q | Lycosa | Death Adder | Win8 Pro 64

Dev/Backup

MSI GD65 | 2500k | H50 | 8GB G.skill | GTX570 | Ubuntu 13.10

Laptop

17" Inspiron | i5 | 4GB DDR3 | 500GB HDD | Win7 Pro 64

jcrox is offline   Reply With Quote
Old 11-02-07, 10:53 PM   #10
ephmrl
Registered User
 
Join Date: Dec 2006
Posts: 81
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Quote:
Originally Posted by MUYA
Thanks bud, but is there another easier way? erm rater than covert straigh to XML, erm extract to the database maybe?
Sounds like you should just write up/macro record some vb script to export your word tables to simple CSV (comma seperated values), or tabs, or colons, etc files, and then import those to whatever database you are using. This would avoid the need for the xml converter at least. Presuming you are using access, your vb script should be able to easily launch both word & access, and iterate through your files without manual intervention.

Good luck.

Here's a few links that describe the basic manual steps:

http://word.mvps.org/FAQS/TblsFldsFms/WordToAccess.htm
http://www.brainbell.com/tutorials/m...s_Database.htm
ephmrl is offline   Reply With Quote
Old 01-15-08, 10:06 AM   #11
jcrox
Mahna Mahna
 
jcrox's Avatar
 
Join Date: Jul 2006
Location: Madison, Wi
Posts: 6,134
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Did you ever figure out how to do this?? It's a little (or lot) late but I know how to do this now
__________________

Gaming

MSI MPower Z87 | 4770k | CNPS9900MAX-B | 8GB G.Skill 1866 | EVGA GTX760 |ThermalTake 850w | X-Fi Titanium | HAF | Asus PA248Q | Lycosa | Death Adder | Win8 Pro 64

Dev/Backup

MSI GD65 | 2500k | H50 | 8GB G.skill | GTX570 | Ubuntu 13.10

Laptop

17" Inspiron | i5 | 4GB DDR3 | 500GB HDD | Win7 Pro 64

jcrox is offline   Reply With Quote
Old 01-15-08, 10:35 PM   #12
MUYA
 
Join Date: Jul 2002
Location: Hong Kong
Posts: 6,794
Send a message via MSN to MUYA
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Well, we outsorced the problem to a IT firm. Things are going well ...ish
__________________
I5-2500k@4.7GHz - MSI Z77A-GD65 - 4GB X2 A-DATA DDR3 1600 - Corsair H100 - Antec Quatro 850W
Gigabyte Windforce X3 GTX 680 OC - Dell 24" IPS
Intel 320 300 GB SSD - 1 TB Hitachi HDD - 2x 250 GB WD HDD
Corsair K90 - Corsair Venegance 2000 Headset - Razer Naga Epic
Corsair 600T Case
MUYA is offline   Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 11:36 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1998 - 2014, nV News.