2016C - FALL CD catalog production
About: 2015C - CD catalog production
see #CDCatalog
#2 publish to iTunes channel or whatever still not done … oh well … maybe someday
#seeAlso email to jason
based upon a count (same criteria as last april) we decided to cut 1400 based upon a count of 1260.
wait for them … wait for them …. #done … pick them up at 2PM today
#done

Stuff them in envelopes and mail the little buggers.
#done #kudos → denise

Take them to the post office
#done

and finally since we got the catalog out another year …. treat ourselves to a nice dinner out … be treated like the king and queeen that we are
← clam chowder with a whipped mango juice at #BahamaBreeze


Somtimes i think i am almost too comfortable
#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
$Year="2016";
$VolumLetter="c";
if (empty($view))
{
// note that the last statement here overrides
$view="Full catalog and new";
$view="Spring Catalog";
$view="Full catalog and new";
}

now shows Full catalog and new … even to guests
Note: guest view is still not free of internal production clutter !
# ---- Set constants for this particular run
$Year="2016";
$VolumLetter="c";
if (empty($view))
{
// note that the last statement here overrides
$view="Full catalog and new";
$view="Spring Catalog";
$view="Full catalog and new";
}


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 #Done
Record and upload mp3 files to the directory /cd_catalog using the format cd_XXXX.mp3#seeAlso email to jason
# 4 in cd_catalog app click “Write Playlist” in full catalog view
denise to review products and cut some so that there will be only 4 discs ← #done
seth to edit audio on selected products to add demos and changes prices ← #done
# 5 For the Fall catalog move the Chrismas and Halloween to the last CD
Change the class in the database to move the recording to the last cd.
#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 ← #done
$sql=’ UPDATE `product` SET class="Christmas" where class="xmas" ’;
$sql=’ UPDATE `product` SET class="Halloween" where class="xhalloween" ’;
// 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 ← #done
$sql=’ UPDATE `product` SET class="Christmas" where class="xmas" ’;
$sql=’ UPDATE `product` SET class="Halloween" where class="xhalloween" ’;
based upon a count (same criteria as last april) we decided to cut 1400 based upon a count of 1260.
- denise can pre-audit the file over on the server in cd_catalog prior to burning or the CDs themselves after burning ... her choice.
- We can even extend the procedure to say, hand deliver the masters to http://www.fastblogit.com/tags/diversified%20systems ← done
- Calculate the number of CDs to produce … calculate and consult history in denise/tome/mlabel.prg tthen tell diversified how many to cut. ← done … going to cut 1300 of the 4 masters
- wait for them wait for them …
- pick then up
- label, stuff, and bulk mail them.
7 Take masters to Divirsified and …
wait for them … wait for them …. #done … pick them up at 2PM today

8 Print Labels #done
****************************************************
* Fall CD Catalog 2016c
* counted total mailing on 10/13/2016 = 1269 - did not move date up from previous
* Burnt 1400 of 4 masters
*
* Printed those ordering in one batch counted as 1134 on 10/13/2016
thismail="#v"
set filter to;
("c" $ media or "d" $ media);
and not "x" $ code;
and not "x" $ media;
and empty(country);
and not empty(order_date);
and statusdate>{^2012-10-01}
* Printed those NOT ordering in one batch counted as 135 on 10/13/2016
thismail="#w"
set filter to;
("c" $ media or "d" $ media);
and not "x" $ code;
and not "x" $ media;
and empty(country);
and empty(order_date);
and statusdate>{^2012-10-01}
* Fall CD Catalog 2016c
* counted total mailing on 10/13/2016 = 1269 - did not move date up from previous
* Burnt 1400 of 4 masters
*
* Printed those ordering in one batch counted as 1134 on 10/13/2016
thismail="#v"
set filter to;
("c" $ media or "d" $ media);
and not "x" $ code;
and not "x" $ media;
and empty(country);
and not empty(order_date);
and statusdate>{^2012-10-01}
* Printed those NOT ordering in one batch counted as 135 on 10/13/2016
thismail="#w"
set filter to;
("c" $ media or "d" $ media);
and not "x" $ code;
and not "x" $ media;
and empty(country);
and empty(order_date);
and statusdate>{^2012-10-01}
# 9 And now for the fun part …

Stuff them in envelopes and mail the little buggers.
#done #kudos → denise

Take them to the post office
#done

and finally since we got the catalog out another year …. treat ourselves to a nice dinner out … be treated like the king and queeen that we are
← clam chowder with a whipped mango juice at #BahamaBreeze


Somtimes i think i am almost too comfortable

