Import Text File into StoreIt
Before you import your data, you need to define the category that you are going to import your data into. In this example, we are going to use the following category structure called Record Collection.
|Field Name||Field Type||Field Format|
And here is the information we want to import.
|Artist||Sleeve Image||Title||Recording Date||Notes||Cost||Own|
|Art Blakey||The Big Beat||NO|
|Dexter Gordon||Our man in Paris||May 23, 1963||Slight damage to back cover
Vinyl in excellent condition
|Grant Green||His majesty king funk||May 26, 1965|
The text file should be formatted as a tab separated file with no header information. That is, with a tab used between each field value (including empty values). There are 2 tab separated text file formats that you can use to import data.
- Each line of field values is prefixed with 3 additional columns containing the category name, the item id and the parent item id (if appropriate). This is the format that text files are exported from StoreIt.
- Or, if the category does not contain any nested categories, the field values can be listed with no additional prefixed columns.
As our example does not contain nested items, we are going to use the second format for now.
When preparing data for import the following should be noted about specific field types:
- Image, Category and Category Link (StoreItPro) field types should not be included in the file.
- Date, Time and Date & Time field types should be formatted as shown in the import page on StoreIt Link.
This will match the format that is used to display these fields on your iPhone.
- For Checkmark field types, if the field is checked then YES should be used, otherwise, when it is not checked, either NO or a blank field should be used.
- When a Number field type is formatted as Money, either the format that is used to display money values on your iPhone should be used, including your currency symbol, or an unformatted number can be used.
- If a Note field contains newlines or carriage returns then the text should be quoted with double quotes(“).
So taking all this into account, the following is how our data that we want to upload should be formatted. (We have used the symbol ¬ to represent the tab character.)
Art Blakey¬The Big Beat¬¬¬¬NO
Dexter Gordon¬Our man in Paris¬May 23, 1963¬Slight damage to back cover Vinyl in excellent condition¬$57.99¬YES
Grant Green¬His majesty king funk¬May 26, 1965¬¬¬
You should now be able to import this file using the StoreIt Link. Press the Sync button at the bottom of the Category screen to activate. (See the Export and Backup Data from StoreIt FAQ for instructions on how to do this.)
Tip 1: If you are having trouble performing an import then manually enter some items into the category on your iPhone and perform an export. This should give you a good guide to how you need to format your file to complete an import.
Tip 2: If you are importing a large number of items (say, over a few thousand items) then you should consider keeping your All Items view unsorted. Unsorted views perform much better for large categories. You can always create filtered views on the category that could be sorted.
Tip 3: If you have followed these instructions and are still having problems then you could try following our detailed steps for getting data from Excel into a tab separated format.