Producing the Practical print catalog (fall 2016)

About: Producing the Practcal print catalog (fall 2015)

#HangOut in #PrintCatalog

We compose this catalog in on our print application

which is gated and guests cannot access.

#1 …

denise chooses the products and places them on pages 1-12 (our currently designed catalog) ← #Done

#2 …

generate XML for  print job use gen_print_xml_files.php?niche=p

← seems some product editing is needed

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.

okay all erronious copied character types have been found and now the XML file validates null
#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 …

(a) created a director for the print project mirriored on my local google drive.   I’m using this format “niche PT YYYY-MM”

(b) set FTP view of “print catalog XML” to align with new directory … in this case “niche PT 2016-09” and download story_and_pictures.xml  into that local directory.


#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.  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.  Old directory will probably be in File/Open Recent.  

in 2016 new cataloged was saved to
My Drive/print projects/PT 2016-09.indd

#6 Replace old XML structure with new one #Done

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

#7 Now review all the pages and products.  #Done

  1. Move things around in the app →
  2. Make changes to the product text in →
  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 →

# 8 Dink pictures #Done 

Your basic dink is ...
  1. select the picture
  2. click fit frame to content
  3. click fit content to fram
  4. move with just arrow keys to new position
  5. maybe do 3 & 4 again

# 9 Review performance of last year’s coupon #Done

see database – online orders only were recorded here
would need to check records in Tome to find phone orders
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.

after review by denise the coupon will be 

# 10 Choose a printer

# 11  Spellcheck the whole document within the #indesign  #Done

#12 Output a pdf file on GoogleDrive

      Instructions → File/Adobe Presets/[High quality print] 

←  viewable now #Done

#13 review products & prices with denise

       can be done direct from PDF.  (no need to print) #Done

#14 Make corrections in file or db and regenerate as above.  

    final changes  ←  #Done
    export new pdf  ← #done

#15 Output Black & White version for press

      In File/Adobe Presets/[High quality print] 
      Output tab:
           Color Converstions : Convert to Destination
           Destination: choose Dot Gain 30 %

← #done


#16 Send job to press  via email attachment

     Send job to YourTown press via email attachment  ← #done 

     Recieve proof back in private email and go ok it here
     and my response here ← #Done

     Okay proof and wait for YourTown Press to print job and send to eagle mailing  (4 days) #Done 

#17 Generate the mailing file in Tome

*Niche mailing of practical borshire
* count is 6108 before selectivecoding when date was {^2013-01-01}
* after codeselectivemail.prg counted 6427 up to {^2013-01-01}
* moved date up to {^2013-04-01}
* 6256 sent to mailing house 10/11/2016
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>{^2013-04-01}

Wait for them … wait for them …  ← #InProcessNow


  1. speaktomecatalog
  2. PrintCatalog
  3. SeirTD
  4. hashtag
  5. aside
  6. year2016
  7. y2016
  8. SeriTD
  9. HangOut
  10. SaveAS
  11. inquiry
  12. TotallyNewCoin
  13. ConversationRooms
  14. ClickToVerify
  15. fairwitness
  16. PHP
  17. JavaScript
  18. SeeAlso
  19. indesign
  20. InProcessNow
  21. NoBrainer


Si says
Just wondering why you keep republishing this instead of updating it? Is there something here you want me to look at?

Seth says
woopse sorry … i guess i was pressing publish rather than update.

