The trick is this: I creat an 'template' of the card, somewhere outside of the page. All object for data are text object, with all the formating needed. In place of the photo is an rectangle. The script read an text file (CSV) with the database, duplicate all template object, one by one and replace string in text object with the string from DB and import photo in place of the rectangle, redimension and convert to RGB or CMYK, acording to the initial data (atach.) When the page is full, create another one.
I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file. In InDesign CS4, I set the tickets four up on the master page. On page 1, I positioned my merge fields such that ticket1 was directly above stub1, ticket 2 directly above stub 2, etc.
Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package
Microsoft Publisher offers many design tools that let you create any type of publication or document. You can essentially make anything in Publisher, including tickets. The easiest way to make tickets in Microsoft Publisher is to download a ticket template from Microsoft Office's website and modify it in Publisher with your own text, colors and graphics. These steps can be used for creating tickets in both Microsoft Publisher 2003 and 2007.
I’d like to share my solution. It came to me partially in my sleep, I tried refining it this morning but because of time, finally had my production person print the manually numbered tickets so that we could deliver them to the customer who needed them today. Here is my solution. I deduced that it would be better to let a program designed to count, do the counting. I used Excel. I then let InDesign CS4 do the merging. Here’s the formula.
But it’s not hard to duplicate and reduplicate until you have a thousand or more numbered tickets. I think the conclusion of all these Rube Goldberg approaches is that InDesign still isn’t ready for handling what is really a head-smacking-stupid-simple kind of numbering job — the kind of jobs computers were created for in the first place. My DOS word processor XyWrite — from AD 1987! — could do numbering stuff like this in no time and with no trouble. Quite ridiculous, really, when you consider the staggering graphics and typography capabilities inside InDesign — but the poor thing cannot really count. I handle this much differently. I create a number list in Excel and save as a txt file.
We have a 700. In Indesign I design raffle tickets 5 up. You have to create an excel file with your numbering 5 up or 5 columns, save as a text file. Use your data merge in Indesign. If your file is too large your Indesign will crash. So keep the placement of your number and delete all other copy on the page. Then do a data merge. It will create just the numbered pages. Send that to your Fierty command workstation as process and hold. Go back and send original file with just your copy layout as a process and hold job. In your command workstation open copy file
Creating numbered tickets in Word can seem difficult or even impossible if you are not familiar with all the capabilities of the Word program. If you have tried going to the Word template section and have been unsuccessful or frustrated with all the options and questions, there is an easier way. The simplest resolution for creating numbered tickets is to find existing templates that can be edited and adjusted to fit your needs.
OfficeArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.
Corel crashed repeatedly on my production person today while he was trying to number them using the plug-in. I couldn’t figure out how to make Mike’s script work. It appeared designed for variable numbers in one place. My customer needed her tickets numbered in two places, on the ticket and on the stub. Because she needs them tomorrow there is no time to send them out to be numbered manually. I’ll keep watching this space for more info. Thanks folks.
CS2 (or earlier) “Cheesy” Numbering There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars” That’s the key to this trick, too: First, get a bunch of numbers. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice. To ensure each number fills its own text frame, select the whole story (Command/Ctrl-A), open the Keep Options (Command/Ctrl-Option/Alt-K) and choose In Next Frame from the Start Paragraph pop-up menu.
You need to create a list of numbers using some method (maybe even through VBA) as a text file, database or other data source, then just insert merge field in the document and use Print Merge to generate multiple labels with different numbers in it. (just need to give it enough space to fit the longest string along as many lines as you think there could be) If I reserve space for 50 chars and the major strings are 25 chars, the result is not professional looking. My solution for all print merge for ID cards (and similarities, incl. Auto numbering) is to merging data BEFORE printing, in an CDR file with all pages. So, I check all the cards and I correct only on text object how need. I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my). I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my) And my script use photo also.
One of the most profitable products a small print shop can produce is Raffle Tickets. But the trouble is most small to medium sized print shops either don't have a numbering unit or it is not setup to number multiple documents on a single sheet of paper. Most print shops do however have a laserjet or multi purpose printer. Combine that with some graphic software like Publisher and and easy to use numbering software program and you can capture the raffle ticket business and not let it slip away from you.
An awesome new feature to has been introduced to Microsoft Publisher 2010 is the ability to use Data Sources to create "Catalogue Pages". This is like a Mail Merge for design documents. Now, I would have to agree that Publisher isn't the best graphic design program in the market. But it's certainly adequate for simple ticket designs — for example, for a school social. Let's say we want each ticket to have a unique number and an inspiration quote. This is all possible through Publisher and a data source, e.g. an Excel Spreadsheet.
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
The ticket numbering problem seems solved, if awkwardly. But what about linking automatic numbering of text references to a figure (e.g. “see fig.101″) to a legend of that figure (e.g. Fig. 101 shows….”)? Is this quite beyond InDesign CS3? If it is solvable the solution isn’t mentioned in any CS3 book I have managed to get hold of, nor is it dealt with in the CS3 Help facility as far as I can see, nor were the speakers at a recent Adove CS3 Workshop able to solve it. Please advise this frustrated book author!
It was the paper size and multiple pages that was stumping me. However I do have a tip for those wanting a short cut to raffle books of 10. It is a little more fidgety so Im sure someone who is experienced with excel (Im not) but it will make the cutting perfect. Print out in sheets of ten and you just need to staple, cut and perforate...then you have 4-5 ready made raffle books.
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks.
Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function. Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.