CDPedia - Revision history

Dave: /* New: Just use Copy and Paste */

2012-08-16T20:36:26Z

New: Just use Copy and Paste

← Older revision		Revision as of 20:36, 16 August 2012
Line 3:		Line 3:

	==New: Just use Copy and Paste==		==New: Just use Copy and Paste==
	A new feature is that you can just [[https://karaoke.kjams.com/wiki/Edit#Copy_and_Paste copy and paste]] blocks of data from your spreadsheet directly into kJams, and the data will "land" in the correct columns!		A new feature is that you can just [https://karaoke.kjams.com/wiki/Edit#Copy_and_Paste copy and paste] blocks of data from your spreadsheet directly into kJams, and the data will "land" in the correct columns!

	==To use an Excel spreadsheet with kJams==		==To use an Excel spreadsheet with kJams==

Dave: /* New: Just use Copy and Paste */

2012-08-16T20:36:16Z

New: Just use Copy and Paste

← Older revision		Revision as of 20:36, 16 August 2012
Line 3:		Line 3:

	==New: Just use Copy and Paste==		==New: Just use Copy and Paste==
	A new feature is that you can just [[https://karaoke.kjams.com/wiki/Edit#Copy_and_Paste\|copy and paste]] blocks of data from your spreadsheet directly into kJams, and the data will "land" in the correct columns!		A new feature is that you can just [[https://karaoke.kjams.com/wiki/Edit#Copy_and_Paste copy and paste]] blocks of data from your spreadsheet directly into kJams, and the data will "land" in the correct columns!

	==To use an Excel spreadsheet with kJams==		==To use an Excel spreadsheet with kJams==
	First you'll need to convert the spreadsheet into a text file:		First you'll need to convert the spreadsheet into a text file:

Dave at 20:58, 11 February 2012

2012-02-11T20:58:16Z

← Older revision		Revision as of 20:58, 11 February 2012
Line 2:		Line 2:
	[http://bruji.com/cdpedia/ CDPedia] is an amazing database application that just knows everything about your discs. It even lets you import your data from Excel!! Wow!		[http://bruji.com/cdpedia/ CDPedia] is an amazing database application that just knows everything about your discs. It even lets you import your data from Excel!! Wow!

			==New: Just use Copy and Paste==
			A new feature is that you can just [[https://karaoke.kjams.com/wiki/Edit#Copy_and_Paste\|copy and paste]] blocks of data from your spreadsheet directly into kJams, and the data will "land" in the correct columns!
	==To use an Excel spreadsheet with kJams==		==To use an Excel spreadsheet with kJams==
	First you'll need to convert the spreadsheet into a text file:		First you'll need to convert the spreadsheet into a text file:

Dave at 16:11, 6 March 2009

2009-03-06T16:11:25Z

← Older revision		Revision as of 16:11, 6 March 2009
Line 1:		Line 1:
			__TOC__
	[http://bruji.com/cdpedia/ CDPedia] is an amazing database application that just knows everything about your discs. It even lets you import your data from Excel!! Wow!		[http://bruji.com/cdpedia/ CDPedia] is an amazing database application that just knows everything about your discs. It even lets you import your data from Excel!! Wow!

Dave at 05:22, 21 March 2008

2008-03-21T05:22:59Z

← Older revision		Revision as of 05:22, 21 March 2008
Line 17:		Line 17:
	# run CDPedia		# run CDPedia
	# in the preferences -> General, set the custom fields so they look like this:<br>http://www.kjams.com/screenshots/cdpedia.png		# in the preferences -> General, set the custom fields so they look like this:<br>http://www.kjams.com/screenshots/cdpedia.png
	# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres), it should look like this:<br>http://www.kjams.com/screenshots/cdpedia_import.png		# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres and a bunch of other stuff), it should look like this:<br>http://www.kjams.com/screenshots/cdpedia_import.png
	# click "Import"		# click "Import"
	# Follow the steps below for using CDPedia with kJams		# Follow the steps below for using CDPedia with kJams

Dave at 05:22, 21 March 2008

2008-03-21T05:22:31Z

← Older revision		Revision as of 05:22, 21 March 2008
Line 17:		Line 17:
	# run CDPedia		# run CDPedia
	# in the preferences -> General, set the custom fields so they look like this:<br>http://www.kjams.com/screenshots/cdpedia.png		# in the preferences -> General, set the custom fields so they look like this:<br>http://www.kjams.com/screenshots/cdpedia.png
	# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres), it should look like this:<br>http://www.kjams.com/~~resources~~/~~import_code~~.png		# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres), it should look like this:<br>http://www.kjams.com/screenshots/cdpedia_import.png
	# click "Import"		# click "Import"
	# Follow the steps below for using CDPedia with kJams		# Follow the steps below for using CDPedia with kJams

Dave at 05:16, 21 March 2008

2008-03-21T05:16:46Z

← Older revision		Revision as of 05:16, 21 March 2008
Line 3:		Line 3:
	==To use an Excel spreadsheet with kJams==		==To use an Excel spreadsheet with kJams==
	First you'll need to convert the spreadsheet into a text file:		First you'll need to convert the spreadsheet into a text file:
	# In excel, make sure your spreadsheet has labels on the top including "Title" (which is the name of the song), Artist, Album, and either "Track #" or "Code". If you don't have all these fields, it won't work. You may optionally include "Genre". Extra fields are ignored. If you don't have a "Track #" then you must have "Code". Codes are used for when you have number-coded your song files for reference into your spreadsheet. eg: you may have a song called "432523.mp3", and in your spread sheet, you can look up code 432523 and see it's title, artist, album etc. If you have all track numbers, then this will also work when you put in a CD.<br>Below is an example of an excel spreadsheet using the "Codes" method. Note the column headers have been named correctly:<br>http://www.kjams.com/resources/xl_code.png		# In excel, make sure your spreadsheet has labels on the top including "Title" (which is the name of the song), Artist, Album, and either "Track #" or "Code". If you don't have all these fields, it won't work. You may optionally include "Genre", "Key", "Publisher", "Actual Time", "Rendition", and "Backup" (backing vocals). Extra fields are ignored. If you don't have a "Track #" then you must have "Code". Codes are used for when you have number-coded your song files for reference into your spreadsheet. eg: you may have a song called "432523.mp3", and in your spread sheet, you can look up code 432523 and see it's title, artist, album etc. If you have all track numbers, then this will also work when you put in a CD.<br>Below is an example of an excel spreadsheet using the "Codes" method. Note the column headers have been named correctly:<br>http://www.kjams.com/resources/xl_code.png
	# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)". Below is an example of what the text file then looks like when using "Track #" (ignoring "date added" field):		# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)". Below is an example of what the text file then looks like when using "Track #" (ignoring "date added" field):
	<pre>		<pre>
Line 16:		Line 16:
	Now that you've got the text file, the rest is easy:		Now that you've got the text file, the rest is easy:
	# run CDPedia		# run CDPedia
	# in the preferences -> General, set ~~"Custom Field 1" to "Album", and "Custom Field 2" to "Track #", and "Custom Field 3" to "Code"~~. ~~'''NOTE:''' if you're already using these fields for something else, please let me know, and I'll tell you how to instruct kJams to use other fields~~.		# in the preferences -> General, set the custom fields so they look like this:<br>http://www.kjams.com/screenshots/cdpedia.png
	# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres), it should look like this:<br>http://www.kjams.com/resources/import_code.png		# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres), it should look like this:<br>http://www.kjams.com/resources/import_code.png
	# click "Import"		# click "Import"

Dave at 20:35, 2 March 2008

2008-03-02T20:35:44Z

← Older revision		Revision as of 20:35, 2 March 2008
Line 3:		Line 3:
	==To use an Excel spreadsheet with kJams==		==To use an Excel spreadsheet with kJams==
	First you'll need to convert the spreadsheet into a text file:		First you'll need to convert the spreadsheet into a text file:
	# In excel, make sure your spreadsheet has labels on the top including "Title" (which is the name of the song), Artist, Album, and either "Track #" or "Code". If you don't have all these fields, it won't work. You may optionally include "Genre". Extra fields are ignored. If you don't have a "Track #" then you must have "Code". Codes are used for when you have number-coded your song files for reference into your spreadsheet. eg: you may have a song called "432523.mp3", and in your spread sheet, you can look up code 432523 and see it's title, artist, album etc. If you have all track numbers, then this will also work when you put in a CD.		# In excel, make sure your spreadsheet has labels on the top including "Title" (which is the name of the song), Artist, Album, and either "Track #" or "Code". If you don't have all these fields, it won't work. You may optionally include "Genre". Extra fields are ignored. If you don't have a "Track #" then you must have "Code". Codes are used for when you have number-coded your song files for reference into your spreadsheet. eg: you may have a song called "432523.mp3", and in your spread sheet, you can look up code 432523 and see it's title, artist, album etc. If you have all track numbers, then this will also work when you put in a CD.<br>Below is an example of an excel spreadsheet using the "Codes" method. Note the column headers have been named correctly:<br>http://www.kjams.com/resources/xl_code.png
	# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)", the text file then looks like ~~this~~ (ignoring "date added" field):		# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)". Below is an example of what the text file then looks like when using "Track #" (ignoring "date added" field):
	<pre>		<pre>
	Title Artist Album Track # Date Added		Title Artist Album Track # Date Added

Dave at 07:23, 28 February 2008

2008-02-28T07:23:25Z

← Older revision		Revision as of 07:23, 28 February 2008
Line 3:		Line 3:
	==To use an Excel spreadsheet with kJams==		==To use an Excel spreadsheet with kJams==
	First you'll need to convert the spreadsheet into a text file:		First you'll need to convert the spreadsheet into a text file:
	# In excel, make sure your spreadsheet has labels on the top including ~~Name~~, Artist, Album, Track #. If you don't have all these fields, it won't work. You may optionally include ~~genre~~. Extra fields are ignored.		# In excel, make sure your spreadsheet has labels on the top including "Title" (which is the name of the song), Artist, Album, and either "Track #" or "Code". If you don't have all these fields, it won't work. You may optionally include "Genre". Extra fields are ignored. If you don't have a "Track #" then you must have "Code". Codes are used for when you have number-coded your song files for reference into your spreadsheet. eg: you may have a song called "432523.mp3", and in your spread sheet, you can look up code 432523 and see it's title, artist, album etc. If you have all track numbers, then this will also work when you put in a CD.
	# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)", the text file then looks like this (ignoring "date added" field):		# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)", the text file then looks like this (ignoring "date added" field):
	<pre>		<pre>
Line 16:		Line 16:
	Now that you've got the text file, the rest is easy:		Now that you've got the text file, the rest is easy:
	# run CDPedia		# run CDPedia
	# in the preferences -> General, set "Custom Field 1" to "Album", and "Custom Field 2" to "Track #". '''NOTE:''' if you're already using these fields for something else, please let me know, and I'll ~~let~~ you ~~know what~~ to do.		# in the preferences -> General, set "Custom Field 1" to "Album", and "Custom Field 2" to "Track #", and "Custom Field 3" to "Code". '''NOTE:''' if you're already using these fields for something else, please let me know, and I'll tell you how to instruct kJams to use other fields.
	# File -> Import Collection, and pick your text file, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>		# File -> Import Collection, and pick your text file. If you're using track numbers, you should get a dialog that looks like this:<br>http://www.kjams.com/resources/import_collection.png<br>Alternately, if you're using Codes (and you happen to have Genres), it should look like this:<br>http://www.kjams.com/resources/import_code.png
	# click "Import"		# click "Import"
	# Follow the steps below for using CDPedia with kJams		# Follow the steps below for using CDPedia with kJams
Line 27:		Line 27:
	# Make sure it's name is "Library.cdpedia" in the finder		# Make sure it's name is "Library.cdpedia" in the finder

	Next time kJams starts up, it will also open that database (inside kJams). ~~Then~~, when you stick in a CD, if the data can be automatically gathered, it will "just work". If not, kJams will ask you for the CDPedia album name. Simply type the name of the album (or copy and paste it from CDPedia), and ~~that~~'s it!		Next time kJams starts up, it will also open that database (inside kJams). If you're using Tracks, then when you stick in a CD, if the data can be automatically gathered, it will "just work". If not, kJams will ask you for the CDPedia album name. Simply type the name of the album (or copy and paste it from CDPedia), and it will get all the meta for you. If you're using Codes, then when you go File->Add To Library, or if you Pull Meta Data, then it will just gather the info magically. Yay!

Dave at 06:32, 28 February 2008

2008-02-28T06:32:59Z

← Older revision		Revision as of 06:32, 28 February 2008
Line 4:		Line 4:
	First you'll need to convert the spreadsheet into a text file:		First you'll need to convert the spreadsheet into a text file:
	# In excel, make sure your spreadsheet has labels on the top including Name, Artist, Album, Track #. If you don't have all these fields, it won't work. You may optionally include genre. Extra fields are ignored.		# In excel, make sure your spreadsheet has labels on the top including Name, Artist, Album, Track #. If you don't have all these fields, it won't work. You may optionally include genre. Extra fields are ignored.
	# Do a "Save As" on your spreadsheet, ~~and save it as text, using tab separated values~~, the text file then looks like this (ignoring "date added" field):		# Do a "Save As" on your spreadsheet, the "Format:" popup should be set to "Text (Tab delimited)", the text file then looks like this (ignoring "date added" field):
	<pre>		<pre>
	Title Artist Album Track # Date Added		Title Artist Album Track # Date Added