See Also

  1. Thought Did Putin blackmail Trump? with 611 viewings related by tag "year2016".
  2. Thought What is happening in Sweden? with 382 viewings related by tag "inquiry".
  3. Thought Inquiry: The nature of an individual to a group. with 279 viewings related by tag "inquiry".
  4. Thought 2017c Fall Print Catalog with 246 viewings related by tag "aside".
  5. Thought 2017A - Spring CD catalog production with 228 viewings related by tag "seeAlso".
  6. Thought RFD: The base domain from which we proliferate with 201 viewings related by tag "SeriTD".
  7. Thought Enforcement enacted. with 191 viewings related by tag "SeriTD".
  8. Thought Download Orders From Amazon Shop (New Method) with 171 viewings related by tag "speaktomecatalog".
  9. Thought Work on baby ... with 167 viewings related by tag "SeriTD".
  10. Thought To upload mp3 files to Fillmore box 6300 with 129 viewings related by tag "speaktomecatalog".
  11. Thought Why my trains of thought break ... with 127 viewings related by tag "SeriTD".
  12. Thought Glossary with 124 viewings related by tag "hashtag".
  13. Thought Reseller Permit with 116 viewings related by tag "speaktomecatalog".
  14. Thought Sometimes SeriTD gets Starry Eyed with 113 viewings related by tag "SeriTD".
  15. Thought Conversation on hash tags? with 111 viewings related by tag "hashtag".
  16. Thought I banished evil! with 110 viewings related by tag "hashtag".
  17. Thought Wow! Words have meanings to others too! with 106 viewings related by tag "hashtag".
  18. Thought Curating My Long Term Trains of Thought with 102 viewings related by tag "SeriTD".
  19. Thought SeriTD dreams, and dreams of boz. with 97 viewings related by tag "SeriTD".
  20. Thought Portable Collapsable Lantern with 95 viewings related by tag "speaktomecatalog".
  21. Thought Project to switch php version at Speak To Me Catalog.Com with 94 viewings related by tag "php".
  22. Thought Shout Out: Stay Hydrated but keep it in your pocket with 90 viewings related by tag "speaktomecatalog".
  23. Thought Sending out Speak To Me Catalog Email Catalog with 88 viewings related by tag "speaktomecatalog".
  24. Thought Going from Spectrum to Trinity with 86 viewings related by tag "SeeAlso".
  25. Thought 2016C - FALL CD catalog production with 86 viewings related by tag "seeAlso".
  26. Thought Automatic vertical image sizes with 80 viewings related by tag "SeriTD".
  27. Thought about: Kajabi - The Only Knowledge Commerce Platform Today with 79 viewings related by tag "hashtag".
  28. Thought Put the river in fastblogit with 76 viewings related by tag "SeriTD".
  29. Thought #TypeError with 71 viewings related by tag "SeriTD".
  30. Thought Cloud SQL charges this month with 62 viewings related by tag "SeriTD".
  31. Thought Internet with 59 viewings related by tag "seritd".
  32. Thought BlackListt ... get speaktomecatalog off the list with 57 viewings related by tag "speaktomecatalog".
  33. Thought My bookmarks are ... with 56 viewings related by tag "SeriTD".
  34. Thought Game Level 1 (FOUNDATION) is complete. with 54 viewings related by tag "SeriTD".
  35. Thought SENTRY3 - Active Call Blocker 3.0 with 50 viewings related by tag "speaktomecatalog".
  36. Thought Shout Out: Trump is back by popular demand ! (2017-01-17) with 50 viewings related by tag "speaktomecatalog".
  37. Thought 2017c - Fall CD catalog production with 48 viewings related by tag "speaktomecatalog".
  38. Thought Conversation Rooms and Tag Clouds with 45 viewings related by tag "hashtag".
  39. Thought Traditional Christmas dinner 2016 with 45 viewings related by tag "speaktomecatalog".
  40. Thought Speak To Me Catalog will donate 10% of every sale on these products with 45 viewings related by tag "InProcessNow".
  41. Thought Questions about group tag clouds ... with 41 viewings related by tag "SeriTD".
  42. Thought Clarifying how hashtag’s are defined with 41 viewings related by tag "hashtag".
  43. Thought RFC: Planning sub domain growth for with 37 viewings related by tag "SeriTD".
  44. Thought 1612a with 35 viewings related by tag "speaktomecatalog".
  45. Thought [title (20177)] with 30 viewings related by tag "SeeAlso".
  46. Thought Speak To Me Catalog (Production of the Print Version) with 29 viewings related by tag "indesign".
  47. Thought about: something said or asked here - comment 60870 with 28 viewings related by tag "SeriTD".
  48. Thought Google Campaign with 26 viewings related by tag "speaktomecatalog".
  49. Thought about: Siri is dying. Long live Susan Bennett. - Typeform blog with 25 viewings related by tag "SeriTD".
  50. Thought Marketing Stratagies for Speak To Me Catalog with 20 viewings related by tag "speaktomecatalog".