The Traders' Den  

  The Traders' Den > Where we go to learn ..... > Technobabble
 

Notices

Technobabble Post your general Need for Help questions here.
Lossy or Lossless?
Moderators

Reply
 
Thread Tools
  #1  
Old 2011-04-07, 12:01 PM
oxymoron
0.00 KB/0.00 KB/---
 
Question 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?
Edit/Delete Message Reply With Quote Reply with Nested Quotes
  #2  
Old 2011-04-07, 04:10 PM
U2Lynne's Avatar
U2Lynne U2Lynne is offline
TTD Staff
471.57 GB/2.01 TB/4.37
 
Join Date: Oct 2004
Location: California
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.
__________________
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

TTD GoFundMe Campaign

Reply With Quote Reply with Nested Quotes
  #3  
Old 2011-04-07, 04:32 PM
oxymoron
0.00 KB/0.00 KB/---
 
Re: Word / Database

Quote:
Originally Posted by U2Lynne View Post
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
Reply With Quote Reply with Nested Quotes
  #4  
Old 2011-04-07, 09:00 PM
xjsb125 xjsb125 is offline
78.22 GB/159.27 GB/2.04
 
Join Date: Oct 2006
Location: Bristol, VA
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.
Reply With Quote Reply with Nested Quotes
  #5  
Old 2011-04-08, 01:01 AM
tgunn2760's Avatar
tgunn2760 tgunn2760 is offline
1.12 TB/1.19 TB/1.06
 
Join Date: Sep 2006
Location: Canada, eh?
Re: Word / Database

Quote:
Originally Posted by oxymoron View Post
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.
__________________
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
Reply With Quote Reply with Nested Quotes
  #6  
Old 2011-04-08, 02:02 AM
oxymoron
0.00 KB/0.00 KB/---
 
Re: Word / Database

thank you all!
Reply With Quote Reply with Nested Quotes
Reply

The Traders' Den > Where we go to learn ..... > Technobabble

Similar Threads
Thread Forum Replies Last Post
Converting Lotus Word Pro document into MS Word? - thisistoto Technobabble 6 2011-01-19 04:54 PM
How To Do A List Database? - Ritual Technobabble 4 2007-03-11 01:29 PM


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

Forums


All times are GMT -5. The time now is 06:10 AM.


Powered by: vBulletin, Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004 - , TheTradersDen.org - All Rights Reserved - Hosted at QuickPacket
no new posts