Proposed improvements for OpenNumismat

but this ID don’t tell us nothing. When we’re managing

our collection we need a special key code to match our ítem in your program with our ítem in real collection to identify and locate it easily.

In this case, I have 3 coins, all of them are the same code in SCWC but each one have different specific info.

I need to match with this

How to solve it?

then we’ll have common info for the element

element you can put the year for this variant of

the element, you can replace this for a new control to select the year. Even this new control can be delimited by the data of the first and last issue year.

Replace with this control

First issue = Low limit
Last issue = High limit

automatically on the field:
And even better, you can have

two specific fields for this purpose. If the element have just a only date then you put the same info in both fields

type or category of element you’re recording, this field will

be very useful for new filter on Treeview and list and summary counter, this may be translated from the colnect download info form.

Add this control there

Even if you put this as Catalog (References), people can manage many categories of collectibles in a single data base like all collections in Colnect.net or even another ones, it’s not necesary to implement the functionally of download the info from the Colnect site, you can still working only with Coins, Banknotes and Stamps

image

field for default Mint Mark in the Mints catalog, of

course not as icon, when you select the Mint then image will load automatically in the image box

But you can let the user can select another image due the modify logo of Mints though the time. For example Moscow Mint

need to automatically load his signature image on “Classification tab”

in the image field in variety área and and name in signature field in “Design tab” only if category field ítem is BANKNOTE. This signature image will be assigned on the Governor catalog for each one.

Why not put the signatura image on this place???
Because is not enough space to a signature image. Even you can modify this forms because signature is more like a variety of the banknote

they individual signs if Colnect info includes it for each

element???

As you can see, sign images for different banknotes as the same one. But the quality is diferent, then you could select the best defined sign and assign it in the catalog for the right Governor and even we can sabe space on data base.

your element of the catalog , in this case I

have the element KM# 472 for 1972 year

have a diferent issue date. Selecting the element on the

treeview, click right button to show Pop-Up menú and click on Clone this element (new option)

to add new ítem and on Pop-Up menú click on

Add new coin (replace text with Add new item) and show new window

This info came from the element which you’re adding a new coin and they are non editable fields here, just informative function to identify the master record.

Generate

Unique Key

This is a tool to create the unique Key for each ítem, I’ll explain this función later

Number

This is a ítem counter. Is equal to 1 if the element don’t have any ítem, and it will automatically increase in 1 unit when you add a new ítem on the same element. If you already have 1 ítem in this element then the next one will be 2, if you have 6 then next one will be 7.

Serial Prefix

Serial Number

For the banknotes you need to have Serial Prefix and number info for each item

the first one named “Buys” and the second one “Sales”.

This new tabs will be operated (as until now) depending of which value you select

It still doing nothing

I don’t know the right words in English, then I’ll use colors to identify

In Buys tab enabled the wished área to set the date when you see this ítem for first time or know its existence and start to wished it

In Buys tab enabled the wished area , seller area and the auction area to set bidding info

In Buys tab enabled the wished area , seller area and the auction area to set bidding info

In Buys tab enabled the wished area, seller area, auction area and the owned area to set the date when you got in your hands this item

This action enabled all areas in Buys tab and enabled in Sales tab the On Sale area

This action enabled all areas in Buys tab and enabled in Sales tab the On Sale area and Selled area.

This action enabled both tabs, Buys and Sales with all funcionalities mentioned until this point

This action enabled both tabs, Buys and Sales with all funcionalities mentioned until this point and enabled Lost area in Sales tab

default value is today. Suppously you’ll add this wished coin

the same day you wish it.

Set on Calendar Box dates of start and end of the auction, the initial Price and the first bid we did, enabled Place and Seller fields, already they exist.

As you can see, I inverted the order of Place of buy and the seller. You can select the seller from a list box from a new catalog

Payment

Commision

Shipment Cost

Shipment Date

Payment Date

0.00

0.00

0.00

This área set the info of a Direct buy, if you don’t got this ítem by auction, you can show their data with default data. Or at same time it conclude the bidding process it you got this ítem by auction.

on your hands and calculate Total Cost
Custom Taxes
Reception Date
0.00
TOTAL COST
0.00
TOTAL

COST is calculated automatically only with the sum of this numeric fields

I allocated all this control with no order and diferent sizes just to ilustrate you, of course you’ll put in correct size and distribution even you can remain the information field under the total cost field to write down any interesting thing in this process

set the initial prices if you’re selling in an auction

and the place were you’re selling your ítem.

Select the buyer, set the final Price, sale comisión and shpment cost. Set the Sale date.

Set the date when you lost or notice of losing this item.

Final Price

0.00

Sale date

Sale Comission

0.00

Shipment Cost

0.00

TOTAL PRICE

0.00

PROFIT OR LOSS

0.00

Information

TOTAL PRICE is calculated automatically only with the aritmetic operations of this numeric fields Final Price –(Sale Comission + shipment Cost)

