2017c Fall Print Catalog

About: ClonedProducing the Practical print catalog (fall 2016)

tag #PrintCatalog


We compose the products
in the catalog in on our web application
db/catalog.php →


#1 …

denise chooses the products and
places them on pages 1-12  1-16 (denise added an extra print sheet this year)  ← #done 

#2 …

to generate the XML structure for print job
composed in InDesign click
db/gen_print_xml_files.php?niche=p  →


Fix parsing errors.   After generating stroy_and_pictures.xml (above), special caracters must be removed from the data via db.  The file is best audited by viewing the XML file in a browser, Firefox will indicate exactly where the errors be.   apparently my famous “...” cannot be used in our product descriptions … they make a character type which when copied from here to speaktomecatalog db barfs when it gets into an XML file.

So edit out all erroneous “copied” character types so that the XML file validates ← #done
#aside: niche “p” contains only the practical products not the fun novelty ones.  this is the only print catalog that we have produced for the last couple of years.
 #SeeAlso “New Print Catalogs by Niche”  and  “(private thought)
perhaps more in niche,print … lots of old history to shuffle through to see what actually happened and stuck.  but this does not need to be done right now … er, hopefully.

#3 …

#4 …

Joson dinks and puts the high resolution pictures in CYMK in our shared Google/My Drive/picture
That directory should sync to my local Google Drive/picture.

Currently they look in sync.  ← #done 
But if they were not i might have to download.  ????

#5 …

load the last inDesign file from it’s google drive directory and #SaveAS in the current one just created in step #3 above.  Old directory will probably be in File/Open Recent.  
in 2017 new cataloged was saved to
My Drive/print projects/PT 2017-09.indd ← #done 

#5a …

4 pages were added in the middle of the document turning the 12 page catalog into a 16 page catalog

← #done

#6 Replace old XML structure with new one

You can see the old structure by clicking View/structure/show structure.

To replace it with the new structure click File/Import XML and let the options show the same as in this picture, and click OK.   The new pictures and text will replace the old ones in their respective slots on the pages null
← #done 

#6a  Adding pages and products on a page that were not present in old catalog

Bear in mind that the XML structure in the left panel of the inDesign screen shows the desired structure that is produced by the catalog.php app.   The structure of the pages must be changed to correspond.  For example to add pages 7 – 10, go to those pages and add text frames.  Then add the picture frames as content type graphic. 

… then drag from the  structure element in the left XML panel to the corresponding structure in the document to apply the content to that element.

← #done 

Notes on adding pages and products

Product pages, or product pictures are added to the catalog by …
  1. making a frame in the appropriate place and
  2. selecting whether it is a text frame or a graphic frame: menu object, content, text or graphic
  3. Drag the corresponding page or product text  from the XML structure and drop it on the frame.



#7 Now review all the pages and products. 

  1. Move things around in the app → http://www.speaktomecatalog.com/db/catalog.php
  2. Make changes to the product text in → http://www.speaktomecatalog.com/db/
  3. Export the new XML file with → gen_print_xml_files.php?niche=p
  4. ftp the XML file back to the local drive with the FTP profile “Print Catalog XML”
  5. Import the revised XML file in the document with “File/Import XML”
… repeat → #done 

# 8 Dink pictures ← #done 

Your basic dink is ...
  1. select the picture
  2. click fit frame to content
  3. click fit content to frame
  4. move with just arrow keys to new position, or drag yello gadget on right of the frame.

# 9 Review performance of last year’s coupon

← 2015c coupon
Count of use of code “PRINT1” in Tome yields: 15 orders @ $10 each costing us $150 and yielding something in excess of $750. the exact gross is more because people did not just order $75 but would take too much work to calculate.

← in 2016c coupon

← in 2017c coupon → #done 


# 10  Spellcheck the whole document within the #indesign 

#11 Output Black & White version for press – save in google drive directory

     Job sent in email here   ← #done 
     Attaching the PDF file …

→ #done 

Proof was sent us as PDF and approved
it looked identical to the one we sent them → #done 

#14 Code the neiche in the comment line of each invoice

#15 Generate the mailing database to send to the mailing company

*Niche mailing of practical borshire
* count is 5364 before selectivecoding
* after codeselectivemail.prg counted 5706
* moved date up to {^2014-04-01}
* 5706 sent to mailing house 10/13/2017
set filter to;
        (empty(media) or "p" $ lower(media));
        and not "x" $ code;
        and not "x" $ media;
        and empty(country);
        and not empty(zip);
        and "p" $ lower(comment);
        and not "$" $ comment;
        and statusdate>{^2014-04-01}
Eagle Mailing Service
503-393-7260 Fax

#16 Make a coupon for PRINT3  #done


  1. speaktomecatalog
  2. PrintCatalog
  3. aside
  4. SaveAS
  5. SeeAlso
  6. indesign

