PDA

View Full Version : Word / Database


oxymoron
2011-04-07, 12:01 PM
need help to convert word.doc into a databasewith these structure:
interpret / titel / date / number of dvd

i saved my collection on dvd, make with copy/paste a list from each dvd.

example:

436
John McLaughlin - 2010-11-13 Town Hall, NY
John McLaughlin - 2010-11-18 Potawatami Casino's, Milwaukee
John McLaughlin - Master Class- New Morning-95_12_13
John McLaughlin & One Truth Band - 1978 09 07 Berlin FM
Weather Report - 1973 Chateauvallon FRANCE 1973-08-24 FM
Weather Report - Jabberwocky Club Syracuse, NY 1973-08-30 FM
Miles Davis - 1971-10-21 FM
Miles Davis - 1985-04-26 New Orleans FM
Miles Davis - 1986-07-24c San Sebastian FM
Miles Davis - 1986-10-26 Belgrade - TV Broadcast


any idea?

U2Lynne
2011-04-07, 04:10 PM
I would guess you would need to first convert it to a plain text file. Then, um, I'd probably google it. :)

oxymoron
2011-04-07, 04:32 PM
I would guess you would need to first convert it to a plain text file. Then, um, I'd probably google it. :)

hmm, editing/convert *.doc > *.txt (with hypertext?). the problem are the dates, different places in the text ... no idea to handle it.
also a great problem is the original doc file (word97), at time 3.5MB, too big for word and a lot of work to be editig by hand
next time i install hypertext, will see what´s come up with this prog
other upcoming problem is the database, which is the best? have read some articles about html (sql) database,very nice, but more work with it

yeah, this shows to make it right by starting. next live and next collection i do it better

thanx lynne
:wave:

xjsb125
2011-04-07, 09:00 PM
Remove Word and download Open Office. From there your entries need to have a uniform structure to them. Your current list is not uniform in the way the dates are typed, venues, and some even have the source after them.

Example:
John McLaughlin - 2010-11-18 Potawatami Casino's, Milwaukee
John McLaughlin - Master Class- New Morning-95_12_13
John McLaughlin & One Truth Band - 1978 09 07 Berlin FM

Uniform:
John McLaughlin - 2010-11-18 - Potawatami Casino's - Milwaukee, WI
John McLaughlin - 1995-12-13 - Master Class - Unknown
John McLaughlin & One Truth Band - 1978-09-07 - FM Broadcast - Berlin, Germany

Once everything is uniform, you should be able to import it into a spreadsheet such as Excel or Calc in Open Office. Once it's in the spreadsheet, if you name the columns, you can sort the whole sheet by artist, date, venue, whatever you like.

tgunn2760
2011-04-08, 01:01 AM
need help to convert word.doc into a databasewith these structure:
interpret / titel / date / number of dvd

i saved my collection on dvd, make with copy/paste a list from each dvd.

example:

436
John McLaughlin - 2010-11-13 Town Hall, NY
John McLaughlin - 2010-11-18 Potawatami Casino's, Milwaukee
John McLaughlin - Master Class- New Morning-95_12_13
John McLaughlin & One Truth Band - 1978 09 07 Berlin FM
Weather Report - 1973 Chateauvallon FRANCE 1973-08-24 FM
Weather Report - Jabberwocky Club Syracuse, NY 1973-08-30 FM
Miles Davis - 1971-10-21 FM
Miles Davis - 1985-04-26 New Orleans FM
Miles Davis - 1986-07-24c San Sebastian FM
Miles Davis - 1986-10-26 Belgrade - TV Broadcast


any idea?


Just rename the txt file csv or excel, whatever the extension for excel may be. It worked for me when I saved my TT list to text and renamed it csv, which is excel format with csv extension.

The problem I have is that I cannot import the csv list to dbetree.

oxymoron
2011-04-08, 02:02 AM
thank you all!