This is how to create a CSV file to import in your collection.
This feature can be found:
Login -> My Crate -> Tools
* All additional fields are optional only required is UPC (a valid 12 or 13 digit UPC code is required!)
* Any line that starts with a '//' is ignored as a remark
* Date formats should be standard date format between 1/1/1900 and 1/1/2080
* Any Disc not found by the UPC is searched against a collection of web feeds, if not found there the Disc is added to a unknown report
* All Disc's imported via this mechanism are added to your 'Owned' crate
* If no Price paid is given then the MSRP of the Disc is used for reporting statistics
FIELDS:
upc = UPC of Disc (well, doh!)
private = incidates if the DVD is a private (dont show if someone other than you is viewing your collection, ie Pron or "Tootsie" (ick!), must be either "1" or "True" (For Yes) and "0" or "False" (For No)
acquiredFrom = Name of place where Disc was purchased/found/traded/stolen (ie 'Acquired From'), must not contain commas, can be surrounded by Quotes (")
acquiredDate = Date of Disc acquisition
pricePaid = USD amount paid
note = Any note you would like to store with this Disc in your collection (ie "Grandma loves this Movie, watch it when she is in town"), must not contain commas, can be surrounded by Quotes (")
Example One (about as plain as one can get):
Code:758445115628
720616901194
Example Two (add some details):
Code://upc, private, acquiredFrom, acquiredDate, pricePaid, note
025192055027, 0, Best Buy, 1/1/2008, 14.95,
097361386843, 0, Radio Shack, 2/1/2008, 24.95, Some kind of give away thing
025193290427, 0, Circuit City
Example Three (some with info, some without):
Code://upc, private, aquiredFrom, acquiredDate, pricePaid, note
025192055027, false, "Best Buy", 1/1/2008, 14.95,
000001110000
097361386843, false, "Radio Shack", 2/1/2008, 24.95, "Some kind of give away thing"
758445115628
720616901194
010030310000
025193290427, false, Circuit City
And just because I can, here is the debug output of importing the Example Three above about into my account;
Code:[CSV Import Start]
Added Dvd [12] to User [1] Collection Id [1]
User [CmdrTallen] Imported Disc [025192055027]
! Error Importing Disc [000001110000] Error [No Disc Found with by given UPC [000001110000]]
Added Dvd [2] to User [1] Collection Id [1]
User [CmdrTallen] Imported Disc [097361386843]
Added Dvd [6] to User [1] Collection Id [1]
User [CmdrTallen] Imported Disc [758445115628]
Added Dvd [9] to User [1] Collection Id [1]
User [CmdrTallen] Imported Disc [720616901194]
! Error Importing Disc [010030310000] Error [No Disc Found with by given UPC [010030310000]]
Added Dvd [7] to User [1] Collection Id [1]
User [CmdrTallen] Imported Disc [025193290427]
[Complete]
The DVDCrate Dude