pattrickcolin

"space bar" then "duplicates" also works

"I have many covers in my collection with more than one stamp variety on the cover.  I am interested in entering these covers into Stamp Manage that would allow me to reference the varieties.  Does anyone have suggestions on how to do this?"

• It would be  an unworkable Database, due to size.
• Since 1940 'Gilbert And Ellice Islands' have issued 200+ General issue stamps.
• Disregarding different postmarks, each of these covers could include 1p Postage Due Stamp making 400+ Total Covers Database.
• The Covers Database needs to include any one of the 8 different Postage Due Stamps making a 1,600+ Total Covers Database

---------------------------------

So how many combinations of 10 stamps can one find from 200+ stamps issued is:-

22,451,004,309,013,280 unique covers of which your example is one of them. I accept that some examples would not exist, but which ones would you not want included? Also there are covers with duplicated pairs, etc. with other stamps. Where would you stop?

-------------------------

With my current database of 800,000 Scott records and 450,000 images and previously studied Statistics, permutations and combinations, I understand the problem really well.

Regards colinATcolinpattrickDOTcom

Hi

What United Nations Country? and the data for the stamp and correct image would be helpful

Hi mipalmers

Madgascar was under British Rule 1885-1886.

After 1886 it was under French Rule. Stamps from Madagascar are found under "Malagasy Republic"

Hope this helps

Colin Pattrick

I also got frustrated with SM and went over to Access for Editing/Updating Data. if you wish to make contact. colinATcolinpattrickDOTcom

India - Feudatory States - Jasdan appears on page 1156 of the 2017 catalouge. They only issued one stamp Scott 1 the image for it appears below

Nancy.

If you want to send a 'representative sample from your excel spreadsheet/s', say 100 records, I'll have a go of Uploading them to SM.

If a few can be done, then all can be done.

From Colin Pattrick

email :-    colin@colinpattrick.com

NO. You are trying to sort on a 'Text' field (Scott#).

SM stores the Scott Number in two formats within the Access Database. The first format it stores the Full Scott Number as a 'Text' field (this is the field you are trying to Sort on). The second format within the Access Database it stores the Full Scott Number as 3 fields (Prefix, Number & Suffix). It is Number that is a Numeric Field and will sort the way you want.

I am uncertain whether the 2nd format can be viewed within the Report you are generating.

Hope this helps.

Regards colin@colinpattrick.com

In Scott World Catalouges 1-6 the Scott design number represents the Images appearing. Each image is a representative sample  of a group of stamps. So for Jersey image "A109 Europa 1990" it represents a group of stamps Scott532 to Scott535 e.g. Europa Issues. The image displayed is for the third image in this set of four, namely the 24p stamp.

Hope that explains it.

Happy New Year and wishing you Hope.

Colin

No, you cannot simultaneously and always update your copy of SM. The SM Programming and the database are combined in Access.mdb.

Its not impossible, but difficult to do, to import a Excel/CSV into Excel Format that Stamp Manage Database understands.

If you email me a selection of your Excel file I can offer you some help.

Regards Colin Pattrick

colinATcolinpattrickDOTcom

This is because when you have a Country it can contain different Types of Stamps, (such as General Issue, Airmail,  Postage due etc ). These categories or Types (as SM calls them), of stamps have different TypeID numbers tied to the CountryID.

It is possible to set up  "General Issues" and "general issues" for the same Country and these would have different TypeID's and be in different categories/types, like airmail and postage due.

Q. What Country are you referring to? as I am unaware of any single Country with this situation.

Agree there should be conformity with names of different categories/types.

With regards to merging. This is is not a simple copy and paste exercise. 

If you contact me direct i can try to help.

colinATcolinpattrickSOTcom

a)The Scott number for the Machin stamp has to be in the database.

b)The Scott numbered stamp image for your Machin stamp has to be in the image file under folder '545'

