Printing dated pages

Hello out there!

Is there any way to create and print dated pages for 2006 using these templates? Or is the only option to print undated and date them by hand?



Syndicate content

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Dated templates

The only dated templates currently released are the monthly ones. Perhaps some enterprising user might consider whipping up a macro to do a nice daily dated template that conforms to the D*I*Y Planner look? Heaven know it wouldn't be much fun to do it manually....

all my best,

Tried that but was unsuccessful

... Or at least partially unsuccessful.

What I did was to create the lay-out of the template in the master, and have 31 pages with imported excel files displaying the date, day of the week and small calendars for the previous and next month, increasing the day by 1 each time. It had an external reference to a separate spreasheet which held the startdate.

So theoretically if you updated the reference file, and you opened the template it would update all the dates. This way you would only need to create the template once, and after that change the reference date, and print the next month.

As I said theoretically, cause unfortunately the embedded excel files did not update consistently. You would have to go into each day, and manually say to update the links, which kind of defeats the purpose.

I believe that Macros in OpenOffice work only in 'Writer' not in draw. So it looks like that route is blocked as well. Does anyone have any other suggestions ?

Unverified, but may work

Can anyone verify the file format for OOo's Draw? XML? 'Cause if it's XML (looks like you can import XML, at least), you could write a program to 'fill in the numbers', and make it a valid import file. Other systems (I'm thinking of LaTeX and ConTeXt specifically) interface pretty well with XML. Just a thought.

It's XML.

OpenOffice Draw files are indeed XML, after a fashion. They are jar-form OpenDocumentDrawing files, so, basically, they are a zip file containing a few folders and several XML files. As far as most people are concerned for Draw documents, you should look at the content.xml file. It is pretty simple to understand, and the documentation is freely available, including a free book: . Basically, unzip a .odg, or any other OpenDocument file, and the worlds unfold...



Thanks, Cain. This looks pretty hackable. Is there anyone currently working on calendars with dates?

Hi ya.

Hi ya.

I was working with an OOpMacro by Danny Brewer that numbers the pages and adds up to 4 lines of text to the page.
See: Calendar Maker Macro

I was trying to get it to print the holidays (etc) and was having problems. Email me and I'll send you what I have (assuming I can find it tonight).


Calendar Maker Macro

Hi, Rebecca --
I learned about Danny Brewer's macro yesterday (from another post), and I've been futzing with it a little; haven't tried the holidays. Looks pretty easy to modify ('course, since it'll take more than 2 minutes, I haven't done it yet). Shouldn't be too hard to create something slightly different than the demo template.


Dated Pages

I also wanted dated pages but my solution is to print the undated Day Keeper pages ( I use the 2 up version ) then put the paper back in the printer and print the dates on these.

I actually used Word and Excel to create a set of dates and days that print the in right places on the pages.

I did look at printing double sided and thought that this would take too long and as I am left handed there is an advantage to keeping all the pages on the left

Hope this helps


MailMerging Dates into templates

I am messing around with OOo Writer's mailmerge feature in an attempt to get template planner pages printed with dates.

I created a spreadsheet with the following columns:

Month|Date|Year|Day|Current Day|Days Left

I filled in each row with the appropriate info for each day in 2006. For example the first row of cells is


After creating a template in OOo Draw, I Select All and copy it into a Writer document. I then add the fields from the dates spreadsheet to the document. When you Print, you are given the option to merge data from all or selected rows. With this you can print one day, one week, one month worth of pages.

Still not perfect yet. The Draw item pasted is treated like a graphic, so I've been having trouble getting the fileds added exactly where I want them. And for some reason when I print as a grapgic, shading and even some lines don't show up on the printed output.

It would be ideal if you could mailmerge from within Draw. But the method I'm playing around with so far shows great potential.

If I ever get it working to my satisfaction, I'll post more detailed info on the procedure.

Screen shot of what I have so far

After some more playing

After some more playing around, I was able to get better control over placement of the merged fields by setting the Draw slide as a background image in the Writer document.

I first exported my Draw slide as a WMF file. Then in Writer, I used the Page options dialog to set that exported file as the background image. My Draw slide was already set up to align the template with the left and bottom margins. I set it the same way in Writer using the Type Position option. You might have to do more juggling of the image in Writer if your template isn't aligned with the margins.

