|
Technobabble Post your general Need for Help questions here.
• Lossy or Lossless? Moderators |
|
Thread Tools |
#1
|
|||
|
|||
Word / Database
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? No members have liked this post.
|
#2
|
||||
|
||||
Re: Word / Database
I would guess you would need to first convert it to a plain text file. Then, um, I'd probably google it.
__________________
ABT Seeding Policy | ABT Seeding Guide | VBT Seeding Policy | VBT Seeding Guide Software Links HERE | FAQ is HERE | Technobabble forum is HERE. If your port number is in red, you are firewalled! How to Set Up Your Router (so you aren't firewalled) and How to Port Forward on Windows XP Five's Checksums Demystified - everything and anything you want to know about checksums
On a Mac? Get XLD to rip your CDs. Please see this guide - X Lossless Decoder (XLD): How to create flawless CD rips on Mac OS X No members have liked this post.
|
#3
|
|||
|
|||
Re: Word / Database
Quote:
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 No members have liked this post.
|
#4
|
|||
|
|||
Re: Word / Database
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. No members have liked this post.
|
#5
|
||||
|
||||
Re: Word / Database
Quote:
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.
__________________
Partial DVD list here: http://db.etree.org/tgunn2760 Text file of over 1500 DVDs: https://docs.google.com/file/d/0BxX3...Q2M/edit?pli=1 Trading status: Canada and USA only-please VERIFY all discs. http://db.etree.org/public_wantlist....erid=tgunn2760 No members have liked this post.
|
#6
|
|||
|
|||
Re: Word / Database
thank you all!
No members have liked this post.
|
The Traders' Den |
Similar Threads | ||||
Thread | Forum | Replies | Last Post | |
Converting Lotus Word Pro document into MS Word? - thisistoto | Technobabble | 6 | 2011-01-19 03:54 PM | |
How To Do A List Database? - Ritual | Technobabble | 4 | 2007-03-11 12:29 PM |
|
|