Add / Edit Currencies

[tcawe]

As you can read in a previous thread on this forum, the currencies list can not be changed from the NIF file anymore. Soon we'll try to add all missing currencies that appear on Wikipedia's currencies list.

Do mind that the current list may have problematic entries that are perhaps duplicates and perhaps wrong currencies such as when we have "cent" and we don't know which currency it belongs to. All these problems won't be fixed in a day but hopefully, with time, we'll have all the proper information added to Colnect.

To add a currency I need a statement like

Code: Select all

INSERT INTO `colnect`.`currency` (`id` ,`name` ,`symbol` ,`iso`)VALUES (NULL , 'NAME', 'SYMBOL', 'ISO');

Where you should replace NAME, SYMBOL and ISO such as in these examples:

Code: Select all

INSERT INTO `colnect`.`currency` (`id` ,`name` ,`symbol` ,`iso`)VALUES (NULL , 'US Dollar', '$', 'USD');
INSERT INTO `colnect`.`currency` (`id` ,`name` ,`symbol` ,`iso`)VALUES (NULL , 'Afghan Pul', '؋', 'AFN');

To update a currency I need a statment like:

If you'd like to change an existing currency it should be something like:

Code: Select all

UPDATE `colnect`.`currency` SET `name` = 'NAME',`symbol` = 'SYMBOL',`iso` = 'ISO' WHERE `currency`.`id`=CURRENCY_ID;

The CURRENCY_ID is the number appearing on the list of Colnect currencies (you can see this list on the IMPORTS page). The CURRENCY_ID is also the number which appear in a URL which has a currency filter such as:

https://colnect.com/en/coins/series/cou ... tes_dollar

Examples:

Code: Select all

UPDATE `colnect`.`currency` SET `name` = 'Units',`symbol` = 'units',`iso` = '' WHERE `currency`.`id`=1;
UPDATE `colnect`.`currency` SET `name` = 'Afghan Afghani' WHERE `currency`.`id`=69;

Yes, I could have made a nicer interface for adding or updating currencies BUT soon we expect to add all missing currencies so such tasks will become very rare. You're welcome to respond here if you have any questions.

[angelo13]

Hi Amir,

excuse my ignorance, from your new Currency integration schemes, I can not Understand how to write the formula.

Tell me if this coin https://colnect.com/it/coins/coin/7531- ... one-Italia the formula that i wrote is correct:

INSERT INTO currency colnect `` `(` 7531 `,` Italian Lira `,` ₤ `,` ISO 4217 Code ITL `) VALUES (NULL, 'Name', 'symbol', 'ISO').

The change must be sent via excel file?

[tcawe]

Hi Angelo,

We already have the Italian lira [437] on our currencies list hence it shouldn't be added.

Here another example:

INSERT INTO `colnect`.`currency` (`id` ,`name` ,`symbol` ,`iso`)VALUES (NULL , 'Salvadoran Colón', '₡', 'SVC');

Do mind you should be changing only the BOLD parts.

If you want to add the symbol for the Italian lira and fix it's name what you should write is:

UPDATE `colnect`.`currency` SET `name` = 'Italian Lira',`symbol` = '₤',`iso` = 'ITL' WHERE `currency`.`id`=437;

Do mind you should be changing only the BOLD parts.

Such statements you can send me either here or via email.

Thanks

[mozistv]

Hi!

I have add in last couple of moths, about 10,000 of banknotes to the catalog, and until now was easy to add new type of currency and i can not understand, why need to exchange some easy things in something complicated. Each time when i want to add a new currency i need to write some complicated things. I don't agree whit this. And by the way the NIF for banknotes is to old, with many missing Country and currency.

Istvan

[tcawe]

Hi Istvan,

The reason for this change is that the currencies list had many duplicates and wrong information on it. You are not expected to have to add currencies to Colnect. We plan on soon adding all currencies, then updating all NIFs with them. It will then be a very rare thing to add a new currency.

The NIFs should be kept updated here's how to update a NIF:

1/ Log in to Colnect

2/ Download the NIF you wish to update

3/ Check the relevant lists for that NIF on https://colnect.com/minad.php/en/import/lists

4/ Copy+paste the lists to the relevant location on the NIF. It's not likely the new lists will be shorter but verify it anyway.

5/ Update the cells the use these lists to ensure their ranges are correct. These are the input cells for section I and some columns from section II

6/ Raise the version of the NIF file (for example 0.68 -> 0.69). The cell is protected so remove protection, change and put the protection again.

7/ Save the new NIF and send it to me via email with the subject of it's name + version (ex: "NIF_PC v0.72")

Thanks

Hi!

I have add in last couple of moths, about 10,000 of banknotes to the catalog, and until now was easy to add new type of currency and i can not understand, why need to exchange some easy things in something complicated. Each time when i want to add a new currency i need to write some complicated things. I don't agree whit this. And by the way the NIF for banknotes is to old, with many missing Country and currency.

Istvan

[mozistv]

I forget to write something, pls go to:

https://colnect.com/en/banknotes/currencies

and try to go to unknown currency.

Istvan

[tcawe]

Yes, I see now it doesn't work. I'll try to fix it soon and update here when done.

I forget to write something, pls go to:

https://colnect.com/en/banknotes/currencies

and try to go to unknown currency.

Istvan

[tcawe]

Check out this new currencies post