2016C - FALL CD catalog production

About: 2015C - 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
$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 !

#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" ’;

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

#done

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}

# 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

Comments

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