What is the import file format?
- Vote for this:
There are two basic formats you can use to import data into MyBoxOffice. Both formats are Comma Separated Values (CSV) files.
This is the simplest format for importing data into MyBoxOffice and is also the format identified in the Help section in the app itself. The format is:
In this format, the only optional field is the Comment field. All other fields must be present and in appropriate CSV format. If you don't include the comments column, you must either leave it entirely blank or include a blank column by indicating double quotes (E.G. "").
The extended format allows you to import and control all values in MyBoxOffice, but it a bit more complex. The format is:
The only required field is Title. With the exception of UPC, all other fields can be left "blank" by putting in two quote characters for that field (E.G. ""). To leave out UPC, you must completely remove the UPC column for that row. With the exception of UPC, you cannot leave out or delete any columns that are blank. They must be present and denoted by double quotes. Status values are integer numbers from 0-4 (0 is want, 4 is 86'ed... they start numbering on the left of the user interface bar for status and continue right). Format is an integer from 0-3, same numbering scheme (based on the bar location of the value in the user interface). Read is 0 for no and 1 for yes.
Performing the Import
In order to perform the import, you need to upload your file to a location that is directly accessible on the internet. There are several services online for this type of thing, but many of them which used to offer true direct links have stopped doing so and several have become much more trouble than they're worth. If you want to give your own a try, feel free. However, I offer temporary file hosting on this website to support network import. Simply login to this website and then click on the "Temporary File Hosting" link from the "Tools" menu on the left. Once you have uploaded your file, simply enter the "direct link" provided by the site, exactly as you see it, for your file into the "Source" field on My Library and tap Go. Your data will be pulled in for you to use!