i have a database of 627 Machin Images. These can be downloaded by clicking on the links below.

They will download into four files 1048,1049,1050 and 1051. The contents can be copied and pasted to folder 545

https://ln2.sync.com/dl/bcacad4c0/ftsxfrz9-q22gp6mb-fdg5ps8w-huk5p3r3

https://ln2.sync.com/dl/bb0fa5160/qadmrkyy-azcvpv7z-wuridn9p-7d6t8gie

https://ln2.sync.com/dl/1171fe080/myy752vu-3sasdyr8-2dqjrprg-gizva7f7

https://ln2.sync.com/dl/715d9f180/dvfqwz5b-6f5vhngx-sbtiq98d-g7pre4a7

Hope it helps

As a generalization Within SM image file CountryID 765, then inages from 3,900 to 4,900 need change the 4 to a 3 as you say, but many images thereafter need to delete 1 from the Scott number.

I have covered Poland to Scott 4000 images:-

https://ln2.sync.com/dl/22f4d3e40/mxugf933-unsyu8dg-7x64rmg8-ng5ft2aa

However the file 765 is incomplete for images over Scott 5000

regards Colin

To Dave

You are correct in that Stamp Manage has two listings for Isle of Man, namely Id900 and id620. You should use one, or the other code.

Images that you add to one file do NOT automatically appear in the other listing. 

I just suggest that id900 is the id of choice.

Here is a Link to my Isle of Man Stamp Images. 

 ISLE OF MAN 2,500 + Images ID 900 

 If you copy/paste the link into your browser, the images will be displayed on your screen. There is a onscreen 'download button' if you wish to download the images. The images will download into a folder called "Sync/ColinsStampImages" with a file name as "CountryID". This is a live feed to my Images. You are advised to copy/Paste these images into your Stamp Manager Image Folder, using the same ‘Countryid’ file name.

