pattrickcolin

On 10/20/2019 at 3:30 PM, admin said:

Hi, ok we can add these for the next free update.  The reason we don't let users add the country is because it can lead to the same country having 2 separate  unique number ids.  This would cause problems later on.

Hi

Stamp Manage does not store the Country Name for each database entry but uses a CountryID number.

Each country issues different types of stamps e.g. General Issue, Air Postage, Postage Due, etc. So there is a Stamp Manage TypeID for this. This TypeID for Air Postage is a different ID for every country, likewise General Issue, Postage Due etc.

The Stamp Manage database uses CountryID and TypeID to help sort the database, before the correct allocation of the Scott number.

Sorry a batch import into Stamp Manage is not possible as each image in your database would need the Scott Number added. To complicate your problem still further, the Scott Number has to be imported as a Text style Number and it also needs importing as Suffix+number+prefix (Suffix and prefix as Text, and Number as numeric)

Email me if you want      colinATcolinpattrickDOTcom

I can give you guidance on making your image Files into a Database.

Jeff.

I was referring to Year Issued, as appertaining to when the Set was issued. Some Sets (definatives) are issued over a number of years e.g 1920-1923. Whereas Date issued shows exact date of issue. To keep sets together within the database, it is not correct to just use the year field extracted from DATE Issued.

A year purchased field is only applicable to an individual purchaser, and not of any use to the SM world.

I do agree that YEAR is not clearly defined, within SM.

Here is the link to my 3,550+ "Netherlands" Stamp Images with SMCountryID of 677. Its a Big download but it runs in he background.

677 Netherlands Images = https://ln.sync.com/dl/cd156b890/5dqr9usg-s9mxjc85-qyzy768q-k3kr8957

The link will load into a folder "Sync/677". Be aware that this is a live feed to my Netherlands images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/677" folder into "Stamp Manage Images/677" because if I discontinue the link you will also lose the images.

The images are freely available for anyone to download.

Regards colinATcolinpattrickDOTcom

P.S.Thank you for your emails appreciating these downloads

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

Yes I agree. Date & Year should be seperate. Date seems okay but Year is a mess within the database. Agree Year should be a 'short text' field as one needs to enter year spans (1860-1862).

But this has not stopped the Misuse of this field.

Year field should be Year only The rejection of entries NOT 'numeric' or '-' should be built into the database.

On 2/4/2019 at 5:57 PM, maineiac13 said:

Your image is correct, but is described by Scott as "Perf 10 Vertically."

Cannot blame SM for this Scott erroneous descrption

 To DrGaryG and Cliff

My Image of Scott 656 shows a Horizontal Coil. Q Is this correct?

From colinATcolinpattrickDOTcom

Here is the link to my 160+ "United States - Hawaii" Stamp Images with CountryID of 559. Its a small download but it runs in he background.

The link will load into a folder "Sync/559". Be aware that this is a live feed to my Hawaii images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/559" folder into "Stamp Manage Images/559" because if I discontinue the link you will also lose the images.

The images are freely available for anyone to download.

Regards colinATcolinpattrickDOTcom

PS If you missed prevous Links then here is a list. I've just done a big upload of Italy Images to the same Link.

Hi Ray

Q1

https://acronyms.thefreedictionary.com

This link has 158 different suggestions for what SSP stands for

This Link has 36 different suggestions for what APU stands for

Sorry I don't know the answer.

Q2

Don't know the answer either. One would need a specialist catalouge and I don't have access to one.

Great Stamp collecting, sorry couldn't help

colinATcolinpattrickDOTcom

I changed all my preferances to singular names General Issue, Air Mail for the ¾million records in my Database. Still awaiting, yawn, a reply wether SM is interested in purchasng it. (A rejection is acceptable)

All Unique records, all similar to S.M, The majority with year dates. The majority with denominations. Samples sent of database that you have acknowledged receiving. Are you interested still with purchasing? From colinATcolinpattrickDOTcom

11 hours ago, Guest Mozambique Company images said:

Did you discontinue this feed, as there is no link in your post.

Sorry Typed up the message and just forgot to include the Link. Now rectified. Happy New Year All. From colinATcolinpattrickDOTcom

Hi Marios Theodossiou

Here is the link to my 240+ Mozambique Company Images. The download runs in the background.

"662" Mozambique Company Images =https://ln.sync.com/dl/ee459f780/an8igsrd-rvw8qmjq-btbq87ck-tj6fu7w7

The link will load into a folder "Sync/662". Be aware that this is a live feed to my Mozambique Company Images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/662" folder into "Stamp Manage Images/662" Folder because if I discontinue the link you will also lose the images..

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download

Pierre. As promised a link to my France Stamp Images

Here is the link to my 5,100+ France Stamp Images. The download runs in the background.

"504" France Images =https://ln.sync.com/dl/600d30ce0/69dxfpb3-ik762mqj-tqaydhey-2j2s49cc

The link will load into a folder "Sync/504". Be aware that this is a live feed to my France images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/504" folder into "Stamp Manage Images/504" Folder because if I discontinue the link you will also lose the images.

