Get short, timely messages from Canonbury Services.

Twitter is a rich source of instantly updated information. It's easy to stay updated on an incredibly wide variety of topics. Join today and follow @canonburysvcs.

Get updates via SMS by texting follow canonburysvcs to 40404 in the United States
Codes for other countries

Two-way (sending and receiving) short codes:
Country Code For customers of
Australia
  • 0198089488 Telstra
Canada
  • 21212 (any)
United Kingdom
  • 86444 Vodafone, Orange, 3, O2
Indonesia
  • 89887 AXIS, 3, Telkomsel
Ireland
  • 51210 O2
India
  • 53000 Bharti Airtel, Videocon
Jordan
  • 90903 Zain
New Zealand
  • 8987 Vodafone, Telecom NZ
United States
  • 40404 (any)

canonburysvcs

  1. How to use GM logs for forensics: The GoldMine user logs (Tools>Logs>GoldMine Logs>User Login Logs) give you a q... bit.ly/HU1vIL
  2. GoldMine contantly re-runs installer: fix: We met this on our own server and it drove us mad for a few hours. B... bit.ly/zdz9I2
  3. Add a unique reference to an import file: When importing into GoldMine it's often useful to have a unique refere... bit.ly/ylTYuM
  4. How to identify primary email addresses: It's easy enough to write a query to find email address records in Gold... bit.ly/xStXCL
  5. Script to find duplicate records: Here is a very simple SQL script that you can run in GoldMine to find duplicat... bit.ly/xgwirO
  6. Find out where your linked docs live: Here's a SQL query that will you show you a count of all the document path... bit.ly/yAnFBw
  7. iGM / iHeat and OS X Lion: If you have iGoldMine or iHeat clients who are running OS X 10.7 (Lion) then you'll n... tinyurl.com/7vtmynj
  8. Reviving lost opportunities: If you were to believe what GoldMine tells you, you'd think that once an opportunit... bit.ly/zO9R7b
  9. Where do GM+View pages live?: GM+View pages are written in HTML, and so are basically small web pages in their o... bit.ly/zsbTAC
  10. SQL query on GM group: Let's say that you've built a group and that you then want to run a query on the members ... bit.ly/tRk2l3
  11. Transferring databases between SQL versions: Some time ago I wrote about how to transfer SQL databases from a ne... bit.ly/rXU9XS
  12. Dealing with a 'referral returned...' error: Users of old versions of GoldMine or Heat on Windows Vista or Windo... bit.ly/okf0bW
  13. Rounding up durations in Crystal: I had to write an interesting formula today which I thought I'd share with the... bit.ly/pMPGey
  14. iGM 9 / iHeat 9 logon page: The new iGoldMine / iHeat is a many-splendoured thing but, like so much software the... http://bit.ly/qsCGrn
  15. Finding duplicate contact2 entries: Older versions of GoldMine sometimes created duplicate contact2 entries. T... http://bit.ly/rgz4Yv
  16. iHeat & iGM compatibility warning: Please be advised that Windows Update KB2555917, released on July12, 2011, is... http://bit.ly/r1Os5F
  17. Beating the 10,000 record SQL limit in GM: When you write a SQL query in GoldMine you are, by default, limited t... http://bit.ly/m7zC2H
  18. GoldMine 9.02 released: FrontRange have announced the latest version of GoldMine Premium Edition. It is a free u... http://bit.ly/kKHD5U
  19. SQL query on a group: A customer recently asked us to generate a query for them that would use a group as its ba... http://bit.ly/jML8AI
  20. GM Notes fields in Crystal Reports: Ever since the advent of GoldMine PE 8.5 the notes fields in the various tab... http://bit.ly/kIBANN