2017A - Spring CD catalog production

About: 2016C - FALL CD catalog production

see #CDCatalog

#1 Revise program for this production ← #Done

Change the program manually
at  http://speaktomecatalog.com/cd_catalog/  
to set the 3 variables 

# ---- Set constants for this particular run
if (empty($view))
    // note that the last statement here overrides
    $view="Full catalog and new";
    $view="Full catalog and new";
    $view="Spring Catalog";

null now shows Spring Catalog … even to guests

Note: guest view is still not free of internal production clutter !

#2 publish to iTunes channel or whatever still not done … oh well … maybe someday

#3 Record …. waiting for Jason to finish recordings

Record and upload mp3 files to the directory /cd_catalog using the format cd_XXXX.mp3 
#seeAlso email to jason  we might need to skip the 5 products that were not as yet recorded

#4  ftp all the recent recordings from
speaktomecatalog.com/cd-catalog → seth’s local mirror ← #done 

#5 in cd_catalog app click “Write Playlist”

     denise to review products and cut some so that there will be only 4 discs ← #done

For the Fall catalog move the Chrismas and Halloween to the last CDChange the class in the database to move the recording to the last cd.
re #ClassTags 
// docie-doe to do at end of year catalog
// before generation of playlist
$sql=’ UPDATE `product` SET class="xmas" where class="christmas" ’;
$sql=’ UPDATE `product` SET class="xhalloween" where class="Halloween" ’;
// after cutting cd’s switch back ←
$sql=’ UPDATE `product` SET class="Christmas" where class="xmas" ’;
$sql=’ UPDATE `product` SET class="Halloween" where class="xhalloween" ’;

#6 FTP playlists back to seth’s local

#7 Import Playlists to iTunes and Burn CDs ← #done

7 Take masters to Divirsified ← #done 

#8 Count CDs to duplicate

Enter count at bottom of labelm.prg
* Spring  CD Catalog 2017a
* counted total mailing on 4/12/2017 = 1140
* Burnt 1300 of 4 masters
* Printed those ordering in one batch counted as 1134 on 10/13/2016
* Count based upon this ...
    set filter to;
        ("c" $ media or "d" $ media);
        and not "x" $ code;
        and not "x" $ media;
        and empty(country);

#9 Upload CD files to the #fillmore phone box ← #done 

#10 Pick them up personally at Divirsified ← #done 

#11 Take off the mail bounces from last catalog ← #done 

#12  Print Labels ← #done 

* Spring  CD Catalog 2017a
* counted total mailing on 4/12/2017 = 1140
* Burnt 1300 of 4 masters
* After taking off bounces = 1123
* Printed all in one batch counted as 1123 on 1/19/2017
    set filter to;
        ("c" $ media or "d" $ media);
        and not "x" $ code;
        and not "x" $ media;

        and empty(country);
        and statusdate>{^2013-10-01}

#13  And now for the fun part ←   #done 

Stuff them in envelopes and mail the little buggers. 

#14 take them to the post office ← #done

X pieces mailed 1st class at  $1.15 (should have been $1.12) each … you do the math.
Starting from the high zip codes and working backwards … dealing with orderers  and look-e-lews alike.
432 pieces  mailed bulk (class B9) under permit 239  at  $.647 = $279.50

ok ok, i’ll do the math based upon the usps reciept for stamps …
805/1.15 = 700    we rounded up to buy $800 worth of stamps
so apparently we mailed out 420 + 700 = 1120
but we printed ……………………………...1123 labels
good enough for government work null

This puppy is finished … hoepfully the phones will start ringing now.


  1. speaktomecatalog
  2. cd catalog
  3. CDCatalog
  4. seeAlso
  5. ClassTags
  6. shucks
  7. fillmore


Seth says
how was i tagged by seth ?… i am seth and i just pushe this on top of my focus.

Seth says

null suddenly iTunes decides not to import into the playlist some selected mp3’s even though they are on the hard disk in the same directory and same coding as others that do import.

here is a link to the playlist

contacting apple support community here.

null OMG i found this … somehow the hard drisk had gotten renamed … i renamed it back to “Macantosh HD” and now the files import ok.   #shucks i have been fighting this for the last 20 hrs. 

I found the problem by making a playlist manually and exporting it and looking at the format … i could see that the location had the bogus name in it. 

Seth says

Seth says