While not exactly an elegant solution, I think it will work for me. But if any one comes up with something better, I'd be happy to hear about it.

Screen shot


That's absolutely brilliant, Pudah! You certainly have a much better grasp of these things than I do. Is it possible to pump out a PDF "set" of dated pages for a full year, with margins for rings?


It should be possible

Doug, it should be possible. But there seems to be a bug in the Writer mail merge. When I save the merged document as a single file, I end up with a blank page after each planner page. I'm off to google the problem to see if there is a solution. Will keep you posted.

Seems like the blank page

Seems like the blank page thing is a known bug/feature with the mail merge. Version 2.0.1 of OO allows the user to suppress the printing or saving (when exporting to PDF) of these blank pages. I'll download it when I get home tonight but hopefully that will take care of it.

OOo 2 blank page bug

Excellent! Please keep us informed. I've heard from a lot of people who would love to have a dated set of daily calendars.

all my best,

margins for rings


It appears that the blank page suppression thingy is in OOo 2.0.2, which is due to be released on February 27th.

But I was thinking about what you said about creating a year's worth of dated pages with margins for rings. I had said that was doable. And when I said it I was thinking of the way I lay out my planner: to do list/appointment schedule page on the left, notes page on the right. A typical 2 page per day layout.

This works with the method I laid out above because the graphic I exported from Draw has the template oriented to be a left hand page. When that graphic is used as a background image, the ring margin is fixed because it is a picture and not text. My plan was to print all of the left hand to do pages, flip them over and print all of the right hand note pages. These would be printed from two separate mail merge documents, each with a different background image.

I'm not sure whether there is a way to print one page per day, at least with the method I am using. While I'm waiting for 2.0.2 to be released, I'll continue to play around to see if anything can be done.

Got it working

Found that there is a release candidate version of 2.0.2 available so I downloaded it and was able to create a PDF of a full year's worth of dated pages, without the annoying blank pages that Writer puts in when doing mail merge.

Also, with a tip I got re getting rid of the blank pages, I was able to figure out how to do the merge adjusting for margins for those that like a one page per day system.

First set up your document with mirror margins. Whether you make the inside or outside margin the one for rings will depend upon whether you want the first dated page to be on the right or left.

Set your image as background as above, except instead of aligning with one of the corners, select the Area radio button which will essentially fill in the area of the page defined by the margins with your image. In this case you'll want to make sure your image doesn't have any padding for margins in it or your margin will be too big. In Draw I did Ctrl-A to select all and then Export, opting to export the selection when prompted. The resulting WMF file is then exactly as large as the items on the template with no extra white space. You'll want your Writer margins to be the same as the margins you used to design your template in Draw (or at least margins with the same proportions so that your image doesn't distort too much).

After setting up your margins and background image, point Writer to your date database and add your desired fields to the document. I found it easiest to set the position of the text by adding a single blank line before the line with the date fields and using the Paragraph settings to force fixed line spacing for that single blank line paragraph. You can then increase/decrease the line spacing until you get the date fields to be positioned on the page just where you want them vertically. Use the left/center/right alignment and tab stops to position your text horizontally.

Once you have the date fields where you want them, select and copy all of your page text to the clipboard. Insert the Next Record field (Ctrl-F2, Database, Next Record) after the last text on your page followed by Ctrl-Enter to force a new page. You will notice that the new page has the wide margin on the side opposite that of your first page. Now copy the page 1 text to page 2. Then do your mail merge.Since there are an odd number of days in the year, you'll end up with blank date fields on the last page. Just remove that page from the saved merge document before exporting to a PDF.

Actually, it might be better to work with say, a month at a time. You could then print either an Index page of a full month grid one the "back" of the first page of the month. I'm sure the creative folks here will come up with good ideas for using these predated pages.

All of that probably sounds a bit confusing. But I think once you play around with Writer and Draw it won't be too bad. Please let me know if you have any questions or clarifications on the procedure and I'll do my best to answer them.

Doug I sent you a mail about uploading a set of files for those who may not feel up to tinkering with OOo. They were too big to submit thru the create content form.

Hello, I was curious if