Tags
- speaktomecatalog
- cd catalog
- CDCatalog
- seeAlso
- kudos
- BahamaBreeze
- ClassTags
Comments
Seth says
how was i tagged by seth ?… i am seth and i just pushe this on top of my focus.
how was i tagged by seth ?… i am seth and i just pushe this on top of my focus.
See Also
- Thought Well here i am back in this reality with 312 viewings related by tag "kudos".
- Thought 2017c Fall Print Catalog with 246 viewings related by tag "SeeAlso".
- Thought 2017A - Spring CD catalog production with 228 viewings related by tag "cd catalog".
- Thought Producing the Practical print catalog (fall 2016) with 197 viewings related by tag "SeeAlso".
- Thought Download Orders From Amazon Shop (New Method) with 171 viewings related by tag "speaktomecatalog".
- Thought To upload mp3 files to Fillmore box 6300 with 128 viewings related by tag "cd catalog".
- Thought Reseller Permit with 116 viewings related by tag "speaktomecatalog".
- Thought Go Mark! with 102 viewings related by tag "kudos".
- Thought Portable Collapsable Lantern with 95 viewings related by tag "speaktomecatalog".
- Thought Going from Spectrum to Trinity with 86 viewings related by tag "SeeAlso".
- Thought Making up Others with 85 viewings related by tag "kudos".
- Thought Sending out Speak To Me Catalog Email Catalog with 85 viewings related by tag "ClassTags".
- Thought Shout Out: Stay Hydrated but keep it in your pocket with 84 viewings related by tag "speaktomecatalog".
- Thought BlackListt speaktomecatalog.com ... get speaktomecatalog off the list with 57 viewings related by tag "speaktomecatalog".
- Thought Amazon's Buy Box Games with 52 viewings related by tag "kudos".
- Thought Shout Out: Trump is back by popular demand ! (2017-01-17) with 50 viewings related by tag "speaktomecatalog".
- Thought SENTRY3 - Active Call Blocker 3.0 with 48 viewings related by tag "speaktomecatalog".
- Thought 2017c - Fall CD catalog production with 48 viewings related by tag "cd catalog".
- Thought Traditional Christmas dinner 2016 with 45 viewings related by tag "speaktomecatalog".
- Thought Fo Hammer popped up at the FBI today. with 43 viewings related by tag "kudos".
- Thought 1612a with 35 viewings related by tag "speaktomecatalog".
- Thought [title (20177)] with 27 viewings related by tag "SeeAlso".
- Thought Google Campaign with 26 viewings related by tag "speaktomecatalog".
- Thought Marketing Stratagies for Speak To Me Catalog with 20 viewings related by tag "speaktomecatalog".
- Thought Footer problem on individual page at speaktomecatalog.com with 19 viewings related by tag "kudos".
- Thought Meatloaf with 17 viewings related by tag "kudos".
- Thought Lovely tag cloud! with 16 viewings related by tag "kudos".
- Thought Improving Speak To Me Catalog's status on Amazon with 16 viewings related by tag "speaktomecatalog".
- Thought Bookmarks Love with 15 viewings related by tag "kudos".
- Thought XPOWER - Smart and Slim Power Bank for Smartphone with 14 viewings related by tag "speaktomecatalog".
- Thought Tostada with 14 viewings related by tag "speaktomecatalog".
- Thought Outbound Email Server for Speak to me Catalog Postage of Orders with 14 viewings related by tag "speaktomecatalog".
- Thought about: how it works - ideabuzz with 13 viewings related by tag "kudos".
- Thought about: Producing the Practcal print catalog (fall 2015) with 12 viewings related by tag "speaktomecatalog".
- Thought Probably the most pertinant speech yet this century with 11 viewings related by tag "kudos".
- Thought about: naughty santa mug from speak to me catalog with 11 viewings related by tag "speaktomecatalog".
- Thought OMG We are back in business ... with 11 viewings related by tag "kudos".
- Thought renewal of ssl certificate for www.speaktomecatalog.com with 9 viewings related by tag "speaktomecatalog".
- Thought Promotions in the Speak To Me Catalog Shopping Basket with 8 viewings related by tag "speaktomecatalog".
- Thought Talking Trump Bear by Nika with 7 viewings related by tag "speaktomecatalog".
- Thought Speak To Me World with 7 viewings related by tag "speaktomecatalog".
- Thought Trying to find a current Source for this product ... with 7 viewings related by tag "speaktomecatalog".
- Thought Conversations are Kewl with 6 viewings related by tag "kudos".
- Thought I want to collect email subscriptions to our news leter .. with 6 viewings related by tag "speaktomecatalog".
- Thought about: how to make a pinterest pin button? with 5 viewings related by tag "speaktomecatalog".
- Thought A Speak To Me Catalog desire ... with 4 viewings related by tag "speaktomecatalog".
- Thought New Print Catalogs by Niche with 4 viewings related by tag "speaktomecatalog".
- Thought Coupon 1604a - Talk about those special times coming ... with 3 viewings related by tag "speaktomecatalog".
- Thought #CDCatalog with 3 viewings related by tag "cd catalog".
- Thought Coupon 1602a "Free shipping on Valentine page" with 3 viewings related by tag "speaktomecatalog".