pflip

Q: calendar project problems

I am having a frustrating problem with calendar projects. when the project is exported to either a pdf preview or just to buy, the Month text at the bottom of the page shows up as very small. there is no way to edit the font size at any stage of the project. i had this same problem in November

and got around it by thrashing the whole project and 4hrs of work and starting over. It then worked and i thought the problem was a corrupt file on my end.however i have invested a full day doing this project on two different Macs with the same result. any help or insight would be appreciated

 

!. Using Photos 1.5

2.Both Macs with 10.11.4

3.Using the colored paper theme

4.Not all months have small MONTH TEXT seems to be random

iMac, OS X El Capitan (10.11.2)

Posted on Apr 8, 2016 3:05 PM

Close

Q: calendar project problems

  • All replies
  • Helpful answers

  • by Old Toad,

    Old Toad Old Toad Apr 8, 2016 4:08 PM in response to pflip
    Level 10 (141,105 points)
    Mac OS X
    Apr 8, 2016 4:08 PM in response to pflip

    First, as a test launch Photos with the Option key held down and create a new, test library.  Import some photos and test to see if the same problem persists. Does it? If it doesn't the problem is limited to your library so try repairing the library according to the instructions in this Apple document: Repair Your Library.

    Warning: If you use iCloud Photo Library with Photos, this action will cause Photos to upload all your pictures again (from Fix missing or incorrect thumbnails in Photos - Apple Support).


    If that doesn't fix the problem user  jdelisle   posted his fix for the same problem in iPhoto.  Don't know if it applies to Photos, however.

    jdelisle

    Dec 6, 2012 8:00 PM

    Re: Altering text font size in a date box also irreversible resizes month font to 6 point??

    in response to Loki Cyberforce

     

    I ran into the same problem - my iPhoto Calendar month text was small for some reason, and I could not change it to a bigger font size. I decided to take a look at how iPhoto stores project data, and discovered it's a simple SQLite table.

     

    Here's a fix, guaranteed to work.  We're going to open your iPhoto Projects database and edit the font details directly by hand, since there's no way to correct this in iPhoto (Apple, please fix this bug...)

     

    This sounds a lot harder than it is - this is seriously 10 minutes effort.

     

    1. Get SQLite Browser from http://sqlitebrowser.sourceforge.net/
    2. Close iPhoto, and run the SQLite Browser
    3. Open a new finder window, and open the Pictures folder located in your home directory
    4. You should see an item in your Pictures folder called "iPhoto Library".  Right-click it, and choose "Show Package Contents" because we need to edit a file inside the library
    5. Look for "Projects.db".  Right-click it, and choose "Duplicate" to make a back-up in case something goes wrong
    6. Drag and drop "Projects.db" into the running SQLite Browser application
    7. Click the "Browse Data" button
    8. Select the "KHProject" from the "Tables" drop-down menu
    9. You'll see a list of your iPhoto Projects.  Locate your calendar project by looking through this list and particularly the values in the "name" column.  Once you find your calendar project, make note of the number in the "modelID" column.
    10. Change to the "KHProjectTextStyle" table using the "Tables" drop-down menu
    11. Locate a line in the "KHProjectTextStyle" table where the number in the "projectID" column matches the "modelID" you noted in step 9, and where the "styleIdentifier" value is "Picture-Calendar-CalendarMonth".
    12. On the line identified in step 11, look at the value of the "fontSize" column.  For my broken calendar, it was "6".  That's way too small, you can barely read 6 point.
    13. Double-click the "fontSize" value (for me, I double-clicked the "6" value)
    14. Change the "6" to "54".  Don't press enter, just change the "6" to "54", and click the "Apply Changes" button
    15. You're done! Just click the little disk icon in the SQLite Browser to save your changes (or File -> Save)
    16. Open iPhoto, and enjoy your fixed calendar

     

    Hope that helps some of you, it worked 100% for me on several calendar projects.  If you don't see the font size change, make sure you've identified the correct project in step 8, and make sure you're editing the "fontSize" for that project, on the line where the "styleIdentifier" value is "Picture-Calendar-CalendarMonth".

     

    If something went terribly wrong, you made a backup in step 5 (right?) and just have to delete the "Projects.db" you edited, and rename the backup to "Projects.db".  You can then try again, or not.

     

    I'm sending my calendars for print this week, and will report back if there are issues.  I do not anticipate any issues.

    Be sure to backup your library before attempting the hack of the database file.

    OTsig.png

  • by pflip,

    pflip pflip Apr 9, 2016 5:55 PM in response to Old Toad
    Level 1 (8 points)
    Photos for Mac
    Apr 9, 2016 5:55 PM in response to Old Toad

    Thanks for your speedy reply! I did a test case as you suggested and i also attempted to follow jdelisles' tutorial. As you mentioned I am not sure that the SQlite browser supports Photo because @ step 9 i could get nothing past my 2015 projects on either computer. The test seemed to work but when i went back to the full photos app the problem reoccurred. I believe that jdelisle is correct in his assumption that the problem is a SGlite table. but it seems to be a specific problem with only the "colored paper" theme. i changed themes and the preview was good. I have used colored paper exclusively and did change font size for custom date entries in both 2014 and 2015 no problem until this year. I will attempt to follow up and determine if SQbrowser supports Photos or if there is a fix for the theme if so i will post to this thread  again thank you and thanks to jdelisle for his excellent work

     

    pflip   

  • by Old Toad,Helpful

    Old Toad Old Toad Apr 10, 2016 11:48 AM in response to pflip
    Level 10 (141,105 points)
    Mac OS X
    Apr 10, 2016 11:48 AM in response to pflip

    Which theme exactly is it? 

     

    Be sure to report the problem with the colored paper theme to Apple at https://www.apple.com/feedback/photos.html.

  • by pflip,

    pflip pflip Apr 10, 2016 3:01 PM in response to Old Toad
    Level 1 (8 points)
    Photos for Mac
    Apr 10, 2016 3:01 PM in response to Old Toad

    The original theme and the one I always used is  "COLORED PAPER" , It can be found at the very bottom of theme options,  I switched to a "MODERN LINES" theme which worked fine I think, I have not rec'd a shipping notice or a " We are very sorry but we could not complete your order please do the following etc.. etc... Yet so i am holding my breath.  per your suggestion I did notify APPLE.

     

    Thanks again

    pflip

  • by Old Toad,

    Old Toad Old Toad Apr 11, 2016 9:09 AM in response to pflip
    Level 10 (141,105 points)
    Mac OS X
    Apr 11, 2016 9:09 AM in response to pflip

    I just ran a test with the Colored Paper theme and the Month and year text at the bottom of each month were fine.  Give this a try:  download and apply the OS X El Capitan 10.11.4 Combo Update which will install a new dopy of Photos 1.5.  Combo updaters often will correct installation issues that arise via incremental updaters from the App Store.  it's worth a try. 

  • by pflip,

    pflip pflip Apr 12, 2016 4:12 PM in response to Old Toad
    Level 1 (8 points)
    Photos for Mac
    Apr 12, 2016 4:12 PM in response to Old Toad

    I downloaded and installed the combo update and attempted the project again both in the main Photos Library and in a new test Library using the option Key and importing the photos from a sd card that i had loaded with the album. Both tests produced the same problem. I am now starting to believe that the problem must be with one or more of my photos although I don't know why or how. It also does not explain why it worked with a different theme. I am now kind of discouraged as i really enjoyed the calendars and the theme which unlike the others is not cut & dried. I don't really know how to check each photo for corruption and rebuilding the whole photos library might be a option but i do use icloud photo library. I pretty much have tried everything short of rebuilding but that would use another 30 GB. Again thank You very much for your time and energy.

     

    pflip