See Also

  1. Thought 2017A - Spring CD catalog production with 228 viewings related by tag "seeAlso".
  2. Thought Producing the Practical print catalog (fall 2016) with 197 viewings related by tag "aside".
  3. Thought Download Orders From Amazon Shop (New Method) with 171 viewings related by tag "speaktomecatalog".
  4. Thought To upload mp3 files to Fillmore box 6300 with 129 viewings related by tag "speaktomecatalog".
  5. Thought Reseller Permit with 116 viewings related by tag "speaktomecatalog".
  6. Thought Portable Collapsable Lantern with 95 viewings related by tag "speaktomecatalog".
  7. Thought Shout Out: Stay Hydrated but keep it in your pocket with 90 viewings related by tag "speaktomecatalog".
  8. Thought Sending out Speak To Me Catalog Email Catalog with 88 viewings related by tag "speaktomecatalog".
  9. Thought Going from Spectrum to Trinity with 86 viewings related by tag "SeeAlso".
  10. Thought 2016C - FALL CD catalog production with 86 viewings related by tag "seeAlso".
  11. Thought BlackListt speaktomecatalog.com ... get speaktomecatalog off the list with 57 viewings related by tag "speaktomecatalog".
  12. Thought SENTRY3 - Active Call Blocker 3.0 with 50 viewings related by tag "speaktomecatalog".
  13. Thought Shout Out: Trump is back by popular demand ! (2017-01-17) with 50 viewings related by tag "speaktomecatalog".
  14. Thought 2017c - Fall CD catalog production with 48 viewings related by tag "speaktomecatalog".
  15. Thought Traditional Christmas dinner 2016 with 45 viewings related by tag "speaktomecatalog".
  16. Thought 1612a with 35 viewings related by tag "speaktomecatalog".
  17. Thought [title (20177)] with 30 viewings related by tag "SeeAlso".
  18. Thought Speak To Me Catalog (Production of the Print Version) with 29 viewings related by tag "indesign".
  19. Thought Google Campaign with 26 viewings related by tag "speaktomecatalog".
  20. Thought Marketing Stratagies for Speak To Me Catalog with 20 viewings related by tag "speaktomecatalog".
  21. Thought Footer problem on individual page at speaktomecatalog.com with 19 viewings related by tag "speaktomecatalog".
  22. Thought Improving Speak To Me Catalog's status on Amazon with 16 viewings related by tag "speaktomecatalog".
  23. Thought XPOWER - Smart and Slim Power Bank for Smartphone with 14 viewings related by tag "speaktomecatalog".
  24. Thought Tostada with 14 viewings related by tag "speaktomecatalog".
  25. Thought Outbound Email Server for Speak to me Catalog Postage of Orders with 14 viewings related by tag "speaktomecatalog".
  26. Thought about: Producing the Practcal print catalog (fall 2015) with 12 viewings related by tag "speaktomecatalog".
  27. Thought about: naughty santa mug from speak to me catalog with 11 viewings related by tag "speaktomecatalog".
  28. Thought renewal of ssl certificate for www.speaktomecatalog.com with 9 viewings related by tag "speaktomecatalog".
  29. Thought Promotions in the Speak To Me Catalog Shopping Basket with 8 viewings related by tag "speaktomecatalog".
  30. Thought Talking Trump Bear by Nika with 7 viewings related by tag "speaktomecatalog".
  31. Thought Speak To Me World with 7 viewings related by tag "speaktomecatalog".
  32. Thought Trying to find a current Source for this product ... with 7 viewings related by tag "speaktomecatalog".
  33. Thought I want to collect email subscriptions to our news leter .. with 6 viewings related by tag "speaktomecatalog".
  34. Thought about: how to make a pinterest pin button? with 5 viewings related by tag "speaktomecatalog".
  35. Thought A Speak To Me Catalog desire ... with 4 viewings related by tag "speaktomecatalog".
  36. Thought New Print Catalogs by Niche with 4 viewings related by tag "speaktomecatalog".
  37. Thought Coupon 1604a - Talk about those special times coming ... with 3 viewings related by tag "speaktomecatalog".
  38. Thought Coupon 1602a "Free shipping on Valentine page" with 3 viewings related by tag "speaktomecatalog".
  39. Thought Coupon 1602b ... for president's day with 3 viewings related by tag "speaktomecatalog".
  40. Thought Purchace a new LP2844 with 1 viewings related by tag "speaktomecatalog".
  41. Thought about: 90% Hot ... 10% Discount ... with 1 viewings related by tag "speaktomecatalog".
  42. Thought Speak To Me Catalog, todo list with 1 viewings related by tag "speaktomecatalog".
  43. Thought Shout out newsletter 2016-05-02 with 1 viewings related by tag "speaktomecatalog".
  44. Thought WCBUT - Butterfly Windchime with 1 viewings related by tag "speaktomecatalog".
  45. Thought about: soy candles - glass jars - page 1 - collectivescents.com with 0 viewings related by tag "speaktomecatalog".
  46. Thought Responding to out customer's order ... with 0 viewings related by tag "speaktomecatalog".
  47. Thought Coupon 1601a "10% off everything on health page" with 0 viewings related by tag "speaktomecatalog".
  48. Thought Practical print niche catalog with 0 viewings related by tag "speaktomecatalog".
  49. Thought Adobe Creative Cloud with 0 viewings related by tag "indesign".
  50. Thought Shout out newsletter 2016-03-08 with 0 viewings related by tag "speaktomecatalog".