PROFIT OR LOSS is calculated automatically only with the subtraction of the numeric fields Final Price – Final Cost

You can select the Buyer from a list box from a new catalog

Date of lost

This icon let you print a mail label to send this ítem to the selected buyer

info came from the element which you’re adding a new

coin and they are non editable fields here, just informative function to identify the master record.

Generate

Unique Key

Number

When you click here then program must be créate automatically the unique Key for this ítem from the new tab you need to add in the collection window configuration.

Serial Prefix

Serial Number

put this on big size to show you how this

could work

In this case. This configuration will gives us a unique Key:

MEX-KM#472-1976-1

[FieldName] this is a field from the data base asociated qith this ítem. You can see a list of all fields there.
+ sign, means CONCATENATION
“AnyText” this is a fixed text to insert into unique key as separator.
Capital Letter after [FieldName] means when you apply this FieldName according the catergory of the ítem (B=banknotes, C=coins, S=stamps).

In this example you could ask me where you find the CountryID and ItemID fields. Well, the ItemID is the automatically generated number whom increase in 1 unity when you add a new item.

The CountryID it will need to add in the Country catalog the ISO 3166-1 alfa-3 codes.

MEX for Mexico
UKR for Ukraine
RUS for Russia
USA for USA ;)

identify our ítems in database matching with the real. Even

we’re able to print some labels (if you add this new functionality we could talk later about new reports and printing improves). Labels examples on next image.

item in our database, but what happend when we have

more than 1 coin, banknote or stamp of the same element with particular characterisctics?

In this case, I have 3 coins, all of them are the same code in SCWC and the same year but each one have different specific info.

How to solve it?

This is easy!!!!, just we still using the copy and clone functions to have a new record for this new item, it could be linked with the master element but a specific info about the status of the coin, its unique key, its single buying/selling process, and most importanat, we’ll have only a single set of images of the coin (Observe and Reverse ant the others it could have) instead 3 set.

to add functuionality to this program about the Sale process

due to users asked you this. Then you have numismastic users using your program to manage a large collections. What happend when we have more than 1 ítem of the same element with particular characterisctics, what happend when I buy a coin roll with 10 coins and I would sell them individually???, I know, I could copy or clone the same ítem 10 times as I described in the Case 1. Now, we imagine about some user buys a banknote brick with 100 same banknotes and he want to sell them or just register them individually????

This is easy, too!!!!, apart from the copy and clone functions we need to include a new function, REPLICANT (or multiply) ítem, that means you need to slect the ítem, open Pop-Up menú and chose this new option to open the work window. First of one you must add the basis ítem with the all common characteristics, in the case of banknotes write down the serial prefix and the first serial number (remember, this serial number could have a mix of numbers and letters).

How to solve it?

a recursive function to create this 999 (in this example)

new ítems,
1.-take the hightest ItemID number for this element and add 1 for each one new record.
2.-Generate the Unique Key for each new record according the configuration pointed in before slides for the new items.
3.-In case of the Category of the basis ítem being Banknote, then the basis serial number will be increased in 1 unity for each
New ítem.

This example will create 999 new items in addition to the basis ítem, that means what I’ll have 1,000 items on the catalog attached to the same element. And again, we have only 1 set of images for the element instead 1,000 sets of images by each ítem.

know why you add the map functionality. What does it

represent?

I think that the functionality is excelent but not the info that it represent. I identified 3 geo information topics it would be interesting to know.
1.-The country of the item.
2.-The address where I bought the item, and
3.-The address where I sell the item.

When we edit our catalogs, the country catalog must need to open a new window for each record

name of the country
This code will be used to generate

the Unique Key

The country’s icon for listboxs

This flag image would be use in the future to have colourful reports with better resolution

This is the Geo Location for the country. This info will let us to have a map to identify what countries we have items

Category: All
FRA
Coins

50
Banknotes 16
Stamps 0

Total Cost 95.34
Total Price 0.00

That’s what info to show when I clicked on France pin

new catalog about Buyers and Sellers
You can manage this catalog

in the same Tab or in a single Tab for each one, but both must be depending of the Shops, Sites or Places where we buy

Bach
Address
4 Jingshan Front St, Dongcheng Qu, Beijing Shi, China, 100006


email
Jet_Li@chinamail.cn
Phonel
+86

10 8500 7421

Notes

These data are to print label in Sales tab on item window.

Map

Info

Map

Category: All
AsianBanknotes
SELLER

Coins

50
Banknotes 16
Stamps 0

Investment 95.34

That’s what info to show when I clicked on China pin

Category: All
That’s what info to show when I clicked on

Colombia pin

AsianBanknotes
SELLER

Coins 0
Banknotes 52
Stamps 0

Incomes 24.00

base topic?
I’ve registered only 133 ítems until now and data

base file already is 39 Mb. What would happend when I register 10,000 items???, why do not use a high performance relational data base model???