I was curious if there is now a template available with dated pages. I'm not too good with OO, so I would like to find something in the download section...

Thanks a lot!


I'd like to help

Is there an Open Office version of the calendar pages I can get to ?

I believe I can directly hack the XML.

I have OOO versions

I have OOO versions of the pages that I created if that's what you were looking for. Let me know.

Sure. Love to have them

I saw your weekly planner pages. Do you have monthly pages ?

I will happily share whatever I come up with.

Just e-mail them directly to me, please.

OOo Macro for building monthly calendars


I made available a calendar macro that creates dated (with public holidays) monthly pages. I have the same for weekly ones although it needs a bit of a cleanup before release.

I made my own templates, looking somewhat like the diyplanner ones. you'll find them here:

Dated Monthly Pages


I used the same method described in an earlier message in this string to create my own daily pages. I also figured out how to do the same thing with Monthly pages.

Steps involved in the Monthly pages:

  1. Create a Calc spreadsheet that has one row per month. In the first column, type in the name of the month and year (ex: January 2007).
  2. Name the remaining columns after days of the week and weeks of the month (ex: Sun1, Mon1, Tue1....Sun5, Mon5, Tue5..) until you get to the last day of the week with the #5 stuck on the end.
  3. In the cells of each row, put the date number in the block that corresponds--so if Monday is the first day of the month, put a 1 in the "Mon1" column for that month. Then number consecutively to the right until you get to the last column. If you haven't reached the end of the month, put the last few days back into the first week. Example: December 2007 begins on Saturday. For me, this is the last day of the week, so the 1 goes into the Sat1 column. That means 30 has to go into the Sun1 column, and 31 goes into Mon1. This is that 'wrapping' thing you see on calendars, where the last few days of the month are shown in the first week.
  4. Create your undated template of the month in Draw (or whatever). I'm using a two-page spread, which makes the merge slightly more complex, but the concepts are all the same.
  5. Embed your picture of the undated month into a Writer document (as described in the earlier message).
  6. Create a table on the page that lines up with the lines in your template (to make the text formatting easier) and work out your text sizes and alignments. I used a row height that's the same as the large block that represents one day on my page--not just the date number box, the entire day block. YMMV.
  7. When you're sure your numbers will fit and line up, etc., then it's time to insert your fields. This was tricky for me to learn since I'm so used to MS products, but basically the mail merge wizard will allow you to connect your spreadsheet up as a 'data source'. It wants you to be writing a letter, but you can skip that part and use the 'edit document' button to allow you to insert fields manually.
    This is where it gets a little weird. The first column, the one with the month and year, is your page header. In each day box, you're going to insert one field--the top row of days will correspond to your fields with "1" in the name. The second row will be the "2" fields, etc. Use the mail merge wizard to preview what you're doing, and save frequently. You don't need any 'next record' or other fancy stuff at all, just the fields you created in your spreadsheet.
  8. Once you have all your fields inserted, you can generate a merge document and see how it all looks.

I did quite a bit of tweaking, but after about an hour and a half, I have a merge setup that will last for years. I'll be able to generate these calendars in standard DIY format at a moment's notice whenever I want. They are basic calendars, no holidays or reminders or anything.

I am using a two page spread, and I generated two images to be my graphics, which made the whole formatting thing a little more complicated. I decided to do a letter-landscape print, since I am cutting down my own paper anyway. So I've got a two-column layout on my letter-landscape page, and each column has a graphic. Doing it this way instead of the 'background image' method is a pain in the patootie and I definitely DO NOT recommend it if you're not pretty fabulous with maneuvering graphics in a word processor. I have about 15 years experience doing just that, so it was only a nominal time-waster. When I did my daily pages, I did the 'background image' thing and it was sweet and easy and fast, once I figured out that pesky insert field thing.

So, I have a document template and a spreadsheet. These are the two pieces needed. Would anyone want them in the letter-landscape two-page-per-month layout?


It Should Work !!!

(three brownie points for anyone recognizing the reference to Young Frankenstein)

There are those of us who are working on it. See this thread.

Personally, I see three immediate possibilities: pngwriter to dynamically create pages as PNG graphics, PDFlib to create dynamic PDF files, or a Qt application that would have a GUI front end, could produce either PNG or PDF and would be cross platform capable.