Sequentially numberted tickets...

classic Classic list List threaded Threaded
7 messages Options
zed zed
Reply | Threaded
Open this post in threaded view
|

Sequentially numberted tickets...

I have been asked to design and print numbered tickets for an event being
organised by a Club to which my wife belongs.  

Starting from the left edge:

(a) in the first third details of the event and a number. This is the "stub"


(b) in the remaining two thirds there is an image to the left and then
details of the event. This is the "ticket"

(c) each ticket has two numbers (both the same) printed to justify right on
the "stub" and on the "ticket"

(d) each ticket spans the width of an A4 page

(f) there are four tickets to an A4 page

(g) the ticket will be perforated between the "stub" and the "ticket" to
allow for easy detachment

(h) Designing the ticket is not a problem.  But how do I ensure that the
numbers are printed sequentially in groups of two?

Is it possible to do this on LibreOffice?

I realise that it is possible to number each  ticket on a A4 page and then
print it but as it is looking like 150 tickets that looks like a lot of
work.

David
--
David Love
"A lie gets halfway around the world before the truth has a chance to get
its pants on."

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Nino Nino
Reply | Threaded
Open this post in threaded view
|

Re: Sequentially numberted tickets...

Hi David,

Am 08.08.2013 06:53, schrieb David Love:
> I have been asked to design and print numbered tickets for an event being
> organised by a Club to which my wife belongs.  

How I'd do it (it's from memory, so bear with me for little glitches):

1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
format with two preceeding zeroes) into a column

2. design a nice text page with all 4 tickets in it (you could also try
going with labels but for just 4 tickts per page I'd rather go with
copy&paste instead of fumbling with labels)

3. assign the spreadsheet from #1 as data source (for later use as
mailmerge, from memory: File > New > Database > connect to existing >
spreadsheet)

4. on your above designed ticket page, press F4 to open the spreadsheet
from above as data source

5. enter (simply drag&drop) column header field into the appropriate
place in stub and repeat this for the ticket

6. after every SECOND field enter "next record" switch (Insert > field >
others > database > next record) but NOT after the fourth ticket (as a
page break always triggers a next record switch)

7. Print as mailmerge (or form letter or whatever it's called) into 1
document

8. review the document and if necessary correct&repeat some of the above
steps

9. print the merged documents,

10. enter perforation (I use a sewing machine, works perfectly if you
use a thin needle and adjust the step width appropriately)

11. cut tickets apart :-)

Enjoy learning ;-)

Nino

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: Sequentially numberted tickets...

Hi :)
How i would do it. 

1.  Go to an office supplies shop or even a small newsagents
2.  Buy a book of raffle tickets for something like 50p or maybe a £5er these days

Job done. 

Regards from
Tom :) 





>________________________________
> From: Nino Novak <[hidden email]>
>To: "[hidden email]" <[hidden email]>
>Sent: Thursday, 8 August 2013, 10:14
>Subject: [libreoffice-users] Re: Sequentially numberted tickets...
>
>
>Hi David,
>
>Am 08.08.2013 06:53, schrieb David Love:
>> I have been asked to design and print numbered tickets for an event being
>> organised by a Club to which my wife belongs. 
>
>How I'd do it (it's from memory, so bear with me for little glitches):
>
>1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
>desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
>format with two preceeding zeroes) into a column
>
>2. design a nice text page with all 4 tickets in it (you could also try
>going with labels but for just 4 tickts per page I'd rather go with
>copy&paste instead of fumbling with labels)
>
>3. assign the spreadsheet from #1 as data source (for later use as
>mailmerge, from memory: File > New > Database > connect to existing >
>spreadsheet)
>
>4. on your above designed ticket page, press F4 to open the spreadsheet
>from above as data source
>
>5. enter (simply drag&drop) column header field into the appropriate
>place in stub and repeat this for the ticket
>
>6. after every SECOND field enter "next record" switch (Insert > field >
>others > database > next record) but NOT after the fourth ticket (as a
>page break always triggers a next record switch)
>
>7. Print as mailmerge (or form letter or whatever it's called) into 1
>document
>
>8. review the document and if necessary correct&repeat some of the above
>steps
>
>9. print the merged documents,
>
>10. enter perforation (I use a sewing machine, works perfectly if you
>use a thin needle and adjust the step width appropriately)
>
>11. cut tickets apart :-)
>
>Enjoy learning ;-)
>
>Nino
>
>--
>To unsubscribe e-mail to: [hidden email]
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

