Chrislands Upload Format
Tab-Delimited Files

Listed in the table below is the field format for tab-delimited upload files.
Only 3 fields must contain data (Seller ID, Title, and Price); the other fields may contain null values.
All 35 fields must be present in each upload file, even if the many of the fields contain null values.

Field Sequence

Field Name

Type and (length)
of field

Are null values allowed

1

Seller ID (unique ID assigned to each book)

 text or number (50)

Null value not allowed

2

Author

 text (255)

May be null

3

Title

 text (255)

Null value not allowed

4

Illustrator

 text (255)

May be null

5

Book condition

 text (999)

May be null

6

Book size

 text (50)

May be null

7

Jacket conditionn

 text (30)

May be null

8

Binding

 text (50)

May be null

9

Book type

 text (30)

May be null

10

ISBN

 text (15)

May be null

11

Publisher

 text (255)

May be null

12

Publish place

 text (100)

May be null

13

Publish Date

 text (50)

May be null

14

Edition

 text (150)

May be null

15

Inscription

 text (50)

May be null

16

Description

 text (65000)

May be null

17

Quantity

 integer (max value = 999)

May be null. If null, default value of 1 assigned

18

Price

 numeric (no $ sign)

Null value not allowed

19

Image

 text (255)

May be null. If used, must be web address such as http://www.name.com/image.jpg

20

Category 1

 text (128)

May be null.  If null, book will be assigned to "Other" category

21

Category 2

 text (128)

May be null.   A book can be assigned to multiple categories.

22

Category 3

 text (128)

May be null

23

Category 4

 text (128)

May be null

24

Category 5

 text (128)

May be null

25

Keyword 1

 text (2500)

May be null.  Entries in this field will will be included in "Keyword" searches.

26

Keyword 2

 text (2500)

May be null

27

Keyword 3

 text (2500)

May be null

28

Keyword 4

 text (2500)

May be null

29

Keyword 5

 text (2500)

May be null

30

Keyword 6

 text (2500)

May be null

31

Keyword 7

 text (2500)

May be null

32

Keyword 8

 text (2500)

May be null

33

Keyword 9

 text (2500)

May be null

34

Weight

 numeric

Optional Field

35

Featured Item

 text(15)

Optional Field - If you want an item to apppear as a Featured Item, then enter any letter in this field. If this field is null, then the item will not be listed as a featured item

When uploading by FTP use the following naming conventions to let the server now how you want your upload file processed.

1.  Purge upload.  When processing a purge upload, all of your online listings will be deleted and then replaced with the listings in the purge upload file.  

To initiate a purge upload when uploading by FTP include the string “purge” in the name of the upload file.  Examples

Purge.txt
purge.tab
purge21Aug01.txt

2. Delete upload. When processing a delete upload, only the first field (Seller ID) of each record is read and that corresponding item will be deleted from your online listings.

To initiate a delete upload when uploading by FTP include the string “del” in the name of the upload file. Examples

Del.txt
delete.txt
delete21Aug01.tab

3. Add/Modify upload. New records will be added to the your online listings and if an item has the same item number as an online listing, then the online listing will be updated with the new information.

Any upload file that does not contain “del” or “purge” will be treated as an add/modify upload.