There is no charge for the download('s) but the link does cost me. A Donation of £5 per country (0r 5,000 images) in any currency would be gratefully accepted and would allow the expansion of this service.  https://paypal.me/StampImages

Please email me with your next request for a country, or for any queries you may have.

Regards ColinATcolinpattrickDOTcom

Here is the link to my 1000+ "Armenian" Stamp Images with CountryID of 385. The download will run in the background.

The link will load into a folder "Sync/385". Be aware that this is a live feed to my Armenia images. As I add/edit more images these will automatically be added. You are advised to copy and paste the "Sync/385" folder into "Stamp Manage Images/385" because if I discontinue the link you will also lose the images. (I'm on a pension, the link stays LIVE whilst I fund it)

The images are freely available for anyone to download.

The World Collection of Stamps is a BIG download. This can be found here.

https://ln2.sync.com/dl/6d913a800/5g3xm4r2-6zhcz2yf-78ja4f9x-bayuwmx3

Regards colinATcolinpattrickDOTcom

P.S. Cliff My Armenia collection of Images is poor for the Early Overprints

Here is a Link to my World Image Database. It contains 344,500+ Images, all using Scott Numbers and held in Folders, similar to Stamp Manage.

The download will run in the background. (It takes a long time to download!)

The link will load into a folder "Sync/Colins Stamp Images".

Be aware that this is a live feed to all My World Stamp Images. As I add/edit more images these will automatically be added. You are advised to copy and paste the "Sync/Colins stamp Images" folders into “Stamp Manage Images”/folders because if I discontinue the link you will also lose the images, within “Colins Stamp Images” (I'm on a pension, the link stays LIVE whilst I fund it)

The images are freely available for anyone to download.

Thank you to all those that requested other countries, thought it easier to give you access to all countries.

Please email me.

Regards colinATcolinpattrickDOTcom

When I first started my database I used the above Ctry ID and Type ID. (Copied from Stamp Manage)

Whilst North Vietnam is fairly tidy in the SM database, this is not true for Vietnam & South Vietnam.

Vietnam only exists on Country ID 304 with nothing in the Varieties database and no image file set up.

Whilst  South Vietnam uses Country ID 305, it uses Type ID 21200, 29800 and 31313 all for GENERAL issue stamps in Varieties Table. Should all use a single Type ID.

Also lots of Varieties having Scott numbers over 516 in Varieties Table and in the image Folder for Country ID 305. Scott numbers finish at 516.

Hope it helps

ColinATcolinpattrickDOTcom

Here is the link to my 500+  "Vietnam, Republic of South Vietnam" Stamp Images with CountryID of 306. The download will run in he background. (Scott 27 to Scott 516)

The link will load into a folder "Sync/306". Be aware that this is a live feed to my Vietnam, Republic of South Vietnam images. As I add/edit more images these will automatically be added. You are advised to copy and paste the "Sync/306" folder into "Stamp Manage Images/306" because if I discontinue the link you will also lose the images. (I'm on a pension, the link stays LIVE whilst I fund it)

The images are freely available for anyone to download.

Regards colinATcolinpattrickDOTcom

P.S. Stamp Manage Image File ID "306" currently contains a number of incorrect images, these being North Vietnam ID 305, these need to be removed

PPS If you missed previous Links then here is a list.

                       304 Vietnam                              https://ln2.sync.com/dl/a93a5ce60/cub7eihm-uew7j9yf-g2vtz87c-d7uvfsev

                       306 Vietnam, Republic of South Vietnam https://ln2.sync.com/dl/f02cc9a40/ef9ti4ca-2b5gihug-apwvzq4i-ptcyy6jj

Here is the link to my 26 "Vietnam" Stamp Images with CountryID of 304. The download will run in he background.

The link will load into a folder "Sync/304". Be aware that this is a live feed to my Vietnam images. As I add/edit more images these will automatically be added. You are advised to copy and paste the "Sync/304" folder into "Stamp Manage Images/304" because if I discontinue the link you will also lose the images. (I'm on a pension, the link stays LIVE whilst I fund it)

The images are freely available for anyone to download.

Regards colinATcolinpattrickDOTcom

P.S. 304 Vietnam is in the Stamp Manage Database, but you will need to create a Stamp Manage Image Folder, "304" and then copy & paste

PPS If you missed previous Links then here is a list.

                       304 Vietnam                              https://ln2.sync.com/dl/a93a5ce60/cub7eihm-uew7j9yf-g2vtz87c-d7uvfsev

                       306 Vietnam, Republic of South Vietnam (To Follow)

Vietnam was a single country ruled by Chinese and French. Scott 1-26. The country was split into the two:-

a)Vietnam  South, (Republic of Viet Nam)        Scott 27 onwards

b)Vietnam North (Democratic Republic of )      Scott 1 onwards

"Marg" Bit of a simplistic answer. But hope it helps. Didn't want to ramble on with the full version.

Here is the link to my 5300+ "Belgium" Stamp Images with CountryID of 427. The download will run in he background.

The link will load into a folder "Sync/427". Be aware that this is a live feed to my Belguim images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/427" folder into "Stamp Manage Images/427" because if I discontinue the link you will also lose the images. (I'm on a pension, the link stays LIVE whilst I fund it)

The images are freely available for anyone to download.

Regards colinATcolinpattrickDOTcom

PS If you missed previous Links then here is a list.

Here is the link to my 3900+ "Portugal" Stamp Images with CountryID of 782. The download will run in he background.

The link will load into a folder "Sync/782". Be aware that this is a live feed to my Portugal images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/782" folder into "Stamp Manage Images/782" because if I discontinue the link you will also lose the images. (I'm on a pension, the link stays LIVE whilst I fund it)

The images are freely available for anyone to download.

Regards colinATcolinpattrickDOTcom

PS If you missed previous Links then here is a list.

El Salvador has two CountryID

Isle of Man also has two CountryID