View Single Post
  #4  
Old 06-05-2006, 11:03 PM
mnpolock mnpolock is offline
Member
 
Join Date: Jun 2006
Posts: 19
Default The Field list (A little hard to read... but best I could do

The spreadsheet has colors and lines up better ... but I figured I would paste the info here.


Key to Abbreviations Used
ALL All Areas Listed
RR Roman Republican
Rimp Roman Imperatorial
RI Roman Imperial
RP Roman Provincial
Byz Byzantine

NOT USED Not used for any areas listed above
TEXT BOLDED If the Text is Bolded please read. It is either not required, or a system field.
Only Used for Some Areas Listed
Only Used for Some Areas Listed and uses Special Characters for Tantalus
If green on right Special Characters Available for Some Areas Listed

Srt Tantalus Field Areas Using Description of the field and any special items to note
1 coin_id All The Tantalus Coin Number assigned by the system, this should only be entered if you are replacing a coin that is already in the database that you have the coin number for, otherwise leave blank for the database to assign. Used by all.
2 a_id All The Tantalus Album ID, this is also assigned by the system, but you will need to add a coin, and then download a CSV of the album to get the album ID.
3 album All The name of your Tantalus Album. NOT REQUIRED FOR IMPORT LEAVE BLANK
4 a_header All The header of your Tantalus Album. NOT REQUIRED FOR IMPORT LEAVE BLANK
5 a_archive All Album Archive Flag ( 0=Not Archived, 1=Archived) SET TO 0
6 a_public All Album Public Flag ( 0=Viewable by Public, 1=Private not viewable by public)
7 a_rights All Album Picture Rights Flag ( 0= All Rights Reserved ,1= Copyrighted by User - Free to Reproduce with Copyright Holder Acknowledgement , 2=Must Contact for Permission , 3= Non-Commercial Right to Reproduce , 4= Public Domain )
8 cointype All Coin Type ( 1=Roman Provincial 2=Roman Imperial 4=Byzantine 5=Roman Republican 12 =Roman imperatorial)
9 forsale All For Sale Flag ( 0=Not for Sale, 1=For Sale)
10 currency All Currency Flag (1= USD, 2=EURO, 3=British Pound)
11 sellprice All Numeric Value for Selling Price. This is what Tantalus Users will see as the price for the coin to buy.
12 created All Database Only Field
13 modified All Database Only Field
14 public All Coin Public or Private ( 0=Private, 1=Public)
15 sale_pending All Sale Pending Flag ( 0=No Pending Sale, 1=Pending Sale)
16 auction All Text for Auction Name and Auction Number (i.e. EBay #8345613325)
17 authenticity All Text area to note Authenticity (i.e. Genuine, Ancient Forgery, etc.)
18 authority NONE NOT USED
19 certification All Text area for Certification Information
20 certified_by All Text area for who Certified/Organization/Service etc.
21 city RP City is used only for ROMAN PROVINCIAL COINS
22 country NONE NOT USED
23 denomination All Text area for Denomination Information
24 die_axis All Numeric Value for Degrees only
25 edge NONE NOT USED
26 edge_legend NONE NOT USED
27 est_currency All Estimated Value Currency Flag (1= USD, 2=EURO, 3=British Pound)
28 est_value All Numeric Number only for Estimated Value
29 est_value_cur All Estimated Current Value Currency Flag (1= USD, 2=EURO, 3=British Pound)
30 estimate All Numeric Number only for Estimated Current Value
31 exergue1 RP,Rimp,RR Exergue for Roman Provincial, Imperatorial and Republican Coins only
32 exergue2 NONE NOT USED
33 gens Rimp,RR GENS used for Roman Imperatorial and Republican Coins only
34 grade All Text area for noting Grade
35 location All Text area for noting Location
36 lot All Text area for noting what lot the coin was purchased from (EBay Auction, or other Auctions)
37 metal All Text area to note the metal of the coin
38 mint NONE NOT USED
39 mint_date All Text area to note Mint Date
40 mint_loc RI,Rimp,RR,Byz Text area to note Mint Location except for Roman Provincial Coins
41 mintage NONE NOT USED
42 mintmark NONE NOT USED
43 moneyer Rimp,RR Text area to note the Moneyer for Roman imperatorial and Republican coins
44 obv_desc Text area for Obverse Description
45 obv_legend Text area for Obverse legends (note that Roman Provincial also have special characters available)
46 officina RI,Byz Tantalus special characters to note Officina for Roman Imperial and Byzantine Coins
47 owner Text area to note Owners name
48 price All Numeric Value for price that you paid for the coin
49 price_currency All Price Currency Flag (1= USD, 2=EURO, 3=British Pound)
50 rarity All Text area to note the rarity of a coin
51 region RP Text area to note the Region that a Roman Provincial coins was minted in.
52 rev_desc All Text area for Reverse Description
53 rev_legend All Text area for Reverse legends (note that Roman Provincial also have special characters available)
54 ruler RI,RP,Rimp,Byz Text to note the ruler on the coin (Emperor and such) for all but Roman Republican
55 ruler_group NONE NOT USED
56 saledate All Text area to record the date of the coins sale
57 seller All Text area to record the sellers name
58 series NONE NOT USED
59 shape NONE NOT USED
60 size All Numeric Value for Size in millimeters (MM)
61 state NONE NOT USED
62 sub_variety NONE NOT USED
63 title RI,RP,Rimp,Byz Title of the Ruler or person on the coin for all but Roman Republican coins
64 tribe NONE NOT USED
65 type_info NONE NOT USED
66 variety NONE NOT USED
67 venue All Venue the coin was purchased in (EBay, Vcoins, Tantalus)
68 weight All Numeric Value for weight in Grams (GM)
69 regnal Byz Text area to record the Regnal Year for Byzantine Coins
70 indictional Byz Text area to record the Indictional Year for Byzantine Coins
71 date_ad NONE NOT USED
72 date_ah NONE NOT USED
73 dynasty NONE NOT USED
74 emperor NONE NOT USED
75 inventory All Text to note your internal inventory number or coin number
76 king NONE NOT USED
77 kingdom NONE NOT USED
78 reign NONE NOT USED
79 image1 All Name of Image one (required if you want an image for your coin)
80 image1_tn All DO NOT IMPORT - Tantalus will do this for you from the main image
81 image2 All Name of Image two (required if you want an image for your coin)
82 image2_tn All DO NOT IMPORT - Tantalus will do this for you from the main image
83 note_created All Tantalus Database Field DO NOT USE
84 note_txt All Text area to record your notes about your coin. You can use limited forum type HTML in the text area. Avoid using apostrophes.
85 note_public NONE NOT USED
86 fieldmark1 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
87 fieldmark2 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
88 fieldmark3 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
89 fieldmark4 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
90 fieldmark5 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
91 fieldmark6 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
92 fieldmark7 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
93 fieldmark8 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
94 fieldmark9 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
95 fieldmark10 RI,Byz Tantalus special characters to note Field Marks for Roman Imperial and Byzantine Coins
96 provenance1 All Text area to note your Provenance for your coins
97 provenance2 All Text area to note your Provenance for your coins
98 provenance3 All Text area to note your Provenance for your coins
99 provenance4 All Text area to note your Provenance for your coins
100 reference1 All Text area to note your Reference used to ID your coins
101 reference2 All Text area to note your Reference used to ID your coins
102 reference3 All Text area to note your Reference used to ID your coins
103 reference4 All Text area to note your Reference used to ID your coins
104 reference5 All Text area to note your Reference used to ID your coins
105 designer NONE NOT USED
106 inlay NONE NOT USED
107 ribbon NONE NOT USED
108 mounting NONE NOT USED
109 grouping NONE NOT USED
Reply With Quote