Pierre be aware that this is a large file that loads in the background, the time taken is dependant on how many users are using the link. Still not heard from SM if they wish to purchase the ¾million database. Have a good Christmas.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download

Hi

You have to have the Scott Number (plus a,b,c below) for each stamp before you can import ( or copy and Paste to Stamp Manage).  From the print out shown you have Stanley Gibbons numbers only.

To enable an import (or copy and paste) into the database one needs

a)the CountryID for New Caladonia to be set to 684

b)the TypeID of stamp e.g General Issue = 20812 to be entered (Postage Due, Airmail etc have different TypeID numbers)

c) the Unique Scott Number needs to be included in the data base.

ab&c have to be UNIQUE for each stamp, prior to a copy and paste into the database.

c) Your list suggests that the Scott Number has NO Prefix or suffix, (e.g Both Blank Fields) which makes it slightly easier to import (or copy & Paste). However c) the UNIQUE Scott Number needs to appear firstly as combined TEXT (Prefix+Number+Suffix) Format. Secondly the Scott Number then needs to appear as Three seperate fields(Prefix+Number+Suffix) with Prefix & Suffix as Text Fields and the Number as a NUMBER field within the SM Database.

This is minimum requirement to import (or copy and Paste to Stamp Manage)

If you wish to Email me a Excel copy of the 246 records, I'll have a crack at conversion to Stamp Manage.

From colinATcolinpattrickDOTcom

with ¾million Unique Database Records

This includes 825+ New Caladonia Images which I will supply a link in the next few days.

My New Caladonia database has 1500+ records with denominations, plus other fields. S its worth a crack

Here is the link to my 4,700+ "Spain" Stamp Images. If you have previously used this Spain link then the images will automatically be download to your computer.(It is the same Link) A big thankyou to those who sent me additional images.

"202"  Images =https://ln.sync.com/dl/5fce87020/zv5s7yh8-kwz8qsrg-njieek24-brzq4ije

The link will load into a folder "Sync/202". Be aware that this is a live feed to my Spain  images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/202" folder into "Stamp Manage Images/202" because if I discontinue the link you will also lose the images.

I am preparing a copy of my database for Stamp Manage.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download.

Not a very popular country

Here is the link to my 150+ "Fiume" Stamp Images. Its a small download but it runs in he background.

"503" Fiume Images =https://ln.sync.com/dl/aa47619a0/8qcq3nrh-duh9iagf-95irhrd4-qst4n567

The link will load into a folder "Sync/503". Be aware that this is a live feed to my Fiume  images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/503" folder into "Stamp Manage Images/503" because if I discontinue the link you will also lose the images.

I am preparing a copy of my database for Stamp Manage.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download.

Here is the link to my 400+ "Finland-Aland Islands" Stamp Images. Its a small download but it runs in he background.

"356" Finland-Aland Islands Images =https://ln.sync.com/dl/13bf201d0/ap9gcmns-k5pcu3g4-ukx7ah8a-h6hc4ns8

The link will load into a folder "Sync/356". Be aware that this is a live feed to my Finland-Aland Island images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/356" folder into "Stamp Manage Images/356" because if I discontinue the link you will also lose the images.

I am preparing a copy of my database for Stamp Manage.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download.

Here is the link to my 2160+ Finland Stamp Images. Its a big download but it runs in he background.

"502" Finland Images =https://ln.sync.com/dl/505fed8a0/aqhmaatn-67qed69c-vag48j9u-ju5tf4fy

The link will load into a folder "Sync/502". Be aware that this is a live feed to my Finland images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/502" folder into "Stamp Manage Images/502" because if I discontinue the link you will also lose the images.

I am preparing a copy of my database for Stamp Manage.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download.

Here is the link to my 1420+ Fiji Stamp Images. Its a big download but it runs in he background.

"501" Fiji Images = https://ln.sync.com/dl/1d56b4970/nbz5ns3u-grwsyxe3-5um8fdhw-c8ehf9hn

The link will load into a folder "Sync/501". Be aware that this is a live feed to my Fiji images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/501" folder into "Stamp Manage Images/501" because if I discontinue the link you will also lose the images.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download.

=Scott 1687

DrGaryG. Would it be possible to scan the correct images? 

Hi. Surely a Stampless cover is Unique.

It has diffent dates, markings, addressees, sent from fields, etc.

But its Unique. One could have all the joy of looking up the database, knowing that their unique cover would not be there (Unless one had added their own limited covers, to the database)

Stamp Manage is not suited to a Stampless Collection of Unique Covers, in my opinion.

Here is the link to my 1820+ Indonesia Stamp Images. Its a big download but it runs in he background.

"20" Indonesia Images = https://ln.sync.com/dl/507594bb0/q2ze8ywc-54xry9js-v6ebxyc7-njjcrrkg

The link will load into a folder "Sync/20". Be aware that this is a live feed to my Indonesia images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/20" folder into "Stamp Manage Images/20" because if I discontinue the link you will also lose the images.

Regards colinATcolinpattrickDOTcom

P.S. The images are freely available for anyone to download.