See Also

  1. Thought 2017c Fall Print Catalog with 246 viewings related by tag "SeeAlso".
  2. Thought Producing the Practical print catalog (fall 2016) with 197 viewings related by tag "SeeAlso".
  3. Thought Download Orders From Amazon Shop (New Method) with 171 viewings related by tag "speaktomecatalog".
  4. Thought about: The #RWG - comment 67967 with 159 viewings related by tag "shucks".
  5. Thought Belief Types with 139 viewings related by tag "shucks".
  6. Thought To upload mp3 files to Fillmore box 6300 with 129 viewings related by tag "cd catalog".
  7. Thought Reseller Permit with 116 viewings related by tag "speaktomecatalog".
  8. Thought Portable Collapsable Lantern with 95 viewings related by tag "speaktomecatalog".
  9. Thought Shout Out: Stay Hydrated but keep it in your pocket with 90 viewings related by tag "speaktomecatalog".
  10. Thought Sending out Speak To Me Catalog Email Catalog with 88 viewings related by tag "ClassTags".
  11. Thought Going from Spectrum to Trinity with 86 viewings related by tag "SeeAlso".
  12. Thought 2016C - FALL CD catalog production with 86 viewings related by tag "cd catalog".
  13. Thought It Speaks For Its Self with 80 viewings related by tag "shucks".
  14. Thought (3a & 3b) SparkPost transaction that acctually dispatches a mailing with 77 viewings related by tag "shucks".
  15. Thought REPORTER with 77 viewings related by tag "shucks".
  16. Thought Eggs Florentine with 61 viewings related by tag "shucks".
  17. Thought BlackListt speaktomecatalog.com ... get speaktomecatalog off the list with 57 viewings related by tag "speaktomecatalog".
  18. Thought SENTRY3 - Active Call Blocker 3.0 with 50 viewings related by tag "speaktomecatalog".
  19. Thought Shout Out: Trump is back by popular demand ! (2017-01-17) with 50 viewings related by tag "speaktomecatalog".
  20. Thought 2017c - Fall CD catalog production with 48 viewings related by tag "cd catalog".
  21. Thought Traditional Christmas dinner 2016 with 45 viewings related by tag "speaktomecatalog".
  22. Thought #shucks with 41 viewings related by tag "shucks".
  23. Thought Luther's Table with 40 viewings related by tag "shucks".
  24. Thought about: GitHub - sait/vfpjson: Json encoder and decoder for VFP Visual Fox Pro with 36 viewings related by tag "shucks".
  25. Thought 1612a with 35 viewings related by tag "speaktomecatalog".
  26. Thought [title (20177)] with 30 viewings related by tag "SeeAlso".
  27. Thought Google Campaign with 26 viewings related by tag "speaktomecatalog".
  28. Thought hey what happened to my thought? with 20 viewings related by tag "shucks".
  29. Thought Marketing Stratagies for Speak To Me Catalog with 20 viewings related by tag "speaktomecatalog".
  30. Thought Footer problem on individual page at speaktomecatalog.com with 19 viewings related by tag "speaktomecatalog".
  31. Thought Improving Speak To Me Catalog's status on Amazon with 16 viewings related by tag "speaktomecatalog".
  32. Thought XPOWER - Smart and Slim Power Bank for Smartphone with 14 viewings related by tag "speaktomecatalog".
  33. Thought Tostada with 14 viewings related by tag "speaktomecatalog".
  34. Thought Outbound Email Server for Speak to me Catalog Postage of Orders with 14 viewings related by tag "speaktomecatalog".
  35. Thought about: Producing the Practcal print catalog (fall 2015) with 12 viewings related by tag "speaktomecatalog".
  36. Thought about: naughty santa mug from speak to me catalog with 11 viewings related by tag "speaktomecatalog".
  37. Thought renewal of ssl certificate for www.speaktomecatalog.com with 9 viewings related by tag "speaktomecatalog".
  38. Thought Promotions in the Speak To Me Catalog Shopping Basket with 8 viewings related by tag "speaktomecatalog".
  39. Thought Talking Trump Bear by Nika with 7 viewings related by tag "speaktomecatalog".
  40. Thought Speak To Me World with 7 viewings related by tag "speaktomecatalog".
  41. Thought Trying to find a current Source for this product ... with 7 viewings related by tag "speaktomecatalog".
  42. Thought I want to collect email subscriptions to our news leter .. with 6 viewings related by tag "speaktomecatalog".
  43. Thought about: how to make a pinterest pin button? with 5 viewings related by tag "speaktomecatalog".
  44. Thought A Speak To Me Catalog desire ... with 4 viewings related by tag "speaktomecatalog".
  45. Thought New Print Catalogs by Niche with 4 viewings related by tag "speaktomecatalog".
  46. Thought Coupon 1604a - Talk about those special times coming ... with 3 viewings related by tag "speaktomecatalog".
  47. Thought #CDCatalog with 3 viewings related by tag "cd catalog".
  48. Thought Coupon 1602a "Free shipping on Valentine page" with 3 viewings related by tag "speaktomecatalog".
  49. Thought Coupon 1602b ... for president's day with 3 viewings related by tag "speaktomecatalog".
  50. Thought Purchace a new LP2844 with 1 viewings related by tag "speaktomecatalog".