Tantalus - the online coin registry

Go Back   Tantalus Online Coin Registry > Main > Suggestions
 

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-05-2006, 09:45 PM
mnpolock mnpolock is offline
Member
 
Join Date: Jun 2006
Posts: 19
Default Import Guide and Import Issues

Ras,

Can you look at an import and see why the References or Attributions will not import. I have tried entering them into Tantalus by hand, exporting the file and then deleting the coin and importing it ... but all to no avail... it is like the database settings for those fields are messed up... I am getting everything in except for that.

Thanks,

Tony
Reply With Quote
  #2  
Old 06-05-2006, 11:01 PM
mnpolock mnpolock is offline
Member
 
Join Date: Jun 2006
Posts: 19
Default

Here is a link to instructions and what have you that I made for importing into Tantalus.

It covers Roman Rep, Imperatorial, Imperial, Provincials and Byzantine coins. I have noted all the fields, the meaning of the fields as I can tell, the options or flags that can be set and what they mean.

It is an excel spreadsheet so you need Excel or Open Office to view the spreadsheet. It also has TABS across the bottom ... four in total.

1. A how to import guide
2. Field List and Description
3. The actual Data Entry area
4. The preformatted ready to save as a Txt file area for the import.

Let me know what you think, Ras and Angie feel free to us this however you would like ... mod/change etc, I transfer full rights of the doc to Tantalus :-)

http://www.commonbronze.com/Tantalus...preadsheet.xls

I have it hosted at Common Bronze right now because I am unable to attached an excel file to the post .. perhaps Ras can move it and tell everyone where it should be.

Thanks,

Tony

AND BTW ... stop by the store if you get a chance http://www.commonbronze.com/catalog
Reply With Quote
  #3  
Old 06-05-2006, 11:02 PM
mnpolock mnpolock is offline
Member
 
Join Date: Jun 2006
Posts: 19
Default The How Two Guide

A How To Import Guide for Tantalus

1. Fill out all the fields that are listed and that you want to have data for on the " ENTER COIN INFORMATION HERE" tab of this excel spreadsheet.

2. When you are finished, click on the tab labeled "SAVE AS MSDOS TXT FILE"

3. You will see that only the fields that you have entered data in are displayed to be imported. NOW, save the excel file so that you have all your information complete.

4. After you have made sure that you have saved your information and you are still on the "SAVE AS MSDOS TXT FILE" tab, you can go to FILE on the toolbar and then SAVE AS and save the file as a MSDOS txt file. This is the required format for importing coins into Tantalus.

5. Now you need to create a folder on your hard drive to get everything ready for import. For example lets say that you create a folder on your C Drive called Tantalus .. So it is C:\Tantalus and you would save your file you just created in that folder.

6. Now you need to create a folder under the Tantalus folder (or whatever you called it) to store the images, and you need to name it images. So when you are done you should have a folder here C:\Tantalus\images

7. Now you need to copy your images into this directory. Please make sure that you have listed the name of the image in the spreadsheet and that your capitalization is correct … if the file name is TANTALUS.JPG … your excel spreadsheet needs to show TANTALUS.JPG .. not tantalus.jpg or TANTALUS.jpg .. has to match EXACTLY.

8. Now that you have the excel file saved as a MSDOS txt file in the C:\Tantalus folder and you should have all your images in the C:\Tantalus\images folder.

9. You now need to create a zip file. If you are not sure how to do this you can go to http://www.winzip.com and download WinZip to create your WinZip file. The way I create the WinZip file is as follows.

A. Right click your mouse in the folder C:\Tantalus and select "NEW" then "WINZIP FILE" and name it whatever you would like.

B. Using the Control Key, select the TXT file that you created (located in C:\Tantalus) you do this by holding down the Control Key and left click the file, NOW KEEP THE CONTROL KEY PRESSED DOWN and now left click the folder named images. You should now have to items that are highlighted in blue.

C. Release the Control Button and click and hold once on either the TXT file or the images folder and drag the files over the WinZip file that you just created.

D. A WinZip dialog box should open with a prompt to add files to the WinZip archive. Click add.

E. Open Tantalus … go to the Import/Export feature, browse for your WinZip file that you just created, and then click IMPORT and Wala you now have imported coins into Tantalus.
Reply With Quote
  #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
  #5  
Old 06-06-2006, 12:26 PM
rasiel rasiel is offline
Administrator
 
Join Date: Sep 2005
Posts: 276
Default

WOW! Thanks for all this help Tony, you tha man!

Ras
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -4. The time now is 01:30 PM.

Powered by vBulletin Version 3.5.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Dirty Old Coins, LLC