Jump to content

pattrickcolin

Members
  • Content Count

    52
  • Joined

  • Last visited

  • Days Won

    6

pattrickcolin last won the day on February 10

pattrickcolin had the most liked content!

About pattrickcolin

  • Rank
    Advanced Member

Recent Profile Visitors

420 profile views
  1. 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.
  2. 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.
  3. 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. SMCountry ID Country Name LINK 559 United States-Hawaii https://ln.sync.com/dl/3f8bd77b0/w25kzsvm-hwdsss5i-zx62yvem-6emxzqr5 662 Mozambique Company https://ln.sync.com/dl/ee459f780/an8igsrd-rvw8qmjq-btbq87ck-tj6fu7w7 504 France https://ln.sync.com/dl/600d30ce0/69dxfpb3-ik762mqj-tqaydhey-2j2s49cc 684 New Caladonia https://ln.sync.com/dl/57287c260/3w7bs7q9-7pcvpbb7-y492ssym-5adeevkq 502 Finland https://ln.sync.com/dl/505fed8a0/aqhmaatn-67qed69c-vag48j9u-ju5tf4fy 202 Spain https://ln.sync.com/dl/5fce87020/zv5s7yh8-kwz8qsrg-njieek24-brzq4ije 503 Fiume https://ln.sync.com/dl/aa47619a0/8qcq3nrh-duh9iagf-95irhrd4-qst4n567 356 Finland-Aland Islands https://ln.sync.com/dl/13bf201d0/ap9gcmns-k5pcu3g4-ukx7ah8a-h6hc4ns8 501 Fiji https://ln.sync.com/dl/1d56b4970/nbz5ns3u-grwsyxe3-5um8fdhw-c8ehf9hn 20 Indonesia https://ln.sync.com/dl/507594bb0/q2ze8ywc-54xry9js-v6ebxyc7-njjcrrkg 36 Italy https://ln.sync.com/dl/e5827d500/x9qxsd4p-gejvr5di-tvdmphwc-p7wppnq2 57 Malaya States - Jedah https://ln.sync.com/dl/fd1280350/7qwq4tww-tprxgwk7-xanabz7e-49gc9255 51 Malaya States - Johore https://ln.sync.com/dl/183dbc030/y932s5ik-athu5urf-avx285g7-3fpj3ihd 202 Spain https://ln.sync.com/dl/5fce87020/zv5s7yh8-kwz8qsrg-njieek24-brzq4ije 121 Malaya States - Sabah https://ln.sync.com/dl/6869849d0/f3msga74-qssxg6nc-a4jz2cqk-7pu28i5d
  4. 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.
  5. Cannot blame SM for this Scott erroneous descrption
  6. To DrGaryG and Cliff My Image of Scott 656 shows a Horizontal Coil. Q Is this correct? From colinATcolinpattrickDOTcom
  7. 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. 559 United States-Hawaii https://ln.sync.com/dl/3f8bd77b0/w25kzsvm-hwdsss5i-zx62yvem-6emxzqr5 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. Country ID Country Name LINK 559 United States-Hawaii https://ln.sync.com/dl/3f8bd77b0/w25kzsvm-hwdsss5i-zx62yvem-6emxzqr5 662 Mozambique Company https://ln.sync.com/dl/ee459f780/an8igsrd-rvw8qmjq-btbq87ck-tj6fu7w7 504 France https://ln.sync.com/dl/600d30ce0/69dxfpb3-ik762mqj-tqaydhey-2j2s49cc 684 New Caladonia https://ln.sync.com/dl/57287c260/3w7bs7q9-7pcvpbb7-y492ssym-5adeevkq 502 Finland https://ln.sync.com/dl/505fed8a0/aqhmaatn-67qed69c-vag48j9u-ju5tf4fy 202 Spain https://ln.sync.com/dl/5fce87020/zv5s7yh8-kwz8qsrg-njieek24-brzq4ije 503 Fiume https://ln.sync.com/dl/aa47619a0/8qcq3nrh-duh9iagf-95irhrd4-qst4n567 356 Finland-Aland Islands https://ln.sync.com/dl/13bf201d0/ap9gcmns-k5pcu3g4-ukx7ah8a-h6hc4ns8 501 Fiji https://ln.sync.com/dl/1d56b4970/nbz5ns3u-grwsyxe3-5um8fdhw-c8ehf9hn 20 Indonesia https://ln.sync.com/dl/507594bb0/q2ze8ywc-54xry9js-v6ebxyc7-njjcrrkg 36 Italy https://ln.sync.com/dl/e5827d500/x9qxsd4p-gejvr5di-tvdmphwc-p7wppnq2 57 Malaya States - Jedah https://ln.sync.com/dl/fd1280350/7qwq4tww-tprxgwk7-xanabz7e-49gc9255 51 Malaya States - Johore https://ln.sync.com/dl/183dbc030/y932s5ik-athu5urf-avx285g7-3fpj3ihd 202 Spain https://ln.sync.com/dl/5fce87020/zv5s7yh8-kwz8qsrg-njieek24-brzq4ije 121 Malaya States - Sabah https://ln.sync.com/dl/6869849d0/f3msga74-qssxg6nc-a4jz2cqk-7pu28i5d
  8. 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
  9. 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)
  10. 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. Sorry Typed up the message and just forgot to include the Link. Now rectified. Happy New Year All. From colinATcolinpattrickDOTcom
  12. 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
  13. 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
  14. Report post Posted October 10 Here is the link to my 825+ New Caladonia Stamp Images. The download runs in the background. "684" New Caladonia Images =https://ln.sync.com/dl/57287c260/3w7bs7q9-7pcvpbb7-y492ssym-5adeevkq The link will load into a folder "Sync/684". Be aware that this is a live feed to my New Caladonia images. As I add more images these will automatically be added. You are advised to copy and paste the "Sync/684" folder into "Stamp Manage Images/684" 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
  15. 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
×
×
  • Create New...