zed zed
Reply | Threaded
Open this post in threaded view
|

Re: Sequentially numberted tickets...

In reply to this post by Nino
Nino Novak <[hidden email]> wrote:

> Hi David,
>
> Am 08.08.2013 06:53, schrieb David Love:
> > I have been asked to design and print numbered tickets for an event
> > being organised by a Club to which my wife belongs.
>
> How I'd do it (it's from memory, so bear with me for little glitches):
>
> 1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
> desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
> format with two preceeding zeroes) into a column
[snip]

Thanks, Nino.  I will give it a go and report back.

David

--
David Love
Do more than anyone expects, and pretty soon everyone will expect more  

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

zed zed
Reply | Threaded
Open this post in threaded view
|

Re: Sequentially numberted tickets...

In reply to this post by Nino
Hi Nino

Nino Novak <[hidden email]> wrote:

> Am 08.08.2013 06:53, schrieb David Love:
> > I have been asked to design and print numbered tickets for an event
> > being organised by a Club to which my wife belongs.
>
> How I'd do it (it's from memory, so bear with me for little glitches):

Thank you for the prompt reply and my apologies for the delay in replying to
you.

> 1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
> desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
> format with two preceeding zeroes) into a column

Did that without problems.

> 2. design a nice text page with all 4 tickets in it (you could also try
> going with labels but for just 4 tickts per page I'd rather go with
> copy&paste instead of fumbling with labels)

O.K. Although I did have some trouble grouping all elements.

> 3. assign the spreadsheet from #1 as data source (for later use as
> mailmerge, from memory: File > New > Database > connect to existing >
> spreadsheet)

Perfect!

> 4. on your above designed ticket page, press F4 to open the spreadsheet
> from above as data source

No problem.  

> 5. enter (simply drag&drop) column header field into the appropriate place
> in stub and repeat this for the ticket

Went without a hitch.

> 6. after every SECOND field enter "next record" switch (Insert > field >
> others > database > next record) but NOT after the fourth ticket (as a
> page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how.  As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above.  Is that correct?

and then, as it will be a new page, the numbering will continue in sequence
until we reach the end of the records.  Is that correct

> 7. Print as mailmerge (or form letter or whatever it's called) into 1
> document

I do this by Printing to file.  The first ticket is correct.  Tickets number
2, 3 and 4 are not numbered.  It then goes to the next page where the first
ticket is numbered 2 and the other three are not numbered.  And so it goes
on until the end of the records.  Each page is the next number.

I notice that when I have Next Record highlighted and click Insert, all that
happens is a thin grey vertical line appears where I click.  I would have
thought the words <next record> would have appeared.  Am I wrong?

> 8. review the document and if necessary correct&repeat some of the above
> steps

I am at a loss as to what I should do next.

> 9. print the merged documents,
>
> 10. enter perforation (I use a sewing machine, works perfectly if you use
> a thin needle and adjust the step width appropriately)
>
> 11. cut tickets apart :-)
>
> Enjoy learning ;-)
 
My enjoyment is leading to "grinding of teeth in frustration"

David

--
David Love
A "running mate" is a husband who dared to talk back

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Nino Nino
Reply | Threaded
Open this post in threaded view
|

Re: Sequentially numberted tickets...

Hi David,

Am 21.08.2013 06:42, schrieb David Love:

>> 6. after every SECOND field enter "next record" switch (Insert > field >
>> others > database > next record) but NOT after the fourth ticket (as a
>> page break always triggers a next record switch)
>
> This is where I've gone wrong and I cannot figure out how.  As I understood
> it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
> above.  Is that correct?

Not quite.

If - as I understand your description - you have the following design:

+-------+-------------------+
|       :                   |
| stub1 :     ticket1       |
|       :                   |
+-------+-------------------+
|       :                   |
| stub2 :     ticket2       |
|       :                   |
+-------+-------------------+
|       :                   |
| stub3 :     ticket3       |
|       :                   |
+-------+-------------------+
|       :                   |
| stub4 :     ticket4       |
|       :                   |
+-------+-------------------+

and you put your ticket number fields sequentially from top left to
bottom right, i.e. first into stub1, then into ticket1, then stub2, then
ticket2, and so on, then the first "Next Record" field has to be put
after the number field in ticket1, but before the number field in stub2,
the second one after ticket2/before stub3, and so on. So number fields
in tickets 1, 2, and 3 should be followed by a Next Record field, while
in ticket 4 it should not.

At least that's how it works for me.


> and then, as it will be a new page, the numbering will continue in sequence
> until we reach the end of the records.  Is that correct

Yes - it's sufficient to design just one page, the following pages
should be created automatically the same way if data are left over after
the first page has been printed.


>> 7. Print as mailmerge (or form letter or whatever it's called) into 1
>> document
>
> I do this by Printing to file.  The first ticket is correct.  Tickets number
> 2, 3 and 4 are not numbered.  It then goes to the next page where the first
> ticket is numbered 2 and the other three are not numbered.  And so it goes
> on until the end of the records.  Each page is the next number.

then the "Next Record" fields seem to not work, see below.

>
> I notice that when I have Next Record highlighted and click Insert, all that
> happens is a thin grey vertical line appears where I click.  I would have
> thought the words <next record> would have appeared.  Am I wrong?

By default, these fields are just rendered as those thin lines. To make
full field names visible, you must press Strg+F9 (or toggle "View >
Field Names"). When done, the fields should look something like "Next
record:FileName.TableName" (where FileName and TableName are the file
and table name you chose in steps 1-3). Here is where you can control if
there are any errors. It's a bit boresom as subsequent fields do not
have any space or delimiter in between, so if you by mistake inserted
multiple fields, it will look a bit confusing. But you can simply delete
a field, then you will know where it had started and ended :-)

Note that the field name must contain the correct database and table
names to work properly. If it does not, delete it and insert it anew.
Take care to have the correct data source open (I always leave it open
in the F4 subwindow during the whole procedure).


>> 8. review the document and if necessary correct&repeat some of the above
>> steps
>
> I am at a loss as to what I should do next.

After making field names visible as described above, you should
understand how it works.


>> 9. print the merged documents,
>>
>> 10. enter perforation (I use a sewing machine, works perfectly if you use
>> a thin needle and adjust the step width appropriately)
>>
>> 11. cut tickets apart :-)
>>
>> Enjoy learning ;-)
>  
> My enjoyment is leading to "grinding of teeth in frustration"

You've almost reached the goal, there's only one small step left.
Now don't give up, this will not help reducing frustration.
Only if you succeed, you will get satisfaction ;-)

What reminds me to ask you, which version of LibreOffice you are using
and on which Operating System - just to exclude that you use a buggy
version.

Regards,
Nino

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Nino Nino
Reply | Threaded
Open this post in threaded view
|

Re: Sequentially numberted tickets...

Am 21.08.2013 15:54, schrieb Nino Novak:
> Am 21.08.2013 06:42, schrieb David Love:

>>> 7. Print as mailmerge (or form letter or whatever it's called) into 1
>>> document
>>
>> I do this by Printing to file.  The first ticket is correct.  Tickets number
>> 2, 3 and 4 are not numbered.  It then goes to the next page where the first
>> ticket is numbered 2 and the other three are not numbered.  And so it goes
>> on until the end of the records.  Each page is the next number.
>
> then the "Next Record" fields seem to not work, see below.

Oh, I think here I draw the wrong conclusion: If the field numbers are
"empty" then only the number fields from the first ticket have been
correctly inserted, the other fields must be somehow wrong.

However - make the fields visible with Ctrl+F9 (or View > Field Names)
then look what's wrong with them :-)

BTW: If you want a preview of the resulting Merged Document on the fly,
you can select a couple of rows in the F4 data source window (click on
the first row, then shift-click on the tenth row or so, so that they are
all marked blue) and click on the "Data to fields" button in the data
source window.

Nino

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted