Visit DvdCrate.com
Welcome Guest Search | Active Topics | Members | Log In | Register

CSV Upload Format Options
CmdrTallen
Posted: Saturday, November 08, 2008 10:46:15 PM

Rank: Administration

Joined: 10/7/2008
Posts: 252
Location: Olathe, KS
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
CmdrTallen
Posted: Tuesday, December 16, 2008 11:16:16 PM

Rank: Administration

Joined: 10/7/2008
Posts: 252
Location: Olathe, KS
I added the ability to import DvdSpot Exports. As long as the first line in the export file (the file you are sending to DvdCrate) looks exactly like this;
Code:
upc,title,custom_title_sort,rating,review,source,price,owned,owned_date,owned_custom,watched,watched_date


You should have no import issues.

This will also create viewings and reviews if you have the fields filled out above. I am not sure how DvdSpot handled commas without quotes, so if you have commas in your review, notes or title it most likely will cause some issues. If someone is trying to upload a DvdSpot and it fails please post a snippet of the file and the error your getting.

Thanks!


The DVDCrate Dude
CmdrTallen
Posted: Sunday, January 18, 2009 1:57:22 PM

Rank: Administration

Joined: 10/7/2008
Posts: 252
Location: Olathe, KS
If you have any amount of Discs in your collection, I highly recommend heading to Ebay and getting yourself a CueCat.

Its a simple USB barcode scanner than will emulate a keyboard. So you literally plug it in, start notepad, scan your discs, then save that file and then import that file.

Super easy.


The DVDCrate Dude
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

DVDCrate Theme Created by CmdrTallen
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.057 seconds.