2017c - Fall CD catalog production

 #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="2017";
$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";
}

null 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 …. waiting for Jason to finish recordings ← #done 

Record and upload mp3 files to the directory /cd_catalog using the format cd_XXXX.mp3 
* might need to call Jason with specific motivational tone ← #done 

#4 in cd_catalog app click “Write Playlist” ← #done 

     denise then reviews products and cut some so that there will be only 4 discs ← #done 
     Note: Denise should TAB through the products (not up and down arrow) so as to preserve place on screen.

    UPDATE `product` SET class="xmas" where class="christmas"
    UPDATE `product` SET class="xhalloween" where class="Halloween" ’
    // after cutting cd’s switch back ←
    UPDATE `product` SET class="Christmas" where class="xmas" ’;
    UPDATE `product` SET class="Halloween" where class="xhalloween" ’;

     Note:  “xhalloween” was excluded in the program from the disc

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

#5a – Denise specifies changes and i make them on both local and server files

#6 FTP playlists back to seth’s local ← #done 


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

7 Take masters to Divirsified ← #done 

#8 Count CDs to duplicate & print 1” labels → #done 

Enter count at bottom of labelm.prg
****************************************************
* Fall  CD Catalog 2017c
* counted total mailing on 10/5/2017 = 1174
* Burnt 1300 of 4 masters
* After taking off bounces = 1151
* Printed all in one batch counted as ? on 10/11/2017
* First class … $1.12 each … mailed $800 worth … working East Coast to West
    thismail="#z"
    set filter to;
        ("c" $ media or "d" $ media);
        and not "x" $ code;
        and not "x" $ media;
        and statusdate>{^2013-10-01}

#9   Stamp, label, stuff 4 cd’s in  envelopes and mail first class …
         720 x $(.91+.21) = $806.40
         completed and took to post office 10/12/2017 ← #done 

#10  Label and bundel in 10s remaining ← #done

          4 trays of (9 bundels of 10) = 360
           1 tray of 6 x 10 = 60
            1 bundel of 8 = 8
          total mailing piedes = 428

         Note 720 + 428 = 1148 … printed 1151 … 3 labels error (then we added 1 new customer)

         costs $.64701 x 429 + $225 for permit for the year.

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

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