Import Data from TSV

FAQ and general support for the XSEL Flashcard app on the Apple App Store.

Import Data from TSV

Postby xseltech » Fri Sep 30, 2016 8:15 pm

database.tsv
TSV File Download
(47.89 KiB) Downloaded 84 times


There are a handful of tools you'll need before you start entering information into the TSV file.
1. Version 5.1 or higher of xSEL Inventory. (If you have purchased Restaurant Inventory Management you're entitled to a free copy, just forward your iTunes receipt to support@xsel.tech and we will get you a fresh promotional code to download a free copy.)
2. Microsoft Excel or equivalent. (Microsoft Excel is the official supported program, but even a simple text editor like Notepad will work.)
3. A familiarity with CSV/TSV files is recommended but not required.

To start entering data via TSV...
1. Launch the application and press "Export Database".
2. Send the email to an email address that you can open on your desktop computer.
3. Copy the file to your desktop computer and open it in Excel. When you open the file it will look something like this:
XSELINVENTORYTSV
BUILD6
VENDORLIST
ITEMLIST
LOCATIONLIST
ENDLIST


4. For each vendor you have you will want to put a vendor ID and a name followed by "(null)" without parentheses. Each vendor must have a unique Vendor ID, it must start with 1, and it must be in sequential order. (Keep in mind, {tab} is not actually there, it is the separation between cells. For example if you have three vendors your file might look like this when you are finished:
XSELINVENTORYTSV
BUILD6
VENDORLIST
1 {tab} Scott's Produce {tab} (null)
2 {tab} Jake's Meats {tab} (null)
3 {tab} Restaurant Depot {tab} (null)
ITEMLIST
LOCATIONLIST
ENDLIST


5. For each item you have you will want to put a item ID, a name, a portioned name, a package name, how many portions per package, the build to, the package price, and the preferred vendor ID. Each item must have a unique item ID, it must start with 1, and it must be in sequential order. (Keep in mind, {tab} is not actually there, it is the separation between cells. For example if you have three items your file might look like this when you are finished:
XSELINVENTORYTSV
BUILD6
VENDORLIST
1 {tab} Scott's Produce {tab} (null)
2 {tab} Jake's Meats {tab} (null)
3 {tab} Restaurant Depot {tab} (null)
ITEMLIST
1 {tab} Apple Pie {tab} Pie {tab} Box {tab} 6 {tab} 4 {tab} 23 {tab} 3
2 {tab} Applesauce {tab} Can {tab} Case {tab} 6 {tab} 1 {tab} 28 {tab} 1
3 {tab} Bacon {tab} Box {tab} Box {tab} 2 {tab} 8 {tab} 59 {tab} 2
LOCATIONLIST
ENDLIST


6. For each location you have you will want to put a location ID, a name, and the item IDs of the items that are stored in each location. (keep in mind that you can store the same items in more than one location if you count them in more than one location.) Each location must have a unique location ID, it must start with 1, and it must be in sequential order. (Keep in mind, {tab} is not actually there, it is the separation between cells. For example if you have three locations your file might look like this when you are finished:
XSELINVENTORYTSV
BUILD6
VENDORLIST
1 {tab} Scott's Produce {tab} (null)
2 {tab} Jake's Meats {tab} (null)
3 {tab} Restaurant Depot {tab} (null)
ITEMLIST
1 {tab} Apple Pie {tab} Pie {tab} Box {tab} 6 {tab} 4 {tab} 23 {tab} 3
2 {tab} Applesauce {tab} Can {tab} Case {tab} 6 {tab} 1 {tab} 28 {tab} 1
3 {tab} Bacon {tab} Box {tab} Box {tab} 2 {tab} 8 {tab} 59 {tab} 2
LOCATIONLIST
1 {tab} Freezer {tab} 3
2 {tab} Cooler {tab} 1 {tab} 2
3 {tab} Dry Storage
ENDLIST


7. After you have finished inputting this data you will hit the save button. It will show a warning, ignore this warning and continue saving as a TSV not as an Excel file.
8. Email this TSV file to an email address that you have on your device.
9. Ensure that you have a clean install of xSEL Inventory version 5.1 or higher. (Meaning you haven't entered any items, vendors, or locations since you installed it.
10. Press and hold the attachment "database.tsv" in your email for approximately one second.
11. Scroll to the right and select "Copy to Inventory".
12. Your data should be imported but your vendors will need to be associated with contacts in your address book. Be sure to allow permission for Inventory to access your contacts.
xseltech
Site Admin
 
Posts: 3
Joined: Mon Nov 30, 2015 1:32 pm

Return to XSEL Flashcard

Who is online

Users browsing this forum: No registered users and 4 guests

cron